oracle pse,打Patch后Oracle起不來了

README for 2922427

Oracle8 8.1.7.4.11 Patch for the following products on Windows NT and Windows 2000

Oracle8i Release 3 (8.1.7) Enterprise Edition for Windows NT

and Windows 2000

Oracle8i Release 3 (8.1.7) for Windows NT and Windows 2000

Oracle 8i (8.1.7) Personal Ed. for Windows NT and Windows 2000

-----------------------------------------------------------------

Earliest version of the product that this patch may be applied

to: 8.1.7.4.1

Note: All the products supplied in this patch may NOT display

the version Number 8.1.7.4.11, because of cumulative patch.

Bug fixes included in this patch are listed at the end of the file.

Oracle Server Installation Instructions:

---------------------------------------

(1) Stop all oracle services.

-- 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: orajox8.dll, oracore8.dll, oranls8.dll, owm2.dll,

oranro8.dll, orantcp8.dll, orantns8.dll, orannzsbb8.dll, oractxx8.dll, sqlplus.exe,

sqlplusw.exe, oraxml8.dll, lsnrctl.exe, naedac.exe, oran8.dll, orank58.dll,

tnslsnr.exe, oraplp8.dll, orapls8.dll, agtctl.exe, extproc.exe, hsdepxa.exe,

hsots.exe, oracle.exe, oraclient8.dll, oracommon8.dll, orageneric8.dll,

exp.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 the included files: deploync.sbs, ncomp.sbs, statusnc.sbs

%ORACLE_HOME%\JAVAVM\INSTALL\SBS directory.

(5) Copy jtc.h to %ORACLE_HOME%\JAVAVM\JAHOME directory.

(6) Copy classes111.zip to %ORACLE_HOME%\JDBC\LIB directory.

(7) Copy dbmssql.sql, prvtstat.plb, prvtread.plb, prvtpitr.plb,

prvthssq.plb, prvtsql.plb, prvtssql.plb

to %ORACLE_HOME%\RDBMS\ADMIN directory.

(8) Copy the included files: deploync.bat, ncomp.bat, statusnc.bat to

%ORACLE_HOME%\bin directory.

(9) Copy catexp.sql, catproc.sql, prvtgdk.plb, prvtbfla.plb, utlgdk.sql to

%ORACLE_HOME%\RDBMS\ADMIN directory.

(10) To install the symbols copy orajox8.sym, oranls8.sym and oracore8.sym,

oraxml8.sym, oran8.sym, orank58.sym, oraplp8.sym, orapls8.sym, oracle.sym,

oraclient8.sym, oracommon8.sym, orageneric8.sym, orannzsbb8.sym,

oranro8.sym, orantcp8.sym, orantns8.sym  to

%ORACLE_HOME%\RDBMS\ADMIN directory.

(11) To install the Network message files copy naukus.msb, nltus.msb to

%ORACLE_HOME%\NETWORK\MESG directory.

(12) To install the RDBMS message files copy oraus.msb to

%ORACLE_HOME%\RDBMS\MESG directory.

(13) Restart all services and databases after the patch is installed.

Post Server Install Instructions:

--------------------------------

1) cd %ORACLE_HOME%\rdbms\admin

sqlplus " sys/change_on_install as sysdba"

SQL> @utlgdk.sql

SQL> @prvtgdk.plb

SQL> @prvtbfla.plb

SQL> @catproc.sql

---------------------------------------------------------------

The fix for bug 1607043 introduced a new option (WIN32_THREADS) to the

proc command line and gui tool. A known limitation is that since the

change to the Proc gui tool could not be translated, this new option

breaks the gui tool when running in a non-US language. The

workaround is to use the proc command line executable when this option

is needed and to revert to the original pre-bug-fixed version of the

Proc gui tool for all non-US language installations. The instructions

below revert the Proc gui tool back to the version of the gui tool

without the changes from bug fix 1607043. US customers and those not

using the Proc gui tool can ignore these 2 steps.

1) Non-US language versions who have installed 8.1.7.4.1 patch

should copy procui.exe and procus8.dll shipped in this patch

to %ORACLE_HOME%\bin directory.

2) Non-US Language versions should copy ".pre" files

to the respective directory as given below. This is a known bug,

that Proc gui tool will not work for Non US languages after applying the

fix of bug 1607043 and hence can not use the new option called

WIN32_THREADS. As an alternative use the proc.exe command line version.

8.1.7.4.11 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: oracore8.dll, oranls8.dll, owm2.dll,

oranro8.dll, orantcp8.dll, orantns8.dll, orannzsbb8.dll, oractxx8.dll, sqlplus.exe,

sqlplusw.exe, oraxml8.dll, oran8.dll, orank58.dll, oraplp8.dll,

orapls8.dll, oraclient8.dll, oracommon8.dll, orageneric8.dll,

exp.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 the included files: deploync.sbs, ncomp.sbs, statusnc.sbs to

%ORACLE_HOME%\JAVAVM\INSTALL\SBS directory.

(5) Copy jtc.h to %ORACLE_HOME%\JAVAVM\JAHOME directory.

(6) Copy classes111.zip to %ORACLE_HOME%\JDBC\LIB directory.

(7) Copy dbmssql.sql, prvtstat.plb, prvtread.plb, prvtpitr.plb,

prvthssq.plb, prvtsql.plb, prvtssql.plb

to %ORACLE_HOME%\RDBMS\ADMIN directory.

(8) Copy the included files: deploync.bat, ncomp.bat, statusnc.bat to

%ORACLE_HOME%\bin directory.

(9) Copy oranls8.sym and oracore8.sym, oraplp8.sym, orapls8.sym, oraclient8.sym,

oranro8.sym, orantcp8.sym, orantns8.sym, orannzsbb8.sym,

oracommon8.sym, orageneric8.sym, catexp.sql, catproc.sql, prvtbfla.plb,

prvthssq.plb, prvtsql.plb, prvtssql.plb,

prvtgdk.plb, utlgdk.sql to %ORACLE_HOME%\RDBMS\ADMIN directory.

(10) To install the Network message files copy naukus.msb, nltus.msb to

%ORACLE_HOME%\NETWORK\MESG directory.

(11) To install the RDBMS message files copy oraus.msb to

%ORACLE_HOME%\RDBMS\MESG directory.

(12) 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

This client only patch installation is complete.

Important Note: If the Oracle home has a server installed, you should apply

the complete patch.

Bug fixes included in this patch

-------------------------------

<8.1.7.4.11>

Fix for BUG#2817542 (PSE BUG#2881484) working in this patch.

Fix for BUG#2494999 (PSE BUG#2748164) working in this patch.

Bug      Base Bug Category  Description

-----    -------- --------  -----------------------------------------------

2917703  2762016  RDBMS     POTENTIAL MUTEXING ISSUES ON CONNECTION WHEN MIXING V7 & V8 OCI CALLS

<8.1.7.4.10>

naedac.exe was missing in the previous patches. Added now.

new exp.exe was built and added now.

<8.1.7.4.9>

Bug      Base Bug Category  Description

-----    -------- --------  -----------------------------------------------

2898711            RDBMS     DBMSSQL.SQL MISSING FROM 8.1.7.4.8 CAUSING DBMS_SQL AND REPLICATION TO FAIL

2803397  2745261   CORE     8.1.7.4.6-PARSER LOSING NEWLINE DURING PARSING

<8.1.7.4.8>

Bug      Base Bug Category  Description

-----    -------- --------  -----------------------------------------------

2877453  2453072   CTX      USING OPERATOR ABOUT CTX_DOC.MARKUP DOESN'T

MARK THE CORRECT AND ATTENDED WORDS

2876124  2622690   RDBMS    ORA-600 [12209] ON CLOSING CURSOR

2865840  2323097   RDBMS    ORA-2064 ON SNAPSHOT FAST REFRESH (8173 FIX)

2865533  2865515   RDBMS    MERGE LABEL REQUEST FOR THE FIXES FOR

BUGS 2656881 & 2346568 ON TOP OF 8.1.7.4

2862342  2496699   RDBMS    SELECT ON OBJECT_VIEWS VERY SLOW WITH REF'S

2857924  2643579   RDBMS    ORA-7445 [10] CURSOR_SHARING=FORCE KXSPOAC

2804310  2605628   CTX      ORA-1480 TRAILING NULL MISSING CREATING INDEX

2800931  2410688   PLSQL    DBMS_SQL.PARSE NEEDS HIGHER VARCHAR2 ALLOWANCE

2792811  2392166   PLSQL    PMON CRASHES THE INSTANCE IF A SERIALLY

REUSABLE ROUTINE IS CALLED IN A QUERY

2656550  2508921   CTX      INTERMEDIA RETURNS DIFFERENT RESULTS FOR SAME

SEARCH ON WE8ISO AND UTF8 DATABASE

2847293  2617480   RDBMS    ORA-600[KDISLE:NROWS][1] DURING INSERT INTO TABLE

WITH INDEX

2847773  2686584   RDBMS    PGA MEMORY LEAKS WHEN PQ IS EXECUTED - TQ STATS

INFO STRUCTURES.

2854052  2763219   RDBMS    MEMORY LEAK WHEN EXECUTING A QUERY THROUGH TAF

CONNECTION

2840713  2787968   NET      INAPPROPRIATE MESSAGE ON ERROR CONDITION THAT SHOULD NEVER OCCUR

2838672  2514005   RDBMS    CRASH IN KPURST()

2837642  2360357   RDBMS    CREATE OR REPLACE TYPE WITH OID FAILS WITH ORA-02304:

INVALID OBJECT IDENTIFIER

2836509  2728408   RDBMS    ORA-08177 ON SELECTING DATA WITH SERIALIZABLE

2832218  2782787   RDBMS    PLEASE PROVIDE MERGE OF BUGS 2661701,2687687,

2711788,2667235,2522549

2831046  2702723   CORE     PERFORMANCE BOTTLENECK IN SLTSKYS/SLTSKYG

2830826  2638483   RDBMS    XAER_RMERR RETURNED ON XA_COMMIT

2821704  2784635   NET      MERGE LABEL REQUEST FOR 115 ORACLE NET ON TOP OF 8.1.7.4

2814643  1407738   RDBMS    DBMS_STATS.GATHER_SCHEMA_STATS GIVES ORA-6502 WITH STALE/EMPTY

2813849  2281320   RDBMS    ORA-600[17182] POSSIBLE AFTER CTRL-C OR CLIENT DEATH

2811390  2673203   RDBMS    OCIPARAMGET() CRASHES RATHER THAN RETURNING ERROR

2809847  2664217   RDBMS    APPST9202: HIGHLY CRITICAL - HR FAMILY PACK CAUSES

PACKAGE LOCKING

2808548  2235386   RDBMS    EVENT REQUIRED TO MODIFY WHAT KSQDLD() DUMPS ON DEADLOCK

DETECTION

2807215  1805407   RDBMS    EXP,ORA-01422: EXACT FETCH RETURNS MORE THAN REQUESTED

NUMBER OF ROWS

2803397  2745261   CORE     8.1.7.4.6-PARSER LOSING NEWLINE DURING PARSING

2801460  2002679   CORE     LNXTEST TLNXSUM COREDUMPS ON AIX

2782570  2257375   DRGEN    WRONG QUERY RESULTS WITH TURKISH WORDS WITH SPECIAL CHARACTERS

2780890  2672970   RDBMS    EXPORT FAILS WITH EXP-10 IN CERTAIN CASES IF USERNAME

CONTAINS '.'

2780753  1227266   PLSQL    INCORRECT RESULTS WHEN BIND VARIABLES ARE NOT INITIALIZED

2768265  2424490   RDBMS    LOG_ARCHIVE_DEST_X FAILURES ARE NOT WRITTEN TO THE ALERT LOG

2768130  2435247   RDBMS    APPSST: ORA-3113 ERROR ON INTERMEDIA QUERY AFTR CHANGING

SESSION LANGUAGE PARAMS

2765671  2408475   NET      MEMORY LEAK WHEN CONNECT ATTEMPT TO REMOTE AGENT FAILS

2762582  2639679   RDBMS    MVIEW CREATED WITH DATE RANGE CHANGES QUERY_REWRITE FLAG

2754187  1986657   RDBMS    SQL*LOADER-704: INTERNAL ERROR: MAXIMUM RECORD LENGTH

MUST BE <= [10000000]

2749747  2649659   RDBMS    INVALID DATA RETRIEVED WITH BLOCKING MODE (ONBSET) IN OCI7

2748164  2494999   WMT      ORACLE WALLET MANAGER IS NOT IMPORTING A CA'S CERTIFICATE

2742804  2642439   CORE     SECURITY ALERT 50 - TO_TIMESTAMP_TZ OVERFLOW

2738874  2510810   RDBMS    ORA-911 ON ANALYZE IF USERNAME AND TABLE_NAME CONTAIN

SPECIAL CHARACTERS

2738653  2642267   CORE     SECURITY ALERT 49 - TZ_OFFSET BUFFER OVERFLOW

2738473  2610596   RDBMS    HUGE CPU RMAN-SERVERPROCESS WHEN TAPE NOT MOUNTED

AND BACKUP_TAPE_IO_SLAVE=TRUE

2737075  1403594   JDBC     JDBC CONNECTIONS RETURNS ORA-28000 BEFORE FAILED_LOGIN_ATTEMPTS

ARE REACHED

2737061  1426414   NET      /VOBS/NETWORK_SRC/SRC/NTT/SNTT.C -  HANDLE EWOULDBLOCK IN

NON-BLOCKING READ

2736853  2658226   RDBMS    LARGE UPDATE SEES 20-FOLD DEGRADATION W/TEXT INDEX PRESENT,

TEXT COL NOT IN SQL

2731093  2479827   RDBMS    ORA-07445 [QERBXCLOSE()+160] WHEN EXECUTING PROCEDURE THAT

RETURNS NO DATA

2720623  2511780   JDBC     XARESOURCE.PREPARE() FAILS WITH ORA-2051, XA ERROR -3

ORACLE ERROR 65535

2715618  2620726   RDBMS    SECURITY ALERT 51 - CONNECT OVERFLOW

2714336  2427185   NET      JDBC THIN DRIVER & SERVER SIDE LOAD BALANCING DOESN'T WORK

ON RAC

2713575  2642117   RDBMS    SECURITY ALERT 48 - BFILENAME OVERFLOW

2713161  2647235   RDBMS    THE RESULT IS INCORRECT AT THE SELECT WHICH USED INLIST

2711774  2510357   RDBMS    ODESCR CRASHES WHEN COLUMN EXPRESSION >= 960 CHARS AND NO

ALIAS IS GIVEN

2711708  2635098   RDBMS    ODESCR CRASHES WHEN COLUMN EXPRESSION TOO LONG CHARS AND

NO ALIAS IS GIVEN

2709653  2383111   CORE     PLEASE MAKE THE FOLLOWING CHANGES TO SLTM.C FOR WINDOWS NT

2707116  2517189   NET      HANDLE LEAK WHEN  REPEATING CONNECT/DISCONNECT IN OCI_THREADED

MODE

2688932  1656080   RDBMS    ORA-3217 TSPITR CLONE EXPORT, PRIMARY DB HAS TEMPORARY

TABLESPACE TEMPFILES

2625242  2273354   RDBMS    AQ/JMS - MESSAGE NOTIFICATION FAILS WITH JMS CLIENT ON WINDOWS

AND DB ON SOLARIS

2498312  1863894   NLSDATA  ROUNDTRIP INTEGRITY NOT MAINTAINED FOR WE8ISO8859P15 VALUE 0XBE

2238229  2064575   JAVAVM   ASSERTION FAILURE AT JOECALL.C:239 USING LARGE ADTS

<8.1.7.4.7>

Bug      Base Bug Category  Description

-----    -------- --------  -----------------------------------------------

2790160  2787968   NET      INAPPROPRIATE MESSAGE ON ERROR CONDITION

THAT SHOULD NEVER OCCUR

<8.1.7.4.6>

Bug      Base Bug Category  Description

-----    -------- --------  -----------------------------------------------

2669645  2136149   RDBMS   SQL*LOADER-643 ON LOADING WITH VARYING

WIDTH CLOBS FROM V920 CLIENT TO V817 DB

2669615  2605435   RDBMS   MEMORY LEAK WHEN EXECUTING A QUERY THROUGH

TAF CONNECTION

2666927  2628258   RDBMS   "0X00" IS ADDED TO THE VALUE OF THE MACHINE

COLUMN OF V$SESSION.

2663963  2548451   RDBMS   OCI 9.2.0 AGAINST AN RDBMS 8.1.7 HIT ORA-1455

SELECTING A REMOTE TABLE

2659779  2645378   RDBMS   CHANGED DATA IN LOB BLOCKS AFTER A RECOVERY

2658996  1585867   CORE    PARSER LOSING NEWLINE DURING PARSING

2644000  2514869   RDBMS   SELECT STATEMENT END UP IN CORE DUMP WHEN

CURSOR_SHARING=FORCE IS SET

2642403  1983967   CORE    DATABASE CRASH ON INVALID USERID/PASSWORD

2628448  2502317   RDBMS   DBMS_OFFLINE_OG.END_LOAD WITH

DBMS_REPCAT.SET_COLUMNS OBJECT FIRES 23463

2627982  2514761   RDBMS   OCI APPLICATION COREDUMP IN OCILOBREAD WHEN A

NETWORK ERROR OCCURS

2620270  1349297   RDBMS   SQLLDR WITH "DECODE( :X, ... ( SELECT ....) )"

EXECUTES THE SUBQUERY WRONG

2617989   2610437  RDBMS   MERGE Fix OF BUGS 2438940 2559375 2289081

2615627   2261722  RDBMS   CANNOT EXPORT 9.0.1 DATABASE FROM 8.1.7.3 EXPORT

EXECUTIBLE.

2605306  2488590   RDBMS   EXP-8 ORA-3113 EXP-0 WHEN EXPORTING AN OPERATOR,

DUMP IN KGHFREMPTY

2601007   2217015  RDBMS   ORA-4016 OCCURS WHEN USING SEQUENCE

2597082  2540219  LISTENER LISTENER FAILS TO PROCESS SPECIAL COMMANDS ALERT #42

2594063  2222508   RDBMS   QUERY USING SELFWRITTEN DOMAIN INDEX FAILS WITH

ORA-3113

2586629  1550647   RDBMS   NLS: VARRAY SIZE CHECKING NOT DONE WHEN CHARACTER

SIZE EXPANDS

2586299  2366678   RDBMS   PASSING ADT PARAMETERS TO PLSQL CALLOUTS CAN RESULT

IN DUMPS / SPINS

2586277  2496556   RDBMS   ORA-600 [KDOURP-2] USING DBMS_PIPE

2580644  2073948   RDBMS   ORA-6550 IN ANONYMOUS PL/SQL AFTER DROPPING TWO

PARTITIONS IN A REMOTE TABLE

2574261  2298968   RDBMS   MEMORY LEAK IN SELECT FOR UPDATE WHEN RUNNING 32BIT

CLIENT WITH 64BIT SERVER

2574068   2222386  RDBMS   ORA-1401 TRANSFERRING MORE THAN 32760 BYTES IN A

RAW FIELD

2567214   2397501  RDBMS   GSI9I -- ORA-600 [KKOJCIO]

2563904  2322620   RDBMS   RECOVERY HALTED ON PHYSICAL STANDBY WITH ORA-600 AND

ORA-10564

2563499  2401670   RDBMS   ORA-1002 AFTER ROLLBACK-TO-SAVEPOINT IN PRO*C OR OCI

APPLICATION

2563494  2225569   RDBMS   ORA-600 [KOKBNP2] EXECUTING PACKAGE WITH NESTED

CURSOR AS GRANTED USER

2561014  2483052   RDBMS   QUERY RETURNS INCORRECT RESULTS WHEN USING VIEW AND

MERGE JOIN

2560411  2519138   CORE    XML PARSER CRASH WHEN HAVE LARGE ATTRIBUTES

2560334  2481069   RDBMS   ORA-3113 RAISED AFTER INVOKING ORA_GRANTEE FUNCTION

2554148  2171847   OSNS    KERBEROS ADAPTER FAILS TO HANDLE WINDOWS 2000 TICKETS

2553746  2298215   RDBMS   ADVANCED QUEUE DEQUEUE PROCESS TAKES UPTO FIVE

SECONDS TO DEQUEUE RECORD.

2549418  2474452   RDBMS   BUS ERROR - CORE DUMPED RUNNING A LOB IMPORT OF SDO

OBJECTS

2546719  2346568   RDBMS   DBMS_LOB.COMPARE HAS ORA600 AFTER CSCONV.

2544142  2358608   RDBMS   ORA-600 [16607] DURING ANALYZE COMPUTE STATISTICS

2536695  2373278   RDBMS   CREATE INDEX IN PARALLEL GIVES ORA-30562

2535976  2210617   RDBMS   SELECT RETURNS WRONG RESULTS ON IOT IF INDEX IS

CORRUPTED.

2533772  2415134   RDBMS   SR ENQUEUE CAUSING HANG

2525865  2210612   RDBMS   FAILOVER: ACCESS VIOLATION IN (ORACOMMON9.DLL):

0XC0000005, USING ROWID IN SQL

2521719  2275708   OSNS    FIPS-140 CONNECT FAILS WITH ERROR 2537 /"READ OF

LIBRARY" FAILS FOR ORANCRYPT8.A

2516771  2414956   RDBMS   RESIZE OF DATAFILE FAILS IF DATAFILE WAS CREATED

IN 7.2

2514957  2281071   RDBMS   ORA-4030 WHEN CALLING PG4APPC TRANSACTION IN A

PL/SQL CURSOR LOOP: MEMORY LEAK

2514486  2386334   RDBMS   ORA-7445[QERUAROWPROCEDURE] SELECT FROM VIEW WITH

UNION ALL

2508244  2483138   RDBMS   THE CLIENT PROGRAM STOPS AT MTS FOR 60 SECONDS.(4CPU

MACHINE)

2506110   2267522  RDBMS   "INSERT INTO ... SELECT FUNC@LOOP FROM DUAL" GAVE

WRONG FEEDBACK MESSAGE

2503752  2305507   RDBMS   AFTER APPLYING 8.1.7.3.0, RT TEXT QUERY = ORA-29902

ORA-20000 DRG-50942 ORA-1455

2501719  2371235   RDBMS   MEMORY LEAK WHEN LOBS PASSED FROM AN EXTERNAL ROUTINE

2486029  2459355   RDBMS   ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [XTYCSR3]

USING SUM,GROUP BY AND PQ

2484900  2459355   RDBMS   ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [XTYCSR3]

USING SUM,GROUP BY AND PQ

2475331   2410612  RDBMS   CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT

2461896  2207382   RDBMS   WHEN FETCHING ORACLE AND DB2 REPEATEDLY WHIN WHILE

LOOP, GOT ORA-600 [12333]

2460210  1569784   RDBMS   ORA-600 [6109] ON ROLLBACK OF TRUNCATE TABLE WITH AN

INDEX

2453735  2422726   PLSQL   ORA-600 [16201] WHEN RECOMPILING A WRAPPED PACKAGE

2453425  2385857   RDBMS   RMAN BACKUP PERFORMANCE DEGRADES OVER TIME WITH

LARGER DB_FILES

2448292  2367294   RDBMS   CURRENT ALGORITHM TO INVALIDATE DEPENDANT OBJECTS IS

VERY SLOW

2437837  2395416    NET    OVER-RUNS IN ORACLE NET ALERT #40

2425224  1625347   RDBMS   MEMORY LEAK WHEN PASSING COLLECTIONS TO FUNCTIONS

2420877  1625347   RDBMS   MEMORY LEAK WHEN PASSING COLLECTIONS TO FUNCTIONS

2409942  1786170   RMAN    CROSSCHECK OR CHANGE FAILS IF BACKUPPIECE HAS BEEN

REMOVED THROUGH THE MML CATAL

2408050  1258537   CORE    SUM FUNCTION GENERATES BAD NUMBER WHEN ADDING

FRACTIONS

2408019  1219226   RDBMS   ORA-22292 BY OCILOBOPEN IN CASE OF UNIQUE INDEX OR

IOT IN 816, 817 AND 8.2

2402463  2307892   RDBMS   CBO : POOR EXECUTION WITH LARGE IN-LISTS

2393380  2252824   RDBMS   ANALYZE TABLE FOR ALL COLUMNS FAILS WITH ORA-600

[16515]

2381893  787734    RDBMS   CLIENT MAKING TWO REQUESTS TO NAMES SERVER, ONLY ONE

IN TRACE

2311440  920659    JAVAVM  FILEOUTPUTSTREAM THROWS EXCEPTION ON NT WHEN \\

SPECIFIED

2699291  872976    RDBMS   REPEAT STARTUP/SHUTDOWN IMMEDIATE OVER AND OVER,

OPS IS HANG.

2675330  2016464   JDBC    ALTER SESSION SET CURRENT_SCHEMA HAS NO EFFECT ON

THE KPRB DRIVER

2483214  2311562   JDBC    PASSING BIG COLLECTION FROM PLSQL TO JAVA GIVES NULL

POINTER EXCEPTION

2423033  1784060   JAVAVM  USER NCOMP DOES NOT WORK ON NT

2503413  1367542   PLSQL   NEED PLSQL API TO CONVERT ORACLE CHARSET NAME IANA

--Following bugfix is being reshipped in 8.1.7.4.4 since it did not make it into

8.1.7.4.1

Bug         Base Bug    Category    Description

-------     --------     --------     -------------------------------------------

1824290  1620381   SQLPLUS   ORA-24315 RESULTS ON CONNECT REQUEST AFTER

PASSWORD VERIFICATION FAILURE

2164675  2003657   CORE      ORA-1890 DOING PCTAS

2125139  750816    NLSDATA   G CEDILLA IS CONVERTED TO G ACUTE

2122772  1808970   CORE      MEMORY LEAK WITH MICROSOFT COM+ DISTR TXNS

2058684  1988709   CORE      EXP-28 ERROR WHEN USING NAMED PIPES ON EXPORT

1976833  1388806   CORE      DCD FAILS AFTER 16 CONNECTIONS

1978353  1744093   NLSRTL    UNICODE: DATA TRUNC WHEN WRITING MORE THEN

64 BYTES TO UTF8 DB FROM UCS2 DATA

1730290  875830    NLSRTL    JA16SJIS HAS DIFFERENT MAPPING TO UNICODE FROM

JAVA'S MS932 ENCODING

1731667  1634613   NLSRTL    8.1 NEEDS TO HAVE AL16UTF16

1716997  1638516   NLSDATA   FUNCTION 'ADD_MONTHS' DOES NOT WORK CORRECTLY WHEN

NLS_CALENDAR='PERSIAN'

1777392  1328943   NLSRTL    DATE FORMAT MASK IGNORED IN SQLPLUS

(IF CLIENT ASCII AND SERVER EBCDIC)

1884033  1862456   SQLPLUS   SQLPLUS.EXE GIVES APPLICATION ERROR AFTER

INSTALLING 81714 PATCHSET