Specifying a Connection by Using an Empty Connect String and the LOCAL
Variable
You can set the connect string to an empty connect string (""), and then set the
LOCALenvironment variable to one of the following values:
■
A direct address, as described under "Specifying a Connection by Using DirectAddressing"
on page 4-3■
Oracle Net keyword-value pair■
A tnsnames.ora entry and TNS_ADMIN is set to the location oftnsnames.ora
■
A tnsnames.ora entry and the following:–
tnsnames.ora file located in ORACLE_HOME/network/admin–
The ORACLE_HOME environment variable set to this Oracle homeThis method allows your applications to specify internally a connection string if the
application code itself uses an empty connection string. The benefit of an empty
connect string is that the application itself does not need to specify the
tnsnames.ora
entry. Instead, when a user invokes the application, the location of thedatabase is determined by a script or the environment, depending on where you have
set the
LOCAL environment variable. The disadvantage of using empty strings is thatyou need to configure this additional information in order for your application to
connect to the database.
From: "Action Request System discussion list(ARSList)" <[email protected]> [mailto:"Action Request System discussion list(ARSList)" <[email protected]>] On Behalf Of Rick Phillips <[EMAIL PROTECTED]>
Sent: Tuesday, 6 February 2007 3:59 AM
To: [email protected]
Subject: Re: Problems connecting to Oracle following 10g client install...
new 10g \Network\Admin folder, but am still getting the same error.
tnsping shows the correct use of sqlnet.ora and tnsnames.ora, so that
looks good.
Not sure what to try next.
rp
On Feb 5, 12:13 pm, "Grooms, Frederick W" <[EMAIL PROTECTED]>
wrote:
> Usually each client has it's own tnsnames.ora file. Check the
> copy the 9i one into the 10g folder.
>
> Fred
>
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
>
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips
> Sent: Monday, February 05, 2007 11:03 AM
> To: [EMAIL PROTECTED]
> Subject: Problems connecting to Oracle following 10g client install...
>
> Hello all,
>
> Windows 2000 AS
> Ora 9i
> ARS 5.1.2 upgraded to 7.0.1
>
> I installed the 10g client, but am unable to start arserver following
> the 7.0.1 upgrade. Found no errors in the install log, but found the
> following in the arerror.log
>
> Mon Feb 05 11:13:38 2007 ORA-06401: NETCMN: invalid driver
> designator
>
> Mon Feb 05 11:13:38 2007 390600 : Cannot initialize contact with SQL
> database (ARERR 551)
>
> Mon Feb 05 11:13:38 2007 Stop server
>
> Mon Feb 05 11:13:38 2007 390600 : AR System server terminated -- fatal
> error encountered (ARNOTE 21)
>
> I can connect via SQL Plus as ARAdmin.
>
> I have my old 9i client installed, and tnsnames.ora is in the 9i path.
> Was the 10g client installation supposed to create a new or modify the
> old tnsnames.ora file?
>
> Tia,
>
> Rick
>
> ___________________________________________________________________________?____
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are"- Hide quoted text -
>
> - Show quoted text -
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
--
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
--
__20060125_______________________This posting was submitted with HTML in it___
