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

From: HARI OM <hari_om_at_hotmail.com>
Date: 1 Mar 2005 15:35:55 -0800
Message-ID: <1109720155.636776.178540@g14g2000cwa.googlegroups.com>

This time I tried different and got working the above issues but when I run my SQL it shows following ERROR:

$export ORACLE_SID=SATURN;
$sqlplus '/ as sysdba'
SQL> startup nomount /// I guess here it uses initsaturn.ora file... SQL> @/sql/test/createtest.sql
CREATE CONTROLFILE SET DATABASE "SATURN" RESETLOGS NOARCHIVELOG *
ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/data/saturn/cfile/control02.ctl'
ORA-27040: skgfrcre: create error, unable to create file

IBM AIX RISC System/6000 Error: 2: No such file or directory

and here is my createtest.sql file...
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE 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
;

As mentioned, I am trying to MOVE existing DB Instance from ONE SERVER to this SERVER. I have MOVED in all the above files to this new server.

My Question is:
when I do "startup nomount" Oracle reads (as expected) INITSATURN.ORA file which is defined as follows...which also has CONTROL File definitions ... BUT there are NO CONTORL FILES on this NEW SERVER since I am creating a new CONTROL FILE... I did not move the CONTROL FILES from the original server to this server,..do I have to move the contorl files as well with the data files....?
My initsaturn.ora file is:

*.aq_tm_processes=1
*.background_dump_dest='/usr/local/oracle/OraHome1/admin/saturn/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/data/saturn/cfile/control02.ctl','/dict/saturn/cfile/control01.ctl','/usr/local/oracle/OraHome1/oradata/saturn/control03.ctl'
*.core_dump_dest='/usr/local/oracle/OraHome1/admin/saturn/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='saturn'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=saturnXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='saturn'
*.java_pool_size=155189248
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=377487360
*.shared_pool_size=157286400
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/usr/local/oracle/OraHome1/admin/saturn/udump'
Received on Tue Mar 01 2005 - 17:35:55 CST