[DB-SIG] Oracle Logon Error

[Paul O'Keefe]

|> However, when I try to create a connection object, this happens:

|> >>> ob = oracledb.oracledb("foo/bar")
|> Traceback (innermost last):
|>   File "<stdin>", line 1, in ?
|> OracleDbError: LOGON caused a Error while trying to retrieve text for error ORA-12545


1) use "foo/bar@myhost"		or set TWO_TASK in your environment

2) set ORACLE_HOME and TNS_ADMIN in your environment

Site specific example assuming csh:

setenv ORACLE_HOME      /home/oracle		# wherever Oracle is installed
setenv TNS_ADMIN        $ORACLE_HOME/sqlnet2.1/config	# for SQL*Net 2

I don't think you need to set ORACLE_SID.

3) append $ORACLE_HOME/lib to your LD_LIBRARY_PATH

Paul O'Keefe

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________