Solved

I've found the error Message "error attaching to SGA" And "SGA not initialized"

Posted on 1998-11-25
6
971 Views
Last Modified: 2008-02-20
I've just install the oracle 7.3.4 for Nt It work well Until I install the oracle webserver version 3.0
I've set the configuration for single node and I can browse the database from it's administration page but now I can't do it and I can't login fron sql*Plus it show the error message
"    ERROR: ORA-01034: ORACLE not available
     ORA-09243: smsget: error attaching to SGA
     OSD-04101: invalid SGA: SGA not initialized    "
What is "SGA" and what can i do?
0
Comment
Question by:kanatera
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
junfeb earned 200 total points
ID: 1082747
This only means your oracle service and Database is not started. Go to your start
menu , settings, control panel ,services and there you'll see listed two services
OracleserviceORCL and OraclestartOrcl. If you startup oraclestartORCL both will start
automatically. This will give you access to Oracle Database.
0
 
LVL 3

Expert Comment

by:junfeb
ID: 1082748
P.S Regarding your question on the Error message -
ERROR: ORA-01034: ORACLE not available
         ORA-09243: smsget: error attaching to SGA
         OSD-04101: invalid SGA: SGA not initialized    "

SGA - is the memory that is allocated to Oracle. This is the Shared Global Area. This
says that the SGA is not initialised which is done at Oracle Startup time.  So just starting up the services on NT will solve this problem.

If you require more help please post.
0
 
LVL 3

Expert Comment

by:junfeb
ID: 1082749
Here is some documentation on the System Global Area  - SGA..

SGA and Oracle processes constitute an Oracle instance. Oracle automatically allocates
memory for an SGA when you start an instance and the operating system reclaims the memory when you shut down the instance. Each instance has its own
SGA.

The SGA is read-write; all users connected to a multiple-process database instance may read information contained within the instance's SGA, and several
processes write to the SGA during execution of Oracle.

The SGA contains the following data structures:

     the database buffer cache
     the redo log buffer
     the shared pool
     the data dictionary cache
     other miscellaneous information

Part of the SGA contains general information about the state of the database and the instance, which the background processes need to access; this is called
the fixed SGA. No user data is stored here.

The SGA also includes information communicated between processes, such as locking information.

If the system uses multithreaded server architecture the request and response queues, and some contents of the program global areas, are in the SGA.

Thanks.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:kanatera
ID: 1082750
I've start OracleserviceORCL and  oraclestartORCL already but it still show those error Message I've try to stop Oracle Web serveer service and OracleserviceORCL and  OraclestartORCL and start it then start Oracle Web Server (I use the command in dos prompt such as "owscrt start wrb"  "owscrt start admin"  "owscrt start www") but it can not use both of them please help and thanks for comment
0
 

Author Comment

by:kanatera
ID: 1082751
I've start OracleserviceORCL and  oraclestartORCL already but it still show those error Message I've try to stop Oracle Web serveer service and OracleserviceORCL and  OraclestartORCL and start it then start Oracle Web Server (I use the command in dos prompt such as "owscrt start wrb"  "owscrt start admin"  "owscrt start www") but it can not use both of them please help and thanks for comment
0
 

Author Comment

by:kanatera
ID: 1082752
I've start OracleserviceORCL and  oraclestartORCL already but it still show those error Message I've try to stop Oracle Web serveer service and OracleserviceORCL and  OraclestartORCL and start it then start Oracle Web Server (I use the command in dos prompt such as "owscrt start wrb"  "owscrt start admin"  "owscrt start www") but it can not use both of them please help and thanks for comment
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question