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
|
