Solved

start / stop oracle services on solaris / windows

Posted on 2002-05-12
8
2,222 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
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 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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Install MySQL 5.6 and PHP on Centos Linux 6 101
Insert and update a row at the same time 4 52
Convert Oracle data into XML document 2 59
aix unix tar error 3 43
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…
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…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

920 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