Output tnsping $TWO_TASK [oracle@wtnoraerp1:/DB/EBS/APPS/fs1/inst/apps/PROD_wtnoraerp1/admin/scripts]$ tnsping $TWO_TASK TNS Ping Utility for Solaris: Version 10.1.0.5.0 - Production on 04-NOV-2017 11:07:53 Copyright (c) 1997, 2003, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=wtnoraerp1)(PORT=1526)) (CONNECT_DATA=(SID=PROD))) OK (0 msec) ============================================= Output of sqlplus apps/apps_password [oracle@wtnoraerp1:/DB/EBS/APPS/fs1/inst/apps/PROD_wtnoraerp1/admin/scripts]$ sqlplus apps/apps SQL*Plus: Release 10.1.0.5.0 - Production on Sat Nov 4 11:11:26 2017 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ====================================================== Output of DB listner status [oracle@wtnoraerp1:/DB/PROD/12.1.0/appsutil/scripts]$ lsnrctl status PROD LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 04-NOV-2017 12:07:18 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wtnoraerp1-vip.rchsp.med.sa)(PORT=1526)(IP=FIRST))) STATUS of the LISTENER ------------------------ Alias PROD Version TNSLSNR for Solaris: Version 12.1.0.2.0 - Production Start Date 03-NOV-2017 16:39:02 Uptime 0 days 19 hr. 28 min. 15 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /DB/PROD/12.1.0/network/admin/PROD1_wtnoraerp1/listener.ora Listener Log File /DB/PROD/diag/tnslsnr/wtnoraerp1/prod/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.5.13)(PORT=1526))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.5.11)(PORT=1526))) Services Summary... Service "PROD1" has 1 instance(s). Instance "PROD1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully