Path: news.easynews.com!easynews!feedwest.news.agis.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: janiselai@yahoo.com (J. Lai)
Newsgroups: comp.databases.oracle.server
Subject: Re: Error: ORA-01034, ORA-09243, ORA-02042
Date: 5 May 2002 18:21:26 -0700
Organization: http://groups.google.com/
Lines: 58
Message-ID: <ab44e6a3.0205051721.1b50399@posting.google.com>
References: <ab44e6a3.0205031832.5545f7d@posting.google.com> <aavj3t$2k78$1@msunews.cl.msu.edu>
NNTP-Posting-Host: 202.66.74.201
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1020648087 23338 127.0.0.1 (6 May 2002 01:21:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 May 2002 01:21:27 GMT
Xref: easynews comp.databases.oracle.server:145982
X-Received-Date: Sun, 05 May 2002 18:19:02 MST (news.easynews.com)

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@hpdbe.com> wrote in message news:<aavj3t$2k78$1@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@hpdbe.com
> www.hpdbe.com
> High Performance Database Engineering
> Available for long and short term contracts
> 
> 
> "J. Lai" <janiselai@yahoo.com> wrote in message
> news:ab44e6a3.0205031832.5545f7d@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!