Re:Listener not working

[Former Member]

Hi,

We have recently installed the SAP ECC 6.0 with the concept of clusters.

But we found out that after it has been installed, the listener is not working after logging in as ora<sid>..

Also it does not show the status of the listener.

Kindly let us know what needs to be done.

Kindly note the below error

CPDB:oracpl 12> sqlplus "/as sysdba"

Error 6 initializing SQL*Plus

Message file sp1<lang>.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

The listener.log also shows the error

04-OCT-2007 12:25:16 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.235)(PORT=53390)) * establish * CPL * 12518

TNS-12518: TNS:listener could not hand off client connection

TNS-12547: TNS:lost contact

TNS-12560: TNS:protocol adapter error

TNS-00517: Lost contact

Please provide us with your suggestions.

Regards,

Radeesh V

[Former Member]

hi Radeesh,

Cheak wheather ur sap is connected to data base or not

the command is R3transs -d

Regards,

Younus.

[Former Member]

Hi,

We have recently installed the SAP ECC 6.0 with the concept of clusters.

But we found out that after it has been installed, the listener is not working after logging in as ora<sid>..

Also it does not show the status of the listener.

Kindly let us know what needs to be done.

Kindly note the below error

CPDB:oracpl 12> sqlplus "/as sysdba"

Error 6 initializing SQL*Plus

Message file sp1<lang>.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

The listener.log also shows the error

04-OCT-2007 12:25:16 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.235)(PORT=53390)) * establish * CPL * 12518

TNS-12518: TNS:listener could not hand off client connection

TNS-12547: TNS:lost contact

TNS-12560: TNS:protocol adapter error

TNS-00517: Lost contact

IBM/AIX RISC System/6000 Error: 32: Broken pipe

04-OCT-2007 12:25:21 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.239)(PORT=53391)) * establish * CPL * 0

04-OCT-2007 12:25:21 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.235)(PORT=53392)) * establish * CPL * 0

04-OCT-2007 12:25:22 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.239)(PORT=53393)) * establish * CPL * 0

04-OCT-2007 12:25:22 * (CONNECT_DATA=(SID=CPL)(GLOBAL_NAME=CPL.WORLD)(CID=(PROGRAM=dw.sapCPL_DVEBMGS00)(HOST=CPCI)(USER=cpladm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.82.235)(PORT=53394)) * establish * CPL * 0

Please provide us with your suggestions.

Regards,

Radeesh V

[Former Member]

Radeesh,

I hope you have set the env variables ORACLE_HOME,path etc.

Now can you please confirm if you can call sqlplus. May be oracle s/w has not been installed properly.

[Former Member]

Hi,

The oracle was installed correctly..

We also found that we had the following error

CPDB:oracpl 9> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 14-NOV-

2007 16:50:42

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

Message 1070 not found; No message file for product=network, facility=TNSTNS-125

45: Message 12545 not found; No message file for product=network, facility=TNS

TNS-12560: Message 12560 not found; No message file for product=network, facili

ty=TNS

TNS-00515: Message 515 not found; No message file for product=network, facilit

y=TNS

IBM/AIX RISC System/6000 Error: 2: No such file or directory

This happened when we tried to start the listener.

[Former Member]

1. check if the listener.ora file exists in network/admin

2. Make sure the ORACLE_HOME and the home directory of your oracle user is not same. Can you please tell me what are the current values?

[Former Member]

Hi,

Please find the current values

1. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/DBENV.SH#7 $

2. Oracle RDBMS Environment

THREAD=NOPS; export THREAD

if [ $THREAD = NOPS ]; then

DBSID=CPL

else

if [ $THREAD != "001" ]; then

DBSID=CPL_$

else

DBSID=CPL

fi

fi

dbms_type=ORA; export dbms_type

dbs_ora_tnsname=$DBSID; export dbs_ora_tnsname

dbs_ora_schema=SAPSR3; export dbs_ora_schema

ORACLE_SID=$DBSID; export ORACLE_SID

DB_SID=CPL; export DB_SID

ORACLE_HOME=/oracle/CPL/102_64; export ORACLE_HOME

ORACLE_BASE=/oracle; export ORACLE_BASE

NLS_LANG=AMERICAN_AMERICA.UTF8 ; export NLS_LANG

SAPDATA_HOME=/oracle/CPL; export SAPDATA_HOME

DIR_LIBRARY=/usr/sap/CPL/SYS/exe/run; export DIR_LIBRARY

1. check for running user and set for orasid ORA_NLS10

USER=`id | awk -F\( '{print $2}' | awk -F\) '{print $1}'`

TRUL='tr "ABCDEFGHIJKLMNOPQRSTUVWXYZ" "abcdefghijklmnopqrstuvwxyz"'

ORASID="ora`echo $DB_SID | $TRUL`"

if [ $USER != $ORASID ]; then

TNS_ADMIN=/usr/sap/CPL/SYS/profile/oracle; export TNS_ADMIN

ADD=/oracle/client/10x_64/instantclient

_f=/sapmnt/CPL/profile/DEFAULT.PFL

t=/oracle/CPL/10264/bin/sqlplus

SAPDBHOST=""

if [ -r "$_f" ]; then

SAPDBHOST=`awk -F= '/^[ ]SAPDBHOST[ ]=/ {print $2; exit}' $_f | awk '{print $1}'`

fi

if [ -r "$_t" -o `uname -n` = "$SAPDBHOST" ]; then

ORACLE_HOME=/oracle/CPL/102_64; export ORACLE_HOME

fi

else

ORACLE_HOME=/oracle/CPL/102_64; export ORACLE_HOME

ADD=/oracle/CPL/102_64/lib

fi

if [ ! -z "$ORACLE_HOME" ]; then

for d in $ORACLE_HOME/bin; do

i=0

for p in `echo $PATH | sed 's/:/ /g'`; do

if [ "$p" = "$d" ]; then

i=1

break

fi

done

if [ $i -eq 0 ]; then

PATH=$:$; export PATH fi done fi case `uname` in AIX*) if [ -z "$LIBPATH" ]; then LIBPATH=/usr/lib:/lib:$:/usr/sap/CPL/SYS/exe/run else for d in /usr/sap/CPL/SYS/exe/run $; do i=0 for p in `echo $LIBPATH | sed 's/:/ /g'`; do if [ "$p" = "$d" ]; then i=1 break fi done if [ $i -eq 0 ]; then LIBPATH=$:$; export LIBPATH

fi

done

fi

;;

HP*)

if [ -z "$SHLIB_PATH" ]; then

SHLIB_PATH=$:/usr/sap/CPL/SYS/exe/run else SHLIB_PATH=$:/usr/sap/CPL/SYS/exe/run

else

for d in /usr/sap/CPL/SYS/exe/run $; do i=0 for p in `echo $SHLIB_PATH | sed 's/:/ /g'`; do if [ "$p" = "$d" ]; then i=1 break fi done if [ $i -eq 0 ]; then SHLIB_PATH=$:$; export SHLIB_PATH fi done fi ;; Linux* | SIN* | Reliant*) if [ -z "$LD_LIBRARY_PATH" ]; then LD_LIBRARY_PATH=$:/usr/sap/CPL/SYS/exe/run

else

for d in /usr/sap/CPL/SYS/exe/run $; do i=0 for p in `echo $LD_LIBRARY_PATH | sed 's/:/ /g'`; do if [ "$p" = "$d" ]; then i=1 break fi done if [ $i -eq 0 ]; then LD_LIBRARY_PATH=$:$; export LD_LIBRARY_PATH fi done fi ;; OSF*) if [ -z "$LD_LIBRARY_PATH" ]; then LD_LIBRARY_PATH=$:/usr/sap/CPL/SYS/exe/run

else

for d in /usr/sap/CPL/SYS/exe/run $; do i=0 for p in `echo $LD_LIBRARY_PATH | sed 's/:/ /g'`; do if [ "$p" = "$d" ]; then i=1 break fi done if [ $i -eq 0 ]; then LD_LIBRARY_PATH=$:$; export LD_LIBRARY_PATH fi done fi ;; *) if [ -z "$LD_LIBRARY_PATH" ]; then LD_LIBRARY_PATH=$

else

for d in $ADD; do

i=0

for p in `echo $LD_LIBRARY_PATH | sed 's/:/ /g'`; do

if [ "$p" = "$d" ]; then

i=1

break

fi

done

if [ $i -eq 0 ]; then

LD_LIBRARY_PATH=$:$; export LD_LIBRARY_PATH

fi

done

fi

;;

esac

1. define some nice aliases

alias cdora='cd /usr/sap/$SAPSYSTEMNAME/SYS/profile/oracle'

1. end Oracle RDBMS Environment

Regards,

Radeesh V

[Former Member]

1. Check the home directory of the current user ora<sid>. When you login it displays the home directory of the user.

If it is /oracle/CPL/102_64 change it to say /oracle/CPL

This may be one of the reasons. Once this is done please check again

2. I am also suspective of the value of LIBPATH. LIBPATH for orasid should be $ORACLE_HOME/lib whereas the current setting is quite different.