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

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Wed, 12 Aug 2009 22:45:28 +0200
Message-Id: <D7FB57A8-02F6-4483-8085-1654924CE618_at_gmail.com>

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

--
http://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_at_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...........

>



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

Received on Wed Aug 12 2009 - 15:45:28 CDT