On HP-UX we got this problem when the definition of shared memory segment
remains on disk.
1° we stop the instance with ABORT option.
2° under the directory $ORACLE_HOME/dbs you shouldn't find a file called
"sgadef[$ORACLE_SID].dbf"
3° If this file exists, remove it.
4° restart the instance.
Nicholas Palmer a écrit dans le message <35EC1925.49B6_at_kcicorp.com>...
>I recently upgraded from Oracle 7.1.6 to Oracle 7.3.2.2 on a Sparc
>running Solaris 2.4. The server seems to run fine, and the TNS listener
>seems to startup fine, and I can connect and do things fine from the
>server based programs, but when I try and connect from a client I get
>the following message (This is from SQLPLUS)
>
>ERROR: ORA-01034: ORACLE not available
>smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>
>In the manaual it says to look at the permissions or at the last part of
>the error message to figure out what is wrong. It seems to me that I'm
>missing a file or directory some where. Anybody have a clue as to what
>it would be?
>
>Thanks in advance.
>Nick
>--------------------------------------------
>Take off Late, Get Deep, Go Down Hard...
>
>nick_at_kcicorp.com (Nick Palmer)
>KCI Computing International
Received on Wed Sep 02 1998 - 03:28:16 CDT
