Re: RE: Different Platform
FORTE compiler On Mon, 21 Jul 2003 Richard Ji wrote : So which compiler will you standarize on? GCC? On Solaris I believe the Sun C Compiler is supported but not gcc, though you can make it work. -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Richard Ji 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). ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
Different Platform
Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Different Platform
Hi! Our production environment is on Sun OS 5.8 sparc. [snip] The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? PL/SQL won't usually have any problems, at least I haven't seen any (when moving from unix to unix you won't have thes directory path problems either...). OCI library side should also be the same for all unix platforms, but your application definitely needs to be tested on Sun, there's many differences between platforms, especially when using threading and other advanced programming techniques. Tanel. Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Different Platform
So which compiler will you standarize on? GCC? On Solaris I believe the Sun C Compiler is supported but not gcc, though you can make it work. -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Richard Ji 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Hi: Thanks to everyone who responded to my message on Cross Platform Migration... I will update the list if we come to any conclusions not consilient with the findings given on the list.. Thanks Regards, Sashi Sashidhar Kondareddy Project Manager IT Solutions Inc, a SEI CMM Level 5 Company Chennai 66, India efax : +1 (360) 242-8334 -- The nice thing about standards is that you have so many to choose from. Furthermore, if you do not like any of them, you can just wait for next year's model. -- Andrew S. Tanenbaum in Computer Networks, 2nd Edition --- Original Message --- We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
You may want to review an article, Cross Platform Migration of a Large Production Database, in the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to IBM AIX. - Kirti --- Goulet, Dick [EMAIL PROTECTED] wrote: Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over
Aah !Hint, hint that some certain RDBMS vendor will offer cross-platform compatibility of database files soon. Hemant At 04:14 AM 07-06-03 -0800, you wrote: Sashidar: In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible. There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that. Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or
1. Join the 10i beta program 2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance. ;-) Or... Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in SQL*Loader native format to named pipes that were being dd'd with large block sizes across a fast network, to several SQL*Loader processes on the other side using direct/unrecoverable. We ran several of these at a time. As soon as a table would finish we would kick off the index creation in parallel/unrecoverable mode. The goal was to get both the source and target hosts as close to 100% utilization as possible. This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11 64-bit. The migration took 6 hours. It shouldn't have even taken that long, but we were clumsy in a few ways. There's a lot involved in a migration. Lots of dependencies and details to think about. I recommend repeated practice runs on test equipment before trying the real thing. There's a lot of blood to be squeezed out of this stone to get the time down and reliability up. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 9 Jun 2003, Goulet, Dick wrote: Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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: Jeremiah Wilton 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over
Direct mode doesn't work across platforms [or, at least, I haven't tried it]. It isn't supported. SQLLDR, Parallel Export-Import, Parallel Index Build are options -- these can be done in parallel. Run at least two rounds of testing to see how you can migrate the data. Hemant At 06:29 AM 09-06-03 -0800, you wrote: Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Wondering out aloud here. Could you export/imp using pipes. I remember doing this on a 200gb database going from 7.3 to 8 on Solaris, granted on the same server. Took about 4-6 hours if I remember correctly. Anyway to create a remote pipe on another server to listen for inputs from another server so that the above can be accomplisher or am I Way off the mark here. mohammed --- Goulet, Dick [EMAIL PROTECTED] wrote: Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
This is *exactly* what I would like to do on our SAP systems when we upgrade, since this is the best way to move to LMT's. Unfortunately for me and a lot of other folks, Windoze don't do that. :( You can't imagine just how much I wish we were on Solaris. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/09/2003 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or .. You may want to review an article, Cross Platform Migration of a Large Production Database, in the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to IBM AIX. - Kirti --- Goulet, Dick [EMAIL PROTECTED] wrote: Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).
HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Sashidar: In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible. There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that. Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink o
K I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any possibility the datafiles might be compatible? Sashidar This was discussed quite a bit on this list 5/14, the subject was quickest method. The consensus seemed to be that: 1. SQL*Loader in direct path mode is the fastest. The catch is the hassle of getting the data out to a flat file and creating a loader control file. 2. Database links and exp/imp are roughly the same speed, so you have to test to see which will be fastest for your situation. I plan to test these various methods in our environment, since the downtime window will be rather small. Consider using the 80/20 principle (Pareto's Rule). Typically, just a handful of tables contain most of the data. In my case, a single table contains about 25% of the data. It is worth the effort to develop a method to dump the data to a flat file and to create a loader control file if that is the fastest method. For the many small files, just use exp/imp. Please update me on any conclusions you reach since this topic is of significant interest to me. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, June 07, 2003 7:15 AM To: Multiple recipients of list ORACLE-L or .. Sashidar: In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible. There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that. Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink o
Why don't you try it? Create a small database on Alpha, rcp it to HP and see what happens. On 2003.06.07 09:39 DENNIS WILLIAMS wrote: K I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any possibility the datafiles might be compatible? Sashidar This was discussed quite a bit on this list 5/14, the subject was quickest method. The consensus seemed to be that: 1. SQL*Loader in direct path mode is the fastest. The catch is the hassle of getting the data out to a flat file and creating a loader control file. 2. Database links and exp/imp are roughly the same speed, so you have to test to see which will be fastest for your situation. I plan to test these various methods in our environment, since the downtime window will be rather small. Consider using the 80/20 principle (Pareto's Rule). Typically, just a handful of tables contain most of the data. In my case, a single table contains about 25% of the data. It is worth the effort to develop a method to dump the data to a flat file and to create a loader control file if that is the fastest method. For the many small files, just use exp/imp. Please update me on any conclusions you reach since this topic is of significant interest to me. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, June 07, 2003 7:15 AM To: Multiple recipients of list ORACLE-L or .. Sashidar: In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible. There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that. Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). -- Mladen Gogala Oracle DBA -- 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).
Cross Platform RPC
Title: RE: Weirdness Probably a bit "OT" here, butanyone have any pithy rejoinders about doing cross platform RPC...or how MS RPC is different from, say, ONC/Sun RPC? I am about to get into something where this will matter, and I am just dipping a toe in the water. thanks in advance for any thoughts, including those scurrilous off topic comments! ;-) - Ross Mohan
Re: Cross Platform RPC
I'm supporting Siebel; where the database is Oracle running on Solaris while the Siebel application server software runs on an NT box. As part of the DB shutdown script an rsh is issued to the NT box to stop the application server s/w prior to bringing down the DB. In the DB startup script the application server is started after the DB comes up. I've successfully tested starting from NT invoking a script on Solaris, but don't have anything just yet in production that uses this capability. HTH YMMV! Mohan, Ross wrote: Probably a bit OT here, butanyone have any pithy rejoinders about doing cross platform RPC...or how MS RPC is different from, say, ONC/Sun RPC? I am about to get into something where this will matter, and I am just dipping a toe in the water. thanks in advance for any thoughts, including those scurrilous off topic comments! ;-) - Ross Mohan -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 NOTHING is impossible for the person who does not have to do it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Cross(-eyed) Platform RPC
CM - I *think* this is functionally identical but linguistically different than client/server RPC calls. The rsh is supported ( i ::think::, Unix goo-roo's help me, here) by udp/ip as is rpc calling, but...is strictly remote execution without the richness the RPC connection offers. Of course, I am probably just smoking WAY to much Oracle cRAC. thanks for your thoughts...it keeps the juice going (but then again, you probably didn't need that level of detail. ) :-) - RM rm -rf /bin/laden -Original Message- Sent: Thursday, October 25, 2001 4:55 PM To: Multiple recipients of list ORACLE-L I'm supporting Siebel; where the database is Oracle running on Solaris while the Siebel application server software runs on an NT box. As part of the DB shutdown script an rsh is issued to the NT box to stop the application server s/w prior to bringing down the DB. In the DB startup script the application server is started after the DB comes up. I've successfully tested starting from NT invoking a script on Solaris, but don't have anything just yet in production that uses this capability. HTH YMMV! Mohan, Ross wrote: Probably a bit OT here, butanyone have any pithy rejoinders about doing cross platform RPC...or how MS RPC is different from, say, ONC/Sun RPC? I am about to get into something where this will matter, and I am just dipping a toe in the water. thanks in advance for any thoughts, including those scurrilous off topic comments! ;-) - Ross Mohan -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 NOTHING is impossible for the person who does not have to do it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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).
FW: Platform
If you are interested I found the answer on metalink: select dbms_utility.port_string from dual; Ivo -Original Message- Sent: Wednesday, September 26, 2001 02:09 PM To: '[EMAIL PROTECTED]' Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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: Platform
Hi, You can always check for the location of the datafiles. Their location on nt should start with {A-Z}:\ and can be evaluated through a substring command or something Jack Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 26-09-2001 15:10:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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: Platform
How about trying one, build an exception, and on exception try the other ? HTH, Remco -Oorspronkelijk bericht- Van: Libal, Ivo [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 26 september 2001 15:10 Aan: Multiple recipients of list ORACLE-L Onderwerp: Platform Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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: Daemen, Remco 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: Platform
I presume you mean utl_file, not dbms_file. Doesn't this need the utl_file parameter set up with the available directories - could you just check to see if this parameter includes c:\log or /log - Bill. At 05:10 26/09/01 -0800, you wrote: Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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). -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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: Platform
Title: RE: Platform I've also used this query: select substr (banner, 9, instr (banner, ':') - 9) as os from v$version where banner like 'TNS for %' ; Because port_string is sometimes cryptic. For example, on my 7.3.4 database on Sun Solaris, here's what I get: SQL select dbms_utility.port_string from dual ; PORT_STRING SVR4-be-7.0.0 -Original Message- From: Libal, Ivo [mailto:[EMAIL PROTECTED]] If you are interested I found the answer on metalink: select dbms_utility.port_string from dual; -Original Message- Sent: Wednesday, September 26, 2001 02:09 PM how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS?
Platform dependency on released connections (WAS) Re: user holding session even after a re-boot
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: Guess the bottom line is the behavior of a released connection is platform dependent. What do you guys think? I would hope this isn't the case. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer 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).
Set-up layout config to impl PeopleSoft on Oracle HP platform
Guru List, Does anyone have any documentation or recommendations for setting up Oracle to run the PeopleSoft application on HP9000 64 bit, such as layout of files, init parms, initial and next extents, tuning parameters etc? Any help is appreciated! Willie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Townsend Willie 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).
Set-up layout config to impl PeopleSoft on Oracle HP platform
Guru List, Does anyone have any documentation or recommendations for setting up Oracle to run the PeopleSoft application on HP9000 64 bit, such as layout of files, init parms, initial and next extents, tuning parameters etc? Any help is appreciated! Willie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Townsend Willie 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).
Multi-platform Editors - Was: Unix
Hi Roland, (DISCLAIMER - I have no interest in Pacemaker software, other than that Paul has a good product) I use an editor called CRiSP extensively - it is a GUI-based version of a character based editor called Brief (from Underware), that got bought by Borland (remember them ...). It runs under Windows, Unix, Linux It has lots and lots of features (including the ability to FTP a file from a UNIX server, allow you to edit it locally, and then FTP it back, if you really want to). But you could also edit the file directly on the server if you wanted to. It is also the only editor that I know that will allow you to highlight a COLUMN, and then do regular expression changes on the column. Unlimited Undo's, file compares, extensible etc. etc. Colouration of reserved words (including SQL) - very configurable -. Pricing is extremely good as well (GBP 150.00 for Win/Nt), and he is constantly working to improve it. You can also buy locked or Floating licenses. Works well with your favourite complier to become an IDE (allows you to compile from within the editor, picks up the output and displays the errors and highlights the offending lines) Go to www.pacemaker.co.uk and have a look - you can also download an evaluation copy there. Regards Oweson Flynn -- Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: 14 May 2001 16:01 To: Multiple recipients of list ORACLE-L How can I modify a Unix file in an other editor not using vi, for instance I would like to use a Windows based editor? Roland Sköldblom -- 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). *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn 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).
Moving database to another platform with GL app 10.7 Character mode
Hi List, Currently, we are running Oracle Application 10.7 ( GL and AP modules, character mode) + Oracle Database .. all of them on one AIX box, so now we have plan to move Oracle database to SUN Solaris, and still kept Oracle application on old machine. I wonder about the Oracle Application library (FND) on AIX can connect to new database ? Please give me your advice about this situation and email to [EMAIL PROTECTED] Thanks so much. Jenn __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bao Jenny 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).