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

[Ray Stell]

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

--