Re: Problem creating new user

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
>
>
>Enter user-name: $
>
>What did I forget to do? Any help would be appreciated.
>
>Kim Ieong
>

First, make sure the ORACLE_SID is set appropriately. Also, if the Unix user running sqlplus is NOT the Oracle owner (eg. oracle), make sure the setuid bit is set on $ORACLE_HOME/bin/oracle. The permission we use is 6751.

Bottom line - the error message indicates that the Unix user can't attach to the $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf file. This is either because it isn't there (Oracle is not up), Oracle can't find it (environmental variables are not set), or the setuid permissions are not set correctly ($ORACLE_HOME/bin/oracle).

Hope this helps.

-- 
Mike Morgan
Technology Integration Services - Unix DBA

email: mike.morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"Murphy's Law of computing:  Anything that can go wrSegmentation 
fault(coredump)"
*******************************************************