Home » Server Options » Data Guard » Data Guard Broker CLI
Data Guard Broker CLI [message #159740] Tue, 21 February 2006 03:00 Go to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,
I have a data gurad configuration where switchover works fine when done manually. But when dgmgrl is used it gives the
Quote:


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor



error and i have to manually restart the databases after the switchover. Below is the full output of this switchover process

Quote:

[oracle@racserver2 admin]$ dgmgrl
DGMGRL for Linux: Version 10.2.0.1.0 - Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/tbxdb
Connected.

DGMGRL> show configuration;

Configuration
Name: TEST
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
tbx - Physical standby database
tbx2 - Primary database

Current status for "TEST":
SUCCESS



DGMGRL> switchover to "tbx";
Performing switchover NOW, please wait...

Operation requires shutdown of instance "tbx" on database "tbx2"
Shutting down instance "tbx"...
ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.
Operation requires shutdown of instance "tbx1" on database "tbx"
Shutting down instance "tbx1"...
ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.
Operation requires startup of instance "tbx" on database "tbx2"
Starting instance "tbx"...

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 "tbx"
You must start instance "tbx" manually
Operation requires startup of instance "tbx1" on database "tbx"
You must start instance "tbx1" manually
Switchover succeeded, new primary is "tbx"
DGMGRL> quit




on my listener.ora and tnsnames.ora files i have the following entries.

tnsnames.ora
Quote:


TBX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racserver2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tbx.codegen.net)
)
)


STBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = racserver1.tbx.net)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tbx.codegen.net)
)
)






listener.ora
Quote:


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oraclebase/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = tbx)
(ORACLE_HOME = /oraclebase/app/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = tbx.codegen.net)
)
)




How do i make the switchover function smoothly?
thank you for any help you can give
Re: Data Guard Broker CLI [message #376802 is a reply to message #159740] Thu, 18 December 2008 10:27 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

I am facing the same problem please reply me if you sorted out this issue.
with regds
rajnish
Re: Data Guard Broker CLI [message #377127 is a reply to message #376802] Sat, 20 December 2008 10:00 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Read metalink note 308943.1

or

put DGMGRL on global dbname

GLOBAL_DBNAME = xxxx_DGMGRL.yyyyyy.zzz
Re: Data Guard Broker CLI [message #377248 is a reply to message #377127] Mon, 22 December 2008 02:19 Go to previous message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear Deep
Really it's appriciate to give response. I have done my all effort to resolve out this issue but still i am in dark. This is my config for netca. kindly help me out.
listener.ora (on Primary)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = orcl_DGMGRL)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
)
)

tnsnames.ora (on primary)
DBSTANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)

DBPRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
RCATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

listener.ora(standby)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = orcl_DGMGRL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
)
)

tnsmames.ora(standby)
DBSTANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
DBPRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
RCATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


Thanks a lot
with regds
rajnish
Previous Topic: Data Guard Broker
Next Topic: Problem while recovering standby db
Goto Forum:
  


Current Time: Thu Mar 28 07:59:35 CDT 2024