Solved

Oracle 10g - ORA-00059

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now