ORA-44317 TRYING TO START SERVICE IN READ-ONLY STANDBY (Doc ID 749657.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4

Symptoms

Trying to start a service in read-only standby database gives error:

srvctl start service -d hkg -s hkgsrv1
PRKP-1030 : Failed to start the service hkgsrv1.
CRS-0215: Could not start resource 'ora.hkg.hkgsrv1.cs' 

The imon_<db_name>.log shows:

2008-11-03 09:28:30.775: [ RACG][4591]
[1319016][4591][ora.hkg.hkgsrv1.srv]:
ORA-44317: database open read-only
ORA-06512: at "SYS.DBMS_SERVICE", line 468
ORA-06512: at "SYS.DBMS_SERVICE", line 221
ORA-06512: at line 1


Changes

Customer has a RAC database with a standby database. He created a new service for standby database intended for use when standby database is opened for read-only.

1. create service hkgsrv1 using srvctl for standby:
srvctl add service -d hkg -s hkgsrv1 -r hkg1
srvctl config service -d hkg
hkgsrv1 PREF: hkg1 AVAIL:

2. open database hkg1 read only
3. try to start the hkgsrv1
srvctl start service -d hkg -s hkgsrv1
PRKP-1030 : Failed to start the service hkgsrv1.
CRS-0215: Could not start resource 'ora.hkg.hkgsrv1.cs'.


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