Home » Server Options » Data Guard » can't connect to standby db (Oracle 11R1 , WinXP)
icon5.gif  can't connect to standby db [message #488159] Wed, 05 January 2011 06:19 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8347
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 #488161 is a reply to message #488159] Wed, 05 January 2011 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
env | sort
Check your ORACLE_HOME and ORACLE_SID.

Regards
Michel
Re: can't connect to standby db [message #488162 is a reply to message #488160] Wed, 05 January 2011 06:47 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
yes, I stop at step 9.

It is possible to connect to database using sqlplus when i do not create any instance?

I do not create any instance on the standby server until step 9.

[Updated on: Wed, 05 January 2011 06:50]

Report message to a moderator

Re: can't connect to standby db [message #488166 is a reply to message #488162] Wed, 05 January 2011 06:54 Go to previous messageGo to next message
John Watson
Messages: 8347
Registered: January 2010
Location: Global Village
Senior Member
Quote:
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: can't connect to standby db [message #488171 is a reply to message #488159] Wed, 05 January 2011 07:20 Go to previous message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
thank you reply all.

I make a little mistake on ORACLE_HOME path. I fix it and use oradim utility then i connect standby db via sqlplus
Previous Topic: disaster recovery site
Next Topic: Data Guard failover steps (4 threads merged by bb)
Goto Forum:
  


Current Time: Fri Sep 25 18:21:44 CDT 2020