Re: Shared Memory Problem - Solaris 2.4 Oracle7.1.6

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1995/08/21
Message-ID: <809035201.26428_at_jimsmith.demon.co.uk>#1/1


Gerald Skerbitz <gsker> wrote:

>I've just installed Oracle on Solaris2.4 but I can only connect as oracle.
>I can't connect as any other user.
>The database is installed on thor.
 

>(thor)/var/opt/oracle>sqlplus
>
>SQL*Plus: Release 3.1.3.7.1 - Production on Wed Aug 16 10:30:22 1995
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>Enter user-name: scott/tiger
>ERROR: ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>
>
>(thor)/var/opt/oracle>ipcs -a
>IPC status from <running system> as of Wed Aug 16 10:32:59 1995
>Message Queue facility not in system.
>T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH
>SEGSZ CPID LPID ATIME DTIME CTIME
>Shared Memory:
>m 400 0x08559afb --rw-r----- oracle dba oracle dba
>74440064 2476 2492 10:30:16 10:30:16 10:29:30
>T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS
>OTIME CTIME
>Semaphores:
>s 262144 0x0x00000000 --ra-r----- oracle dba oracle dba 25
>10:30:00 10:29:30
>s 262145 0x0x00000000 --ra-r----- oracle dba oracle dba 25
>no-entry 10:29:30
>(thor)/var/opt/oracle>
 

>Is this a permissions problem? What file or directory is it trying to get?
>How do I change the permissions on the shared memory segments?
 

>Any help would be greatly appreciated!
>Thanks.
>--
>Gerry
>Gerald Skerbitz <gsker_at_med.umn.edu> U of MN Med School Admin 6-5379
>Home St. Paul,Ramsey County,Minnesota, USA

There are two possibilities.

1 Permissions on the oracle executable should be 4751 rwsr-x--x.

2 Is ORACLE_SID set for the other user? You get 1034 if this isn't set as it can't find the file sgadef<sid>.dbf which contains instance specific information inclding the shared memory address.

Jim Smith                      jim_at_jimsmith.demon.co.uk
Oracle DBA                     
Received on Mon Aug 21 1995 - 00:00:00 CEST

Original text of this message