-
I Have performed the following steps till now
1, copy all the files to the new Node
2, change the initSID.ora file to reflect the path of the new controlfile, back_dump, core_dump,..etc, etc..
Now the third step as suggested by gsprince is
3, startup mount ; /* make sure ORACLE_SID, ORACLE_HOME, PATH everything is set */
To startup the database i need to set the oracle_sid and create the services which I did as below
C:\>set oracle_sid=testsid6
C:\>oradim80 -new -sid testsid6 -intpwd oracle1 -startmode auto -pfile C:\testsid6\inittestsid6.ora
C:\>oradim80 -startup -sid testsid6 -starttype srvc,inst -usrpwd oracle1 -pfile C:\testsid6\inittestsid6.ora
Now open the server manager and try to mount the database
using the following commands
SVRMGR> connect internal/oracle1
ORA-12203: TNS:unable to connect to destination
SVRMGR> connect internal/oracle1@testsid6
ORA-12154: TNS:could not resolve service name
Please tell me what am I doing wrong here.
I want to restore the whole database on a production system if this test works. If you need I can also post my init.ora file also.
Thanks
Anurag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|