-
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
: TNS:could not
resolve the connect identifier specified (DBD ERROR: OCIServerAttach)
Thanks.
Peter
Sounds as though you have hit an issue sharing an env.
I'm not sure as I've not done this myself but you may need to look at
the ora_envhp attribute:
The first time a connection is made a new OCI
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
/local/nz/bin/:.;
my $dbh_inst2 = DBI-connect(dbi:Oracle:inst2, schema, password, {
RaiseError = 1, PrintError = 1});
$dbh_inst1-disconnect();
$dbh_inst2-disconnect();
exit;
Here is the error message:
DBI connect('inst2','schema',...) failed: ORA-12154: TNS:could not
resolve the connect
12 matches
Mail list logo