| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Request SQL*Net Experts
Hello Pamela,
your listener.ora file miss the following statement:
Pamela Samuels schrieb:
> 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
>
....
>
> 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))
> )
>
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TESTDB)
(ORACLE_HOME = /u01/.....)
(SID_NAME = TESTDB)
>
> 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)))
You can see it here:
>
> The listener supports no services
Received on Mon Jan 21 2002 - 09:20:28 CST
 |
 |