What method do you use to startup the DB? do you use any scripts (in case of dataguard installed) or you log on to SQL as sysdba and run startup?
---------- Post updated at 02:21 PM ---------- Previous update was at 02:13 PM ----------
You can use this..
Code:
for line in `awk -F"[#:*]" 'NF==3&&$1~/./{print $1}' /wload/clht/app/etc/oratab` ; do
ps -ef|grep $line|grep pmon > /dev/null
if [ $? -eq 0 ] ; then
echo "DB $line is up and running"
else
echo "DB $line is not running"
#Your DB startup script goes in here I would say set ORACLE_SID to $line before you startup
fi
done
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)
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)
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)
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)
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)
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)
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)
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
... (0 Replies)
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 PHP
exit
EXIT(3) 1 EXIT(3)exit - Output a message and terminate the current scriptSYNOPSIS
void exit ([string $status])
DESCRIPTION
void exit (int $status)
Terminates execution of the script. Shutdown functions and object destructors will always be executed even if exit is called.
exit is a language construct and it can be called without parentheses if no $status is passed.
PARAMETERS
o $status
- If $status is a string, this function prints the $status just before exiting. If $status is an integer, that value will be used
as the exit status and not printed. Exit statuses should be in the range 0 to 254, the exit status 255 is reserved by PHP and
shall not be used. The status 0 is used to terminate the program successfully.
Note
PHP >= 4.2.0 does NOT print the $status if it is an integer.
RETURN VALUES
No value is returned.
EXAMPLES
Example #1
exit example
<?php
$filename = '/path/to/data-file';
$file = fopen($filename, 'r')
or exit("unable to open file ($filename)");
?>
Example #2
exit status example
<?php
//exit program normally
exit;
exit();
exit(0);
//exit with an error code
exit(1);
exit(0376); //octal
?>
Example #3
Shutdown functions and destructors run regardless
<?php
class Foo
{
public function __destruct()
{
echo 'Destruct: ' . __METHOD__ . '()' . PHP_EOL;
}
}
function shutdown()
{
echo 'Shutdown: ' . __FUNCTION__ . '()' . PHP_EOL;
}
$foo = new Foo();
register_shutdown_function('shutdown');
exit();
echo 'This will not be output.';
?>
The above example will output:
Shutdown: shutdown()
Destruct: Foo::__destruct()
NOTES
Note
Because this is a language construct and not a function, it cannot be called using variable functions.
Note
This language construct is equivalent to die(3).
SEE ALSO register_shutdown_function(3).
PHP Documentation Group EXIT(3)