[rhn-users] Need help with access of DB problem

[Mark Maggelet]

I want to second this comment. The 10.2 installer for linux is making me 
want to kill myself.

Ray Stell wrote:
> 
> oh yes, lovely oracle corp had bugs in 10.2 and other versions
> I think that messed up the install.  There are patches for that, but
> it is really stupid that they didn't pull the distribution after
> that was determined.
> 
> 
> 
> 
> On Fri, Apr 07, 2006 at 03:08:08PM -0400, James Oliver wrote:
> 
>>Problem Resolved.
>>In checking all permissions, oracle was already set as -rwsr-s--x, we
>>found that the file dbsnmp had 'root' as the owner.  When we compared
>>that to other production databases, we found them to have it's owner as
>>'oracle'.
>>We changed the owner to 'oracle' and bounced the database and then was
>>able to log in with multiple users.
>>Our research found that owner was set from a script called root.sh
>>which was provided by Oracle.
>>I'm still unclear which way it is supposed to be set but I know it
>>works once we set it to 'oracle'.
>>Thanks for your responses.
>>Every response got us taking a harder look at other areas.
>>
>>
>>-----Original Message-----
>>From: rhn-users-bounces at redhat.com
>>[mailto:rhn-users-bounces at redhat.com]On Behalf Of James Oliver
>>Sent: Friday, April 07, 2006 7:48 AM
>>To: rhn-users at redhat.com
>>Subject: [rhn-users] Need help with access of DB problem
>>
>>Not sure if we have an Oracle problem or an O/S problem but would
>>appreciate any help that can be offered.
>>We have installed Oracle 9.2.0.6 on a Red Hat Linux 3.2 32-bit O/S.
>>We can only access DB with SQL*plus that is started by Oracle process
>>owner.
>>Once Oracle is started, the user that started the database can access
>>the database using SQL*plus.
>>Any other user with the same privileges cannot get in.
>>We get:
>>ERROR:
>>ORA-01034: ORACLE not available
>>ORA-27123: unable to attach to shared memory segment
>>Linux Error:  13:  Permission denied
>>
>>We have beat ourselves up for two days and are no further along.
>>All help is much appreciated.
> 
> 
>>_______________________________________________
>>rhn-users mailing list
>>rhn-users at redhat.com
>>https://www.redhat.com/mailman/listinfo/rhn-users
> 
>