[GUSDEV] Gus build and DBD::Oracle

[Juan C. P. <bi...@ge...>]

I was encountering errors when installing DBD::Oracle for perl where while
using MCPAN to install I kept seeing connect errors for (scott/tiger).  A
resident Oracle expert confirmed all our oracle settings were fine, and that
connection was perfectly fine through all other connect methods.  So, I
decided to force install DBD::Oracle and hope it was just a localized error
with MCPAN.  

BUT.. When attempting to finally build, the system has trouble connecting
once again, with a different user (maybe unrelated to the above problem, but
is a DBD issue) and gives the following error:

[InstallSchema] INFO: Writing Database
     [echo] .
     [echo] Installing GUS/ObjRelP
     [echo] generating Perl Objects
     [exec] GUS::ObjRelP::DbiDbHandle connect('orcl','sys',...) failed:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (DBD ERROR:
OCISessionBegin) at
/home/oracle/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 165
     [exec] Can't bless non-reference value at
/home/oracle/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 21.

BUILD FAILED
/home/oracle/GUS/project_home/install/build.xml:28: The following error
occurred while executing this line:
/home/oracle/GUS/project_home/GUS/build.xml:225: exec returned: -1

Total time: 2 minutes 4 seconds

This time its having trouble as orcl.  The user doesn't even exist when I
look into the user list.  I'm not sure if I should create the user, or if
there is a bigger problem.  I'm learning oracle as I go, so I have a lot to
learn, any suggestions will help.  Thanks all!

Juan Perin