ORA-44317 TRYING TO START SERVICE IN READ-ONLY STANDBY
Last updated on AUGUST 02, 2017
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4This 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:
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'.
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