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 ----- From: "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, July 08, 2000 7:34 PM Subject: RE: can't connect locally through Net8

> 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
Received on Sat Jul 08 2000 - 23:34:11 CDT