Oracle Database Discussions

Hi,

I am facing some issues with the TNS listener on my instance.

[oracle@erpp2 bin]$ lsnrctl status

LSNRCTL for Linux: Version 8.0.6.3.0 - Production on 28-DEC-2005 13:30:59

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=erpp2))
STATUS of the LISTENER
------------------------
Alias APPS_PROD
Version TNSLSNR for Linux: Version 8.0.6.3.0 - Production
Start Date 28-DEC-2005 13:11:06
Uptime 0 days 0 hr. 19 min. 55 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /oracle/prodora/8.0.6/network/admin/apps_prod.log
Services Summary...
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)
The command completed successfully

[oracle@erpp2 bin]$ tnsping prod

TNS Ping Utility for Linux: Version 8.0.6.3.0 - Production on 28-DEC-2005 13:35:05

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=ERPP2.****)(PORT=1521))
OK (0 msec)

But when i try to use SQL*Plus to log in, i get the following error:

[oracle@erpp2 bin]$ sqlplus apps/apps@prod

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Dec 28 13:36:08 2005

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-12514: Message 12514 not found; product=RDBMS; facility=ORA



The listener.ora file is like below:

APPS_PROD =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= erpp2)(Port= 1626))
)
SID_LIST_APPS_PROD =
(SID_LIST =
( SID_DESC = ( SID_NAME = FNDSM )
( ORACLE_HOME = /oracle/prodora/8.0.6 )
( PROGRAM = /oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/oracle/prodappl/APPSPROD_erpp2.env,PATH=/usr/bin:/usr/ccs/bin:/bin,FNDSM_SCRIPT=/oracle/prodcomn/admin/scripts/PROD_erpp2/gsmstart.sh' )
)
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /oracle/prodora/8.0.6 )
( PROGRAM = /oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/oracle/prodora/8.0.6/lib,APPLFSTT=PROD_806_BALANCE;PROD;PROD_BALANCE;PROD_FO,APPLFSWD=/oracle/prodappl/admin;/oracle/prodcomn/temp;/oracle/prodcomn/html/oam/nonUix/launchMode/restricted' )
)
)
STARTUP_WAIT_TIME_APPS_PROD = 0
CONNECT_TIMEOUT_APPS_PROD = 10
TRACE_LEVEL_APPS_PROD = OFF
LOG_DIRECTORY_APPS_PROD = /oracle/prodora/8.0.6/network/admin
LOG_FILE_APPS_PROD = APPS_PROD
TRACE_DIRECTORY_APPS_PROD = /oracle/prodora/8.0.6/network/admin
TRACE_FILE_APPS_PROD = APPS_PROD
IFILE = /oracle/prodora/8.0.6/network/admin/PROD_erpp2/PROD_erpp2_listener_ifile.ora

and the TNS names is :
PROD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ERPP2.****)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD)
)
)

I dont think i have changed anything (config). Any guess what to look around?

Thanks
Ashish