Solved

Oracle 10g - ORA-00059

Posted on 2011-09-05
3
784 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
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

730 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