pe.com*
hpesm_pri_grn_pos_email_06
*From:* Mani, Arunkumar (BMS - India GDC)
*Sent:* Tuesday, August 9, 2016 1:54 PM
*To:* 'Howard, Chris' ; Nelson, Erick
; mohammed.must...@wipro.com;
dbi-users@perl.org
*Subject:* RE: ORA-12154 - (DBD: login failed)
Yes.
*Arunkumar Mani
*ITO Service Delivery Consultant
Data
rg
*Subject:* RE: ORA-12154 - (DBD: login failed)
Yes.
*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account
arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305 Office
+91 74062 71026 Mobile
Bangalore, Karnataka/India
*hpe.com*
hpesm_pr
In message , "Mani, Arunkumar (BMS - India GDC)" writes:
>Just following up to see if I can get any help on this.
I saw where you confirmed that tnsping and sqlplus from
your new 10g ORACLE_HOME work against your listeners
and instances.
But did you confirm that you rebuilt your DBD::Oracle agains
pe.com
[hpesm_pri_grn_pos_email_06]
From: Mani, Arunkumar (BMS - India GDC)
Sent: Tuesday, August 9, 2016 1:54 PM
To: 'Howard, Chris' ; Nelson, Erick
; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)
Yes.
Arunkumar Mani
ITO Service Delivery Consultant
Data
o:howa...@prpa.org]
Sent: Monday, August 8, 2016 9:29 PM
To: Mani, Arunkumar (BMS - India GDC) ; Nelson, Erick
; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)
And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other
tools, yes?
From
he database
server also with the hostnames removed.
For giggles, do a tnsping for ECLD.WORLD and post the results.
-Kevin
-Original Message-
From: Christopher Jones [mailto:christopher.jo...@oracle.com]
Sent: Monday, August 08, 2016 7:07 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154
x27;/home/httpd/cgi-bin/oradba';
my $sid = "ECLD.WORLD";
my $usr = "mania2";
my $pas = "blah";
my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;
Output:
bash-2.03$ ./perl_testing1.pl
DBI->connect(tns:ECLD.WORLD
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>]
Sent: Monday, August 08, 2016 5:38 AM
To: Nelson, Erick; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org
<mailto:dbi-use
To: Nelson, Erick; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org
<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)
Instead of @, we define the connection string in TWO_TASK, and
it still looks for tnsnames.ora or sqlnet.or
nnect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;
Output:
bash-2.03$ ./perl_testing1.pl
DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14
ORA-12154: TNS:could
In message , "Mani, Arunkumar (BMS - India GDC)" writes:
>I'll probably explain it with a piece of code and output, so everybody can =
>explain the problem I face clearly.
Assuming that you've confirmed Oracle's tools in your new ORACLE_HOME
can connect to your instances, I doubt you rebuilt DBD::
min/site/lib/perl';
use DBI;
$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';
$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';
my $sid = "ECLD.WORLD";
my $usr = "mania2";
my $pas = "blah";
my $dbh = DBI->connect("dbi:Oracl
> -Original Message-
>> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
>> Sent: Monday, August 08, 2016 5:38 AM
>> To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
>> Subject: RE: ORA-12154 - (DBD: login failed)
>>
>&
Original Message-
> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
> Sent: Monday, August 08, 2016 5:38 AM
> To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> Instead of @, we define
@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)
Instead of @, we define the connection string in TWO_TASK, and it
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.
Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account
arunkumar.m...@hpe.com
+91
t 1:14 AM
To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>"
mailto:mohammed.must...@wipro.com>>,
"dbi-users@perl.org<mailto:dbi-users@perl.org>"
mailto:dbi-users@perl.org>>
Subject: RE: ORA-12154 - (DBD: login failed)
All were done earli
Bangalore, Karnataka/India
hpe.com
-Original Message-
From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]
Sent: Monday, August 8, 2016 5:01 PM
To: Mani, Arunkumar (BMS - India GDC) ;
mohammed.must...@wipro.com; dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)
Did you try
- India GDC) ;
dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)
Testing: Manually, try connecting to DB using current .ora file content.
Solution: update .ora file with right
Ip:
Port:
Sid/service name:
Regards,
Mustafa
+44-7440 56 12 32
__
To: dbi-users@perl.org
Subject: ORA-12154 - (DBD: login failed)
** This mail has been sent from an external source **
Hi,
We have a perl script which is used to connect to all our target databases (
close to 1000) and fetch the user related information and inturn compare it
with our
to right sqlnet.ora.
Need your help to fix this.
ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login
failed)
Perl Version:
bash-2.03$ /usr/local/bin/perl -v
This is perl, version 5.005_03 built for sun4-solaris
Copyright 1987-1999, Larry Wall
Perl may be copied
You would not be able to run about 99% of the test with a Read only account.
There is all sorts of thinge going one , table create drop, insert delete
slecect so a read only client will not cut it.
If the Makefile.PL and the make worked It would be normally quite safe to
ues for simple selectes.
I can connect to the database using sqlplus as user oracle, but not as root.
I can compile DBD::Oracle but not complete the test.
I tried to set variables properly:
ORACLE_HOME=/u/oracle/10.2.0
ORACLE_HOST=hostname
ORACLE_PORT=1522
ORACLE_SID=databasename
ORACLE_USERID=user/passw...@databasename
)
> (CONNECT_DATA =
> (SERVICE_NAME = inst2)
> )
>)
> )
>
> -Original Message-
> 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 res
riginal Message-
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
essage-
> From: Martin 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,
> >
>
"Tim Bunce" <[EMAIL PROTECTED]>
To: "Alexander V Alekseev" <[EMAIL PROTECTED]>
Cc: "Loo, Peter # PHX" <[EMAIL PROTECTED]>;
Sent: Wednesday, December 12, 2007 5:43 PM
Subject: Re: ORA-12154: TNS:could not resolve the connect
identifierspecified
&g
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, PrintEr
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;
>
lekseev [mailto:[EMAIL PROTECTED]
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,
>
&
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
4 PM
To: Loo, Peter # 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 ora
calls can pass in different connection strings to connect to
different instances.
Alan
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 3:29 PM
To: Martin Evans; dbi-users@perl.org
Subject: RE: ORA-12154: TNS:could not resolve t
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.
first instance without
problems, but the instance yields "ORA-12154" error. However, when I
reverse the connection order by connecting the inst2 with 10.2 version
first, then connecting to the inst1 with 9.2 version, there is no error.
I hope someone can shed some lite. Here is the code
problems, but the instance yields "ORA-12154" error. However, when I
reverse the connection order by connecting the inst2 with 10.2 version
first, then connecting to the inst1 with 9.2 version, there is no error.
I hope someone can shed some lite. Here is the code:
#!/usr/bin/perl
use
Have you looked into the Oracle error docs? What happens if you
'tnsping MAINO1'?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Angela Chan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 9:24 AM
To: dbi-users@perl.org
Subject: ORA-12154 message
Hi, all,
Since I can't get Oracle Client 9i ot 10g, I just down grade my PERL to
5.6.1 Build 638, and try to connect to ORACLE 8i. However, I get the
following message:
"DBI connect('MAIN01','owner',...) failed: ORA-12154: TNS:could not resolve
the connect i
>>>>> "Ron" == Ron Reidy <[EMAIL PROTECTED]> writes:
Ron> Can you connect to this database using SQL*Plus in the same manner?
Ron> From the error docs:
Ron> $ oerr ora 12154
Ron> 12154, 0, "TNS:could not resolve service name"
Ron&g
Jeffrey> On 09 Dec 2005 15:37:33 +0200, Claude <[EMAIL PROTECTED]> wrote:
>>
>> I run locally a client script which fails with the following message:
>>
>> ORA-12154: TNS:could not resolve service name (DBD ERROR:
>> OCIServerAttach) at ...
>>
Can you connect to this database using SQL*Plus in the same manner?
>From the error docs:
$ oerr ora 12154
12154, 0, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the followi
wing message:
>
> ORA-12154: TNS:could not resolve service name (DBD ERROR:
> OCIServerAttach) at ...
> DBI::connect('DBI','dbi:Oracle:abc','batman','secret','HASH(0x82d7910)')
> called at ...
>
> The datasource seems ok to
I run locally a client script which fails with the following message:
ORA-12154: TNS:could not resolve service name (DBD ERROR:
OCIServerAttach) at ...
DBI::connect('DBI','dbi:Oracle:abc','batman','secret','HASH(0x82d7910)')
called at ...
Charles Seelig wrote:
- TNS_ADMIN is not set in either the registry or environment.
- Not run by web server; only from the command line.
CS
ora-12154 (tns-12154) means it can't find the service name you
requested. So that means:
1) the service name you requested doesn't exi
n the
script is run from \orant\net80\admin.
When the script is run from anywhere else, I get this error:
ORA-12154: TNS:could not resolve the connect identifier specified
(DBD ERROR: OCIServerAttach)
Note that printf("%s\n", $ENV{'ORACLE_HOME'});
displays c:\orant
SqlPlus connection works fine.
>
>A perl script attempting connection works fine ONLY when the
>script is run from \orant\net80\admin.
>
>When the script is run from anywhere else, I get this error:
>
>ORA-12154: TNS:could not resolve the connect identifier s
run from \orant\net80\admin.
When the script is run from anywhere else, I get this error:
ORA-12154: TNS:could not resolve the connect identifier specified
(DBD ERROR: OCIServerAttach)
Note that printf("%s\n", $ENV{'ORACLE_HOME'});
displays c:\orant (as expected).
H
> }
> sub openconnection {
> $dbh = DBI->connect($connect,$login,$passwd,{RaiseError => 1, AutoCommit =>
> 1}) or die "Cannot connect to database";
> }
>
> sub closeconnection {
> $sth->finish;
> $dbh->disconnect;
> }
&
This should be on the dbi-users list. Are you sure all of the
environment variables are set? Can you show the code? The
ORA-12154 is TNS error,
12154, 0, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAME
On Tue, Aug 03, 2004 at 04:06:17PM -0500, Scott T. Hildreth wrote:
> This should be on the dbi-users list.
So anyone replying should edit the CC to only include [EMAIL PROTECTED]
Thanks.
Tim.
49 matches
Mail list logo
