Listener could not hand off client connection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Listener could not hand off client connection

  1. #1

    Angry

    Listener could not hand off client connection

    We're runing Oracle 8.1.7.3 on AIX 4.3.3, and on the upgrade road to Oracle 9.0.1
    After I installed the Oracle 9.0.1 software and startup the listener replacing 8.1.7.3 listener, the client can not connect to the database via the Apache HTTP server.
    The client get TNS:12518 and ORA:12560 errors.
    Here is part of the trace file on level=16
    -------------------------------------------------------
    nsglhrem: entry
    nsglhrem: Error - removed cxd 0x1104f51d0 from wrong list.
    nsglhrem: entry
    nsglhrem: exit
    nsglhfre: Terminating listening endpoint: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=commander.sx.com)(PORT=1521)))
    nsdisc: entry
    nsclose: entry
    nstimarmed: entry
    nstimarmed: no timer allocated
    nstimarmed: normal exit
    nsdo: entry
    nsdo: cid=1, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2
    nsdo: rank=64, nsctxrnk=0
    nsdo: nsctx: state=7, flg=0x4202, mvd=0
    nsevunreg: entry
    nsevunreg: cid=1, sgt=0, rdm=0
    nsevunreg: 10 registered connection(s)
    nsevunreg: exit (0)
    nsdo: nsctxrnk=0
    nsdo: normal exit
    nsclose: closing transport
    nttdisc: entry
    nttdisc: Closed socket 10
    nttdisc: exit
    nsclose: global context check-out (from slot 1) complete
    nsnadisc: entry
    nsbfr: entry
    nsbfr: normal exit
    nsmfr: entry
    nsmfr: 2768 bytes at 0x11050fd70
    nsmfr: normal exit
    nsmfr: entry
    nsmfr: 744 bytes at 0x11050f170
    nsmfr: normal exit
    nsclose: normal exit
    nsdisc: exit (0)
    nsglhfre: Deallocating cxd 0x1104f51d0.
    nsglhfre: exit
    nsglhfre: entry
    nsglhrem: entry
    nsglhrem: entry
    nsglhrem: exit
    nsglhfre: Terminating listening endpoint: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    nsdisc: entry
    nsclose: entry
    nstimarmed: entry
    nstimarmed: no timer allocated
    nstimarmed: normal exit
    nsdo: entry
    nsdo: cid=3, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2
    nsdo: rank=64, nsctxrnk=0
    nsdo: nsctx: state=7, flg=0x4202, mvd=0
    nsevunreg: entry
    nsevunreg: cid=3, sgt=0, rdm=0
    nsevunreg: 9 registered connection(s)
    nsevunreg: exit (0)
    nsdo: nsctxrnk=0
    nsdo: normal exit
    nsclose: closing transport
    ntusdisc: entry
    ntusdisc: Closed socket 12
    sntusgph: entry
    sntusgph: exit
    ntusdisc: exit
    nsclose: global context check-out (from slot 3) complete
    nsnadisc: entry
    nsbfr: entry
    nsbfr: normal exit
    nsmfr: entry
    nsmfr: 2768 bytes at 0x110514f30
    nsmfr: normal exit
    nsmfr: entry
    nsmfr: 744 bytes at 0x1105141d0
    nsmfr: normal exit
    nsclose: normal exit
    nsdisc: exit (0)
    nsglhfre: Deallocating cxd 0x110513df0.
    nsglhfre: exit
    -------------------------------------------------------
    I appreciate to any help.
    Thanks.

    Queyon
    Queyon Zeng

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I had the same problem. Oracle's solution was to use two listeners, one for the 9i databases, one for the 8.1.7 databases.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width