OraFAQ Forum: Server Administration » ORA-00059: maximum number of DB

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00059: maximum number of DB_FILES exceeded [message #567448]

Mon, 01 October 2012 06:41

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

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #567451 is a reply to message #567448]

Mon, 01 October 2012 06:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #567453 is a reply to message #567451]

Mon, 01 October 2012 06:58

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

Report message to a moderator

Previous Topic:	How to see Schema user password in text
Next Topic:	Database upgrade and XDB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:36:30 CST 2024