| Data Guard Broker CLI [message #159740] |
Tue, 21 February 2006 03:00  |
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 #377248 is a reply to message #377127] |
Mon, 22 December 2008 02:19  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
