000035013 - Failed to connect to the database error during upgrade to RSA Identity Governance and Lifecycle 7.0.1

Document created by RSA Customer Support Employee on Apr 13, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035013
Applies ToRSA Product Set:  Identity Governance and Lifecycle
RSA Version/Condition: 7.0.1
 
IssueDuring the upgrade to RSA Identity Governance and Lifecycle 7.0.1, the aveksa-install.log displays the following error:
[Wed Mar 29 15:44:41 EDT 2017] Shutting down RSA Identity Governance and Lifecycle...
[Wed Mar 29 15:44:41 EDT 2017] Shutting down RSA Identity Governance and Lifecycle completed
--------------------------------------------------------------------------
[Wed Mar 29 15:44:41 EDT 2017] Configuring users...
[Wed Mar 29 15:44:41 EDT 2017] Configuring users completed
--------------------------------------------------------------------------
[Wed Mar 29 15:44:41 EDT 2017] Installing Oracle Client...
[Wed Mar 29 15:44:43 EDT 2017] Installing Oracle Client completed
--------------------------------------------------------------------------
[Wed Mar 29 15:44:43 EDT 2017] Checking database connections...
Checking database...
Failed to connect to the database[Wed Mar 29 15:44:43 EDT 2017] Checking database connections...
Checking database...
Failed to connect to the database
Cause
  1. Open the following files in a text editor:
  • /tmp/aveksa/staging/deploy/common.sh,
  • /tmp/aveksa/staging/deploy/install.sh and
  • /tmp/aveksa/staging/database/cliAveksa.sh
  1. Add the following command as the first line in each file.  This will print subsequent executed commands to the terminal.
set -x

  1. Save and close the files.
  2. Run the installation again.
  3. The last command run before the failure is:
. CHECK_SQLPLUS=Y
. su - oracle -c 'tmp/aveksa/staging/deply/../database/cliAveksa.sh -check dbtuning silent'
. "[' 126 -gt 0 ']'
. tee -a /tmp/aveksa-instyall.log
. echo 'Failed to connect to the database'
.ailed to connect to the database
return 2
. '[' N = N ']'
echo ''

  1. When you execute the following command as root, the following permission denied error is seen:
su - oracle -c '/tmp/aveksa/staging/deploy../database/cliAveksa.sh -check dbrunning silent'
bash: /tmp/aveksa/staging/deploy../database/cliAveksa.sh: Permission denied
ResolutionIn this particular case, we had multiple issues where the files in /tmp/aveksa/staging did not have the correct ownership and file protections.
Follow the instructions in the RSA Identity Governance and Lifecycle V7.0.1 Installation Guide to create /tmp/aveksa/staging and /tmp/aveksa/packages as root and untar the files to /tmp/aveksa/staging/ as root.  
The files need to be executable and we must be allowed to write logs to /tmp.  Run the following:
chmod +x /tmp/aveksa/staging/deploy/common.sh
chmod +x /tmp/aveksa/staging/deploy/install.sh
chmod +x /tmp/aveksa/staging/database/cliAveksa.sh

Attachments

    Outcomes