Re: smsget: shmat error when trying to attach sga

William <mailto:whuang_at_earthlink.net> wrote:
>
> Deepak,
>
> I've seen this type of an error on both HP-UX and SCO/Unix. Usually
> it means that SQLPlus could not start properly due to a permission
> problem. Check your $ORACLE_HOME/bin directory and make sure that
> the permissions are set correctly. The permissions for the ORACLE
> file should look something like RWSR-SR-X as well as for a few other
> files. I'm not at the office right now, so I can't give you exact details
> on which files or permissions. Usually if the permissions get set correctly
> you can log in right away without bouncing (starting up and
> shutting down) the database. Before you do a CHMOD on the files, log
> into your server as the 'oracle' account under SunOS (whichever
> account you installed the Oracle RDBMS as) and see if SQLPlus
> will run. IF SQLPlus runs properly, then all you have to do is
> correct the permissions. If SQLPlus has worked in the past,
> check your backup tapes and confirm the permissions for the files
> in this directory. Someone probably just did a CHMOD -R. . .
>
> Good luck.
>
> -William / mailto:whuang_at_earthlink.net

P.S. Here's the solution that worked for us on SCO/Unix. Check your man pages for SunOS.

chmod 6751 oracle

Incorrect settings:
-rwxr-x--x oracle dba 4951162 Oct 08 1993 oracle

Correct settings:
-rwsr-s--x oracle dba 4951162 Oct 08 1993 oracle

-William / mailto:whuang_at_earthlink.net

>
> Deepak K. Sinha <mailto:dksinha_at_denali.ims.alaska.edu> wrote:
> >
> > Hi, I am totally new to oracle. My sys. admin. installed oracle-7 recently
> > on a sun sparc-II server running sunos-4.1.3, he is also new to oracle.
> > In the past we have been working with INGRES so we have INGRES experience.
> >
> > I am trying to log in to oracle using sqlplus so that I can create my
> > own table and stuff but I am getting the following error:
> >
> > ---------------------------------------------------------------------
> > SQL*Plus: Release 3.1.3.5.1 - Production on Fri Feb 16 11:46:01 1996
> >
> > Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
> >
> > Enter user-name: dksinha
> > Enter password:
> > ERROR: ORA-01034: ORACLE not available
> > ORA-07320: smsget: shmat error when trying to attach sga.
> > SunOS Error: 13: Permission denied
> > ---------------------------------------------------------------------
> >
> > Do you know what's going on?
> > I will really appriciate if you can email me. Thank you very much
> > for your attention,
> >
> > Deepak
> > =====================================================================
> > Deepak K. Sinha Phone: (907)474-5184
> > Programmer/Analyst Fax: (907)474-7204
> > University of Alaska, Fairbanks email: dksinha_at_ims.alaska.edu
> > =====================================================================
> > --
> > =====================================================================
> > Deepak K. Sinha Phone: (907)474-5184
> > Programmer/Analyst Fax: (907)474-7204
> > University of Alaska, Fairbanks email: dksinha_at_ims.alaska.edu
Received on Mon Feb 19 1996 - 00:00:00 CET