| Oracle Database version for Oracle Streams. [message #75650] |
Wed, 31 December 2003 01:59  |
Vidyanand More
Messages: 35
Registered: January 2003
|
Member |
|
|
Hi All,
I would like to know Oracle Database version required to implement Oracle Streams?
Is Oracle version 9.2.0.4 must to implement oracle streams?
I tried with oracle version
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
But didn't manage to complete necessary steps to install oracle streams.
Is it due to lower version of Oracle Database ?
Can some one confirm this ?
Thanks in Advance.
Regards,
Vidyanand
|
|
|
|
| Re: Oracle Database version for Oracle Streams. [message #75652 is a reply to message #75650] |
Thu, 01 January 2004 21:34  |
Frank Naude
Messages: 4595
Registered: April 1998
|
Senior Member |
|
|
Hi,
Oracle Streams is available from 9.2.0.1.0, but you need the 9.2.0.4 patch-set (or later if available) to fix most or the issues. Besides this patch-set, you may also need the following patches:
- Patch 3023858 for the Streams OEM GUI and Oracle Management Server; and
- Patch 3197856 - MERGE LABEL FOR BUGS 5 STREAMS BUGS ON TOP OF 9.2.0.4
Best regards.
Frank
|
|
|
|
| Re: Oracle Database version for Oracle Streams. [message #75653 is a reply to message #75652] |
Thu, 01 January 2004 21:48 |
Frank Naude
Messages: 4595
Registered: April 1998
|
Senior Member |
|
|
Small correction -
Apply patch 3314371 (a later superset) instead of patch 3197856.
The following issues are addressed in it:
# Bugs Fixed by this patch:
# -------------------------
# 3314371 - PLEASE PROVIDE MLR FOR STREAMS ON TOP OF 9.2.0.4
# 3157924 - STREAMS APLY PROCESS RETURNS ERROR ORA-1435 "USER DOES NOT EXIST"
# 3155220 - ORA-4030 ENCOUNTERED AT TARGET WHEN LESS COLUMNS INSERTED INTO
# TARGET TABLE
# 3150982 - APPLY DML HANDLER DOES NOT PUT ERROR MESSAGE IN DBA_APPLY_ERROR
# 3147518 - ORA-600 [[KWQPBQDEQR]] ON STREAMS PROPAGATION
# 3120228 - ORA-7445 ON PROPAGATION JOB
# 3231190 - DBA_APPLY_PROGRESS OLDEST_MESSAGE_NUMBER DOES NOT INCREASE
# 3234793 - KRVXBGEN_GENERICTX CORE DUMPS
# 3263696 - STREAMS APPLY PROCESS RETURNS ORA-1435 WHEN SET TRANSFORMATION
# LOGIC ON APPLY
# 3272219 - PX QREF LATCH IMPACTS STREAMS APPLY PROCESS
# 3170326 - STREAMS ERROR HANDLER NOT CALLED WHEN CERTAIN DDLS PERFORMED ON
# TARGET TABLE
# 3256816 - LONG RUNNING TRANSACTION INFO ON STREAMS CAPTURE
# 3167779 - ORA-26701 ON STREAMS CAPTURE WHEN FORCING A CHECKPOINT ON RAC
# 3192519 - CANNOT CREATE CAPTURE AFTER POINT IN TIME RECOVERY
# 3210086 - CREATE CAPTURE AFTER RESETLOGS CLONES OLD CAPTURE
# 2442042 - ORA-07445/ORA-04031 WHEN TOO MANY SPILLED MESSAGES OCCUR IN
# BUFFER QUEUE
# 3260252 - STREAMS MEMORY REQUIREMENTS WORKAROUND
# 2836515 - ORA-4030 STREAMS APPLY PROCESS CUNSUMES / LEAKS MEMORY
# 3109703 - HANG IN DBMS_LOGMNR_D.BUILD AT TRUNCATE TABLE
# 3231109 - CLONING A LOGMINER SESSION TO CREATE STREAMS CAPTURE MAY FAIL
# 3232401 - FREQUENT ORA-4031 WITH STREAMS
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
