raichel
asked on
start / stop oracle services on solaris / windows
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/o ra8
$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.
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/o
$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.
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.
will take care of it at the time of startup/shutdown the machine.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Very simple, go to controlpanel->service, stop the oracleservice<SID>.
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
Moondancer - EE Moderator
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
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
ASKER
I guess these scripts are for Solaris ?
what should I do for windows ?
and to what should I change them ?
Eran