Listener port is wrong because of which R3trans is failing

[Former Member]

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 .

[Former Member · Accepted solution]

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

[JPReyes · Accepted solution]

Moved to SAP on Oracle, you probably will get a better answer here.

regards

Juan

[Former Member · Accepted solution]

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

[Former Member]

Hi, what's in your tnsnames.ora.

Mark

[JPReyes]

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