Home » RDBMS Server » Server Administration » Running Oracle Services With Batch
Running Oracle Services With Batch [message #227436] Wed, 28 March 2007 04:18 Go to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear All
I want to run the oracle services with the batch file.
How can i start the oracle specific services with a batch file.
I don't want to start the oracle services manually or automatically. I just want to start them with a batch file.

thanks
Re: Running Oracle Services With Batch [message #227450 is a reply to message #227436] Wed, 28 March 2007 05:08 Go to previous messageGo to next message
fcatak
Messages: 16
Registered: March 2007
Location: turkey
Junior Member
you can use "net stop" and "net start"
like

net start OracleServiceSID
net stop OracleServiceSID
Re: Running Oracle Services With Batch [message #227487 is a reply to message #227450] Wed, 28 March 2007 06:40 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Can you provide the script to start and stop the all oracle services like orcl,tns_listner,http_server etc with batch file.
Thanks for your reply
Re: Running Oracle Services With Batch [message #227528 is a reply to message #227487] Wed, 28 March 2007 08:34 Go to previous messageGo to next message
fcatak
Messages: 16
Registered: March 2007
Location: turkey
Junior Member
yes,
you can
Re: Running Oracle Services With Batch [message #227657 is a reply to message #227528] Wed, 28 March 2007 23:12 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Please provide me the script for running services like orcl,tns_listner,http_server etc with batch file.
I am still waiting.
Re: Running Oracle Services With Batch [message #227661 is a reply to message #227436] Wed, 28 March 2007 23:25 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>I am still waiting.
Please coninue to do so.
While you are waiting, you might find your answers at http://tahiti.oracle.com if you decide to try to help yourself.
Re: Running Oracle Services With Batch [message #227672 is a reply to message #227661] Thu, 29 March 2007 00:29 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

I tried but I did not find the answer yet.
Re: Running Oracle Services With Batch [message #227673 is a reply to message #227672] Thu, 29 March 2007 00:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I tried but I did not find the answer yet.

Can you show what you did.

do follow step.
1.create .bat file.
2.
net start ORACLESERVICE<sid>
net start TNSLISTER >>>> according exact name mention in services.msc windows.
net start HTTPSERVER >>> according exact name mention in services.msc windows.



Schedule through SCHEDULE TASK utility.

hope this helps
regards
Taj
Re: Running Oracle Services With Batch [message #227678 is a reply to message #227436] Thu, 29 March 2007 00:46 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
0) I tried but I did not find the answer yet.
1) What happens if/when NOBODY gives you the answers you desire?
2) What happens if/when both #0 & #1 stay true?

P.S.
Though it has been implied or inferred, on what OS name & version are you running.
See, it does matter for any script to actually work.
icon14.gif  Re: Running Oracle Services With Batch [message #228998 is a reply to message #227678] Wed, 04 April 2007 23:40 Go to previous message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Thanks i have run the script. It works quite well.
Once again thanks for reply.
Previous Topic: Trace Files problem
Next Topic: How to Find ML Level
Goto Forum:
  


Current Time: Wed Dec 07 06:53:09 CST 2016

Total time taken to generate the page: 0.23096 seconds