One last question on this. I have installed both the 8.1.7.1.1 and the 8.1.7.1.5 patches to my server. Do I need to reinstall the client on my desktop? I would think so. The 1.1 patch doesn't mention anything about it, but the 1.5 has the following after upgrading the server:
8.1.7.1.5 Client only Installation Instructions:
--------------------------------------------
(1) Make sure all applications that use the Oracle Client are shutdown.
This may include Webservers if any, that load Oracle client in the
mid tier.
-- The Patch might include files from components that you might
not have currently installed. If you find a file that is included
with the patchset but not in your current installation, then
you do not have to copy that file.
(2) Copy the included files: oraclient8.dll, orageneric8.dll, oranoncj8.dll,
orapls8.dll, orancrypt8.dll, procui.exe, procus8.dll, orasql8.dll,
ocijdbc8.dll, oran8.dll, oranjni8.dll, oranl8.dll, oranls8.dll sqlplus.exe,
sqlplusw.exe and proc.exe to %ORACLE_HOME%\bin directory.
(3) Install the NLS data files by copying all the .nlb files under nlsdata
directory to %ORACLE_HOME%\OCOMMON\NLS\ADMIN\DATA directory.
(4) Copy pr2us.msb to %ORACLE_HOME%\PRECOMP\MESG directory.
(5) Copy utlrp.sql, oranls8.sym, orapls8.sym, oraclient8.sym, orageneric8.sym
to %ORACLE_HOME%\RDBMS\ADMIN directory.
(6) Copy classes111.zip to %ORACLE_HOME%\JDBC\LIB directory.
(7) Copy classes12.zip to %ORACLE_HOME%\JDBC\LIB directory.
(8) Copy all the .pre files under precomp\demo\proc directory to the
respective directory as given below.
1) %ORACLE_HOME%/precomp/demo/proc/Ansidyn1/Ansidyn1.pre
2) %ORACLE_HOME%/precomp/demo/proc/Ansidyn2/Ansidyn2.pre
3) %ORACLE_HOME%/precomp/demo/proc/Coldemo1/Coldemo1.pre
4) %ORACLE_HOME%/precomp/demo/proc/Cppdemo1/Cppdemo1.pre
5) %ORACLE_HOME%/precomp/demo/proc/Cppdemo2/Cppdemo2.pre
6) %ORACLE_HOME%/precomp/demo/proc/Cppdemo3/Cppdemo3.pre
7) %ORACLE_HOME%/precomp/demo/proc/Cv_demo/Cv_demo.pre
8) %ORACLE_HOME%/precomp/demo/proc/empclass/empclass.pre
9) %ORACLE_HOME%/precomp/demo/proc/Lobdemo1/Lobdemo1.pre
10) %ORACLE_HOME%/precomp/demo/proc/Mltthrd1/Mltthrd1.pre
11) %ORACLE_HOME%/precomp/demo/proc/Navdemo1/Navdemo1.pre
12) %ORACLE_HOME%/precomp/demo/proc/Objdemo1/Objdemo1.pre
13) %ORACLE_HOME%/precomp/demo/proc/Oraca/Oraca.pre
14) %ORACLE_HOME%/precomp/demo/proc/Plssam/Plssam.pre
15) %ORACLE_HOME%/precomp/demo/proc/Sample/Sample.pre
16) %ORACLE_HOME%/precomp/demo/proc/Sample1/Sample1.pre
17) %ORACLE_HOME%/precomp/demo/proc/Sample10/Sample10.pre
18) %ORACLE_HOME%/precomp/demo/proc/Sample11/Sample11.pre
19) %ORACLE_HOME%/precomp/demo/proc/Sample12/Sample12.pre
20) %ORACLE_HOME%/precomp/demo/proc/Sample2/Sample2.pre
21) %ORACLE_HOME%/precomp/demo/proc/Sample3/Sample3.pre
22) %ORACLE_HOME%/precomp/demo/proc/Sample4/Sample4.pre
23) %ORACLE_HOME%/precomp/demo/proc/Sample5/Sample5.pre
24) %ORACLE_HOME%/precomp/demo/proc/Sample6/Sample6.pre
25) %ORACLE_HOME%/precomp/demo/proc/Sample7/Sample7.pre
26) %ORACLE_HOME%/precomp/demo/proc/Sample8/Sample8.pre
27) %ORACLE_HOME%/precomp/demo/proc/Sample9/Sample9.pre
28) %ORACLE_HOME%/precomp/demo/proc/Sqlvcp/Sqlvcp.pre
29) %ORACLE_HOME%/precomp/demo/proc/Winsam/Winsam.pre
(9) A new precompile time option win32_threads is introduced for proc.
The default value for the option win32_threads is "no" and it can take
values "yes" or "no". The documented way of using multithreading with precompiler
applications is to precompile with option threads=yes, however if there are
any multithreaded precompiler applications that are precompiled with
threads=no, then they should now be precompiled with option win32_threads=yes.
(10)The procui.exe (the proc gui tool) has the newly introduced
win32_threads option. NOTE: ".pre" files created with previous versions of
procui.exe cannot be opened with this version and get error Unexpected
file format.
Previously created .pre files need to be recreated again.
This client only patch installation is complete.
Terry M. Hoey
