Re: [GUSDEV] Gus build and DBD::Oracle

[Michael S. <msa...@pc...>]

Hi Juan

You should not install using the sys or system users.  Instead,  
create a new user, grant that user DBA privileges, and then install  
using that user.  After the install you may revoke the DBA privileges  
from that user if you'd like.

It doesn't look like it's trying to connect as orcl... where is that  
coming from?

--Mike

On Oct 27, 2005, at 11:43 AM, Juan Carlos Perin wrote:

> 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
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>