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

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

No, we've never been able to install DBD::Oracle without a force.  It  
requires a lot of setup (i.e. a database with the scott/tiger user).

--Mike

On Oct 27, 2005, at 1:24 PM, Juan Carlos Perin wrote:

> Yes, that was my mistake, I was looking at 'orcl', 'sys'.  Orcl is  
> the db
> name.  Although, You are right.  My gus.config had the right user  
> that I had
> created with DBA privileges, but the gus.properties was still the  
> older
> version with sys as the user.  I changed this and it appears to be  
> building
> just fine.  Thanks Mike!
>
> Do you forsee any potential problems from having forced DBD::Oracle to
> install.  I'm not sure why it would ever need to login as 'scott',  
> but I
> don't know if that's a fundamental component of DBD in general.
>
> Juan
>
>
> On 10/27/05 12:59 PM, "Michael Saffitz" <msa...@pc...>  
> wrote:
>
>
>>
>> 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
>>>
>>>
>>
>>
>>
>> -------------------------------------------------------
>> 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
>>
>>
>
>