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

[James Oliver]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/rhn-users/attachments/20060407/49a1ce1e/attachment.htm>