local sqlplus gets "ORA-07320: smsget: shmat error when trying to attach sga"

From: Jim Maki <jim_maki.no_at_where.hotmail>
Date: Fri, 14 May 1999 07:45:03 -0700
Message-ID: <FFW_2.25349$ny.1701818_at_typhoon-sf.snfc21.pbi.net>

Running sqlplus locally on our AIX 4.2 server gets the error:   ERROR:ORA-01034:ORACLE not available
  ORA-07320: smsget: shmat error when trying to attach sga.   IBM AIX RISC System/6000 Error: 13: Permission denied

sqlplus remotely (over TCP/IP) works OK.

This unhappiness started after a bad install of OAS 4.0.7 on our 7.3.4 server with sqlnet 2.3.4. (Some library updates = AIX 4.2.1.7 were  needed for the install to work and we didn't have them. Now it will be a little while before we can try again - argh!)

What could cause this error? An ipcs command showed the Oracle shared memory with "owner.group" = "oracle.dba" and 640 permissions. Is that our problem? Or the non-working install somehow?

Anybody have some experience with this?

     Thanks for any help,
     Jim Maki

Received on Fri May 14 1999 - 16:45:03 CEST