RE: can't connect locally through Net8

It looks like the tnsnames.ora file is using the alias at to represent the sid lat. You might want to try doing a connect system_at_at and see how that works.

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Scott Shafer
Sent: Sunday, July 09, 2000 12:34 AM
To: Multiple recipients of list ORACLE-L Subject: Re: can't connect locally through Net8

Is the TWO_TASK environment variable set?

What does:

env | grep ORA

show for the ORACLE_* env variables?

Scott Shafer
San Antonio, TX

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, July 08, 2000 7:34 PM

> An error message would be most useful.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>
> -----Original Message-----
> Sent: Friday, July 07, 2000 3:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> 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
> also send the HELP command for other information (like subscribing).

--
Author: Scott Shafer
  INET: scott.shafer_at_ildmail.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