Solved

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

Posted on 1998-11-25
6
969 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
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!

 

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

732 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