Re: switchover with DGMGRL
Date: Tue, 2 Jun 2015 13:29:20 -0500
Message-Id: <B731B092-978B-481D-8A9F-8C4F3262886F_at_gmail.com>
lsnrctl status output on standby side?
Sent from my iPad
> On Jun 2, 2015, at 1:19 PM, max scalf <oracle.blog3_at_gmail.com> wrote:
>
> I changed the listener.ora file on standby as below...but still get the error...
>
> on standby...
> [oracle_at_standby admin]$ cat listener.ora
> LISTENER_STANDBY =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1545))
> )
> )
>
> ADR_BASE_LISTENER_TESTDB = /ora_home
>
> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_PRIME=ON # line added by Agent
>
> SID_LIST_LISTENER_STANDBY=
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=prime)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> (SID_DESC=
> (GLOBAL_DBNAME=standby_DGMGRL)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> )
> [oracle_at_standby admin]$
>
>
>
> on primary ...
> [oracle_at_prime admin]$ dgmgrl /
> DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
>
> Copyright (c) 2000, 2009, Oracle. All rights reserved.
>
> Welcome to DGMGRL, type "help" for information.
> Connected.
> DGMGRL> show configuration;
>
> Configuration - prime
>
> Protection Mode: MaxPerformance
> Databases:
> prime - Primary database
> standby - Physical standby database
>
> Fast-Start Failover: DISABLED
>
> Configuration Status:
> SUCCESS
>
> DGMGRL> switchover to standby;
> Performing switchover NOW, please wait...
> Operation requires a connection to instance "prime" on database "standby"
> Connecting to instance "prime"...
> Unable to connect to database
> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
>
> Failed.
> Warning: You are no longer connected to ORACLE.
>
> connect to instance "prime" of database "standby"
>
> DGMGRL>
>
>
>> On Tue, Jun 2, 2015 at 1:16 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote: >> On the standby, the static dgmgrl entry should be db_unique_name_dgmgrl. Which should be standby_dgmgrl it looks like. >> >> Sent from my iPad >> >>> On Jun 2, 2015, at 1:04 PM, max scalf <oracle.blog3_at_gmail.com> wrote: >>> >>> Hello all, >>> >>> I am trying to do a switchover for my test setup for DG, it work just fine if i do it with SQLPLUS but with data guard broker it does not work. >>> >>> primary host is called prime, secondary host is called standby and DB_name is PRIME while DB_UNIQUE_NAME is PRIME and STANDBY >>> >>> here is what i get when i do switchover with data guard broker. I have also pasted my listener and tns file below for both prime and standby. Would this be related to the parameter "StaticConnectIdentifier" ?? >>> >>> >>> [oracle_at_prime admin]$ dgmgrl / >>> DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production >>> >>> Copyright (c) 2000, 2009, Oracle. All rights reserved. >>> >>> Welcome to DGMGRL, type "help" for information. >>> Connected. >>> DGMGRL> show configuration; >>> >>> Configuration - prime >>> >>> Protection Mode: MaxPerformance >>> Databases: >>> prime - Primary database >>> standby - Physical standby database >>> >>> Fast-Start Failover: DISABLED >>> >>> Configuration Status: >>> SUCCESS >>> >>> DGMGRL> swithover to standby; >>> Unrecognized command "swithover", try "help" >>> DGMGRL> switchover to standby; >>> Performing switchover NOW, please wait... >>> Operation requires a connection to instance "prime" on database "standby" >>> Connecting to instance "prime"... >>> Unable to connect to database >>> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor >>> >>> Failed. >>> Warning: You are no longer connected to ORACLE. >>> >>> connect to instance "prime" of database "standby" >>> >>> DGMGRL> >>> DGMGRL> show database verbose prime; >>> >>> Database - prime >>> >>> Role: PRIMARY >>> Intended State: TRANSPORT-ON >>> Instance(s): >>> prime >>> >>> Properties: >>> DGConnectIdentifier = 'prime' >>> ObserverConnectIdentifier = '' >>> LogXptMode = 'ASYNC' >>> DelayMins = '0' >>> Binding = 'optional' >>> MaxFailure = '0' >>> MaxConnections = '1' >>> ReopenSecs = '300' >>> NetTimeout = '30' >>> RedoCompression = 'DISABLE' >>> LogShipping = 'ON' >>> PreferredApplyInstance = '' >>> ApplyInstanceTimeout = '0' >>> ApplyParallel = 'AUTO' >>> StandbyFileManagement = 'AUTO' >>> ArchiveLagTarget = '0' >>> LogArchiveMaxProcesses = '4' >>> LogArchiveMinSucceedDest = '1' >>> DbFileNameConvert = '' >>> LogFileNameConvert = '' >>> FastStartFailoverTarget = '' >>> InconsistentProperties = '(monitor)' >>> InconsistentLogXptProps = '(monitor)' >>> SendQEntries = '(monitor)' >>> LogXptStatus = '(monitor)' >>> RecvQEntries = '(monitor)' >>> ApplyLagThreshold = '0' >>> TransportLagThreshold = '0' >>> TransportDisconnectedThreshold = '30' >>> SidName = 'prime' >>> StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prime)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prime_DGMGRL)(INSTANCE_NAME=prime)(SERVER=DEDICATED)))' >>> StandbyArchiveLocation = '/data/oradata/prime/arch' >>> AlternateLocation = '' >>> LogArchiveTrace = '0' >>> LogArchiveFormat = '%t_%s_%r.dbf' >>> TopWaitEvents = '(monitor)' >>> >>> Database Status: >>> SUCCESS >>> >>> DGMGRL> >>> DGMGRL> >>> DGMGRL> show database verbose standby; >>> >>> Database - standby >>> >>> Role: PHYSICAL STANDBY >>> Intended State: APPLY-ON >>> Transport Lag: 0 seconds (computed 0 seconds ago) >>> Apply Lag: 0 seconds (computed 0 seconds ago) >>> Apply Rate: 285.00 KByte/s >>> Real Time Query: OFF >>> Instance(s): >>> prime >>> >>> Properties: >>> DGConnectIdentifier = 'standby' >>> ObserverConnectIdentifier = '' >>> LogXptMode = 'ASYNC' >>> DelayMins = '0' >>> Binding = 'optional' >>> MaxFailure = '0' >>> MaxConnections = '1' >>> ReopenSecs = '300' >>> NetTimeout = '30' >>> RedoCompression = 'DISABLE' >>> LogShipping = 'ON' >>> PreferredApplyInstance = '' >>> ApplyInstanceTimeout = '0' >>> ApplyParallel = 'AUTO' >>> StandbyFileManagement = 'AUTO' >>> ArchiveLagTarget = '0' >>> LogArchiveMaxProcesses = '4' >>> LogArchiveMinSucceedDest = '1' >>> DbFileNameConvert = '' >>> LogFileNameConvert = '/data/oradata/prime/redoA/, /data/oradata/prime/redoA/, /data/oradata/prime/redoB/, /data/oradata/prime/redoB/, /data/oradata/prime/standbylog, /data/oradata/prime/standbylog' >>> FastStartFailoverTarget = '' >>> InconsistentProperties = '(monitor)' >>> InconsistentLogXptProps = '(monitor)' >>> SendQEntries = '(monitor)' >>> LogXptStatus = '(monitor)' >>> RecvQEntries = '(monitor)' >>> ApplyLagThreshold = '0' >>> TransportLagThreshold = '0' >>> TransportDisconnectedThreshold = '30' >>> SidName = 'prime' >>> StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=standby_DGMGRL)(INSTANCE_NAME=prime)(SERVER=DEDICATED)))' >>> StandbyArchiveLocation = '/data/oradata/prime/arch' >>> AlternateLocation = '' >>> LogArchiveTrace = '0' >>> LogArchiveFormat = '%t_%s_%r.dbf' >>> TopWaitEvents = '(monitor)' >>> >>> Database Status: >>> SUCCESS >>> >>> DGMGRL> >>> >>> >>> >>> here is the TNS and listener file for primary >>> >>> [oracle_at_prime ~]$ cd /ora_home/app/product/11.2/dbhome/network/admin/ >>> [oracle_at_prime admin]$ cat listener.ora >>> LISTENER_PRIME = >>> (DESCRIPTION_LIST = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540)) >>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1540)) >>> ) >>> ) >>> >>> ADR_BASE_LISTENER_TESTDB = /ora_home >>> >>> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_PRIME=ON # line added by Agent >>> >>> SID_LIST_LISTENER_PRIME= >>> (SID_LIST= >>> (SID_DESC= >>> (GLOBAL_DBNAME=prime) >>> (SID_NAME=prime) >>> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome) >>> ) >>> (SID_DESC= >>> (GLOBAL_DBNAME=prime_DGMGRL) >>> (SID_NAME=prime) >>> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome) >>> ) >>> ) >>> [oracle_at_prime admin]$ cat tnsnames.ora >>> LISTENER_PRIME = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540)) >>> >>> >>> PRIME = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540)) >>> (CONNECT_DATA = >>> (SERVER = DEDICATED) >>> (SERVICE_NAME = prime) >>> ) >>> ) >>> >>> # Note service_name = prime, as the DB is still going to be called prime >>> # it is only the db_unique_name that standby >>> STANDBY = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545)) >>> (CONNECT_DATA = >>> (SERVER = DEDICATED) >>> (SERVICE_NAME = prime) >>> ) >>> ) >>> >>> [oracle_at_prime admin]$ >>> >>> >>> >>> >>> Here is the listener and tns for standby server... >>> >>> [oracle_at_standby ~]$ cd /ora_home/app/product/11.2/dbhome/network/admin/ >>> [oracle_at_standby admin]$ cat listener.ora >>> LISTENER_STANDBY = >>> (DESCRIPTION_LIST = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545)) >>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1545)) >>> ) >>> ) >>> >>> ADR_BASE_LISTENER_TESTDB = /ora_home >>> >>> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_PRIME=ON # line added by Agent >>> >>> SID_LIST_LISTENER_STANDBY= >>> (SID_LIST= >>> (SID_DESC= >>> (GLOBAL_DBNAME=prime) >>> (SID_NAME=prime) >>> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome) >>> ) >>> (SID_DESC= >>> (GLOBAL_DBNAME=prime_DGMGRL) >>> (SID_NAME=prime) >>> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome) >>> ) >>> ) >>> [oracle_at_standby admin]$ >>> [oracle_at_standby admin]$ cat tnsnames.ora >>> LISTENER_STANDBY = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545)) >>> >>> >>> PRIME = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540)) >>> (CONNECT_DATA = >>> (SERVER = DEDICATED) >>> (SERVICE_NAME = prime) >>> ) >>> ) >>> >>> # Note service_name = prime, as the DB is still going to be called prime >>> # it is only the db_unique_name that standby >>> STANDBY = >>> (DESCRIPTION = >>> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545)) >>> (CONNECT_DATA = >>> (SERVER = DEDICATED) >>> (SERVICE_NAME = prime) >>> ) >>> ) >>> >>> [oracle_at_standby admin]$ >>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 02 2015 - 20:29:20 CEST