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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now