Re: Problem creating new user
From: Chuck Isaacson <ccisaac_at_mtu.edu>
Date: 1996/01/15
Message-ID: <4def09$61l_at_instasrv.admin>#1/1
: 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
:
Received on Mon Jan 15 1996 - 00:00:00 CET
Date: 1996/01/15
Message-ID: <4def09$61l_at_instasrv.admin>#1/1
The error you received indicates that Oracle is not running. Follow your procedures to bring Oracle up such as: sqldba
connect internal
startup pfile=xxxxxx
HTH
Kim Ieong (ieong_at_news.sfu.ca) 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
:
Received on Mon Jan 15 1996 - 00:00:00 CET