cancel
Showing results for 
Search instead for 
Did you mean: 

Listener not found allthough is working any ideas?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member189725
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thank you wery much - start LISTENER_TAU did the trick (do not know why I did not come to that...)

Br,

Kristjan T.

Answers (1)

Answers (1)

former_member189725
Active Contributor
0 Kudos

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

Regards

Ratnajit

Former Member
0 Kudos

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'"