Q) Changing Max # of Datafiles... (But it does not work...)

From: <ksjune_at_sys.gsnu.ac.kr>
Date: 1997/12/03
Message-ID: <3484e1bd.171709416@news.snu.ac.kr>#1/1

Hi !!! Everyone....
I'd like to change the number of maxdatafiles. so I run below statement and the it does work well....
note : Oracle 7.3.2 on Windows NT 4.0

svrmgrl> startup
svrmgrl> alter database backup controfile to trace;

This statement create the trace_file in '%RDBMS73%\trace' directory like this. ( I've deleted the comment line) If you use the UNIX System, this file will be created in 'udump' directory

---

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORACLE" NORESETLOGS ARCHIVELOG     MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1600
LOGFILE

  GROUP 1 'D:\ORANT\DATABASE\REDO\GRP1ORCL.LOG'  SIZE 2M,
  GROUP 2 'D:\ORANT\DATABASE\REDO\GRP2ORCL.LOG'  SIZE 2M,
  GROUP 3 'D:\ORANT\DATABASE\REDO\GRP3ORCL.LOG'  SIZE 2M

DATAFILE
'D:\ORANT\DATABASE\SYS_ORCL.DBF',
'D:\ORANT\DATABASE\USR_ORCL.DBF',
'D:\ORANT\DATABASE\RBS_ORCL.DBF',
'D:\ORANT\DATABASE\TMP_ORCL.DBF'

;

RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN;

---

you will find the number 32 at line5, MAXDATAFILES section. So I've changed this number to 62, and changed the number to 50 at db_files section in initSID.ora
Next, I've shutdown Oracle system, and restart above scripts in SVRMGRL.
But it does not work. Error Message like this

ORA-01503: CREATE CONTROLFILE failed
ORA-00213: cannot reuse control file 'D:\ORANT\DATABASE\ctl1orcl.ora'; old file size 310, 358 required

Please Help....
Thanks in Advance....

ksjune_at_sys.gsnu.ac.kr Received on Wed Dec 03 1997 - 00:00:00 CST