It might be a problem of privileges on tnsnames.ora ot listener.ora =
files.
Ivo Libal
> -----Urspr=FCngliche Nachricht-----
> Von: Jeffery Stevenson [SMTP:jeff_at_mpv.com]
> Gesendet am: Sonntag, 9. Juli 2000 19:04
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: can't connect locally through Net8
>=20
> 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.
>=20
> Jeffery Stevenson
> Chief Database Geek
> Medical Present Value, Inc.
>=20
>=20
> -----Original Message-----
> Shafer
> Sent: Sunday, July 09, 2000 12:34 AM
> To: Multiple recipients of list ORACLE-L
>=20
>=20
> Is the TWO_TASK environment variable set?
>=20
> What does:
>=20
> env | grep ORA
>=20
> show for the ORACLE_* env variables?
>=20
> Scott Shafer
> San Antonio, TX
>=20
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, July 08, 2000 7:34 PM
>=20
>=20
> > 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 =3D
> > (DESCRIPTION =3D
> > (ADDRESS_LIST =3D
> > (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D localhost)(PORT =3D =
1521))
> > )
> > (CONNECT_DATA =3D
> > (SID =3D lat)
> > )
> > )
> >
> > and my listener.ora is:
> > LISTENER =3D
> > (DESCRIPTION_LIST =3D
> > (DESCRIPTION =3D
> > (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D =
latdev1.concretemedia.com)(PORT
> =3D
> > 1521)
> > )
> > )
> > (DESCRIPTION =3D
> > (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D EXTPROC))
> > )
> > )
> >
> > SID_LIST_LISTENER =3D
> > (SID_LIST =3D
> > (SID_DESC =3D
> > (GLOBAL_DBNAME =3D lat.concretemedia.com)
> > (ORACLE_HOME =3D /u01/app/oracle/product/8.1.6)
> > (SID_NAME =3D lat)
> > )
> > (SID_DESC =3D
> > (PROGRAM =3D extproc)
> > (SID_NAME =3D PLSExtProc)
> > (ORACLE_HOME =3D /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).
>=20
> --
> Author: Scott Shafer
> INET: scott.shafer_at_ildmail.com
>=20
> 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).
>=20
>=20
> --=20
> Author: Jeffery Stevenson
> INET: jeff_at_mpv.com
>=20
> 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
Received on Tue Jul 11 2000 - 05:23:40 CDT
