Re: Oracle 9.2.0.2 bugs

Govind.Arumugam,

		I also hit two bugs running 9i rac on linux 9.2.0.2.
	The first bug is snapshot refresh cannot go on if the data volume is large , you have to drop and recreate the snapshot.


>>>19:08:01 SQL> 19:08:01 SQL> 19:08:01 SQL> BEGIN dbms_snapshot.refresh('snp_articlescatalog'); END;

>>>

>>>*

>>>ERROR at line 1:

>>>ORA-12008: error in materialized view refresh path

>>>ORA-01438: value larger than specified precision allows for this column

>>>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794

>>>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851

        The second bug is with the oracle cluster manager. If the first node reboot, you have to reboot the whole cluster ,or you cannot mount the first instance any longer.

>>>Reconfiguration complete
>>> Post SMON to start 1st pass IR
>>>Tue Jan 28 06:24:46 2003
>>>This instance was first to mount
>>>LCK0 started with pid=14
>>>Tue Jan 28 06:24:52 2003
>>>Errors in file /home/oracle/admin/rac/udump/rac1_ora_1585.trc:
>>>ORA-00600: internal error code, arguments: [kccsbck_first], [2], [2066586566], [], [], [], [], []
>>>Tue Jan 28 06:24:53 2003
>>>ORA-600 signalled during: ALTER DATABASE MOUNT...
>>>Shutting down instance: further logons disabled
>>>Shutting down instance (normal)
>>>License high water mark = 1

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)

• 2003-03-03 13:54:00 ,you wrote£º=======

>List,
>
>We recently upgraded our Production system to 9i and got burnt by these bugs.
>
>Installed Patch List:
>2785282 [ Base Bug(s): 2442125 ]
>
>Bug # 2808431 WRONG RESULTS FOR PARALLEL QUERY WITH HASH AND INDEX JOIN
>
>Bug # 2783229 Base bug : 2442125 INCORRECT DATA RETURNED FROM DATABASE WHEN QUERIED FROM PROC
>
>I would greatly appreciate if we can share among ourselves the various bugs noted in 9i along with possible fixes.
>
>Our version info.
>
>Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
>With the Partitioning and Real Application Clusters options
>JServer Release 9.2.0.2.0 - Production
>
>Sun Solaris 2.8
>
>TIA,
>Govind

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).