RE: move 9i r2 database on host 1 to 10g r1 on another host
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'sundarmahadevan82@xxxxxxxxx'" <sundarmahadevan82@xxxxxxxxx>, "'Oracle-L@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 12 Aug 2009 15:57:49 -0500
Note:
39616.1<https://metalink2.oracle.com/metalink/plsql/f?p=130:14:5673990506335654633::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,39616.1,1,1,1,helvetica>
https://metalink2.oracle.com/metalink/plsql/f?p=130:14:5673990506335654633::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,39616.1,1,1,1,helvetica
Notice there is a Note on getting the ORA-0600 [17069] error on upgrade from
9.2. to 10.2 (not sure if it applies to you or not)
Note
5016165.8<https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=5016165.8&blackframe=1>
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of sundar mahadevan
Sent: Wednesday, August 12, 2009 3:06 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Re: move 9i r2 database on host 1 to 10g r1 on another host
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:
