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

I don't know about the error you got installing 9i, but personally wouldn't be confortable with it.

Have you overwritten your 8i Oracle home with the 9i installation? If so you will be in trouble.

Your 8i database has apparently not shut down cleanly; migration should be performed on a cleanly shutdown database (transactional or immediate).

You took a good backup before starting all of that, hmmm?

If you still have 8i around and functional, try starting up the db and shutting down immediate.

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 9.2.0.5
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Eagle Fan" <eagle.f_at_gmail.com> a écrit dans le message de
news:1121420600.904489.272660_at_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.

>