Re: move 9i r2 database on host 1 to 10g r1 on another host
- From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Fri, 14 Aug 2009 16:36:46 -0400
My Sincere Thanks to one and all for helping me out to upgrade from 9ir2 to
10gr1. Initially I had problems on host2 (10gr1) with the 9i database files.
There was no drop_segments column in sys.mon_mods$ in my 9ir2(9.2.0.4).
Because of this smon printed out errors and normal/immediate shutdown of
database was not possible. I had to do an OS level shutdown. Hence I had to
upgrade to 9.2.0.8. After the upgrade, I tried to use dbca for 9i to 10gr1
upgrade which still gave me the internal oracle error. I switched to manual
upgrade and completed it successfully. Thanks once again.
On Wed, Aug 12, 2009 at 4:57 PM, Taylor, Chris David <
ChrisDavid.Taylor@xxxxxxxxxxxxxxx> wrote:
> 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
>
>
> *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:
