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

HARI OM wrote:
> 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;
> ------------------------------------------------------------

Assuming you have done the obvious i.e. Install Oracle on Mulan and have standard Oracle user and dba group etc.

What happens if you do,
$ export ORACLE_SID=SATURN
$ sqlplus "/ as sysdba"

Regards
/Rauf Received on Mon Feb 28 2005 - 17:11:04 CST