Security patch 68

These are two files that I develop to install the security 68 patches for
9.2.0.5 on win2000.
The sql file is at the bottom and it is run from the batch file.
The run assume that an oracle database exist and need to patch.
The batch file will install the first patch, run all the sql scripts needed
and install the second patch.
Check that my mail did not warp lines before you run it.

Batch file:

echo off
rem unzip patch 3738339 to
file_server\oracle_install\9.2.0.5.3_unzipped\3738339
rem unzip patch 3847290 to file_server\oracle_install\9.2.0.5.3_2_unzipped

cd /d %4:\9.2.0.5.3_2_unzipped

rem check parameters

if x%1 == x goto usage
if x%2 == x goto usage
if x%3 == x goto usage
if x%4 == x goto usage
if x%5 == x goto usage

rem check parameters and echo usage.
echo make sure that all oracle services are down. you will get copy errors
otherwise.
echo also make sure that there are no active applications using oracle.
echo make sure that the drive letter %4 is not used on this computer
pause press any key to continue

echo on


rem assign drive letter to patch and copy new opatch
rem you can run this part again because in the second run the rename and md
fails
rem and it just copy the new opatch again.

net use %4: \\file_server\oracle_install
cd /d %1
rename opatch opatchold
md opatch
cd opatch
xcopy /Y /E %4:\opatch

rem patch 3738339

rem set path, oracle home, sid and apply patch.
set path=%cd%;%path%
set oracle_home=%1
set oracle_sid=%2
cd /d %4:\9.2.0.5.3_unzipped\3738339

rem goto second   unrem this line to run only the second patch.

rem if the patch installed ok and the scripts failed later just rem the next
line on rerun

call opatch apply %4:\9.2.0.5.3_unzipped\3738339

echo check apply results. press any key to continue. press ctrl-C to stop.
pause

rem now start the database and run scripts
lsnrctl start listener
oradim -startup -sid %2 -STARTTYPE srvc,inst
cd /d %1\rdbms\admin
sqlplus "/ as sysdba" @%4:opatch_3738339_1.sql %3

rem - patch 3847290

cd /d %4:\9.2.0.5.3_2_unzipped
call patch.cmd -m sysobjects -o %1 -c "sys as sysdba" -p %5
call patch.cmd -m midtier -o %1
cd /d %1
goto end

:usage
echo usage:
echo activate this patch with the following parameters:
echo  1) oracle home, including the drive letter: c:\oracle\ora92
echo  2) oracle sid
echo  3) ctxsys password
echo  4) drive letter to connect to file_server
echo  5) sys password

:end
net use %4: /delete
Echo opatch run finished

****************************************************************************
**************

SQLFILE opatch_3738339_1.sql :

set echo on
spool patch68.log
shutdown immediate
startup migrate
set echo off
@prvtstas.plb
@prvtstat.plb
@catproc.sql
@dbmsiotc.sql
alter user ctxsys account unlock;
alter user ctxsys identified by &1;
connect ctxsys/&1
@..\..\ctx\Admin\dr0out.plb
connect / as sysdba
alter user ctxsys account lock;
alter user ctxsys password expire;
alter session set current_schema=MDSYS;
@..\..\md\admin\sdolrsmd.sql
@..\..\md\admin\prvtgmd.plb
shutdown
startup
@prvtpexp.plb
Exit






--
http://www.freelists.org/webpage/oracle-l

Other related posts:

  • » Security patch 68