Oracle Database Discussions

HI,

oracle version:oracle 8i(8.1.7.0.0)

os : sun solaris 5.9

SQL> alter tablespace PIN00 add datafile '/oracle16/oradata/pindb/pin111.dbf' size 4096m;
alter tablespace PIN00 add datafile '/oracle16/oradata/pindb/pin111.dbf' size 4096m
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded


and if i do:
sql>alter database backup controlfile to trace;



in user dump path:

|
|

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PINDB" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 8
MAXLOGHISTORY 49655
LOGFILE

|
|
|

Thu Nov 27 17:23:47 2008
ARC0: Beginning to archive log# 7 seq# 1834141
ARC0: Completed archiving log# 7 seq# 1834141
Thu Nov 27 17:34:52 2008
alter tablespace PIN00 add datafile '/oracle16/oradata/pindb/pin111.dbf' size 4096m
Thu Nov 27 17:38:09 2008
DB_FILES[8] exceeded (fno=201 kcfdpk=200)
ORA-59 signalled during: alter tablespace PIN00 add datafile '/oracle16/ora...
Thu Nov 27 18:07:14 2008
Thread 1 advanced to log sequence 1834143
Thu Nov 27 18:07:14 2008
ARC0: Beginning to archive log# 9 seq# 1834142

in alert log file:




as of now 200 datafile(normal datafile and index datafile)

if i add 201 file it is showing the error eventhough in create database command MAXDATAFILES 500


but if i do
SQL> show parameter spfile
SQL>

so my database is running in pfile but in init parameter i could not see this value

bash-2.05$ grep db_file "initpindb.ora"
db_file_multiblock_read_count = 8
dbfile_noncontig_mblock_read_count=1


so this db_files where it is configured. but in database level it is showing the value.

SQL> show parameter db_files

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
db_files integer 200


Thanks

Prakash

Edited by: user612485 on Nov 27, 2008 5:01 AM