Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent - Migration
Gilberto,
We got very similar errors when upgrading from 8.0.4 to 8.1.5 and then to
8.1.7.
In both cases, we opened a TAR with Oracle and they asked us to turn off
the
star_transformation_enabled init.ora parameter as a workaround. We did and
it made our errors go away. However, this is not an acceptable work-around
for
us since our design is pretty much based on the star query layout for our
120 Gig
data warehouse.
When we were on 8.1.5 they told us we had to go to 8.1.7. Now that we are
on 8.1.7,
that fixed our problems but we have new similar ones with very similar
messages.
We opened a new TAR with Oracle and they recommended the same workaround
with turning off star transformation or applying the 8.1.7.1 patch set.
That is what we are
in the process of doing now.
If I were you, I would open a TAR with Oracle and submit your error message
and
trace files. Are you using partitioning? Do you have
star_transformation_enabled
set to true in your init.ora file?
Thanks,
Cherie Machler
Gelco Information Network
"Gilberto Gampert" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <gampert_at_upf. cc: tche.br> Subject: Urgent - Migration Sent by: root_at_fatcity. com 04/16/01 04:00 PM Please respond to ORACLE-L
Hello People!
I migrate the Oracle 7.3.4.5 to Oracle 8.1.6.0.0, in the following way:
The problem is that began to appear the following error in the alert.log:
--- Mon Apr 16 15:43:19 2001 Errors in file /u01/app/oracle/admin/sun/bdump/sun_s001_1065.trc: ORA-07445: exception found: core dump[kxscdv()+180] [SIGSEGV] [Address not mapped to object] [4] [] [] Mon Apr 16 15:43:54 2001 found dead multi-threaded server 'S001', pid = (13, 2) --- and in the client applications appears: ORA-03113 end-of-file on communication channel. Does anybody can help me? Platform: SUN Enterprise 3000 with 1.5Gb RAM Solaris 2.6 --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil gampert@upf.tche.br http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: gampert_at_upf.tche.br Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Apr 16 2001 - 16:51:59 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Cherie_Machler_at_gelco.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |