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

From: HARI OM <hari_om_at_hotmail.com>
Date: 28 Feb 2005 14:54:45 -0800
Message-ID: <1109631285.411624.188350@f14g2000cwb.googlegroups.com>

I am using IBM AIX 5.1L and ORACLE 9.2.0.2.

I have a Server named "tintin" and an instance running on it called "saturn".
I haver another identical Server named "mulan" and would like to MOVE this instance over from "tintin" server to "mulan" server. So, this is what I did:

On my TINTIN Server, I do:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; So, this one creates a Control trace file which is stored under UDUMP directory. I EDIT that file according to directory structure of my MULAN Server. I save that file. I then Add a ENTRY of SATURN instance on my TNSNAMES.ORA and LISTENER.ORA files (on MULAN Server).

I then go to my MULAN's SQLPLUS and do : SQL> conn sys/saturn@**** as sysdba on which I get following ERROR:

---

ERROR: ORA-01031: insufficient privileges

---

I then use ORAPWD utility to create a password but still get the same. Can anyone point or give any hints on the above?

Here is what control Trace file I have (from my TINTIN Server) which I would like to RUN on MULAN Server BUT it does NOT allow me to log in...:

---

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "SATURN" NORESETLOGS 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/PHS3.dbf',
'/dict/saturn/SERPH_TEST.dbf'

CHARACTER SET WE8ISO8859P1
;

RECOVER DATABASE ALTER DATABASE OPEN; 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;

---

Received on Mon Feb 28 2005 - 16:54:45 CST