IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got ” CRS-2800: Cannot start resource ‘ora.ctssd’ as it is already in the INTERMEDIATE state on server ” error in Oracle database.
CRS-2800: Cannot start resource ‘ora.ctssd’ as it is already in the INTERMEDIATE state on server
Details of error are as follows.
GI service fails to start:
$ srvctl start service -s <service> -d <database> PRCD-1084 : Failed to start service <service> PRCR-1079 : Failed to start resource ora.<database>.<instance>.svc CRS-2800: Cannot start resource 'ora.<database>.db' as it is already in the INTERMEDIATE state on server '<hostname>' CRS-2632: There are no more servers to try to place resource 'ora.<database>.<service>.svc' on that would satisfy its placement policy CRS-2800: Cannot start resource 'ora.<database>.db' as it is already in the INTERMEDIATE state on server '<hostname>' $ $ srvctl config database -d <database> -a Database unique name: <database> Database name: Oracle home: /opt/oracle/product/11.2.0.4.1 Oracle user: oracle Spfile: +DATA02/sgracdb/spfile<database>.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: <server_pool> Database instances: <instance1>,<instance2> Disk Groups: <DISKGROUP1>,<DISKGROUP2> Mount point paths: Services: <service> Type: RAC Database is enabled Database is administrator managed
Cannot start resource ‘ora.ctssd’ as it is already in the INTERMEDIATE state on server
This CRS-2800 error is related to the database resource is in INTERMEDIATE state with Restricted Access.
$ crsctl stat res ora.<database>.db -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.<database>.db 1 ONLINE INTERMEDIATE <hostname1> Restricted Access 2 ONLINE INTERMEDIATE <hostname2> Restricted Access $
Get the database resource out of “INTERMEDIATE” state, in this case, disable restricted access:
1)Disable the restricted session on all the DB instances:
SQL> alter system disable restricted session;
2)Start the service
$ srvctl start service -s <service> -d <database>
3)Check the service status
$ srvctl status service -s <service> -d <database> Service <service> is running on instance(s) <instance1>,<instance2>
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
Tried like above still not working
SQL> alter system disable restricted session;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
oracle@xxxxxxxxxxxxxx% srvctl start service -d xxxxx -s cccccc
CRS-2800: Cannot start resource ‘dddddd as it is already in the INTERMEDIATE state on server
CRS-2528: Unable to place an instance ofas all possible servers are occupied by the resource
could you send crs_stat -t result ? and if it is possible run the crsctl stop cluster -all then crsctl start cluster -all if it is in the intermediate state.