We are currently running our SAP R/3 4.7 system on Oracle 9i database. Oracle 188.8.131.52 is the exact version. We haven’t change any parameter on our control file.
The main problem is we need to set our number of datafiles on Oracle
Currently we have DB_FILES set to 768 on Oracle parameter file. We need to set this to higher number (may be around 1024). I ask this question to SAP SDN forum and Stefan said I need to check MAXDATAFILES on our control file. So I need to check my control file.
I log on to my database system and try to dump our control file to trace file using this SQL command :
SQL> alter database backup controlfile to trace;
I check my dump trace location.
SQL> show parameter user_dump_dest
NAME TYPE VALUE
———————————— ———– ——————————
user_dump_dest string /oracle/[SID]/saptrace/usertrace
Than I try to get my files and read it using my text editor.
This is some lines on my trace file.
# only if the current version of all online logs are available.
CREATE CONTROLFILE REUSE DATABASE “[SID]” NORESETLOGS FORCE LOGGING ARCHIVELOG
— SET STANDBY TO MAXIMIZE PERFORMANCE
From MAXDATAFILES line, I get information about my maximum datafiles I can set, 784. So I cannot set my DB_FILES parameter to 1024 yet. I need to adjust and re-create my control file.
I need to shutdown, backup and re-create it. I’ll explained on mye next posting.