While starting listener on Oracle Applications through adalnctl.sh exited with,
adalnctl.sh: exiting with status 1
Following was found in the log file.
LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:52
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=XXX)(Port=1626))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
Starting listener process APPS_XXX.
LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:55
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Starting /oraapp/ncrmprd6ora/8.0.6/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Log messages written to /oraapp/XX/8.0.6/network/admin/apps_XX.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=XXX7)(PORT=1626))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
IBM/AIX RISC System/6000 Error: 13: Permission denied
To resolve this issue generated a trace, found an issue with permission on /tmp/.oracle check the analysis below,
truss -aefo check.lst lsnrctl start APPS_XXX
Found that my listener was not able access /tmp/.oracle,
885468: socket(1, 1, 0) = 9
885468: _getpid() = 885468
885468: access("/tmp/.oracle/s#885468.1", 0) Err#13 EACCES
885468: close(9) = 0
885468: lseek(8, 18944, 0) = 18944
885468: kread(8, "\00F04 /\0\0\0 b04 0\0\0".., 512) = 512
885468: _getpid() = 885468
885468: access("/tmp/.oracle/s#885468.1", 0) Err#13 EACCES
885468: close(9) = 0
885468: lseek(8, 18944, 0) = 18944
885468: kread(8, "\00F04 /\0\0\0 b04 0\0\0".., 512) = 512
[MITHUN:]-/tmp> ls -ltr .oracle
ls: 0653-345 .oracle/s#246172.1: Permission denied.
ls: 0653-345 .oracle/s#278740.1: Permission denied.
ls: 0653-345 .oracle/s#1410002.1: Permission denied.
ls: 0653-345 .oracle/s#2486458.1: Permission denied.
total 0
[:MITHUN:]-/tmp> cd .oracle
ksh: .oracle: Permission denied.
[:MITHUN:]-/tmp> ls -la | grep oracle
drw-r----- 2 applmgr dba 256 Jan 02 05:48 .oracle
[:MITHUN:]-/tmp> id
uid=204(applmgr) gid=203(dba) groups=1(staff)
[:MITHUN:]-/tmp> chmod 777 .oracle
[:MITHUN:]-/tmp> lsnrctl start APPS_XXXX
ls: 0653-345 .oracle/s#246172.1: Permission denied.
ls: 0653-345 .oracle/s#278740.1: Permission denied.
ls: 0653-345 .oracle/s#1410002.1: Permission denied.
ls: 0653-345 .oracle/s#2486458.1: Permission denied.
total 0
[:MITHUN:]-/tmp> cd .oracle
ksh: .oracle: Permission denied.
[:MITHUN:]-/tmp> ls -la | grep oracle
drw-r----- 2 applmgr dba 256 Jan 02 05:48 .oracle
[:MITHUN:]-/tmp> id
uid=204(applmgr) gid=203(dba) groups=1(staff)
[:MITHUN:]-/tmp> chmod 777 .oracle
[:MITHUN:]-/tmp> lsnrctl start APPS_XXXX
LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 05:47:27
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Starting /oraapp/ncrmprd6ora/8.0.6/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Log messages written to /oraapp/ncrmprd6ora/8.0.6/network/admin/apps_XXXX.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=XXX)(PORT=1626))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=XX)(Port=1626))
STATUS of the LISTENER
------------------------
Alias APPS_XX
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Start Date 25-JAN-2013 05:47:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP ON
Listener Log File /oraapp/XXd6ora/8.0.6/network/admin/apps_XXX.log
Services Summary...
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Starting /oraapp/ncrmprd6ora/8.0.6/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Log messages written to /oraapp/ncrmprd6ora/8.0.6/network/admin/apps_XXXX.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=XXX)(PORT=1626))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=XX)(Port=1626))
STATUS of the LISTENER
------------------------
Alias APPS_XX
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Start Date 25-JAN-2013 05:47:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP ON
Listener Log File /oraapp/XXd6ora/8.0.6/network/admin/apps_XXX.log
Services Summary...
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)
Comments
"TNS-12560: TNS:protocol adapter error"
i am getting this error can you plz tell me how to resolve this issue. i am not able to understand what you have mentioned.