Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: can't connect locally through Net8

Re: can't connect locally through Net8

From: Scott Shafer <scott.shafer_at_ildmail.com>
Date: Fri, 7 Jul 2000 16:47:05 -0500
Message-Id: <10551.111484@fatcity.com>


Is the listener running? Type

lsnrctl status

at the linux command prompt.

--Scott

> I can connect remotely from other tools (Toad, Oracle for NT), and I can
> connect by just typing:
>
> connect system/manager ...
>
>
>
> but if I try to connect through:
>
> connect system_at_lat
>
> I lose - and it fails.
>
>
> My SID is lat, and i defined my tnsnames.ora as:
>
>
> AT.CONCRETEMEDIA.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = lat)
> )
> )
>
> and my listener.ora is:
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = latdev1.concretemedia.com)(PORT =
> 1521)
> )
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = lat.concretemedia.com)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.6)
> (SID_NAME = lat)
> )
> (SID_DESC =
> (PROGRAM = extproc)
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.6)
> )
> )
>
>
> But alas - I cannot get there from the local machine. It is 8.1.6 on
redhat
> 6.2 ....
>
> any ideas out there?
>
>
> thanks
>
> adam
>
>
>
> --
> Author: Adam Turner
> INET: ATurner_at_concretemedia.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Jul 07 2000 - 16:47:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US