When upgrade database from 8i to 9i ,hit the ORA-07445 error

From: Eagle Fan <eagle.f_at_gmail.com>
Date: 15 Jul 2005 02:43:20 -0700
Message-ID: <1121420600.904489.272660@o13g2000cwo.googlegroups.com>

Hi:

When I did the database upgrade from 8i to 9i, I hit the error ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []

The process is as the following :
1. When I relink all , at the last, show the make error

 Undefined                       first referenced
 symbol                             in file

\t*
/oracle/SUPT2/home/products/9205/srvm/lib/libsrvm.def (symbol scope sp

                 ecifies local binding)

ld: fatal: Symbol referencing errors. No output written to libsrvm.so *** Error code 1
make: Fatal error: Command failed for target `libsrvm.so'

 Then I try to do relink oracle, relink network, relink client, relink utilities
 All relink jobs were OK, so I went ahead to do the upgrade

2. Then I shutdown the database (environment is 8i)

The Ora-07445 errors appeared in the alert.log

ALTER DATABASE CLOSE NORMAL
Thu Jul 14 23:40:24 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 14 23:40:25 2005
Thread 1 closed at log sequence 131488
Thu Jul 14 23:40:33 2005
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 14 23:40:33 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Thu Jul 14 23:40:36 2005
ARCH shutting down
Thu Jul 14 23:40:36 2005
ARC0: Archival stopped
Thu Jul 14 23:40:36 2005
ARCH shutting down
Thu Jul 14 23:40:36 2005
ARC1: Archival stopped
Thu Jul 14 23:40:37 2005
Errors in file /oracle/SUPT2/home/admin/SUPT2/udump/supt2_ora_1645.trc: ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []
Thu Jul 14 23:40:37 2005
Errors in file /oracle/SUPT2/home/admin/SUPT2/udump/supt2_ora_1647.trc: ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []
Thu Jul 14 23:40:38 2005
Errors in file /oracle/SUPT2/home/admin/SUPT2/udump/supt2_ora_1649.trc: ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []
Thu Jul 14 23:40:38 2005
Errors in file /oracle/SUPT2/home/admin/SUPT2/udump/supt2_ora_1654.trc: ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []
Thu Jul 14 23:40:38 2005

3. Then I changed the environment to 9i, startup migrate

   Met the error in the alert.log

ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; kwqplbsc: open notifier exception err 604 replication_dependency_tracking turned off (no async multimaster replication found)

4. Then I notice the error message, try to do shutdown immediate, but the error show: table or view doesn't exist

Does anybody have the same experience?

If I did the startup and then shutdown immediate after I met the 07445 error in 8i environment before startup migrate in 9i environment, can I make the upgrade successfully?

Any information are appreciated. Received on Fri Jul 15 2005 - 04:43:20 CDT