When running "acm startdb" or "service aveksa_server startdb" for RSA Via Lifecycle & Governance the error "PRCD-1027 : Failed to retrieve database AVDB" displays followed by several other error conditions
3 years ago
Originally Published: 2016-04-04
Article Number
000064561
Applies To
RSA Product Set: RSA Via Lifecycle and Governance 7.0 (L&G)
RSA Version/Condition: 7.0, 6.9.1
Platform: RSA Software Appliance, RSA Hardware Appliance
O/S Version: SuSE 11 SP3, Red Hat
Issue
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.
Cause
The errors are caused by the underlying systems not being available for the start to complete.
Resolution
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 running
The 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 environment
If 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

Related Articles

Trending Articles

Don't see what you're looking for?