Solved

Maximum number of DB_Files exceeded

Posted on 2009-07-14
6
1,166 Views
Last Modified: 2013-12-19
I am trying to create a new schema but I am getting the error "maximum number of DB_Files exceeded". What command do I need to run to change this?

thanks
0
Comment
Question by:Sainai
  • 3
  • 2
6 Comments
 
LVL 2

Expert Comment

by:ysd
ID: 24849757
Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and restart Oracle.
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24851224
sqlplus / as sysdba
SQL> show parameter db_files

SQL> alter system set db_files = 512 scope = spfile;

Restart your instance

SQL> shutdown immediate
SQL> startup open

0
 

Author Comment

by:Sainai
ID: 24851361
Thanks Cola. I have a four nodes on the cluster. Now after I run the later system command do I need to reboot the nodes or just restart oracle on each?
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 40

Accepted Solution

by:
mrjoltcola earned 250 total points
ID: 24851425
Yes. This is a database level parameter, which means it is global to the whole cluster. According to docs either use a shared parameter file, or make sure the parameter is identical across all spfiles.

Restart all instances.
0
 

Author Closing Comment

by:Sainai
ID: 31603250
You da man cola!
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24851791
Glad to help! :) Hope the cluster bounces ok.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Encryption Decryption in Oracle 12 119
scheduler for Procedure in DB with 3 arguments in 10g 7 33
sort a spool into file output in oracle 1 28
pl/sql - query very slow 26 59
Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question