Request SQL*Net Experts

From: Pamela Samuels <xyz_at_hotmail.com>
Date: Thu, 17 Jan 2002 01:29:51 GMT
Message-ID: <jOp18.8796$n81.2506800@typhoon.southeast.rr.com>

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

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 Received on Wed Jan 16 2002 - 19:29:51 CST