Solved

start / stop oracle services on solaris / windows

Posted on 2002-05-12
8
2,218 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
8 Comments
 
LVL 3

Accepted Solution

by:
p_yaroslav earned 50 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
 
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 7

Assisted Solution

by:waynezhu
waynezhu earned 50 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…

706 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

18 Experts available now in Live!

Get 1:1 Help Now