Re: Problem creating new user (wbalmer)

From: Wayne Balmer <wbalmer_at_op.net>
Date: 1996/01/16
Message-ID: <4dj6p6$ig3_at_picasso.op.net>#1/1


ieong_at_news.sfu.ca (Kim Ieong) wrote:

>I tried to add an new Oracle user to the system, but after I created the user
>and grant the appropriate permissions, I got the following error message when
>I tried to run sqlplus from the Unix prompt:
 

>$ sqlplus new_user/new_user
 

>SQL*Plus: Release 3.1.2.3.1 - Production on Mon Jan 15 11:35:18 1996
 

>Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
 

>ERROR: ORA-01034: ORACLE not available
>ORA-07320: smsget: shmat error when trying to attach sga.
>AT&T System V/386 Error: 13: Permission denied
 

>Kim Ieong

I believe that you have permissions problems on the oracle executable file in your $ORACLE_HOME/bin directory. Is this the first user (UNIX user) other than "oracle" to try to access the database?

UNIX will start the oracle kernel with the permissions of the "oracle" executable file . This file must be setuid root so that "others" (those not root or oracle [UNIX users] ) can access the shared memory area. Check the permissions (long listing) on the file:

          $ORACLE_HOME/bin/oracle

If it is all combinations of dwx- then you must issue the following command as root user:

       chmod 4755 $ORACLE_HOME/bin/oracle

You must then stop and restart the database to reload the kernel with the new permissions.

If this WAS the problem then you should make sure that you ran the post install scripts as root as there may be other files not placed or permissioned correctly. I hope this was some help!

                                  Wayne Balmer, WAINWRIGHTS, inc.
                                 temporarily wbalmer_at_op.net
Received on Tue Jan 16 1996 - 00:00:00 CET

Original text of this message