Solved

ORA-09352 - (SID) has not been started

Posted on 2000-02-29
6
1,523 Views
Last Modified: 2012-06-27
As a beginner in the field, I have a starting question:

My ORACLE DB is installed on Windows NT along with a user application. The app runs well but if I want to enter svrmgr23 this error appear:
ORA-09352: OracleService (SID) has not been started.
In services the 3 Oracle components start automatic and I've seen ORACLE_SID set.

What's the mater ?

 
0
Comment
Question by:moia
  • 3
  • 2
6 Comments
 
LVL 2

Expert Comment

by:banicki
ID: 2569129
You said your two services are started?
-OracleServiceXXXX where XXXX is your SID
-OracleTNSListner
Right?

You said you went to a DOS Prompt and set the OracleSID.
-set oracle_sid
 = XXXX  where XXXX is your SID
Then you try to start Server Manager
-svrmgr23
and you get a ORA-09325

What is you SID
jTell us what service are running that start with Oracle.

Terry
 
0
 
LVL 6

Expert Comment

by:crsankar
ID: 2571937
Try this

Go to the ms-dos prompt

type this at the command prompt

SET ORACLE_SID=<sid>

substitute <sid> with the name of the instance that you want to work with

svrmgr23

If you still have problems,

type

connect internal

show parameter db_name

verify it is the correct database

and then issue

startup pfile=<name of your param file>




0
 

Author Comment

by:moia
ID: 2571956
Thank you Terry.

Actually, there are three services starting automatic:

OracleServiceGFPC
OracleStartGFPC
OracleTNSListener

My Oracle_sid is GFPC and the database is the same (set in init.ora)
I set again in DOS prompt, then started ServerManager and it works, but if I start SQLplus the same error appears.

In NT environment system variable the only varible set is ORACLE_HOME. How could I add ORACLE_SID to appear at startup ?
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.

 
LVL 2

Accepted Solution

by:
banicki earned 100 total points
ID: 2572902
do this on your oracle server.
You have to set ORACLE_SID in the NT registry.  
-go to a command prompt (or start>run)
-type regedt32
-find the hkey_local_machine on local maching
-drill down, software>oracle
-make sure you have a view of tree and data, data on the right half of screen
-edit>add value>
-in you add value pop up window, enter a value name of ORACLE_SID, data type of
REG_SZ or REG_EXPAND_SZ, then click ok
-a string editor window will pop up
-enter your sid in the string field
-close the window, will save your value
-this action will cause this to be you default destination. example bring up an OEM signon window and leave the service empty.
0
 
LVL 2

Expert Comment

by:banicki
ID: 2572917
I am assuming you have only one oracle instance on this nt server.  setting the default SID makes life difficult if you have two instances on one server.
Terry
0
 

Author Comment

by:moia
ID: 2576569
Thanks Terry. I modified the registry and everything seems to be OK.

See you
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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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.

758 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

23 Experts available now in Live!

Get 1:1 Help Now