OraFAQ Forum: Windows » How can i execute Svrmgrl in a single line command in batch file

Home » Infrastructure » Windows » How can i execute Svrmgrl in a single line command in batch file

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

How can i execute Svrmgrl in a single line command in batch file [message #327019]

Fri, 13 June 2008 07:44

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Dear i want to start oracle 8.1.7 in windows xp so i use svrmgrl command the command step is

1). Svrmgrl
2). Connect internal
3). startup

but i want that i apply all three command in single line bath file where these paramters defined and when i run this batch all process complete as a single command how it possible please guide me and send me the syntax of batch file

kind regards
faheem

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327036 is a reply to message #327019]

Fri, 13 June 2008 09:06

ebrian
Messages: 2794
Registered: April 2006

Senior Member

(
echo conn internal
echo startup
) | sqlplus /nolog

Why not just use net start OracleService<sid_name> ?

[Updated on: Fri, 13 June 2008 09:32]

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327044 is a reply to message #327019]

Fri, 13 June 2008 09:22

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Why not just use net start OracleService<sid_name> please tell me how to start oracle service name i use following command but not working properly

oradim -startup -sid orcl

may be i am not use this command propery please tell me where i change in windows xp to start oracle service

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327045 is a reply to message #327044]

Fri, 13 June 2008 09:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Since your SID appears to be named ORCL, the command should be:

net start OracleServiceORCL

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327048 is a reply to message #327045]

Fri, 13 June 2008 09:51

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How to start this service

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327049 is a reply to message #327048]

Fri, 13 June 2008 09:54

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Have you tried to issue the command at a command prompt ? If so, what is the output?

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327394 is a reply to message #327019]

Mon, 16 June 2008 05:14

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

The Requestd service has already started if i use
net start OracleServiceORCL but did not start database

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327395 is a reply to message #327019]

Mon, 16 June 2008 05:14

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

The Requestd service has already started if i use
net start OracleServiceORCL but did not start database

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327396 is a reply to message #327019]

Mon, 16 June 2008 05:14

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

The Requestd service has already started if i use
net start OracleServiceORCL but did not start database

Report message to a moderator

Re: How can i execute Svrmgrl in a single line command in batch file [message #327398 is a reply to message #327396]

Mon, 16 June 2008 05:18

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Then make sure ORA_ORCL_AUTOSTART is set to TRUE in the registry. If you don't see, it then add it.

Report message to a moderator

Previous Topic:	ora 1034 ORACLE NOT AVAILABLE
Next Topic:	Export Database using DOS Batch File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 02 11:57:54 CDT 2025