Visit Our UNIX and Linux User Community


Automate restart Grid control

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions Automate restart Grid control
# 1  
Old 11-04-2009
Automate restart Grid control

Hi all,

I'm trying to write a batch program to automate restart of grid control.

oraclehomes\db10g\bin\lsnrctl status >> %filename%
oraclehomes\oms10g\bin\emctl status oms >> %filename%
(This is just for testing.)

However, i cannot seem to let both of the line to execute as the batch stopped when line 1 finish executing (without executing line 2).

Any help is appreciated. Thanks.
# 2  
Old 11-04-2009
Within the batch script, try preceding each of the two commands with "call " which will cause them to execute in their own batch shell, preventing the first job from exiting the whole batch job. (Not tested with your commands).

To read the help text about "call". From a "cmd" prompt:
Code:
call /?

# 3  
Old 11-04-2009
Thanks man, it works.Smilie

Is there anyway i can catch the status of my shutdown process?
e.g. lsnrctl stop will return the status telling it shutdown successfully?
# 4  
Old 11-06-2009
The "No longer listening on" messages will be in the Oracle listener log. Provided that you start a new log each time you start the Oracle listener, you can extract the messages with a MSDOS "find" command.

Not tried with your commands but you could try testing ERRORLEVEL immediately after executing the command, though I think that each command with the test for ERRORLEVEL would have to be in its own batch file executed from a call statement. We don't want to test the result of "call" itself.
ERRORLEVEL is explained in the help text for "if".

Code:
if /?

You'll have to check Oracle documentation for the ERRORLEVEL values from Oracle commmands.

Previous Thread | Next Thread
Test Your Knowledge in Computers #808
Difficulty: Easy
The CSS RGB Hex Code for Green is #008000.
True or False?

5 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Running RMAN backups from grid control but using oracle account with rsa keys vs a password ?

I'm a sysadmin trying to help out one of our DBA's setup the RMAN backups (Oracle 11g on rhel5 ) so they can schedule and control them from the OEM grid control. But we want the oracle user to use ssh keys instead of a password. I have the working rsa keys in place for the user but the GUI seems to... (0 Replies)
Discussion started by: samael00
0 Replies

2. High Performance Computing

how to do GRID COMPUTING?

Hello, I want to know how to combine the processing power of given 2 FEDORA machines in LAN. Can you please tell me the commands,etc used to perform such an operations.Can you please give me the links where I can find more info on this topic. (5 Replies)
Discussion started by: nsharath
5 Replies

3. UNIX for Dummies Questions & Answers

How to automate check outs from version control?

I'm in a fustrating situation where I am repeatidly checking code, editing, synchronizing, finding something is broke, reverting all my changes and starting over. This if often easier than trying to merge my changes with someone who has beat me to the checkin. Is there a way I can mitigate... (5 Replies)
Discussion started by: siegfried
5 Replies

4. High Performance Computing

Grid vs. Parallel vs. Distributed

Hello all, I was wondering if someone could either explain or maybe point me to another article somewhere that explains the difference between: distributed computing grid computing parallel computing I see these terms thrown around a lot in server and cluster environments, but I'd like a... (2 Replies)
Discussion started by: Heathe_Kyle
2 Replies

5. AIX

GRID containers technology

Hi forum, I am aware that on Hp-Superdome technology (Blade Servers) is avaliable while on Solaris GRID technology is the latest in the market. I would like to know if similar high end technology is also available for AIX ? (1 Reply)
Discussion started by: dheram
1 Replies

Featured Tech Videos