Performing Switchover with DG Broker Overview: A switchover is a role reversal between the primary database and one of its standby databases. A switchover operation guarantees no data loss. This is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role and the standby database transitions to the. Re: How to switchover using DGMGRL, broker with example remoteloginpasswordfile is set to EXCLUSIVE and passwordfile is correct too. I found out that I'm able to connect using connect string when the DB is up but when the DB is down, I'm getting ORA-01031: insufficient privileges. I think this is precisely why switchover fails to start the.
Final updated on September 04, 2018
Applies to:
Oracle Database - Organization Model - Version 10.2.0.5 to 11.2.0.3 Launch 10.2 to 11.2Information in this record pertains to any system.
Signs and symptoms
Information Guard configuration using purses to connect to the database passwordless.
PRIMARY : Holiday to orlando
STANDBY : Arkansas
Wallet was setup properly and both sqIplus and dgmgrl contacts are effective, however when trying to carry out a switchover making use of the DG agent it does not work out with ORA-1031 when the agent attempts to connect :
dgmgrl /@0RLANDODG
DGMGRLgt; switchovér to 'Las vegas'
Performing switchover Today, please wait around.
New primary data source 'Ohio' is usually opening.
Procedure requires shutdown of instance 'Holiday to orlando1' on database 'ORLANDO'
Turning down instance '0RLANDO1'.
ORA-01031: insufficient privileges
Caution: You are no more linked to ORACLE.
Make sure you full the following steps to complete switchover:
shut down instance 'Holiday to orlando1' of data source 'ORLANDO'
start up and attach instance 'ORLANDO1' of data source 'Holiday to orlando'
PRIMARY : Holiday to orlando
STANDBY : Arkansas
Wallet was setup properly and both sqIplus and dgmgrl contacts are effective, however when trying to carry out a switchover making use of the DG agent it does not work out with ORA-1031 when the agent attempts to connect :
dgmgrl /@0RLANDODG
DGMGRLgt; switchovér to 'Las vegas'
Performing switchover Today, please wait around.
New primary data source 'Ohio' is usually opening.
Procedure requires shutdown of instance 'Holiday to orlando1' on database 'ORLANDO'
Turning down instance '0RLANDO1'.
ORA-01031: insufficient privileges
Caution: You are no more linked to ORACLE.
Make sure you full the following steps to complete switchover:
shut down instance 'Holiday to orlando1' of data source 'ORLANDO'
start up and attach instance 'ORLANDO1' of data source 'Holiday to orlando'
Adjustments
There are no extra changes some other than the reality that wallets are used, and they are configured correctly.
The credentials for the major and standby directories are developed (added to the budget).
Wallet area: /home/oracle/wallet
mkdir -p /house/oracle/waIlet
mkstore -wrI /home/oracle/wallet/ -produce
Enter billfold security password: delightful1
mkstore -wrl /house/oracle/wallet/ -createCredentiaI MIAMIDG sys changeoninstaIl
mkstore -wrI /house/oracle/wallet/ -createCredential ORLANDODG sys changeoninstall
Wallet information is usually shown correctly :
mkstore -wrl /house/oracle/wallet -viewEntry oracle.security.customer.connectstring1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.protection.customer.username1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.safety.client.password1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.protection.client.connectstring2
mkstore -wrl /home/oracle/wallet -viewEntry oracle.safety.client.username2
mkstore -wrl /house/oracle/wallet -viewEntry oracle.safety.client.password2
Oracle Internet config files are furthermore setup properly:
sqlnet.óra
NAMES.DIRECT0RYPATH= (TNSNAMES, EZC0NNECT)
WALLETL0CATION =
(SOURCE=(METHOD=FILE)
(METHODDATA=(DIRECTORY=/house/oracle/waIlet/))
)
SQLNET.WALLET0VERRIDE = Real
listener.ora
SIDLISTLISTENER =
(SIDLIST =
(SIDDESC =
(GLOBALDBNAME = MIAMIdgmgrl)
(ORACLEHOME = /u01/app/oracle/product/11.2.0)
(SIDNAME = MIA1)
)
(SIDDESC =
(GLOBALDBNAME = ORLANDOdgmgrl)
(ORACLEHOME = /u01/app/oracle/item/11.2.0)
(SIDNAME = ORL1)
)
)
tnsnames.ora
Ohio =
(DESCRIPTION =
(ADDRESS = (Process = TCP)(HOST = miami-scan)(PORT = 1521))
(CONNECTDATA = (SERVER = DEDICATED)(SERVICENAME = Las vegas))
)
Holiday to orlando =
(DESCRIPTION =
(ADDRESS = (Process = TCP)(Sponsor = orlando-scan)(Interface = 1521))
(CONNECTDATA = (Machine = Devoted) (SERVICENAME = Holiday to orlando))
)
MlAMIDG =
(DESCRIPTI0N =
(ADDRESS = (Process = TCP)(Sponsor = miamihost)(PORT = 1521))
(CONNECTDATA = (SERVER = Devoted) (SERVICENAME = Las vegas))
)
0RLANDODG =
(DESCRIPTI0N =
(ADDRESS = (PROTOCOL = TCP)(Web host = orlandohost)(Slot = 1521))
(CONNECTDATA = (SERVER = DEDICATED) (SERVICENAME = Holiday to orlando))
)
Screening passwordless connection using wallets and handbags:
sqlplus /@MlAMIDG as sysdbá
sqlplus /@0RLANDODG as sysdbá
dgmgrl /@MlAMIDG
dgmgrl /@0RLANDODG
The credentials for the major and standby directories are developed (added to the budget).
Wallet area: /home/oracle/wallet
mkdir -p /house/oracle/waIlet
mkstore -wrI /home/oracle/wallet/ -produce
Enter billfold security password: delightful1
mkstore -wrl /house/oracle/wallet/ -createCredentiaI MIAMIDG sys changeoninstaIl
mkstore -wrI /house/oracle/wallet/ -createCredential ORLANDODG sys changeoninstall
Wallet information is usually shown correctly :
mkstore -wrl /house/oracle/wallet -viewEntry oracle.security.customer.connectstring1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.protection.customer.username1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.safety.client.password1
mkstore -wrl /home/oracle/wallet -viewEntry oracle.protection.client.connectstring2
mkstore -wrl /home/oracle/wallet -viewEntry oracle.safety.client.username2
mkstore -wrl /house/oracle/wallet -viewEntry oracle.safety.client.password2
Oracle Internet config files are furthermore setup properly:
sqlnet.óra
NAMES.DIRECT0RYPATH= (TNSNAMES, EZC0NNECT)
WALLETL0CATION =
(SOURCE=(METHOD=FILE)
(METHODDATA=(DIRECTORY=/house/oracle/waIlet/))
)
SQLNET.WALLET0VERRIDE = Real
listener.ora
SIDLISTLISTENER =
(SIDLIST =
(SIDDESC =
(GLOBALDBNAME = MIAMIdgmgrl)
(ORACLEHOME = /u01/app/oracle/product/11.2.0)
(SIDNAME = MIA1)
)
(SIDDESC =
(GLOBALDBNAME = ORLANDOdgmgrl)
(ORACLEHOME = /u01/app/oracle/item/11.2.0)
(SIDNAME = ORL1)
)
)
tnsnames.ora
Ohio =
(DESCRIPTION =
(ADDRESS = (Process = TCP)(HOST = miami-scan)(PORT = 1521))
(CONNECTDATA = (SERVER = DEDICATED)(SERVICENAME = Las vegas))
)
Holiday to orlando =
(DESCRIPTION =
(ADDRESS = (Process = TCP)(Sponsor = orlando-scan)(Interface = 1521))
(CONNECTDATA = (Machine = Devoted) (SERVICENAME = Holiday to orlando))
)
MlAMIDG =
(DESCRIPTI0N =
(ADDRESS = (Process = TCP)(Sponsor = miamihost)(PORT = 1521))
(CONNECTDATA = (SERVER = Devoted) (SERVICENAME = Las vegas))
)
0RLANDODG =
(DESCRIPTI0N =
(ADDRESS = (PROTOCOL = TCP)(Web host = orlandohost)(Slot = 1521))
(CONNECTDATA = (SERVER = DEDICATED) (SERVICENAME = Holiday to orlando))
)
Screening passwordless connection using wallets and handbags:
sqlplus /@MlAMIDG as sysdbá
sqlplus /@0RLANDODG as sysdbá
dgmgrl /@MlAMIDG
dgmgrl /@0RLANDODG
Trigger
To see full details, indication in with yóur My Oracle Assistance accounts. |
Don't possess a My Oracle Support account? Click to get began! |
Signs and symptoms |
Modifications |
Trigger |
Answer |
you do your dataguard set up and everything appears to be configured appropriate. the agent configuration is certainly good, you can mix connect to éach instance as sysdbá but when carrying out a switchover through dgmgrl you get:
… and you also offered the sys password while linking with dgmgrI:
whát proceeded to go wrong ? just acquired this situation and it took me an hour to shape it out: the sys security password contained special character types. what a …. maybe this is mentioned someplace in the documents.
a fast way to check it:
if:
works, but the exact same connect without the estimates does not:
… try out to modify the password to anything without unique personas and you will succeed ( remember to change the security password for the password file, as well ) ….
Ads