Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long 
It has been so long since it happened I might be (mis)remembering that 
the periods were in the path to java being used by the installer(?).


Jeff

On 08/16/2016 05:51 PM, Jeff Long wrote:

Does your current ORACLE_HOME have periods in it?  If so the periods
could possibly cause the problem.  I have seriously been unable to do
things with certain versions of Oracle on certain operating systems when
there were periods in the directory path.  Getting rid of the periods
made everything work immediately.

Jeff Long


On 08/10/2016 10:40 PM, Mani, Arunkumar (BMS - India GDC) wrote:

Just following up to see if I can get any help on this.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com 
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.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
Database Engineering, BMS Account

arunkumar.m...@hpe.com 
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Howard, Chris [mailto:howa...@prpa.org]
*Sent:* Monday, August 8, 2016 9:29 PM
*To:* Mani, Arunkumar (BMS - India GDC) mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
mailto:erick.nel...@hdsupply.com>>;
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:*Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
*Sent:* Monday, August 08, 2016 9:37 AM
*To:* Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com
; dbi-users@perl.org

*Subject:* RE: ORA-12154 - (DBD: login failed)

I'll probably explain it with a piece of code and output, so everybody
can explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g
client. After that it couldn’t resolve the TNS connection string.

_Perl code with 8i client - works:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/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) failed: ORA-01017: invalid
username/password; logon denied (DBD: login failed) at
./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed)
at ./perl_testing1.pl line 14.

bash-2.03$

_Perl code with 10g client - not working:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/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: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 not resolve the connect identifier specified (DBD:
login failed) at ./perl_testing1.pl line 14.

bash-2.03$

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com 

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com ;
dbi-users@perl.org 
Subject: RE: ORA-12154 - (DBD: login failed)

ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)

-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 the connection string in TWO_TASK,
and it still looks for tnsnames.ora or sqlnet.ora for resolution and it
fa

Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long 
Does your current ORACLE_HOME have periods in it?  If so the periods 
could possibly cause the problem.  I have seriously been unable to do 
things with certain versions of Oracle on certain operating systems when 
there were periods in the directory path.  Getting rid of the periods 
made everything work immediately.


Jeff Long


On 08/10/2016 10:40 PM, Mani, Arunkumar (BMS - India GDC) wrote:

Just following up to see if I can get any help on this.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com 
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.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
Database Engineering, BMS Account

arunkumar.m...@hpe.com 
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Howard, Chris [mailto:howa...@prpa.org]
*Sent:* Monday, August 8, 2016 9:29 PM
*To:* Mani, Arunkumar (BMS - India GDC) mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
mailto:erick.nel...@hdsupply.com>>;
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:*Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
*Sent:* Monday, August 08, 2016 9:37 AM
*To:* Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com
; dbi-users@perl.org

*Subject:* RE: ORA-12154 - (DBD: login failed)

I'll probably explain it with a piece of code and output, so everybody
can explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g
client. After that it couldn’t resolve the TNS connection string.

_Perl code with 8i client - works:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/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) failed: ORA-01017: invalid
username/password; logon denied (DBD: login failed) at
./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed)
at ./perl_testing1.pl line 14.

bash-2.03$

_Perl code with 10g client - not working:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/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: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 not resolve the connect identifier specified (DBD:
login failed) at ./perl_testing1.pl line 14.

bash-2.03$

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com 

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com ;
dbi-users@perl.org 
Subject: RE: ORA-12154 - (DBD: login failed)

ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)

-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 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 80 338 59305  Office

+91 74062 7102