Solved

Oracle 10g - ORA-00059

Posted on 2011-09-05
3
800 Views
Last Modified: 2012-05-12
Hi,

Error while trying to expand a tablespace.
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

I have the following procedure.:
 
Logon in SQLplus as system user and perform the following commands
   Sqlplus system/manager
SQL> sho user
SYS
SQL> select * from v$version;
 BANNER
  Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
  PL/SQL Release 10.2.0.2.0 - Production
  CORE 10.2.0.2.0 Production
  TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
  NLSRTL Version 10.2.0.2.0 – Production
  SQL> sho parameter db_files
               NAME TYPE VALUE
               ----------- db_files integer 200
  SQL> alter system set db_files = 256 scope = spfile;

Is it how it supposed to be done?
0
Comment
Question by:joaotelles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Docteur_Z earned 500 total points
ID: 36485075
It should be OK, but you have to bounce the DB
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams049.htm#REFRN10039 says :
If you increase the value of DB_FILES, then you must shut down and restart all instances accessing the database before the new value can take effect. If you have a primary and standby database, then they should have the same value for this parameter.
0
 

Author Comment

by:joaotelles
ID: 36485087
Tks for the reply.. I will restart it.
0
 

Author Closing Comment

by:joaotelles
ID: 36485089
tks
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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 Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

624 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