 can't connect to standby db [message #488159] |
Wed, 05 January 2011 06:19  |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
hi all,
I'm trying to prepare data guard operation on the virtual machines.
1. I have install Oracle database without start up database on the standby server.
2. I try to connect this db by sysdba, but failed!
Quote:
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
I'm using instruction below:
http://wiki.oracle.com/page/11gR2+Data+Guard+Setup+project+Part5
Why I can't login to database?
please help me.
|
|
|
|
| Re: can't connect to standby db [message #488160 is a reply to message #488159] |
Wed, 05 January 2011 06:32  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Would I be correct in assuming that you are stuck at step 9? If sdo, your problem is that you are using Windows, and your instructions are for Linux. You'll need to create the Windows service with the oradim utility.
|
|
|
|
|
|
|
|
|
|
| Re: can't connect to standby db [message #488167 is a reply to message #488161] |
Wed, 05 January 2011 06:56 |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
I'm working on the windows xp.
I'm using SET comment and define oracle_home and oracle_sid, but failed.
c:\>set
ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1
ORACLE_SID=ms112dgs
|
|
|
|
| Re: can't connect to standby db [message #488168 is a reply to message #488167] |
Wed, 05 January 2011 07:03 |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
I'm using oradim tool on windows, but appear error message.
what is wrong I did?
C:\>oradim -NEW -SID ms112dgs -startmode manual
Message 51 not found; No message file for product=RDBMS, facility=ORADIM
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
