Solved

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

Posted on 1998-11-25
6
941 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
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
junfeb earned 200 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:kanatera
Comment Utility
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
Comment Utility
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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
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…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now