OraFAQ Forum: Data Guard » Urgent..Error on Switchover Physical Standby DB..=(

Home » Server Options » Data Guard » Urgent..Error on Switchover Physical Standby DB..=( (10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent..Error on Switchover Physical Standby DB..=( [message #356576]

Fri, 31 October 2008 04:45

qqiey
Messages: 1
Registered: October 2008
Location: Jakarta

Junior Member

Hello All gurus...

Sorry for bothering..=)

Im Rizky...students from indonesia..

Right now, im doing my final assignments about analyzing data protection mode on physical standby db..

But im having problems on that..
please help me..

Any inputs or response will be a great help for me..
^^

My situation is:

I already done the standby database system with real time processing..
Data Guard broker also had been configured n ran well..
But whenever i want to switchover primary db to standby db (and also the reverse), i found this problem..

=========================================
DGMGRL> switchover to 'orclQQ';
Performing switchover NOW, please wait...
Operation requires shutdown of instance "orclta" on database "orclTA"
Shutting down instance "orclta"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "orclta" on database "orclQQ"
Shutting down instance "orclta"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "orclta" on database "orclTA"
Starting instance "orclta"...
ORACLE instance started.
Database mounted.
Operation requires startup of instance "orclta" on database "orclQQ"
Starting instance "orclta"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "orclta"
You must start instance "orclta" manually
Switchover succeeded, new primary is "orclQQ"
===========================================

Here's my listener.ora
==============================================
SID_LIST_LISTENER =
(SID_LIST =

(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)

(SID_DESC =
(SID_NAME = orclTA)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = orclTA)
)

(SID_DESC =
(SID_NAME = orclTA)
(GLOBAL_DBNAME = orclTA_DGMRL)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.14.13.17)(PORT = 1521))
)
)
=======================================================

Can anyone help me..=)
Thx for your attention before..^^

Report message to a moderator