When attempting to run the command
acm startdb
or
service aveksa_server startdb
The following output displays:
oracle@acm-700:~> acm startdb
PRCD-1027 : Failed to retrieve database AVDB
PRCR-1070 : Failed to check if resource ora.avdb.db is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCD-1027 : Failed to retrieve database AVDB
PRCR-1070 : Failed to check if resource ora.avdb.db is registered
CRS-0184 : Cannot communicate with the CRS daemon.
The errors are caused by the underlying systems not being available for the start to complete.
The startdb argument has a pre-requisite that several Oracle components are available.
If Oracle is shutdown and you need to start it, the argument is startoracle, as in the examples below:
acm startoracle
or
service aveksa_server startoracle
After running the startoracle command, the startdb command is not required as it fully starts the database.
Running startdb when it is already runningThe startdb command is typically only used in conjunction with the stopdb command. If you do run the startdb command it will not harm the system, it will return output similar to:
oracle@acm-700:~> acm startdb
PRCC-1014 : AVDB was already running
PRCR-1004 : Resource ora.avdb.db is already running
PRCR-1079 : Failed to start resource ora.avdb.db
CRS-5702: Resource 'ora.avdb.db' is already running on 'acm-700'
Database is running.
Checking the environmentIf you want to check to see if the services required by the startdb command are started you can run this command:
acm statusoracle
or
service aveksa_server statusoracle
If the services are
not available you will see this output from statusoracle:
oracle@acm-700:~> acm statusoracle
CRS-4639: Could not contact Oracle High Availability Services
PRCD-1027 : Failed to retrieve database AVDB
PRCR-1070 : Failed to check if resource ora.avdb.db is registered
CRS-0184 : Cannot communicate with the CRS daemon.
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-APR-2016 11:18:36
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1555)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=acm-700.vcloud.local)(PORT=1555)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
If the services
are available you will see this output from statusoracle:
oracle@acm-700:~> acm statusoracle
CRS-4638: Oracle High Availability Services is online
Database is running.
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-APR-2016 11:21:56
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1555)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 04-APR-2016 11:21:25
Uptime 0 days 0 hr. 0 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.1.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/acm-700/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1555)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acm-700.vcloud.local)(PORT=1555)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.26.114)(PORT=1521)))
Services Summary...
Service "AVDB" has 1 instance(s).
Instance "AVDB", status READY, has 1 handler(s) for this service...
Service "AVDBXDB" has 1 instance(s).
Instance "AVDB", status READY, has 1 handler(s) for this service...
The command completed successfully