PHYSICAL: ORA-604 ORA-16000 on Standby Opened Read Only (Doc ID 730659.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
Oracle Database versions 9.2 to 10.2.0.4




Symptoms

Tried to log into Standby database Opened Read Only as non-sysdba user via
SQLPLUS on the server:

 It fails with the following errors:

SQL> conn <username>
Enter password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-01017: invalid username/password; logon denied



 

Changes

These steps were taken on the PHYSICAL standby BEFORE the test was done.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> SELECT NAME, DATABASE_ROLE FROM V$DATABASE;

NAME DATABASE_ROLE
--------- ---------------- 
V102P PHYSICAL STANDBY

SQL> select log_mode,open_mode , database_role from v$database;
 
LOG_MODE OPEN_MODE DATABASE_ROLE
------------ ---------- ----------------
ARCHIVELOG READ ONLY PHYSICAL STANDBY

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms