RE: migration sequence oci problem
It's solved. The oci-code must be changed when going from oracle 7 to Oracle 8 or 9. When a sequence.nextval is called using a float_type you get returned Duplicates. Not only the type of column returned must be changed but the buffer etc .. also Thanks, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 27 november 2003 19:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: migration sequence oci problem We could narrow it down to the value of the sequence exceeding 16777216 (2 to the power of 24) This looks familiar as described in bug 2573172 This bug describes to change the type in the odefin call to type 3 but this doesn't help. I know this is not really a dba issue now anymore but I'm desperate for any advice because I don't have any developers left with oci-knowledge Tnx, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: Wednesday, November 26, 2003 16:40 Aan: '[EMAIL PROTECTED]' Onderwerp: migration sequence oci problem Hi, We're testing an oracle 9.2.0.4 database with an oracle 7 client. This is a C++ client, using OCI to go to oracle. We see strange behaviour when using a sequence which worked nicely before. The sequence is not incremented when issueing select res_id.nextval from dual When I test this with an oracle 7 sqlplus client this works also as expected. Is there any known bug or issue known with migrating oci-applications. According to manuals it shouldn't be a problem and I cannot find any problems on metalink about this. Thanks in advance, Jeroen
RE: migration sequence oci problem
We could narrow it down to the value of the sequence exceeding 16777216 (2 to the power of 24) This looks familiar as described in bug 2573172 This bug describes to change the type in the odefin call to type 3 but this doesn't help. I know this is not really a dba issue now anymore but I'm desperate for any advice because I don't have any developers left with oci-knowledge Tnx, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: Wednesday, November 26, 2003 16:40 Aan: '[EMAIL PROTECTED]' Onderwerp: migration sequence oci problem Hi, We're testing an oracle 9.2.0.4 database with an oracle 7 client. This is a C++ client, using OCI to go to oracle. We see strange behaviour when using a sequence which worked nicely before. The sequence is not incremented when issueing select res_id.nextval from dual When I test this with an oracle 7 sqlplus client this works also as expected. Is there any known bug or issue known with migrating oci-applications. According to manuals it shouldn't be a problem and I cannot find any problems on metalink about this. Thanks in advance, Jeroen
RE: migration sequence oci problem
Jeron, I don't know if it would help any, but if it is a DB issue, event 10217 might be useful: $ oerr ORA 10217 10217, 0, debug sequence numbers // *Cause: // *Action: I have never used it myself before, but if you push support a bit maybe they might provide details on how this can be used. I've just experimented with it a bit now, but to no avail - just setting it alone and/or combined with 10046 doesn't seem to make much difference. Thanks, Boris Dali. --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: We could narrow it down to the value of the sequence exceeding 16777216 (2 to the power of 24) This looks familiar as described in bug 2573172 This bug describes to change the type in the odefin call to type 3 but this doesn't help. I know this is not really a dba issue now anymore but I'm desperate for any advice because I don't have any developers left with oci-knowledge Tnx, Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: Wednesday, November 26, 2003 16:40 Aan: '[EMAIL PROTECTED]' Onderwerp: migration sequence oci problem Hi, We're testing an oracle 9.2.0.4 database with an oracle 7 client. This is a C++ client, using OCI to go to oracle. We see strange behaviour when using a sequence which worked nicely before. The sequence is not incremented when issueing select res_id.nextval from dual When I test this with an oracle 7 sqlplus client this works also as expected. Is there any known bug or issue known with migrating oci-applications. According to manuals it shouldn't be a problem and I cannot find any problems on metalink about this. Thanks in advance, Jeroen __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration utility to convert 32 bit DB to 64 bit?
Thanks Dick. It is worth a try. -Original Message- Sent: Thursday, November 13, 2003 6:35 PM To: Multiple recipients of list ORACLE-L To the best of my knowledge, I've done this several times now, you run the appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit. Now you must have the 64 bit executables installed or it creates some interesting results. But you don't have to rebuild the database. UNLESS your changing os platforms like Sun to WinDoze. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Migration utility to convert 32 bit DB to 64 bit?
Thanks for the info Dick. I also found an article on metalink 62290.1 (changing between 32-bit and 64-bit word sizes). Murali. |-+--- | | [EMAIL PROTECTED]| | | tate.fl.us | | | Sent by:| | | [EMAIL PROTECTED]| | | m | | | | | | | | | 11/14/2003 09:34 AM | | | Please respond to | | | ORACLE-L| | | | |-+--- --| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: RE: Migration utility to convert 32 bit DB to 64 bit? | --| Thanks Dick. It is worth a try. -Original Message- Sent: Thursday, November 13, 2003 6:35 PM To: Multiple recipients of list ORACLE-L To the best of my knowledge, I've done this several times now, you run the appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit. Now you must have the 64 bit executables installed or it creates some interesting results. But you don't have to rebuild the database. UNLESS your changing os platforms like Sun to WinDoze. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Migration utility to convert 32 bit DB to 64 bit?
Paula, I moved a database (Sun box) from 32 to 64 bit Oracle 9.2.x. I did nothing except point the database to the 64 bit Oracle software. Of course, it was the same release levels (32 64 were both 9.2.x). Everything is fine. At the very least, I would think that you need to run catalog catproc. Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration utility to convert 32 bit DB to 64 bit?
It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration utility to convert 32 bit DB to 64 bit?
So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration utility to convert 32 bit DB to 64 bit?
To the best of my knowledge, I've done this several times now, you run the appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit. Now you must have the 64 bit executables installed or it creates some interesting results. But you don't have to rebuild the database. UNLESS your changing os platforms like Sun to WinDoze. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration
Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Arménio Teles -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: A. Teles INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Migration
It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF - --- Original Message --- - From: Yechiel Adar [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 05:54:25 Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Armo Teles -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Migration
You can't just copy over the files with os commands and hope that Oracle will somehow recognize them. You have to use RMANs new convert tablespace command to do the byte order conversion. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:54 PM It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF - --- Original Message --- - From: Yechiel Adar [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 05:54:25 Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Armo Teles -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Re: Migration
Tanel, Any idea about speed and temporary storage requirements? Especially for 32G+ datafiles ;-) ? Wondering if it will really be useful in practice, compared to what is available today. Well, it may do for simpler operations, but not necessarily faster. SF - --- Original Message --- - From: Tanel Poder [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 07:49:26 You can't just copy over the files with os commands and hope that Oracle will somehow recognize them. You have to use RMANs new convert tablespace command to do the byte order conversion. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:54 PM It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF - --- Original Message --- - From: Yechiel Adar [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 05:54:25 Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Armo Teles -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Re: Migration
Well, I don't know about it's performance, but I think this conversion doesn't require any temporary space, because the byte values of some structures in blocks have to be swapped, and this a trivial operation. I think it may still be faster, especially if we are dealing with huge amounts of data, swapping bytes in blocks is faster than reading and parsing data through buffer cache, transferring it over sqlnet and formatting + writing it back to datablocks... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 6:14 PM Tanel, Any idea about speed and temporary storage requirements? Especially for 32G+ datafiles ;-) ? Wondering if it will really be useful in practice, compared to what is available today. Well, it may do for simpler operations, but not necessarily faster. SF - --- Original Message --- - From: Tanel Poder [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 07:49:26 You can't just copy over the files with os commands and hope that Oracle will somehow recognize them. You have to use RMANs new convert tablespace command to do the byte order conversion. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:54 PM It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF - --- Original Message --- - From: Yechiel Adar [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 05:54:25 Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Armo Teles -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Migration
Hi Stephane, The way you put it here would mean that the internal format of the tablespaces will be big/little-endian independant. That would mean either an extra amount of overhead in the low level IO, or Oracle-specific arithmatic everywhere in the kernel. I doubt whether Oracle would do that. It might (will!) cause severe performance penalties. A few weeks ago I had an interview with Chuck Rozwat. I asked him this specific question. He was quite convinced telling me that the transport mechanism (data pump?) performs the HW-dependent conversions whenever you transfer a tablespace from one platform to another. He told me also that the HW-dependant differences will remain in place, and it isn't possible to have a R/O tablespace opened simultaneously by instances running on different platforms. (Not even Windoze/Linux combined) So the binary incompatability will remain in place. Alas, I haven't got a beta version, so I haven't been able to test it yet :( Regards, Carel-Jan At 06:54 10-11-03 -0800, you wrote: It raises an interesting question. As of today, we have datafiles which are OS dependent and _not_ binary compatible from one system to another. We upgrade to 10g and it will become magically binary compatible. Which means that the upgrade process will do more intimate things than updating some file header block, creating a couple of new tables in the data dictionary and recreating view. Has anybody tried to upgrade from 9.x to 10g yet, on some database of decent size ? SF - --- Original Message --- - From: Yechiel Adar [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 10 Nov 2003 05:54:25 Wait for 10g. They say that you could just copy the datafiles and them plug them in to he new database, even across platforms. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:24 AM Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? 4.. Witches are the main tasks to consider in a planning schedule? 5.. Witches are the time frames associated to these tasks? Thanks Armo Teles -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Migration
A. Teles wrote: Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? No. Would take ages. 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? With imp? Could really be weeks. 3.. It is possible to apply the mentioned technique or some other (witch one?) in uptime, totally or partially? You must try to do as many things as you can in parallel, running many processes at once. If you can safely take all the network bandwidth without being fired, SQL*Plus COPY on a table-per-table basis. Which means that you have, prior to that, recreated tablespaces, users, etc. Other than SQL*Plus COPY (or CTAS across a dblink), you can download to flat files (there are tools for that), ftp, SQL*Loader direct, which assumes you already have recreated empty tables (exp ROWS=N CONSTRAINTS=N can help). 4.. Witches are the main tasks to consider in a planning schedule? The great thing is that you need not backup your database. But you must be able to switch back quickly to the old system if anything goes wrong. Be careful with your scripts (NOVALIDATE when reenabling constraints, for instance). Test a lot beforehand. Otherwise it really depends on your operational constraints. For a hospital you can't afford be offline for a long time. 5.. Witches are the time frames associated to these tasks? Can really vary. Order of magnitude is likely to be several hours in the best of cases IMHO. Also, it also depends on how much of your data is really active. You may consider quietly moving the 'dead' or archived part of it, and switching later the really active, much smaller set. Logging activity is also something which can be cntemplated for really difficult cases. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration
Hi List, Could someone please help me? Assumption situation - Platform migration of Oracle DW on Oracle DB (data volume 3.5 TB) from HP-UX to IBM-AIX 1.. DB migration; it is correct to use Export/Import technique/method in the above assumption? Use exp/imp only for transporting the database structure, using rows=n. Then use insert /*+ APPEND */ over database links for transporting data itself. Just copying over the files or using cross-platform transportable tablespace doesn't probably work even though HP IBM Unix servers both use Big Endian byte order. (Btw, in 10g you can use RMAN to convert tablespaces datafiles to any supported platform specific format :) 2.. Witch is the time frame in a worst case for this (how many hours, days or weeks!!)? If planned well and on proper hardware, I guess you can do it in one weekend. It is possible to reduce downtime even more, but in that case you have to take special measures, like logging DML, precopying read only data, rolling upgrades, etc.. The worst case can be weeks, but of course you should be doing a lot of migration testing (with full dataset if possible), to be sure in your downtime requirement first. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration 9201 to 9203 doc needed
Title: Migration 9201 to 9203 doc needed Unless Im really missing something, going from 9.2.0.1 to 9.2.0.3 is just a patch install, and the README.html included in the patch should tell you what you need to do. --Walt Weaver Bozeman, Montana -Original Message- From: Martin, Alan (Contractor) (DLIS) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: Migration 9201 to 9203 doc needed Does anyone have the subject Metalink note? Oracle's gateway problems are preventing access to ML. Thanx, Alan Martin Defense Logistics Info Service
RE: Migration 9201 to 9203 doc needed
Title: Message Your right, sorry. My brain is fried today. Thanx, Alan -Original Message-From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 5:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Migration 9201 to 9203 doc needed Unless I'm really missing something, going from 9.2.0.1 to 9.2.0.3 is just a patch install, and the README.html included in the patch should tell you what you need to do. --Walt Weaver Bozeman, Montana -Original Message-From: Martin, Alan (Contractor) (DLIS) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:00 PMTo: Multiple recipients of list ORACLE-LSubject: Migration 9201 to 9203 doc needed Does anyone have the subject Metalink note? Oracle's gateway problems are preventing access to ML. Thanx, Alan Martin Defense Logistics Info Service
RE: Migration Suggestion.
If you cannot recover the database, you *** CAN *** take a cold backup and open it elsewhere, on a 5.2 box, for example. You only have to make sure that you loaded the right post_wait extensions. I advise you to use the ones from 9.2. Boot the machine in 32 bit mode. No migration is necessary, cold backup actually works in 32 bit mode. IBM went to great lengths to ensure the compatibility. I'll risk extreme unpopularity with IBM-bashers, but they did an admirable job. I tried things with AIX 4.3 and the 8.1.7.1 database and it worked. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 1:39 PM To: Multiple recipients of list ORACLE-L I am looking for some expert suggestions for the migration of 300GB database to different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit and performance on this system is really slow. Export for 2GB table takes 2 hours. All the data is on EMC symmetric. We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit. Oracle 816 on AIX5.1 is not supported. 'Cause OS is different we cannot use redirect restore and apply archive logs to bring the database up. Any suggestion regarding migration. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration Suggestion.
This would be alot of extra work and downtime compared to export/import but... 1) upgrade to AIX 4.3.3 You might want to think about using AIX 64 bit here (you can still run Oracle on 32 bit if you want). 2) upgrade to 8.1.7.4 3) AIX 4.3.3 is binary compatable with 5.1, so you _could do a cp. 4) If you are using LPAR you may want to go to 5.2 because you can use dynamic reconfig. HTH, Mike [EMAIL PROTECTED] idence.org To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: Migration Suggestion. m 08/26/2003 01:39 PM Please respond to ORACLE-L I am looking for some expert suggestions for the migration of 300GB database to different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit and performance on this system is really slow. Export for 2GB table takes 2 hours. All the data is on EMC symmetric. We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit. Oracle 816 on AIX5.1 is not supported. 'Cause OS is different we cannot use redirect restore and apply archive logs to bring the database up. Any suggestion regarding migration. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues
Looks like a whole set of bugs we haven't come across YET -Original Message- Sent: 20 June 2003 10:14 To: Multiple recipients of list ORACLE-L After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. _library_cache_advice=false This parameter takes care of library cache pin problem _optim_enhance_nnull_detection=false SELECT COUNT(*) GIVES WRONG RESULT with null values ( BUG:- 2920925 ) _multi_join_key_table_lookup=false (BUG:- 2446423) Details:- QUERY RETURNS WRONG ANSWER WITH ORDER BY CLAUSE _predicate_elimination_enabled=false BUG:- 2257439 Details:- NULL VALUE IN PARTITION RETURNED IF PARTITION BOUND VALUE IS IN WHERE CONDITION M/c = SF15K Database using Shared Servers (MTS) Database Size = 250 GB Hybrid Banking Application using Bind variables mostly though some amount of Literal SQLs also run cursor_sharing = EXACT We are considering trying out cursor_sharing = FORCE gradually checking if shared_pool_size shared_pool_reserved_size values can be reduced . Any Else experienced such issues ? Any Advise ? We are considering Migrating another 1000 GB Production database also to 9i setting Similar parameters . Following is a STATSPACK report of the Production Database already at 9i having the above NON-Documented parameters already set . DB Name DB IdInstance Inst Num Release Cluster Host --- --- --- TBASUN1820705732 tbasun 1 9.2.0.3.0 NO IB15KDB Snap Id Snap Time Sessions Curs/Sess Comment --- -- - --- Begin Snap:1437 18-Jun-03 11:00:032,686 49.2 End Snap:1446 18-Jun-03 12:00:052,936 51.0 Elapsed: 60.03 (mins) Load Profile Per Second Per Transaction --- --- Redo size:265,713.47 1,165.59 Logical reads: 24,199.94106.16 Block changes: 1,275.65 5.60 Physical reads: 1,293.29 5.67 Physical writes:108.35 0.48 User calls: 7,869.31 34.52 Parses:348.92 1.53 Hard parses: 19.96 0.09 Sorts:243.00 1.07 Logons: 8.93 0.04 Executes: 4,874.94 21.38 Transactions:227.97 % Blocks changed per Read:5.27Recursive Call %:12.26 Rollback per transaction %: 68.52 Rows per Sort: 335.11 Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- latch free 1,386,411 72,966 14,913 11 1.7 db file sequential read 3,606,772 0 5,690 2 4.4 log file sync 327,290273 4,104 13 0.4 log file parallel write 240,139236,242245 1 0.3 PctAvg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss(s) Requests Miss -- -- -- -- -- library cache52,729,8761.70.4 5393 248,744 11.0 Get PctPinPct Invali- Namespace Requests Miss Requests Miss Reloads dations --- -- -- -- -- BODY 2,7150.1 2,7150.2 10 CLUSTER 2070.03100.0 00 INDEX 9,4310.4 9,4310.4
RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues
I don't think the cursor sharing will help. We've been going 'round and 'round with the shared pool fragmentation problem and the 4031 errors. Flushing the shared pool might or might not work; sometimes it cleans things up; sometimes it doesn't do anything (as far as I can tell). About all you can do is follow Oracle's recommendations on sizing and cross your fingers. You might have to schedule a periodic restart of the database -- sort of like Windows 3.1 huh? And ... Oracle is still trying to figure out why index create/rebuild online on a busy table can lock things up. Other people have brought it to their attention, but we (apparently) are the first site that could make it happen at will. I guess there are times when those fat pig applications are useful for something. By the way, we are on Tru64, so I don't think the problems are platform specific. -Original Message- After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: MIGRATION FROM Oracle 8.1.6 to 8.1.7 - Invalid Table Partitions
Hi We had a different problem with our upgrade but the same error message - there is a patch available from Oracle that is supposed to help(did n't for us though) Regards, N. -Original Message- [EMAIL PROTECTED] Sent: 01 April 2003 09:04 To: Multiple recipients of list ORACLE-L Hi gurus, I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on Windows 2000) but when I try to query my partitoned tabless I get the error ORA-00604 'error occured at recursive SQL level 1' ORA -00904 'Invalid column name' I have run the scripts U0801060.sql (which calls catalog.sql and catproc.sql) in vain. I can access unpartitioned tables without errors. Any ideas? Moses Mmoya This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: migration
An ora 1452 error says there are duplicate keys, hence you can't create a unique key. If it is a known, death be unto me if I am wrong, 100% fact that the unique key was valid in the original data, the first question I would ask is: Was this an import that is being run with commit=y ignore=y, aborted, then restarted without truncating the data? In a case like that, you would get duplicate rows. If that is not the case, you could try creating an EXCEPTIONS table using the ?/rdbms/admin/utlexcpt.sql script. Then try to add the unique constraint using the extra clause: exceptions into exceptions. The exceptions table will have the rowid's of the offending rows. You can then: select a,b,c,etc. from your_table where rowid in (select row_id from exceptions); -Original Message- IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: migration
How about checking out the part of the import log where it tells you which character sets are being used? Jared Peter R [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 03:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:migration Hi Friends, Iam migrating data from 7.3.2 to 8.1.7.4 with exp/imp, when Iam importing into 8.1.7.4 Iam getting silly errors like IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001 I checked in metalink and other sites for help, I got sense that its all about NLS_LANG parameter!! But my both databases are US7ASCII character set!! I have no clue what to do?? I tried to set nls_lang and exported it!! But no use!! I got the sense its all about char set!! Any help will be appreciated!! TIA Peter. _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration from SQL Server to ORACLE 9i
Look into Oracle Migration Workbench (on technet, it's free). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 4:18 AM Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration from SQL Server to ORACLE 9i
Babu - Congratulations on the project! Is this database especially large or are you facing severe restrictions in terms of the amount of time the data is unavailable to your users? Are there any unusual objects in SQL Server that will be difficult to create in Oracle? I think Oracle provides a migration tool, but I haven't used it. Usually I follow a procedure such as: 1. Create objects in Oracle. 2. Dump data from SQL Server to a flat file. 3. Load the data with SQL*Loader. 4. Verify the data, application. 5. Prepare for production cut-over. 6. Truncate Oracle tables. 7. Dump data from SQL Server to a flat file and load with SQL*Loader. 8. Shut down SQL*Server. 9. Verify application is ready to go live. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 04, 2003 3:19 AM To: Multiple recipients of list ORACLE-L Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration from SQL Server to ORACLE 9i
Read-up: http://otn.oracle.com/documentation/oracle9i.html http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration from SQL Server to ORACLE 9i
Another thought is to use DTS to handle at least some of the transfer for you. SQL Server's DTS (Data Transformation Services) package will be able to connect to Oracle, create the table structure and import the data for you. You are on your own as far as foreign keys and primary keys, etc. But something like ERwin could help you out with that. DTS is great for simple data loads, not sure how complicated your migration is, but its something to look into. Good luck! -Original Message- Sent: Tuesday, February 04, 2003 9:40 AM To: Multiple recipients of list ORACLE-L Babu - Congratulations on the project! Is this database especially large or are you facing severe restrictions in terms of the amount of time the data is unavailable to your users? Are there any unusual objects in SQL Server that will be difficult to create in Oracle? I think Oracle provides a migration tool, but I haven't used it. Usually I follow a procedure such as: 1. Create objects in Oracle. 2. Dump data from SQL Server to a flat file. 3. Load the data with SQL*Loader. 4. Verify the data, application. 5. Prepare for production cut-over. 6. Truncate Oracle tables. 7. Dump data from SQL Server to a flat file and load with SQL*Loader. 8. Shut down SQL*Server. 9. Verify application is ready to go live. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 04, 2003 3:19 AM To: Multiple recipients of list ORACLE-L Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration from SQL Server to ORACLE 9i
How about using SQL Server's DTS ? So long as you have Net8 plus an OLEDB driver for Oracle installed on your SQL Server box you can just shift the tables across. Point and click in true SQL Server fashion, you can't go wrong. Ade -Original Message- Sent: 04 February 2003 14:40 To: Multiple recipients of list ORACLE-L Babu - Congratulations on the project! Is this database especially large or are you facing severe restrictions in terms of the amount of time the data is unavailable to your users? Are there any unusual objects in SQL Server that will be difficult to create in Oracle? I think Oracle provides a migration tool, but I haven't used it. Usually I follow a procedure such as: 1. Create objects in Oracle. 2. Dump data from SQL Server to a flat file. 3. Load the data with SQL*Loader. 4. Verify the data, application. 5. Prepare for production cut-over. 6. Truncate Oracle tables. 7. Dump data from SQL Server to a flat file and load with SQL*Loader. 8. Shut down SQL*Server. 9. Verify application is ready to go live. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 04, 2003 3:19 AM To: Multiple recipients of list ORACLE-L Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: migration from Sybase to Oracle
Best option is to use bcp to get the data out of Sybase ino a flat file, then use SQL*Loader to get the data into some Oracle staging tables. You can then use pl/sql procs to move the data to it's final destination. Ade -Original Message- Sent: 29 January 2003 12:49 To: Multiple recipients of list ORACLE-L Hi Everyone, We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models defer a lot. Is there any tool available for this kind of migration. Can we do this migration with out any tool. If yes please let me know like how should we go about this migration. If there are any websites/ checklist on effort estimation till implementation please share with me. Thanks in advance. Regards, Vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: migration from Sybase to Oracle
vijay, oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle. however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you could possibly use this product to at leastget your data into oracle then massage it into your new structures. good luck, steve Vijaya Chander V.S [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/29/2003 07:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:migration from Sybase to Oracle Hi Everyone, We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models defer a lot. Is there any tool available for this kind of migration. Can we do this migration with out any tool. If yes please let me know like how should we go about this migration. If there are any websites/ checklist on effort estimation till implementation please share with me. Thanks in advance. Regards, Vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: migration to oracle 9i
We attempted to use OID 3.0.1 for our LDAP implementation, but OID cannot accept all v3LDAP-compliant LDIFs, despite what their marketing says. When we filed a TAR, Oracle Support's solution was to have us Oracleize the industry-standard LDIF. Wrong! This same LDIF file has since been imported verbatim into OpenLDAP and SunOne (iPlanet). We are choosing to use SunOne. Also, under RedHat, we have run into another show stopper while using replication with OID. For some unknown reason, we will end up with Max connections reached. closing connection. in the oidldapd.log file, even when there's very sparse usage. We filed BUG 2369181, which is still pending, AFAIK. The workaround is to bounce the LDAP servers. Unbreakable... And since we intend on using SunOne, Oracle won't support it's usage for names resolution unless you also have OID as a gateway between the two. Huh?? What the hell is the point of doing that? Sure doesn't help the CUSTOMER! soapbox So, until Oracle cleans up their LDAP act (which, admittedly, our new Oracle sales guy seems to be working at), they can bite me. Sorry if that comes off a bit acerbic, but it really gets my goat when a software company like Oracle tries to pull that MS BS of making an industry standard proprietary just so they can charge us for an inferior product when much more mature and stable (and CHEAPER!) alternatives are available. All it does is get the customer hacked off, which isn't good for Oracle nor Us. /soapbox Best of luck to ya! :) I do have some nifty Korn scripts for dealing with OID administration. One of these days I'll have to post them to the web. If you want them in their raw form, contact me offline. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, September 17, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Hi Guys , I know this question might have apperaed in this many times and I just neglected it cuz I was not interested in it. But now I am asking same question . We are runnning oracle bi ( 8.1.7) database , since recently it has been decided to move our iplanet LDAP server to oracle 9i LDAP we are considering migrating our database also to oracle 9i . Now my question is a) what version oracle 9i is most stable 9.1.0.2 . Are there any issues which we should be concerned about . I am sure many of you have done this migration .I would like to know your experience . Thanks , Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Migration Assistant Speeds
I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours. Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. THT YMMV! Post, Ethan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] t cc: Sent by: Subject: Migration Assistant Speeds [EMAIL PROTECTED] 09/11/2002 09:23 AM Please respond to ORACLE-L Can anyone share experience with running database migration assistant against a 150 GB database (7.3.4) and how long it takes? Don't have the box specs yet but I think it is a 3 CPU HPUX with 2 GB Ram and a couple of unmirrored disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
Re: Migration Assistant Speeds
Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. -- I shall go for full export with direct=y recordlength-65535 and file=/dev/null which may be much faster then analyzemay be 5-6 hours Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 11 Sep 2002 09:24:46 -0800 I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours. Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. THT YMMV! Post, Ethan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] t cc: Sent by: Subject: Migration Assistant Speeds [EMAIL PROTECTED] 09/11/2002 09:23 AM Please respond to ORACLE-L Can anyone share experience with running database migration assistant against a 150 GB database (7.3.4) and how long it takes? Don't have the box specs yet but I think it is a 3 CPU HPUX with 2 GB Ram and a couple of unmirrored disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Migration Assistant Speeds
Also keep in mind that if you use the assistant to go from 7.x to 8.x, the system tablespace will grow at least 2x. During the migration process, both the 7.x and 8.x data dictionary exists. For our Oracle Applications 10.7 instances with 55,000 objects, this was not acceptable. We instead exported/imported. This also gave us the apportunity to move to LMTs. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/11/02 10:53 AMcc: Please respond toSubject: Re: Migration Assistant Speeds ORACLE-L Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. -- I shall go for full export with direct=y recordlength-65535 and file=/dev/null which may be much faster then analyzemay be 5-6 hours . Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 11 Sep 2002 09:24:46 -0800 I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours. Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. THT YMMV! Post, Ethan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] t cc: Sent by: Subject: Migration Assistant Speeds [EMAIL PROTECTED] 09/11/2002 09:23 AM Please respond to ORACLE-L Can anyone share experience with running database migration assistant against a 150 GB database (7.3.4) and how long it takes? Don't have the box specs yet but I think it is a 3 CPU HPUX with 2 GB Ram and a couple of unmirrored disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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
Re: migration MS SQL 6.5 to ORACLE 8i
See otn.oracle.com for Oracle Migration Workbench. -Joe --- Arslan Bahar [EMAIL PROTECTED] wrote: How !? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar 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). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: MIGRATION
Here's something to keep in mind... It seems on Friday, Feb. 15, Interland picked up a few of the servers it was hosting, placed them on a truck, and then moved them to a new facility with a new IP address -- without notifying at least one disgruntled customer. The move left our reader unable to update any DNS or domain records, and crippled his clients' Web sites. Apparently the same is true for other Interland customers, as tech support appears to be too swamped to even handle his calls. Meanwhile, our reader claims there is nothing left to do but beat myself over the head with a recently emptied tequila bottle. ROBERT X. CRINGELY(R): Notes from the Field InfoWorld.com -Original Message- Sent: Monday, February 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Hi I am planning to move our DB servers from one data center to another Data center.Let me know what precausion should I take care please? Thx -Guri _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guri singh 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: Grabowy, Chris 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: MIGRATION
Guri, When we move hosting centers, we certainly prefer to do it with some overlap. We usually move our machines with the test databases, create enough room to make standby databases for production. That way we can halt the production databases, activate the standby's and switch our applications over in a matter of minutes. Then leisurely move the production machines and reverse the standby procedures to get the databases back on the original machines. I know when you compare it to power down the machine and move it it's a lot of activity. But there's a lot of peace of mind having an operating database at the new location before you take down production -- you just never have a database dependent on equipment that is in the hands of teamsters. If you don't have the machines to do something like this and can't beg, borrow, rent or steal. Then I'd advise cold backups on removable media transported in a different vehicle than your machine. It's a good idea to have more than one device that can read the media as I've found that removable media devices fail during moves more than most other devices. -rje g I am planning to move our DB servers from one data center to another Data g center.Let me know what precausion should I take care please? g Thx g -Guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: MIGRATION
Rje I don't have machine to buildup the standby database.I don't have much time to take cold backup also.I think if Can take cold backup on another disk partition would be fine. Any suggestion please? Thx guri From: Robert Eskridge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: MIGRATION Date: Mon, 25 Feb 2002 11:28:41 -0800 Guri, When we move hosting centers, we certainly prefer to do it with some overlap. We usually move our machines with the test databases, create enough room to make standby databases for production. That way we can halt the production databases, activate the standby's and switch our applications over in a matter of minutes. Then leisurely move the production machines and reverse the standby procedures to get the databases back on the original machines. I know when you compare it to power down the machine and move it it's a lot of activity. But there's a lot of peace of mind having an operating database at the new location before you take down production -- you just never have a database dependent on equipment that is in the hands of teamsters. If you don't have the machines to do something like this and can't beg, borrow, rent or steal. Then I'd advise cold backups on removable media transported in a different vehicle than your machine. It's a good idea to have more than one device that can read the media as I've found that removable media devices fail during moves more than most other devices. -rje g I am planning to move our DB servers from one data center to another Data g center.Let me know what precausion should I take care please? g Thx g -Guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guri singh 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: MIGRATION
Hi Guri, If you don't have time to make a backup before moving a machine to a different site at least take the time to update your resume and put it in a safe location. Good Luck, John [EMAIL PROTECTED] wrote: guri, If you don't have the time to get the cold backup to removable media, you'll just have to accept the risk of the box being lost, stolen, or destroyed in an accident. You can still reduce risks in other areas. I don't see what risk you are abating by making a cold backup to another disk partition, unless that partition is on another physical drive. A physical event that causes one file to be unreadable (such as head damage) usually renders the entire disk unreadable, so you don't gain much. If it's a different physical drive, at least you're gaining the probability of one of them surviving the physical abuse. Chances are you'll be able to shut down the database, shut down the OS, power down the machine, carry it to the new location, and power it back up with no problem. Modern equipment is fairly robust. Personally I'd treat it all like a carton of eggs just to be safer. The how much extra precaution you take should be based on what it will cost you if the machine falls off the truck, never to be seen again. One can justify the cost of the precautions as long as they are lower than the cost of the loss. -rje g I don't have machine to buildup the standby database.I don't have much time g to take cold backup also.I think if Can take cold backup on another disk g partition would be fine. g Any suggestion please? g Thx g guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: MIGRATION
Last time I moved a server from one data center to another we just powered it down, unplugged it all, rolled it down the hall to the other data center and plugged it all back in. Did this without affecting production too. Of course production was halted due to a network upgrade but that's not the point. Actually moved it so I could get a backup of the system ironically enough. Had to get it connected to the other backup system due to the network being down. It all comes back to that network thing. -Original Message- Sent: Monday, February 25, 2002 1:43 PM To: Multiple recipients of list ORACLE-L Hi Guri, If you don't have time to make a backup before moving a machine to a different site at least take the time to update your resume and put it in a safe location. Good Luck, John [EMAIL PROTECTED] wrote: guri, If you don't have the time to get the cold backup to removable media, you'll just have to accept the risk of the box being lost, stolen, or destroyed in an accident. You can still reduce risks in other areas. I don't see what risk you are abating by making a cold backup to another disk partition, unless that partition is on another physical drive. A physical event that causes one file to be unreadable (such as head damage) usually renders the entire disk unreadable, so you don't gain much. If it's a different physical drive, at least you're gaining the probability of one of them surviving the physical abuse. Chances are you'll be able to shut down the database, shut down the OS, power down the machine, carry it to the new location, and power it back up with no problem. Modern equipment is fairly robust. Personally I'd treat it all like a carton of eggs just to be safer. The how much extra precaution you take should be based on what it will cost you if the machine falls off the truck, never to be seen again. One can justify the cost of the precautions as long as they are lower than the cost of the loss. -rje g I don't have machine to buildup the standby database.I don't have much time g to take cold backup also.I think if Can take cold backup on another disk g partition would be fine. g Any suggestion please? g Thx g guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Kimberly Smith 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: Migration utility from 7.3.4 to 9i ??
Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: RE: Migration utility from 7.3.4 to 9i ??
Hi Dick, According to the 9i Migration Utility Guide, the Mig Utility that comes with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no 7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it myself. We migrated several 7.3.x database to 8.x using Mig Util without any problems. Of course, one can always use export/import for such things. - Kirti -Original Message- Sent: Thursday, February 07, 2002 8:22 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Migration errors
These errors have to do with advanced queueing. Do you have AQ_TM_PROCESSES set to any value other than 0? If you do, set it to 0 during the upgrade. N.B., this is a mere guess based on the information provided. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 7:25 PM To: Multiple recipients of list ORACLE-L hi all, Is any body encountered following errors... this happening while I try to migrate 8.1.7.2 database to 9.0.1 using manual upgradation or ODMA tool. ALTER TABLE system.aq$_queues * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ALTER TABLE system.aq$_queues * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] and alert log has following errors Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:04 2002 Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:06 2002 Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:08 2002 TIA narender akula Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: MacGregor, Ian A. 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: migration
I've done quite a few migrations and I just wanted to reiterate what Jared said. There are a lot of little steps listed in the migration guide that don't seem important but if you ignore them, you can really screw up your migration. So follow the steps listed and test, test, test. Cherie Machler Oracle DBA Gelco Information Network Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: migration om 01/07/02 12:26 PM Please respond to ORACLE-L The best advise is to *read* the migration manual. Then build a test database and document the steps needed for your site to do the migration. This actual steps needed from the migration manual is highly dependent on your environment. Jared Nirmal Kumar Muthu KumaranTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] NIRMALK@qtel. cc: com.qa Subject: migration Sent by: [EMAIL PROTECTED] om 01/07/02 08:00 AM Please respond to ORACLE-L Hi guru's, Can someone guide me how to do the migration from oracle7.3.1 to 8.1.7. I have all full cold backup of Oracle731 database. Now i want to migrate it to Oracle817. What i did is: 1) i created a new service using oradim command, 2) Modified init.ora file accordingly and restored all database files in appropriate directory folders. 3) While i'm tring to migrate it with migrate assitant after 15 mintes it will hangup. Any one have best soltion to do this task? Is any manual steps are there to migrate a database as like creating database with step by step?. Thanks in adv. Rgds, Nirmal. (See attached file: att29yx1.dat) (See attached file: att29yx1.dat) att29yx1.dat Description: Binary data
RE: MIGRATION OF DATA
Seema - For this amount of data, you might consider a clone technique. Go to http://www.orafaq.com and search on clone. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 25, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Hi I want to migrate data from one server to other server on unix platform.If database is more than 40gb which method is good to migrate data from one server to other.I have oracle 8.1.7 on solaris 2.7. With regards -Dinesh _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: DENNIS WILLIAMS 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: Migration v. Upgrade
Erik - I believe the upgrade / recovery manual will have the more concise definition you seek. Look for the Oracle version you are on and the one you want to move to and it will tell you whether you need to upgrade or migrate. With an upgrade you usually just bring up the new version and run some procedures to modify your system tables. With migrate it is much more involved. To put things concisely: upgrade - good migrate - bad upgrade - minor, easy. migrate - hard, difficult, headaches. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 02, 2001 11:00 AM To: Multiple recipients of list ORACLE-L I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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: DENNIS WILLIAMS 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: Migration v. Upgrade
Migrating is the process of transforming one database version to a later database version. Oracle 7 to Oracle 8 is migration. Upgrading is the process of transforming one database release to another database release of the same database version. Oracle 8.0.1 to 8.0.5 is upgrading database. HTH Rick -Original Message- Sent: Tuesday, October 02, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Erik - I believe the upgrade / recovery manual will have the more concise definition you seek. Look for the Oracle version you are on and the one you want to move to and it will tell you whether you need to upgrade or migrate. With an upgrade you usually just bring up the new version and run some procedures to modify your system tables. With migrate it is much more involved. To put things concisely: upgrade - good migrate - bad upgrade - minor, easy. migrate - hard, difficult, headaches. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 02, 2001 11:00 AM To: Multiple recipients of list ORACLE-L I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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: DENNIS WILLIAMS 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: Cale, Rick T (Richard) 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: migration from RBO to CBO
ALL_ROWS is not always good for OLTP, is this an OLTP environment? Perhaps FIRST_ROWS is better, perhaps not. I would recommend sticking with CBO, properly tuned, it is generally faster in all cases, although you sometimes have to use hints to make up for an incorrect plan choice. Like you said, a lot of the new features truly benefit from Cost based optimization. Plan stability and outlines are a good idea if you feel you have good plans and you do not want them to change, but a lot of times you may want them to chance as data grows, especially when it is unexpected. Make sure you look at the INDEX_ parameters which drastically increase the effectiveness of the CBO. Also be concerned with parameters like DB_FILE_MULTIBLOCK_READ_COUNT which also affect which path CBO takes. I would recommend using DBMS_STATS instead of Analyze table due to parallel use and bugs. You may want to also consider 'monitor' feature of tables to assist in determining stale statistics with DBMS_STATS and get a good idea of usage. When and how often plays a big factor in how you do statistics. In a smaller environment, you have more lead way, in the larger environments your decisions become more difficult. I generally try to use hints as a last resort only, although they are needed in times, not always. One interesting trick is to force the database into RBO and capture outlines, then switch to CBO and use statistics, then you have certain plans saved so you have the effect of using RBO for them. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Saturday, September 15, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi List, I'm going to change my job and I'll have to inherite one DB which doesn't seem to be very good designated. I haven't known much about the application yet and I can't post many details to you but I would appreciate your general advices. Despite of the optimizer_mode set to RULE at instance level, they use many new features (partitioning, bitmap indexes, function-based indexes, etc). It seems the system is overloaded with indexes and optimizer hints. They collect statistics regularly. Molotov's cocktail! So I expect some hybrid behaviour of the optimizer. The sql statements don't seem to be especially optimized for RBO and give real trouble for system (my first feeling). Before we could start any sql tuning we have to decide which road to choose. My current understanding is that we need to fix existing execution plans with 'Plan Stability' option and set optimizer_mode = all_rows. Then ask the developers to use CBO in new development and gradually test and rewrite existing code. What would be your advice? Any experience? Also I would like to know if anybody use the 'plan stability' feature. Is it stable itself ? :) The system is 8.1.7.0.1 on Red Hat Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard 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: Christopher Spence 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: Migration
You don't migrate a database from 8.x to 8.x, migrations happen between major version numbers(like 7 to 8), heck 8 to 9 isnt even a migration nowadays. anyway, break out the migration guide( a misnomer at best) and start reading the chapters on upgrading from 8.0 to 8.1. joe [EMAIL PROTECTED] 09/17/01 03:50PM Hi Folks, In the weekend I will migrate my database 8.0.5 to 8.1.7 any steps to follow. Actually Oracle 8.0.5, - Compaq Proliant ML530 - 2 Pentium III 800 MHZ processor - 1 GB Memory - 6 Hard Drives of 9GB = 54 GB (In a Raid 0 or 5 get confused, all as big disk) - DLT 20/40 GB - 40 users Want to implement LMT tablespace. In the very near future want to migrate the applications to web style, Intranet. What products install ? Is an obligation install 9i Application Server ? TIA, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
RE: Migration of simple snapshots
In your case, i would have used offline instantiation. Have a look at the replication manual! Cheers -Original Message- From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 18:51 To: Multiple recipients of list ORACLE-L Subject: Migration of simple snapshots I use simple snapshots, and have some questions regarding migration from 7.3.4.5 to 8.1.6.2: 1) Can a 8.1.6.2 master site co-exist with a 7.3.4.5 snapshot site? 2) After I migrate master site I need to drop triggers on the mlogs, because 8I does not use database triggers to populate the mlogs? 3) Do I need to do a complete refresh of each snapshot after the master migration? Any way around this? 4) Do I need to convert my rowid snapshots to primary key snapshots? 5) Any other issues I need to be aware of? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth 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: Hatzistavrou Giannis 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: Migration Workbench
glad to see it worked for you. I hate to see people go through the same run around I did. Reed -Original Message- Sent: Monday, July 02, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Thanks, Reed, I'm in. Guess you had the same problem cause I found nothing on Metalink. Dave - There is a bug in migration workbench that you have to make sure that your root password on the mysql database is 8 characters long, then specify that password when connecting through migration workbench. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Migration Workbench
There is a bug in migration workbench that you have to make sure that your root password on the mysql database is 8 characters long, then specify that password when connecting through migration workbench. This should clear up the handshake error. Hope this helps. -Original Message- Sent: Monday, July 02, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Has anyone encountered problems with the Migration Workbench? We are moving an older database from mysql 3.23 to oracle 8.1.7, however, when I try to connect to the mysql database from the tool, I get either a handshake error, or told no databases running on that server. I am able to connect to the mysql from windows command line. And to anyone that has used the migration tool in general, did they find it of much use? Thanks, Dave -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Migration Workbench
Thanks, Reed, I'm in. Guess you had the same problem cause I found nothing on Metalink. Dave - There is a bug in migration workbench that you have to make sure that your root password on the mysql database is 8 characters long, then specify that password when connecting through migration workbench. -- 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).
RE: Migration of a database from MS Access to ORACLE
Oracle provides a tool for this. I have seen it used successfully. OLE Objects? Dunno -Original Message- Sent: Thursday, June 21, 2001 2:01 PM To: Multiple recipients of list ORACLE-L Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE objects which need to be moved too. Any help would be appreciated ! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Mohan, Ross 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: Migration from 7.3.4 to 8.1.6
The thing that is killing us is a single query. This query does a group by. It also references some user-defined functions in the column-list of the SELECT statement. These user-defined functions are actually SELECTS from 2 other small tables. It is not behaving the same way it did in version 7.3.4. The table that the query runs against is pretty big (700,000 rows across 4 gig). The 2 tables referenced by the user-defined functions are very small (10-20 rows). "Ruiz, Mary A (CAP, CDI)" [EMAIL PROTECTED] on 03/22/2001 04:18:30 PM To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Dan: What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean up" the database and fix the chained /migrated rows before we migrate (mainly on the big tables). We will spend a month testing on a migrated copy before migrating production. Our apps are custom Powerbuilder apps. I decided to go to 8.1.5 because our other databases are 8.1.5, and just live with the fact I cannot import a table from a multiple-table export. (that bugs me to no end) I am most interested in responses to this post. Maybe some truly compelling reasons to go to 8.1.6 , although I heard about hanging listener problems with that version which scared me. thanks in advance, Mary Ruiz / Atlanta -Original Message- Sent: Thursday, March 22, 2001 3:46 PM To: Multiple recipients of list ORACLE-L We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown, production size testing. Anybody have any information on things that go wrong with this type of migration? -- 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). -- 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).
RE: Migration from 7.3.4 to 8.1.6
Dan: What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean up" the database and fix the chained /migrated rows before we migrate (mainly on the big tables). We will spend a month testing on a migrated copy before migrating production. Our apps are custom Powerbuilder apps. I decided to go to 8.1.5 because our other databases are 8.1.5, and just live with the fact I cannot import a table from a multiple-table export. (that bugs me to no end) I am most interested in responses to this post. Maybe some truly compelling reasons to go to 8.1.6 , although I heard about hanging listener problems with that version which scared me. thanks in advance, Mary Ruiz / Atlanta -Original Message- Sent: Thursday, March 22, 2001 3:46 PM To: Multiple recipients of list ORACLE-L We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown, production size testing. Anybody have any information on things that go wrong with this type of migration? -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruiz, Mary A (CAP, CDI) 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).