Home » Infrastructure » Windows » How can i execute Svrmgrl in a single line command in batch file
How can i execute Svrmgrl in a single line command in batch file [message #327019] Fri, 13 June 2008 07:44 Go to next message
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Since your SID appears to be named ORCL, the command should be:

net start OracleServiceORCL
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 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How to start this service
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
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.
Previous Topic: ora 1034 ORACLE NOT AVAILABLE
Next Topic: Export Database using DOS Batch File
Goto Forum:
  


Current Time: Fri Mar 29 00:42:48 CDT 2024