ORA-00059: maximum number of DB_FILES exceeded.

[prasad_sure]

Hi All,

I m getting the following error.

ORA-00059: maximum number of DB_FILES exceeded.

As data_files parameter reaches its maximum value. I checked in the Oracle that maximum files was 354. Now the my problem how to change this value in the HP_UX 11.23.Can you suggest me.

How to change this value?

Regards

S.Prasad

[sebastian_sebaraj]

Prasad Sure

you have to recreate the Oracle Control file.

Check the syntax of CREATE CONTROLFILE command in Oracle.

Just changing in ORACLE INIT file alone will not help.

You need System downtime, plan for that.

1.take a backup of control file ( ALTER DATABASE BACKUP CONTROLFILE TO TRACE)

2.shutdown the SAP and ORACLE

3.logon as SYSDBA

3.startup nomount

4.run control.sql

5.alter database open ....

Test it first

Good luck

Edited by: Sebastian Sebaraj on Dec 17, 2008 8:30 PM

[markus_doehr2]

> you have to recreate the Oracle Control file.

??? why that? This is just a parameter to change.

Depending on what is used - pfile or spfile - a change in init<SID>.ora is sufficient or it needs to be done using "alter system.... scope=spfile" and a restart of the database.

Note 398927 - ORA errors because dimensions of parameters are too small

Markus

[Former Member]

hi prasad,

you need to change parameter DB_FILES on init<SID>.ora. You could use BRTOOLS to change it or directly access command : BRSPACE -f dbparam.

You need to restart your Oracle database to activate new parameter.

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

[Former Member]

The answer will depend on your Oracle version; you didn't tell us.

For a start, have a look at SAP notes 8812 and 398927.

hope this helps

[prasad_sure]

Hi,

My oracle version is 9.2.0.8

Regards

S.Prasad

[Former Member]

Sap note 398927 should help:

Then enter the parameter with a correspondingly higher value in the profile and restart Oracle.