-
From: David Dooling [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 2:01 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
On Wed, Dec 12, 2007 at 01:28:37PM -0700, Loo, Peter # PHX wrote:
I tried setting both variables
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 2:01 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
On Wed, Dec 12, 2007 at 01:28:37PM -0700, Loo, Peter # PHX wrote:
I tried setting both variables at the very beginning before
Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying to
connect to two different Oracle instances within one program run. The
two Oracle instances are different in versions. inst1 is 9.2 while
inst2 is 10.2. I am able to connect to the
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying
to connect to two different Oracle instances within one program run.
The two
, 2007 1:47 AM
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying
to connect to two different Oracle instances within one program run
# PHX; Martin Evans; dbi-users@perl.org
Subject: RE: ORA-12154: TNS:could not resolve the connect identifier specified
Peter,
Why don't you use one oracle home and set up two tns entries, one for each
instance, in the tnsnames.ora file?
For example: you can set 10.2 as oracle home, in it's
]
Sent: Wednesday, December 12, 2007 3:21 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: RE: ORA-12154: TNS:could not resolve the connect identifier
specified
Hello!
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables
On Thu, Dec 13, 2007 at 01:20:38AM +0300, Alexander V Alekseev wrote:
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables at the very beginning before any
connection is made and the result is still the same.
$ENV{ora_envhp} = 0;
Hello!
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables at the very beginning before any
connection is made and the result is still the same.
$ENV{ora_envhp} = 0;
$ENV{ORA_ENVHP} = 0;
ora_envhp is one of Connect
There's a file named tnsnames.ora file in $ORACLE_HOME/network/admin. Make sure
there is an entry for $dbName there.
Bong
Loo, Peter # PHX [EMAIL PROTECTED] wrote:
Here is what I did:
eval {
$dbh = DBI-connect(dbi:$dbDriver:$dbName, $dbUser, $dbPass,
{ RaiseError = 1, PrintError =
Evans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 1:47 AM
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying
11 matches
Mail list logo