Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dataguard while log switch error ora-01031:insufficient privileges

539327Oct 13 2006 — edited Oct 13 2006

I have configured a simple data guard system. The physical standby database open in read only mode. when I issue the following command in the primary database it shows the following error

SQL> alter system switch logfile;

System altered.

SQL> select status,error from v$archive_dest;

STATUS ERROR
--------- -----------------------------------------------------------------
VALID
ERROR ORA-01031: insufficient privileges
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE

what may be the reasons?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2006

Added on Oct 13 2006

#general-database-discussions

1 comment

547 views