Solved

HOW TO START THE DATABASE (ORACLE 10G) AUTOMATICALLT WHEN WINDOWS SERVER START

Posted on 2009-05-20
4
694 Views
Last Modified: 2012-05-07
SIR
I HAVE CONFIGURED THE FAIL SAFE SERVER(3.3.3 ON ORACLE 10G) ON  WINDOWS SERVER 2003 MSCS.nOW WHEN I REBOOT THE WINDOWS SERVER THE DATABASE IS NOT STARTING AUTOMATICALLY.IT IS NOT MOUNTED
THEN I HAVE TO USE SHUTDOEN IMMEDIATE COMMAND TO MAKE IT DOWN
AND THEN STARTUP FORCE TO MAKE IT OPEN.
I DON'T  LIKE TO START IT MANUALY AT EVERY STARUP.
PLEASE LET ME KNOW THE PROCEDURE FOR MAKEING THE ORACLE 10G DATABASE OPEN AT EVERY STARTUP OF WINDOWS SERVER.
0
Comment
Question by:ajayg161073
[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
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 24430503
please learn ORADIM command line tool to configure the oracle instance service to start up automatically:
http://download.oracle.com/docs/cd/B19306_01/win.102/b14304/create.htm#i1006533

oradim -EDIT -SID <your SID> -STARTMODE auto 

Open in new window

0
 

Author Comment

by:ajayg161073
ID: 24430836
done but bot working in my case
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 24431743
Check your Services applet.  Are the Oracle services configured to start automatically?  You may not need all of them to be configured that way.  The main two that you need are:
1. Oracle[Oracle_home]TNS_Listener
2. OracleService[SID]

If you have the database and listener shut down, what happens at a command prompt if you try:
net start service OracleService[SID]
and
net start Oracle[Oracle_home]TNSListener

Do those commands start the dataabse and listener as expected?

Also, are those services configure to start as someone other than the default: "Local System"?  If not, they will not have access to any network resources outside of the local server, and that may impose some limits you don't want.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24433005
What are the names of Oracle Service and Oracle Listener in processes list?
You have to set the startup to automatic.

But Windows starts the services in alphabetical order.
Possibly your Oracel service depends on another service
but that service is not started. I have faced this mess
installing Oracle Application Server with Infrastructure
Data base.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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ā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.
Suggested Courses

615 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