Listener could not hand off client connection

[Queyon]

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

[marist89]

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.