000017695 - RSA Authentication Manager 7.1 SP4 on Linux database service will not start and SQLplus does not display a prompt

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000017695
Applies ToRSA Authentication Manager 7.1.4 for Linux
RSA Authentication Manager 7.1 SP4 for Linux
RSA Authentication Manager 7.1 Service Pack 4 for Linux
Linux
IssueStart all RSA Authentication Manager 7.1 SP4 services properly on a Linux server
Database service won't start on a Linux server.
SQLplus appears to start but does not display the SQL> prompt on a Linux server.
SQLplus won't start.
SQL prompt doesn't display.
rsautil manage-database -a start-db results in Error: com.rsa.common.UnexpectedDataStoreException: com.rsa.tools.common.ScriptExecutionException: Error when executing the sql script with sqlplus.
Alert log shows the error A001: warning -- apply server 1, sid 410 waiting for event (since xxx seconds):
Starting sqlplus appears to start but then does not provide a SQL> prompt.
CauseThe root cause is still under investigation.  However, it appears that a process got "stuck" which is causing a cascading failure.
Resolution

1. Open a terminal session on the server- need to be root to run /sbin/chkconfig rsaauthmgr off/ [on]


2. /sbin/chkconfig rsaauthmgr off                 - Appliance/Linux:#    sudo su -        1st


3. Reboot the server                               - Appliance/Linux:#   reboot                  [shutdown -r now]


4. Open the terminal session


5. cd to <RSA>/server


6. ./rsaam start dblistener


7. cd ../utils


8. . ./rsaenv


10. rsautil manage-secrets -a get com.rsa.db.root.password


9. sqlplus sys/<password> as sysdba
-- where <password> is the password displayed in the previous step


11. You will now have a "SQL>" prompt. Enter the following commands:


SQL> shutdown abort;


SQL> startup mount;


SQL> recover database;


SQL> alter database open;


SQL> exit;


12. /sbin/chkconfig 2345 rsaauthmgr on


13. Reboot

Legacy Article IDa65460

Attachments

    Outcomes