<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2838" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV id=intelliTxt>Problem Resolved.<BR>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'.<BR>We changed the owner to 'oracle' and bounced the database and then was able to log in with multiple users.<BR>Our research found that owner was set from a script called root.sh which was provided by Oracle.<BR>I'm still unclear which way it is supposed to be set but I know it works once we set it to 'oracle'.<BR>Thanks for your responses.<BR>Every response got us taking a harder look at other areas.</DIV><BR><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message-----<BR><B>From:</B> rhn-users-bounces@redhat.com [mailto:rhn-users-bounces@redhat.com]<B>On Behalf Of </B>James Oliver<BR><B>Sent:</B> Friday, April 07, 2006 7:48 AM<BR><B>To:</B> rhn-users@redhat.com<BR><B>Subject:</B> [rhn-users] Need help with access of DB problem<BR><BR></DIV>
<DIV id=intelliTxt style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px">Not sure if we have an Oracle problem or an O/S problem but would appreciate any help that can be offered.</DIV>
<DIV style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px">We have installed Oracle 9.2.0.6 on a Red Hat Linux 3.2 32-bit O/S.<BR>We can only access DB with SQL*plus that is started by Oracle process owner.<BR>Once Oracle is started, the user that started the database can access the database using SQL*plus.<BR>Any other user with the same privileges cannot get in.<BR>We get:<BR>ERROR:<BR>ORA-01034: ORACLE not available<BR>ORA-27123: unable to attach to shared memory segment<BR>Linux Error: 13: Permission denied<BR><BR>We have beat ourselves up for two days and are no further along.<BR>All help is much appreciated.</DIV></BLOCKQUOTE></BODY></HTML>