Re: Moving Instance from One Server to Another (ERROR: ORA-01031)

This is because you have not created the directories for the control files. You are creating the control files so you don't need to bring them over from the source server.

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "SATURN" RESETLOGS NOARCHIVELOG     MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 '/r01/saturn/redo01.log' SIZE 100M,   GROUP 2 '/r02/saturn/redo02.log' SIZE 100M, DATAFILE
'/dict/saturn/system01.dbf',
'/data/saturn/undotbs01.dbf',
'/data/saturn/cwmlite01.dbf',
'/dict/saturn/drsys01.dbf',
'/data/saturn/example01.dbf',
'/data/saturn/indx01.dbf',
'/data/saturn/odm01.dbf',
'/data/saturn/tools01.dbf',
'/data/saturn/users01.dbf',
'/data/saturn/xdb01.dbf',
'/data/saturn/abc.dbf',
'/dict/saturn/ABC_TEST.dbf'

CHARACTER SET WE8ISO8859P1
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/saturn/temp01.dbf'

     SIZE 42991616 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; ALTER TABLESPACE PHS3_TEMP ADD TEMPFILE '/data/saturn/PHS3_TEMP.dbf'

     SIZE 115343360 REUSE AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M; Using the above script, please follow these steps.

1. Make sure all directories that oracle user need to access including the data files etc have proper permissions set for Oracle user. This should have been done during installation.
2. Make sure you have initsaturn.ora file in $ORACLE_HOME/dbs directory on the target server.
3. Open initsaturn.ora and check that background_dump_dest, user_dump_dest and paths for each of the three control_files (NOT the control files themselves) exist and have proper permissions set.
4. In the CREATE CONTROLFILE script above... Make sure that all the paths (NOT log files) listed under LOGFILE section exist with proper permissions set. Make sure all the files listed under DATAFILE section exist. Make sure paths (NOT files) for both temp file exist.

$ export ORACLE_SID=SATURN
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @CreateTest.sql

Regards
/Rauf Received on Tue Mar 01 2005 - 18:28:11 CST