Re: Error: ORA-01034, ORA-09243, ORA-02042

Since the client software is available for free from http://technet.oracle.com I would recommend upgrading. However, it sounds like there is a problem with your database. The errors you list are fatal:

ORA-01034 ORACLE not available

Cause: Oracle was not started. Possible causes include the following:

  a.. The SGA requires more space than was allocated for it.

  b.. 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.

ORA-09243 smsget: error attaching to SGA Cause: SGA may not have been created (database not started).

Action: See OSD error accompanying this message.

Good luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts


"J. Lai" <janiselai_at_yahoo.com> wrote in message
news:ab44e6a3.0205031832.5545f7d_at_posting.google.com...


> Hi all,

>

> I used SQL Plus 3.3 to connect 8.0.3 database on Novel. Yesterday, the

> connection is ok, but today the following messages show after inputted

> Username and password:

>

> ERROR: ORA-01034: ORACLE not available

> ORA-09243: smsget: error attaching to SGA

> OSD-02042: the SGA is invalid or is not present

>

> Please help me!  Thanks!