Search Results

I do give shutdown immediate. I don't use Shutdown as it takes forever to shutdown the database. The reason I need this solution is due to known bugs (MTS Related) in 9iR2 those are fixed in...

Thanks scottn for sharing your Script. Sorry for the poor title. I will try to do better next time.

Thanks KnockTurnAll for the post.
Any way I can do without hardcoding the date>?

That's right
Thanks for your reply.

This is what I want ..if the result of
ps -ef |grep sqljw something is from older then 2 days I want to do some other database script to run
end then exit

something like this

set x1 = 'ps...

when I run
ps -ef |grep sqljw
I get

sqlsys 4522102 1 0 Mar 05 - 0:52 dba_sqljw_DEV
sqlsys 4522201 1 0 Mar 08 - 0:52 dba_sqljw_DEV
sqlsys 4524104 1 0 ...

I have Oracle 9i R2 on AIX 5.2. My Database is running in shared server mode (MTS).

Sometimes when I shutdown the database it shutsdown cleanly in 4-5 mints and sometimes it takes good 15-20...

Up until now I used Oracle's Enterprise manager to submit the batch job. However its SMTP function (Sends EMail about Job status) is unstable lately. I want to use Unix's Cron to submit my batch job....

Thanks, Can you give syntax for the TAR command, please

Environment:
ServerA - IBM AIX 5.2
ServerB - IBM AIX 5.2

I want to clone one of my oracle installation. The easiest way is to ZIP(possibly use gzip) the installed folder from the ServerA (Here...