check if your Linux denies any remote connexion (see /etc/hosts.deny file
for mandrake linux).
"Pamela Samuels" <xyz_at_hotmail.com> wrote in message
news:jOp18.8796$n81.2506800_at_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
>
> 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
>
>
Received on Thu Jan 17 2002 - 12:07:57 CST
