Skip to Content
avatar image
Former Member

Listener port is wrong because of which R3trans is failing

Hi Experts ,

I have installed a new SRM system on which after stopstart i can see that the listener port is 1521 instead of the port given during install as 1536 .

trans.log ::::::::::::::::::::::::

4 ETW000 50 0.493642

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1254 1' 33 0.493675

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 12541 30 0.493705

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=12541) 31 0.493736

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 12541 71 0.493807

4 ETW000 [dev trc ,00000] ORA-12541: TNS:no listener

4 ETW000 50 0.493857

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dbl ink#7 @ 431] 86 0.493943

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#7 @ 431] 33 0.493976

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o ra_tnsname = 'DS4'"

R3trans -d::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

ngdhydaix4:orads4 14> R3trans -d

This is R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

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

R3trans finished (0012).

TNSNAMES.ORA :::::::::::::::::::::::::::::::::::::

  1. cat tnsnames.ora

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

  1. Filename......: tnsnames.ora

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

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

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

DS4.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = xxxxxxxxx4)

(PORT = 1536)

)

)

(CONNECT_DATA =

(SID = DS4)

(GLOBAL_NAME = DS4.WORLD)

)

)

Listener.ora ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

  1. cat listener.ora

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

  1. Filename......: listener.ora

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

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER_DS4 = on

LISTENER_DS4 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DS4.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DS4)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = xxxxxxxx4)

(PORT = 1536)

)

)

STARTUP_WAIT_TIME_LISTENER_DS4 = 0

CONNECT_TIMEOUT_LISTENER_DS4 = 10

TRACE_LEVEL_LISTENER_DS4 = OFF

SID_LIST_LISTENER_DS4 =

(SID_LIST =

(SID_DESC =

(SID_NAME = DS4)

(ORACLE_HOME = /oracle/DS4/102_64)

orads4 15> lsnrctl status:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 15-OCT-2009 15:24:17

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

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

STATUS of the LISTENER

-


Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

Start Date 15-OCT-2009 15:06:04

Uptime 0 days 0 hr. 18 min. 12 sec

Trace Level off

Security ON: Local OS Authentication

SNMP ON

Listener Parameter File /oracle/DS4/102_64/network/admin/listener.ora

Listener Log File /oracle/DS4/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXXXXX4)(PORT=1521)))

The listener supports no services

The command completed successfully

where is it gettign the port from . Please advise .

Thanks in advance .

Jay .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2009 at 02:45 PM

    Hi Juan ,

    Yes i checked the right listener.ora ..

    Please find it attached .

    orads4 18> cat listener.ora

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

    1. Filename......: listener.ora

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

    3. Name..........:

    4. Date..........:

    5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

    ADMIN_RESTRICTIONS_LISTENER_DS4 = on

    LISTENER_DS4 =

    (ADDRESS_LIST =

    (ADDRESS =

    (PROTOCOL = IPC)

    (KEY = DS4.WORLD)

    )

    (ADDRESS=

    (PROTOCOL = IPC)

    (KEY = DS4)

    )

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = xxxxxxxxx)

    (PORT = 1536)

    )

    )

    STARTUP_WAIT_TIME_LISTENER_DS4 = 0

    CONNECT_TIMEOUT_LISTENER_DS4 = 10

    TRACE_LEVEL_LISTENER_DS4 = OFF

    SID_LIST_LISTENER_DS4 =

    (SID_LIST =

    (SID_DESC =

    (SID_NAME = DS4)

    (ORACLE_HOME = /oracle/DS4/102_64)

    )

    )

    Thanks ,

    Jay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The name of your listener is LISTENER_DS4 and not LISTENER.

      So try this:

      lsnrctl status LISTENER_DS4

      PS:

      And you will have to start it like this:

      lsnrctl start LISTENER_DS4

      Edited by: Joe Bo. on Oct 15, 2009 5:13 PM

  • Oct 15, 2009 at 02:36 PM

    Are you sure you edited the right listener.ora?...

    Listener Parameter File /oracle/DS4/102_64/network/admin/listener.ora

    Check /oracle/DS4/102_64/network/admin/listener.ora

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 03:42 PM

    Hi, what's in your tnsnames.ora.

    Mark

    Add comment
    10|10000 characters needed characters exceeded