data file add terminated

[Former Member]

Dear all

when i add datafile termineted with the following error

please guide

when i increase the db_file-500

in this situation when i shutdown the database ,

dabase will be insonsistant or consistant

log are the foolowings

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2008-03-25 09.47.14

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2008-03-25 09.47.14

BR0370I Directory D:\oracle\PRD\sapreorg\sdxoacxi created

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR0319I Control file copy created: D:\oracle\PRD\sapreorg\sdxoacxi\cntrlPRD.old 17948672

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR0370I Directory D:\oracle\PRD\sapdata4\prd_236 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_237 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_238 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_239 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_240 created

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR1088I Extending tablespace PSAPPRD...

BR0280I BRSPACE time stamp: 2008-03-25 09.56.30

BR0301E SQL error -59 at location BrSqlExecute-1

ORA-00059: maximum number of DB_FILES exceeded

BR1017E Execution of SQL statement 'alter tablespace PSAPPRD add datafile 'D:\oracle\PRD\sapdata4\prd_236\prd.data236' size 2048M autoextend off, 'D:\oracle\PRD\sapdata4\prd_237\prd.data237' size 2048M autoextend off, 'D:\oracle\PRD\sapdata4\prd_238\prd.d

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2008-03-25 09.56.30

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

thanks

venkat

[Former Member · Accepted solution]

Hi,

Venkat, in the init<SID>.ora a parameter DB_FILES is set which has the values for the maximum number of data files that can be added.

check the following SAP Notes

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

SAP Note 8812 - Increasing max. number of data files in Oracle

Regards,

Suhas

[Former Member]

Hi. Read the Note 398927 - ORA errors because dimensions of parameters are too small.

Regards.