Unable to connect to read only database, Getting error ORA-00604 ORA-16000 (Doc ID 461653.1)

Last updated on OCTOBER 18, 2016

Applies to:

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

Symptoms

A read-only database is cloned from a read-write production database.
The read-only database is brought to sync with the production database everyday and is used only for reporting.

At times, users are unable to connect to the database, otherwise they can login to the read-only database without any problem.

The error they receive is:
ORA-00604: Error occurred at recursive SQL line 1
ORA-16000: Database open for read-only access

Changes

Profile has been set for the users connecting to the read-only database.

SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where profile='NEWBIZUSERS';


RESOURCE_NAME                     RESOURCE             LIMIT
----------------------------      --------     --------------------
....
FAILED_LOGIN_ATTEMPTS             PASSWORD        6
PASSWORD_LIFE_TIME                PASSWORD        60
PASSWORD_REUSE_TIME               PASSWORD        UNLIMITED
PASSWORD_REUSE_MAX                PASSWORD        5
PASSWORD_VERIFY_FUNCTION          PASSWORD        VERIFY_PASSWD_8CHAR
PASSWORD_LOCK_TIME                PASSWORD        UNLIMITED
PASSWORD_GRACE_TIME               PASSWORD        0

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