Re: A critical error! Help....

From: Buelent Zeyben <bzeyben_at_ptc.com>
Date: Thu, 04 Jun 1998 10:04:44 -0400
Message-ID: <3576A97C.15479A67@ptc.com>

ence:oracle [2] oerr ora 1034
01034, 00000, "ORACLE not available"

// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages.
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.

fence:oracle [3] oerr ora 7429
07429, 00000, "smsgsg: shmget() failed to get segment."

// *Cause:  a shared memory segment used for all part of the SGA could not be
//          retrieved.
// *Action: Use the system error number in the error message to determine why
//          the segment could not be retrieved. If it does not exists,
shutdown
//          the database using the "abort" option, and then restart it.
//          If the get failed because the permissions are incorrect, make sure

//          that the ownership of the oracle executable is the same as that on

//          the shared memory segment.

Hope it helps ...
Buelent

news.seed.net.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
>
> 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!
Received on Thu Jun 04 1998 - 09:04:44 CDT