Single sign on
From dbi-users Personally, I use a password server daemon that supplies passwords to authenticated users, encrypted with RC4 as they traverse the network. Single sign-on in open source cool... That way I only need keep the passwords in one file. No passwords on the command line, which is handy for automated stuff. Since it is written in Perl ( based on a daemon in the Perl Cookbook) it has a native Perl interface as well as a command line interface. You can download it at new URL http://www.oreilly.com/catalog/oracleperl/pdbatoolkitPDBA-1.0.tar.gz You can buy the book too if you like, though it's probably not necessary for many folks on this list. :) Jared And an excuse too Thanks :) My Oracle bookshelf is pretty limited as there are a bunch of marketing and accounting manuals competing for space :( Unix in a Nutshell Perl in a Nutshell Oracle 8 The Complete Reference (just about time for an upgrade) and Velepuri's Backup and Recovery(not used often but just in case :). sed awk, Roberts RMAN Handbook and Pete Finnegans Oracle Security pretty well round out my regular references. Not counting the binders of man and pod printouts on DBI, Apache, mod-perl, etc from the early days, again, not used alot but needed. Thanks for the code, loading it on to my development server as I write Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
A Couple of does and donts
Hi All, Do not tune because a statistic looks bad Do tune because a luser says this is slow and is adversely affecting my productivity. Do not use MTS Yes I know there are a few exceptions, but in general MTS causes more problems than it solves. Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
DBMS_OBFUSTICATION
Hi All, The easiest way to protect the key is to create a package owned by the data owner and create functions within the package to encode and decode the data. Ensure the encryption key is defined in the package body. Grant execute privileges to the data entry schemas. The view ALL_SOURCE will only show the package header and not the package body This will not protect against rogue DBA's or network sniffing HTH Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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: copyright
Hi Tim, A few thoughts, It's a script - Oracle RDBMS is a bunch of scripts It was posted on the internet - Oracle is available on the internet Does this mean I can download Oracle, place it on my website legally, call it notoracle and sell it? Or I found this script on the web #!/bin/ksh # # File: oramem.sh # Type: UNIX korn-shell script # Author: Tim Gorman, Sagelogix Inc. # Date: 28jun02 # # Description: # # This shell script utilizes the pmap -x command to total up the # total amount of virtual memory used by all of the Oracle server # processes (both background and foreground) belonging to a # database instance. # # Modifications: # TGorman 28jun02 written for Solaris 2.8 How about if I put this on my website after I remove all references to yourself and SageLogix and claim to be the author? How about if I rewrite in bourne sh, keep all the references and post it? The first is definitely illegal, the second might be, (you don't explicitly give permission to copy the script, but accepted practise in the area is that attribution is enough). You will definitely be unhappy with the first, you might be proud you were attributed in the second. Some basic facts, Jared wrote it, Jared owns the copyright. The fact that he makes it publically available is irrelevant. Oracle is using his work, without attribution in a paid service. (Metalink, from which the page is now unavailable, gee I wonder why). A copyright is intellectual property, removal of a copyright notice is illegal. Consult SageLogix's lawyers, mine would have loved to work for Jared, would have done it on contigency basis. Bad manners is not an acceptable legal defence. This has everything to do with copyrights, patents, and theft. Personally, I think it adds to Jared's reputation but what happens if this is not challenged and 5 years from now they come back at Jared and say you are distributing one of our scripts? Defending oneself in that situation would be impossible. Tilting at windmills. Protesting illegal actions taken by large corporations is futile? Standing up for ones rights is pointless? Come to Canada where we know how to treat monopolies ;-) Badly An apology, for protecting his intellectual capital, especially since the offending page has (again) been removed. OK. Jared, if I have interfered unseemingly in your life I am sorry, but I think minor issues like this can hve very wide ramifications. However, this belief does not give me to right to interfere. I did not email Oracle, the only comment was to this forum. Dave From: Tim Gorman [EMAIL PROTECTED] Date: Mon, 10 Feb 2003 21:12:17 -0700 Subject: Re: dump.sql This has nothing to do with copyrights, patents, reputation, or IP. It's a script. It was posted on the internet. Nothing more than a case of bad manners. There is no disservice in not tilting at this particular windmill. You owe Jared an apology. -- -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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: dump.sql
Hi Jared, I think a letter to the Redwood Shores police department alleging IP theft and asking them to investigate may be effective. I believe copyright in it's current business model is dead but since everyone's reputation is based on their copyrights you can not allow this theft to continue. If you do you are doing a disservice to everyone. Dave Jared wrote ... It may also be found at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1050919.6 Yes, it's back, still without credit. Please, no 'piracy' emails to Oracle about it. Jared -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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: Hot backups vs RMAN, the rebuttal
Hi Jared, Responses in line. Jared Still wrote: I think your list of reasons for using RMAN is incomplete. The database backup window may need to be shrunk not because the database is so big, but because there are a lot of systems to backup, and they use a lot of time and tape. RMAN backs up blocks, hot backup backs up files. Agreed Yet many sites do not have this pressure on their backup window. These sites often panic when one of the incrementals is corrupt/not found. Mind you the same thing happens with hot backups, What do you mean we can recover from 2 different backups? It's just easier to do and explain at the file level. And I admit I have a prejudice against block level backups as I was trained by an old-timer from the mainframe days in the 60's who swore the best thing that ever happened in his career was when filesystem backups became possible. This is probably a myth now that should die, but old prejudices die hard. Also, finding and retrieving the correct files for restoration is rather tricky when using a tape library. It can be somewhat error prone. A recovery at odd hours doesn't help much. When you have an automated repository that can be told 'restore database', and it knows the file names to request and makes that request to the tape management system, restores are simplified. This is the problem for the tape management system, I can tell netbackup (Veritas) Give me the backups from this filesystem on this machine at this time or Give me the files from this backup job run on this date I can restore to any machine and/or any SID very easily. Once you are past as simple recovery in RMAN, (ie a file is corrupt, you have to change the SID, naming conventions on your redo logs are messed up because filesystems are full) it becomes much harder. Not impossible, but much harder. The management of backups once they are on tape is a sysadmin task, the DBA tells the sysadmin the date and the job he wants restored. SQL Backtrack was good for that, and now RMAN. Our tape library is rather small, and I'm still thankful that I don't have to browse it for database files to do a restore. At a previous employer, we used a couple of StorageTek silos: you don't really want to browse that to get all the correct files for a database. Try it when you have several hundred files. But tape libraries are just about always managed by a backup manager whether it is Veritas, Legato, Omniback I don't browse, I request date and job/filesystems, restore all the files. StorageTek, you lucky guy, I probably wouldn't mind browsing just for the pleasure of playing with the new toy :-) Dave, it seems that you do work for clients scattered all around, hot backups probably works best for you. Yes, RMAN adds some complexity. It also adds some power and efficiency. I agree, big complex sites have to use RMAN, maybe. If you have various versions of Oracle how many versions of RMAN do you need? Makes the site even bigger and more complex. And yet at alot of the places I work where they have ample disk and space I leave RMAN running because it is quicker to restore simple failures and it is a useful traing exercise on what dependencies can do to your availability. RMAN is administratively expensive. The hot backups at these sites are solely used for cloning and complex recoveries. Just test those recoveries. :) Amen, I can not emphasis this point enough, hots, colds, RMAN or hardware array splits, test your recoveries. If you have done it before you will be able to handle the crisis when it occurs. Jared Dave Off to interview for a contract where they do nightly colds and yet when I ask if they can afford a day's loss of data/work answer Of course not -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
RAC on Linux vs Support
Hi All, RH is nothing more than a kernel and libraries. If you have the correct kernel, (and OWS does not ask about compiled in options) and the correct libraries, lie and say it is RH whatever. There are a couple of good analysts in OWS who do understand the the OS is Linux not Redhat. Personnaly I file less TARs for Linux than any other OS, and my work is split 40% Linux, 40% Solaris, 10% HP and 10% AIX. And I like AIX best of all. That mainframe heritage shows! It's no wonder that some sysadmins get frustrated with DBA's. If anyone came to me and said it's not working because it's Redhat 6.2 instead of Redhat 7.3 I would say, and I quote ARE YOU AN IDIOT? and then start him/her on a serious reading program. Oracle runs fine on any of the 2.2.4 and greater kernels as well as any of the 2.4 kernels. Please note this is not a definitive list Joe, run with raw devices and you should have no troubles. Iam not sure what kernel they appeared in but I have not used openssi but I had alot of fun playing with Beowulf when it first came out. Not that I ever got it successfully running, but it was fun :-) Currently running a pre-prod 8.0.5 on Slackware 1.12 (patched to kernel 2.2.10) doing 100 test transactions a day with a continuous uptime of 388 days. (The only reason it is still around is because of the uptime :-) And various Oracle 8.1.6, 8.1.7 on Redhat 6.2 patched to 2.4.19 in production across Europe and NA. Technically every single one of these instances is unsupported. Yet they rarely give their owners problems. It gives me problems because I have to keep looking for new work instead of living off of old work. Maybe I should go back to living off Windoze? :-) Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
Hot backups vs RMAN, the rebuttal
Hi All, I followed the recent RMAN discussion with some amusement. I get alot of my work rescuing sites that are using RMAN yet do not understand it. RF, your book is invaluable for this, thank you. First: no matter what method you use to backup TEST YOUR RECOVERY method. We don't need no stinking backups, we need recoveries :-) When to use RMAN: Your database is so big you cannot meet your backup window. Your database is so busy the system cannot handle the redo log generation Other than that, why do you need the complexities? Why do you accept the additional dependencies? Why do you accept the uncertainties? Steve, I hate to say it but backup and recovery is and should be boring! Rebuttals to other reasons: From TG: RMAN checks for corruption in archivelogs By the time I am writing archive logs to tape it is too late. The instance could be in trouble already. Archive log multiplexing (since 8.??) is the only guard against this. From RF: What if you don't understand the script? So the poor DBA has to read some man pages? At http://www.100.com I have posted a simple shell (bourne) script with environment file that does dynamic hot backups to disk and has been tested on Oracle versions 6 through 9 and on Solaris, Linux, AIX, SGI and HP. I have heard from another that she had it running under CGWIN on Windoze. Advantages: deploy in 5 minutes integration with Veritas, Legato and other backup managers is a one line change use of tar, cpio or ufsdump is a one line change use of bzip, compress, gzip is a one line change it's simple, reliable and works just about anywhere backs up up all init.ora files, all network.ora files creates and backs up a ASCII control file backs up all binary control files cloning from the backup is trivial easily modifiable Disadvantages raw tape handling has been removed as most of the complexity in tape backups for Oracle is dealing with the tape drive. you should understand the script before you run it but then you should understand RMAN before you use it too Along the backup script I have posted two monitoring/tuning scripts. As a contractor I often cannot install anything in the SYS schema. This scripts create no objects in the database at all. Everything is done with inline views and anonymous PL/SQL blocks. I will be posting scripts in the future. The majority will be in bourne shell (run anywhere is important) and will deal with fulfilling Oracle's needs in the OS. I have no desire to duplicate what is already on the web but I have noticed there is a shortage of OS level maintenace scripts. vi and sqlplus are my tools, until .. 4 AM MST, it's London Calling (apologies to the Clash) Dave our db server crashed it's available again but we have a corrupted /usr/bin, a couple other minor file systems are missing and Oracle is complaining about a control file missing Easy, one line change in init.ora with what? /usr/bin/vi :-) My first experience with ed. I tolerated vi before, I love it now :-) -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
US Travel for the DBA
Hi All, The only reason I am posting this is because I have defended America on this list and elsewhere before. I wish this to be taken as one best friend speaking to another. Background I was born in Bahrain (Persian Gulf) and left there when I was six months old. I have two passports, Canadian and UK. 30-40% of my work is in the USA. Due to the new INS regulations I am photographed and fingerprinted when I cross the border I have to check in at an INS office when I arrive at my destination I have to check in at an INS office when I leave my destination Use of my other passport to enter the US will define me as suspicious Please note, this in no way prevents me from working in America, however, I can no longer go skiing in Whitefish. (The nearest INS office is 2 hours south in Missoula, I believe) Walt, Steve, whats the snow like in Bozeman this year? I'm allowed to go skiing there. :-) Sigh .. Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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: RAC on Linux vs Support
Hi Jared, But then running Oracle is a non-trivial exercise At least for me ;-) Dave [EMAIL PROTECTED] wrote: Dave, Of course, upgrading the kernel on older versions is not always a non-trivial exercise. Jared Hi All, RH is nothing more than a kernel and libraries. If you have the correct kernel, (and OWS does not ask about compiled in options) and the correct libraries, lie and say it is RH whatever. There are a couple of good analysts in OWS who do understand the the OS is Linux not Redhat. Personnaly I file less TARs for Linux than any other OS, and my work is split 40% Linux, 40% Solaris, 10% HP and 10% AIX. Snip ... -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
SANS Oracle Security Book released
Hi All, SANS has just released the Oracle Security Step-by-Step Guide. http://store.sans.org It is a typical SANS guide ranging from the most basic security steps that every site should use through to the most anal security actions that are totally impractical in the real world. The author, Pete Finnigan, has gathered input from over 60 Oracle professionals (many from this list) and spent almost a year producing this best practises manual. Highly recommended Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
OT Posts vs HTML posts
Hi All, Jared, I find it funny that complaints about offtopic posts are effective (move to the OT list, which I refuse to join because of the hoster's privacy policy), however, complaints about HTML in emails are ignored. A recent Oracle-l digest was 1.2M when it arrived at my server and only 380K once the HTML was stripped out. OT posts are hard on people who use Lotus notes, HTML is devastating to contractors who do 60% of their work with PDA's and wireless (both WIFI and cell) If there are to be these limits can we not move to a model similar to the dbi-users maillist where OT's get nicely flamed and HTML does not appear. Just my $0.02 CAN ($0.013 US) Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan 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).
Tuning methodology (was T3's) and use of NetApp's
Hi Cary Thanks for the feedback, comments inline Cary Milsap wrote Some questions and a couple of comments regarding Dave's note: 1. RE the tuning from a blue collar DBA perspective, is it accurate to paraphrase the described method as: No matter what might be causing the performance problem, check this List Of Things first, using tools that vary significantly from one platform to the next. ? Well, I hoped I demonstrated how on at least one platform. My solution for another platform, if vocalized, will start another of these tedius OS religious battles I was trying to say that complex tools and traces such as tkprof and event 10046 are of no help if you don't understand the underlying system and SQL. Despite what is said there are uses for database ratios. Some such as disk vs memory sorts are vital to throughput. Ignore the fact that it is imperfect and use explain plan to look for inappropriate FTS. The payoff in quickly catching unecessary I/O, both physical and logical, overrides the need for detailed analysis Then is the time for tkprof, setting events, changing the optimizer and such 2. Dave is multiplying Oracle's time statistics by 1/1000 (wrong) instead of 1/100 (correct). Oracle is really reporting 'db file sequential read' average latencies of .311cs = 0.003s (not 0.0003s), 'db file scattered read' latencies of .506cs = 0.005s (not 0.0005s), 'db file parallel write' latencies of 3.036cs = 0.030s (not 0.003s), and so on. (Dave's I/O subsystem has consumed an average of 30ms for each 'db file parallel write' call.) I don't know why but I seem to have alot of troubles with decimals on this list. Sure don't have the same problem with cheques :) 3. Note that it's only because the data are collected system-wide that it is necessary to ignore the 'SQL*Net%' events. This is a waste, though, because with properly time-scoped session-level data, the 'SQL*Net%' events constitute probably the easiest way to detect when you have bad applications code (not the SQL, but the stuff that calls the SQL). I agree the data is a waste but many do not know this and worry needlessly. So at the session level the SQL Net events allow me to troubleshoot the applications server. Cool I continue to learn. 4. 'db file sequential read' does *not* typically indicate a full-table scan, because 'db file sequential read' events, since Oracle8.0 are almost always single-block read calls (before that, the event could indicate multi-blocks reads of sort segment blocks into a PGA). Does this parameter measure anything then? 5. 'LGWR wait for redo copy' is *not* affected by the archiver not keeping up. The alert log *is* a better way to detect this (because 'LGWR wait for redo copy' doesn't detect it at all). An even better way is to look for occurrences of 'log file switch (archiving needed)'. 6. 'latch free' -- Question: Does anybody know what total_timeouts means for the 'latch free' event? I see nothing in v$latch that possibly corresponds to something that could be called a timeout. And nothing I notice that these numbers often climb when Oracle has to be aggressive in reclaiming shared pool memory because of literal SQL. I find that reducing the shared pool to as small as possible while storing the data dictionary optimizes performance (even if it's still bad) which are reflected in these numbers. The many bugs in the shared pool memory handling in many 8i versions often show up here too. Thanks once again Cary. On to other stuff At my current contract I am using a NetApp filer as an archive machine and I am extremely happy with how it has worked out. Archive logs are stored locally on a T3 and through NFS on the filer. MIN_SUCCEED_DESTINATION or whatever is set to one. If the NetApp disappears oracle keeps chugging along writing the archive logs to the local array. All hot backups are put on the filer. I would be extremely hesitant to use it for any other files. I do have to be careful with the timing of my backups as it is pretty easy to overwhelm the appliance when copying files in. Dave Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
T3's, NetApps, Tuning, Wife's Opinion and other fun
not critical ;) SQL*Net break/reset to client 92904 0 9522.102 - Client communication ignore LGWR wait for redo copy 92844 7 736.008 - Affected by the archiver not keeping up. The alert log and an infamous ratio - are better ways of detecting this. file open 76910 0 1874.024 - note the number of occurances is getting very small, average time is low, ignore direct path write 69706 0 1408596 20.208 - writes for sorts, even though average time is high, research indicates that - the client does not wait for this, so internal ignore SQL*Net message to dblink 48680 0 7 0.000 SQL*Net message from dblink 48680 0 108414 2.227 - network or machine dependant ignore control file sequential read 45198 0 31664.701 latch free44849 30305 28693.640 - Memory latch contention, notice rate of Timeout to # of waits - If average time increases, need to determine why contention is increasing - QUICKLY SQL*Net more data from client 43851 0 229528 5.234 enqueue 19946 19380 5973595 299.488 - I used to worry but , nothing ever happened so ignore - And the rest happen so infrequently ignore file identify 6961 0 496.071 smon timer 66396612 203366288 30632.066 log file single write 2770 0 2998 1.082 rdbms ipc reply1290 0 2302 1.784 log buffer space 1104 1 5507 4.988 db file single write924 0 162.175 log file switch completion 743 8 17454 23.491 refresh controlfile command 722 0 413.572 pipe get377 213 81693 216.692 library cache pin 316 0 152.481 control file single write 231 0 164.710 library cache load lock 72 6877 26.069 single-task message 68 0 49.721 switch logfile command 45 0 815 18.111 process startup 16 0 94 5.875 SQL*Net more data from dblink16 0 0 0.000 row cache lock5 0 0 0.000 db file parallel read 3 0 7 2.333 instance state change 2 0 0 0.000 Null event1 1 410 410.000 reliable message 1 0 0 0.000 sort segment request 1 1 103 103.000 And the more you study your database the more you will understand of the above :) After you are aware of your systems problems, fix your config files and file positions and then chase down SQL issues. From your users, capture the SQL run explain plan Run top, catch processes that use a full cpu for more than 30 seconds Capture the sql, run explain plan I have always ogled women. When I got married, (well started going out) I explained to my wife that I was making sure I had the best. But really, she's a good wife, I'm even allowed to have opinions. If she approves of them I'm allowed to have them :) The digest hit 983K on Friday, if I'm kind, 100K was content. From the titles I see that there were performance problems with partitioned tables and bitmap indices? I can't help those who won't help themselves. And I don't receive HTML email. TTFN Off to figure out the relationship between multiblock_read_count and those index_optimizer thingies Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
8.1.7 7.3.4 on one listener?
Hi All, Is anyone running versions 7.3.4 and 8.1.7 using the SQLNet8 listener? Haven't tried with 8.1.7 and I don't want to assume it works just like 8.1.6 . Been there, . No MTS Solaris 2.6 Also anyone running SUN T3 arrays? Advice? I'm starting to believe SAME is a cult New work email addy is [EMAIL PROTECTED] Life has been interesting lately Axed on the Tuesday after Victoria Day holiday, (May 20) after spending the weekend deploying a new product involving 2 existing schemas, a new encrypted credit card dataset, and our first real data exchanges with outside companies. My boss got the ax the same day The sysadmin quit as soon as he heard this. The webmaster quit 2 days later ROTFLMAO for days, weeks, months I was just starting to enjoy my holidays when I found work :) :( :) :( :) :( :) I'm in digest mode, which is now over 0.5 MB daily hint hint TIA Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: online backup and alter system switch logfile
Hi All, You do not need to archive the log files. Alter system switch logfile does not return until the logfile is written to disk. For recovery purposes the location of the logfile does not matter as long as it has been written. Archiving and hot backups are totally seperate processes. Alter system switch logfile For each tablespace start backup mode backup datafiles end backup mode Alter system switch logfile No archiving necessary, let the archiver do it's job so you don't have to. Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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 IMPORT Urgent
In digest mode so sorry if I'm late :) These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything I believe the tables will still be owned by the original user. We probably should see the export script and log imp sys/change_on_install fromuser=orig_user touser=ravi file=g.dmp log=g.log ^ When import is successful there is a list of tables, rowcounts and other object creation stuff. As Kimberly said ignore the characterset warning, one's a subset of the other Good luck Ravindra Dave -- Dave Morgan [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: persistent connections vs. login/logout white papers anyone?
Hi Robert, When I signed on at cybersurf the webserver (apache/perl/DBI) was handling 500 - 900 clients at any one time and the listener process took the most CPU as defined by top. The database server was pinned and everything was failing. By adding mod-perl to the mix (for caching database connections only, all the code was still running as a normal cgi) the listener dropped to usual CPU levels and the machine went to about a 30% CPU utilization. The one caveat is ensure that the webserver has a is fairly aggressive about shutting down idle connections or the database server will swap out the server side process causing shorter but still annoying delays. Also use dedicated servers as the MTS has problems dealing with long winded connections. HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Favourite Urban Myth
The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: RMAN
Hi Lisa, Steve, But what advantage do you gain by taking the two days to install RMAN? The only one I can think off is the block level backup but that can create problems of it's own. They used to do block level backup in the 60's and gave that up because of the complexity. Disadvantages: - another database to backup - another dependency (h I hate those) - upgrades and version conflicts My scripts do hot backups to disk or tape, allow choice of tablespaces and will backup tablespace files in parallel according to the number of CPU's. The last major change I made to them was from Oracle 6 to Oracle 7.0. The biggest advantage is that the procedure to recover every database is exactly the same. RMAN starts with which catlaog do I connect to. My recovery command (for the easy ones at least) is: recover database auto in svrmgrl. Apart from that, DBA's who have never used anything but RMAN may be able to recover but usually do not understand the underlying concepts and so are unable to figure out what to do when problems during recovery arise. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: max_open_cursors
Hi All, max_open_cursors of 2000? What programmer can handle 2000 open cursors at once? Remember this is per session. The default is 40, if a programmer can explain to me the cursors he has to maintain open, and that number is 40 then I will increase the number to 100. This has happened to me once in 10 years DBAing (and the programmer was one of these brilliant people where I just nod my head in awe when he speaks :) 2000 open cursors is a code problem. Happens alot in JAVA where they will not finish/close their result set. Dave Mogens wrote: It can be set to much higher values if the need is there. There used to be some kind of limit depending on the various 7-versions as far as I remember. Personally, I haven't seen the need for anything higher than 2000 more than once or twice. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Trouble ticketing system
Hi David, Look into REQUEST TRACKER. Open source (perl), many databases. Similar to Remedy byt free. A Google search will find it. Why code when you can install? Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Do programmers tune SQL?
Isn't this the DBA's eleventh commandment Rachel's Mother wrote: I'm wrong, I've always been wrong, I will always BE wrong, let's move on from there. As for the programmers I would rather write (right) the SQL for them as it means I don't have to deal with their SQL later. And I write lousy SQL Stored procs are the way to go. That way when you get a good programmmer he can rewrite them for you. In my dreams at least :) Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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 Modelling Tool
Hi Eva, I find all data modelling tools create lousy SQL so the DBA ends up rewriting the SQL anyway. Having said this I use tgif on Linux (other Unisexes also). Similar to Visio except it has a link feature that allows you to edit the actual SQL in the text file without disrupting your pretty pictures. http://bourbon.usc.edu:8001/tgif/ HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
OT Now - was RE: screen
Well, concurrently could be difficult, but consecutively The use of screen allows more time for sex and skiing, after which I have to sleep and eat sushi to recover my energy :) Robert and Rachel (RR) wrote: I was just hoping it was really a list. If they were concurrent we might never be able to look Dave in the face again -rje RC In that order? pleae tell me it's just an alphabetical list :) RC --- Dave Morgan [EMAIL PROTECTED] wrote: A list of Dave's favourite things: Snip S:screen, sex, skiing, sleep, sushi Snip Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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:Hot backup and TEMP tablespace
ALWAYS BACKUP THE ROLLBACK TABLESPACE! or you will not be able to recover. How else will Oracle rollback a transaction in the works when the database went down. I do not back up TEMP or my INDEX tables spaces. I have scripts that recreate all of these. (150GB of indices, not worth the tape.) And while I use RMAN for backups I do all my recoveries from the our scripted hot backups. I also practise recoveries every 6 months. RMAN backups fine, it's recoveries it has trouble with :) Why? There is limited flexibility with RMAN along with an added dependency. As most know I loathe unecessary dependencies. An Example: power surge blows out Machine and hub/router power supply. Machine automagicaly fails over to alternate power, however, the hub/router needs servicing. Your RMAN catalog is on the other side of the hub/router. What are you going to do now? And yes, as I keep saying, I am paranoid. Dave Tom wrote: steps just to save yourself some time during backups? Why stop at backing up the TEMP tablespace - why not the ROLLBACK tablespace - this could be dropped and re-created also. Why not INDEX tablespaces - heck, if you have the scripts, these could be re-created too! -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: multiple extents are OK, dagnabbit!
Hi Jeremiah, The problem arose in the catalog upgrade script. It would never return. My diary says we let one attempt run for 36 hours. The process showed CPU usage and I/O but nothing happened. Some of the Oracle guys figured the problem was with the $fet (or whatever tables hold the extent info, I never bother with the internals of the data dictionary) having problems while being restructured. Once the tables were changed from 40K to 500M extents the upgrade took less than 2 hours. One of the suggestions I did not use was to edit sql.bsq to provide much larger extents for the table holding the extent info. Even though I do this for the SOURCE$ table I am a big fan of the KISS principle and rebuilding the tables needed to be done anyways. HTH Dave Can you elaborate on exactly what happened? 8.1.5 to 8.1.6 is just a catalog script and a binary change. What error did you encounter, and at which step in the upgrade? Extents should not matter in an upgrade. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: multiple extents are OK, dagnabbit!
Hi All, Actually, in extreme cases ( 87000 in my case, and I had 12 tables like that) it can cause problems with upgrading. Not sure what, but we had to do CTAS into new tables with much larger extents to do the upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants baffled also I still like to keep the number of extents below 500, but I'm paranoid :) Dave Rachel wrote: Snip There really is NO reason to worry about large numbers of extents these days. I mean, I wouldn't want to really test the unlimited ability but other than that, there is no problem. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Returning multiple rows as a single row
Hi All, I know I've seen this before but I forget ... Given a table like Customer_Software( Custid Number SoftwareVarchar ) How do I return the customerid and all the software entries in a single row? Desired output is like Custid -- 1 Excel Word StarOffice 2 vi tgif oracle ... I know it's a group by with a subquery but TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Listeners listening to multiple IPs
Hi All, Yet I hard code IP addresses into the listener.ora (I do not want the db server to be dependant on another server, if DNS is down the listener will not come up) and I have no problems having it listen to multiple IP's, either as two listener's with different names or one listener listening on 2..n IP addresses. Just add another DESCRIPTION/ADDRESS entry to the DESCRIPTION LIST in listener.ora. Been this way since 7.2.2.4 I think. Client side tnsnames is different, follow Rachel's advice. Dave Rachel wrote: Subject: RE: Listeners listening to multiple IPs well yeah... that's the whole point of USING DNS, so that it will work like that --- Djordje Jankovic [EMAIL PROTECTED] wrote: I am not talking whether putting DNS entry works, but am just pointing to the fact that oracle behaves differently if you put hardcoded IP - it than listens to one IP only, and if you put the dns name - listens to all IPs. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Standard SQLNET.ORA with multiple O_HOME's
Hi Stephen, I configure all our SQLNET stuff in a directory called ora_net under the oracle users unix home directory. I then create links from the various ORACLE_HOME/network directories into the /home/oracle/ora_net directory. Works like a charm. Advantages are it removes your listener logs from your binary disk and you have a single directory to backup to save all the listener configurations. HTH DAve Stephen wrote: Greetings fellow listers,=20 We are starting to make the changes to sqlnet.ora files, I discovered that = we have 9 separate files on one particular. Most of the file is identical = with the only variance appearing to be in the SQLNET.EXPIRE_TIME value = which ranges from 10 to 300. =20 I'm thinking that we could have a single file (maybe in /etc/) and create = OS links from the various $ORACLE_HOME/network/admin/sqlnet.ora files. = Has anyone tried this or know of any reason why this wouldn't be a good = idea? We also have quite a number of hosts and have a standard tnsnames.ora that = we ftp from a master location on a nightly basis and would like to do the = same with a standard sqlnet.ora. Any thoughts? -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Partition attached to Synonym
Hi All, Once again sinking into the depths of Oracle code. BUG INFO Bug:1716968 / Bug:1273906 Base Bug:743019 Fixed In Ver: 9.0.2 Abstract: CANNOT DROP PARTITION IF ADDED VIA SYNONYM - ORA-2149 Still waiting for instructions on how to cleanup my data dictionary. Oracle support can reproduce it and feel that's enough. Sigh Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
More Partition attached to a synonym.
Hi All, First off I did not receive the digest last night so if someone could forward me the digest or resend any emails on this topic directly to me it would be greatly appreciated. In summary, a table partitioned on the first of every month had a partition added when using a synonym name in the ALTER TABLE ADD PARTITION statement. The partition shows up in DBA_TAB_PARTITIONS associated with the synonym name There is no entry in DBA_SEGMENTS for the partition. The partition is currently 800MB in size and holds 15 million rows DML and data access on/to the data in the partition is fine. from OBJ$, the 2 problem entries and a good one OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE# CTIME -- - -- -- - --- 3383 39 IMPRESSIONS 15 29-MAR-01 20817 20817 39 IMPRESSIONS 1 IMPRESSIONS_2001_08 20 23-JUL-01 20578 20943 39 IMPRESSIONS_TAB 1 IMPRESSIONS_2001_06 19 29-MAY-01 IMPRESSIONS is a private synonym (owned by the table owner) for IMPRESSIONS_TAB I do have a copy of the data, so I can drop the synonym., table and tablespace but I am worried about my data dictionary. TIA Dave Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Partition attached to SYNONYM
Hi All, Just found an archive at http://faqchest.dynhost.com/prgm/oracle-l To answer Jonathan's questions: It is an LMT It is a standard partitioned table. I know the tablespace the segment is in so I can get rid of it. I can extract the data from the segment. My main worry is data dictionary consistency after I clean up. Off to research DBMS_SPACE_ADMIN Thanks Dave Jonathan Lewis wrote Remind me, Is it a locally managed tablespace ? If so, get on to Oracle about the following idea. a) Export the data from the extent b) Use dbms_space_admin to make the non-existent segment appear/disappear If not, is there even an entry in UET$ for the extent ? Is this a standard partiitoned table, or a partitioned IOT ? If standard, there MUST be a segment, because dba_tab_partitions CANNOT report a partition without joining to the matching seg$ row. Jonathan Lewis Clearly this hasn't happened ;) But if the item shows up in dba_tab_partitions then there is a data segment linked to the partition. Get the SQL from the view dba_tab_partitions, you will see that the first section of the 3 unions is for tabpart$, and it joins tabpart$ to seg$ on file#' and block#. Clip out this bit of the sql, and select out the file# and block# for the funny partition. Then use those values to query the file and block against dba_segments to find out what data segment is actually being referenced. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: PARTITION attache to SYNONYM
Hi Jonathan, Oracle 8.1.7.0 on Solaris 2.8 (5.8 or just 8). It is a private synonym owned by the table owner. Strange indeed, there is no record of the partition in dba_segments. All the other partitions show up, (with the correct owner) and the app is still loading August data. Where is what I am wondering now? Sigh All I really need to know is what happens if I drop the underlying table, the synonym and recreate the synonym to point to a new table. Thanks for your assistance. Dave From: Jonathan Lewis [EMAIL PROTECTED] Date: Tue, 7 Aug 2001 20:15:30 +0100 Subject: Re: PARTITION attache to SYNONYM Which version of Oracle ? I got a 600 error when trying to create a partition when using a public synonym instead of the table_name on 8.1.7.0 Have a look in dba_segments for segment_name = 'your table name' and segment_name = 'your synonym', check especially the OWNER in case something very strange has happened. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 August 2001 19:57 |Hi All, | Wondering if anyone has seen anything like this. I have |filed a TAR. | | When adding next month's partition to a table a synonym was | used accidently. However, the partition was created and shows | up in dba_tab_partitions. However, I cannot modify of drop the | partition. | | ALTER TABLE synonym_name drop PARTITION partition_name; | returns no such table | | ALTER TABLE table_name drop PARTITION partition_name; | returns no such partition. | | I have built another structure to hold the data but does anyone | know the consequences if I dorp the ysnonym. | |TIA |Dave | | |-- |Dave Morgan |DBA, Cybersurf |Office: 403 777 2000 ext 284 -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: PARTITION attache to SYNONYM
Jonathan and others, And some more information. I love my job, I love my job, ... I have 15 million rows taking up 840 MB in a tablespace that has no segments or extents (In a partition that sort of exists, or sort of not exists) The data is updatable and readable. Did I mention that I love my job. TIA Dave Dave Morgan wrote: Hi Jonathan, Oracle 8.1.7.0 on Solaris 2.8 (5.8 or just 8). It is a private synonym owned by the table owner. Strange indeed, there is no record of the partition in dba_segments. All the other partitions show up, (with the correct owner) and the app is still loading August data. Where is what I am wondering now? Sigh All I really need to know is what happens if I drop the underlying table, the synonym and recreate the synonym to point to a new table. Thanks for your assistance. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
PARTITION attache to SYNONYM
Hi All, Wondering if anyone has seen anything like this. I have filed a TAR. When adding next month's partition to a table a synonym was used accidently. However, the partition was created and shows up in dba_tab_partitions. However, I cannot modify of drop the partition. ALTER TABLE synonym_name drop PARTITION partition_name; returns no such table ALTER TABLE table_name drop PARTITION partition_name; returns no such partition. I have built another structure to hold the data but does anyone know the consequences if I dorp the ysnonym. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Snapshot shows as INVALID in DBA_OBJECTs
Thanks Anita, I filed a TAR, altered my catalog.sql, recompiled 360 invalid objects, and now: It shows up in DBA_OBJECTS as a MATERIALIZED VIEW, but the status is still INVALID, and the last refresh data is shown as 1950 I don't think this morning is 1950 but I've been wrong before :) Sigh .. And metaStink is basically down this morning so . I'm still confused :) Dave A. Bardeen wrote: Dave, As someone else pointed out, this is a known bug (1188948). The issue is not with the dd, but that the view for DBA_OBJECTS did not get updated to handle the new object type value for materialized views. If you check the view definition (should be in catalog.sql) you'll see a decode statement that determines the object type. It doesn't have an entry for type 42, the new type for materialized views/snapshots, so that's why they're listed as undefined. You can manually change the view definition, just keep in mind that you'll need to change it again after applying a patchset if the patchset replaces catalog.sql. It doesn't interfere with the way the snapshot/MV works, so it's considered annoying, but harmless. The script is fixed in 9i. HTH, -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Snapshot shows as INVALID in DBA_OBJECTs
Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
OT RE: Digestive DBA special
Hi Ian, I don't believe it can be Admiral Nelson as The Maritime Museum in London has the shirt he wore when he died (Trafalgar, 1814 ?)on display, white with brown blood stains Another interesting point about the museum is that if you have an ancestor who was a British Navy Captain and you give them 48 hours notice, they will pull the official portrait (oil painting) for you to view. Dave Ian MacGregor wrote The wearing of the red shirt to hide a bloody wound is usually said of Admiral Nelson. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
News: Technology and the corruption of copyright
Hi All, In light of the recent discussion here is an alternate view. http://www.zdnet.com/zdnn/stories/comment/0,5859,2770541,00.html Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: What is Quorum device ?
Hi Sinardy, The following is from IBM on one of there SSA's (Serial Storage Array, similar to RAID, different hardware implementation) Assuming you have a form of mirrored disk with two disks for each mirror then a Qurorum setting of 2 would require both disks to be available and containing matching information before the device will show upon boot. Therefore always leave quorum set at 1 otherwise the mirroring will not improve your availability. If the mirror involves 3 disks then Quorum determines how many of the disk need to be available before allowing access to the disks. A setting of 2 requires 2 of the disks to be available etc, etc, etc. Unless your system is critical, life or death, (ie: medical information, realtime air traffic control etc) there is really no need to set quorum larger than 1. If the info is critical and verification of data accuracy is required then at least triple mirror and set quorum at (# of mirrors - 1) EVIL For a junior dba or sysadmin, (on a test box) shutdown the db set quorum = # of disks in the mirror, dd one of the datafile blocks on one of the disks reboot the box and ask him/her - sysadmin, make the array accessible - dba, bring up the database tell all the sysadmins/network admins to watch the fun /EVIL It's a cruel but effective piece of training HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Oracel Support was Re: MaterializeRe: Snapshot Logs Explanation Needed
Hi All, Anita is absolutely right. Before making any changes to the data dictionary call Oracle support. Before using undocumented parameters call Oracle Support. Before doing anything that you do not know all of the side effects for, CALL ORACLE SUPPORT!!! You pay them enough, so use them. Dave A. Bardeen wrote: Dave, /* SOAPBOX ON */ I'm well aware that hacking the data dictionary is possible, but you'll never see me advocating that on the list. I believe hacking should be done only as a last resort to save a db or avoid rebuilding it and even then should be done only under the guidance of Oracle Support. In many cases even they won't let you make the changes, but will require dial-in access so they can make the changes to ensure that they're done properly. Since there are virtually no PK/FK relationships defined in the data dictionary it's far too easy to miss one of the relationships and end up with a corrupted dictionary. Said corruption may not manifest itself until days, weeks, or months later, at which point you'll have a bigger and messier problem than the original one. So even if you practice this on a test db and it seems to work OK, it might just be that you haven't performed the operations that would reveal the corruption. Definitely not something I want to attempt via email. IMHO the disclaimers backup first and use at your own risk are insufficient. /* SOAPBOX OFF */ -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi Anita, I'm not sure if you are the original poster but There is a way to force a view into fast refresh mode after you have restructured the snapshot logs WARNING: This is unsupported by Oracle and involves messing with the data dictionary. I once had to create a 4GB snapshot over an ISDN line This was done by creating the snapshot locally, exporting, ftp, import and then: In DBA_SNAPSHOTS (I believe) I compared the entry in the local database to the remote. One field was different in my case. A simple update to the data dictionary enabled the FAST REFRESH to take place. THIS IS DANGEROUS STUFF :) Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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 SQLServer archiving
Hi James, Well his clients disagree with you, and since they have actually worked with him, I prefer to trust their judgement. And while SQL2000 may have logs mirrored by the database, SQLServer 7 did not. Dave James Xing wrote snip Your friend is Not a MSSQL/NT/2000 expert, apparently! snip -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Size, what is it?
Hi Mogens I agree with all your statements. What I am trying to figure out is what is it that streches the machine. I was quite surprised to see an E450 doing 10GB of transaction logs per day. Pure OLTP using stored procs. I was hoping to get descriptions of the types and amounts of work a large or busy database does along with the description of the hardware that is being used. This would allow a baseline to be developed for estimating. For example how much OLTP work can a Linux 2 CPU machine with lots of memory do? How many DSS users can a similar machine support? I would also like to ask similar questions about other UNIX configurations? VAX/VMS would also be interesting. NT, someone else can do the work if they want :) SUN is also now offering hardware RAID 3 in their RSM2000 array. As I mentioned the Baydel array beats RAID 5 easily, and is substantially cheaper than an equivalent RAID 10 (1+0) array which is my preference. (and everyone elses :) Thanks for your input. Dave Mogens wrote ... My dear friend Cary Millsap once came up with a definition for a VLDB: It's any database that stretches its hardware. I cannot see any relationship between SGA and database sizes. None. RAID-3: Bit-level striping. Incredible it still exists (in my opinion) :). -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
LDAP/OID
Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
MaterializeRe: Snapshot Logs Explanation Needed
Hi Anita, I'm not sure if you are the original poster but There is a way to force a view into fast refresh mode after you have restructured the snapshot logs WARNING: This is unsupported by Oracle and involves messing with the data dictionary. I once had to create a 4GB snapshot over an ISDN line This was done by creating the snapshot locally, exporting, ftp, import and then: In DBA_SNAPSHOTS (I believe) I compared the entry in the local database to the remote. One field was different in my case. A simple update to the data dictionary enabled the FAST REFRESH to take place. THIS IS DANGEROUS STUFF :) Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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 SQLServer archivingq
This was actually one of the reason's I left my last employer. The decision was made to go to MSSQL and I was given the same specs as with Oracle, ie: no lost transactions no matter what. I hired a friend who is a MSSQL/NT/2000 expert to train me. No mirrored redo/transaction logs. Hardware RAID does not help when a LUSER like me does a del * There were other issues that made me uncomfortable but robustness was the primary one. SQLServer is an excellent workgroup product, it is not suitable for enterprise/realtime/CAD-CAM systems. IMHO Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Fire your DBA
I love it when Larry says your dba will have nothing todo. It means I will get another exorbitant pay raise within two years. Oracle 5/6 Dave gets paid duhveloper wages Oracle 7Ugly conversion, Dave gets 20% increase Oracle 8Everyone and their mother installs Oracle, demand for Dave's services to rescue them jumps 20% so does Dave's paycheque. Oracle 9OPS on filesystems, sounds like everyone's little sister will install OPS, hmm, I wonder if I can get more than 20% this time. The easier Larry makes it to install Oracle the better off we as Oracle DBA's are. IMHO Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: WOB (waste of bandwidth ~= OT:)/ Re: HTML in Email
Hi Eric, No I won't, I have Linux nanoprobes which can swallow any virii that use proprietary extensions :) I am assuming Borg == Microsoft Dave Eric D. Pierce wrote: resistance is futile, you WILL be assimilated - the borg On 1 Jun 2001, at 9:54, Dave Morgan wrote ... Javascript exploits in email. As a result I have to filter the digest to remove all HTML before I receive it. This is a special privilege granted me by the mailman. ... -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Request Tracker Call for Assistance
Hi All, I have been involved with a perl/DBI trouble ticketing system called Request Tracker. I have done a small piece of the work required to port the system to Oracle. The creators are almost finished but with my new job I cannot devote the time necessary now that they are pushing to a beta release. Jesse needs Oracle testers and both Oracle and perl assistance. The current problem is the use of "DISTINCT" in a select clause from a table that has BLOB/CLOB etc columns. This is an industrial strength web and email ticketing system ala Remedy, but it is under an open source license. http://www.fsck.com/projects/rt/ mailto:[EMAIL PROTECTED] TIA Dave Tobias Brox wrote: Anyone have a helpful suggestion for how to make oracle happy with this: SELECT DISTINCT * from Tablename; Thanks, Jesse I've never tried Oracle, but I'd suggest trying this: SELECT UNIQUE(*) from Tablename; ___ Rt-devel mailing list [EMAIL PROTECTED] http://lists.fsck.com/mailman/listinfo/rt-devel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Offtopic:DBA Math, Beer and OEM
[EMAIL PROTECTED] wrote:
Well, I doubt that. With an average reach of 5 feet, it would take less
than 8 million people to hold hands along the Canada/US border.
You should check your math more carefully before spouting such nonsense.
Huh? I used
28,000,000 people
7000 miles
5000 feet/mile
= 0.8 ft = 1 ft/person
One!! I thought it was 10, must of dropped a zero somewhere.
I tell my developers when sizing tables an error of 2 or 4 times
is okay but an order of magnitude is a bit much. Thanks for
the correction.
More math, Steve has asked how many mile I put on my bicycle
while in the valley:
11 months
10 days/month (I telecommuted the other 2 weeks)
8 miles/day
= 880 miles
add the zero I dropped earlier
= 8800 miles
I thinks thats why it didn't work out in the valley for me.
Only a four mile commute, I just didn't have the right attitude :)
You're right Steve, it is still a little cool to be riding in
Calgary right now. (though there are some crazies who ride all
winter, the thought of it being 30 below, on a bike makes me
shiver as I sit here, Br). March in the valley is
very similar to May in Calgary. In Calgary I usually bike
from the middle of April to the middle of October. My house
is six miles from downtown so I usually put on about 1200
(oh, add the zero, 12000) miles a year there.
Beers!! I found a place that served Humboldt Red Pale Ale.
Any companies in Humboldt county looking for a DBA? I
patronized the place (The Fish Market) until the keg ran out,
notice I didn't mention this until the keg ran out, and then
they told me they were not going to order another one. The
nerve of some people. Really good beer, I was impressed.
OEM, after reading about the trials and tribulations of people
trying to install OEM, why are people wasting their time and
money running a product that requires you to take a massive
security risk by running Intelligent agent.
I have a set of monitoring scripts (email me offline if
you want a copy, do not ask for support if, they do not work
on your db, you will learn more if you fix them yourself)
that I install at every site. Within 15 minutes I have realtime
text reports that cover everything from invalid objects,
snapshot refreshes, extents, I/O memory. latches , config
parameters ( about 6 pages of data).
Create a reporting schema, install perl DBI, (not on the db
server, on a client somewhere) gnu-plot or a similar graphing
package (anyone know a good perl one?) and within a week
you have graphical historical reports.
It's free and you have increased your skills.
As for detecting outages, here is a short ksh script that connects to
the db as normal user. If the connect fails, do a network ping.
This is to determine which type of admin gets paged.
It used to do a tnsping before the ping but since the DBA has
to fix it anyways that was redundant. Far more relieable than OEM.
And yes I know it is lousy code, but look at my math, what do you
expect.
#!/bin/ksh
# Database monitor scrip, cron at desired time interval
# requires host ip address, email addresses for dba and sysadmin
# requires $ORACLE_HOME
if [ X$1 != X ]; then
export DBNAME=$1
else
echo "The database name must be passed as a parameter"
exit
fi
DBA="[EMAIL PROTECTED]"
ADMIN="[EMAIL PROTECTED]"
DBTEST=test_account/test_password@${DBNAME}
export ORACLE_HOME=/wherever/your/oracle/binaries/are
export HOSTN=ip_address_of_your_db_server
${ORACLE_HOME}/bin/sqlplus -s $DBTEST /dev/null 21 EOF
whenever sqlerror exit 1
select * from dual;
exit 0
EOF
if [ $? -eq 0 ]; then
echo "`date`: Database $DBNAME is up and running."
else
ping -c 1 $HOSTN | grep " 0% packet loss" /dev/null
if [ $? -eq 1 ]; then
echo "ERROR !!! Network or Server DOWN "
echo "Ping of $HOSTN failed !!!"
mailx -s "ALERT !!!...$HOSTN ping failed" $ADMIN -EOF2
Subject: Pinging $HOSTN failed
Pinging $HOSTN failed.
Please investigate!!!
EOF2
mailx -s "ALERT!!!...$HOSTN ping failed. sysadmin notified." $DBA
-EOF4
Subject: Pinging $HOSTN failed
Pinging $HOSTN failed.
Please investigate!!!
EOF4
else
echo "`date`: Database $DBNAME on $HOSTN is down!!!"
mailx -s "ALERT!!!...Database $DBNAME is down on $HOSTN" $DBA
-EOF1
Subject: Database $DBNAME is down on $HOSTN
Database $DBNAME is down on $HOSTN.
Please investigate!!!
EOF1
fi
# end-of-script
The problem with point and click GUI's is that they isolate the DBA
from the detailed sql that is needed to really MANAGE Oracle.
IMHO
Dave
--
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.barter
Offtopic: Canada and America
RANT Typical, a hotmail account spouting off what they know nothing about. Fact: The longest undefended border in the world is between Canada and the US. ( 7000 miles) Granted this reflects better on the US than Canada, as we could put the whole Canadian population along the border and still couldn't hold hands. Question: Name any other state that has lived peacefully beside it's neighbour with 1/10 of the population for almost 200 years? Russia and the Ukraine? China and Tibet? Germany and Denmark? It is almost 200 years because one of the defining moments of Canadian history is the War of 1812. Canadian Geopolitical Summary: We kicked America's butt. American Geopolitical Summary: We kicked Britains butt. British Geopolitical Summary: We kicked Napoleons butt. Pierre Berton's "War of 1812" and "Flames Across the Border" provide a slightly biased but relatively fair view of this conflict from the Canadian viewpoint. There are no similar British or American texts because the Canadian theatre was a very minor and trivial part of this conflict. Canadian Patriotism On Please note that this is the only war America has ever lost. To a bunch of meek and mild Canadians... /CanPat The truth is that the largest force in Canada at the time was the British army. Typically Canadian, one of our nation building moments hardly involved us. I am proud to be Canadian, I am proud to be best friends with America. Thank you, America for being our friend. Does Canada have problems, you bet. Does America have problems, more than us the poor fellows. We do not follow America, we guide it, help it, support it and party with it. And if the rest of the world was as reasonable as they are, Canada could help them too. ( Apologies to the citizens of many states I have slandered with the above comment ) Before you comment on cultures you have not experienced it would be advisable to at least visit there as a tourist. If you work there for a while you may even realize that what is "common knowledge" is wrong. After spending six weeks in Moscow, 2 years ago, I do not believe anything I read in the media (it is both better and worse than it is reported). And yes, there is a separate Canadian culture. (Part of which is wondering if we have a separate culture.) /RANT Sigh.., and the day after I promised Jared I would behave. Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Off topic, humour, flagrant breach of the rules
This should make it through GE's filters but .. I think they have it backwards though. Shouldn't it be "something to protect the software from Matt" rather than "software to protect Matt from something" My apologies Jared, but it's only one rule. I usually break them 4 or 5 at a time. Announcing a new musical with music by The Travelling DBA's !!! A one act musical on UNIX, NT/2000 clients are advised to reboot after each song and apply all new Microsoft patches. Curtain rises A DBA's spouse wanders down to the basement where his or her partner has been tele-commuting for the past little while and breaks into a song by George Thoroughgood. Get a haircut and get a real job, clean your act up and don't be a slob Get it together like your LITTLE brother bob, why don't you get a haircut and get a real job Next we join our intrepid hero(ine) in SILICON VALLEY!!! Working 5(am) to 9(pm), what a way to make a living barely catching by, it's all taking and no giving they just use your mind, then they never give you credit Enter stage right, the NEW BOSS! Best portrayed by a young person with no experience who has one of the following certificates, MSCE or OCP. (Cisco certified techies are ineligible for this role) With apologies to AC/DC Walk this way Talk this way DBA this way Administer this way. Cut to our hero(ine) who appears to have many more grey hairs (and wrinkles) laughing hysterically just before you hear the wonderful music of Johhny Paycheck! Take this job and shove it I ain't working here no more My CLIENTS left and took all the reasons I was working for You better not try to stand in my way When I'm walking out the door Take this job and shove it I ain't working here no more Fade to a chorus of sysadmins, network admins, and data entry clerks crooning to the tune of You've Lost That Lovin Feeling You've lost that Dee Bee Aaa Whoa, that Dee Bee Aaa You've lost that Dee Bee Aaa Now it's gone, gone, gone, woah Final shot Our hero, once again in the basement with the loving spouse leaning over his/her shoulder whispering "I'm so glad you're back to stay" Curtain falls . Thanks to all who have helped me at this job. I will rely on you at my next one :) (In Calgary, at one of Canada's largest ISP's) Jared, I'll be good from now on, I promise. After Friday I will be reachable at [EMAIL PROTECTED] Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
OPS on RS6000
Hi Cyril, Alex, Oracle Parallel Server 8.1.6 on IBM AIX 4.3.3 requires HACMP/ESClustering software, Add on to AIX SSA Serial Storage Array, IBM's Disk Array provide shared disk Hi speed Interconnect Serial Port to Serial port direct connection - this is not a network interface! Alex, if you can cluster SUNs clustering IBM's is trivial :) Hooray for smitty ! HTH Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Anyone Seen this? ACC_TRIGGER problem
Hi All,
Anyone have a clue? Seen it before?
Completed checkpoint up to RBA [0x20f.2.10], SCN: 0x.00665693
Thu Feb 22 13:16:16 2001
Errors in file /home/oracle/SCQQQI/bdump/pmon_47776_scqqqi.trc:
ORA-00600: internal error code, arguments: [kssdys 2: bad ch], [0],
[807311928], [0], [806153868], [], [
], []
ORA-00601: cleanup lock conflict
ORA-01401: inserted value too large for column
ORA-06512: at "SYS.ACC_TRIGGER", line 5
ORA-04088: error during execution of trigger 'SYS.ACC_TRIGGER'
Thu Feb 22 13:16:16 2001
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 47776
Oracle 8.1.6.2, AIX 4.3.3
It's not really important, on my development database,
damagement doesn't need Oracle support :{, but I still care.
Why? Cause they pay me and deserve my loyalty.
See next post for off-topic looking for work spam :)
I know I should spend the time to investigate but the
list is so much easier.
TIA
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
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: Linux as a production machine
Hi Steve, Thanks, I wasn't aware of that. As I said, they are not busy machines so I hadn't noticed any paging activity at all. Two more kernels, 2.2.17 and a 2.4 are in my test area so I guess I should upgrade once again sigh.. I would like to jump straight to 2.4 but the first release issues always scare me (Not just Linux but any software) Dave Steve Adams wrote: Hi Dave, I would recommend a later kernel for anyone who wants to run a production Oracle system on Linux. The 2.2.14 kernel has bugs in the VM. It pages much too aggressively and cannot be tamed. So you need to ensure that you never page which is wasteful. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Linux as a production machine
Hi Dick, A couple of campanies I consult for are using Linux and Oracle (8.0.5, 8.1.6) as production databases. Neither is really high transaction volume but one is holding about 1.5 GB of data. One install occured because Oracle on NT was choking the box and the company did not want to buy new hardware. I find you usually get a 20 -30% performance boost with Oracle on Linux vs NT for the same hardware. The 8.0.5 Linux release has some problems so I would recommend the 8.1.6 release which is of the same quality as all other UNIX Oracle releases (Notice I didn't comment on the quality, just the similarity :) Both machines are in archive log mode and show typical unix uptimes (Months). WARNING: My original kernel is Slackware 1.2.13 (I think) and I have maintained my own kernel and system for the past 5-6 years (Currently 2.2.14). This gives me an extremely reliable (but custom) system. My builds are of better quality than any commercial linux packages I have tested. I would recommend Caldera over Redhat based on my tests and what I have heard from other admins. The feeling seems to be Redhat is going after the consumer market while Caldera is concentrating on the server market. In summary, Linux, once properly configured is quite suitable as a production Oracle platform. HTH Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
