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

I would like to describe my case more detail, ONLY my computer have these problem, other users or other computers are OK and Oracle is run smoothly. What can I do?

Thanks!

"Chris Weiss" <chris_at_hpdbe.com> wrote in message news:<aavj3t$2k78$1_at_msunews.cl.msu.edu>...
> 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!
Received on Sun May 05 2002 - 20:21:26 CDT