Re: help to connect

Are you sure Oracle is expecting UTF8 for the password? Because it works
without accented chars in the password, the simplest thing might be to
change to a password without encoding issues.

On Thu, May 12, 2016 at 10:38 AM, Bruce Johnson <
[email protected]> wrote:

>
> > On May 12, 2016, at 4:12 AM, Jefferson Elias <
> [email protected]> 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
>
>


-- 
"Why would you want to be the last man alive on a sinking ship?" -- Elon
Musk