tag:blogger.com,1999:blog-2571414265392841828.post5850341337541789132..comments2023-07-11T01:54:39.701-07:00Comments on OracleNext - Solution to your Oracle problems: ORA-01031 insufficient privileges during switchover using DGMGRLSalman Ahmed Qureshihttp://www.blogger.com/profile/06946726509853037798noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-2571414265392841828.post-8706270516139569632019-03-24T22:24:05.384-07:002019-03-24T22:24:05.384-07:00I am afraid I can not help any further. As a last ...I am afraid I can not help any further. As a last resort, try copying password file from primary host to the DG host and try switchover again,.Salman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-10952444857761308002019-03-23T09:42:44.025-07:002019-03-23T09:42:44.025-07:00Following below steps.
[oracle@rac2 ~]$ dgmgrl
DG...Following below steps.<br /><br />[oracle@rac2 ~]$ dgmgrl<br />DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production<br /><br />Copyright (c) 2000, 2009, Oracle. All rights reserved.<br /><br />Welcome to DGMGRL, type "help" for information.<br />DGMGRL> connect sys@stand<br />Password:<br />Connected.<br />DGMGRL> switchover to prod;<br />Performing switchover NOW, please wait...<br />New primary database "prod" is opening...<br />Operation requires shutdown of instance "stand" on database "stand"<br />Shutting down instance "stand"...<br />ORA-01109: database not open<br /><br />Database dismounted.<br />ORACLE instance shut down.<br />Operation requires startup of instance "stand" on database "stand"<br />Starting instance "stand"...<br />ORA-01031: insufficient privileges<br /><br />Warning: You are no longer connected to ORACLE.<br /><br />Please complete the following steps to finish switchover:<br /> start up and mount instance "stand" of database "stand"<br /><br />Anonymoushttps://www.blogger.com/profile/07571669502503951492noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-36653293170549823452019-03-22T01:23:35.448-07:002019-03-22T01:23:35.448-07:00I am sorry Vinod I have no clue. One last thing, d...I am sorry Vinod I have no clue. One last thing, do not use "as sysdba" while connecting as SYS, if you are using this.Salman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-91272964871948920602019-03-21T23:42:58.754-07:002019-03-21T23:42:58.754-07:00SQL> /
DATABASE_ROLE OPEN_MODE
------------...SQL> /<br /><br />DATABASE_ROLE OPEN_MODE<br />---------------- --------------------<br />PRIMARY READ WRITE<br /><br />SQL> conn sys@prod as sysdba<br />Enter password:<br />Connected.<br />SQL> conn sys@stand as sysdba<br />Enter password:<br />Connected.<br />SQL><br /><br /><br /><br />SQL> /<br /><br />DATABASE_ROLE OPEN_MODE<br />---------------- --------------------<br />PHYSICAL STANDBY MOUNTED<br /><br />SQL> conn sys@stand as sysdba<br />Enter password:<br />Connected.<br />SQL> conn sys@prod as sysdba<br />Enter password:<br />Connected.<br />SQL><br /><br /><br /><br />Password is same on both servers and replication is working fine. if password is not matched the how the replication is working fine.<br /><br />Please suggest.......Anonymoushttps://www.blogger.com/profile/07571669502503951492noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-29977169907912823132019-03-21T18:45:01.635-07:002019-03-21T18:45:01.635-07:00Try connecting with primary and standby database f...Try connecting with primary and standby database from SQLPLUS using same TNS entry to confirm if you are supplying correct SYS password and password is same on both primary and standby.Salman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-5157686116300474732019-03-21T13:17:06.801-07:002019-03-21T13:17:06.801-07:00Tried like above..but still am getting same except...Tried like above..but still am getting same exception.. please suggest...Anonymoushttps://www.blogger.com/profile/07571669502503951492noreply@blogger.com