Re: Problem creating new user (wbalmer)
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:
>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.netReceived on Tue Jan 16 1996 - 00:00:00 CET