Database - RAC/Scalability (MOSC)

MOSC Banner

ORA-00059 Maximum Number Of DB_FILES Exceeded

edited Aug 6, 2014 11:43PM in Database - RAC/Scalability (MOSC) 4 commentsAnswered ✓

Dear colleague,

I got error message as subject while adding datafile.

my environment is IBM AIX with RAC 2 nodes 10.2.0.4. spfile stored on diskgroup, shared to both node 1 and node 2.

1) my question is, can I do rolling bounce while changing db_files parameter as command below,  ?

alter system set db_files=x scope=spfile;

2) can I apply below command to my db, do I need to restart both instances ?

alter system set db_files=x scope=spfile sid="*";

Regards,

Andes

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center