?
Solved

start / stop oracle services on solaris / windows

Posted on 2002-05-12
8
Medium Priority
?
2,237 Views
Last Modified: 2013-12-05
hi all,
I need to start/stop oracle services on solaris/windows
platforms from my java application.
What should I do ?
(if I have to execute any scripts please let me know which).
thanks
Eran
0
Comment
Question by:raichel
[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
8 Comments
 
LVL 3

Accepted Solution

by:
p_yaroslav earned 200 total points
ID: 7004227
Hi!

There are two scripts for start/stop databases.
1. $ORACLE_HOME/bin/dbstart (start databases)
2. $ORACLE_HOME/bin/dbshut (stop databases)

These scripts look for database names in file /var/opt/oracle/oratab .

You may copy these scripts and change them for appropriate needs.

Best regards!

Yaroslav.
0
 

Author Comment

by:raichel
ID: 7004234
hi and thanks,
I guess these scripts are for Solaris ?
what should I do for windows ?
and to what should I change them ?
Eran
0
 
LVL 3

Expert Comment

by:p_yaroslav
ID: 7004271
Hi!
Yes, these scripts for solaris.

For example, this script stops Oracle DB "ORCL" (for any UNIX systems) :
------------------------------
#!/bin/ksh
export ORACLE_SID=ORCL
export ORACLE_HOME=/mount_point/ora8

$ORACLE_HOME/bin/sqlplus /nolog <<EOD
connect internal
shutdown immediate
exit
EOD
------------------------------
ORACLE_HOME - environment variable where you install your Oracle software.


For windows you may write similar script.
Unfortunaly, I don't remember exactly windows syntax.

Best regards!
Yarodlav.
0
Technology Partners: 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!

 
LVL 7

Expert Comment

by:waynezhu
ID: 7005028
On windows, the Services are the counterparts of S/K scripts of Solaris. When setting to auto, the OS
will take care of it at the time of startup/shutdown the machine.
0
 
LVL 7

Assisted Solution

by:waynezhu
waynezhu earned 200 total points
ID: 7005215
On Windows, from command line, you can do either

net start OracleServiceSID
net stop OracleServiceSID

or

oradim -startup -sid SID
oradim -shutdown -sid SID [-shutmode [i|a|n]]
0
 

Expert Comment

by:FelixSasiKumar
ID: 7026207
Very simple, go to controlpanel->service, stop the oracleservice<SID>.

0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7096947
Please update and finalize this question.  I am happy to help split points or otherwise help you with special handling needs.  Expert input always appreciated.
Moondancer - EE Moderator
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 9219973
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Points split between p_yaroslav  and waynezhu
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

anand_2000v
EE Cleanup Volunteer
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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…
Suggested Courses
Course of the Month10 days, 6 hours left to enroll

765 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