Tuesday, August 28, 2007
Thursday, August 16, 2007
Reference for Shell Scripting
I am a subscriber to the newsletter from
oracle_tips@topica.email-publisher.com
for the last three years and used to get good and informative mails from them.
The following pdf document reference is the one I received recently and found very useful as a reference in my day to day Oracle DBA activities.I've even shared the same to many of my known Oracle DBAs and Unix administrators.Blogging here by giving the link if someone will find it useful.
http://www.dba-oracle.com/Shell-Script-sec.pdf
Source Donald K. Burleson
oracle_tips@topica.email-publisher.com
Happy reading..
oracle_tips@topica.email-publisher.com
for the last three years and used to get good and informative mails from them.
The following pdf document reference is the one I received recently and found very useful as a reference in my day to day Oracle DBA activities.I've even shared the same to many of my known Oracle DBAs and Unix administrators.Blogging here by giving the link if someone will find it useful.
http://www.dba-oracle.com/Shell-Script-sec.pdf
Source Donald K. Burleson
oracle_tips@topica.email-publisher.com
Happy reading..
Wednesday, August 15, 2007
CPUJul2007
Received the auto generated mail from Metalink on the release of CPU July 2007 and food is ready for my colleague Ganesh for next few weeks.Ganesh is like a care taker for few hundred databases in our organization and ensure that all the databases are patched to meet the audit requirements.I used to crack jokes on him by saying that his breakfast and late supper is patching the databases on Development and UAT databases and during the weekends his breakfast,lunch and dinner is applying the CPU patches on to production systems once the UAT systems are signed of for the Patch applied by the application team.
The great news is we have automated the execution of the catcpu.sql script against each database after patching the Oracle binary.Otherwise it is going to be a monotonous and very boring job that everytime we are required to export the ORACLE_SID,ORACLE_HOME and other envrionment variables,
cd $ORACLE_HOME/cpu directory
executing sqlplus "/as sysdba" run the catcpu.sql against each database.. Oh my goodness it is going to be a laborious job to do all these especially after a longday.
Now only thing required is apply the patch by using the opatch utility and calling the Shell script to run the catcpu.sql against the each database running on the specific server, Life is so cool..
Link for summary on CPUJULY2007 is
http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2007.html
The great news is we have automated the execution of the catcpu.sql script against each database after patching the Oracle binary.Otherwise it is going to be a monotonous and very boring job that everytime we are required to export the ORACLE_SID,ORACLE_HOME and other envrionment variables,
cd $ORACLE_HOME/cpu directory
executing sqlplus "/as sysdba" run the catcpu.sql against each database.. Oh my goodness it is going to be a laborious job to do all these especially after a longday.
Now only thing required is apply the patch by using the opatch utility and calling the Shell script to run the catcpu.sql against the each database running on the specific server, Life is so cool..
Link for summary on CPUJULY2007 is
http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2007.html
Subscribe to:
Posts (Atom)