E-Business Suite R12.2
Error:- adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
[applmgr@hari 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@hari ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 14-OCT-2020 17:44:41
Copyright (c) 1991, 2014, 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_hari/listener.ora
Log messages written to /u01/oracle/PROD/diag/tnslsnr/hari/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hari.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 14-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_hari/listener.ora
Listener Log File /u01/oracle/PROD/diag/tnslsnr/hari/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hari.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@hari ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 14-OCT-2020 17:45:17
Copyright (c) 1991, 2014, 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 14-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_hari/listener.ora
Listener Log File /u01/oracle/PROD/diag/tnslsnr/hari/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hari.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@hari ~]$
Again start the EBSR12.2 Application Server.
[applmgr@hari 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_hari/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/applmgr/PROD/fs1/inst/apps/PROD_hari/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
