Patch Release Notice
										 ORACLE 								for 						SPARC Platforms
6.0.33 RDBMS Patch 6 Release
Part No. 6616-60-0492


1.0 General
6.0.33 RDBMS Patch 6 Release is for the ORACLE 6.0.33 RDBMS release running on SPARC platforms with SunOS 4.1.1 or 4.1.2 or their derivatives. This patch release subsumes and replaces all previous patches for the 6.0.33 RDBMS release. After this patch release is applied, the ORACLE RDBMS version will be changed to 6.0.33.2.3. Postscript and plain text copies of this Patch Release Notice, relnotice.ps and relnotice.txt, can be found in the patch directory.
2.0 Patch Contents
This release contains patches for bug fixes, new version of products, and product enhancements. We recommend that you apply all the patches. The total size of this distribution is 25.1 Megs.
2.1 SQL*Forms30/SQL*Menu50 Motif and OpenLook
SQL*Forms30/SQL*Menu50 OpenLook have been certified under OpenWindows 3.0 with Patch 100451-09 from Sun.
This patch will not work with previous versions of OpenWindows. If you do not have OpenWindows 3.0 with the appropriate patch available on your machine, do not patch SQL*Forms30 or SQL*Menu50.
README files for Motif and OpenLook versions of SQL*Forms30 are located in the directories $ORACLE_HOME/mprodins and $ORACLE_HOME/olprodins respectively. Please refer to the README files for more information.

IMPORTANT NOTES:
OPENWINDOWS 3.0 WITH PATCH 100451-09 IS REQUIRED IF YOU WISH TO RE-LINK THE OPENLOOK VERSION OF SQLFORMS30/SQLMENU50. Note that the OpenLook versions of the orakit, forms30 and menu5 libraries provided in this patch will NOT work with the OpenWindows 2.0/2.5 libraries. This patch is currently available from Sun.




MOTIF 1.1.2 IS REQUIRED IF YOU WISH TO RELINK THE MOTIF VERSION OF SQLFORMS30/SQLMENU50. In order to relink the Motif products, Oracle requires a copy of libXm.a that contains the fix for OSF bug P2628. This bug is fixed in Motif 1.1.2.
The Motif version also requires the version of libXt.a supplied with OpenWindows 3.0 with patch 100451-09. The previous versions of OpenWindows libraries will not work with the Motif implementation. 

With this patch tape, Oracle no longer ships ANY X11, OpenLook, or Motif object libraries. 
Whereas $ORACLE_HOME/mprodins used to contain X11 libraries, and $ORACLE_HOME/olprodins used to contain X11 and OpenLook libraries, we now require our products to be linked with the versions of these libraries provided with OpenWindows from Sun. We will continue to work aggressively with Sun to make sure that problems are resolved as quickly as possible.

The SQL*Forms30 and SQL*Menu50 makefiles have changed. The sqlforms30.mk and sqlmenu5.mk files provided with this patch expect to find the OpenWindows libraries installed under the /usr/openwin/lib directory. They also look for the Motif libXm.a file under the directory /usr/lib. 
If this is not the case for your site, please find and modify the following lines in the makefiles:
OPENWINHOME=/usr/openwin
OLLIBS=-L$(OPENWINHOME)/lib -lXol -lXt -lX11 -lm
MOTIFLIBS=/usr/lib/libXm.a -L$(OPENWINHOME)/lib -lXt -lX11 -lm

Known bugs:
103989 - MOTIF: scroll down/up in runform30 takes to long to scroll.
Scrolling through records in a form with multiple records in Motif takes too long. Records are adjusted one at a time instead of several at once. 
98470 - MOTIF & OpenLook: NLS spanish problem.
The spanish translations are not available yet.
94614 - OpenLook: list_value(restrict) not working properly. 
When only one record matches the query criteria using a list_value(restrict), then the form aborts.

2.2 Version 1.2.7.3.1 of orasrv
This patch release contains V1.2.7.3.1 of orasrv, which supports the fourth field in the /etc/oratab file (to fork a process other than oracle) and also allows the socket address to be reused.
2.3 Version 1.0.33.1.1 of PL/SQL
This patch release contains V1.0.33.1.1 of PL/SQL, which fixes bugs 80422 and 78693 (see 2.10 Bug Fixes for the descriptions of these bugs). SQL*ReportWriter Version 2 BETA Customers should not install this patch.
2.4 Support for Multiprocessor SPARC Platforms
This release includes a special patch to take advantage of multiprocessor (MP) architecture. This patch is for MP machines only, and, if installed, will have no effect on single-processor machines.
The following tunable init.ora parameters will be supported as a result of this MP patch. These parameters should only be set for the MP machines.
cpu_count
This parameter specifies the number of CPUs running on an MP machine. On Sun and Solbourne MP machines, the value of cpu_count is set internally and automatically by the RDBMS; do not specify a value for this parameter in the init.ora file.
The log_simultaneous_copies redo parameter specifies the number of copy latches; if this is not specified, then the default value is set to cpu_count. Note that the SQL*DBA show parameters command will show the value of this parameter as the default, which is zero, rather than the internally determined value.
spin_count
This parameter sets the number of times an ORACLE process attempts to get a latch before sleeping. If the ORACLE process tries to get a latch, and finds that it is busy, ORACLE spins and checks back with the latch up to spin_count number of times until the latch is not busy. Once it hits spin_count, the ORACLE process sleeps for a set period of time, then wakes up and tries again.
You can adjust performance by changing the value of spin_count. If you use a high value, you will get the latch sooner than if you use a low value. However, you may use more CPU time spinning to get the latch if you use a high value for spin_count.
With regard to tuning, note that the default value is 0, i.e. no spinning, which should be the setting for single-processor machines. If there is a lot of latch contention and it is unlikely that a latch will be acquired during the spin, you should set this number low so that the process can relinquish the CPU to other processes. A reasonable spin_count value is 2000.

2.5 Sun Database Excelerator
For additional Oracle RDBMS performance support, please consult with your Sun sales representative about the Sun Database Excelerator.
2.6 Version 6.0.34 of imp
This patch release contains version 6.0.34 of imp, which fixes import problems for Oracle Financials and bugs 83639 and 91600.
2.7 Pro*Ada Runtime Source
This patch release contains Pro*Ada runtime source for Sun Ada 1.0 and Verdix Ada 6.0.3D. This source is used for on-site recompilation. To recompile use the commands:
	% cd $ORACLE_HOME/ada/runtime
% make -f proada.mk compile
2.8 Support of Sun DNI Version 7.0
Version 1.2.16 of SQL*Net DECnet, which is bundled with 6.0.33 release, has been certified to run with Sun DNI Version 7.0.
2.9 Oracle for Datalens 1-2-3 Support for Lotus 1.1
Version 1.0.4 of Oracle for Datalens 1-2-3 allows accessing data from an Oracle database while using Lotus 1-2-3 (Now including Lotus version 1.1 for the Open Look Interface).
IMPORTANT: FOR REQUIRED SUN-OS LOTUS-SPECIFIC PATCHES AND KNOWN BUGS, SEE $ORACLE_HOME/datalens/rel_note1.1.

2.10 Bug Fixes
This patch includes the following bug fixes:
RDBMS
64031 - Arguments [3339] [0] [134217735] in rdbms test when db_writers > 1.
77770 - Database link gave ORA-3100 when used after connecting remotely.
79275 - Imp terminated with error EX_FAIL when it should have errored with EX_WARN.
82273 - Unexpected server termination with signal 6.
No Bug# - Wrong array size in table replication feature
No Bug# - Multi-Processor Patch
54213 - Undo the changes made to optimizer since 6.0.31.0.
81137 - Shadow process size grows significantly when running pl/sql block.
78874 - Process size increases with repeated rollback in exception handler.
61671 - Import fails to create objects that span a physical block boundary.
76031 - Error IMP-8 depending on the buffer size
88043 - Numbers rounded incorrectly in Rdbms, Sql*Plus, Sql*Forms etc.
91924 - Db-links with pipe driver fails unless a select to table on default.
90554 - Release of cursors is too slow.
83639 - Import core dumps when get duplicate key in index errors.
91600 - Import errors with ORA-0001, then does a core dump.
98478 - ORACLE_PATH not being used after installing Patch #4.
99811 - Terribly slow after upgrading to Sun 670MP.
101676 - SQL*DBA Monitor Latch shows all zeros for time-outs -- same with v$latch.
INSTALL
78170 - tools.boot rev 6.17: KEY_LENGTH not found.
PL/SQL
80422 - PLSQL-358: `ROWNUM' existed in more than one table; use qualifier.
78693 - CALL/NEW_FORM did not release cursors.
SQL*Forms (version 2.3)
77899 - #EXEMACRO COPY or #COPY did not copy properly if last character is 8 bit.
77164 - Assigning SYSDATE in 8 bit character set language, e.g. French gave problem 	during validation.
94381 - Printing German umlaut with F9 results in `^'. The Base bug# for this bug is 57657.
SQL*Forms30/SQL*Menu50(CHARACTER)
81892 - Gets core dump when generating a menu application.
81975 - Core dump from [show keys] screen.
86292 - Clear record and duplicate field mapped both to r1 f2.
86394 - sun.r: r1 f2 is mapped to perform 2 different functions.
86801 - Cannot link in fortran user exits with makefile provided.
No Bug# - 6.0.32 patch 2.
No Bug# - Key mapping for Screen Painter doesn't show up when using xtermncd:ncd220
SQL*Forms30/SQL*Menu50(MOTIF)
61703 - Can't navigate with mouse into block with no updateable fields.
71345 - Roles/users could be entered in lower case.
71409 - Modifying size of initial window not possible.
75135 - Window input was not following mouse selection consistently.
75137 - Rollback does not consistently clear all fields in Motif.
76954 - No limit on number of enterable characters. 
76984 - Going to the next field after entering an invalid date, cleared the date.
77379 - Replace menu did not show up on pop-up page.
77382 - Values were echoed even if echo input was turned off.
78009 - Display error cut off line.
81892 - Gets core dump when generating menu application.
82537 - Unable to change boiler-plate font.
83812 - Got core dump after calling iapcal() a second time.
84577 - Exiting msqlforms or msqlmenu leaves screen cursor an x.
84742 - Motif: the menu titles have to have one and only one capitol letter.
84748 - Motif: List of values (lov) ignores the location in field description.
85126 - Can not enter the umlaute character in runform.
86762 - Msqlforms \? gives -e as an option but msqlforms30 -e gives error.
87088 - Keys don't work when pointer on editor attributes.
87765 - Show Keys does not correctly display mappings.
88416 - Return and Tab behave differently in IAD, some fields are unreachable.
90430 - Core dump using set_field('ordid',displayed,attr_off).
90431 - The form grows when doing a call form.
92454 - Key-nxtkey does not fire.
94453 - If orakit file has error color allocation fails but no error recovery is done.
96661 - If you get show keys from menu bar, it will not highlight any. 
97181 - Can not erase using backspace if field is full.
97328 - Popup, remove on exit window closes when cursor enter any window on form.
98367 - Disable and Enable items behave differently between bitmap and char.
99162 - Core dump in runform with mouse navigation limit set to field.
99473 - Core dump if you attempt to cut field from block other than current.
101163 - Size of windows turns smaller after applying patch #5.
103013 - Motif: Runform core dumps.
No Bug#- Fields were not being cleared completely.
No Bug# - Makefile for forms30 Ada user exits with OPEN LOOK support.
SQL*Forms30/SQL*Menu50(OPEN LOOK)
61703 - Can't navigate with mouse into block with no updateable fields.
67893 - ACCVIO; Corrupted SQL statement to query referenced object.
71345 - Roles/users could be entered in lower case.
71409 - Modifying size of initial window not possible.
72008 - Sqlforms30.mk for olsqlforms30 looked for /home/openwin.
73900 - Values were echoed even if echo input was turned off.
73901 - Horizontal scroll bar was not working for pop-up windows.
73902 - List of values window was not positioned properly.
73915 - Autoskip skipped the field one char early.
73916 - In designer, the editor attributes showed blank the second time.
73917 - Could not see value in the current field if the length was 1, with echo input on.
74763 - Made fields active when cursor moved into the field.
75135 - Window input did not consistently follow mouse.
75137 - Rollback does not consistently clear all fields in Open Look.
76900 - Menus did not work after an os_command form command type 7.
76901 - Infinite loop with command type 5 menu and two parameters.
76904 - Calling a form left part of previous showing.
76954 - No limit on number of enterable characters.
76984 - Going to the next field after entering an invalid date, cleared the date.
77409 - Open Look: core dumps without the olorakit file in the home directory.
78009 - Display error cut off line.
79314 - Core dumped in designer quite often.
79718 - Make on obj: olsqlforms30x failed with unref symbols.
80675 - Resize_View did not work in Open Look.
81333 - Selection made in Page Definition spread table did not coincide with full screen.
81892 - Gets core dump when generating a menu application.
81961 - Able to go to next block in enter query mode; caused assert failure.
82537 - Can't change boiler plate to anything but chapter and fixed.
85157 - Tab and F1 keys do not function in Screen Painter.
86762 - olsqlforms \? gives -e as an option but olsqlforms30 -e gives error.
87662 - Popup, remove on exit window closes when cursor enter any window on form.
90755 - Core dumps when hitting F5 the show keys key in designer.
94453 - If orakit file has error color allocation fails but no error recovery is done.
94584 - Returning to an iconised form from a popup page gives Xlib fatal error.
96661 - If you get show keys from menu bar, it will not highlight any.
96790 - Iapcal() does not work if you try to call a bit-mapped olrunforms.
98367 - Disable and Enable items behave differently between bitmap and char.
100357 - Procedure name may be entered with more than 30 characters.
No Bug# - Makefile for forms30 Ada user exits with OPEN LOOK support.
CRTTORES
90691 - Oraterm hangs on opening resource file created by crttores.
SQL*Net
91794 - Disconnect from Oracle needs to wait on specific PID.
102629 - Orasrv hangs if handshake connection not established.
SQL*Plus
72159 - Could not create the sqlplus executable with forms30 linked in.
SQL*ReportWriter
78169 - Srw.install terminal selection was erroneous.
CASE*Dictionary
29221 - Domains could not be unshared/uncoupled from applications.
CASE*Designer
84850 - Fixes core dump created by linking with X libraries with less than patch 18 for 
CASE*Designer V1.1.20.2.4, bundled with CASE*Dictionary V4.1.
No Bug# - Fixes core dump created by linking with X libraries with less than patch 18 for 
CASE*Designer V1.1.21.0.1, bundled with CASE*Dictionary V5.0.
ORACLE*Mail
91822 - Aliases getting truncated to 30 characters on connect node.
Oracle for Datalens 1-2-3
No Bug# - Oracle for Datalens 1-2-3 upgrade for Lotus 1.1 for OPEN LOOK.





3.0 Documentation Errors
3.1 ORACLE for Lotus 1-2-3 Datalens
In Chapter 24 of V6.0.30 Installation and User's Guide, the version number of Lotus 1-2-3 required by ORACLE is incorrect. Instead of Lotus 1-2-3 for Sun Release 3, Lotus 1-2-3 for Sun Version 1.0 is required by ORACLE.
Please see 2.9 on support for Lotus 1-2-3 for Sun Version 1.1.
4.0 Installation Procedures
Before installing this tape, please shut down the database.
	% sqldba shutdown
To install the tape, perform the following steps:

1. Move old $ORACLE_HOME/install/patch, $ORACLE_HOME/mprodins and 
$ORACLE_HOME/olprodins.
	% mv $ORACLE_HOME/install/patch $ORACLE_HOME/install/patch.save
	% mv $ORACLE_HOME/mprodins $ORACLE_HOME/mprodins.save
	% mv $ORACLE_HOME/olprodins $ORACLE_HOME/olprodins.save

2. Read the patch in from the tape:
	% cd $ORACLE_HOME
	% tar xvf /dev/rst0

3. Set the PATCH_HOME environment variable:
	% setenv PATCH_HOME $ORACLE_HOME/install/patch

4. Install the patch. Please refer to Chapter 4 of the Installation and User's Guide on oracle.patch:
	% cd $ORACLE_HOME/install/patch
	% ./oracle.patch

5. Save oracle.patch for future use:
	% mv $ORACLE_HOME/install/oracle.patch $ORACLE_HOME/install/oracle.patchO
	% cp $ORACLE_HOME/install/patch/oracle.patch $ORACLE_HOME/install/oracle.patch

	You have completed the patch installation
You may now start up the database.
	% sqldba startup


End of Patch Release Notice
