Re: Server / Listener Problems

In Article<4v16em$1pj_at_mtinsc01-mgt.ops.worldnet.att.net>, <wsluk_at_postoffice.worldnet.att.net> writes:
> Path: rocksanne!parc!news.Stanford.EDU!agate!howland.erols.net!panix!netaxs.com!hunter.premier.net!news-res.gsl.net!news.gsl.net!usenet.eel.ufl.edu!arclight.uoregon.edu!netnews.worldnet.att.net!newsadm
> From: William Luk <wsluk_at_postoffice.worldnet.att.net>
> Newsgroups: comp.databases.oracle
> Subject: Server / Listener Problems
> Date: 16 Aug 1996 07:02:46 GMT
> Organization: Self
> Lines: 19
> Message-ID: <4v16em$1pj_at_mtinsc01-mgt.ops.worldnet.att.net>
> NNTP-Posting-Host: 46.los-angeles-3.ca.dial-access.att.net
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 1.22ATT (Windows; U; 16bit)
>
>
> We are running Oracle 7 server on an X86 Solaris 2.5.
> I finished installing the Oracle 7 server (version 7.3.2.1)
> with SQL*Net version 2.3. When I tried to access the
> server from a sqlplus client, I got the following errors on
> the client:
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> NCR System 3000 Error: 2: No such file or directory
>
> Oracle support has been working on this for couple weeks, and
> is not sure where the error is coming from.
>
> Any help will be greatly appreciated...
>
> WSL
>
>

Make sure to check the ownership of files,shared memory etc..

The command "ipcs" should show ownership of "oracle" and a group of "dba" for the existing instance structures.

If your system starts oracle automatically (most do) after a reboot, the "ipcs " could show an ownership of "root" and group of "other" for the shared memory and semaphores. The following is an output of "ipcs"

Shared Memory:

m   9000 0x0a52f50b --rw-rw----   oracle      dba
m      1 0x1252f50b --rw-rw----   oracle      dba
m      2 0x1a52f50b --rw-rw----   oracle      dba
m      3 0x0c94c199 --rw-rw----   oracle      dba
m   8004 0x0d297b01 --rw-rw----   oracle      dba
m      5 0x15297b01 --rw-rw----   oracle      dba
m      6 0x1d297b01 --rw-rw----   oracle      dba
m   1007 0x0e94c082 --rw-rw----   oracle      dba
m   5008 0x0d297feb --rw-r-----   oracle      dba
m      9 0x00000184 --rw-rw-rw-    arbor    staff
Semaphores:
s      0 0x0x00000000 --ra-ra----   oracle      dba
s      1 0x0x00000000 --ra-ra----   oracle      dba
s      2 0x0x00000000 --ra-ra----   oracle      dba
s  65539 0x0x00000000 --ra-ra----   oracle      dba
s 327684 0x0x00000000 --ra-r-----   oracle      dba

I have a number of oracle instances running on this server, but note that all of the structures have ownership of oracle and group of dba.

If yours does not look similar to this you have a problem. This can be caused by incorrect ownership/sticky bit settings of the oracle executeable. The following directory entry was cut from my Solaris 2.4 / Oracle 7.1.6 system.  

-rwsr-s--x 1 oracle dba 9159320 Jul 23 1995 oracle

I hope this info helps

Kevin Hrim

//Been there, Done that// Received on Mon Aug 19 1996 - 00:00:00 CEST