Re: Cache Management on Storage Box
I assume that write behind means that when the write I/O request gets to the controller cache the controller returns ok to the computer and then write the data to the disk in its own time, like DASD fast write on the mainframe. If this assumption is wrong don't read any more. I think that it all depends on battery backed for the memory on the controller. If the controller cache memory have a battery backup you will get faster response time with write behind and the battery assure you that in case of power failure you will not lose data. If you do not have battery backup DO NOT use write behind as you will lose the data in case of power failure. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 23, 2002 6:53 PM Cache Management on Storage Box :- Qs Which is Better ? Write-Behind OR AUTO Advantages of Each ? Any Docs , Links on the Same ? NOTE - Application is a Banking Product - Hybrid in Nature i.e. both OLTP Batch Processing Operations Exist Qs When Configured to AUTO is there an Overhead Within when Switching between Write-Behind Write-Through Modes ? NOTE - Database in particular Exists on T3 Model SUN Storage Box . T3 Supports Hardware RAID In-built Write-Behind Cache Management Solaris 8 Oracle 8.1.7 Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MIcrosoft Blackmail
Title: OT: MIcrosoft Blackmail What exactly is your problem? Lets say that you are a factory that sells paper. You need to buy a computer system. One supplier also sell printers and the other advocate paperless office. All things being equal, which one will you give your business to?? Yechiel AdarMehish - Original Message - From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Thursday, September 26, 2002 1:13 AM Subject: OT: MIcrosoft Blackmail This came to our DBA team today. I'd appreciate your thoughts. I'm not a business guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice by MS? It is important from an Architecture point of view that we understand all the various approaches to "web services" (also known as "grid computing" -- see my recent report). Microsoft's dot Net initiative is their approach to this grand overarching software strategy. There is a second reason why we might be interested specifically in dot Net. Subsidiary XYZ earns $xyz a year for us from Microsoft by [performing certain services], etc. Microsoft has told our management that one of their criteria for evaluating their vendors will be how good of a MS customer is the potential vendor. Specifically, has the vendor bought in to the dot Net strategy. Now we aren't going to make our global enterprise solutions strategy decisions based upon that point alone, but it's not something we are going to ignore either. Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING.
Re: DBA place in the business (was RE: DBA work load)
Hello Peter We have an infrastructure division that divides into two departments: system programming and DBA. Organization chart for us will be: CEO - CIO - Infrastructure - DBA. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 11:13 AM I've found the thread on DBA workload valuable and interesting. It endorses points made repeatedly over the past years, basically the highly variable nature of the job. This variability is giving us a small problem. Our dba work (shared between two of us) tends to function in the background, and of course because we do it so damn well (!!), our impact on the running of the organisation is pretty low. Kind of 'reverse exception' effect, if you will. There is now a desire to formalise the role of the dba function within the organisation, and nobody has the first idea of how to define, in an organisational / structural sense just how the dba role slots in. I'm talking about organsiational charts, herarchies etc, that sort of thing. Not just across the org, but particularly within the IT domain too. Specifically, dba impacts from the low-level hardware side, right up to application development, with everything in between. And that already spans several existing lines of management responsibility. Our problem has added spice as we are (trying) to operate a matrix management system, which repeatedly throws up intriguing political dimensions. Anybody ever been down this particular route? Any thoughts much appreciated, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MIcrosoft Blackmail
DENNIS, I think that I did not explain my idea. I do not understand the complain of Thomas. I do not see any harm in a company choosing its dealers based on their commitment to the goals of my company. Microsoft has a right to prefer dealer who embrace the .net, or do you think that anybody have the right to tell a PRIVATE company who to deal with? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 5:18 PM Yechiel - But all things are NEVER equal. So companies end up doing stupid things because of some larger motive. You end up buying crappy computers because your boss thinks it will impress the CEO with how you are loyally supporting someone that somehow supports your company. Ironic isn't it. When the PC industry began, the computer industry was firmly dominated by IBM. PC enthusiasts were a bunch of starry-eyed dreamers that though they could wrestle computing away from the computer priesthood and bring freedom to everyman. In many ways the Internet has made that dream come true. But then we have Microsoft talking about creating a new security system for my computer that on one hand will protect me from bad things and on the other hand will protect the products of large corporations from me. In a great number of ways Microsoft resembles the IBM of the past. obligatory Oracle reference Of course Larry Ellison only wishes he had these type of issues to deal with. /obligatory Oracle reference Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 26, 2002 8:43 AM To: Multiple recipients of list ORACLE-L What exactly is your problem? Lets say that you are a factory that sells paper. You need to buy a computer system. One supplier also sell printers and the other advocate paperless office. All things being equal, which one will you give your business to?? Yechiel Adar Mehish - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, September 26, 2002 1:13 AM This came to our DBA team today.I'd appreciate your thoughts. I'm not a business guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice by MS? It is important from an Architecture point of view that we understand all the various approaches to web services (also known as grid computing -- see my recent report). Microsoft's dot Net initiative is their approach to this grand overarching software strategy. There is a second reason why we might be interested specifically in dot Net. Subsidiary XYZ earns $xyz a year for us from Microsoft by [performing certain services], etc. Microsoft has told our management that one of their criteria for evaluating their vendors will be how good of a MS customer is the potential vendor. Specifically, has the vendor bought in to the dot Net strategy. Now we aren't going to make our global enterprise solutions strategy decisions based upon that point alone, but it's not something we are going to ignore either. Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
I think that this require a deeper investigation. Last night I tried to use alter system sql_trace=true and it did not work either. I had to put sql_trace=true in init.ora and to bounce the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 8:18 PM All Im trying to run the following statement EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE) And get the following error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Looking under SYS schema I have package and package body for DBMS_SYSTEM and the body includes SET_SQL_TRACE_IN_SESSION I had to turn on tracing on the database level... What could be the matter with this?? Many Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BACKUP database question
Add a local disk to one of the machines and put your Rman catalog there. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 8:31 PM List, With all of the recent discussion and the forth coming books and the upgrade here to 8i I have a question. Where do you build your RMAN repository database? If you build it in the same server as the one you are backing up then you risk the loss of everything in the event of a disk farm failure. If you created a separate server to hold the RMAN repository does it require a separate license for the oracle running on the server? We have a clustered environment with a disk farm and 2 Alpha boxes. One box will be Production and the other will be Development and they share the disk farm. If I use RMAN to backup the production box and keep it in the development database I still have all of my eggs in one disk farm. If I create a separate server on a Linux pc I need a license for the Oracle database on the pc. What methods have you used at your work location and I do not care about your licensing agreements. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Restrict certain database access using 3rd party tools.
Just deny login if your trigger does not know the program. Check the archives for example scripts for login triggers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 8:08 PM Oups ! you're right. --- Kevin Lange [EMAIL PROTECTED] a écrit : Except for the fact that they could always change the program name that they are running to match what you need. Then that security is bypassed. -Original Message- Sent: Thursday, October 03, 2002 11:08 AM To: Multiple recipients of list ORACLE-L In homemade applications, by default users have a role with read only, in the applications we change the default role that allows insert, update, delete. I've not tested this scenario but how about if, in a database logon trigger, you check the v$process.program field then depending of that value you may be able to change the user default's role. Should work on 8i using dedicated connection. --- [EMAIL PROTECTED] a écrit : Hi All, We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have sqlplus,toad,etc. I know you can set up security for sqlplus,etc using product_user_profile but is there a way to allow only SELECT when using a 3rd party tool such as TOAD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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.com -- Author: Kevin Lange 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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.com
Re: Reports
Maybe he got the wrong name. Can you connect via SQLPLUS from his machine? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:33 PM I don't work with Oracle Reports but one of my co-workers does. His problem --- TNS can't find the database. He has three Oracle homes. I've copied the good tnsnames.ora to all of his homes (I know about the NETWORK and NET80 directories). It's Report 6i on a Win2K machine trying to connect to an 8.1.6 Oracle. He has Reports 6i installed on two of his Oracle homes and Reports 6.0 on the other. Don't ask me why --- I don't know. I used the Oracle home changer and cycled through all 3 homes. The error is ORA-12154: TNS could not resolve service name. Is there anything special about having multiple copies of Reports on Win2K? Thanks (IA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needsrecovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??? HELP Yechiel AdarMehish
Re: sequence numbers
I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performancehit if I take out the cache 20? April Wells Oracle DBAThere is neither good nor bad, but thinking makes it so. -Shakespeare
Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Thanks for all the replies. We called Oracle support and they come with the DUL utility and extracted the data. As Iwrite this e-mail imports are running. Concurrently wetried to restore the last full backup from more then 2 weeks ago\ and found about 1 day worth of archive logs missing, so this option is out. We now also restoring last night export to a separate database so in case of logical errors in the imported data they will be able to input the deals again and bring the system up to date. So now, eleven hours later we hope to finish in a few hours. Yechiel AdarMehish
If stupidity got you at the age of 7 it will stay with you until you die
The header is from a show done in Israel and is one of the pearls of wisdom from Jerusalem. The guy who is responsible for the fucked up system that went down last weekend decided to move the system to the backup server and run it from there until they fixed up the original server. He did it by doing an export/import to the new server and then renaming the servers. I talked with him and told him: Switch also the IP address for the servers. He: NO need. the tnsnames and everything go by server name. I: OK. One hour later: HELP (and he IS an idiot) - we brought up the system and it seems not right. We brought down the database that the application is not supposed to work with and the application bomb. A little test and: SUPRIZE - they got IP addresses in the hosts file in windows and the application worked against the old database. Now he is changing also the IP address and doing build database and import again 2-3 hours more. So I am stuck here at least until 22:00 to 23:00. RR Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: CodeNotes for Oracle9i...
The studies I remember on the subject say that talking while driving put you in the same risk factor as drunk driving . Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 12:03 PM There's always some idiot who wants to rain on the parade, so it may as well be me. I can't remember the specifics but a recent test in London showed that people on (hands-free) phones in their cars were 'x'% more likely to crash ('x' was somewhere like 50%!), the test being designed to show that its not the phone in your hand, its the fact that you're talking/listening that ends up killing you... I can't begin to imagine the traffic carnage when the CD DBA101: The sensual sultry sounds of Carmichael hits the charts! Does Rachel really want that kind of responsbility :-) Cheers Connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: It's a little difficult to see how code samples and illustrations (which I find invaluable) could be translated to audio It's technically copyright infringement (I believe) to translate the books. I don't own the copyright, so I'm not about to call out the lawyers. I am supposed to contact my publisher for permission (never been refused, as it's publicity) when I want to use part of a chapter for an article or presentation. Besides, I have problems concentrating when I listen to books on tape, so I'm not the best person to advocate this! --- Joe Testa [EMAIL PROTECTED] wrote: I would think the authors should read and publish the books in .mp3 format, you can get like 10 hours worth on one cd. Rachel how about you start, bwahahahahahahaha joe DENNIS WILLIAMS wrote: I have an odd question about these on-line books. Can I copy-and-paste the text? Like many of you, I seem to end up with long commutes (why are the best jobs never in your neighborhood?). I find listening to books on CD to be a better use of time than reading bumper stickers. Nobody ever seems to issue Oracle books on audio. So I got a text-to-voice program, and it works pretty good to create an audio version of a book. But many of these eBooks zealously protect their text and prevent you from doing copy-and-paste on the text. Fortunately Oracle makes their books readily available. Any ideas are welcome. And my apologies to the authors on the list that are going he wants to do WHAT with my book!!. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 10, 2002 7:54 PM To: Multiple recipients of list ORACLE-L I believe the Book Safari is changing. It is supposed to be more flexible now. http://www.oreilly.com/news/new_safari_0902.html Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/08/2002 01:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:CodeNotes for Oracle9i... So every few months my Lookout reminder pops up to remind me to check out what new Oracle books have been released. I stumbled upon a new book called CodeNotes for Oracle9i on Amazon.com, but the interesting part is that it is available in eBook format. Here's the (probably broken) link... http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr= 1 -25/ref=sr_1_25/104-5919725-7522346?v=glance The eBook version is $9.95 and the shipping is free (big grin), while the paperback is $13.97 plus shipping. Are you comfortable reading an eBook? You decide. At any rate, I will probably break down and buy the eBook. Not so much because the book is great (or not) but because I hope to send a message to publishers to publish more books in the eBook format, which is also why I posted this message. I know that O'Reilly has the Safari Bookshelf website, but I found it to be restrictive and pricey. BTW, if for some reason you are or will be using .Net, the CodeNotes eBook version is free... http://www.codenotes.com/do/downloads/downloadsNETbook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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
Re: DW setup
Forgive me for asking, but if you have enough CPU for all why do you need control? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 12:03 AM Thats what we are planning on doing here with our data warehouse. Unfortunately, your CPU's have to be at 100% for resource manager to become effective. I'd like to be able to have a bit more control over sessions than that. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, October 14, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Rich - Good point! I haven't used Oracle Resource Manager, but in theory it should be able to do a better job of implementing priorities than the operating system can. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 14, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Why seperate instances? Why not seperate schemas in the same instance? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hello, BACKGROUND: We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on Solaris, and have proposed the following: 1) 2 separate instances of Oracle 9.2, - Instance A will be the staging instance, all ETL processing will take place here - Instance B will be the query instance, all reporting activity will take place here 2) Once data has been transformed, copy the tablespace metadata from Instance A to Instance B using transportable tablespaces feature 3) The physical datafiles will be fast-copied from Instance A to Instance B using a vendor feature called Checkpoints (not Oracle's definition of checkpoints). Point 3 needs further explanation: both of these instances will be connected to Network Attached Storage (NAS) from a vendor named Procom. They have a feature called Checkpoints, which quickly creates a read-only copy of a data volume (I believe this is similar to network appliance's snapshot feature, and EMC also has something like this, but the name escapes me). Checkpoints are very fast to create, and can result in a read-only copy of 200GB of data in 1 - 2 minutes. At present, we use them for backup purposes only, and they work well. Instance A, the staging instance, will use the read-write Oracle datafiles located on the procom read-write volumes. Instance B, the query instance, will use datafiles located on a read-only procom volume, which also happens to be the checkpoint volume of the read-write volume used by Instance A. The checkpoint volume will be refreshed daily, from the staging volume, when the daily ETL stream has completed. The query instance datafiles will be dropped and re-created daily via the procom checkpoint, and the tablespace metadata will be plugged in using transportable tablespaces. We have verified that Oracle works OK using plugged-in read only tablespaces located on a procom read-only checkpoint volume. QUESTIONS: (too much to hope for) 1) Is anyone else out there using this type of configuration with procom? If so, how well does this work? Any comments, problems? (more realistic) 2) Is anyone else out there using a similar configuration with a comparable vendor feature like checkpoints? Any performance problems? Any comments, problems? (more desperate) 3) Is anyone running a large Oracle data warehouse using primarily read-only tablespaces? Any comments, problems? How do you refresh them? (last resort) 4) Does anyone care to comment on the above configuration? good idea...bad idea? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gesler, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message An update: We finished the creation of the database in the morning in time for business day. We found that the file system was performing at about 30-50% efficiency. On Sunday we moved the database to a new server and all is OK. Now we are starting to prepare new server so we can return to replication. Yechiel AdarMehish - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 11:53 PM Subject: Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Thanks for all the replies. We called Oracle support and they come with the DUL utility and extracted the data. As Iwrite this e-mail imports are running. Concurrently wetried to restore the last full backup from more then 2 weeks ago\ and found about 1 day worth of archive logs missing, so this option is out. We now also restoring last night export to a separate database so in case of logical errors in the imported data they will be able to input the deals again and bring the system up to date. So now, eleven hours later we hope to finish in a few hours. Yechiel AdarMehish
Re: Urgent!!! ora-01115 ora-01110 ora-27069
I now this thing. Had it two weeks ago. Call Oracle and ask them to come with the DUL (database unload) utility. Your database is OUT. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 8:58 AM OS:WIN2K DB:Oracle 9.0.1 (ArchiveLog Production) I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in autoextend mode, so I don't aware about the datafile increasing, until suddenly database down:( Unfortunetly, I've no backup at all also. The person who responsible to do offline backup never backup the database. Some archive log is missing also:( Please help me, to solve the problem. Any comment or suggestion I would appreciate. thank in advance, ~holly~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lynxidajax 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Theory v Practice
This is VERY wrong. I know they are perfect, but one bug in the code will cause data loss, order entries without a correct customer code etc. Lets say that a year from now one customer complain. They print a report and see that two entries are missing. You check for orders with incorrect customer number and find that you have 15 orders in the amount of 100,000$ without the correct customer number. Now you have 100,000$ in lost revenues. For a system like this insist on all the constraint that you can put into the database. They can still do the checks in the application so they will not get ORA-N but will give nice error messages to the users, but put checks into the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 7:45 PM The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to release blocks of table?
Thanks Mladen and Lee I am always amazed by the ability and knowledge of the people on this list. You guys (all the list members) always come up with many options to do something so if some option does not work you have others. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 9:13 PM -Original Message- The way to decrease the initial size is 'alter table xxx deallocate unused keep nnn'. I found it in the doc after sending the previous msg. Another possibility: If the storage specifications for the tables in the database are acceptable, and you are the one doing the export, you can specify compress=n when you do the export. Then the initial extent will be as specified when the original table was created. Some shops create large tables with a small initial extent for this reason: When they only want the schema structure in someplace else, they can get it without the big initial extents. You can also use emacs to directly modify the export file to change the storage parameters therein. Something similar to the following: Create the file fix-extents.el with the following: (beginning-of-buffer) (while (re-search-forward INITIAL[ 0-9]*NEXT[ 0-9]*MINEXTENTS nil t) (replace-match INITIAL 1M NEXT 1M MINEXTENTS nil nil)) (save-buffer) Run the following to fix the dump file test.dmp: emacs -batch test.dmp -l fix-extents.el -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Displaying Foreign characters
Hello Viktor I think that the problem is not with oracle. If you have the same nls_lang on the client and the database oracle will not do translation but will work on the principal of GIGO (garbage in, garbage out), meaning what you put in is what you get. You need a program on the client side that can display the special characters that you get in your data. We are working also with we8iso8859p1 and we store and retrieve Hebrew letters with no problems. Yechiel AdarMehish - Original Message - From: Viktor To: Multiple recipients of list ORACLE-L Sent: Thursday, October 17, 2002 10:10 PM Subject: Displaying Foreign characters Hello all, Is there a simple way to display correctlyforeign characters primarily found in name and address records? Currectly, NLS_LANGUAGE = AMERICAN in init.ora and NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 in the registry on client side. Problem is is that name and address records may have characters like "a"with 2 dots on top, and many others, and when querying the db, obviously they're not displayed correctly. Is therean easy way to do this reql quick? Thanks much in advance! Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com
Re: Archive files and their Management
Title: Archive files and their Management Our policy is to keep archive for the last 2 days at least. We are doing daily backup so it gives us the option to restore from the last backup or the one before without restoring archive logs. Yechiel AdarMehish - Original Message - From: Denham Eva To: Multiple recipients of list ORACLE-L Sent: Friday, October 18, 2002 12:28 PM Subject: Archive files and their Management Greetings Gurus Just wondering... Our archive log's directory has grown substantially and space is becoming an issue. How do you know which archive files is safe to delete? In other words... Do you delete all archive files older than the last backup? Should you keep all archive files until it is obviously pointless? Please advise. Many thanks Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: Please help, comment required urgently
Hello George I think that you need to tune the first statement the do the most gets and the most i/o. The same statement also access the most rows. It is fired up about every 5 seconds and is very resource consuming. I am not a tuning expert but this is my 0.01$ worth. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 18, 2002 10:53 AM Hi guys, I need a second opinion on the following Statspack output, I got my suspicions but my manager and the client is not buying what I am say, Not knowing anything of the system architecture please look at the output and say what would concern you. What assumptions/recommendations you would make. Thx George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oraperf comment
Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and split them across disks, but as a rule of thumb splitting indexes and tables make sense (again - when you work without raid). Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 12:39 AM Subject: Re: oraperf comment Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of "parallelization" in "range-scan" operations, but there is no evidence that this is happening. For example, while performing an indexed range-scan,if we wanted to read a batch of index entries from the index "leaf blocks" and submit a list of I/O requests for data blocks on the corresponding table, we could do so. However, when I've performed "truss" operations on an Oracle server process performing such a range-scan operation (at least through Oracle8i), I've not seen this happening. Purely generic "read()" operations, one at a time, sequentially... --- The only real advantages of separating tables from indexes into different tablespaces are: different recoverability requirements indexes can be rebuilt instead of restored data(tables and clusters)must be restored -- cannot be "rebuilt" from anything different types of I/O requests indexes are predominantly accessed using single-block, random read I/O (i.e. UNIQUE scans, RANGE scans, FULL scans) relatively seldom are accessed with multi-block sequentially-accessedread I/O (i.e. FAST FULL scans) while tables are often accessed with a mix of the two types of I/O, depending on the application OLTP usually has heavier single-block, random read I/O due to heavy use of indexes DW usually has heavier multi-block, sequentially-accessed read I/O due to heavy use of FULL table scans may be advantages from this inOracle9i where different blocksizes are possible for different tablespaces These last points are related to performance, but not in the sense that the mythical"conventional wisdom" dictates... Hope this helps... -Tim - Original Message - From: "Ray Stell" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 21, 2002 2:43 PM Subject: oraperf comment An recent oraperf report included the comment: "Never split index and data files to different sets of disks." It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word "Never" inappropriate here? Maybe this is their way of saying don't use old
Re: Actual list of supported/desupported versions of Oracle
Hello Bob We are working with 8163 on NT and windows 2000 and the status is that they will help you find patches but will not backport or develop new patches for this release. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 10:43 PM Bob - I don't feel Oracle makes it easy. They keep changing the location and format. On Metalink, have you clicked on the tab on the left side labeled Certify Availability? Once you are in that section, there are tabs at the top for Product Availability and Desupport Notices. I don't think the finite list of supported/desupported versions exists, but you can get the information you need a piece at a time and gradually build your list. Does that meet your requirements? Yes, for sure they certainly do not make it easy. much akin to using the space shuttle to cross the street) I did manage to find the info though with your guys suggestions. Interestingly enough I entered desupported, desupported versions, version support all with no results... sigh What perplexes me now is the fact that Oracle Support told me on the phone that they don't support any version less than 8.1.7 on WIN2K server... I have 7.3.4, 8.0.5, 8.1.6.3 and now 8.1.7 from NT40 to WIN2K From the documents on the web(below) it appears all platforms are treated equal, so?? I suppose I have to propose that question to the support tech again when I get them on the phone, now that I have the actual documents from their website. Below is a clipping from pertaining to the versions Im interested in. Thanks to all for pointing me in the right direction.. bob # Product: Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition Product Version(s): 7.3.4 Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-DEC-2000 Extended Assistance Support (EAS): 31-DEC-2003 Extended Maintenance Support (EMS): 31-DEC-2002 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 7.3.4 on the following platform(s): ALL Platforms, effective 31-DEC-2000. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.0.6 or Oracle8i on any Oracle certified platform. EAS will be provided until 31-DEC-2003, if the customer has a current support contract in place. Product Version(s): 8.0.5 Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 30-JUN-2000 Extended Assistance Support (EAS): 30-JUN-2003 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 8.0.5 on the following platform(s): ALL Platforms, effective 30-JUN-2000. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.0.6 or Oracle8i 8.1.5 on any Oracle certified platform. EAS will be provided until 30-JUN-2003, if the customer has a current support contract in place. ## Product Version(s): 8.1.6 (8i) Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-OCT-2001 Extended Assistance Support (EAS): 31-OCT-2004 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 8.1.6 (8i) on the following platform(s): ALL Platforms, effective 31-OCT-2001. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.1.7 (8i) on any Oracle certified platform. EAS will be provided until 31-OCT-2004, if the customer has a current support contract in place. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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
Re: Named users! - final clarification
I think that you got the concept wrong. Named users are NOT the userids define in the database. Named users are flesh and blood people that are using applications that access the database. So, if you have an application that use userid GATESB to access the database and you have Bill, Jones and Smith using this application you have 3 named users. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 1:58 PM Thanks folks for your replies on my initial query. Just to clarify by example, how many named user licences would I need for a database with following users. Forgetting minimum purchase requirements I suspect it's 3 is this correct? USERNAME -- SYS SYSTEM OUTLN DBSNMP BLOGSJ LARSONG GATESB - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anybody There?
Welcome Yechiel Adar Mehish, Israel - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 11:18 AM On Monday 21 October 2002 18:38, Ball, Terry wrote: I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Hi, even some new readers are here. I use this message to introduce myself as a new reader(and maybe writer) of this list. My name is Joerg Jost, i am from Paderborn in Germany. I work as a DBA in a company, that produces an ERP - Software. Jörg Jost -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joerg Jost 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating new user
What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM but my friend... i gave the command dir imp* and there are no files found... so now where and how and what do i use my imagination santosh -Original Message- Sent: Tuesday, October 22, 2002 6:25 PM To: Multiple recipients of list ORACLE-L There were imp73 and imp80 for appropriate versions, I don't know about more recent ones Use your imagination, friend! :-) Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobr 15:19 To: Multiple recipients of list ORACLE-L thanks ...but still i gave imp command on command prompt.. but it tells imp not found... and i checked the path also...i have given f:\oracle\bin as the path and there are no imp* files in oracle/bin. any ideas ? santosh -Original Message- Nahata Sent: Tuesday, October 22, 2002 5:40 PM To: Multiple recipients of list ORACLE-L SQL CREATE USER username IDENTIFIED BY password [DEFAULT TABLESPACE user_tablespace TEMPORARY TABLESPACE temp_tablespace] for importing on command prompt imp username/password@database fromuser=username touser=username file=export_dump_file If you just want the table structure and no data then use ROWS=N option too. regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 5:14 PM To: Multiple recipients of list ORACLE-L how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ? any help will be appreciated. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna 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.com -- Author: Santosh Varma 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8.1.7 R 3 for W2K Sever on P4 Xeon Processor - problems?
Known problem with P4 is the Java jit. Copy the installation CD to disk, rename symcjit.dll to symcjit.old and try again. If still not working modify oraparm.ini (in the install directory) to: jre_memory_options=-nojit -ms16m -mx32m. Worked for me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 5:09 PM I wonder if anyone could provide me with some insight on a problem our Sr. DBA is facing. We are trying to install Oracle 8.1.7 SE Release 3 on Win2K Server but our DBA believes that the problem lies with the hardware - a P4 Xeon processor. Has anyone else faced similar issues? Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oraperf comment
I do not understand the WHY in the beginning. I said that it is better to split according to the I/O load, but without more data, split between indexes and tables as a typical sql select will use both. Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 5:14 PM Subject: Fw: oraperf comment ...resending, as the original send encountered some kind of "locking problem" at fatcity... - Original Message - From: Tim Gorman To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 6:35 AM Subject: Re: oraperf comment Why?What are the chances of preciselythat scenariohappening, as opposed to Oracle doing concurrent I/O to tables for both users A and B? Or to indexes for both users A and B simultaneously? Splitting tables and indexes into separate tablespaces makes sense, but mainly for recovery purposes. This has little to do with the placement of the datafiles of those tablespaces ondevices(non-RAID or RAID). Generally, indexes tend to cache extremely well in Oracle (because they are more compact and because of the nature of the I/O), so they usually don't get as much physical I/O as tables. Check V$FILESTAT on a busy application to prove it for yourself... After seeing this performance data, why would you place a datafile/tablespace which only gets a small amount of I/O on one device while placing a much busier datafile/tablespace onto another device, just because one contains indexes and the other tables? Please think in terms of I/O counts, not poorly-conceived but oft-repeated "conventional wisdom". Keep indexes and tables segregated to different tablespaces, but for decisions on placement of datafiles upon devices, use empirical performance data only. - Original Message ----- From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 3:43 AM Subject: Re: oraperf comment Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and split them across disks, but as a rule of thumb splitting indexes and tables make sense (again - when you work without raid). Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 12:39 AM Subject: Re: oraperf comment Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operati
Re: oraperf comment
Sorry if I caused confusion. I meant disks that have different controllers because Ray is talking about a system WITHOUT raid so striping is not an option. Tim said: In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent I just wanted to point that the parallelism helps because Oracle serves more then one user at a time and can benefit from parallel I/O. Yechiel AdarMehish - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 5:03 PM Subject: RE: oraperf comment I'm a little confused when one is talking about putting indexes and tables into seperate TABLESPACES and the other is talking about seperate DISKS. To any extent, I cant imagine how seperating IO typesacrossphysical controllers could be anything but rewarding. Yet, splitting across "DISKS" and splitting across "SPINDLES" are two different concepts. You have striping so you can benefit from more heads to do more IO and you'll only benefit morewithhaving more spindles, ~again~, to handle more IO. Splitting these across multiple spindles has proven performance gains for me andI think the "Never split index and data files to different sets of disks." has a bit of ~a CACHE will solve everything mentality~ (no pun intended). ORACLE will feast on a disk cache especially with 11i applications, butthats not to say it doesn't help. Please correct me as i'm looking for guidance. =) -----Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: oraperf comment Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and split them across disks, but as a rule of thumb splitting indexes and tables make sense (again - when you work without raid). Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 12:39 AM Subject: Re: oraperf comment Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of "parallelization" in "range-scan" operations, but there is no evidence that th
Re: oraperf comment
Hello Tim Maybe I did not express myself as I should have. I am in complete agreement with you on this point. Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 10:00 PM Subject: Re: oraperf comment Yechiel, You had mentioned only one possible scenario (i.e. "user A accesses table while user B simultaneously accesses index") where there are several other possible, equally-likely scenarios (i.e. "user A accesses table while user B simultaneously accesses table", "user A accesses index while user B simultaneously accesses index", etc). Separating tables and indexes to separate devices does nothing for those other, equally-likely scenarios, does it? That's the reason for the question "why?" in the beginning of my last reply... At issue here is not the concept of parallelism in I/O. At issue (at least for me) is the "conventional wisdom" that states/implies that there is some performance benefit of separating tables and indexes to separate devices. My assertion is that this is irrelevantfor two reasons: a) within a single process the accessing of table blocks and index blocks are purely sequential and b) tables and indexes have different I/O characteristics which make it less likely that they will conflict with each other. In fact, in most situations datafiles/tablespaces containing indexes generate far fewer physical I/Os than datafiles/tablespaces containing tables. From an I/O perspective, the key is not to focus on whether the datafile/tablespace contains tables or indexes but rather to focus on the volume and type of physical I/O they generate. By focusing on the I/O statistics rather than whether they are tables or indexes, one can make better determinations on how to distribute I/O across non-RAID devices. Hope this helps... -Tim ----- Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 10:09 AM Subject: Re: oraperf comment I do not understand the WHY in the beginning. I said that it is better to split according to the I/O load, but without more data, split between indexes and tables as a typical sql select will use both. Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 5:14 PM Subject: Fw: oraperf comment ...resending, as the original send encountered some kind of "locking problem" at fatcity... - Original Message - From: Tim Gorman To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 6:35 AM Subject: Re: oraperf comment Why?What are the chances of preciselythat scenariohappening, as opposed to Oracle doing concurrent I/O to tables for both users A and B? Or to indexes for both users A and B simultaneously? Splitting tables and indexes into separate tablespaces makes sense, but mainly for recovery purposes. This has little to do with the placement of the datafiles of those tablespaces ondevices(non-RAID or RAID). Generally, indexes tend to cache extremely well in Oracle (because they are more compact and because of the nature of the I/O), so they usually don't get as much physical I/O as tables. Check V$FILESTAT on a busy application to prove it for yourself... After seeing this performance data, why would you place a datafile/tablespace which only gets a small amount of I/O on one device while placing a much busier datafile/tablespace onto another device, just because one contains indexes and the other tables? Please think in terms of I/O counts, not poorly-conceived but oft-repeated "conventional wisdom". Keep indexes and tables segregated to different tablespaces, but for decisions on placement of datafiles upon devices, use empirical performance data only. - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 3:43 AM Subject: Re: oraperf comment Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and spli
Re: Port usage?
we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: secure connection
Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... I do not see how the file can get "scrambled". You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel AdarMehish - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 7:34 PM Subject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
Re: System Tablespace and Autoextend
Hello Sam I do not know specifically about SYSTEM tablespace but from a bitter experience beware of the 4GB limit. if a datafile on NT/2000 autoextend beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a production database crashing on this problem and had to call in Oracle with the DUL utility to help get the data out and rebuild the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:26 PM Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Full Import/tablespace sizes
Full import will rebuild the tablespaces. browse the export file and you will see the commands inside. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 9:25 PM To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN - It's Here
Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http
Activating batch file from a trigger on nt
Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Activating batch file from a trigger on nt
I solved the problem by: Call a Java function that sends the command to a service that activate the command as a process in NT. This was written by another of my team and can send the command to any computer on the NT network. I think that Joe asked about open window when applying archive logs to a standby database. Maybe this method can work for you. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 6:58 PM Could you use an external procedure or java call? Metalink Tom Kyte's book have good examples. -Original Message- Sent: Thursday, October 24, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to release blocks of table?
I need to release blocks belonging to the initial extent of a table. CTAS is not an option. Optionally how can I decrease the value of initial extent so I can export and import into smaller size. I have a 7GB database that I need to run a script that was given by supplier. This script rebuild all the indexes and I want to make sure that none are forgotten (~ 700). I have enough space for one but not for two. So I thought to import with rows=no twice, run the scripts against one schema and use toad to compare the schemas. The problem is initial extents in the export file that fill all the new DB. If I can decrease the initial extents then I will export and import the whole schema and have enough space. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to release blocks of table?
Ignore my previous msg. The way to decrease the initial size is 'alter table xxx deallocate unused keep nnn'. I found it in the doc after sending the previous msg. I tried it but my problem was that I forgot that the number of empty blocks in the statistics is updated only after analyze. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Download Oracle 7.3.4
select add_month(sysdate,-7*12) from dual; HTH Don't ask for details. That was 7 years ago. I don't even remember how old I was then. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Flat file generation integrity ideas...
But he was talking about sending, not receiving. and he says that the ftp is assured to work ok. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 2:48 AM Unfortunately it is a trust issue... Trust me when I say a file can get scrambled. I have seen it happen. In our wierdest scenario two received files appeared to be merged into a single file - on the source system they had two intact files, on our system 1.5 files merged into a single file and .5 of a file missing. We could never replicate it, we had extensive testing on ftp processes, etc, all we know is that it happened and our validation techniques saw it and saved us a lot of greif. Yechiel Adar adar76@inter. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] net.il cc: Sent by: Subject: Re: Flat file generation integrity ideas... [EMAIL PROTECTED] om 25/10/2002 06:14 Please respond to ORACLE-L I do not see how the file can get scrambled. You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel Adar Mehish - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 7:34 PM Subject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Location of Trace file
I just built a new database for 8.1.6 on win2000. In oracle\ora81\database there is initsid.ora file for the database. This file contains only ifile=\oracle\admin\sid\pfile\initsid.ora. But - The registery entry for pfile point directly to: \oracle\admin\sid\pfile\initsid.ora so ifile value is empty. If you are on windows check that values in the registery for oracle home. Look for name=ora_sid_pfile. The value points to the pfile. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 26, 2002 5:43 PM My query was executed on an Oracle installed, Oracle created Oracle 9i version 2 database on Windows 2000. Oracle really started following OFA on Windows starting with version 8i. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 1:04 PM If you follow OFA, it works for NT ;-) Tom Pall tpall@realtiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] me.net cc: Sent by: Subject: Re: Location of Trace file root@fatcity. com October 25, 2002 12:58 PM Please respond to ORACLE-L Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL show parameter ifile NAME TYPEVALUE --- --- --- ifile file SQL show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 4:12 AM Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: 9iR1 vs 9iR2 ?
We had to decide the same thing. As soon as I saw that support is down in 9 months I decided to go with 9.2. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 3:53 AM Thanx Joe. let me think about it. Jp. On Mon, 28 Oct 2002 Joe Testa wrote : based on metalink note, first level of support for 9ir1 ends 6/30/2003. you decide. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: List of Rows Updated
Title: RE: List of Rows Updated I think that it depends or the needs. If you need a running log then auditing may me better, but if you need to find who has done what from time to time I think that logminer is better as it does not use resources all the time. Of course, do not forget that logminer data from yesterday means that you need to run the database in archive log mode. Yechiel AdarMehish - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 1:58 PM Subject: RE: List of Rows Updated Auditing is much simpler and usable than logminer for *this purpose*. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Tom Pall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated Logminer comes to mind. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:23 PM Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj.
Re: RAID5+
Not a silly analogy - a very good one. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 3:29 AM As with any cached I/O subsystem technology (i.e. RAID-S, NetApps, etc), please visualize a water tank. The water tank represents the cache, the drain from the tank represents I/O throughput rates from the cache to the hard-drives, and the faucet filling the tank represents the I/O volumes from the server to the I/O subsystem. The faucet filling the water tank is on a valve, so that when the tank is full, it does not overflow. Let's say that the water tank holds 100 gallons (about 400 liters???). The faucet filling the water tank can vary its rate, anywhere from 1 gal/min to 30 gals/min. The drain from the water tank operates at 5 gals/min and can not be blocked or closed. Got that pictured in your mind? Now for some scenarios... 1) What happens when the faucet is filling the water tank 24x7 at a rate of 1 gallons/minute? No problem -- the tank never fills, so the flow into it is never impeded... 2) What happens when the faucet is filling the water tank 24x7 at a rate of 5 gallons/minute? Still no problem -- the tank never fills, so the flow into it is never impeded... 3) What happens when the faucet is filling the water tank 24x7 at a rate of 6 gallons/minute? Uh oh. In less than two hours, the water tank will fill, causing the flow of water to be limited to the output rate of 5 gals/min. Too bad, because we really need to move 360 gallons/hour, or 8640 gallons/day, through this system... 4) What happens when the faucet is filling the water tank for an hour at 10 gallons/minute for 15 minutes, then at 1 gal/min for the next 45 minutes? Not a problem -- the capacity of the tank was able to hold the excess input rate during the first 15 minutes, and whatever accumuated was drained off before the next spike or surge... 5) What happens when the faucet tries to run for an hour at 30 gals/min, then 11 hours at 1 gal/min? Uh oh again. We were only able to run at 30 gals/min for about 4-5 mins, and then the flow rate got cut back to 5 gals/min for the rest of the hour. We really wanted 1800 gals to go through the system during that hour, but it actually took 6 hours to get all 1800 gallons through; too bad... Sorry for the silly analogy, but that's how my brain works... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:58 AM Russ: We're using EMC Clariion disk arrays. These are using EMC's version of RAID-5; they call it RAID-S. There is 2GB of cache if front of the disks. They claim that the cache is write guaranteed so that we'll never lose an update. So far, so good, and the performance has been acceptable, except (you knew this was coming, huh?) when we do large file moves from one tray to another, or when doing a refresh of our SAP stage system. This activity kinda buries the internal bus as well as the fiber, so that other users suffer. I guess to make a short answer even longer, this RAID-S technology seems to work a lot better than RAID-5 used to. Remember, though, YMMV. Cheers, Mike -Original Message- Sent: Monday, October 28, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Hi, I just got forwarded a whitepaper from Hitachi and Oracle, that compairs raid 5+ and raid 1 using the TPC-C benchmark test suite. The claim is that raid 5 is as fast or faster. While I'm waiting for a comparison or raid 5+ with raid 0+1, I thought I'd take a poll with the list. The benchmark is using the Hitachi 7700E. Has anyone heard other recommendations attributed to Oracle that are pushing raid 5+ as the configuraton for unrivaled performance? Has new disk technology changed the general conception that raid 0 or 0+1 provides better performance than other raid levels? Thanks, Russ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brooks, Russ 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Login trigger
Here is a message I found in my mail. Change the:IF loc_username='TESTLOGIN' THEN RAISE kill_Login; to whatever test you need. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 09, 2002 8:13 PM Dick, Here is my database log-on trigger. It obviously saves stuff to a database table for later review. I developed this for your same reason - to catch people logging on via c ertain account with an illegal tool. Give it a try! CREATE OR REPLACE TRIGGER WTWDBA.Wtw_Catch_Login_Trg AFTER logon ON DATABASE DECLARE client_info_str V$SESSION.CLIENT_INFO%TYPE; loc_program V$SESSION.PROGRAM%TYPE; loc_usernameV$SESSION.USERNAME%TYPE; loc_osuser v$session.OSUSER%TYPE; loc_terminalv$session.TERMINAL%TYPE; loc_machine v$session.MACHINE%TYPE; kill_Login EXCEPTION; PRAGMA EXCEPTION_INIT( kill_Login, -20999 ); BEGIN -- set a unique string -- dbms_random.seed(dbms_utility.GET_TIME); client_info_str := 'WTWLOGIN_' || LTRIM(dbms_random.value,'.'); DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); SELECT program, username, osuser, terminal, machine INTO loc_program, loc_username, loc_osuser,loc_terminal,loc_machine FROM V$SESSION WHERE client_info=client_info_str; IF loc_username = 'SYS' AND loc_program = 'RESRCMON.EXE' THEN NULL; ELSE INSERT INTO WTW_CATCH_LOGIN(username,program,login_date, osuser, terminal, machine) VALUES(loc_username,loc_program,SYSDATE, loc_osuser,loc_terminal,loc_machine); COMMIT; IF loc_username='TESTLOGIN' THEN RAISE kill_Login; END IF; END IF; EXCEPTION WHEN kill_Login THEN RAISE_APPLICATION_ERROR(-20999,'Login''s using this account and this tool are Invalid'); WHEN OTHERS THEN loc_program := SUBSTR(SQLERRM,1,100); INSERT INTO WTW_CATCH_LOGIN(username,program,login_date, osuser, terminal, machine) VALUES('*Error*',loc_program,SYSDATE, USER,NULL,SUBSTR(client_info_str,-3,3)); END; / Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Flat file generation integrity ideas...
When you get files from an external source no amount of checking is enough. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 6:19 PM Actually, I am sending and receiving files. They will be handling the FTP of the files, and making sure it has FTPed correctly. I just have to have a sanity check of the file. Basically, I decided to prefix each data line with 'DAT', and the CRC line with 'CRC'. The flat file is read into the database via an external table. I query the CRC record, get the expected record count and then count how many rows were actually sent. And then if there is a number column, then I sum that up and check it against the CRC expected sum. Perhaps all this is overkill, but I know that the odds of data corruption are slim to none. I don't like making assumptions, and I can't assume the file is ok. Many thanks to everyone that responded!!! -Original Message- Sent: Monday, October 28, 2002 11:54 AM To: Multiple recipients of list ORACLE-L But he was talking about sending, not receiving. and he says that the ftp is assured to work ok. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 2:48 AM Unfortunately it is a trust issue... Trust me when I say a file can get scrambled. I have seen it happen. In our wierdest scenario two received files appeared to be merged into a single file - on the source system they had two intact files, on our system 1.5 files merged into a single file and .5 of a file missing. We could never replicate it, we had extensive testing on ftp processes, etc, all we know is that it happened and our validation techniques saw it and saved us a lot of greif. Yechiel Adar adar76@inter. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] net.il cc: Sent by: Subject: Re: Flat file generation integrity ideas... [EMAIL PROTECTED] om 25/10/2002 06:14 Please respond to ORACLE-L I do not see how the file can get scrambled. You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel Adar Mehish - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 7:34 PM Subject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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
Re: What's your opinion: ALL_ROWS vs FIRST_ROWS
We have an OLTP system that I thought will benefit from first rows. The sad fact is that when I set optimization to first rows the response sucks. Do some testing, as you can change this anytime. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 11:13 PM We're moving from RBO to CBO. For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? And why? My thinking is if it's a database where most of the querying is done on small sets of records, then we may want to use FIRST_ROWS. On the other hand, if our database is used to generate sizable reports, we might use ALL_ROWS. I also understand that we can always change it per session (with alter session) and per query (with hints). Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: oracle or mssql
I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
Re: oracle or mssql
That was exactly my point. It is NOT 6 of one , half dozen of the other. You commit 1000's of times for each rollback. So the data you read is incorrect while you read it with enormous odds that the changes will be committed. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 8:09 PM But Yechiel, what is better? Getting data that has not been committed by the application, or data that has been updated by an application without a commit being issued? In the mssql option, do you really want to return data as valid, taking the chance that the person who updated the record may issue a rollback? I think it's 6 of one, half a dozen of the other. At least with Oracle, it's logical and under the applications control. If the user issues a commit, then the new data is available for query. If the application needs the data commited more frequently, then issuing commits more often is certainly available. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 11:55 AM To: Multiple recipients of list ORACLE-L I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City
ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Hello All Oracle 8.1.6.3.4 on NT. I got ora-19502 - can not write archive log, and users could not logged on. I can logon only as internal. We had the same problem a few days ago. The technical support people checked the raid 5 disks and did not find any I/O errors. There is a lot of free space on the drive. Has anybody encountered this problem? Do you know what can cause it? What I need to do in order to prevent this from happening again? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: suggestion w/c platforms to choose from...
As a rule buy the biggest, meanest, fault tolerance, with gigabytes of memory and terabytes of disk storage that you can buy. If you will provide more data about: 1) The size of the database 2) How many users 3) How critical is the system 4) The use of the system - data warehouse, OLTP etc then you will probably get a more specified answer. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 2:13 PM hi, can anyone suggestion w/c platform should i used to run oracle? wat are the things to consider in choosing platform? thanks Best regards, Grace Lim MIS Department Suy Sing Comm'l Corp. T- (632)-2474134 F- (632)-2474160 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clone Production Server to Stand by Server on 8.1.7 on Win 2k
Hello You did not write if you bring both databases on every night or the backup is down until needed. If it is down you have no problem. If you bring both up you can change the global name : Alter database rename global_name to backupdb; BTW - I am not sure that 8.1.7 need global_name=true. We are on 8.1.6 on NT and we do not use global names = true. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 4:53 PM Hello We currently have two Identical servers (identical in terms of both Hardware and SW). We run Oracle 7.3.4.0 (Workgroup server) on Win NT 4 on both the servers. We call them as Production Server and Stand by server. The Stand by server is passive in nature (i.e. does not do anything). Every night a batch process shuts down Oracle instance on both the machines and copies over all the files (Data, log, ctl etc) from Production Server to the Stand by server (Drive to drive, directory to directory...) In case the Production Server fails, we simply switch over the users (with a different alias to the stand by server) and they are back in business. Now, we are thinking of migrating to 8.1.7, however while trying to install this version, one needs to specify a Global name which I believe has to be unique on the network. So will the same process that I used to run (i.e. copy all files over from production to stand by ) work??? I guess both my servers will now have to have separate/unique Global Names. Is there any other approach that any of you can suggest??? TIA Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arif Khan (GWL) 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Here is parts of the alert log: Current log# 6 seq# 4153 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1356.ORA Sun Nov 03 11:03:34 2002 ARC0: Beginning to archive log# 5 seq# 4152 ARC0: Completed archiving log# 5 seq# 4152 Sun Nov 03 11:10:33 2002 Thread 1 advanced to log sequence 4154 Current log# 7 seq# 4154 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA Sun Nov 03 11:10:33 2002 ARC2: Beginning to archive log# 6 seq# 4153 ARC2: Completed archiving log# 6 seq# 4153 Sun Nov 03 11:20:50 2002 Thread 1 advanced to log sequence 4155 Current log# 8 seq# 4155 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1358.ORA Sun Nov 03 11:20:50 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: I/O error 19502 archiving log 7 to 'E:\ORACLE\ORADATA\MUSK135\DATABASE\ARCHIVE\M135T001S04154.ARC' ARC1: Archiving not possible: error count exceeded ARC1: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16038: log 7 sequence# 4154 cannot be archived ORA-19502: write error on file , blockno (blocksize=) ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:28:06 2002 Thread 1 advanced to log sequence 4156 Current log# 3 seq# 4156 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1353.ORA Sun Nov 03 11:28:06 2002 ARC2: Beginning to archive log# 7 seq# 4154 ARC2: Archiving not possible: No primary destinations ARC2: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16014: log 7 sequence# 4154 not archived, no available destinations ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:38:54 2002 Thread 1 advanced to log sequence 4157 Current log# 9 seq# 4157 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG9.ORA Sun Nov 03 11:38:55 2002 ARC0: Beginning to archive log# 7 seq# 4154 ARC0: Archiving not possible: No primary destinations ARC0: Failed to archive log# 7 seq# 4154 Sun Nov 03 11:39:07 2002 Thread 1 advanced to log sequence 4158 Current log# 10 seq# 4158 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG10.ORA Sun Nov 03 11:39:07 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: Archiving not possible: No primary destinations ARC1: Failed to archive log# 7 seq# 4154 Yechiel Adar Mehish - Original Message - To: ORACLE-L [EMAIL PROTECTED] Cc: Yechiel Adar [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 7:31 PM Yechiel, What about those alert log entries? Jared Yechiel Adar [EMAIL PROTECTED] 11/05/2002 10:38 AM To: ORACLE-L [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE Hello Charlie and Jared Thanks for the reply. As I mentioned in my mail there is a lot of free space on the disk and the database is with auto archive. Our problem is that the ARCH process gives an error message (ora 19502) and stop. There are messages on the console about error trying to write the archive log, like when the disk is full. Then the redo log will fill up and the instance will stop. After I connect as internal and do: archive log stop; archive log all; archive log start; everything is back to normal. Yechiel Adar Mehish - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 4:48 PM Subject: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE My first guess is that the instance has archiving enable, but the ARCHIVER is/was not started. The DB will run OK until all the redo logfiles have been filled. At this point the instance will simply cease to process any additional transactions until it has space to which to write additional redo logfile information. There should be an entry in the alert_SID.log about what is happening why. - Forwarded by Charlie Mengler/THD on 11/05/2002 06:45 AM - Yechiel Adar [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .il cc: Sent by: Subject: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE [EMAIL PROTECTED] 11/05/2002 12:58 AM Please respond to ORACLE-L Hello All Oracle 8.1.6.3.4 on NT. I got ora-19502 - can not write archive log, and users could not logged on. I can logon only as internal. We had the same problem a few days ago. The technical support people checked the raid 5 disks and did not find any I/O errors. There is a lot of free space on the drive. Has anybody encountered this problem? Do you know what can cause it? What I need to do in order to prevent this from happening
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Hello Charlie and Jared Thanks for the reply. As I mentioned in my mail there is a lot of free space on the disk and the database is with auto archive. Our problem is that the ARCH process gives an error message (ora 19502) and stop. There are messages on the console about error trying to write the archive log, like when the disk is full. Then the redo log will fill up and the instance will stop. After I connect as internal and do: archive log stop; archive log all; archive log start; everything is back to normal. Yechiel Adar Mehish - Original Message - To: [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 4:48 PM My first guess is that the instance has archiving enable, but the ARCHIVER is/was not started. The DB will run OK until all the redo logfiles have been filled. At this point the instance will simply cease to process any additional transactions until it has space to which to write additional redo logfile information. There should be an entry in the alert_SID.log about what is happening why. - Forwarded by Charlie Mengler/THD on 11/05/2002 06:45 AM - Yechiel Adar [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .il cc: Sent by: Subject: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE [EMAIL PROTECTED] 11/05/2002 12:58 AM Please respond to ORACLE-L Hello All Oracle 8.1.6.3.4 on NT. I got ora-19502 - can not write archive log, and users could not logged on. I can logon only as internal. We had the same problem a few days ago. The technical support people checked the raid 5 disks and did not find any I/O errors. There is a lot of free space on the drive. Has anybody encountered this problem? Do you know what can cause it? What I need to do in order to prevent this from happening again? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-02050
There is another view, DBA_2PC_NEIGHBORS. Maybe there is some info there. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 5:58 PM On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] wrote: Ray, I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that. Of course if there is nothing in that table then the transaction has been rolled back already Right, nothing there, so I was wondering if there was a way to chase the transaction id to app, such as archivelog. 8.1.7.4 here. Thanks. John -Original Message- Sent: 05 November 2002 13:43 To: Multiple recipients of list ORACLE-L ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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.com -- 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Thanks Jared. I forgot to mention that the SA checked for device errors. None found. A tar has been opened is already on it's way to higher support level. This problem occurred again today, third time in two weeks. Also, the database is up, only the ARCH process is dead. I started the ARCH (archive log stop; archive log all; archive log start;) and the database continued to work. Yechiel Adar Mehish - Original Message - To: ORACLE-L [EMAIL PROTECTED] Cc: Yechiel Adar [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 8:17 PM Yechiel, No OS errors here. You may want to look at the LGWR trace file in the BDUMP directory. 2 things 1) Have the SA check for device errors. Something in the IO system is not working. 2) Open a TAR. If you have another location to redirect arch logs to, you may want to do that. The following 2 notes you will find useful for redirecting archive logs to another location without bouncing the database. 135866.1 74324.1 HTH Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
I started to tell you that there were no arch trace file, but got a call, while writing this mail (1.5 hours ago), that the system stuck again. This time we put :alter system set archive_log_trace=32; so we have trace. The trace file for the arch process that stuck is: Tue Nov 05 14:21:36 2002 ORACLE V8.1.6.3.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows NT Version 4.0 Service Pack 6, CPU type 586 Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production With the Partitioning option JServer Release 8.1.6.3.0 - Production Windows NT Version 4.0 Service Pack 6, CPU type 586 Instance name: m135 Redo thread mounted by this instance: 1 Oracle process number: 118 Windows thread id: 728, image: ORACLE.EXE *** SESSION ID:(185.7252) 2002-11-05 14:21:36.531 *** 2002-11-05 14:21:36.531 *** 2002-11-06 09:18:32.656 ARC6: Archive destination 1 made inactive: File I/O error 19502 Propogating archive 0 destination version 14 to version 18 Propogating archive 0 state version 10 to version 14 Propogating archive 1 destination version 5 to version 7 Propogating archive 1 state version 5 to version 7 Propogating archive 2 destination version 5 to version 7 Propogating archive 2 state version 5 to version 7 Propogating archive 3 destination version 5 to version 7 Propogating archive 3 state version 5 to version 7 Propogating archive 4 destination version 5 to version 7 Propogating archive 4 state version 5 to version 7 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 9:05 PM Did I say LGWR trace file? I meant ARCH trace file, sorry. jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2002 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE Yechiel, No OS errors here. You may want to look at the LGWR trace file in the BDUMP directory. 2 things 1) Have the SA check for device errors. Something in the IO system is not working. 2) Open a TAR. If you have another location to redirect arch logs to, you may want to do that. The following 2 notes you will find useful for redirecting archive logs to another location without bouncing the database. 135866.1 74324.1 HTH Jared Yechiel Adar [EMAIL PROTECTED] 11/05/2002 10:56 AM To: ORACLE-L [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE Here is parts of the alert log: Current log# 6 seq# 4153 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1356.ORA Sun Nov 03 11:03:34 2002 ARC0: Beginning to archive log# 5 seq# 4152 ARC0: Completed archiving log# 5 seq# 4152 Sun Nov 03 11:10:33 2002 Thread 1 advanced to log sequence 4154 Current log# 7 seq# 4154 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA Sun Nov 03 11:10:33 2002 ARC2: Beginning to archive log# 6 seq# 4153 ARC2: Completed archiving log# 6 seq# 4153 Sun Nov 03 11:20:50 2002 Thread 1 advanced to log sequence 4155 Current log# 8 seq# 4155 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1358.ORA Sun Nov 03 11:20:50 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: I/O error 19502 archiving log 7 to 'E:\ORACLE\ORADATA\MUSK135\DATABASE\ARCHIVE\M135T001S04154.ARC' ARC1: Archiving not possible: error count exceeded ARC1: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16038: log 7 sequence# 4154 cannot be archived ORA-19502: write error on file , blockno (blocksize=) ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:28:06 2002 Thread 1 advanced to log sequence 4156 Current log# 3 seq# 4156 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1353.ORA Sun Nov 03 11:28:06 2002 ARC2: Beginning to archive log# 7 seq# 4154 ARC2: Archiving not possible: No primary destinations ARC2: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16014: log 7 sequence# 4154 not archived, no available destinations ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:38:54 2002 Thread 1 advanced to log sequence 4157 Current log# 9 seq# 4157 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG9.ORA Sun Nov 03 11:38:55 2002 ARC0: Beginning to archive log# 7 seq# 4154 ARC0: Archiving not possible: No primary destinations ARC0: Failed to archive log# 7 seq# 4154 Sun Nov 03 11:39:07 2002 Thread 1 advanced to log sequence 4158 Current log# 10 seq# 4158 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG10.ORA Sun Nov 03 11:39:07 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: Archiving not possible: No primary destinations ARC1: Failed to archive log# 7 seq# 4154 Yechiel Adar
Re: suggestion w/c platforms to choose from...
First rule: Do not mix OLTP and datamart. Datamart access is very heavy and complex SQL's that will impact your OLTP system. I think that an NT with 2-4 CPUs and a lot of memory will do (a not so educated guess). Controller with a lot of cache memory and fast disks (15,000 rpm). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 3:48 AM database will be used for oltp and data mart # of users -- 200 very critical, since order taking , purchase order and accounting module,hr will run on it.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 9:03 PM As a rule buy the biggest, meanest, fault tolerance, with gigabytes of memory and terabytes of disk storage that you can buy. If you will provide more data about: 1) The size of the database 2) How many users 3) How critical is the system 4) The use of the system - data warehouse, OLTP etc then you will probably get a more specified answer. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 2:13 PM hi, can anyone suggestion w/c platform should i used to run oracle? wat are the things to consider in choosing platform? thanks Best regards, Grace Lim MIS Department Suy Sing Comm'l Corp. T- (632)-2474134 F- (632)-2474160 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Differences between Oracle 9.2.0 EE and SE
The list of 9i options can be found at: http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt ions.html Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 4:49 PM I have given up on trying to find document detailing differences between Oracle 9i (9.2.0) EE and SE. Can someone provide a link,etc for this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help required: Enterprise Manager Console - Export/Import/Backup
If I remember correctly ( a big if) there is an option in the OEM menus to set the preferred credentials. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 5:04 PM Come on folks...Help me, I am stuck... I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the export wizard through the Enterprise Manager Console by doing the following: Under Database folder, I right click the Global Name (say ORCL) - Data Management - Export ... and it comes back with the error Either Preferred Credentials are not set or the username and/or password are invalid for this database and node. You must set the Preferred Credentials for the database and node in the Oracle Enterprise Manager Console OK I have logged in to EM-Console with SYSMAN user. Under System - Preferences - Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and SYS with Role as NORMAL, SYSDBA SYSOPER. I have no credentials setup for the Node (say ORATEST). I am pretty new to Oracle 8i and hence may not be taking the right steps required. So, what Id should I log in to EM-Console with??? What ID should I put under preferred credential against ORCL database What permissions does this ID need to have (Can they be provided logging in to sql plus with System or Sys account) What ID should I put under preferred credential against Node ORATEST (Does this ID need to have any prerequisites/permissions) Any other info. I need to provide??? Thanks Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arif Khan (GWL) 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Purging Strategy
Hi Tim We just signed a contract for external storage system from EMC and the configuration is going to be: Regular servers - connect as Nas Database servers - connect as San. If I remember correctly Nas use SCSI connections while San use fiber. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 1:43 AM In response to a post on data purging Tim Gorman wrote some on SAN-based disk, some on NAS-based storage. Can someone please explain the differences between these technologies please. My understanding that a SAN is a group of disks which are available on a network and are not 'owned' by a server and have no direct cables into a server. I also understood NAS to be network based disk (duh!) Please correct, clarify, or comment as needed; I don't recall ever having seen a formal definition for either acronym: * SAN (storage area network): storage-arrays connected by dedicated high-speed interconnects (i.e. SCSI, SSA, FC-AL, etc) managed by a dedicated server, including switches and routers to provide storage for one or multiple storage clients (i.e. what we tend to call servers)... * NAS (network-attached storage): storage that is hosted by (i.e. mounted on) a dedicated, special-purpose server and made available to network clients via IP protocols like NFS, Samba, etc across general-purpose IP networks. For NAS, think dedicated NFS server or dedicated file server or the like and you've got the idea... There are so many technologies mixed into SANs that I find it difficult to generalize. It is probably more appropriate to define NAS first and then say SANs are everything else in networked storage, but I thought I'd try it the hard way... Further generalizing: * SANs are capable of faster and more sustainable I/O throughput rates, but more complex and more expensive * NAS are economical, easy to administer, and easy to implement, but provide lower sustained I/O throughput rates For this reason, I don't see the question as an either-or proposition (i.e. either all SAN or all NAS). They are each point-solutions along a continuum, as illustrated in the strategy in my previous reply. Data passes through a life-cycle, just like anything else. Requirements for storage and retrieval can change during that life-cycle... - ... continuum .. there's a high-class word I've been itching to use . has the potential to become as hoity-toity and annoying as paradigm and juxtaposition, though... :-) Thanks John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Space management failures on autoextend datafiles
Hi Paulo When creating an index, or CTAS, oracle use temp segments while building and rename them after the build finish. So if you do not have enough space you will get: unable to allocate TEMP segment. Yechiel AdarMehish - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Thursday, November 07, 2002 6:04 PM Subject: RE: Space management failures on autoextend datafiles never heard on this problem but are u sure table the temp tablespace of the user executing the commeand is temp and not user_indx??? regards Paulo -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: quinta-feira, 7 de Novembro de 2002 15:39To: Multiple recipients of list ORACLE-LSubject: Space management failures on autoextend datafiles I have a 9.2 database running on Solaris 8. I'm creating some test tables with indexes. The USER_INDX tablespace's datafile is set to autoextend (as are TEMP and USER_DATA). When the system attempts to create indexes, instead of auotextending the datafile (there is plenty of space on the device), it throws an ORA-01652: unable to extend temp segment by 128 in tablespace USER_INDX error. If I manually resize the datafile and rerun it, no problems. Anyone else heard of this behavior? I can't find anything on Metalink that fits the problem definition. Dan Fink
Re: Adding more space to server
Title: Adding more space to server Is the server dedicated to Oracle data files or you have more data in it. We have for each server a lot of data that was loaded in the database + a daily export. I saved a lot of space by compressing the folders for the data and the export. Yechiel AdarMehish - Original Message - From: Hussain Ahmed Qadri To: Multiple recipients of list ORACLE-L Sent: Sunday, November 10, 2002 7:03 AM Subject: Adding more space to server Hi all, We are running out of space on our server and I was going to add another hard disk to it. I had thought about somewhat crude but easy way to go about it. Since I can afford to shutdown my database for a couple of hours tomorrow, I thought that I would shutdown the database, move some datafiles to other partitions, redefine the partitions as to increase their size (WinNT 4 and Oracle 8i) and then move back the datafiles and then start the database. This way I would have more space to accommodate any increase in size of the datafiles and not worry about changing any of the database complexities (plus more space for the archives generated, as the database is in archive mode). Neither the control file nor any of the parameters would have to be changed as no change in location took place. Is there anything wrong in this method? What could be the other options, if any? Anything else that I need to keep in mind? Thanks and regards, Hussain Ahmed Qadri DBA SKMCHRC
Re: Changing column format
You do not need to change the primary key unless different user names can have the same userid. Just add a unique + not null constraint on the user name column. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 10:33 PM I create a table to store user account information and set userid column to be primary key. I now want to set username to be primary key instead of userid, how do I change it? There are couple hundreds of records in table. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Character Sets - 2 different kinds, same server
1) You can have two databases with different character sets in the same computer. you may have problems running local jobs, but I do not know Solaris to comment on this. 2) according to metalink doc#: 119164.1, UTF8 is a superset of US7ASCII so you can convert your database to use UTF8 without problems. There is a reference to doc# 66320.1 in this document. The 66320.1 document will explain to you how to change the character set. It worked for me in 8.1.6 on NT. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:13 PM Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and Oracle binaries were installed with US7ASCII, how can you convert it to UTF8 without having to reinstall everything? This is Oracle 8.1.7.3 on Solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Purging Strategy
Hello Jay How about building an historical DB and keeping the data there. It will not overload the production instance, will be available online if you need something, you will migrate it to new versions of Oracle so compatibility will not be an issue and you can implement table changes on the historical data so the structure will remain the same as in production. We are doing it in ADABAS on the mainframe. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 11:24 PM Well, if worst comes to worst we can always install an earlier version on a box and import it there. But the reason we can't get more storage approved still has me shaking my head... -Original Message- Sent: Thursday, November 07, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Jay, just make sure you are not around when, after several Oracle upgrades, and they want to import one of these files back that they discover that the current release of import can no longer read the older version of the .dmp file. now what are these senior damagers going to do? blame the DBA, that's what! duck and cover... duck and cover... Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, November 07, 2002 1:55 PM To: Multiple recipients of list ORACLE-L FWIW, what we just implemented (because senior management refuses to approve additional storage on the grounds that making the database larger will affect performance - aaargh!) is 1) Confirmed with business how long data needs to be online for various tables (they're all partitioned so that makes it a lot easier) 2) Export partitions older than that once/month (this is generated off a table that lists each partitioned table and how long data should be kep) 3) After confirming that all export files are valid we drop the old partitions (this will be done by script but is being done manually for the first few months) 4) Leave dmp files on server for 2 end of months (our end of month backup tapes are stored for 7 years) 5) Maintain a table in database saying what exported partitions are on what date's tapes And I really long for the days in this company when senior management made technical decisions by asking the technical people instead of just making things up... Jay Miller -Original Message- Sent: Wednesday, November 06, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Someone asked about this 3 weeks ago. Here's my take on archiving data. I don't expect everyone to agree with this, but nonetheless, I have an opinion. :) Here's an email from last month. You can undoubtedly find some other ideas on this by searching the archives of this list at fatcity.com Jared == I'm not a proponent of purging data. Unless of course, you expect to never see it again. That word 'archive' rolls of the tongues of managers and consultants pretty easily, but what's behind it? There are a few gotchas with purging and archiving. Let's assume you have some 3 year old data that you need to see again, and it has been purged. Here are some of the possible problems: * Your backup tapes are corrupted * Your new backup hardware can't read the old tapes * Your software no longer understands the format that the data is in. * You have the correct software, but it won't work on the current version of OS on your hardware. * The data format/software/whatever is not well documented * The employees that understood the data 3 years ago have been laid off. * ... lots more stuff Read Bryon Bergeron's Dark Ages II: When the Digital Data Die http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0 Perhaps much better than archiving the data, is to stick with the idea of moving it to another database, and using lots of cheap disk storage (NAS) or a heirarchical file system to store it. The point being that if it's online somewhere, it will be maintained. Don't purge it till Finance, HR, the IRS and any other stakeholder says it's ok. Only then purge it and archive it to offline tape with the knowledge that you may never see that data again. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2002 01:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Purging Strategy Dear List, I need some inputs from you all regarding purging data from the database. This is the requirement We define a retention period for all the data in the system. When the retention period is reached, the data should be deleted, but then at a later time, some user might request for this purged data. So it must be possible to retrieve this data. This is the strategy we have designed for this. When the retention period
Re: phyrds in v$filestat and sql trace not match !!
My guess will be that PHYRDS is the count of start i/o's. Each start i/o read mutilblock_read_count blocks from the disk. The data buffer that you read with each start i/o is the same: 8 blocks of 8k or 16 blocks of 4k. So you get the same number of start i/o's. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 12:43 PM list, i'm doing benchmarking using two DB's with different block size i run a count(*) on a 17 million row table, and compare the sql_trace file and the v$filestat stats.. the db was bounced before each test, the init.ora params were identical, EXCEPT in DB1 (4k block size) the muldiblock read was 16, and DB2(block size 8k) it was 8 4 samples were taken... CPU time : DB1 = 9023 DB2 = 8027 elapsed time: DB1 = 19171 DB2 = 18045 phy reads: (from sql_trace) DB1 = 327022 DB2 = 159347 PHYRDS from v$filestat DB1 = 16386 DB2 = 16385 PHYBLKRDS from v$filestat DB1 = 262148 DB2 = 131073 my question is... why the physical reads in the v$filestat are equal ?? but the p reads in the sql_trace file are different ?? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus ~no~output
Title: sqlplus ~no~output To do it in a command file - @sfsfasdf.sql. Set termout off does not work for commands executed from the command line. Yechiel AdarMehish - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, November 11, 2002 10:23 AM Subject: sqlplus ~no~output for the sake of select * against a pinned table I want row output totally turned off. in the past I thought set serveroutput off, set termout off, set pagesize 0 was sufficient, but its still dumping row data on me. What have I forgotten ? TIA
Re: Oracle 10i features
Thanks for the link Jared. For now, I just bookmarker it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:23 PM Check out OraC, written in Perl of course. :) http://www.tux.org/orac-dba/ Jared On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: Good grief. Like I'm going to go through all of that overhead and hassle? And isn't 9iAS a separately licensable (read: cost) option, even if you're already licensed for EE? I think I'm reading the same PDF you were, Raj: The Console interacts with the Oracle Management Service, which, as a J2EE Web Application hosted by an Oracle9i application Server, leverages all of the reliability, scalability, and robustness of the Oracle9iAS instance. I wish I has time to work on the KISS-method OEM replacement I started... sigh Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 12, 2002 10:40 AM To: Multiple recipients of list ORACLE-L New EM4.0 (announced today) has a bunch of new features ... was just reading the PDF ... but it needs 9iAS ... that is a bummer ... more info on oracle website ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris vs Windows 2000
I heard in Oracle Week in Israel that Oracle is planing to add Linux to their supported products and provide help desk for it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 4:48 PM You're right .. but when will it become ready? MS always said their NT3.5 is enterprise eady, they said NT4.0 is enterprise ready, W2K is enterprise ready, .Net is enterprise ready. It's all in the marketing. If enough people like me say Linux is ready, then it becomes ready. Readiness is relative. I'd say it's ready enough. Maybe not SAP specifically. But if you havn't heard, Oracle software runs on Linux fine with a lot of support available for it already today - Dell, RedHat, Oracle IBM all support Linux. -- Lyndon Tiu On Wednesday 13 November 2002 05:39 am, Jared Still wrote: Lyndon, I like linux. I've been using it for 10 years now. It still isn't ready to run my production SAP systems though. I don't mean that it's not capable of doing so, it's very capable. There is not the history of support and stability that is needed to trust my enterprise data to it. My Oracle dev server? No problem, I love it. Will I put my butt on the line for bleeding edge technology? No way. SAP runs our business, pure and simple. If it's down, we are not selling product, we are not producing product. I'm not ready to trust linux that far yet. Jared On Monday 11 November 2002 19:34, Lyndon Tiu wrote: Seriously now. I know you are trying to evaluate Solaris and Windows, but ... Linux is the way to go. Sun's are expensive machines. NT/2K are cheap(er) but locks you into an expensive software upgrade cycle. Linux costs very little and runs on cheap hardware. -- Lyndon Tiu On Monday 11 November 2002 06:58 pm, Stephen Lee wrote: -Original Message- Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. My personal bias against Windows is based mostly on three things. 1. Incompatibility with everything else. Microsoft makes its products as incompatible as it can get away with so that once you start going down the Microsoft path, you become more and more locked into that path. 2. It is a single-user operating system. Microsoft has done a pretty good job of making it look otherwise by tacking on some multi-user extensions; but it is, in fact, NOT a multi-user OS. Just try creating a general user so that user can install, upgrade, and maintain their application without having administrator privilege. It ain't gonna happen. And that brings up the main problem with this arrangement: Every user that must support an application on the box must have administrator privilege. This, of course, presents a completely insecure environment. 3. In its normal form, there is an amazing lack of the kind of support and scripting utilities the are normal on Unix. True, if one wants to spend the time, many of the utilities can be set up on NT; but that involves additional setup and maintenance time -- which your NT admins might not be inclined to do if the bureaucracy of your organization requires that they do it. If your scripting abilities are substantial, then you, no doubt, automate many things with scripts. If you have built these scripts with a non-standard environment, then you have built your house on shifting sand. (By the way, this is why I do not fully support Linux.) I must agree that I do like the Dell Poweredge stuff. I was using it years ago, and the value is certainly compelling. It's too bad that Sun did the same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up about it and over-priced the crap out of everything until it was too late). But the Sun hardware (and IBM too) ain't all that shabby either. And my past experience -- when I was a sys admin work -- with Sun customer support was very positive. IBM eh, so-so ... maybe. Perhaps another thing to consider: If you have ever tried to upgrade the OS on a NT box supporting third-party applications, I suspect you discovered that it can be an excrutiatingly painful experience ... If you even succeeded at all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
Re: Autostarting databases
Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 5:18 PM All Ive finally returned to my desk from the server room/user desktop trenches ;-) with hopefully some time to pose this autostarting problem to the list. I have about 12 oracle database(services) running on windows 2k server, I believe by starting the service should start the instance and stopping the service should shutdown the database. This not happening on the server, so the databases are not starting up automatically. I have to force start then using a batch file as such svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 ... initdb8i.sql connect internal/pw@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit I have tried to delete the service via oradim and recreating but doing that does not affect the auto starting problem. Here is an example of my use of oradim F:\ORA817\bin\ORADIM -delete -SID db8i F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst -TIMEOUT 60 One other issue is once I delete the service and create a new service, then try to delete again. win2k informs me the service is currently marked for deletion so you cant do anything else with the instance, a reboot to clear the marked service is necessary. I've checked the registry entries in the oracle home and it corresponds exactly to what is specified in the oradim statement and the path to the oracle.exe in the service is correct. Overall history: this server was NT 40, now upgraded to win2k server this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3 currently the default home is set to 8.1.7 The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases I have tried to 1. delete and recreate the sid using oradim 2. migrating an 8.1.6 to 8.1.7 using the migration wizard 3. Building a new database using 8.1.7 None of the databases will auto start! I have win2k pro with 8.1.6 on my machine and stopping and starting the service starts and stops the database Any suggestions for getting my db's to start upon boot up. I have deleted the service with oradim then recreated, as above then rebooted and the db does not start. This whole problem started whn the server was upgraded to win2k server. thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How-To or Good Practices on Code Releases
Title: How-To or Good Practices on Code Releases Whenever I install a new release of software my boss wants to know: How do you return to the old version if this does not work? For each install script require an undo script. We are using toad to compare schemas and it can also generate script to convert from one schema to the other. Yechiel AdarMehish - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 13, 2002 5:29 PM Subject: How-To or Good Practices on Code Releases Friends ... I have a (sort of) problem ... what are the best practices to manage code releases to production environment ... currently we get a bunch of scripts from development team, and we release code to production on the schedule (currently twice a month). But this is not complete. The scripts we get consists of various DML and DDL statements. We do not have a mechanism to roll-back these changes in place and I am seeking your opinion on ways to achieve these. Also we would like to implement script dependencies (which we manage manually right now) and rollback mechanism. Are there any good practices papers? I know these would be site specific, but I am looking for common methods. Hope I make myself clear ... (and if it matters it is Oracle 9.2 and Forms/Reports) application. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
Re: How-To or Good Practices on Code Releases
Title: How-To or Good Practices on Code Releases Are you working with UTF8? They had some problems in the initial release but they are corrected now. Yechiel AdarMehish - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 13, 2002 6:15 PM Subject: RE: How-To or Good Practices on Code Releases TOAD _until now_ had problems with 9.2 database ... it would complain that (in our case) 903 objects were not found when I could go in, and perform all kind of DML on those objects. 7.4 seems to be better ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 13, 2002 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: How-To or Good Practices on Code Releases Whenever I install a new release of software my boss wants to know: How do you return to the old version if this does not work? For each install script require an undo script. We are using toad to compare schemas and it can also generate script to convert from one schema to the other. Yechiel AdarMehish
Re: Move ALL Data from 1 Database into Another
No matter how you do it, do it in parallel. Export and import, or CTAS, by schema or tables so you can run them in parallel. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 7:03 PM Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either. Qs Would Creating a Database Link between the 2 Databases using CREATE TABLE TABLE NAME IN 8i DB NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM TABLE NAME IN 7.3.4 DB@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database Importing (imp) to the Oracle 8i Database ? ASSUMPTION - Both Databases Exist on the SAME Storage Box thus on the Same Machine Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT ksh day of week yesterday
Run your script at 23:58 :-) Yechiel AdarMehish - Original Message - From: Barbara Baker To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 13, 2002 8:24 PM Subject: OT ksh day of week yesterday Will someone take pity on this poor VMS'er lost in a unix world?? I'm trying to create a script (ksh) that reads a log file created yesterday. The log filesare created with `date +%a` appended to the end of the log file name. Last night a log file was created called arc_indexlog.Tue It's easy enough to get today TDAY="`date +%a`" grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAY grep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAY but how do I get yesterday in the same format?(i.e., Tue instead of Wed) I man'd date, but it was no help. Thanks for any help. Barb Do you Yahoo!?U2 on LAUNCH - Exclusive medley videos from Greatest Hits CD
Re: Autostarting databases
Hi Bob I took a look at the database service one of our servers. service properties: startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the database). startup mode = automatic. logon as local system account. allow service to interact with desktop. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 9:52 PM Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How-To or Good Practices on Code Releases
You do not have to reinvent the wheel. If you want to check the scripts just do the following: 1) Get the DBATool from DataBee www.databee.com 2) Do export no data from the target system. 3) Read the export into the DBATool 4) Create DDL for the schema 5) Run the DDL and create the schema in test db. 6) Run your script against the empty schema. All syntax error and logical error will show up. It will not check for data dependent error, like adding unique constrain to a column with data that have multiple occurrences of the same value but it will save you a lot of time and development. Yechiel Adar (who does not have any hidden/unhidden connections to DataBee) Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 9:23 PM one of the things I'm experimenting with right now, based on a request from clients, is a pre-run analysis script to report on likely errors that the actual script would generate. this gives me a chance to trap the silly errors and continue (e.g., modify column to NOT NULL that is already NOT NULL, drop a column that's not there, etc.) and provide feedback to the client on the more serious errors that will need their attention - e.g., changing a column datatype or reducing a column_size, where the existing data won't work; creating a FK, where there are missing parent records; etc.) This analysis script tests for the existance of new columns or data that are to be added, checks max(lengths) of fields that need to be shortened, etc. The client can then execute the analysis script, evaluate the output, and decide on a course of action. As others have said, though, this REALLY SHOULD first be run in a UAT, staging, or other test env first - if for no other reason than a sanity and syntax check. My objective with this is to PREVENT the need to roll back the script, save for unexpected errors (whereby something significant changed between the time the analysis script was run and the actual delta) and *critical* errors (crash, out of disk space, etc.) . . . in which case I would revert back to the backup they should have taken just before the script was executed HTH bill -Original Message- Sent: Wednesday, November 13, 2002 1:20 PM To: Multiple recipients of list ORACLE-L As an example, something that yours truly was involved with, and still have the scars to show for it. A migration from a lower version of Oracle, to a higher version, on a completely new server. The scripts ran fine, and the implementation plan worked fine. However, the application started reporting intermittent connection problems. This was a web application, and it took the developers a day to realize that the one of the components in the application was not fully certified with Oracle 8i. Also, there were memory leak issues with that version of Oracle 8i. Whereby we needed to fall back to the old server, with the new data. The rollback strategy in the implementation plan was a one liner, to fall back to the old server. This was good for an immediate fallback after the implementation. Had to go the export import way, which had some additional outage for hours. So, the next time this was implemented, we had a quick rollback strategy to rollback after n number of days. If memory serves me right, I think we had a standby database created on the old server with the new release, and a downgrade plan. This was tested and approved by the developers and the QA team, though I never had to use it. Since then, I tend to be paranoid about any changes to production databases. You live and learn. Regards Raj DENNIS WILLIAMS DWILLIAMS@LIFETo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COM cc: Sent by: Subject: RE: How-To or Good Practices on Code Releases [EMAIL PROTECTED] m November 13, 2002 12:15 PM Please respond to ORACLE-L Raj - Can you provide more details? Is this an automated script, or just a line on the form that says that you have some idea of how to rollback the change in case anything goes wrong? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 13, 2002 10:54 AM To: Multiple recipients of list ORACLE-L And have a similarly tested and signed off rollback strategy in place. An immediate rollback, as well as a rollback strategy after n number of days. Raj One attachment (0k) Reginald W. Bailey/JPMCHATo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SE@CHASE cc: Sent
Re: Configuring disks on a Windows 2000 server?
Hello Paul ALL our oracle servers are windows NT/2000 with raid 5 arrays for all the files. 1) The point that Oracle does not support online redo logs on stripped partition seems wrong to me. 2) There was a discussion on the list a while ago about the write speed times between raid 5 and raid 0+1. Anyway, since raid 5 are usually implemented with a big controller cache (backed up by a battery) your database writes to the cache and you get reasonable response time. We have a heavy online application with about 50 users that runs OK on windows NT with 2 processor and 5 disks raid 5 array. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 12:03 PM Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] MS ODBC for ORACLE driver connection problem!!
Put a copy of tnsnames where MS ODBC wants it? Check if MS ODBC support name server or Directory services? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 4:58 PM We are testing the ORACLE 9iR2 client server connection. On PC side, we installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to 2.573.9001.000. After configuration, ORACLE ODBC driver work fine, but MS ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error. I trouble shooting the problem and found MS ODBC for ORACLE ONLY check \orant\network\admin\tnsnames.ora. The path we installed ORACLE client on \oracle\9.2\. Does anyone know how to fix this problem? Thanks. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New development in Cobol or PL/SQL - please help
If I understood correctly your whole application will be on the mainframe with web front end to interface with the users. We are a mainframe (mostly) company and we have dozens of Cobol programmer on the mainframe and NO sql programmer. (I have to fight the open system group to get at least ONE sql programmer so the DBA team will not have to write whatever sql programs the APPLICATIONS need). So a new project on the mainframe will definitely be in Cobol. I still do not understand why they want Oracle on the mainframe. We are working with ADABAS and get very good result. Most other mainframe that I know use DB2. I have not heard of anyone using Oracle on mainframe (at least under IBM MVS). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 12:24 AM I just found out today that we have a major development initiative that is starting and they are planning on using Pro*Cobol to develop the application. (my head is still shaking in disbelief!!!) So we will have a Java front-end, invoking MQ series that will go across to the mainframe for MQ series to invoke Pro*Cobol programs that will then do the processing (accessing data and doing calculations) and then return data. If anyone has been in this or a similar situation, please help. I need some really good arguments as to why we should put the business logic into PL/SQL instead of Pro*Cobol. I understand the reason we are using Oracle is that the director has 15 years experience with it and loves it. Aaargh!!! thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Netbackup [#2]
Since no one else replied I will give you my experience: (Backupexec for oracle 816 on NT/2000) We are working with it and got backup speed up to 300MB per minute. There are some limitations: 1) Backupexec does not delete archive logs. We wrote a script that marked all existing archive logs before starting the backup and delete all the marked logs after the backup. 2) When restoring to a different machine, Backupexec creates a folder for each tablespace and restore the datafiles to this folder. You need to move the datafiles to their place in order to start the database. 3) Backupexec does not do recovery. You need to restore the archive logs that you think you need and then do recovery yourself. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 12:23 PM Is no-one out there using NetBackup???. Without wishing to sound rude I'll assume a non-response indicates an affirmative to that OR that you're all too busy to voice an opinion ;) -Original Message- Sent: Thursday, November 14, 2002 15:04 To: 'List, OracleDBA [Fatcity]' Howdy Folks, Would appreciate feedback on experiences, positive :) or negative :(, folk have had using Veritas NetBackup product for DB recovery, especially in DR scenarios. There is an Oracle agent but so far all it appears to me to be is a glorious scheduler of your own RMAN scripted jobs!. Feedback on features I may have missed with agent would also be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: move USERS tablespace to locally managed
Thanks for a clear and illuminating article; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 7:08 PM One thing my article did not cover was of course the possibility that you end with up with a miniscule extent size multiple in the bitmap because you have to existing extent sizes that are close to being relatively prime. Will this hurt...dunno really. I haven't played with deliberately distorting the bitmaps in this way hth connor --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Mark, Thanks for the reference. But it seems to quibble with detail that may not affect very many people. My conclusion after reading of what was found is to go ahead and use the package. If you experience the error reported, then the site gives an appropriate work-around. It dopes not, however, express any real reservation for not using the package. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Tom, There are actually reasons not to use the package Oracle supplies to go from DMT to LMT. For the full details, see Connor McDonald's paper on http://www.oaktable.net/ . -Mark On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote: John, Why would you *not* want to use the package provided by Oracle? The answer to your question is to: 1). create a new USERS tablespace 2). issue ALTER TABLE table_name MOVE new_tablespace commands 3). issue ALTER INDEX index_name REBUILD commands. 4). issue ALTER USER username DEFAULT TABLESPACE new_tablespace; 5). drop the old tablespace. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City
Re: Netbackup [#2]
Sean Sorry for the wrong reply. You asked about NetBackup and I replied about BackupExec. We did NetBackup restore to another computer and it worked ok without problems. We DID built the directory structure beforehand so I do not know if he builds it himself when needed. Naveen - There is an option in BackupExec to run user script before and after the backup. Since archive logs are written with the (OS) archive bit off, we just use 'attrib *.* +a' and then backup the archive log and then delete all the files with the archive bit on in the after backup script. While replying to you I remembered a problem we had with this method. When we restored all the files we found out that the archive log that were created DURING the backup itself are not included in the backup set. You will need to: 'alter system archive log current' after the backup and backup in a different job the archive log that were created during the backup. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 12:23 PM Is no-one out there using NetBackup???. Without wishing to sound rude I'll assume a non-response indicates an affirmative to that OR that you're all too busy to voice an opinion ;) -Original Message- Sent: Thursday, November 14, 2002 15:04 To: 'List, OracleDBA [Fatcity]' Howdy Folks, Would appreciate feedback on experiences, positive :) or negative :(, folk have had using Veritas NetBackup product for DB recovery, especially in DR scenarios. There is an Oracle agent but so far all it appears to me to be is a glorious scheduler of your own RMAN scripted jobs!. Feedback on features I may have missed with agent would also be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
moving from dedicated connections to MTS
Hello all First a little background. We work with oracle 8.1.6.3.4 on NT or win2000 servers. The technical people have just move an application server behind a firewall. The application servers access a database that is a central repository of user connections (i.e. all applications on the intranet access this database for each page for each user). They saw that the application works fine for a while and then they get access denied. They track it down to the port numbers in the firewall. We are working with dedicated connections and it seems that the port numbers for each connections are climbing up until they exceeded the range of open ports in the firewall. They said that they had the same problems in another server, they brought an outside guy (of course without telling the DBA group) and he solved the problem. They brought me the init.ora file of that database (I can not access it via the firewall) and showed me the parameters that made the difference. The guy put in: mts_dispatchers= ... port=8000) (5 dispatchers). Since they want me to do it on a central and essential database I want to ask you guys: 1) Any gotcha moving from dedicated connections to MTS? 2) Is each dispatcher assigned for the current sql command and then released or is it assigned for the duration of the session? 3) What is the ratio of users per dispatcher? 4) Is there a way to tell oracle to reuse port numbers for dedicated connections that were closed? 5) Anything else you care to share. Sorry if my questions are somewhat trivial but we need a decision tomorrow morning (in 18 hours) as they start doing some training session on the system on Sunday and time is short. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: opinions on SAN devices for Oracle
We just bought EMC Cellero. I do not know the reasons, just that they won the contract. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 8:49 PM Hi All, We are considering the following 3 SAN storage devices. If anyone can share any info on any I would appreciate it. They all have 2gig fibre channel. Hitachi 9200 EMC CX400 HP EVA 2c2d Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: opinions on SAN devices for Oracle
We just bought EMC Cellero. I do not know the reasons, just that they won the contract. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 8:49 PM Hi All, We are considering the following 3 SAN storage devices. If anyone can share any info on any I would appreciate it. They all have 2gig fibre channel. Hitachi 9200 EMC CX400 HP EVA 2c2d Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Yechiel Adar 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: ANALYZE question
On the subject on analyzed: We are doing analyze compute statistics and it takes about an hour. Do you know of ways to speed it up? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:54 PM On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: A question: If analyzing SYS objects is a bad idea, why is it included by default in the analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. Please correct me if my assumption is wrong, we had strange behaviour here when SYS objects were analyzed on a development db. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Farnsworth, Dave 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: Boivin, Patrice J 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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
Re: MUST read Oracle Architecture - Abrief Intro
I think that you will understand it better if you consider 2 scenario's: 1) RMAN backup from time 13:00 is newer then the backup taken at 13:45. 2) You get Enron accounting when the feds discover that invoice number 123 was issued after invoice 124. There are a lot of things, application and / or system, that can go wrong in this situation. To be on the safe side shut the database down for 1.25 hours. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 3:38 PM yes , but time based incomplete recovery could create problems if he doesnt take a full backup after the os-time-change . -Original Message- Sent: Wednesday, July 24, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Oracle has no concept wrt. the date time of Operating System for running individually as a product. It just takes the timestamp in certain DML's while updating and inserting the rows having DATE as datatype. Nothing more than this. Oracle works on the mechanism of SCN ie. System Change Number which gets monotonically incremented one by one after every commit takes place. It has nothing to do wrt. the OS time. When the Oracle engine gets started the control file reads the location of datafiles and redo logs and the latest SCN is read and compared with those present in datafiles aand redo logs. If the SCN is not matched menas the database was abnormally shut down and need thread recovery. Smon does this task independently and roll forwards the txn's which were left in the buffer cache and were not pushed back to d.files during checkpoint process. These txn's were committed at the user end. Now the ones which were not committed would be rolled back internally by Oracle b'ground process SMON or Server Process initiated by user process and would rollback the blocks who soever touches them first. A little bit of ARCHITECTURE OF ORACLE .. Bye for now. No problems at the time lagging behind or time forwarding of the OS -Original Message- Sent: Wednesday, July 24, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Oracle will continue to work fine (as it uses SCN numbers for consistency and transaction logging rather than dates). However, if you have any apps which use timestamps in the data, then I'd do some more investigation for the ramnifications on the application logic side... -Original Message- Sent: Wednesday, July 24, 2002 7:13 AM To: Multiple recipients of list ORACLE-L If you can take the database down for 1.25 hours. I will hesitate to startup the database with time less then last closing time. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 8:33 PM Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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: Yechiel Adar 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: Glenn Travis 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
Re: ANALYZE question
Thanks all for your advice. Will check an option to do estimate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 7:23 PM At the last Open World I attended a couple of sessions where the general advice for 9i DB is to use ANALYZE ESTIMATE without specifying ANY value. A few brief comparision tests did show that it got better results than the alternatives tested. As always, YMMV HTH HAND! -- 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: Yechiel Adar 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: Is Statspack a Security Problem?
Thanks Ian. Have a beer on me, you earned it with this info. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:51 PM Ian, You are likely to win the wager on this one. I discovered the public when i was trying to secure my database. There are grants to public all over the place. I would be very interested to know and understand why Oracle did grant so much to public and what can be safely revoked. Ron ROR mô¿ôm [EMAIL PROTECTED] 07/24/02 04:20PM I'm not saying it's not fixable. The creation of dba level accounts such as dbsnmp and outln by Oracle is fixable as well. But I'll wager there are folks out there who didn't know the grants on the statspack tables were to public. Of course none of our developers or ad hoc query writers would ever write a statement that doesn't use bind variables. I have it on good authority that the same holds true for all Oracle sites everywhere. :) Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Why not just backup the spctab.sql script and then in vi do a g:/PUBLIC/s//DBA or whatever role you choose to play with statspack before running. Although bind vars are still appropriate too. Rodd Holman On Wed, 2002-07-24 at 12:23, kkennedy wrote: Sounds like yet another good reason for using bind variables 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 24, 2002 8:23 AM To: Multiple recipients of list ORACLE-L To wit: $grep -i grant spctab.sql snip grant select onSTATS$SQLTEXT to PUBLIC; grant select onSTATS$SQL_STATISTICS to PUBLIC; grant select onSTATS$LEVEL_DESCRIPTION to PUBLIC; grant select onSTATS$IDLE_EVENT to PUBLIC; grant select onSTATS$PARAMETER to PUBLIC; grant select onSTATS$STATSPACK_PARAMETER to PUBLIC; --- Notice the grants on stats$sqltext and stats$sql_summary. Should anyone who logs into the database be able to see nearly SQL run against it. Oracle appears to truncate alter user statements so that one cannot find 'alter user blatz identified by password;' but one may stumble on update sal_table set sal = 100 where empoyee_id = 5;' or something to that effect. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Yechiel Adar 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: Problem with Oracle manager for MTS
Have you checked the regional settings on the server. Make sure you install the client with language=English USA. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 1:08 PM Hello, We are on Intel pentium 4 windows 2000 SP2 server. We tried to install oracle 8.1.6 client and no thing happened where we clicked on the SETUP button. We applied the patch 1507768 and every thing was okay, we could connect to the database (8.1.7.0 in AIX) via sqlplus. Now when we try to create a service for Microsoft transaction server we got this warning (in french) that we don't get on any other server : Le chiffrement des mots de passe n'est pas pris en charge lorsque la variable locale est la France. Le motde passe sera stocké en toutes lettres dans la de registre. In english : The encryption of the password isn't supported where environment variable is set to France. The password will be written into the register's base without encryption. We can then create the service but the database ID isn't shown in the service's property and there isn't any enregistrement in the table MTS_PROXY_INFO. We've opened an Itar since last week but they don't find any thing and I find nothing in the internet. Any help will be appreciated. Best regards, Thanh-truc Nguyen Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 ?/mn) ; tél : 08 92 68 13 50 (0,34?/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =so-8859-1?Q?Thanh-truc_Nguyen? 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: Yechiel Adar 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
Let me share with you the reason that shutdown abort is not a good practice: One day, along time ago, a database on the mainframe (ADABAS in this case) come up after a power failure (don't ask, the UPS and the generators that are the backup power supply also failed) with a message that the power failure occurred while writing a block to the disk and the database is corrupted. SOP, restore and roll forward. The roll forward abended and we finished up restoring to the morning backup after 20 hours work. Net loss to the bank about 1/2 million dollars in lost revenues. My luck was that during the postmortem the supplier technical expert said I did the right thing. Anyway NOBODY assure you that the recovery process after abort will not fail and leave you with the need to restore and roll forward. As Tom said in the discussion about moving the clock back If I will suggest to my client to stop the DB for 1.25 hours So the 2-20 minutes savings can become a lengthy process. I will use abort in the rare cases where there is no other option but not as everyday practice. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 10:53 AM I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no fallback. The code that reads and writes to datafiles, on the other hand, is tested all the time, and if *it* fails, you've always got the redo logs. We use a script that tries to do a shutdown immediate and if that fails to complete in a reasonable time, does a checkpoint/abort/startup restrict/shutdown immediate. In a perfect world, the latter wouldn't be necessary because I would have investigated and cured every possible cause for shutdown immediate to hang, but a) debugging these problems is difficult and b) the effort involved upgrading to a sensible version of Oracle is not worth the (supposedly) limited lifetime of this database. Regards David Lord -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 23:44 To: Multiple recipients of list ORACLE-L Subject: RE: shutdown abort / startup restrict / shutdown vs. shutdown imm But if you are concerned that shutdown abort could corrupt your redo logs, then that is equivalent to mandating that all servers (that run oracle) must be on an infinite uninterruptible power supply. An instance failure (eg loss of power) is effectively a shutdown abort - so the only way to avoid that would be to have power available all the time. You couldn't have a UPS that is good for (say) 12 hours - because we can never guarantee that a shutdown immediate would finish in this amount of time - and you could not speed up the job with a shutdown abort because that is the cause of all the consternation in the first place If you're getting corrupt redo logs with shutdown abort, then you're exposed to corrupt redo logs anyway. Its not a shutdown abort problem, its a bug in either the oracle or OS layer. hth connor --- April Wells [EMAIL PROTECTED] wrote: That is EXACTLY what happened a week and a half ago. We had to do a shutdown abort because it wouldn't go down, and when we tried to restart it, it wouldn't come back... redo log corruption... and this being test... it isn't in archive log mode (another valid solution but no longer really an option in our case). After we can get back in to the building after the teeny little fire and vandalism thing we have going this morning and I can get all concerned parties in the same place (sans smoke and water) my suggestion is going to be that since we don't know why, and there isn't much of a work around yet, that test and development (at least for now) go into archive log mode, as well. ajw -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/02 4:09 AM Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly, this was on 7.1.4 (don't ask;-) David Lord -Original Message- Sent: 24 July 2002 01:33 To: Multiple recipients of list ORACLE-L imm I have steel belted radial tires on my car that are supposed to be puncture resistant. Is this a good reason for me to go out of my way to drive by a construction site every morning? By my way of thinking, no. If my regular road is blocked and I have no alternative, then I will drive by the construction site reasonably confident
Re: oracle 9i
We used it in testing and had no problems. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:58 PM We're doing that and haven't had any problems. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor 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: Carle, William T (Bill), ALCAS 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: Yechiel Adar 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: Install Oracle 8i on Windows XP?
Eric, thank you for your illuminating notes on the reason they hate us. blowing steamJust two points: 1)A few days ago a bomb explode in India killing 50 people. I did not heard ANY remarks from anybody condemning this. 2) All the people who cry for the Palestinians and demand they should have their own country does not give a shit about the Curds (for example) who are in worse condition. The Europe countries are basing their policy on Jew hating. /blowing steam Yechiel AdarMehish ISRAEL - Original Message - From: Eric D. Pierce To: Multiple recipients of list ORACLE-L Sent: Monday, July 29, 2002 7:03 AM Subject: Re: Install Oracle 8i on Windows XP? Absurd. Your intention from the beginning was to be a snobby jerk. http://www.weeklystandard.com/Content/Public/Articles/000/000/001/102gwtnf.asp Among the Bourgeoisophobes Why the Europeans and Arabs, each in their own way, hate America and Israel. by David Brooks 04/15/2002, Volume 007, Issue 30 AROUND 1830, a group of French artists and intellectuals looked around and noticed that people who were their spiritual inferiors were running the world. Suddenly a large crowd of merchants, managers, and traders were making lots of money, living in the big houses, and holding the key posts. They had none of the high style of the aristocracy, or even the earthy integrity of the peasants. Instead, they were gross. They were vulgar materialists, shallow conformists, and self-absorbed philistines, who half the time failed even to acknowledge their moral and spiritual inferiority to the artists and intellectuals. What's more, it was their very mediocrity that accounted for their success. Through some screw-up in the great scheme of the universe, their narrow-minded greed had brought them vast wealth, unstoppable power, and growing social prestige. Naturally, the artists and intellectuals were outraged. Hatred of the bourgeoisie became the official emotion of the French intelligentsia. Stendhal said traders and merchants made him want to "weep and vomit at the same time." Flaubert thought they were "plodding and avaricious." Hatred of the bourgeoisie, he wrote, "is the beginning of all virtue." He signed his letters "Bourgeoisophobus" to show how much he despised "stupid grocers and their ilk." Of all the great creeds of the 19th century, pretty much the only one still thriving is this one, bourgeoisophobia. Marxism is dead. Freudianism is dead. Social Darwinism is dead, along with all those theories about racial purity that grew up around it. But the emotions and reactions that Flaubert, Stendhal, and all the others articulated in the 1830s are still with us, bigger than ever. In fact, bourgeoisophobia, which has flowered variously and spread to places as diverse as Baghdad, Ramallah, and Beijing, is the major reactionary creed of our age. This is because today, in much of the world's eyes, two peoples--the Americans and the Jews--have emerged as the great exemplars of undeserved success. Americans and Israelis, in this view, are the money-mad molochs of the earth, the vulgarizers of morals, corrupters of culture, and proselytizers of idolatrous values. These two nations, it is said, practice conquest capitalism, overrunning poorer nations and exploiting weaker neighbors in their endless desire for more and more. These two peoples, the Americans and the Jews, in the view of the bourgeoisophobes, thrive precisely because they are spiritually stunted. It is their obliviousness to the holy things in life, their feverish energy, their injustice, their shallow pursuit of power and gain, that allow them to build fortunes, construct weapons, and play the role of hyperpower. And so just as the French intellectuals of the 1830s rose up to despise the traders and bankers, certain people today rise up to shock, humiliate, and dream of destroying America and Israel. Today's bourgeoisophobes burn with the same sense of unjust inferiority. They experience the same humiliation because there is nothing they can do to thwart the growing might of their enemies. They rage and rage. Only today's bourgeoisophobes are not just artists and intellectuals. They are as likely to be terrorists and suicide bombers. They teach in madrassas, where they are careful not to instruct their students in the sort of practical knowledge that dominates bourgeois schools. They are Muslim clerics who incite hatred and violence. They are erudite Europeans who burn with humiliation because they know, deep down, that both America and Israel possess
Re: 11i installation ???
Hello Leslie Did you remember to clean up c:\program files\oracle as well. This is where Oracle keeps the install log and files. I think that if you delete also this folder Oracle will start the install from fresh. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 8:49 PM Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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: Yechiel Adar 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: how to change nls date format.
Did you check the registry on the machine that you execute sqlplus on to see if there is nls_date_format there? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 7:38 AM Hi, The default date format for an instance is dd-mon-. Ex when issue the following statement Select to_char(sysdate) from dual; The output is 01-Jan-2002. I want to change this format to mm/dd/. According to Oracle documentation this can be changed @ sesion level by the following : Alter session set nls_date_format='mm/dd/'; ( alter system does not work). To change it @ the instance level, the following needs to be added in the init.ora file : Nls_date_format=mm/dd/. After starting the instance, when we check v$parameter, this change is reflected. But the same is not reflected while selecting data. Again when the sysdate select is issued the result does not change. The date format was not specified while installing Oracle or creating the instance, it was a default installation. Is there anyway to change this? Other Info on Database : Version Oracle 8.1.6 OS - Windows NT NLS_TERRITORY - AMERICA NLS_LANGUAGE - AMERICAN Charset WE8ISO8851 Thanks in advance Sunil Gompa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunil Kumar 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: Yechiel Adar 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: data modeling question - child table with multiple parents
I agree. If you have one client record and one supplier record put the address there without the need for separate tables. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 1:02 AM If this is the way you want it then why is the need for a separate table? I understand separate table is good when you have repeating groups (one-to-many) or it's an independent attribute/entity. -Original Message- Sent: Wednesday, July 31, 2002 6:27 PM To: Multiple recipients of list ORACLE-L igor: I agree with what you say here, as well as your previous comment about deleting a laid-off employee and then the extra step of finding the orphan addresses. Our developers have imbedded this inverse logic throughout the application. and now I'm left to try to figure out how to validate data and make sure the logic is accurately represented by the data model. I think I will ultimately end up with multiple address tables to support distributed data, proper enforcement of parent-child relationships via foreign keys (as opposed to triggers - don't like using them for r/i issues) as well as the concept of not mixing different conceptual data elements within the same table. Works for this case. -bill -Original Message- Sent: Wednesday, July 31, 2002 5:39 PM To: Multiple recipients of list ORACLE-L seems to me like a case of inverse logic. is it employee (or supplier, or whatever) entity, which has address attribute, or is it address entity, which has employee (or supplier) as an attribute? for me, it's the first: I'm not interested in any address, if it does not belong to employee, or supplier, or whoever... info stored in address table is just common set of attributes split from employee, or supplier table. and, if they'd stay in those tables, employee_id (or supplier_id) would be PK - not address_id. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 5:04 PM Since the ADDRESS table is just a look-up table, why not let it have a primary key for each address and then let the EMPLOYEE and SUPPLIER tables reference it with a foreign key? That does not prevent the EMPLOYEE and SUPPLIER tables from having their own unique primary keys. -Original Message- Sent: Wednesday, July 31, 2002 4:43 PM To: Multiple recipients of list ORACLE-L Good day, all: Am curious to hear opinions on how to model a child table that has multiple parent tables (i.e., foreign key to multiple parents) Example: There's a table that stores Addresses (table ADDRESS) for both employees (table EMPLOYEE) and suppliers (table SUPPLIER). Each of these tables has a Primary Key field called ID. One way to set this up would be for the ADDRESS table to have 2 fields, EMPLOYEE_ID and SUPPLIER_ID, which would be mutually exclusive (i.e., one or the other, to indicate the parent record of the address). Another solutions if for the ADDRESS table to have two fields to indicate the parent table name and parent table pk value. The first method enables me (the dba) to create foreign keys from the address table to each of the parent tables to validate data. The second method does not enable me to create such foreign keys (leaving it to the developers to validate date and insure referential integrity) but would also easily facilitate the addition of other parent tables (e.g., CONTRACTOR, VENDOR, etc.) without altering the ADDRESS table itself. Any and all thoughts, comments, opinions, experiences are most welcome. Thanks! bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: Clark, Tommy R 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