Skip to Content
avatar image
Former Member

Failure to Start Oracle Listener after applying Oracle Patch

Hi all ,

I'm having problem after upgrading to 10.2, patch level 15 .

Before applying the patch everything went well. The server is hosting 2 instance D02-ECC6 and BID- BI .

I'm a newbie in oracle , hope someone that faced this issue before and managed to solve this issue before can shed some light how to solve it .

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

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

64-bit Windows Error: 2: No such file or directory

07-SEP-2007 20:37:19 * (CONNECT_DATA=(SID=D02)(GLOBAL_NAME=D02.WORLD)(CID=(PROGRAM=D:\usr\sap\D02\DVEBMGS00\exe\disp+work.EXE)(HOST=ACMSAPD02)(USER=OraUser))

For BID - BI Instance

tarted with pid=3596

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\BID.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\BIDipc)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ACMSAPD02)(PORT=1528))

TNS-12542: TNS:address already in use

TNS-12560: TNS:protocol adapter error

TNS-00512: Address already in use

64-bit Windows Error: 48: Unknown error

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\BID.WORLDipc)))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\BIDipc)))

TNSLSNR for 64-bit Windows: Version 10.2.0.2.0 - Production on 26-SEP-2007 02:04:37

Thank You

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 27, 2007 at 10:08 AM

    Hi Sallehudin,

    This is clearly a problem of Port Conflict for listner service.

    while checking output of tnsping command port shown is 1521

    and in your error log shows it is attempting to start listner on port 1528.

    Change the port for your listner service.

    Hope this is useful

    Regards

    Umesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Did you restart the listener?

      Could you log on to the database as sysdba like that?

      sqlplus /nolog

      connect / as sysdba

      How ist the PATH Variable set?

      Do you have any Oracle clients on this OS?

      Best regards

  • avatar image
    Former Member
    Sep 27, 2007 at 07:32 AM

    Hello Sallehudin,

    Could you please check if the OracleService<DBSID> is started?

    Which error do you get, if you execute this command?

    LSNRCTL> services <listener name>

    How is the DB Parameter processes set? Can you ping the database? tnsping <DBSID>

    Best regards

    Baran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Here’s the result of r3trans –x, there’s error when running the command..

      For BIDADM

      C:\Documents and Settings\bidadm>r3trans -x

      This is r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

      unicode enabled version

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

      ra_tnsname = 'BID'"

      r3trans finished (0012).

      C:\Documents and Settings\bidadm>

      For D02ADM

      C:\Documents and Settings\d02adm>r3trans -x

      This is r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

      unicode enabled version

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

      ra_tnsname = 'D02'"

      r3trans finished (0012).

  • avatar image
    Former Member
    Sep 28, 2007 at 01:29 AM

    I am working with sallehuddin on this

    After change tnsname.ora listener.ora and sqlnet.ora it still pointing to host 202.75.47.122 port 1521 instead of 192.168.4.7 port 1528

    BELOW WAS THE OUTPUT

    SQL> connect / as sysdba

    Connected to an idle instance.

    SQL> startup

    ORACLE instance started.

    Total System Global Area 679477248 bytes

    Fixed Size 2056000 bytes

    Variable Size 348127424 bytes

    Database Buffers 322961408 bytes

    Redo Buffers 6332416 bytes

    Database mounted.

    Database opened.

    SQL> select status from v$instance;

    STATUS

    -


    OPEN

    SQL>

    <b>LISTENER OUTPUT</b>

    LSNRCTL> STATUS BID

    Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=BID.com.my))(ADDRESS=(PRO

    TOCOL=TCP)(HOST=202.75.47.122)(PORT=1521)))

    TNS-12541: TNS:no listener

    TNS-12560: TNS:protocol adapter error

    TNS-00511: No listener

    64-bit Windows Error: 61: Unknown error

    <b>TNSPING OUTPUT</b>

    D:\oracle\BID\102\BIN>tnsping BID

    TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 28-SEP-2

    007 09:24:29

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

    Used parameter files:

    D:\usr\sap\BID\SYS\profile\oracle\sqlnet.ora

    Used TNSNAMES adapter to resolve the alias

    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

    .WORLD) (PROTOCOL = TCP) (HOST = ACMSAPD02) (PORT = 1528))) (CONNECT_DATA = (CON

    NECT_DATA = (SERVICE_NAME=BID) (ADDRESS = (PROTOCOL = TCP) (HOST = ACMSAPD02) (P

    ORT = 1528)))

    TNS-12533: TNS:illegal ADDRESS parameters

    D:\oracle\BID\102\BIN>

    <b>Profile parameter setting</b>

    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 $

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

    BID.WORLD=

    (DESCRIPTION =

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ACMSAPD02)

    (PORT = 1528)

    )

    )

    (CONNECT_DATA =

    (CONNECT_DATA =

    (SERVICE_NAME=BID)

    (ADDRESS =

    (PROTOCOL = TCP)

    (HOST = ACMSAPD02)

    (PORT = 1528)

    )

    )

    LISTENER.ORA

    LISTENER =

    (ADDRESS_LIST=

    (ADDRESS=(PROTOCOL=tcp)(HOST=ACMSAPDEV02)(PORT=1528))

    (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

    1. SID_LIST_<lsnr>

    List of services the listener knows about and can connect

    clients to. There is no default. See the Net8 Administrator's

    Guide for more information.

    SID_LIST_LISTENER=

    (SID_LIST=

    (SID_DESC=

    #BEQUEATH CONFIG

    (GLOBAL_DBNAME=BID.SAP)

    (SID_NAME=BID)

    (ORACLE_HOME=D:\oracle\BID\102)

    #PRESPAWN CONFIG

    (PRESPAWN_MAX=20)

    (PRESPAWN_LIST=

    (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))

    )

    )

    )

    SQLNET.ORA

    AUTOMATIC_IPC = ON

    TRACE_LEVEL_CLIENT = OFF

    NAMES.DEFAULT_DOMAIN = WORLD

    1. 05.01.06 unsorported parameter now

    #NAME.DEFAULT_ZONE = WORLD

    1. 05.01.06 set the default to 10

    SQLNET.EXPIRE_TIME = 10

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    1. 05.01.06 set to default

    #TCP.NODELAY=YES

    1. 05.01.06 set to 32768

    DEFAULT_SDU_SIZE=32768

    Remarks: TNS_ADMIN point to D:\usr\sap\BID\SYS\profile\oracle<u></u><u></u><u></u>

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      you can unset TNS_ADMIN and try again to start the listener for BID?

      Before starting the listener, rename the listener.log and create a new listener.log (D:\oracle\BID\102\network\log)

      Do you have a sqlnet.ora D:\oracle\BID\102\network\admin

      check please environment settings according to the SAP 556232 - Environment settings for R/3/Oracle on Windows

      best regards

  • avatar image
    Former Member
    Sep 27, 2007 at 07:36 AM

    Hi Yusuf,

    Have you rebooted the OS after patch install.?

    Hari.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2007 at 01:33 AM

    The above output refer to BID

    Add comment
    10|10000 characters needed characters exceeded