Re: Request SQL*Net Experts

On Thu, 17 Jan 2002 01:29:51 GMT, "Pamela Samuels" <xyz_at_hotmail.com> wrote:

>I have been trying to configure an Oracle 9i instance on a linux
>server, and am having trouble connecting, both from Windows and Linux.
>I can tnsping the instance from Windows, though I am not up on my
>SQL*Net, and I am wondering if any errors jump out at anyone. I've
>been looking at it for days, and am about to resign in shame and
>disgust.
>
>
>
>
>
>
>
>
>
>TNSNAMES.ORA on Windows Client
>TESTDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = laquinta)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = TESTDB)
> )
> )
>
>
>
>
>
>
>
>oracle_at_laquinta:/usr/oracle/9.0/network/admin > cat sqlnet.ora
># SQLNET.ORA Network Configuration File:
>/usr/oracle/9.0/network/admin/sqlnet.or
>a
># Generated by Oracle configuration tools.
>
>NAMES.DEFAULT_DOMAIN = samuels.com
>
>NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
>
>
>
>oracle_at_laquinta:/usr/oracle/9.0/network/admin > cat listener.ora
># LISTENER.ORA Network Configuration File:
>/usr/oracle/9.0/network/admin/listene
>r.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = laquinta.samuels.com)(PORT =
>1521))
> )
>
>TRACE_LEVEL_LISTENER = USER
>
>
>
>
>
>
>
>
>oracle_at_laquinta:/usr/oracle/9.0/network/admin > cat tnsnames.ora
># TNSNAMES.ORA Network Configuration File:
>/usr/oracle/9.0/network/admin/tnsname
>s.ora
># Generated by Oracle configuration tools.
>
>TESTDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = laquinta)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = TESTDB)
> )
> )
>
>
>
>
>
>oracle_at_laquinta:/usr/oracle/9.0/network/admin > lsnrctl start
>
>LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 16-JAN-2002
>20:13:00
>
>Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
>
>Starting /usr/oracle/9.0/bin/tnslsnr: please wait...
>
>TNSLSNR for Linux: Version 9.0.1.0.0 - Production
>System parameter file is /usr/oracle/9.0/network/admin/listener.ora
>Log messages written to /usr/oracle/9.0/network/log/listener.log
>Trace information written to
>/usr/oracle/9.0/network/trace/listener.trc
>Listening on:
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=laquinta.samuels.com)(PORT=1
>521)))
>
>Connecting to
>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=laquinta.samuels.com)(PORT=1
>521)))
>STATUS of the LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for Linux: Version 9.0.1.0.0 -
>Production
>Start Date 16-JAN-2002 20:13:00
>Uptime 0 days 0 hr. 0 min. 0 sec
>Trace Level user
>Security OFF
>SNMP OFF
>Listener Parameter File /usr/oracle/9.0/network/admin/listener.ora
>Listener Log File /usr/oracle/9.0/network/log/listener.log
>Listener Trace File /usr/oracle/9.0/network/trace/listener.trc
>Listening Endpoints Summary...
>
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=laquinta.samuels.com)(PORT=1
>521)))
>The listener supports no services
>The command completed successfully
>
>
>
>
>
>oracle_at_laquinta:/usr/oracle/9.0/network/trace > tail listener.trc
>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 192.168.1.252
>nttvlser: Accepted Entry: 192.168.1.252
>nttcon: set TCP_NODELAY on 12
>nsopen: transport is open
>nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
>nsopen: global context check-in (to slot 3) complete
>nsanswer: deferring connect attempt; at stage 5
>nscon: doing connect handshake...
>nscon: got NSPTCN packet
>nsevdansw: exit
>nscon: sending NSPTAC packet
>nscon: doing connect handshake...
>nscon: nsctxinf[0]=0x4d, [1]=0x9
>nsconbrok: asking transport to enable NTOBROKEN
>nsevdansw: exit
>nsdo: 3944 bytes from NS buffer
>nsglgrDoRegister: Creating new instance: "TESTDB".
>nsglgrDoRegister: Creating new service: "MODOSE".
>nsglgrDoRegister: Creating new service: "TESTDB.laquinta".
>nsglgrDoRegister: Creating new handler: "D002".
>nsglgrDoRegister: Creating new handler: "D001".
>nsglgrDoRegister: Creating new handler: "D000".
>nsglgrDoRegister: Creating new handler: "DEDICATED".
>nsdo: 380 bytes to NS buffer
>

• No definition of the IPC protocol in listener.ora
• node name mismatch between tnsnames.ora on the client and on the server
• reference to (sid=) in tnsnames.ora on the client, while a corresponding definition doesn't exist in listener.ora Just make sure you are precise. It is not that difficult! It only requires you are accurate

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 16 2002 - 23:56:12 CST