Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Migrating Oracle

Migrating Oracle

From: Kimberly Smith <KSMITH1_at_gmd.fujitsu.com>
Date: 27 Apr 2000 12:38:26 -0700
Message-Id: <10480.104351@fatcity.com>


Currently we are running Oracle 8.0.5 32-bit on HPUX 10.20. We are going to be upgrading our machines to HPUX 11 64-bit. I already have an Oracle 8i 64-bit database running in this environment but its a new database. Has anyone had the joy of going from 8.0.5 to 8i (probably 8.1.5) and from 32-bit to 64-bit plus a new operating system? Any gotya's to go with that? I think the preference so far in our upgrades is to go from a fresh install of the OS instead of upgrading but they have not done one with a database yet. These are all 24x7 production systems as well.

I would be willing to upgrade the database to 8.0.6 first then move it to HP11 as 8.0.6 then upgrade to 8i but keep it 32-bit. I see no real gains in 64-bit in our cases (from an Oracle standpoint). Even though that involves a couple of upgrades does it not seem like the easiest and safest in the end? Any thoughts appreciated.



Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work: 503-669-6050
Email: kimberly.smith_at_gmd.fujitsu.com

        kimberly.smith_at_eds.com


 From: L <leed_at_shell.cais.net>
 Date: Thu, 27 Apr 2000 16:12:26 -0400 (EDT)  Subject: [Q] what is table ORA_KGLR7_IDL_SB4?

e have ORACLE 7.3.4.4 on SUN Solaris 2.6. I found there has a trace file generate by user application. The sql statement is following:

SQL> select * from ORA_KGLR7_IDL_SB4
  2 ;
ERROR:
ORA-00600: internal error code, arguments: [12338], [], [], [], [], [], [], []

I search dba_tables and dba_views and can NOT found any name call "ORA_KGLR7_IDL_SB4'. Does anyone know what is that?

Thanks.


 From: Winnie_Liu_at_infonet.com
 Date: Thu, 27 Apr 2000 13:26:05 -0700
 Subject: Re: [Q] what is table ORA_KGLR7_IDL_SB4?

Search the dba_objects. Maybe it's a synonym pointing to a remote object. Received on Thu Apr 27 2000 - 14:38:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US