Hi,

I have Oracle8i (8.1.7) installed on Solaris 5.8 machine. After reboot the machine, database will startup automatically, but listener will not start automatically. Got TNS-12541, TNS-12560, TNS-00511 errors.

I checked oratab, dbstart, listener.ora, and tnsnames.ora files and they seem fine. I can start listener manually by issuing 'lsnrctl start'. Does this mean that listener.ora and tnsnames.ora files are good? Also /var/tmp/.oracle was created each time machine was reboot.

I set the listener trace level to user, here is the listener.trc file generated after reboot the machine.

nscon: sending NSPTRF packet
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 4) complete
tnslsnr: connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=tcp)(HOST=dino)(PORT=1521))
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttvlser: valid node check on incoming node 127.0.0.1
nttvlser: Accepted Entry: 127.0.0.1
nttcon: set TCP_NODELAY on 13
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 4) complete
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nscon: sending NSPTRF packet
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 4) complete
nsglecmd: Deallocating cxd 0x130cd0.
nsglecmd: Command specified to exit tnslsnr.
tnslsnr: connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=tcp)(HOST=dino)(PORT=1521))
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 2) complete
nsglhfre: Terminating listening endpoint: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dino)(PORT=1521)))
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 1) complete
nsglhfre: Deallocating cxd 0x101520.

I appreciate any of your advice.

Jiong