My Oracle Support Banner

ORA-16000 When Starting a Service in Read Only Standby Environment Following 12c Grid Infrastructure (GI) Upgrade (Doc ID 1615358.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Start of a database service in a standby database fails with ORA-16000 after upgrading the Grid infrastructure to 12c. "srvctl start service" command fail with the following error.

$ srvctl start service -d <standby_dbname> -s <servicename>

PRCD-1084 : Failed to start service <servicename>
PRCR-1079 : Failed to start resource ora.<standby_instancename1>.<servicename>.svc
CRS-5017: The resource action "ora.<standby_intancename1>.<servicename>.svc start" encountered the following error:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.DBMS_SERVICE", line 433
ORA-06512: at "SYS.DBMS_SERVICE", line 304
ORA-06512: at line 1
For details refer to "(:CLSN00107:)" in "$GRID_HOME/log/<databasename>/agent/crsd/oraagent_oracle/oraagent_oracle.log".

The service can be started in 11.2 GI environment. Turning on 10046 SQL trace for the database agent process will indicate that oraagent issues an DBMS_SERVICE.MODIFY_SERVICE(..), this procedure invokes a DML on service$ dictionary table, which fails as the standby database is not opened in read write mode:

 DBMS_SERVICE.MODIFY_SERVICE(service_name => :service_name, goal => goal, dtp
  => :dtp = '1', aq_ha_notifications => :aq_ha_notification = '1',
  failover_method => :failover_method, failover_type => :failover_type,
  failover_retries => failover_retries, failover_delay => failover_delay,
  clb_goal => clb_goal, edition => :edition, modify_edition => modify_edition);



 Upgrade the Grid Infrastructure to 12c.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.