Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

Solved

DGMGRL

Posted on 2011-03-10

2 solutions

Medium Priority

922 Views

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

Comment

Question by:hussainkhan22

[X]

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

Join The Community

3 Comments

LVL 68

Accepted Solution

by:woolmilkporc

woolmilkporc earned 1000 total points

ID: 350946652011-03-10

Did you create the remote login passwordfile (using "orapwd") on both sites (primary/standby)?

wmp

LVL 2

Assisted Solution

by:niaz

niaz earned 1000 total points

ID: 350965202011-03-10

This discussion thread on oracle forum discuss the same issue.

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

http://forums.oracle.com/forums/thread.jspa?messageID=3227546

LVL 68

Expert Comment

by:woolmilkporc

ID: 351009692011-03-10

Yes,

and that's why the password files are needed.

wmp

Featured Post

Question has a verified solution.

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

Cursor in Oracle

Article by: Swadhin

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…

Oracle Database

Some Useful Settings in JasperReports Server

Article by: Doug

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.

How Joins Work

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…