I can connect to the database using sqlplus as user oracle, but not as root.

I can compile DBD::Oracle but not complete the test.

I tried to set variables properly:

ORACLE_HOME=/u/oracle/10.2.0
ORACLE_HOST=hostname
ORACLE_PORT=1522
ORACLE_SID=databasename
ORACLE_USERID=user/passw...@databasename
PATH=/u/oracle/10.2.0/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
PWD=/usr/src/pub/dbd-oracle/DBD-Oracle-1.22
TNS_ADMIN=/u/oracle/10.2.0/network/admin
TWO_TASK=T:hostname:ORACLE_SID

The machine has a medium sized production Oracle 10g database which works fine 
with a Java application.

The # perl Makefile.PL appears to work and the make appears to work

I have a user name/password which permits read-only access to the database 
which I have verified as user oracle.

I would appreciate any help,

Jeff

Reply via email to