?
Solved

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

Posted on 1998-11-25
6
Medium Priority
?
974 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 600 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

764 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