05-14-2013
Check for DB status and startup DB
EXPERTS,
I need a shell script to check the DBs status (Running/Shutdown) in the server.If its Running then no issue but if it is in shutdown state ,it should prompt like " DB is shut down you want to startup??" if i enter YES it should startup.
ORACLE_SID are present in /var/opt/oracle/oratab
Atleast need a logic to implement this..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
We have a text file which has the following data.
ISA~00~ ~00~ ~ZZ~VISTN ~ZZ~U1CAD ~051227~183
7~U~00200~000011258~0~P~<
GS~FA~EE05J~U1CAD~051227~1831~000011258~X~002002
ST~997~0001
AK1~SH~247
AK2~856~2470001
AK5~A
AK2~856~2470002
AK5~A... (3 Replies)
Discussion started by: isingh786
3 Replies
2. HP-UX
Hi All,
I am having shell scripts that make use of ftp to fetch data from one hp-ux box to another. Currently we are migrating these scripts to sftp. Is it a straight forward one? Also, please clarify my following doubts:
1) In ftp we check the success of ftp by verifying the status codes... (4 Replies)
Discussion started by: fisa
4 Replies
3. Shell Programming and Scripting
Hi,
I wrote a script that is generating a file and then i have to ftp this file on another server. For this i am using mput to put the file.
How can i make sure that the file was ftp'd correctly to the another server, is there any status check ?
Thanks. (1 Reply)
Discussion started by: smc3
1 Replies
4. Shell Programming and Scripting
To all,
I need to run a ftp command in one of my scripts and I need to evaluate what happens after it's done. The problem is the script would not capture the ftp responses. If I type the same thing on the command
line, I get all kinds of responses. I would like to capture the same responses in... (2 Replies)
Discussion started by: april
2 Replies
5. AIX
hello ,
How do i to check the status of ypbind on AIX(5.3) platform ?
Thanks
AVK Linux (1 Reply)
Discussion started by: avklinux
1 Replies
6. Shell Programming and Scripting
Hello All,
I'm new in shell scripting and would like to write an automated script that will check few jobs for the completion, and restart the process based on the jobs status. I am not quite sure how do I check the job status... Can someone please help? Any help will be appreciated. Thanks in... (1 Reply)
Discussion started by: mohullah
1 Replies
7. UNIX for Advanced & Expert Users
Hi,
I have master job which will run based on the sub jobs status.
In the master job I am giving the condition like,
condition: s(sub_job) f(sub_job)
This scenario will work if the sub job status is success or failed. but I want to run my master job even if the sub_job was... (1 Reply)
Discussion started by: Kattoor
1 Replies
8. Shell Programming and Scripting
I have some server ( IBM , Dell ) , our data center is not in the same location with office , therefore , I do not know if the HD lamp is flash when the HD is fault , can advise if I can write a script to check if the HD is normal running or not ?
thanks (1 Reply)
Discussion started by: ust
1 Replies
9. Shell Programming and Scripting
EXPERTS,
I need a UNIX shell script to check the DBs status (Running/Shutdown) in the server.If its Running then no issue but if it is in shutdown state ,it should prompt like " DB is shut down you want to startup??" if i enter YES it should startup.
ORACLE_SID are present in... (18 Replies)
Discussion started by: navsan420
18 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
Have a query
How to check for a process and if down start it , try if for 2 times and its not starting don't do it
My code is working to some extent but while starting try starting both times.
Please advise , whats wrong here ?
if you have any other approach please do share.
My... (1 Reply)
Discussion started by: abhaydas
1 Replies
LEARN ABOUT ULTRIX
rpc_allow_remote_shutdown
rpc_allow_remote_shutdown(3ncs) rpc_allow_remote_shutdown(3ncs)
Name
rpc_allow_remote_shutdown - allow or disallow remote shutdown of a server (server only)
Syntax
#include <idl/c/rpc.h>
void rpc_$allow_remote_shutdown(allow, checkproc, status)
unsigned long allow;
rpc_$shut_check_fn_t checkproc;
status_$t *status;
Arguments
allow A value indicating `false' if zero, `true' otherwise.
checkproc A pointer to a Boolean function.
status The completion status. If the completion status returned in is equal to status_$ok , then the routine that supplied it
was successful.
Description
The routine allows or disallows remote callers to shut down a server using
By default, servers do not allow remote shutdown via If a server calls with allow true (not zero) and checkproc nil, then remote shutdown
will be allowed. If allow is true and checkproc is not nil, then when a remote shutdown request arrives, the function denoted by checkproc
is called and the shutdown is allowed if the function returns true. If allow is false (zero), remote shutdown is disallowed.
Diagnostics
This section lists status codes for errors returned by this routine in
rpc_$not_in_call An internal error.
rpc_$you_crashed This error can occur if a server has crashed and restarted. A client RPC runtime library sends the error to the server
if the client makes a remote procedure call before the server crashes, then receives a response after the server
restarts.
rpc_$proto_error An internal protocol error.
Files
See Also
intro(3ncs), rpc_shutdown(3ncs), rrpc_shutdown(3ncs)
rpc_allow_remote_shutdown(3ncs)