| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: connect to the databases without using tnsnames.ora?
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C255CA.904DD590"
------_=_NextPart_001_01C255CA.904DD590
Content-Type: text/plain;
charset="iso-8859-1"
No it does not.
try the following from the command line
(with no tnsnames.ora file)
(substitute valid values for machine, port, sid, etc)
sqlplus
username@(description=(address=(protocol=tcp)(host=machine1)(port=1521))(con
nect_data=(sid=sid1)))
it will work.
A similar syntax can be used in defining database links, by passing all need for tnsnames.ora file
-----Original Message-----
Sent: Friday, September 06, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
What do you mean by "mistakenly require a TNSNAMES.ORA file" ? The TNSNAMES.ORA file is required unless you are using either of
Hemant
At 06:38 AM 06-09-02 -0800, you wrote:
>As an FYI, some 3rd-party products still mistakenly require a TNSNAMES.ORA
>file. Quest's QCO (at least 2.0, haven't D/L'd 2.1 yet and Quest Support
>tells me it will be fixed in 3.0 next Q1) is one of them.
>
>Also, there is at least one circumstance that requires a TNSNAMES.ORA on a
>server. I can't remember for the life of me what it is, but something with
>the Intelligent Agent sticks in my head.
>
>Rich Jesse System/Database Administrator
>Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI
USA
>
>-----Original Message-----
>Sent: Thursday, September 05, 2002 10:28 PM
>To: Multiple recipients of list ORACLE-L
>
>
> > -----Original Message-----
> > From: CC Harvest [mailto:ccharvest_at_yahoo.com]
> >
> > Does anyone here knows how to setup the connections to
> > the database server without using tnsnames.ora?
> >
> > Our DBA didn't use it. But I don't know how and why?
> > Could anyone tell me the other options?
>
>
>To add to what other posters have said:
>If the DBA was indeed using Oracle Names, you would see the configuration
>parameters for the names server in the sqlnet.ora file, which would be in
>the same directory where you would expect to find the tnsnames.ora file.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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).
Hemant K Chitale
Now using Eudora Email. Try it !
My home page is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: hkchital_at_singnet.com.sg 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). ------_=_NextPart_001_01C255CA.904DD590 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.19"> <TITLE>RE: connect to the databases without using tnsnames.ora?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>No it does not.</FONT> </P> <P><FONT SIZE=3D2>try the following from the command line </FONT> <BR><FONT SIZE=3D2>(with no tnsnames.ora file)</FONT> <BR><FONT SIZE=3D2>(substitute valid values for machine, port, sid, = etc)</FONT> </P> <BR> <P><FONT SIZE=3D2>sqlplus = username@(description=3D(address=3D(protocol=3Dtcp)(host=3Dmachine1)(por= t=3D1521))(connect_data=3D(sid=3Dsid1)))</FONT> </P> <P><FONT SIZE=3D2>it will work.</FONT> </P> <P><FONT SIZE=3D2>A similar syntax can be used in defining database = links, by passing all</FONT> <BR><FONT SIZE=3D2>need for tnsnames.ora file</FONT> </P> <P><FONT SIZE=3D2>----</FONT> <BR><FONT SIZE=3D2>Matt Adams - GE Appliances - = matt.adams_at_appl.ge.com</FONT> <BR><FONT SIZE=3D2>Their fundamental design flaws are completely</FONT> <BR><FONT SIZE=3D2>hidden by their superficial design flaws.</FONT> <BR><FONT = SIZE=3D2> - = Douglas Adams</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Hemant K Chitale [<A = HREF=3D"mailto:hkchital_at_singnet.com.sg">mailto:hkchital_at_singnet.com.sg</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, September 06, 2002 12:59 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: connect to the databases without using = tnsnames.ora?</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>What do you mean by "mistakenly require a = TNSNAMES.ORA file" ?</FONT> <BR><FONT SIZE=3D2>The TNSNAMES.ORA file is required unless you are = using either of</FONT> <BR><FONT SIZE=3D2> a) Oracle Names</FONT> <BR><FONT SIZE=3D2> b) Thin Java client</FONT> </P> <P><FONT SIZE=3D2>Hemant</FONT> </P> <P><FONT SIZE=3D2>At 06:38 AM 06-09-02 -0800, you wrote:</FONT> <BR><FONT SIZE=3D2>>As an FYI, some 3rd-party products still = mistakenly require a TNSNAMES.ORA</FONT> <BR><FONT SIZE=3D2>>file. Quest's QCO (at least 2.0, haven't = D/L'd 2.1 yet and Quest Support</FONT> <BR><FONT SIZE=3D2>>tells me it will be fixed in 3.0 next Q1) is one = of them.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Also, there is at least one circumstance that = requires a TNSNAMES.ORA on a</FONT> <BR><FONT SIZE=3D2>>server. I can't remember for the life of = me what it is, but something with</FONT> <BR><FONT SIZE=3D2>>the Intelligent Agent sticks in my head.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Rich = Jesse &= nbsp; &= nbsp; System/Database Administrator</FONT> <BR><FONT = SIZE=3D2>>Rich.Jesse_at_qtiworld.com = Quad/Tech International, = Sussex, WI USA</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>>Sent: Thursday, September 05, 2002 10:28 = PM</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> > -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> > From: CC Harvest [<A = HREF=3D"mailto:ccharvest_at_yahoo.com">mailto:ccharvest_at_yahoo.com</A>]</FON= T> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Does anyone here knows how to setup the = connections to</FONT> <BR><FONT SIZE=3D2>> > the database server without using = tnsnames.ora?</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Our DBA didn't use it. But I don't know = how and why?</FONT> <BR><FONT SIZE=3D2>> > Could anyone tell me the other = options?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>To add to what other posters have said:</FONT> <BR><FONT SIZE=3D2>>If the DBA was indeed using Oracle Names, you = would see the configuration</FONT> <BR><FONT SIZE=3D2>>parameters for the names server in the = sqlnet.ora file, which would be in</FONT> <BR><FONT SIZE=3D2>>the same directory where you would expect to = find the tnsnames.ora file.</FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Author: Jesse, Rich</FONT> <BR><FONT SIZE=3D2>> INET: = Rich.Jesse_at_qtiworld.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>Hemant K Chitale</FONT> <BR><FONT SIZE=3D2>Now using Eudora Email. Try it !</FONT> </P> <P><FONT SIZE=3D2>My home page is : <A = HREF=3D"http://hkchital.tripod.com" = TARGET=3D"_blank">http://hkchital.tripod.com</A></FONT> </P> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Hemant K Chitale</FONT> <BR><FONT SIZE=3D2> INET: hkchital_at_singnet.com.sg</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C255CA.904DD590-- ------=_NextPartTM-000-72373af5-7cf5-4b62-88c9-66108ea370e2-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adams, Matthew (GEA, MABG, 088130) INET: MATT.ADAMS_at_APPL.GE.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).Received on Fri Sep 06 2002 - 13:36:53 CDT
 |
 |