Posted on 2011-03-10
Last Modified: 2012-05-11
DGMGRL> switchover to 'standby';
Performing switchover now, please wait ...
New primary database "standby" is opening...
Operations requires shutdown of instance "racpoc1" on database "RACPOC"
Shutting down instance "racpoc1"...
ORA-01031: insufficient privileges

Warning: you are no longer connected to oracle.

Please complete the following steps to finish switchover:
Shutdown instance "racpoc1" of database "RACPOC"
start up instance "racpoc1" of database "RACPOC"

DGMGRL> exit
Question by:hussainkhan22
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 68

Accepted Solution

woolmilkporc earned 250 total points
ID: 35094665
Did you create the remote login passwordfile (using "orapwd") on both sites (primary/standby)?


Assisted Solution

niaz earned 250 total points
ID: 35096520
This discussion thread on oracle forum discuss the same issue.

DGMGRL does not support OS authentication. You have to connect as "CONNECT sys/password"
LVL 68

Expert Comment

ID: 35100969

and that's why the password files are needed.


Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question