[cx-oracle-users] Logging-in without password

[Damien T. <dt...@ba...>]

Hello,

I am trying to login to a local Oracle instance without a password. Our 
DBA has setup our Linux environment (ORACLE_HOME, ORACLE_SID, etc.) such 
that all I have to do is type the following on the command line:

sqlplus /

And I am automatically logged-in to the instance I want.

When I try to do the same thing from within python, I connect using the 
following:

con = cx_Oracle.connect()

I don't get any errors, but the dsn (from printing the contents of 
con.dsn) is None.

If I try to specifiy a dsn:

con = cx_Oracle.connect(dsn = 'XYZ')

I get the following error:

x_Oracle.DatabaseError: ORA-01017: invalid username/password; logon denied

So, something is not right, but it is not clear to me what that is. Can 
anyone offer any insight? Is it possible to login to an Oracle instance 
with cx_Oracle without supplying a username/password?

Thanks for your help.

-- 
Damien Tougas
Programmer/Analyst
Internet Software Services
Bates College