Re: Urgent - Migration
Thanks for all!! I applied the patch 8.1.6.3.0 and everything was right! Again, thank you! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- 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).
Urgent - Migration
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).
Re: Urgent - Migration
You're probably ok - this is more likely a bug in 8.1.6 (there are many which cause 7445's and 600's). Next step would be to add patches to (at least) 8.1.6.2, probably 8.1.6.3+ hth connor --- Gilberto Gampert [EMAIL PROTECTED] wrote: 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
RE: Urgent - Migration
i migrated 10 oracle 7.3 to 8.1.6 and no need to do al that.. i only run ODMA, and checked an Oracle documentation out . It took me 40minutes to migrate, becaz Odma only create a new oracle 8 dictionary, and then populates the old v7 dict to the new v8 dict. If you have v7 backup, you could try to migrate the way i did. I had no problems. Best luck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 16, 2001 6:00 PM 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: Claudio Roca 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).
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 [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 you