Home » RDBMS Server » Server Administration » ORA-00059: maximum number of DB_FILES exceeded (oracle 11g r2 RAC of two nodes with asm on solaris 10)
ORA-00059: maximum number of DB_FILES exceeded [message #567448] Mon, 01 October 2012 06:41 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
i am getting ORA-00059:maximum number of DB_FILES exceeded, so i used following on one node
SQL> alter system set db_files=700 scope=spfile;
system altered.


now do i need to re-bounce(restart) the db.

any guidance, please\

Regards


Re: ORA-00059: maximum number of DB_FILES exceeded [message #567451 is a reply to message #567448] Mon, 01 October 2012 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Generally speaking, if you modify a parameter only in the spfile then you have to restart the database for this new value to be taken into account.

Now, as you can't dynamically modify db_files parameter you have no other choice than to modify it only in the spfile and so you have to restart the database.

Regards
Michel
Re: ORA-00059: maximum number of DB_FILES exceeded [message #567453 is a reply to message #567451] Mon, 01 October 2012 06:58 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
Michel, you are great..stay blessed.thank you...in my case i will use srvctl utility to shutdown db as
./srvctl stop database -d gridx 


i should know this fact what u have just narrated. Sad
Previous Topic: How to see Schema user password in text
Next Topic: Database upgrade and XDB
Goto Forum:
  


Current Time: Tue Mar 19 04:33:25 CDT 2024