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
<[EMAIL PROTECTED]>
<gampert@upf. cc:
tche.br> Subject: Urgent - Migration
Sent by:
root@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:
1) I exported the data
2) I removed off Oracle 7
3) I installed Oracle 8
4) I imported the data
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
[EMAIL PROTECTED] http://www.upf.tche.br
--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gilberto Gampert
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
