> On May 12, 2016, at 4:12 AM, Jefferson Elias <jefferson.el...@chu.ulg.ac.be>
> wrote:
>
> Hi,
>
> I've been trying many differents things with the following error, but nothing
> seems to be working.
>
>
> Let me start to explain my problem from the beginning.
>
> (Perl version: v5.10.)
>
> I use a configuration file that I parse using Config::General::ParseConfig.
> This file is encoded in UTF8 as shown below:
>
> $ file config/application.conf
> config/application.conf: UTF-8 Unicode English text
>
>
> In this configuration file, there is a field called
> 'target_db_list_default_password' which contains a default password to be
> used for my monitoring.
> This password is then used in conjunction with DBI->connect() method
> primarily to contact an Oracle Database instance.
>
> I always get the following message at execution:
>
> Perl Error message: DBI connect('MY_DB','halfonz',...) failed:
> ORA-01017: invalid username/password;
> logon denied (DBD ERROR: OCISessionBegin) at
> /home/jeff.elias/Projects/DBA_SOURCES/branches/develop-next/Templates/Projet
> Perl simple/src/libs/Common/DbConnection.pm line 210
>
>
> The password cannot be changed that easily. I've printed out the password I
> get back and copy-pasted it into a SQL Developer new connection dialog then
> tried to connect and it worked.
> So, my conclusion is that the password can be considered as the OK.
Make sure the Oracle environment variables, particularly the SID are the same
for both SQL Developer and in your perl application; perhaps the config file is
pointing to the wrong DB? (a development versus production thing? )
remotely it MIGHT be default NLS_LANG thing, but I don’t think so.
A quick test would be to connect to the DB with hardcoded credentials in a test
perl script? This will determine whether it’s perl/DBI or encoding issues from
the config file.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
