Re: A critical error! Help....

On Thu, 4 Jun 1998 15:39:39 +0800, news.seed.net.tw <jeffrey_at_cradle.com.tw> wrote:
> There's a Oracle Server on SGI IRIX in our company. Because there was
>too many files in the system volumn, our "cute" system administrator moved
>the oracle ...../home/dba/.. system files to another external disk and make
>a
>symbol link at the original location.... Tragedy happened... Our SA used
>'cp'
>command to copy file, so the permission of files maybe changed. Now, When
>I want to use the sqlplus to access the database, a error message show and
>no more detail about it for me to check the real factor of error! Error
>message
>like this:
>
>Enter user-name: wwwdb
>Enter password:
>ERROR: ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
Be sure your executable is
ls -l $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle dba ...

Other things can cause this error, including not setting ORACLE_HOME correctly, unix keeping too many segments around (whether because they are not being released due to incorrectly shutting oracle or on some unix files need to be removed from /tmp - do a ipcs to see) and others. I've seen a couple of situations where one should have been able to do that but a reinstall was required anyways.

Also check oratab (whereever it may be on your system, perhaps /var/opt/oracle) is pathed correctly.

>
>Can anyone tell me how can I get more information about this error(like log
>files, or
>error message table)? I want to know which file was lost and maybe I can do
>something.
>I have to solve this problem ASAP, or my case will.... :<
>Thanx a lot!

Check your config.ora for the background_dump_dest, and look there for a file called alert*.
>
>

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.