Problem
Unable to Start eHealth63 Service /Error :1053 could not restart in a Timely fashion in 6.3.2
Solution
Please check if the the hostname has been changed in any of these files. If you find there is a change please take a backup of the file and edit the file with the correct hostname.
$NH_ORACLE_HOME/network/admin/listener.ora
$NH_HOME/lmgr/license.dat
$NH_ORACLE_HOME/network/admin/tnsnames.ora
$NH_HOME/web/httpd/conf/httpd.conf
$NH_HOME/web/tomcat/conf/server.xml
Once the files are updated restart the services and check if that solves the problem.
If the problem still persists
- Open a command prompt
- Login to sql: sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING
We are checking if the account with which we login to the database has expired.
SQL> select username,account_status FROM dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CRN OPEN
NHLISTENER OPEN
EHEALTH EXPIRED
DBSNMP EXPIRED & LOCKED
SYS OPEN
SYSTEM OPEN
OUTLN LOCKED
If eHealth account shows expired, exit from sqlplus, then start it again as the sysdba: sqlplus "sys/ehealth@%NH_DB_CONNECT_STRING as sysdba"
Then run the following commands:
select limit from dba_profiles where RESOURCE_NAME = 'PASSWORD_LIFE_TIME' unlimited
alter profile default limit PASSWORD_LIFE_TIME unlimited
If EHEALTH account still Shows expired, it can only be revived by assigning it a new password:
ALTER USER %NH_USER% IDENTIFIED BY password;
example : ALTER USER EHEALTH IDENTIFIED BY ehealth ;
Run the below command again:
SQL> select username,account_status FROM dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CRN OPEN
NHLISTENER OPEN
EHEALTH OPEN
DBSNMP EXPIRED & LOCKED
SYS OPEN
SYSTEM OPEN
OUTLN LOCKED
Restart the eHealth Services and check if the problem is resolved.