OraFAQ Forum: Server Administration » Running Oracle Services With Batch

Home » RDBMS Server » Server Administration » Running Oracle Services With Batch

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running Oracle Services With Batch [message #227436]

Wed, 28 March 2007 04:18

sweetkhaliq
Messages: 200
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

Report message to a moderator

Re: Running Oracle Services With Batch [message #227450 is a reply to message #227436]

Wed, 28 March 2007 05:08

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

Report message to a moderator

Re: Running Oracle Services With Batch [message #227487 is a reply to message #227450]

Wed, 28 March 2007 06:40

sweetkhaliq
Messages: 200
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

Report message to a moderator

Re: Running Oracle Services With Batch [message #227528 is a reply to message #227487]

Wed, 28 March 2007 08:34

fcatak
Messages: 16
Registered: March 2007
Location: turkey

Junior Member

yes,
you can

Report message to a moderator

Re: Running Oracle Services With Batch [message #227657 is a reply to message #227528]

Wed, 28 March 2007 23:12

sweetkhaliq
Messages: 200
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.

Report message to a moderator

Re: Running Oracle Services With Batch [message #227661 is a reply to message #227436]

Wed, 28 March 2007 23:25

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Running Oracle Services With Batch [message #227672 is a reply to message #227661]

Thu, 29 March 2007 00:29

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

I tried but I did not find the answer yet.

Report message to a moderator

Re: Running Oracle Services With Batch [message #227673 is a reply to message #227672]

Thu, 29 March 2007 00:36

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

Report message to a moderator

Re: Running Oracle Services With Batch [message #227678 is a reply to message #227436]

Thu, 29 March 2007 00:46

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Running Oracle Services With Batch [message #228998 is a reply to message #227678]

Wed, 04 April 2007 23:40

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

Thanks i have run the script. It works quite well.
Once again thanks for reply.

Report message to a moderator

Previous Topic:	Trace Files problem
Next Topic:	How to Find ML Level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:25:08 CDT 2024