adstrtal.sh: Database connection could not be established

 

[applmgr@ranesh scripts]$ sh adstrtal.sh apps/oracle

You are running adstrtal.sh version 120.24.12020000.6

Enter the WebLogic Server password:
adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

USAGE: adstrtal.sh <appsusername/appspassword> [-nothreading]
adstrtal.sh <applications_username/applications_password> -secureapps
adstrtal.sh -nodbchk

adstrtal.sh: exiting with status 1

Solution
********

 

 [oracle@ranesh ~]$ lsnrctl start

 

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 29-OCT-2020 17:44:41

Copyright (c) 1991, 2029, Oracle. All rights reserved.

Starting /u01/oracle/PROD/12.1.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.1.0.2.0 – Production
System parameter file is /u01/oracle/PROD/12.1.0/network/admin/PROD_ranesh/listener.ora
Log messages written to /u01/oracle/PROD/diag/tnslsnr/ranesh/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ranesh.oracle.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 29-OCT-2020 17:44:57
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/PROD/12.1.0/network/admin/PROD_ranesh/listener.ora
Listener Log File /u01/oracle/PROD/diag/tnslsnr/ranesh/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ranesh.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully

 

[oracle@ranesh ~]$ lsnrctl status

 

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 29-OCT-2020 17:45:17

Copyright (c) 1991, 2029, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 29-OCT-2020 17:44:57
Uptime 0 days 0 hr. 0 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/PROD/12.1.0/network/admin/PROD_ranesh/listener.ora
Listener Log File /u01/oracle/PROD/diag/tnslsnr/ranesh/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ranesh.oracle.com)(PORT=1521)))
Services Summary…
Service “PROD” has 1 instance(s).
Instance “PROD”, status READY, has 1 handler(s) for this service…
Service “ebs_patch” has 1 instance(s).
Instance “PROD”, status READY, has 1 handler(s) for this service…
The command completed successfully

[oracle@ranesh ~]$

 

Again start the EBSR12.2 Application Server.

 

[applmgr@ranesh scripts]$ sh adstrtal.sh apps/oracle

You are running adstrtal.sh version 120.24.12020000.6

Enter the WebLogic Server password: weblogic1

The logfile for this session is located at /u01/applmgr/PROD/fs1/inst/apps/PROD_ranesh/logs/appl/admin/log/adstrtal.log

Executing service control script:
/u01/applmgr/PROD/fs1/inst/apps/PROD_ranesh/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3.12020000.4