Re: smsget: shmat error when trying to attach sga

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

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 Sun Feb 18 1996 - 00:00:00 CET