Re: Help for message ORA-01118.

It may be possible to solve your problem without re-creating the database by modifying the control file.

To do this do the following;

1.) Issue the command;

      alter database backup controlfile to trace;

This will create a file <SID>_ora_<PID>.trc in your user_dump_dest directory (default $ORACLE_HOME/rdbms/log)

2.) Edit the file above removing all line prior to STARTUP NOMOUNT and also increasing the number following MAXDATAFILES (maximum is 255) Save as recreate_ctlfile.sql (for example)

3.) Check the DB_FILES parameter in init<SID>.ora (make the number the same as above)

4.) Shutdown and backup your database.

5.) Run SQLDBA (or SVRMGR depending on your version of Oracle) and execute the file created at step 2.

Hope this works,

Ian Received on Mon Oct 06 1997 - 00:00:00 CDT