======================

!!! READ THIS FIRST !!!

IMPORTANT NOTICE

 This patch contains a fix to a critical RDBMS bug. 

It MUST be applied immediately. For detail see Section 1.1

======================

Patch Release Notice

										 ORACLE 								for 						SPARC Platforms

6.0.36 RDBMS Patch 4 Release

Part No. 6616-60-1192





1.0 General

6.0.36 RDBMS Patch4 Release is for the ORACLE 6.0.36 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.36 RDBMS release. After this patch release is applied, 
the ORACLE RDBMS version will be changed to 6.0.36.4.1. Postscript and plain text copies of 
this Patch Release Notice, relnotice.ps and relnotice.txt, can be found in the patch directory.

1.1 Critical RDBMS Bug Fix (#130548)

This patch fixes a critical RDBMS latch bug that exists from version 6.0.36.0 to 
6.0.36.3. This patch MUST BE APPLIED in order to correct this latch bug, 
which could cause database corruption. This patch will change RDBMS 
version to 6.0.36.4.1. Versions 6.0.36.0 to 6.0.36.3 will no longer be supported.

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 41 Megs.

In addition to the 41 Megs required for the patch distribution, you will need extra 40 Megs of

disk space to run the patch installation. 

2.1 SQL*Forms30/SQL*Menu50 Motif and OpenLook

SQL*Forms30/SQL*Menu50 OpenLook have been certified under 
OpenWindows 3.0 with Patch 100451-27 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.



IMPORTANT NOTES:

OPENWINDOWS 3.0 WITH PATCH 100451-27 IS REQUIRED IF YOU WISH TO RE-
LINK THE OPENLOOK VERSION OF SQLFORMS30/SQLMENU50. Note that the Open-
Look versions of the orakit, forms30 and menu5 libraries provided in this patch will NOT work 
with the OpenWindows 2.0/2.5 libraries. Patch 100451-27 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-27. 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 sql-
menu5.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/
motif/lib.

If this is not the case for your site, please find and modify the following lines in the makefiles:

OPENWINHOME=/usr/openwin

MOTIFLIBHOME=/usr/motif/lib



Known bugs:

103989 - MOTIF: scroll down/up in runform30 takes too 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. 

2.2 CASE*Designer

Please note: CASE*Designer is no longer supported with MIT version of X11. Starting from 
next patch release, CASE*Designer will not be supported with OpenWindows 2.0/2.5 

libraries. It will be only be supported with OpenWindows 3.0.

The CASE*Designer makefile has changed. The cdes.mk file provided with this patch expects 
to find the OpenWindows/Motif libraries (e.g. libXt.a, libXaw.a, etc.) installed under the 

 /usr/openwin/lib directory. If this is not the case for your site, please find and modify the follow-
ing line in this makefile:

GUILIBHOME=/usr/openwin/lib

to point to the directory where these libraries are.

2.3 Sun Database Excelerator

For additional Oracle RDBMS performance support, please consult with your Sun sales represen-
tative about the Sun Database Excelerator.



2.4 Bug Fixes

This patch includes the following bug fixes:

RDBMS

130548 - RDBMS latching bug

110719 - Internal errors fixed.

104511 - Rounding nos. into a char buffer of length 1 to 5 no longer occasionally hangs.

105333 - Index failure space usage improved.

105943 - Shutdown immediate no longer occasionally hangs during trace dumps.

106053 - Parsing filenames with a dollar sign are now accepted.

106148 - Improved handling of auditing in SQL*PLUS.

106418 - Select long val. from view with pseudo col. eg. ROWNUM no longer hangs at times.

109103 - Occasional incorrect handling of longs in EXEC SQL statements fixed.

110714 - Create tablespace offline and shutting down no longer occasionally gives error.

110774 - CREATE VIEW .. WITH CHECK OPTIONS CONSTRAINT no longer makes 
EXPORT occasionally corrupt.

108112 - Complex SQL statement containing outer JOIN causes disconnect from SQLPLUS.

111380 - Error when LOG_ARCHIVE_DEST parameter longer than 79.

109582 - Security risk if OPS$ Account longer than 10 characters.

106053 - In SRW, report name has a dollar sign `$' works fine on VAX but not on UNIX.

115289 - Internal fix

80513 - When using multiple archivers and the archive disks fill up, not all archivers would be 
freed after disk space was reclaimed.

108090 - When several sub-processes are created for queries, very occasionally one of the sub-
processes would loop, effectively hanging database.

112313 - Minor buffer address alignment problem fixed.

113310 - Using an outer join with SELECTs on columns of LONG datatype, no longer occasion-
ally give ORA-3113.

118940 - same as 113310

116253 - Memory management improved by freeing up re-usable memory from shadow.

116375 - Incorrect ranges used in error.msg for unix osd errors

121535 - ORACLE_PATH does not work properly under some conditions.

117711 - Filename exceeds 14 characters.

119605 - Imp core dump

124526 - Unable to find .msg and .msb files while running root.install.

SQL*PLUS

86561 - Set heading off, then error in break on row skip 1.

69818 - Set pause + spool caused plus to exit.

83650 - Simultaneous break on two columns gave headings on empty page.

88580 - Commands disabled through PUP work through INSERT.

103154 - SQL*Plus script gives core dump.

101573 - Lines per page incorrect when SET EMBEDDED ON is used.

47905 - NEW_VALUE, OLD_VALUE do not display NULL.

89428 - Without requesting it, ARRAYSIZE is changing without warning.

128246 - (refers to 120027) Fixed the problem of core dump when sqlplus is called with -s (silent) 
switch and there is a DOC statement with 4 or more lines.

120690 - Compute MIN (or MAX) of SAL produces pages of garbage.

118164 - TTITLE and BTITLE cannot display more than 240 characters.

115200 - WHENEVER SQLERROR EXIT SQL.SQLCODE doesn't work correctly.

120027 - SQLPLUS core dumps on longer doc stmt if -s switch used.

119065 - Echoing with a host command got truncated beyond 199 characters.

PL/SQL

109295 - Protection exception od when calling another form using a NEW_FORM

109726 - ACCVIO; CUHIMACUHEXE referencing sysdate/user functions.

85790 - IAD does not free memory after forms generation.

114591 - Conflicting declarations for psdicd in two include files.

99619 - Date arithmetic wrong by 1 second, rounding problem.

SQL*Forms30/SQL*Menu50(CHARACTER)

126216 - (refers to 123888) Fixed problem of truncating n-digit numeric val to n-1 digits.

68745 - Install doesn't ask if you want to install demo tables.

117705 - Filename exceeds 14 characters.

108721 - Cursor focus lost when returning from edit field.

111111 - Core dumps when locking record on form called from menu.

107696 - Clicking on "VIEW" after screen painter hangs entire system.

SQL*Forms30 (MOTIF)

110909 - MOTIF- Error initializing device Sun when using -d option.

SQL*Net

113000 - Can't connect via internet address instead of name - used to work.

113163 - Comments appended to entries in /etc/oratab cause spurious error.

116832 - Cannot use sqlnet alias facility as there is no default sid.

119919 - Cannot connect to databases after connecting to an ncube in the same session ( or after 
connecting to any other machine.)

SQL*Report

No bug# - rptdel.sql was left out of the bundled release - it's now included.

No bug# - Relinking of SQL*Report will corrupt the rpf executable.

SQL*ReportWriter

127934 - (refers to 107007) Fixed the problem of losing output when at the bottom of a page.

86722 - Cannot pass lexical parameter with space in it via command line.

105732 - Runrep does not logoff when certain errors occur.

107007 - When first grand / child record ends at page bottom, next page format incorrect.

CASE*Dictionary

126221 - (refers to 109257) Fixed the problem with the element deletion screen when language is 
set to German in init.ora.

88587 - Prompts for tablespace changed. (cdspace.sql)

94104 - COL_AVG_VSIZE now updated when you run Update Columns in a Domain. 

(sddudom1.sql)

109408 - COL_DEFAULT now updated as well.

112234 - EXIT command removed from DB2 DDL scripts. (cddle.pc)

112230 - Create Index statements for DB2 DDL corrected. (cddlf.pc)

112232 - Removed NULL from column definitions in DB2 create table statements. (cddlpro.h)

110941 - Added ORDER BY, and specification of indexed columns on DB2 tables. (sddindex.inp)

97465 - Column Definition Report now gives the name of the sequence that sources a column.

(cdcoldt.rpt)

100400 - In Arc field now length 4 to allow for +/- and 3 digits. (relatef.inp)

100643 - SDD_COLCREAT row no longer inserted into code_controls. (icdcont.ins)

104409 - Swapped init & final values in report. (cdtci.rex)

109845 - Removed comment from index name field. (cdcol1.rex)

100771 - Column comments missing in the system objective of module definition screen.

(cdiuerai.inp)

109777 - Business unit to problem definition screen now appears. (Not in same order as doc.)

105659 - Added outer-join to get entities without descriptions. (cdacc2.rex)

112674 - Added validation of length of constraint names for DB2. (cdkydefn.inp)

110678 - Added work around for SRW bug causing screen corruption (cdrpexec.c)

109016 - Switches removed, SEQ for table usages removed. (cdmodpt.rpt, cdmcand.rpt, 

cdmmcand.rpt)

82201 - Headings changed - now consistent with screen. (cdfattm.rex)

88885 - Banner wording changed slightly. (cdicnv)

89642 - Prompt wording changed slightly. (cdximpl)

104879 - ACTIVITY field reduced to 10 chars. (cdmdpc.inp)

113146 - Changed SQL to reconcile FKs with multiple key columns correctly. (cdrkd.pc)

92133 - Validate columns in context of table. (sdddesgn.inp)

94283 - Avg length disallowed if datatype is DATE. (cdcldefn.inp)

98444 - Delete key disabled in B1. (sddmodnt.inp)

111564 - Datatype for property is now also exported. (cdueexp.sql)

100016 - Can no longer base views on themselves. (sddnview.inp)

109217 - Entities listed in alphabetical order. (cdtabent.inp)

107672 - External entities no longer listed.

113235 - Extended length of MOD_TYPE to 10 in b2. (sddmodnt.inp)

88335 - Can now query in third block. (cdiuerai.inp)

116182 - Underlying field now 240 chars. (cdimtui.inp)

No bug# - Removed 3 outer-joins on views. (cdmoddef.rex)

91488 - mu_dictuser field now char(255). (cdtabs.sql)

91187 - Foreign key definition not correctly generated by default database design.

93507 - same as 91187.

109632 - Default database design can generate duplicate column names for foreign key.

118028 - Default database design creates a partial constraint if tables not shared.

CASE*Designer

112995 - Casedes set font path procedure not appropriate for heterogeneous.

94019 - Names of functions in DFD appear outside their boxes.

73283 - ERD-can't copy in sub-type to existing super-type.

77854 - ERD runs out of memory - unable to allocate memory - prealloc.

73031 - ERD-can't save diagrams - get ERD-324.

73668 - ERD-existing relationships can't be moved from one entity to another.

CASE*Generator

102786 - Freeing memory prematurely

CRT

108247 - Added an escape (reset) to setup string in order to get all default function key settings.

NLS*WorkBench

128703 - File ?/nlswb/sql/nlssyp.sql ends half way through a delete statement.

Orakit

108124 - Core dumps when invoking menu with -c and -e option.

73864 - Word wrap for EDIT_FIELD and [EDIT] splits word across lines.

122045 - Term variable is no longer being used to find devicename in ORATERM.R

116179 - `DEFAULT' device in ORATERM.R is being picked up by default.

116538 - In IMAGE-MODIFY, core dumps when user clicks on EDIT-COPY

108721 - Cursor focus lost when returning from edit field.

Orakit(MOTIF)

124648 - MOTIF: LOV width too small when no values available

121875 - MOTIF: Need to have a distinct color for the current field.

Orakit(OPENLOOK)

94584 - OL: Returning to an iconised form gives XLIB fatal error

109020 - OL: Extra chars cause duplication of 1st char in next field.

114736 - OL: KB focus inconsistent when menu item gives error.

114737 - OL: H/L lost when clicking before popup window active.

OCI

130903 - Symbol odescr does not exist in libocic.a. 

ORATERM

124764 - Need .R file for SUN type 5 keyboard for CASE 5, bitmap and char mode forms.

Precompiler

117337 - UPDATE/INSERT ... where current of (dynamically prepared) cursor fails.

116217 - Fixed the problem of the precompiler not releasing memory.

No bug# - Missing ODESCR call from Oracle Call Interface. (oci)

3.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.

	% mv $ORACLE_HOME/install/patch $ORACLE_HOME/install/patch.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

Please refer to Sec. 2.1 of this release notice if you are applying OPENLOOK/MOTIF 

SQL*Forms30 and SQL*Menu5 patches.

Please refer to Sec. 2.2 of this release notice if you are applying CASE*Designer 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



6. For MOTIF users only:

				When the patch installation is completed, two Oracle Toolkit Motif resource files 

	(Orakit.color and Orakit.mono) will be in the $ORACLE_HOME/orakit/install directory.

	Please copy the resource file to your home directory ($HOME) depending on the type of

	monitor you are using.

		%cp $ORACLE_HOME/orakit/install/Orakit.color $HOME/Orakit (if you have color moni-
tor)

	%cp $ORACLE_HOME/orakit/install/Orakit.mono $HOME/Orakit (if you have mono-
chrome monitor)

	You have completed the patch installation

You may now start up the database.

	% sqldba startup





End of Patch Release Notice
