Re: Oracle's jdbc driver
The method you need is: OracleDatabaseMetaData.getDriverVersion() Write a small Java program to call this method, or take a look at Metalink note 94091.1 or 73629.1 for sample code to get JDBC driver version. Regards, Dave [EMAIL PROTECTED] wrote: Hi All How can I findout what is the version of the jdbc driver installed with oracle client install. Thanks and Regards B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Hau 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).
Code Conversion from MSSQL into Oracle
Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle? SAMPLE :- DECLARE @entity_id char(32), @branch_id char(9) DECLARE cur_temp_GEMT CURSOR FOR select branch_id,entity_id from GEMT where other_party_name='' and entity_type='D' OPEN cur_temp_GEMT FETCH NEXT FROM cur_temp_GEMT INTO @branch_id,@entity_id WHILE @@FETCH_STATUS = 0 BEGIN UPDATE GEMT SET other_party_name=(SELECT name from GEAT where branch_id [EMAIL PROTECTED] and [EMAIL PROTECTED] and addr_type='1' and entity_type='D') where [EMAIL PROTECTED] and branch_id = @branch_id FETCH NEXT FROM cur_temp_GEMT INTO @branch_id, @entity_id END CLOSE cur_temp_GEMT DEALLOCATE cur_temp_GEMT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: automate backup and export
Any reference concerning the rman? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:19 PM Yes. It's called RMAN. On 12/12/2003 02:04:46 PM, John wrote: Do you know any script for doing export and backup of Oracle 9i R2 server? My oracle is on a SuSE linux. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John 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: 170systems
If the zip file is less than 1MB, can you also send me one copy. I heard it on the radio, but do not know how it works. Thanks Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 13, 2003 00:24 Hi Allan , Thanks for your quick reply. I tried mailing you but it rebounced saying unknow host . Please reply me at [EMAIL PROTECTED] . Also you can send me the docs on the same email id . Please zip and send so that none of the files get deleted because of firewall. Once again Thanks For the quick reply. Waiting for the docs. Thanks Regards Kirtish P Gaonkar -Original Message- Sent: Saturday, December 13, 2003 11:01 AM To: [EMAIL PROTECTED] Hi Allan , Thanks for your quick reply. Please do send the 170systems docs at this mail id . Also please zip and send the files so that it doesn't get deleted because of firewall. Once again thanks for your quick reply. Waiting for the docs.. Thanks Regards Kirtish P Gaonkar -Original Message- Nelson, Allan Sent: Friday, December 12, 2003 10:00 PM To: Multiple recipients of list ORACLE-L We are running 170 Systems. Unfortunately over dblinks to a database hosted by our parent corporation. It is abysmally slow. I'll try and find some docs for you. Please reply to me off list with an email address capable of accepting mulit-megabyte pdf's at [EMAIL PROTECTED] Allan -Original Message- Kirtish P Gaonkar Sent: Friday, December 12, 2003 1:29 AM To: Multiple recipients of list ORACLE-L hi , Is Any body using 170systems ? Can you please send me the documents or any info you have. Also we are planning to interface 170systems to Oracle Financials . If anybody has already done this please can you send me the docs. Waiting for replies.. Regards Kirtish P. Gaonkar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtish P Gaonkar 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Kirtish P Gaonkar 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: Eric King 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).
Re: 170systems
hi , CAN YOU PLEASE SEND ME ONE COPY AS WELL. Reg, Ravi --- Eric King [EMAIL PROTECTED] wrote: If the zip file is less than 1MB, can you also send me one copy. I heard it on the radio, but do not know how it works. Thanks Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 13, 2003 00:24 Hi Allan , Thanks for your quick reply. I tried mailing you but it rebounced saying unknow host . Please reply me at [EMAIL PROTECTED] . Also you can send me the docs on the same email id . Please zip and send so that none of the files get deleted because of firewall. Once again Thanks For the quick reply. Waiting for the docs. Thanks Regards Kirtish P Gaonkar -Original Message- Sent: Saturday, December 13, 2003 11:01 AM To: [EMAIL PROTECTED] Hi Allan , Thanks for your quick reply. Please do send the 170systems docs at this mail id . Also please zip and send the files so that it doesn't get deleted because of firewall. Once again thanks for your quick reply. Waiting for the docs.. Thanks Regards Kirtish P Gaonkar -Original Message- Nelson, Allan Sent: Friday, December 12, 2003 10:00 PM To: Multiple recipients of list ORACLE-L We are running 170 Systems. Unfortunately over dblinks to a database hosted by our parent corporation. It is abysmally slow. I'll try and find some docs for you. Please reply to me off list with an email address capable of accepting mulit-megabyte pdf's at [EMAIL PROTECTED] Allan -Original Message- Kirtish P Gaonkar Sent: Friday, December 12, 2003 1:29 AM To: Multiple recipients of list ORACLE-L hi , Is Any body using 170systems ? Can you please send me the documents or any info you have. Also we are planning to interface 170systems to Oracle Financials . If anybody has already done this please can you send me the docs. Waiting for replies.. Regards Kirtish P. Gaonkar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtish P Gaonkar 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Kirtish P Gaonkar 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: Eric King INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: 24 x 7 x 365
Tanel, I think this is a good solution, provided the application can handle two phased commit protocol across both the databases, else there could be orphan records on one or both these databases. Murali Tanel Poder [EMAIL PROTECTED] wrote: When you want true 24x7 without compromises, then you have to step closer tothe client anyway.This means, you have two databases for example and your app servermultiplexes all transactions to both ones.This should be faster than sync standby or sync replication, because appserver can send requests to both databases in parallel, unlike withstandby/replication where database itself resends the requests to otherdatabases, making the "chain" of changes longer.Tanel.- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Wednesday, December 10, 2003 11:24 PM Hi, Unfortunately I'm gonig to add the negative view, like several others have... True 24x7x365 (good pick-up Pete on the 7 year thing) will! be limited by much more than database and operating system availability. We just did a major software upgrade last weekend and part of the upgrade involved the conversion of 250+ million records in the database - that takes time no matter what. Yes, with unlimited budget and time constraints we could get the outage down to nothing but at the end of the day it's easier for the business to manage an outage. Our system was offline for a total of about 10 hours yet traffic drives on our tollroad all the time so: The roadside is designed to backlog transactions for several days, our system has capacity to catch upbacklogs fairly fast (within a day we had caught up again), we have an alternative front-end system that can backlog feeds, and finally we designed our conversion process to do as much as possible before the outage. We are also on 8.1.7 enterprise and! don't use OPS/RAC - instead we havethe alternative processes in place to ensure the business can function. Perhaps your company can consider a similar alternative? As others have said - it can be VERY difficult to remove every possible outage and it can be much easier to manage a small outage every few months. Regards, Mark. "Tracy Rahmlow" <[EMAIL PROTECTED] Multiplerecipients of list ORACLE-L <[EMAIL PROTECTED]> xp.com cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED] .com 11/12/2003 03:44 Please respond to ORACLE-L Hello, Our company would like to know whether or not Oracle supports true24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM --** "This message and any attachments are solely for the intended recipientand may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you! have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."**== Privileged/Confidential information may be contained in this message. If you are not the address! ee indicated in this message (or responsible fordelivery of the message to such person), you may not copy or deliver thismessage to anyone. In such a case, you should destroy this message and kindly notify thesender by reply e-mail or by telephone on (03) 9612-6999 or (61) 39612-6999. Please advise immediately if you or your employer does not consent toInternet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do notrelate to the official business of Transurban Infrastructure DevelopmentsLimited and CityLink Melbourne Limited shall be understood as neither givennor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard 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
Re: 24 x 7 x 365
If this is the customer you are talking about, this database supports over 12 million subscribers.. Murali Tim Gorman [EMAIL PROTECTED] wrote: As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL PROTECTED] wrote: True 24x365 is just about impossible. No if, ands. or buts about it. Why is because of the number of factors outside your control that affect system availability. Sure your web sever and database are up 24x365, but your ISP has 1 hour down time each month for maintenance. OOPS!! from a customer point of view your NOT 24x365. Also that fiber optic cable running out of your building to the phone pole is available for some heavy equipment operator to slice through while working on the sewer system, OOPS!! So you can't have 24x365 no matter what. What you should do is try to adapt the changes you need into the downtime that's imposed on you. That's what we do it works very nicely.Besides being completely redundant is extremely expensive, like two of everything, including building, air-conditioning, fiber ! optic cables, etc.Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: 24 x 7 x 365Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the followingannotations on 12/10/2003 09:41:15 AM--**"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."**== Murali Vallath Author: Oracle Real Application Clusters Publisher Digital Press http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2V5D30UGVSisbn=182885itm=4#PU Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: 24 x 7 x 365
i was just in the bookstore. are you the one who wrote the new RAC book? you do realize the whole thing word for word is in a .pdf on otn? - Original Message - From: Murali Vallath To: Multiple recipients of list ORACLE-L Sent: Saturday, December 13, 2003 10:09 AM Subject: Re: 24 x 7 x 365 If this is the customer you are talking about, this database supports over 12 million subscribers.. Murali Tim Gorman [EMAIL PROTECTED] wrote: As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL PROTECTED] wrote: True 24x365 is just about impossible. No if, ands. or buts about it. Why is because of the number of factors outside your control that affect system availability. Sure your web sever and database are up 24x365, but your ISP has 1 hour down time each month for maintenance. OOPS!! from a customer point of view your NOT 24x365. Also that fiber optic cable running out of your building to the phone pole is available for some heavy equipment operator to slice through while working on the sewer system, OOPS!! So you can't have 24x365 no matter what. What you should do is try to adapt the changes you need into the downtime that's imposed on you. That's what we do it works very nicely.Besides being completely redundant is extremely expensive, like two of everything, including building, air-conditioning, fiber ! optic cables, etc.Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: 24 x 7 x 365Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the followingannotations on 12/10/2003 09:41:15 AM--**"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."**== Murali Vallath Author: Oracle Real Application Clusters Publisher Digital Press http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2V5D30UGVSisbn=182885itm=4#PU Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
Re: automate backup and export
John, Oracle publishes reference material available on OTN. You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles. for example: Configuring Oracle Recovery Manager http://otn.oracle.com/oramag/oracle/02-nov/o62support.html or the RMAN Reference Manual: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/toc.htm There exist a multitude of Oracle User Groups, where people (users) publish papers and present material. Check out http://www.ooug.org- click on "Presentations" - Joe Testa presented on RMAN Concepts in the April 2003 meeting. that's a start. Others have recommended Robert Freeman's Oracle 9i Backup and Recovery book under Oracle Press. I have a copy, but haven't read it enough to recommend it. If you have installed Oracle Enterprise Manager with a repository, you can use RMAN transparently via OEM. PdJohn [EMAIL PROTECTED] wrote: Any reference concerning the rman?- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Friday, December 12, 2003 10:19 PM Yes. It's called "RMAN". On 12/12/2003 02:04:46 PM, John wrote: Do you know any script for doing export and backup of Oracle 9i R2server? My oracle is on a SuSE linux. 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 fr! om 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: JohnINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for o! ther information (like subscribing). Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: automate backup and export
In addition to that, you don't need any expensive software. The original poster said that his platform is SuSE. Well, I'm on RH-9, which is almost the same. Almost. When I want to back up a database, I write 700M backup pieces to the filesystem that I have for this purpose and use xdroast to write it down to CDs. In connection to this, I have a question: is anybody using DVD writer on Linux? DVD writers themselves have several standards and I'm not sure which one should I buy. I'm starting to pay atention but I'm not quite sure what would be the right choice. On 2003.12.13 12:49, Paul Drake wrote: John, Oracle publishes reference material available on OTN. You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles. for example: Configuring Oracle Recovery Manager http://otn.oracle.com/oramag/oracle/02-nov/o62support.html or the RMAN Reference Manual: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/toc.htm There exist a multitude of Oracle User Groups, where people (users) publish papers and present material. Check out http://www.ooug.org - click on Presentations - Joe Testa presented on RMAN Concepts in the April 2003 meeting. that's a start. Others have recommended Robert Freeman's Oracle 9i Backup and Recovery book under Oracle Press. I have a copy, but haven't read it enough to recommend it. If you have installed Oracle Enterprise Manager with a repository, you can use RMAN transparently via OEM. Pd John [EMAIL PROTECTED] wrote: Any reference concerning the rman? - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, December 12, 2003 10:19 PM Yes. It's called RMAN. On 12/12/2003 02:04:46 PM, John wrote: Do you know any script for doing export and backup of Oracle 9i R2 server? My oracle is on a SuSE linux. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John 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!? New Yahoo! Photos - easier uploading and sharing -- 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).
Re: Re: 24 x 7 x 365
Yep, I also think so. I'm currently developing a small prototype for this kind of transparent proxy, which I'll post here when it's stable... Tanel. Tanel, I think this is a good solution, provided the application can handle two phased commit protocol across both the databases, else there could be orphan records on one or both these databases. Murali Tanel Poder [EMAIL PROTECTED] wrote: When you want true 24x7 without compromises, then you have to step closer tothe client anyway.This means, you have two databases for example and your app servermultiplexes all transactions to both ones.This should be faster than sync standby or sync replication, because appserver can send requests to both databases in parallel, unlike withstandby/replication where database itself resends the requests to otherdatabases, making the chain of changes longer.Tanel.- Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 11:24 PM Hi, Unfortunately I'm gonig to add the negative view, like several others have... True 24x7x365 (good pick-up Pete on the 7 year thing) will! be limited by much more than database and operating system availability. We just did a major software upgrade last weekend and part of the upgrade involved the conversion of 250+ million records in the database - that takes time no matter what. Yes, with unlimited budget and time constraints we could get the outage down to nothing but at the end of the day it's easier for the business to manage an outage. Our system was offline for a total of about 10 hours yet traffic drives on our tollroad all the time so: The roadside is designed to backlog transactions for several days, our system has capacity to catch upbacklogs fairly fast (within a day we had caught up again), we have an alternative front-end system that can backlog feeds, and finally we designed our conversion process to do as much as possible before the outage. We are also on 8.1.7 enterprise and! don't use OPS/RAC - instead we havethe alternative processes in place to ensure the business can function. Perhaps your company can consider a similar alternative? As others have said - it can be VERY difficult to remove every possible outage and it can be much easier to manage a small outage every few months. Regards, Mark. Tracy Rahmlow !
How to Install Oracle Management Server
How to configure oracle management server. I want to explore OEM fully. I cann't find any installation guide for this in otn. Is OMS is must for dataguard, RAC?. Nirmal. = fsdfsdfsdfsdfs __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M 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: How to Install Oracle Management Server
Hi Nirmal, Please take a look at the following two links which are pointers to the OEM documentation. Oracle Enterprise Manager Configuration Guide http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96673/toc.htm Oracle Enterprise Manager Administrator's Guide http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96670/toc.htm If you are planning to use the DataGuard Manager (GUI) to create/setup Standby databases and to administer primary/standby databases, then OMS is required. Without OMS, you have to create the standby database manually. Not sure about RAC... HTH Chandra -Original Message- Nirmal Kumar M Sent: Saturday, December 13, 2003 4:24 PM To: Multiple recipients of list ORACLE-L How to configure oracle management server. I want to explore OEM fully. I cann't find any installation guide for this in otn. Is OMS is must for dataguard, RAC?. Nirmal. = fsdfsdfsdfsdfs __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M 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: Chandra Pabba 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: How to Install Oracle Management Server
what is ur OS? If it is windows select Enterprise Manager Configuration Assitant which is under Configuration Tools. This will install configure OEM repository for you. -Original Message- Nirmal Kumar M Sent: Saturday, December 13, 2003 5:24 PM To: Multiple recipients of list ORACLE-L How to configure oracle management server. I want to explore OEM fully. I cann't find any installation guide for this in otn. Is OMS is must for dataguard, RAC?. Nirmal. = fsdfsdfsdfsdfs __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M 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: Sami 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: Who are certified Oracle Masters?
This is a family oriented mailing list folks. :) Jared On Fri, 2003-12-12 at 15:19, Richard Foote wrote: Hi Jeremiah, I find the mental image of the six of you holding up your shafts for a publicity shot profoundly disturbing... Cheers ;o) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 5:19 PM Apology accepted. We had to do a lot of hard work to get those superman-style crystal shafts. Among the things we had to do the get the shaft: - Stand on a piece of masking tape on the stage - Not make fun of the OCM program while we were getting the award - Not make fun of any of the other honorary OCM recipients during the presentation - Act imporant and smarter than everyone else - Hold up our shafts for a publicity photo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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: Jared Still 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: automate backup and export
John What is your intention? If you have created a test Oracle database on your Linux system just to learn, then just shut the database down and back up all files. If you have some important data in this database that changes frequently, then you need to learn about Oracle backup recovery. More than a simple script, you need to understand your backup and recovery requirements as well as your scripts so you can ensure the requirements are being met. And you need to test your backup because a crash is no time to find out your method was flawed. All of this is much broader than we can cover in a few short emails or even a web site. Oracle Education teaches a nice week-long course on this. I found the book Oracle Backup Recovery 101 by Smith and Haisley to be an excellent tutorial for the various types of Oracle backup methods. They take you step-by-step through tutorials on the different methods. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, December 13, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Any reference concerning the rman? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:19 PM Yes. It's called RMAN. On 12/12/2003 02:04:46 PM, John wrote: Do you know any script for doing export and backup of Oracle 9i R2 server? My oracle is on a SuSE linux. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John 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).
Changing Character Set from WE8ISO8859P1 to UTF8
I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET command? If so, was there any problems? Thanks, Sandra Arnold Principal DBA NCI Information Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnold, Sandra 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: Changing Character Set from WE8ISO8859P1 to UTF8
I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed character set using alter database character set. It will work without any problem. Go for it. -Original Message- Sent: Saturday, December 13, 2003 9:39 PM To: Multiple recipients of list ORACLE-L I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET command? If so, was there any problems? Thanks, Sandra Arnold Principal DBA NCI Information Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnold, Sandra 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: Pandian, Thiru 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: Performance tuning in complex environment
Avnish, The book goes through this a bit on p61. There are a few tools out there, including three from Oracle. As I mention in the book, I use our own Hotsos Profiler, described at www.hotsos.com/products/profiler.html. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I will try to get the output of v$system_event and will send it you guys. In the mean time I have more question.. I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over looked rest of the chapters but didnt find an easy way to analyze thousands of lines trace file. I am not very good in analyzing big trace files and wondering how you guys analyze do that. Do you do it manually or use any tool to get summarized report. I didnt see anything in that book. I am also planning to take class from HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of your input. Thanks -Original Message- Jared Still Sent: Thursday, December 11, 2003 10:04 PM To: Multiple recipients of list ORACLE-L The wholesale system wide collection of timing data is not generally a good way to go about trouble shooting performance issues. You need to pick a process, collect the timing data for that process, and *only* that process, diagnose where the most time is being spent, and determine what can be done to speed it up. This in a nutshell is the basis of Cary's book, at least per my reading of it. Always try to fix the stuff with the biggest payoff. It could be a SQL statement, it could be a misconfigured or malfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction, then deleting the data and doing it over and over again, all the while doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it. Just for grins though, how about running this script and posting the output for us? Sometimes you get lucky, and something may appear really out of whack. No guarantees though. Troubleshooting system performance problems takes more than an email. HTH Jared = col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head TOTAL|WAITS col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS col time_waited format 999,999,999 head TIME|WAITED|SECONDS col average_wait format 9 head AVG|WAIT|100ths set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. 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
RE: rebuilding indexes - sure to cause a ruckus
not to mention running 48 batch jobs on a 8CPU box with all of them committing after every record and using the table to generate keys (Cary would love this one) ;) They wanted to find other reasons and he conveniently ignored the real problem. Beautiful... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Denny Koovakattu Sent: Friday, December 12, 2003 3:20 PM To: Multiple recipients of list ORACLE-L If it's from Oracle, I would believe it, i.e., I would believe somebody did actually say that ;) But it does not make it right. Now only if management knew/believed that. Some more from Oracle, - Oracle writes to one log member and then the other. So you need both log members for recovery. Volunteered to help us use _allow_resetlogs_corruption when we had one intact log member. (Took a lot of effort not to tell him to read the concepts manual. Was from a Sev1 problem that happened a few years ago.) - Increasing hit ratio, OS swap size to 3 times the OS memory and improving data proximity in an index (never really understood this one) among other bizarre ones to improve performance. This from an Oracle consultant who was called onsite by Development Management because we claimed the real reason was because the application was committing after every record to avoid locking issues on a table generating sequences, not to mention running 48 batch jobs on a 8CPU box with all of them committing after every record and using the table to generate keys (Cary would love this one) ;) They wanted to find other reasons and he conveniently ignored the real problem. BTW, I personally don't like having a zillion extents for an object (more so when you have multiple DBA Replacement Tools querying dba_extents constantly and showing flashing red lights) and would expect the development team NOT to give me a deer in the headlights look when asked for table sizing info. Response most often heard is Why do you need that. Oracle will be able to take care of it or can't Oracle take care of it or some variation thereof What I really want to say is if you don't have any idea about your data, then please don't write any SQL. That should take care of most performance issues. Barbara Baker wrote: You probably think you're joking. Unfortunately . . . We've been fighting with Oracle for several months about SEVERE performance degradation on an OpenVMS application after we upgraded the database to 8.1.7.4 One of Oracle's recommendations taken directly from our TAR just 2 weeks ago: o Ensure tables and indexes have as few extents as possible. sigh... Barb --- Bobak, Mark [EMAIL PROTECTED] wrote: I think this subject has been done to death. We should talk about less contentious issues such as: - The buffer cache hit ratio, your friend in expert Oracle tuning! - Rebuild your tables regularly to reduce the number of extents and improve performance! - Disk access is at least 10,000x slower than memory, to tune your database, eliminate physical I/O! Anyone else got and good ones? ;-) -Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu 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: Cary Millsap 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).
