My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.2.0.1 [Release 9.2 to 12.2]
Information in this document applies to any platform.



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

To view full details, 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 a vibrant support community of peers and Oracle experts.