Home » Server Options » Data Guard » Urgent..Error on Switchover Physical Standby DB..=( (10gR2)
icon5.gif   Urgent..Error on Switchover Physical Standby DB..=( [message #356576] Fri, 31 October 2008 04:45 Go to next message
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..^^
Re: Urgent..Error on Switchover Physical Standby DB..=( [message #356667 is a reply to message #356576] Fri, 31 October 2008 16:21 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Check your firewall setting. I think listener port is blocked.

Babu
Previous Topic: fal server
Next Topic: Export schema from Physical Standby Database
Goto Forum:
  


Current Time: Thu Mar 28 09:34:30 CDT 2024