Re: move 9i r2 database on host 1 to 10g r1 on another host

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: sundarmahadevan82@xxxxxxxxx
  • Date: Wed, 12 Aug 2009 22:45:28 +0200

if you have a synonym "D" - drop it: Note:400200.1 - ORA-0600 [17069] During Upgrade of Pre-10g Database to 10g+ otherwise - according to Note:271733.1 - 271733.1 ORA-600 [17069] During Upgrade Using Database Upgrade Assistant, Utlu101i.sql or Utlu102i.sql

you can either 1. Proceed with the upgrade manually and ignore the error
or 2. Attempt to workaround the problem in DBUA (or manual upgrade) by commenting out "SET SERVEROUTPUT ON" in the upgrade scripts.

once again, metalink helps (probably also MOS will try to)

br
 Martin

--
//www.freelists.org/webpage/oracle-l

Am 12.08.2009 um 22:05 schrieb sundar mahadevan:

Thanks to one and all for helping me out on this issue. I'm trying out the option of copying all the files from host1(9ir2) to host2(10gr1) and then upgrade the database with dbua. After I bring the database up with "startup upgrade", I invoke dbua and receive the following error:ORA 00600 Internal error code, arguments: [17069], [0x53250820], [], [], [], [], [], [] I checked the udump tace file and it has call stack trace, binary stack dump, framedetails ...etc. All of them are in hexadecimal.

What I did:
I just exported the ORACLE_SID=catdb
Initially dbua did not pickup the open catdb database for upgrade on the first screen. Hence I added catdb to /etc/oratab and dbua picked it up for upgrade and then giving me the oracle internal error.

/etc/oratab:
orams:/u01/oracle/app/product/10.1.0/Db_1:N
catdb:/u01/oracle/app/product/10.1.0/Db_1:N

Since my control file will be looking for files in the same setup as in 9ir2 host1, I replicated the same directory settings (only few) in 10gr1 host2. Settings below are from host2.


[oracle@OEL5 ~]$ ls -l /opt/oracle
total 12
drwxr-xr-x 3 oracle oinstall 4096 Aug 11 11:20 admin
drwxr-xr-x 3 oracle oinstall 4096 Aug 11 11:13 oradata
drwxr-xr-x 3 oracle oinstall 4096 Aug 11 11:00 product

admin contains directories for trace
oradata contains datafiles
and product contains directory 9.2.0 which contains dbs directory that contains initcatdb.ora, orapwcatdb, spfilecatdb.ora (all three files were copied to 10gr1 directory).

Any ideas on how to proceed??????? Thanks in advance...........


Other related posts: