I am having a problem using DBI to connect to an Oracle 9i database.
We have a script that loops thru a global tnsnames.ora file that contains
all our databases. The script connects to each database. We have Oracle
8.1.7.4 databases and 9.2 databases. I changed the script to use the same
connect string for both version of Oracle.
When I added the following code to the connect string, I can connect to 9.2
databases, but I can't connect to the some 8.1.7.4 database. For the
databases I can't connect to I get the following error
{ora_session_mode => $session_mode}) where $session_mode =2
## : ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)
When I added the following code to the connect string, I can connect to
8.1.7.4, but I can't connect to the 9.2 databases. I get
{ora_session_mode => $session_mode}) where $session_mode =ORA_SYSDBA
# Connect error: ORA-28009: connection to sys should be as sysdba or
sysoper (DBD ERROR
Has anyone run into this problem? When I use {ora_session_mode =>
$session_mode}) where $session_mode =2, there must be some security missing
in some of our 8.1.7.4 instances such that the connect works in some
8.1.7.4 instances and not in the others. Does anyone know what is missing
or how I can get 1 connect string to work for both our 8.1.7.4 and 9.2
instances??
