Skip to Content
author's profile photo Former Member
Former Member

Listener not found allthough is working any ideas?

Hi,

From problem to question:

I was upgradeing EHP5 to sap 4.7 and everything went fine until step 5 - EU_IMP2 - when all hang. I Stopped SAP and killed hanged sessions in oracle and in processes and shut down Oracle aswell. (Actual problem was that archivelogs were full allthough df -h did not say anything about some disk being full...).

Anyway - when archivelogs were cleaned to last date listener was restarted the same with oracle - both started fine. When starting SAP via sapstart gives error that Oracle needs to be started on remote machine (allthough both oracle and sap reside in same machine.)

When troubleshooting:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

R3trans -x

This is R3trans version 6.13 (release 640 - 19.01.11 - 17:51:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TAU'"

R3trans finished (0012).

(Allthough Oracle is started and operational and db is open)

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-JUN-2012 11:21:27

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production

Start Date 29-JUN-2012 00:34:18

Uptime 0 days 10 hr. 47 min. 8 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/TAU/112_64/network/admin/listener.ora

Listener Log File /oracle/diag/tnslsnr/sledda/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xx)(PORT=1521)))

The listener supports no services

The command completed successfully

(i replaced XXX vith correct hostname in this post. What botheres me is marked with bold text)

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

listener.ora

################

# Filename......: listener.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADR_BASE_LISTENER_TAU = /oracle/TAU/saptrace

ADMIN_RESTRICTIONS_LISTENER_TAU = on

LISTENER_TAU =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = TAU.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = TAU)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = xxx.xxx.xx)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER_TAU = 0

CONNECT_TIMEOUT_LISTENER_TAU = 10

TRACE_LEVEL_LISTENER_TAU = OFF

SID_LIST_LISTENER_TAU =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = TAU)

(ORACLE_HOME = /oracle/TAU/112_64)

)

)

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

tnsnames.ora

################

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

TAU.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = xxx.xxx.xx)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = TAU)

(GLOBAL_NAME = TAU.WORLD)

)

)

LOCAL_LISTENER_TAU.WORLD =

(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx)(PORT = 1527))

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

I have even tried to make Oracle register itself to listener via alter database register - command goes thru but when executing listener status it's the same as before.

As I cannot start SAP the upgrade proccess also gives tp connection error and upgrade cannot continue.

Any advice given on my text above how to make oracle to appear in listener?

Thanks in an advance,

Kristjan T.

Message was edited by: Kristjan T

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 29, 2012 at 08:49 AM

    can you stop the listener process using lsnrctl stop

    Start the listener as follows :

    lsnrctl

    lsnrctl > start LISTENER_TAU

    Then check if the above works.

    lsnrctl> status LISTENER_TAU

    lsnrctl> services LISTENER_TAU

    Regards

    Ratnajit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 29, 2012 at 08:37 AM

    Can you paste the trans.log file , output from R3trans -x

    Regards

    Ratnajit

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your quick response - trans.log is:

      4 ETW000 R3trans version 6.13 (release 640 - 19.01.11 - 17:51:00).

      4 ETW000 unicode enabled version

      4 ETW000 ===============================================

      4 ETW000

      4 ETW000 date&time : 29.06.2012 - 11:39:42

      4 ETW000 control file: <no ctrlfile>

      4 ETW000 R3trans was called as follows: R3trans -x

      4 ETW000 trace at level 2 opened for a given file pointer

      4 ETW000 [dev trc ,00000] Fri Jun 29 11:39:42 2012 67 0.000067

      4 ETW000 [dev trc ,00000] db_con_init called 21 0.000088

      4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 24 0.000112

      4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TAU/SYS/exe/run/dboraslib.so' ...

      4 ETW000 46 0.000158

      4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/TAU/SYS/exe/run/dboraslib.so"), hdl 0

      4 ETW000 9495 0.009653

      4 ETW000 [dev trc ,00000] Library '/usr/sap/TAU/SYS/exe/run/dboraslib.so' loaded

      4 ETW000 28 0.009681

      4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so

      4 ETW000 30 0.009711

      4 ETW000 [dev trc ,00000] Version of '/usr/sap/TAU/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.369)

      4 ETW000 71 0.009782

      4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so

      4 ETW000 25 0.009807

      4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/TAU/SYS/exe/run/dboraslib.so

      4 ETW000 33 0.009840

      4 ETW000 [dev trc ,00000] New connection 0 created 22 0.009862

      4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

      4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

      4 ETW000 46 0.009908

      4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 22 0.009930

      4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

      4 ETW000 23 0.009953

      4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

      4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

      4 ETW000 36 0.009989

      4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/TAU/112_64 from environment

      4 ETW000 227 0.010216

      4 ETW000 [dev trc ,00000] Default connection: tnsname ='TAU' 32 0.010248

      4 ETW000 [dev trc ,00000] Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt

      4 ETW000 44 0.010292

      4 ETW000 [dev trc ,00000] -->oci_initialize (con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)

      4 ETW000 28 0.010320

      4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

      4 ETW000 24 0.010344

      4 ETW000 [dev trc ,00000] default client setting: NLS_CHAR=charset='UTF8'

      4 ETW000 5295 0.015639

      4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 21 0.015660

      4 ETW000 [dev trc ,00000] Logon as OPS$-user to get XXXXXX's password 18 0.015678

      4 ETW000 [dev trc ,00000] Connecting as /@TAU on connection 0 (nls_hdl 0) ... (dbsl 640 090311, UNICODE[2])

      4 ETW000 27 0.015705

      4 ETW000 [dev trc ,00000] Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt

      4 ETW000 31 0.015736

      4 ETW000 [dev trc ,00000] 0 UTF8 AL16UTF16 1 0x2290770 0x229bb88 0x229d698

      4 ETW000 27 0.015763

      4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 25 0.015788

      4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.015809

      4 ETW000 [dev trc ,00000] Attaching to DB Server TAU (con_hdl=0,svchp=0x229baa8,srvhp=0x22a0720)

      4 ETW000 43 0.015852

      4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

      4 ETW000 2047 0.017899

      4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error 12541.

      4 ETW000 31 0.017930

      4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 21 0.017951

      4 ETW000 [dev trc ,00000] SAPUSER or connect error rc=99, oerr=12541. 89 0.018040

      4 ETW000 [dblink ,00430] ***LOG BY2=>sql error 12541 performing CON [dblink#6 @ 430]

      4 ETW000 54 0.018094

      4 ETW000 [dblink ,00430] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#6 @ 430]

      4 ETW000 26 0.018120

      2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TAU'"

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.