Re: 8.1.7.4.12 patch installation

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 13 Nov 2003 10:58:19 -0800
Message-ID: <1ac7c7b3.0311131058.6dfc3ca3@posting.google.com>

Chuck <chuckh_nospam_at_softhome.net> wrote in message news:<Xns94317C3D3A0E7chuckhsofthomenet_at_130.133.1.4>...
> Looking for recommendations to make applying this patch a little better.
> This is perhaps the UGLIEST Oracle patch I've ever seen. There are
> between 75 and 100 files that need to be manually copied from the patch
> directory to the %ORACLE_HOME% subdirectories. I have numerous servers
> running 8.1.7.4 that need to be patched and each time I do it I run into
> at least 10 files that can't be replaced even though all Oracle services
> are shut down. The error message I get states essentially that those
> files (mostly DLLs) are still in use. There are no applications on these
> servers. They're purely used as database servers. What suggestions do you
> have to avoid these errors?
>
> I have already tried disabling all Oracle services and rebooting the
> server. This didn't help at all.
>
> Upgrading to 9i is not an option. The applications are not certified to
> run against a 9i database

Chuck,

If you have file locking issues, check for backup software, snmp services.
download the utility psviewer or handle.exe from sysinternals.com to see what processes have handles on files (e.g. d:\oracle\ora81\bin\ociw32.dll)

here is a copy of an apply script from awhile ago. (use at your own risk - but it worked for me).

rem apply_patch_817412.bat
rem 7:23 PM 12/16/2002 - pld - applied patch set 81746 for win32 rem 2:53 PM 8/26/2003 - pld - applied patch set 817412 for win32 notepad d:\oracle\patches\817412\readme.txt echo read the fine readme.txt please
pause hit a key to continue ...
set oracle_home=D:\Oracle\Ora81
echo Oracle_Home is %ORACLE_HOME%
echo if that is not correct - please edit this file and rerun pause hit a key to continue, <CTRL-> to exit ... echo rem (1) Stop all oracle services.
net stop oracleserviceTEST
net stop oracleserviceDEV
net stop oracleservicePROD
net stop oracleorahome81tnslistener
net stop oracleorahome92tnslistener
net stop "Distributed Transaction Coordinator" net start
echo all oracle services should be stopped pause hit a key to continue
echo (2,6) copying *.dll, *.exe, *.bat to %ORACLE_HOME%\bin\

xcopy /V /C /F /Y D:\Oracle\patches\817412\*.dll %ORACLE_HOME%\bin\
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.exe %ORACLE_HOME%\bin\
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.bat %ORACLE_HOME%\bin\

pause hit a key to continue ...
echo (3) Install the NLS data files .nls xcopy /V /C /F /Y D:\Oracle\patches\817412\nlsdata\*.nlb %ORACLE_HOME%\OCOMMON\NLS\ADMIN\DATA\
pause hit a key to continue ...
echo (4) Copy the included files .sbs
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.sbs %ORACLE_HOME%\JAVAVM\INSTALL\SBS\
pause hit a key to continue ...
echo (5) Copy jtc.h to %ORACLE_HOME%\JAVAVM\JAHOME directory. xcopy /V /C /F /Y D:\Oracle\patches\817412\jtc.h %ORACLE_HOME%\JAVAVM\JAHOME\
pause hit a key to continue ...
rem (6) Copy classes111.zip and classes12.zip to %ORACLE_HOME%\JDBC\LIB directory.
xcopy /V /C /F /Y D:\Oracle\patches\817412\classes1*.zip %ORACLE_HOME%\JDBC\LIB\
pause hit a key to continue ...
rem (7) Copy aqapi.jar and aqapi11.jar to %ORACLE_HOME%\RDBMS\JLIB directory.
xcopy /V /C /F /Y D:\Oracle\patches\817412\aq*.jar %ORACLE_HOME%\RDBMS\JLIB\
pause hit a key to continue ...
echo (8) Copy *.sql, *.plb and *.sym to %ORACLE_HOME%\RDBMS\ADMIN xcopy /V /C /F /Y D:\Oracle\patches\817412\*.sql %ORACLE_HOME%\RDBMS\ADMIN\
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.plb %ORACLE_HOME%\RDBMS\ADMIN\
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.sym %ORACLE_HOME%\RDBMS\ADMIN\
pause hit a key to continue ...
echo (9) Copy the included files: deploync.bat, ncomp.bat, statusnc.bat to
echo %ORACLE_HOME%\bin directory.
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.bat %ORACLE_HOME%\bin\ pause hit a key to continue ...
echo (10) Copy catexp.sql, catproc.sql, prvtgdk.plb, prvtbfla.plb, utlgdk.sql to
echo %ORACLE_HOME%\RDBMS\ADMIN directory. xcopy /V /C /F /Y D:\Oracle\patches\817412\*.sql %ORACLE_HOME%\RDBMS\ADMIN\
xcopy /V /C /F /Y D:\Oracle\patches\817412\*.plb %ORACLE_HOME%\RDBMS\ADMIN\
pause hit a key to continue ...
echo (11) To install the symbols copy *.sym to %ORACLE_HOME%\RDBMS\ADMIN directory.
xcopy /V /C /F /Y D:\Oracle\patches\817412\n*.sym to %ORACLE_HOME%\RDBMS\ADMIN\
pause hit a key to continue ...
echo (12) To install the Network message files copy naukus.msb, nltus.msb to
echo %ORACLE_HOME%\NETWORK\MESG directory. xcopy /V /C /F /Y D:\Oracle\patches\817412\n*.msb %ORACLE_HOME%\NETWORK\MESG\
pause hit a key to continue ...
echo (13) install the RDBMS message files to %ORACLE_HOME%\RDBMS\MESG xcopy /V /C /F /Y D:\Oracle\patches\817412\oraus.msb %ORACLE_HOME%\RDBMS\MESG\
pause hit a key to continue ...
echo (14) To install agent patch, copy updown.tcl to echo %ORACLE_HOME%\network\agent\events\oracle\sqlnet\fault xcopy /V /C /F /Y D:\Oracle\patches\817412\updown.tcl %ORACLE_HOME%\network\agent\events\oracle\sqlnet\fault\ pause hit a key to continue ...
exit

net start OracleServive%ORACLE_SID%
sqlplus /nolog @817412_post_apply_scripts.sql echo patchset has been applied successfully echo create a new backup set prior to opening the database for user connections
pause
exit Received on Thu Nov 13 2003 - 12:58:19 CST