RE: Oracle 9.2-10g upgrade

RE: Oracle 9.2-10g upgrade

 

  



Jeff,
Had you previously run the upgrade to 10.2 and then downgraded again? If so,
this is a known bug: 5016165.

ORA-600 [17069] can occur when running catupgrd.sql, after a
database has been previously downgraded to 9.2.

Workaround:
Drop the sys.stats_target table before re-upgrading the 9.2 database.

HTH
John.



-----Original Message-----
From: Jeffrey Ramsay
[mailto:oracledba-ezmlmshield-x61282974.[Email address protected]
Sent: 09 October 2007 19:51
To: LazyDBA Discussion
Subject: Oracle 9.2-10g upgrade

Hello,

I am looking into the possibility of upgrading from Oracle 9.2 to 10g,
however, I'm experiencing the following errors running the
"utlu102i.sql" script. Anyone here familiar with this error and how I
can fix it?

The database is running ok without problems.

SQL> @utlu102i.sql
ERROR:
ORA-00600: internal error code, arguments: [17069], [0x3DC6D3B08], [],
[], [],
[], [], []

DECLARE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17069], [0x3DC6D3B08], [],
[], [],
[], [], []

ERROR:
ORA-00600: internal error code, arguments: [17069], [0x3DC6D3B08], [],
[], [],
[], [], []

SQL> quit

Thanks,
-Jeff

--
Jeffrey J. Ramsay
Systems Administrator (SCSA, SCNA, SCSECA)
Utica College
1600 Burrstone Road
Utica, NY 13502
Office: (315)223-2383
http://www.utica.edu
AIM: sol6789

When privacy or confidentiality is a concern, using PGP(r)
encryption is the most secure way to send files, email or
other types of communication. For those who would like to
communicate with me via PGP(r), below is my PGP(r) Public Key.

http://pgp.mit.edu:11371/pks/lookup?search=0x198F8216&op=index&fingerprint=o
n



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page