RE: Help - 9ias broke - hostname was changed
Paula - You put on your saddest face, match that with your body language, shuffle into the sys admin's cube and solemly announce "you're going to have to fix this, change the hostname back." Then brighten a little, come closer and whisper "I think I can keep anyone from finding out what you did". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 1:19 PM To: Multiple recipients of list ORACLE-L Yes, but how do I fix it? Do I need to reinstall? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Seriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message- David Sent: Friday, January 23, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Thanks Kevin, couldn't see for looking -- David Lord Senior DBA Iron Mountain (UK) Ltd -Original Message- Sent: 23 January 2004 14:30 To: Multiple recipients of list ORACLE-L Its easy to disable this "feature": Navigate to the Tools->Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message- Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet i
RE: internal date value
Harry This list is moving to freelists, but I'll assume you knew that. Actually the base value for the standard Oracle dates is Jan 1, 4712 BC. There is a Julian function that will return the number of days since the base. To return the Julian, select to_char(sysdate,'J') from dual; Also, Oracle9i has some new date types and you may find one that works better for your purposes: http://otn.oracle.com/products/oracle9i/daily/may02.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:40 AM To: Multiple recipients of list ORACLE-L Folks: >From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Solaris: Finding the cause for disk space growth
Naveen - Are you using autoextend on any of your datafiles? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:39 AM To: Multiple recipients of list ORACLE-L One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with sort, and sort on the size of the file and pipe it through head to see the most recently touched files. eg. find /u03 -mtime -1 -type f -print | xargs ls -ld | sort -nr -k5.1|head -5 This command finds all files in the /u03 file system that have been touched in the last day, pipes it to ls, sorts in reverse by file size and then shows you the five largest files. You can run this on /, it will probably take several minutes. Jared "Naveen, Nahata (IE10)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/23/2004 12:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:OT: Solaris: Finding the cause for disk space growth Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] create tablespace with different block size error???
dba1 I think you must first create a buffer cache for this block size. http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 10:29 AM To: Multiple recipients of list ORACLE-L I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL> create tablespace "index1" logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out "blocksize 16384", then it work fine. SQL> create tablespace "index1" logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[oracle-l] Re: Automatic or Uniform allocation
We need to start moving these discussions to freelists per Jared's note. Brad - I agree with Ron. I think it is critical to read "How to quit defragmenting . . ." before making the change to ensure you clearly understand the concepts and receive the benefits. If someone on the list knows of a more recent paper, please post it. With uniform extents, you eliminate tablespace fragmentation, in addition to Ron's points. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Brad, For LMT's I prefer uniform sizing that I can define to meet the needs of the data. If you use automatic the extend sizes will change drimatically as the number if extends increase. With a little planning you can have little waste in the tablespace and use the tablespace for multiple tables of the same size requirements. We have used the partitioning and LMT's for the yearly data we have, about 5 gig per table per year and the extend count is only around 100 with minimal free space. It makes it easier in the planning stage if you can keep it simple. Ron >>> [EMAIL PROTECTED] 01/22/2004 10:14:34 AM >>> for LMTs... Advantages in uniform versus automatic? Uniform 5 MB? 10 MB.100MB etc thoughts would be appreciatd Thanks Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[oracle-l] Re: pga_aggregate_target and a memory leak
Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is pointing to some memory problems. It is occurring during the CTX_DOC.FILTER process. We are running this process from a custom PL/SQL package that is being initiated from an Oracle Job. However, we still have the problem when we run it from a crontab job. I currently have a 21 page TAR concerning this problem. Sandra Arnold Principal DBA NCI Information Systems 175 Oak Ridge Turnpike Oak Ridge, TN 37830 -Original Message- Sent: Thursday, January 22, 2004 5:05 AM To: Multiple recipients of list ORACLE-L Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone had any production issues with pga memory leaks? There are a series of notes on metalink about this. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:04 PM > --- Kirtikumar Deshpande > <[EMAIL PROTECTED]> wrote: > > I think it depends on your applications. > > > > In DSS type environments we are still stuggling to > > figure out if P_A_T is helping or not. Initial > > tests are not in P_A_T's favor. > > > > But in another Application, that is 80% OLTP, P_A_T > > was the only choice to avoid swapping. This > > 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = > > 1MB)at the instance level. It has over 600 > > persistent users. No MTS in use. > > > > - Kirti > > Kirti, > > I saw in a 9.2.0.4 database just this evening, much to > my surprise, an ORA-00600 in the alert log with - you > guessed it - [723], [10332], [10332], [memory leak]. > > The database was setup in a less than optimal fashion > as far as memory allocations go. The initial > pga_aggregate_target was only 64M (server had 3 GB of > memory and only one instance up) so I'm calling this > one a non-sensical configuration error for the moment, > as there is no need to size a PGA so small. If you're > running with that small a memory footprint, don't use > pga_aggregate_target. > > After resetting the parameter to 256M and cycling the > instance, no ORA-00600's were recorded at instance > shutdown. That was not really a good test though, will > have to see tomorrow evening after the day's load has > hit it. > > Paul > > this was on w2k server sp3, 9.2.0.4 std ed > > > > > > From: Kirtikumar Deshpande > > <[EMAIL PROTECTED]> > > > > Date: 2004/01/21 Wed PM 02:44:31 EST > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > > Subject: Re: pga_aggregate_target and a memory > > leak > > > > > > > > Replies in line... > > > > > > > > - Kirti > > > > > > > > --- [EMAIL PROTECTED] wrote: > > > > > Kirti, you're back! > > > > > > > > Thanks. Found some slack time from routine DBA > > work! > > > > > > > > > Must have finished the book. :) > > > > > > > > Not yet.. Its tough.. > > > > > > > > > > Re the PGA problems, what was the value for > > 'over allocation count' in > > > > > v$pgastat? > > > > > > > > Actually, I never bothered to look at v$pgastat. > > Should have.. and will, when we do some more > > > > testing next week.. > > > > > > > > > > Did you try increasing P_A_T to a larger > > number? > > > > > > > > Yes... > > > > > > > > > Oracle is supposed to grab the memory it > > needs, if available, regardless > > > > > of > > > > > the P_A_T setting. > > > > > > > > > > Also, did your system go in to excessive > > paging or swapping? > > > > > > > > Yes, it did with a large P_A_T. > > > > > > > > > I've been curious as to what the effects would > > be of having P_A_T too low. > > > > > > > > I saw more disk sorts.. > > > > > > > > As time permits, I will play with event 10032, > > 10033 trace for sorts
[oracle-l] Re: What to look for in STATSPACK report
Chris - In Excel, click on Data --> Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file = in exel, all the columns from the csv went into one excel column and for = some reason it wasn't apparentor something like that. .now if I = could only remember what it was I did to fix it. hmmm. .i think it was some searching and replacing or something. .that should get you started though. ..sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to = make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: >=20 > You will find a utility add on for statspack at Mogens company site, > www.miracleas.dk. It is called YAPPPACK. >=20 > You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to = generate > response time graphs for your databases. >=20 > There are many different numbers to look at in a statspack report, = but > for day to day monitoring, I find them fairly useless. I mean = really, > who's gonna read all that stuff? >=20 > Or spend the rest of his life writing a genetic heuristic > artificially intelligent algorithm that is smart enough to determine > that something is out of bounds for a particular database? >=20 > Use YAPPPACK to track response times. When response times spike > abnormally, then dig into the statspack data. >=20 > JMO, >=20 > Jared >=20 > On Sun, 2004-01-18 at 23:54, Mogens N=C3=B8rgaard wrote: > > Hi Helmut, > > > > There are so many opinions about this that it's hard to point at = one > > specific document or recommendation. If anything, start with stuff > > written by Graham Wood (who has done a good deal of the work on = it), > > Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something = about > > it in his new book, so go look on asktom.oracle.com for his = opinions > > about it. > > > > If you hope to find threshold numbers for certain values, etc = then > > someone would have automated it a lng time ago. There can be = two > > reasons for this not having happened: It depends on the = installation, > > situation, etc. - or a lot of system-level measurements are in = reality > > useless. That's pretty much my opinion, but thankfully a lot of = much > > smarter people disagree with me. > > > > Best regards, > > > > Mogens > > > > Daiminger, Helmut wrote: > > > > >Hi! > > > > > >We want to introduce a performance monitoring policy here. We are = using the > > >STATSPACK utility. > > > > > >What are sections in statspack reports to look for? What are = threshold > > >numbers for these values? > > > > > >Does anybody have any power points or papers about it? > > > > > >This is 9.2 on HP-UX. > > > > > >Thanks, > > >Helmut > > > > > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: =3D?ISO-8859-1?Q?Mogens_N=3DF8rgaard?=3D > > 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). > > >=20 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] >=20 > Fat City Network Services-- 858-538-5051 http://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 'ListGu
[oracle-l] Re: Startup Migrate
Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle 9.2.0.3. After installing the products.jar file, one of the steps is to run startup migrate then run catpatch.sql I've looked on technet as well as the documentation CD and can not find any info on startup migrate. Can someone point me in a direction to find out about this? All I can find is that it's new in 9.2. Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Startup Migrate
Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle 9.2.0.3. After installing the products.jar file, one of the steps is to run startup migrate then run catpatch.sql I've looked on technet as well as the documentation CD and can not find any info on startup migrate. Can someone point me in a direction to find out about this? All I can find is that it's new in 9.2. Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Freelists about 2 hours behind
Based on a sample of one message, it looks like Freelists may be running about 2 hours behind. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Automatic or Uniform allocation
Jonathan Thanks so much for posting this excellent article. Very high quality as all your writing is. This was my devious purpose in replying, in hopes something like this was out there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:54 AM To: Multiple recipients of list ORACLE-L I think http://www.jlcomp.demon.co.uk/08_lmt.doc is pretty good, but I'm biased. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearances: Jan 29th 2004 UKOUG Unix SIG - v$ and x$ March 2004 Hotsos Symposium - The Burden of Proof March 2004 Charlotte NC OUG - CBO Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - > Brad - I agree with Ron. I think it is critical to read "How to quit > defragmenting . . ." before making the change to ensure you clearly > understand the concepts and receive the benefits. If someone on the list > knows of a more recent paper, please post it. > > With uniform extents, you eliminate tablespace fragmentation, in addition to > Ron's points. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: pga_aggregate_target and a memory leak
Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is pointing to some memory problems. It is occurring during the CTX_DOC.FILTER process. We are running this process from a custom PL/SQL package that is being initiated from an Oracle Job. However, we still have the problem when we run it from a crontab job. I currently have a 21 page TAR concerning this problem. Sandra Arnold Principal DBA NCI Information Systems 175 Oak Ridge Turnpike Oak Ridge, TN 37830 -Original Message- Sent: Thursday, January 22, 2004 5:05 AM To: Multiple recipients of list ORACLE-L Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone had any production issues with pga memory leaks? There are a series of notes on metalink about this. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:04 PM > --- Kirtikumar Deshpande > <[EMAIL PROTECTED]> wrote: > > I think it depends on your applications. > > > > In DSS type environments we are still stuggling to > > figure out if P_A_T is helping or not. Initial > > tests are not in P_A_T's favor. > > > > But in another Application, that is 80% OLTP, P_A_T > > was the only choice to avoid swapping. This > > 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = > > 1MB)at the instance level. It has over 600 > > persistent users. No MTS in use. > > > > - Kirti > > Kirti, > > I saw in a 9.2.0.4 database just this evening, much to > my surprise, an ORA-00600 in the alert log with - you > guessed it - [723], [10332], [10332], [memory leak]. > > The database was setup in a less than optimal fashion > as far as memory allocations go. The initial > pga_aggregate_target was only 64M (server had 3 GB of > memory and only one instance up) so I'm calling this > one a non-sensical configuration error for the moment, > as there is no need to size a PGA so small. If you're > running with that small a memory footprint, don't use > pga_aggregate_target. > > After resetting the parameter to 256M and cycling the > instance, no ORA-00600's were recorded at instance > shutdown. That was not really a good test though, will > have to see tomorrow evening after the day's load has > hit it. > > Paul > > this was on w2k server sp3, 9.2.0.4 std ed > > > > > > From: Kirtikumar Deshpande > > <[EMAIL PROTECTED]> > > > > Date: 2004/01/21 Wed PM 02:44:31 EST > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > > Subject: Re: pga_aggregate_target and a memory > > leak > > > > > > > > Replies in line... > > > > > > > > - Kirti > > > > > > > > --- [EMAIL PROTECTED] wrote: > > > > > Kirti, you're back! > > > > > > > > Thanks. Found some slack time from routine DBA > > work! > > > > > > > > > Must have finished the book. :) > > > > > > > > Not yet.. Its tough.. > > > > > > > > > > Re the PGA problems, what was the value for > > 'over allocation count' in > > > > > v$pgastat? > > > > > > > > Actually, I never bothered to look at v$pgastat. > > Should have.. and will, when we do some more > > > > testing next week.. > > > > > > > > > > Did you try increasing P_A_T to a larger > > number? > > > > > > > > Yes... > > > > > > > > > Oracle is supposed to grab the memory it > > needs, if available, regardless > > > > > of > > > > > the P_A_T setting. > > > > > > > > > > Also, did your system go in to excessive > > paging or swapping? > > > > > > > > Yes, it did with a large P_A_T. > > > > > > > > > I've been curious as to what the effects would > > be of having P_A_T too low. > > > > > > > > I saw more disk sorts.. > > > > > > > > As time permits, I will play with event 10032, > > 10033 trace for sorts
RE: What to look for in STATSPACK report
Chris - In Excel, click on Data --> Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file in exel, all the columns from the csv went into one excel column and for some reason it wasn't apparentor something like that. .now if I could only remember what it was I did to fix it. hmmm. .i think it was some searching and replacing or something. .that should get you started though. ..sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: > > You will find a utility add on for statspack at Mogens company site, > www.miracleas.dk. It is called YAPPPACK. > > You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate > response time graphs for your databases. > > There are many different numbers to look at in a statspack report, but > for day to day monitoring, I find them fairly useless. I mean really, > who's gonna read all that stuff? > > Or spend the rest of his life writing a genetic heuristic > artificially intelligent algorithm that is smart enough to determine > that something is out of bounds for a particular database? > > Use YAPPPACK to track response times. When response times spike > abnormally, then dig into the statspack data. > > JMO, > > Jared > > On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: > > Hi Helmut, > > > > There are so many opinions about this that it's hard to point at one > > specific document or recommendation. If anything, start with stuff > > written by Graham Wood (who has done a good deal of the work on it), > > Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about > > it in his new book, so go look on asktom.oracle.com for his opinions > > about it. > > > > If you hope to find threshold numbers for certain values, etc then > > someone would have automated it a lng time ago. There can be two > > reasons for this not having happened: It depends on the installation, > > situation, etc. - or a lot of system-level measurements are in reality > > useless. That's pretty much my opinion, but thankfully a lot of much > > smarter people disagree with me. > > > > Best regards, > > > > Mogens > > > > Daiminger, Helmut wrote: > > > > >Hi! > > > > > >We want to introduce a performance monitoring policy here. We are using the > > >STATSPACK utility. > > > > > >What are sections in statspack reports to look for? What are threshold > > >numbers for these values? > > > > > >Does anybody have any power points or papers about it? > > > > > >This is 9.2 on HP-UX. > > > > > >Thanks, > > >Helmut > > > > > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNS
RE: How to get unique value using AWK?
Reminder to post to freelists.org per Jared - I'm crossposting this reply.
Jay
Pipe your output to sort, then uniq.
grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 "
"$6}'|sort|uniq
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 10:09 AM
To: Multiple recipients of list ORACLE-L
Hi All,
My manager wants to get all the unique wait events from the trace file.
I tried the below but how do i get DISTICT wait event name?
Any help would be really appreciated.
$ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 "
"$6}'|more
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='library cache lock' ela=
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
Thanks
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Automatic or Uniform allocation
We need to start moving these discussions to freelists per Jared's note. Brad - I agree with Ron. I think it is critical to read "How to quit defragmenting . . ." before making the change to ensure you clearly understand the concepts and receive the benefits. If someone on the list knows of a more recent paper, please post it. With uniform extents, you eliminate tablespace fragmentation, in addition to Ron's points. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Brad, For LMT's I prefer uniform sizing that I can define to meet the needs of the data. If you use automatic the extend sizes will change drimatically as the number if extends increase. With a little planning you can have little waste in the tablespace and use the tablespace for multiple tables of the same size requirements. We have used the partitioning and LMT's for the yearly data we have, about 5 gig per table per year and the extend count is only around 100 with minimal free space. It makes it easier in the planning stage if you can keep it simple. Ron >>> [EMAIL PROTECTED] 01/22/2004 10:14:34 AM >>> for LMTs... Advantages in uniform versus automatic? Uniform 5 MB? 10 MB.100MB etc thoughts would be appreciatd Thanks Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: data manipulation of a large unix file
Ryan - Can you provide more details? Typically ksh scripts are much, much more efficient than alternate methods, such as manipulating data within the database. Depending on which method you are using to measure CPU usage, you may be seeing 1/4 of one CPU. But even if your script is using a full CPU, that may not be unreasonable. The real question is how long the CPU is used. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:00 AM To: Multiple recipients of list ORACLE-L We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink on the blink
Matthew - Works fine for me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] "The swim only hurt once - from the beginning to the end" - Doc Counsilman on swimming the English Channel at age 58 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Old thread - trace file location
Thanks Alexander. I wasn't aware of this new feature. It will certainly make my script much simpler. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:49 PM To: Multiple recipients of list ORACLE-L For 9.2 users: Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs; Alex. -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Wednesday, January 21, 2004 12:24 PM To: Multiple recipients of list ORACLE-L Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 & 18, 2002. If you are interested, go to Google and enter Oracle-l "backup controlfile to trace". Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Healty ratio of index segment size vs table segment size?
Branimir Beware of simple ratios. The logic is seductive. It seems likely that an easy way to find unnecessary indexes is to look at a ratio such as you describe. And it shouldn't pose much load on a system to do a quick report on ratio. But what would it mean in practice? Just go around dropping indexes on tables that exceed their quota? I haven't used the index monitoring feature, and a cautious DBA always makes a small test before widespread deployment, but from what I've been told, the monitoring feature is pretty low overhead. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Wondering if there is a "rule of thumb", quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average "healthy ratio" above which would be prudent to have a closer look and investigate? Related to the above dilemma, how "expensive" is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few "most suspected" indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Old thread - trace file location
Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 & 18, 2002. If you are interested, go to Google and enter Oracle-l "backup controlfile to trace". Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Old thread - trace file location
Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Rich Amazon - Enter MySQL - 412 hits. The first screen of books are nearly all devoted to MySQL. Enter Postgres - 94 hits. None of the books on the first screen seem to be devoted to Postgres, but just mention it incidentally. Google - Enter MySQL - 15.6 million hits. Postgres - 733,000 hits or less than 5% of the MySQL hits. Admittedly these are just rough comparisons, and I think Jonathan's statement that MySQL books sell much better is a much more reliable statement. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 12:59 PM To: Multiple recipients of list ORACLE-L Huh???!?? What did you search for? I get many hits searching for "postgresql". Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 12:29 PM To: Multiple recipients of list ORACLE-L [snip] A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Developer Mailing List
Mark - Maybe a good place to start is: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.databases.orac le.tools (usenet newslist comp.databases.oracle.tools) If that doesn't suit you, post your request there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 3:30 PM To: Multiple recipients of list ORACLE-L Hi Folks, does anyone know if there is a similar mailing list for Oracle development topics? Regards, Mark http://personals.yahoo.com.au - Yahoo! Personals New people, new possibilities. FREE for a limited time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Mark=20Burgess?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product "SQL*Star", that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked "isn't than like Oracle's SQL*Star?". My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Thanx - I cleared the exam --> another OCP question
Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 15, 2004 6:04 AM To: Multiple recipients of list ORACLE-L Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book "The Difference Between God and Larry Ellison". I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:19 PM > 1) DBI is a perl module to handle the communication with various databases. > 2) Postgres is free. I believe that you can buy commercial support, but I don't know >where. May be Rich can jump in with that. > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > what is DBI? > > > > is postgre free? Is it like linux where you pay for support? I cant find any > > licensing info on the website. Most shops dont need oracle, sql server, > > sybase, or DB2. > > > > Most applications are small. I was on a project where the government had an > > Oracle EE license on windows. They didnt even use foreign key constraints. > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > > could have handled that. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > > what > > > > I've seen, it's more mature than MySQL. > > > > > > I second that. PostgresSQL supports transactions and uses perl as its > > > scripting language. From what little I read and saw (just a little pilot > > > project with the goal to see "what the heck is Postgres"), it's a very > > > decent database, with a decent performance and capabilities sufficient > > > for a small, departmental database server. I know nothing of clustering, > > > distributed database, database links, replication and alike. In other > > words, > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > > it can be quite a convenient storage space for a small corner shop or a > > > small department. Because of perl and DBI, exchanging data with other > > > servers like oracle or UDB (DB2) is easy. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ryan > > 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: SYS Privilege
Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Non)Unique Index Vs Unique Constraint
Jay That is a good one. The question is: "How is the uniqueness constraint being enforced when the index is nonunique?" Offhand I would have assumed your constraint would have been rejected since the index is nonunique -- nope. Then I would have guessed the index would have been converted to a unique index -- it isn't. Then I was skeptical whether the constraint was really being enforced, but it is. The next question is how the uniqueness is being enforced if the index is not unique. Now, if you add some duplicate values to the table, then try to add the constraint, you receive: alter table index_test add constraint index_test_uk1 UNIQUE(c1) * ERROR at line 1: ORA-02299: cannot validate (SILT.INDEX_TEST_UK1) - duplicate keys found My guess, and this is only a guess, is that the nonunique index with a unique constraint executes the code for a unique index. I ran an insert on each version and the plan looks the same. Of course, if you go around doing funny stuff like this, the person that eventually takes over your job duties will probably really bless your name each time they stumble onto something like a unique constraint on a nonumique index. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 16, 2004 9:14 PM To: Multiple recipients of list ORACLE-L All, Please enlighten this Junior DBA. Which method is more efficient? When should I go for option (1)? 1)NON-UNIQUE index Vs Unique Constraint drop table index_test; create table index_test(c1 number,c2 varchar2(20)); create index i1 on index_test(c1); alter table index_test add constraint index_test_uk1 UNIQUE(c1); 2)UNIQUE index Vs Unique Constraint drop table index_test; create table index_test(c1 number,c2 varchar2(20)); create UNIQUE index i1 on index_test(c1); alter table index_test add constraint index_test_uk1 UNIQUE(c1); Thanks in advance, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any student versions of 'business objects' ab initio or infor
Ryan - Some more thoughts for your consideration. 1. Consider studying Data Warehousing. These tools are deliberately made easy to use, so shouldn't take much effort, but understanding how to design a star schema will make data more accessible to any tool. A good start can be had at http://www.ralphkimball.com <http://www.ralphkimball.com> and http://www.billinmon.com <http://www.billinmon.com> 2. In spite of the versatility of these tools, sometimes they can't do everything, particularly in the ETL phase. Consider learning a tool like perl to fill the gap. 3. There are ways to learn about a tool without operating it. Find a group like this dedicated to the tool. Try to locate user groups. See if you can get a manual. 4. Once you've learned quite a bit about the tool, contact the local sales rep for these tools and describe your desires. Use your winning charm. Let them know you are sincere to have learned what you are able. They may have some creative suggestions for you. Maybe let you sit in the back of a training class, or slip you an old manual they are ready to toss. Offer volunteer labor. It is in their best interest to have trained technical people available Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 17, 2004 10:44 AM To: Multiple recipients of list ORACLE-L informatica? Something affordable. These are hot right now and I'd like to learn how to use them. I cant find anything on the web. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ** OCP for 9i requirements -- Instructor Led Class is a
I heard from an Oracle instructor that some idiots were bragging about how
they passed the OCP without logging in once. This distressed some important
people, so this requirement was added. I asked if this meant each instructor
was tasked with ensuring each student logged in, and he just smiled.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 14, 2004 8:09 AM
To: Multiple recipients of list ORACLE-L
Sure.
Read
"Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience -
with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant investment
in its Certification Program. Three distinct changes are being rolled out
with the goal of increasing the level of quality of our certification skill
and ability benchmarks:
Scenario-based testing in all Oracle9i DBA Certified Professional
exams .
Instructor-led class requirement for candidates starting on the
Oracle9i DBA Certified Professional credential exam path.
A new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential.
"
at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
<http://www.oracle.com/education/certification/index.html?dba9i_ocp.html>
"Instructure-led class" is a requirement.
You CAN take the Online Training to _prepare_ for the Exams. But you MUST
attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:
why dont you just read what is on the oracle website?
www.oracle.com <http://www.oracle.com>
do a search for certification.
- Original Message -
To: Multiple recipients of <mailto:[EMAIL PROTECTED]> list ORACLE-L
Sent: Tuesday, January 13, 2004 9:34 AM
Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ? I thought that
the pre-requisite is "at least one Instructor Led Training".
Hemant
At 12:04 AM 13-01-04 -0800, you wrote:
At 06:14 PM 1/12/2004, Ryan wrote:
www.oracle.com <http://www.oracle.com>
do a search for certification. Its all explained there. You can take an
online course for $300. If your company is an oracle partner the course is
free.
My understanding is that you need to take a class that corresponds to one of
the four OCP exams, which are all 5-day classes. The in-classroom versions
run $2500 and the on-line versions run $1250. Oracle partners get a 35%
discount (advantage and certified advantage partners may get a larger
discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.
html
<http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq
.html>
Justin Cave
- Original Message -
To: Multiple recipients of <mailto:[EMAIL PROTECTED]> list ORACLE-L
Sent: Monday, January 12, 2004 7:34 PM
Hi,
For taking Oracle9i OCP exam is it necessary to have attended a Oracle
course by Oracle University. What is the minimum? Is any small course good
enough? Can someone who has gone through this provide details? Thank you
Do you Yahoo!?
Yahoo! Hotjobs: Enter
<http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/mail_footer_email/evt=2
1482/*http://hotjobs.sweepstakes.yahoo.com/signingbonus> the "Signing Bonus"
Sweepstakes
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com <http://hkchital.tripod.com /> {last updated
05-Jan-04}
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net/> -- Author: Hemant K Chitale INET:
[EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com <http://www.fatcity.com/> San Diego, California --
Mailing list and web hosting services
- To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
you want to be removed from). You may also send the HELP command for other
information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com <http://hkchital.tripod.com/> {last updated
05-Jan-04}
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services --
858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list
and web hosting services
RE: JVM for DBA
Bill - Will you be administering the server or do you need to talk to the administrator? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 10:15 AM To: Multiple recipients of list ORACLE-L Hi all, Does anyone have any good resources on the Oracle JVM from a DBA perspective? (ie. Tuning java parameters, managing storage/validation of java objects, monitoring java pool performance, managing security... etc.) I can find lots of stuff for developers but I don't write too much Java code! Thanks for any info. - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql question
David - Can you post the EXPLAIN PLAN for both? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 12, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) However, when I try to count above query as following, it hangs. Does someone have any ideas? SELECT count(b.award_number) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) _ High-speed users-be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups in a DW Environment
Yeah, I configured RMAN on a system. Then the users didn't want me to turn off cold backups. My response was that a DBA wouldn't say there was such a thing as too many backups, so we do both. Specifically with noarchivelog/archivelog, if you try to recover using a backup from before you turned off archivelog, then you will have a gap in your log sequence and only be able to recover to the point you turned off archivelog. I know that you know that Mladen, but I thought maybe some lurker on the list might not. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 10, 2004 6:44 PM To: Multiple recipients of list ORACLE-L On 2004.01.10 16:49, DENNIS WILLIAMS wrote: > Gene - As a part of putting the database back in archivelog mode, I hope you > take another backup. Actually, taking backup should be a part of every major intervention on the database. Changing the database mode from noarchivelog to archivelog most certainly qualifies. You can never be too rich or have too many backups. My experience tells me that the backup you will need the most will always be the one you don't have. Murphy must have been a DBA. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups in a DW Environment
Ryan - I don't see where you received a direct answer to this question. To use RMAN to back up to tape you must license what Oracle terms a MML (media management library). However, you can use RMAN to back up to disk without any additional purchase. My sys admin evaluated the cost of the MML piece from Veritas for our size of server and said the additional disk area was cheaper, so we use RMAN to disk. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 6:39 PM To: Multiple recipients of list ORACLE-L I never heard about the required license from veritas and legato. Can someone else confirm that this is necessary? They actually charge you more money to do use another product with veriftas and legato? What is a 'BCV'? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 7:19 PM > Let's assume RMAN is not an option since we don't have > a license or busget to use a third party backup tool > like Legato or Veritas with RMAN (used in a previous > life with Legato NetWorker. Loved it!!) > > So now I'm left with archive log mode. Archive logs > backed up nightly and a full backup once a week. I > have to set aside at least as much disk space for the > data files as the size of the physical db which will > later be copied to tape. Plus, I also need disk space > for my BCVs'. I can't have both (budgetry > constraints). I'm leaning towards BCV's. Wouldn't it > be just as quick to restore the entire BCV as to do an > Oracle recovery from tape? > > Also Gene, you mention that while loading data, you > turn off archiving. So if you lost that dbf during a > load, how would you recover the db? Restore the dbf, > apply the logs and restart the load, right? > > In the same scenario in my environment I'd just > restore the entire BCV set and re-start the load. Not > an expert on EMC's BCV technology but my sysadmin says > it can be done and yes, I'll test before I sign off on > it. > > True, I'd be nice to have archive logging aswell. But > is it a necassity or have we all been programmed into > believing that "ALL PRODUCTION DATABASES MUST BE IN > ARCHIVE LOG REGARDLESS". Should we not be progressing > beyond this like we did with hit ratios and one large > extents etc...? > > mohammed - jumping into flame proof suit > > --- Gene Sais <[EMAIL PROTECTED]> wrote: > > I put all databases in archive mode, i.e. dev, test, > > and production. I > > can use test db's to test backup/recovery > > scenario's. The only time > > they are not in archive mode is when I am doing a > > major load > > (import,sqlload,etc). After I am done loading data, > > I put them back > > into archive mode. What does it cost you, a few > > archives? Ha, well > > worth it :). > > Gene > > PS. On a side note, Robert Freeman, your book is a > > must have using > > RMAN. Thanks for writing it! > > > > >>> [EMAIL PROTECTED] 01/09/04 04:54PM >>> > > My personal opinion is all production databases > > should be in > > archivelog > > mode. Period. End of story. > > > > Less down time, more recovery optionsit's all > > good. > > > > Having said that, given a specific business case, > > with a specific set > > of > > requirements, one could argue for noarchivelog mode, > > and you might > > even > > convince me...but I doubt it...;-) > > > > -Mark > > > > Mark J. Bobak > > Oracle DBA > > ProQuest Company > > Ann Arbor, MI > > "Imagination was given to man to compensate him for > > what he is not, > > and > > a sense of humor was provided to console him for > > what he is." > > --Unknown > > > > > > -Original Message- > > Sent: Friday, January 09, 2004 4:25 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Have a question on backups in a DW environment. > > > > Our DW is somewhat small at the moment but projected > > to grow. I seem to be having a hard time trying to > > convince the sys admin that I don't want archive > > logging turned on. To me, it does'nt make much > > sense. > > > > He's proposed using EMC BCV's which I've agreed to > > (and also sounds like a good idea) but also wants to > > turn on archiving. My thinking is why turn on > > archiving if I can restore my DB from last night's > > BCV's an
RE: Backups in a DW Environment
Gene - As a part of putting the database back in archivelog mode, I hope you take another backup. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 4:44 PM To: Multiple recipients of list ORACLE-L I put all databases in archive mode, i.e. dev, test, and production. I can use test db's to test backup/recovery scenario's. The only time they are not in archive mode is when I am doing a major load (import,sqlload,etc). After I am done loading data, I put them back into archive mode. What does it cost you, a few archives? Ha, well worth it :). Gene PS. On a side note, Robert Freeman, your book is a must have using RMAN. Thanks for writing it! >>> [EMAIL PROTECTED] 01/09/04 04:54PM >>> My personal opinion is all production databases should be in archivelog mode. Period. End of story. Less down time, more recovery optionsit's all good. Having said that, given a specific business case, with a specific set of requirements, one could argue for noarchivelog mode, and you might even convince me...but I doubt it...;-) -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- Sent: Friday, January 09, 2004 4:25 PM To: Multiple recipients of list ORACLE-L Have a question on backups in a DW environment. Our DW is somewhat small at the moment but projected to grow. I seem to be having a hard time trying to convince the sys admin that I don't want archive logging turned on. To me, it does'nt make much sense. He's proposed using EMC BCV's which I've agreed to (and also sounds like a good idea) but also wants to turn on archiving. My thinking is why turn on archiving if I can restore my DB from last night's BCV's and then bring it up to date by re-loading any data that was loaded after the BCV split. Our system is not 24x7 so we can shutdown before the BCV split. Also, it's not directly accessed by users for ad-hoc queries. Automated processes access the database and build cubes using Cognos tools. Users access these and not the DB directly. So, again I don't see the need for archive logging. Any thoughts? mohammed __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus <http://hotjobs.sweepstakes.yahoo.com/signingbonus> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net/> -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com/> San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net/> -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com/> San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups in a DW Environment
Mohammed - When is this database updated? Once/week? Daily? Continuously? If there is a failure, what is the consequence of returning to the last backup? How much critical data will be lost? How will recovery times be affected with/without archive logging? How much does your sys admin know about Oracle? We have a data warehouse that gets updated weekly. The day after the load we perform a cold backup. We don't use archive logging. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Have a question on backups in a DW environment. Our DW is somewhat small at the moment but projected to grow. I seem to be having a hard time trying to convince the sys admin that I don't want archive logging turned on. To me, it does'nt make much sense. He's proposed using EMC BCV's which I've agreed to (and also sounds like a good idea) but also wants to turn on archiving. My thinking is why turn on archiving if I can restore my DB from last night's BCV's and then bring it up to date by re-loading any data that was loaded after the BCV split. Our system is not 24x7 so we can shutdown before the BCV split. Also, it's not directly accessed by users for ad-hoc queries. Automated processes access the database and build cubes using Cognos tools. Users access these and not the DB directly. So, again I don't see the need for archive logging. Any thoughts? mohammed __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
Ron - You have my sympathy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 11:30 AM To: Multiple recipients of list ORACLE-L That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: timing data
David - I'll second Carel-Jan's suggestion. If you are this interested in this topic, you'll find Cary's book invaluable. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 10:15 AM To: Multiple recipients of list ORACLE-L search for tracing event 10046, or better, buy http://www.oreilly.com/catalog/optoraclep/index.html Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === > I am trying to find a reference or document that explains how timing data > is > collected in 8i and 9i. I can remember reading an article that stated > that > 9i now collects in 1/1000th or 1/100th of a second. I know that > through > the v$system_event (one of the views in the wait interface) that it is > 1/100th of a second. Does anybody now where a document is located that > explains this? > > thanks, > > > David Ehresmann > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ehresmann, David > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman restore question
Joan - I have not used the redundancy policy, but my understanding is this just involves how many backup copies to retain. It does not relate to recovery as I read the manual. Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery? Are you attempting an incomplete recovery or a complete recovery? Any recovery to a time prior to the current time is defined as an incomplete recovery. If I am recalling your goal, you are trying to recover but not use the latest backup sets. I always back up using an RMAN catalog, but have always tested recovery just using the control file. On Oracle8i I found it easier to separately issue a SQL command to back up the control file after an RMAN backup, then I ensure that control file ends up on the backup tape. This means that I can take the backup tape, restore the control file, then issue RMAN commands that will restore the database. That control file only knows about the RMAN backup that was last performed. So I could restore the data files from any backup. Now, as you know, recovery in RMAN is basically a shell over the Oracle recovery mechanism. You can restore using RMAN, then recover the database using Oracle server manager (now SQL*Plus) commands. So it should be possible to restore the database using RMAN as I described it (but not restore), then replace the old control file with a more recent control file, then recover the database (Oracle will apply archive log files) until the current time is reached. Obviously by starting with an older restore, more archive logs must be applied. Take a look at this idea and see if it would meet your requirements. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:24 AM To: Multiple recipients of list ORACLE-L Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: > > If you don't set the redundancey policy to a recovery window of N days, than > the record of the backup will be kept indefinitely. You should be able to > restore the backups from tape and restore from a previous backup. You may > need to do a set until time if there was corruption or another problem. > > HTH, > Ruth > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Joan Hsieh > Sent: Tuesday, December 30, 2003 4:34 PM > To: Multiple recipients of list ORACLE-L > Subject: rman restore question > > Hi Listers, > > I have a question about rman restore. Right now, I configured RETENTION > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk > after a new rman full backup is done. The old backupset will be > backup-ed to tape by system group. In case of the newly backupset on > disk is corrupted and need to restore the 2 days old backupset from > tape. Is there any way or command to restore the database using a > already deleted obsoleted backupset? (from rman catalog point of view) I > could find any command and example to restore a obsoleted backupset. Any > comments will be appreciated. > > Many many thanks! > > Joan > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joan Hsieh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ruth Gramolini > 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 >
RE: rman restore question
Joan - Glad to hear your success. In the meanwhile I replied to your earlier message. Just to clarify, when you used a time-based recovery, setting a time earlier than the most recent backup, RMAN ignored the most recent backup and restored from an earlier backup? Wouldn't that have the disadvantage that you're stuck with a database that doesn't have all the recent transactions applied? Just asking, you're probably suffering from "recovery fatigue" now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: > > Ruth, > > thanks, I am back. I took the redundancy policy to 4 now and deleted > today's backupset and try to recover from the yesterday backupset which > is a valid status in the rman report. I still got error. Rman still > looking for today's backupset sequence. If I do the crosscheck and > delete the expired today's backup. I can recover sucessfully. Is there > any possible way not using delete expired command, just recover from day > old backupset? > > thanks! > > Joan > > Ruth Gramolini wrote: > > > > If you don't set the redundancey policy to a recovery window of N days, than > > the record of the backup will be kept indefinitely. You should be able to > > restore the backups from tape and restore from a previous backup. You may > > need to do a set until time if there was corruption or another problem. > > > > HTH, > > Ruth > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > > Joan Hsieh > > Sent: Tuesday, December 30, 2003 4:34 PM > > To: Multiple recipients of list ORACLE-L > > Subject: rman restore question > > > > Hi Listers, > > > > I have a question about rman restore. Right now, I configured RETENTION > > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk > > after a new rman full backup is done. The old backupset will be > > backup-ed to tape by system group. In case of the newly backupset on > > disk is corrupted and need to restore the 2 days old backupset from > > tape. Is there any way or command to restore the database using a > > already deleted obsoleted backupset? (from rman catalog point of view) I > > could find any command and example to restore a obsoleted backupset. Any > > comments will be appreciated. > > > > Many many thanks! > > > > Joan > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Joan Hsieh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ruth Gramolini > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joan Hsieh > 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: [EMA
RE: Error after resize of LMT
Robyn - Thanks for replying. So what was the consequence of the error? What did you have to do to fix the problem? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 07, 2004 8:40 AM To: Multiple recipients of list ORACLE-L This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C3D52C.273B9780 Content-Type: text/plain We've seen this error on one of our databases (9.2.0.3 on Win2003 Server). Haven't seen it on our other instances (9.2.0.3 on HP-UX). Robyn -Original Message- Sent: Tuesday, January 06, 2004 11:50 AM To: Multiple recipients of list ORACLE-L I've done a LOT of resizing of LMT tablespaces (9.2.0.1) and have never gotten that error.. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Has anyone encountered the ORA-600[kcbnew_3] error after resizing and > LMT in > Oracle9i? > > A vendor install script created tablespaces really large, and I > started to > resize them smaller, but checked Metalink. There is a bug 2747978 > that says > in versions below 9.2.0.4 you can encounter an ORA-600 error after > resizing. > Oracle says they were able to reproduce it. The bug report says this > produces a severe loss of service. As a workaround it says to bounce > the > database after resizing. > > I'm just trying to figure out how likely this error is to occur, so I > though > I'd ask if anyone has encountered this error. And if it occurred, how > severe > were the consequences? I can't apply the 9.2.0.4 patch because the > vendor > says they don't support that yet. Thanks. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer. --_=_NextPart_001_01C3D52C.273B9780 Content-Type: text/html Content-Transfer-Encoding: quoted-printable FW: Error after resize of LMT We've seen this error on one of our databases (9.2.0.3 on= Win2003 Server). Haven't seen it on our other instances (9.2.0.3 on HP-UX)= . Robyn -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] ahoo.com">mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 06, 2004 11:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: Error after resize of LMT I've done a LOT of resizing of LMT tablespaces (9.2.0.1) = and have never gotten that error.. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote= : > Has anyone encountered the ORA-600[kcbnew_3] error = after resizing and > LMT in > Oracle9i? > > A vendor install script created tablespaces really = large, and I > started to > resize them smaller, but checke
RE: Convert to Locally-Managed Tablespaces
Jared - I don't know SAP, but other canned applications have a "wonderful" process they put you through every few years called an upgrade. Often you end up creating another database and moving the data. This is a great opportunity for the DBA to fix some issues like this. However, since SAP is used by some REALLY large organizations with really, really large amounts of data, perhaps SAP uses a different practice. I would like to know if that is the case. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 05, 2004 8:09 PM To: Multiple recipients of list ORACLE-L Tanel, That's a good idea. I briefly considered this, but didn't really dig into it. The systems I need to do this on is our SAP systems, and downtime is a precious commodity, especially for production. I just may try this on our test system. The problem with SAP of course, and many other ERP's is that there are 22k+ tables, which could consume a bit of time. The amount of fragmented space that would be recovered is probably not worth the trouble of this procedure, depending on how much time it takes. I see that you too need to keep the original tablespace names, is this SAP per chance? If you have already performed a test of this, what kind of times are you seeing, along with relevant platform information, and the number of tables/indexes? Jared On Mon, 2004-01-05 at 16:49, Tanel Poder wrote: > Hi! > > > This is what I will need to use on our systems, as there are about 400 gig > > of data and indexes. 200 gig of data is too large to export/import, at > least > > it is for this project. So dbms_space_admin it will be. > > I'm about to do a reorg+conversion of a 250GB 8.1.6 database in next week, > here's what I'll do (there is practically no free space for temporary > usage): > > 1) Export index definitions (normal export with rows=n) > 2) Drop all indexes > 3) use alter table move with parallel 16 and nologging to move all tables to > old index tablespaces (the indexes consumed more space than tables) > 4) drop and recreate data tablespaces > 5) use alter table move again to move tables back (the segments have to > reside in original tablespaces, otherwise I could have skipped this step) > 6) drop and recreate index tablespaces > 7) get index definitions out of exportfile and modify them to add parallel & > nologging (with big sort area size) > 8) rebuild indexes > 9) do a full backup > > It might help to recreate index tablespaces even before step 3, to speed up > parallel table moving a bit.. > > Maybe you want to test this Jared, this approach is much faster than > export/import, because everything can be done with direct path operations > and nologging (import doesn't have direct path facility, so regular array > inserts are used, which always require logging as well). > Also, your tables/datablocks will be optimized after moving them (which is > not the case with dbms_space_admin) and you don't have to have any space for > reorg in case your cleared index tablespace can temporarily accommodate your > data. > > > IIRC one of the drawbacks of using dbms_space_admin to convert is > > that you won't be converting to nice uniform extent sizes for existing > data. > > Yes, and if your tablespace is fragmented, the fragmentation will remain > there, despite your conversions (of course, smaller extents might be able to > use some of this fragmented space later on). > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mail
RE: OCP Question (Perf Tuning)
What I have heard is that all the OCP questions are taken from the Oracle University Student Guide. After all, you wouldn't you expect the class to prepare you? Someone suggested that you "think like a computer". Well, for the philosophy behind the exam, "think like an organization", namely Oracle University. I can't find anything nearly this detailed in the Student Guide, therefore I conclude that this question will not appear on the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 06, 2004 1:34 PM To: Multiple recipients of list ORACLE-L thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables approximately 3m and 1.5m rows in size, that INDEX RANGE SCAN actually returns the first 25 or so records faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior. Surprised me. I've read some docs on this and I think that a range scan is always preferably when you only want a few rows? What am I missing? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 06, 2004 1:59 PM > Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other > methos despite the price. > > On 2004.01.06 13:44, Jay Wade wrote: > > Hello: > > > > I was looking through some OCP questions posted on the web and came across > > the one below. > > I believe the answer is (D), because the join type would be dependent on the > > number of rows within the table. Is this correct or does the OPTIMIZER_MODE > > set to FIRST_ROWS alter this behavior? > > > > > > The cost-based optimizer can choose between a nested loops join and a sort > > merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set > > to FIRST_ROWS. Which execution plan will be the result? > > > > a. The sort-merge join. > > > > b. The nested loops join. > > > > c. This depends on some sort parameter values. > > > > d. This depends on the number of rows in each table. > > > > _ > > Check your PC for viruses with the FREE McAfee online computer scan. > > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jay Wade > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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). -- Plea
Error after resize of LMT
Has anyone encountered the ORA-600[kcbnew_3] error after resizing and LMT in Oracle9i? A vendor install script created tablespaces really large, and I started to resize them smaller, but checked Metalink. There is a bug 2747978 that says in versions below 9.2.0.4 you can encounter an ORA-600 error after resizing. Oracle says they were able to reproduce it. The bug report says this produces a severe loss of service. As a workaround it says to bounce the database after resizing. I'm just trying to figure out how likely this error is to occur, so I though I'd ask if anyone has encountered this error. And if it occurred, how severe were the consequences? I can't apply the 9.2.0.4 patch because the vendor says they don't support that yet. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade your OCP
Awhile back on this list someone asked whether someone with an Oracle 7 or 8 OCP could upgrade their certification directly to 9i. I don't recall that question receiving an answer. If you are interested, the Jan/Feb issue of ORACLE magazine (otn.oracle.com/oraclemagazine) has an article named Upgrading Your OCP that explains how you can do this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi list
Congratulations. I know the feeling! Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 03, 2004 3:15 PM To: Multiple recipients of list ORACLE-L List, thanks to all of you I finally completed my OCP exams (thought they would never end) Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: encrypt back-up data
David - I haven't heard of this feature in Oracle. For one thing, there are many ways to back up Oracle data. Many of these methods are simply direct O.S. file copies. But most O.S.'s offer a file encryption utility that you could easily incorporate into your backup script. But if you choose to do this, be sure to test the recovery. Some utilities try to be helpful and remove "wasted" space in files. Oracle relies on the file being exactly what it created, empty space and all. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 02, 2004 9:54 AM To: Multiple recipients of list ORACLE-L Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman restore question
Joan - Which Oracle version? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A performance problem
Venu You are getting some good advice, but here is a different idea for you that nobody has mentioned. You say that the job formerly took 1 hour and now takes 20 hours. You also mention that you have a development environment. If you can locate the main SQL statement(s), you could run an EXPLAIN PLAN in both your production and development environments. This is not nearly as good a way to diagnose performance problems as the other advice you are receiving, but it has the advantage of being quick (Oracle doesn't actually execute the statement), and may put you on the track of what has changed with the execution plan. When they are after your head, quick is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 29, 2003 12:15 PM To: Multiple recipients of list ORACLE-L John, I can run this in our development environment and trace the job. But, the data is quite a bit larger in production. I can't really take on a refresh/clone now and the prodcution database is over 600GB in size. We do have trace for the job which was available because the program definition for this custom feed job has trace enabled in Apps. That trace file doesn't have any wait event information. This job does use db link. We know that for sure. I advised the developer who wrote this custom feed job to tune it but that is never a satisfactory answer for them. Venu Potluri -Original Message- John Kanagaraj Sent: Monday, December 29, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Venu, Trying to solve the performance issue with a *single* job with Statspack is like searching for a needle in a haystack, especially in an Oracle Apps environment. You will need to trace the program *as it runs*, and if you cannot do that right now, see if you can clone the database to a test system and rerun it again. Btw, was this concurrent job an Oracle standard job or was it a custom program? Any recent changes or patches to the environment? Note that you *can* set trace (albeit just the plain vanilla level 1) on a Concurrent job in 11i... As for the DB Link, can you determine if this indeed does use a Dblink or it is from somewhere else... [See the problem with Statspack?!] John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Potluri, Venu (CT Appl Suppt) [mailto:[EMAIL PROTECTED] >Sent: Monday, December 29, 2003 8:44 AM >To: Multiple recipients of list ORACLE-L >Subject: A performance problem > > >I have a performance issue in our 11.5.5 Oracle Apps >production environment (Oracle 8.1.7.4). A concurrent job that >feeds into another production envrironment (Oracle 9.2) and >runs less than an hour >typically suddenly took almost 20 hours to finish. The users >are as expected up in arms calling my head on a platter. I >looked at the statspack report for the database this job ran on. > >The Top5 Wait events were: > >Top 5 Wait Events >~ > >Wait Event Waits >Time (cs) % Total Wt Time >--- > >db file sequential read15,978,336 > 5,809,277 57.28 >SQL*Net message from dblink3,868 >1,960,168 19.33 >db file scattered read 2,460,279 >943,252 9.30 >control file sequential read 907,148 > 300,572 2.96 >pipe put2,033 >208,850 2.06 > - >-> cs - centisecond - 100th of a second >-> ms - millisecond - 1000th of a second >-> ordered by wait time desc, waits desc (idle events last) > > > Avg > > Total Waitwait Waits >Event WaitsTimeouts >Time (cs)(ms) /txn > -- >--- -- - >db file sequential read15,978,336 0 > 5,809,277 4970.3 >SQL*Net message from dblink 3,868 0 &g
DBA Unemployment
The U.S. government now tracks DBA jobs as an employment category. There are 75,610 people who call themselves DBAs and 6.46% are unemployed. Unfortunately they just started so we can't see what it was during the dot-com bust. http://informationweek.com/story/showArticle.jhtml?articleID=17100148 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standard Vs. Enterprise Edition for Application Compilation
Vivek - Sorry for the late reply, but I just returned from holiday and don't see where anyone has replied to your posting. My understanding is that your situation is exactly what Oracle has anticipated with Std. vs. Enterprise. Oracle's goal is that all differences be code-independent, so that you can compile applications for either version and they will work for the other. The only resource for differences between Std and Enterprise I've seen are Oracle's marketing materials. I don't know the name of the currently available document, just have to poke around. Something about a "Family of Products". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 23, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Hi Qs Does a Pro-C application (Banking) need to be compiled with Standard Edition as Oracle Libraries are being used in the Compilation OR can it be compiled with the Enterprise Edition & simply deployed elsewhere at Customer site containing the Standard Edition? NOTE Application is making OCI Calls to the DB. Does Standard Edition support the same? Qs Which are the important differences between Standard Edition of 8i/9i versus Enterprise Edition? Will provide any info needed Thanks Vivek -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Career Advice
Viktor, Ryan - Is what you are experiencing the result of companies moving to open-systems Web-based architectures? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 8:34 PM To: Multiple recipients of list ORACLE-L I agree with Ryan. Pure Oracle jobs aren't hot as they used to be. We are going through this right now. They are planning to bring in a bunch of new developers and splitting a few DBA's into dev. groups, which means we'll become more like software engineers (who can also do DBA stuff). There will be only one Prod. DBA for a zillion systems. They're driving in the direction of bringing in more cross-trained people. They want all-aroind people who know Perl, Java, Oracle etc. The motto has been: "If you get hit by a bus, he/she can do it". The more you know, the better. Cross-training all the way. It's like that all-in-one fax/printer/copier thing. And at the same time, the paycheck isn't as it had been either. Viktor [EMAIL PROTECTED] wrote: my biggest concern is the model for development has been changed. The model now is do most development with software engineers and have only a small number of database people. this means less pure oracle jobs. > > From: DENNIS WILLIAMS > Date: 2003/12/18 Thu PM 02:59:26 EST > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Career Advice > > Ryan - Excellent points. I well know the feeling of being tied to Oracle's > future. As to Oracle pricing itself out of the market, I would like to make > three points: > - Pricing is one of the quickest things a vendor can change once it > becomes convinced this is hurting it. On the other hand, I've seen software > vendors that stopped investing in new development. They aren't in business > anymore! because you can't quickly change that decision. > - Oracle being perceived as high priced tends to increase our salaries. A > company spends a lot of money on Oracle, so they want it used to good > advantage. The salary surveys I've seen show MS SQL Server DBA with lower > salaries on the average. > - Has anyone seen salary survey results for MySQL or PostgreSQL? The > database is free, so how much should a company spend on a DBA? > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Thursday, December 18, 2003 1:19 PM > To: Multiple recipients of list ORACLE-L > > > your goals should tie into the job market. you might absolutely love Pascal > programming, but I dont recommend studying it. > > Right now(and I dont know how it will fluctuate), there is far, far, far > more demand for Software Engineers who specialize in Java or .Net. Far, far, > far, more than people who specialize in the Oracle database. I think there > has been a fundamental shift in database development. In the past you would > hire mostly Oracle specialized people to do most of your development. They > would use forms or powerbuilder to do your GUIs. > > These days, a growing number of teams hire a large number of java or .Net > experts and only a handful of database people. is this the best way to go? I > dont know. I do see a trend though. How long will the trend last? I do not > know. > > The biggest problem for IT workers is that we are so tied to one specific > skillset and vendor. If Oracle prices themselves out of the market, our > skills become far less valued. Employees today want super specialized > skillsets. If you have them and they are hot, your set, but they wont be hot > forever and i! ts very hard to switch since people want experience in the > specific skillset before hiring you. > > > > From: "Thater, William" > > Date: 2003/12/18 Thu PM 01:44:37 EST > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Career Advice > > > > DENNIS WILLIAMS scribbled on the wall in glitter crayon: > > > > > Saira > > > I think you have to decide what your goal is. Then you need to > > > decide how to best accomplish that goal. One tool that can lead you > > > toward a goal is self-study. I have used that tool many times myself. > > > However, with experience you learn the self-study tool has its > > > limits. To consider self-study, consider the following questions: > > > > > > 1. Is this an area that I can gain significant knowledge with a > > > reasonable amount of effort? For example, are there good books > > > available? Is the area well-defined enough for self-study? > > > 2. Since I'm trying to substitute self-effort for work experience, is > > > this an area where there are few pe
RE: OEM permissions - thanks!
Raj, Thomas, Brad, Bill, anyone I forgot - I feel better about the situation now. Thanks for letting me run this issue past you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Raj - Thanks for your reply. Were this a consultant, my reply would mirror yours, and maybe not so diplomatically. But basically I manage these databases on behalf of this manager, so when he asks for "read-only" access, I can't really refuse. And I think he is pretty competent as a DBA. He says that he prefers to use OEM instead of Toad. What I'm really asking is what could these grants be used for besides just reading data? If there are other actions that could be done, I could at least ask him not to perform those actions, so if something bad happens I have provided an alert ahead of time. For those who use OEM in your environment, does the SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY privileges sound pretty usual for OEM to be able to scout out the info it needs to paint the pretty displays? Yes, I am checking out how this exposes links and what is available on the other systems the links point to. I have also asked his group not to create any database links. Fortunately we have relatively few links. Again, thanks for your advice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Dennis, "select any table" has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for One of our groups hired a new consultant and he (claimed to have DBA background) immediately shot off an email saying he needed "select any table" and "select catalog role" to do his work. We shot off reply "Thanks for your email, while we appreciate your requirements for development, the privileges you are requesting are a tad different than we grant other developers. However we request that you submit a justification for these privileges and tell us how your development would be affected without these and we will accommodate your request". This was 3 months ago and we _still_ haven't heard back. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, December 18, 2003 8:24 AM To: Multiple recipients of list ORACLE-L We have a new manager that wants his group to use OEM for development access, as an alternative to Toad. He has requested a special Oracle userid with the following grants: SELECT_CATALOG_ROLE SELECT ANY DICTIONARY SELECT ANY TABLE Does this seem reasonable for OEM? The manager is responsible for the data in the database, so I don't see a problem with him viewing the data. There are few database links, and I'll be reviewing them. Any ideas on what mischief could occur? Thanks. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, inc
RE: RE: Career Advice
Ryan - Excellent points. I well know the feeling of being tied to Oracle's future. As to Oracle pricing itself out of the market, I would like to make three points: - Pricing is one of the quickest things a vendor can change once it becomes convinced this is hurting it. On the other hand, I've seen software vendors that stopped investing in new development. They aren't in business anymore because you can't quickly change that decision. - Oracle being perceived as high priced tends to increase our salaries. A company spends a lot of money on Oracle, so they want it used to good advantage. The salary surveys I've seen show MS SQL Server DBA with lower salaries on the average. - Has anyone seen salary survey results for MySQL or PostgreSQL? The database is free, so how much should a company spend on a DBA? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 1:19 PM To: Multiple recipients of list ORACLE-L your goals should tie into the job market. you might absolutely love Pascal programming, but I dont recommend studying it. Right now(and I dont know how it will fluctuate), there is far, far, far more demand for Software Engineers who specialize in Java or .Net. Far, far, far, more than people who specialize in the Oracle database. I think there has been a fundamental shift in database development. In the past you would hire mostly Oracle specialized people to do most of your development. They would use forms or powerbuilder to do your GUIs. These days, a growing number of teams hire a large number of java or .Net experts and only a handful of database people. is this the best way to go? I dont know. I do see a trend though. How long will the trend last? I do not know. The biggest problem for IT workers is that we are so tied to one specific skillset and vendor. If Oracle prices themselves out of the market, our skills become far less valued. Employees today want super specialized skillsets. If you have them and they are hot, your set, but they wont be hot forever and its very hard to switch since people want experience in the specific skillset before hiring you. > > From: "Thater, William" <[EMAIL PROTECTED]> > Date: 2003/12/18 Thu PM 01:44:37 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Career Advice > > DENNIS WILLIAMS scribbled on the wall in glitter crayon: > > > Saira > > I think you have to decide what your goal is. Then you need to > > decide how to best accomplish that goal. One tool that can lead you > > toward a goal is self-study. I have used that tool many times myself. > > However, with experience you learn the self-study tool has its > > limits. To consider self-study, consider the following questions: > > > > 1. Is this an area that I can gain significant knowledge with a > > reasonable amount of effort? For example, are there good books > > available? Is the area well-defined enough for self-study? > > 2. Since I'm trying to substitute self-effort for work experience, is > > this an area where there are few people with real work experience? > > 3. Are there credentials that can be earned? > > i'd like to add one more... > 4. is this something where getting it right will still give you a charge > after doing it for 10 years or more? > > [and yes DBA and programming still do for me. but i'm finding the chances > of being allowed to do it right are becoming few and far between.] > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > [EMAIL PROTECTED] > > Time is an illusion, lunchtime doubly so. - Douglas Adams > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting serv
RE: OEM permissions
Raj - Thanks for your reply. Were this a consultant, my reply would mirror yours, and maybe not so diplomatically. But basically I manage these databases on behalf of this manager, so when he asks for "read-only" access, I can't really refuse. And I think he is pretty competent as a DBA. He says that he prefers to use OEM instead of Toad. What I'm really asking is what could these grants be used for besides just reading data? If there are other actions that could be done, I could at least ask him not to perform those actions, so if something bad happens I have provided an alert ahead of time. For those who use OEM in your environment, does the SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY privileges sound pretty usual for OEM to be able to scout out the info it needs to paint the pretty displays? Yes, I am checking out how this exposes links and what is available on the other systems the links point to. I have also asked his group not to create any database links. Fortunately we have relatively few links. Again, thanks for your advice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Dennis, "select any table" has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for One of our groups hired a new consultant and he (claimed to have DBA background) immediately shot off an email saying he needed "select any table" and "select catalog role" to do his work. We shot off reply "Thanks for your email, while we appreciate your requirements for development, the privileges you are requesting are a tad different than we grant other developers. However we request that you submit a justification for these privileges and tell us how your development would be affected without these and we will accommodate your request". This was 3 months ago and we _still_ haven't heard back. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, December 18, 2003 8:24 AM To: Multiple recipients of list ORACLE-L We have a new manager that wants his group to use OEM for development access, as an alternative to Toad. He has requested a special Oracle userid with the following grants: SELECT_CATALOG_ROLE SELECT ANY DICTIONARY SELECT ANY TABLE Does this seem reasonable for OEM? The manager is responsible for the data in the database, so I don't see a problem with him viewing the data. There are few database links, and I'll be reviewing them. Any ideas on what mischief could occur? Thanks. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OEM permissions
We have a new manager that wants his group to use OEM for development access, as an alternative to Toad. He has requested a special Oracle userid with the following grants: SELECT_CATALOG_ROLE SELECT ANY DICTIONARY SELECT ANY TABLE Does this seem reasonable for OEM? The manager is responsible for the data in the database, so I don't see a problem with him viewing the data. There are few database links, and I'll be reviewing them. Any ideas on what mischief could occur? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Viktor My suggestion is to go for Perl as the quick win and impress your new boss. Perl also tends to be more useful for DBAs. Learning Java can be a more long-term proposition. First, you need to have a strong understanding of object-oriented design. We have trained developers in Java, and it hasn't been a quick learn for them. Based on what I've seen, I would push for Java training. Also, before you tear into Java, you may want to get a basic understanding of how the web stuff like HTML works. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 17, 2003 6:24 PM To: Multiple recipients of list ORACLE-L Let's take this topic into a more concrete scenario. New boss, company reorg, cross-training is enforced and now DBA'S's are going to be split into development groups. Need to learn Perl(looking forward to it actually!!!) and Java. Books, web sites, docs - all these material is great. But what if you're expected to learn fast and I can learn quickly, but still, do you guys have some advice on how can one "express" teach himself. Managing expectation is one thing I need to talk with boss about. Surely I would not't want to be overwhelmed with stuff at the beginning. But at the same time I am kinda excited about picking up on Java and Perl. The questions is what are the tricks and tips for learning on a fast track? Thanks! Viktor Stephane Faroult <[EMAIL PROTECTED]> wrote: Believe somebody who first learned SQL back in 83, it's too late for Java now. Run-of-the-mill skill. Any young grad will know it and will be less expensive. ERP would be a good bet, because people learn them at work, mostly. Now, would a company change be justified just for that? Probably not. As you said, you are hired for what you know, not what you want to learn. Grasp opportunities, learn whatever looks to you useful - and fun. My 0.02 EUR. SF [EMAIL PROTECTED] wrote: > > learn java and object oriented programming. go to sun.com and start reading the java docs. > > go to www.bruceeckel.com and read his java book. > > do a search on any job sites. a ton more work for java than oracle. people who can do both are in demand. > > > > From: Mladen Gogala > > Date: 2003/12/17 Wed PM 01:49:25 EST > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Career Advice > > > > Have you ever considered a career in country music? Try getting "Stand By your man" > > just right and the rest will come. You have to learn both kinds of music, country > > and western. May Jake and Elwood be with you. > > > > On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: > > > As an applications analyst/junior dba, I feel I need to learn more but > > > I'm not sure of the direction I should take, so I'm asking for advice. > > > > > > Should I become interested in Oracle Apps? Or should I learn another > > > suite like SAP or Siebel or PeopleSoft? The difficulty is that my > > > company does not use any of these. We use a smaller package by Tecsys > > > called Eli! te and they don't have as many customers - or should I say, as > > > many customers with deep pockets. > > > > > > I know I can get my hands on a working copy of SAP, what about the > > > others? I believe you can purchase an evaluation copy of Apps from the > > > Oracle Store. Has anyone actually tried to train themselves on any of > > > these products? Has anyone installed Apps at home for testing? > > > > > > Sorry if this question has been presented on the list before. > > > > > > Thanks, > > > Saira > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do you Yahoo!? Free <http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> Pop-Up Blocker - Get it now -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Saira I think you have to decide what your goal is. Then you need to decide how to best accomplish that goal. One tool that can lead you toward a goal is self-study. I have used that tool many times myself. However, with experience you learn the self-study tool has its limits. To consider self-study, consider the following questions: 1. Is this an area that I can gain significant knowledge with a reasonable amount of effort? For example, are there good books available? Is the area well-defined enough for self-study? 2. Since I'm trying to substitute self-effort for work experience, is this an area where there are few people with real work experience? 3. Are there credentials that can be earned? If you are considering putting significant effort into this area, it is invaluable to do some informational interviews. Find someone that does the work you would like to or hires people that do the work. Interview them to find what skills and experiences are required and how you would acquire those skills and experiences. Ask what their career path was as an example. Many career advice books describe how to secure and conduct informational interviews. In a way, that is what you are doing on this forum. You have received some great replies to your posting. I think the wide range of replies are indicative of the problem. The ERP packages are very large, complex, expensive, and critically important for the client organization. The big packages like SAP and Oracle Apps are nearly always used by very large corporations. There are a wide range of people that work with these packages, from specialized business users all the way down to the lowly DBA. Ideally, at a corporation, the various people work together as a team, pooling their knowledge and skills. Often these applications are installed by a team of vendor installers that travel the world doing just that task. And even if you did manage to get the application installed on your laptop, it would probably take a lot of training to operate significant portions of the application. When one of these applications are installed at a corporation, there are weeks of training for many different people throughout the organization. I would strongly suggest that you first focus on your DBA skills. This list is an excellent source of insights in how to deepen your DBA skills. You might consider researching the Oracle interface for the various applications. However, in general this part of the application is not well documented, even in the vendor documentation. But you might be able to decode a significant amount of the interface. And you goal would be to learn enough to exhibit a keen interest in learning to a prospective employer that might consider hiring you over other candidates. If they are able to easily find candidates with years of experience . . . well, it isn't going to be very promising for you, regardless of how much self-study you've put in. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 17, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Is it that difficult though? Just to get familiar with it... if you've worked with other similar software before? I guess you'd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no? Thanks, Saira -Original Message- king Sent: December 17, 2003 1:55 PM To: Multiple recipients of list ORACLE-L That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message - To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L Sent: Wednesday, December 17, 2003 1:09 PM Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared "Saira Somani-Mendelin" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROT
RE: After 256 connections : ORA-12154
Jay - You have received some great suggestions on this and no doubt you are researching them. I'll offer a slightly dumber long shot, but easy to check. What is your PROCESSES set for this instance? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Dear Gurus, We are getting the following error if we try to create more than 256 connections from the same client. The problem is easily reproducible bt writing simple java program and keep creating connections(do not close it). Did anyone encounter this kind of issue and how did you solve it? Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve service name at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.fillInStackTrace(Compiled Code) at java.lang.Throwable.(Compiled Code) at java.lang.Exception.(Compiled Code) at java.sql.SQLException.(SQLException.java:43) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code) at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code) at oracle.jdbc.driver.OracleConnection.(Compiled Code) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code) at oracle.jdbc.driver.OracleDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at j1.main(Compiled Code) Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: table partitions
Rick - Well, a simple way to do it might be to create 5 years of partitions, based on date as described. Then map all the Jan partitions to the same tablespace, Feb partitions to the same tablespace, etc. Instead of truncating a partition, just drop it to reclaim the space. Crude, but might meet your needs without adding a new column. If you are still working there in 5 years, then congratulate yourself and create another 5 years of partitions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Yes, this is what I was looking for. I don't care about the year, and don't want to worry about adding new partitions for every new month that comes along each year. This table will only needs to contain six months worth of data. I will not be archiving it at all. I wanted to truncate the data/partition after it was 6 months old. Thanks, Rick Stephenson -Original Message- Sent: Tuesday, December 16, 2003 6:49 AM To: Multiple recipients of list ORACLE-L >From what I understood, he's asking how to put all January records in one partition, all Feb in another etc. So you end up with 12 partitions for as many years as you wish. I could not think of any other solution then the one he does not want to. rw > Your high value for each partition can just be the beginning of every > month. For example: > > CREATE TABLE ACCOUNTS > ( > STATEMENT_DATE DATE NOT NULL, > ACCOUNT_NUMBER VARCHAR2(8)NOT NULL, > BILLING_CYCLE VARCHAR2(2)NOT NULL, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wartiak Rastislav INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rick Stephenson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to refresh
Ron - As far as losing the new functions, this is one reason we've moved to a 3-instance layout. Production, staging, and test. This takes off a lot of the pressure for overwriting test as you describe. Other than that, it becomes a matter of negotiation. Describe what your options are, and let them decide which option they choose. Also suggest that everything in test (except maybe data changes users have made) should be based on scripts. If they've created functions, they should have scripts to recreate those because that is what they are eventually going to have to do in production (or in staging, if you implement that). Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 8:59 AM To: '[EMAIL PROTECTED]' Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact replica in all respects, and you can test your backup as a bonus. If you are interested in this method, tell us how you backup your production database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 8:55 AM To: Multiple recipients of list ORACLE-L I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to refresh
Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact replica in all respects, and you can test your backup as a bonus. If you are interested in this method, tell us how you backup your production database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 8:55 AM To: Multiple recipients of list ORACLE-L I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Good news from Oracle
Oracle is posting healthy profits. http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: connection pooling from an application server to oracle
Well said, Thomas! The longer I'm a DBA the more I find that having the right reply (like your example) is than necessarily being able to provide a thorough technical explanation they won't understand anyway. Obviously I still want to have the technical understanding. Thanks for sharing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 15, 2003 9:54 AM To: Multiple recipients of list ORACLE-L But Mladen, sooner or later, somebody is going to wise-up and catch you in your attempt at passing the blame. When this happens to me, I quote to 80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or rewrite). If they say "The database is slow", I say "Show me the sql that is slow". If they say "I can't because it is coming from the app", i say "Then I can't help you". This focuses everyones' energy into the correct place. If they built a monster that they can't debug, it's not my fault. If they can show me the sql, I can show them either how poorly it is written, or provide a new index to support them. In my mind, this is a much more productive way of doing business. And, as I said, if they choose a specific app server without my input, then it's not my problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 15, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Such app server side connection pooling is a nightmare for a DBA. Http pages ([aj]sp junk,php,mod_plsql,mod_perl using Apache::DBI) will each open one connection per page, as well as most CGI scripts (Adam von Nieda's exquisite oracle tool on http://www.oracletool.com is what comes to mind). If there is a problem with SQL, DBA has a way of finding out who is doing what because each session is connected to a single server process, which can then be located. With app server pooling, you have a single user logged in multiple times and each dedicated server can be used to execute any single SQL statement. With iPlanet, it looks like this: Application invokes bean, pumpkin or servlet which has something to do with oracle. The app server pooling mechanism will allocate one of the already established dedicated server connections, which will perform the work. When the same user executes another vegetable (EJB or servlet), he or she may do so within a different dedicated server connection. We have a situation in which a single user utilizes several dedicated server connections within a single logical screen. Whenever faced with a choice, I try preventing that from happening and make users connect to dedicated servers with different usernames and sessions which can be tied to the user. If I can't prevent it, I always use cache hit ratio (which tells me nothing) for blame shifting game. Buffer cache hit ratio can always be interpreted in such a way that you can blame someone else. It's a DBA version of sun flares excuse found on Simon Trevaglia's wonderful BOFH web site. I am a DBA and it is my job to interpret database statistics. The database statistics tells me that application server pooling is naughty and sinful and should not be utilized. Q.E.D. It's not me, it's BCHR. If I am persistent enough, I can get it off the system. Who was saying that BCHR isn't useful? On 12/15/2003 09:49:26 AM, Justin Cave wrote: > At 05:59 AM 12/15/2003, [EMAIL PROTECTED] wrote: > >The software engineers here are using an application server with > >connection pooling to connect to our oracle instances. > >They are doing it with a dedicated connection to Oracle. No MTS. > > > >This concerns me. how do you handle transaction control in this type of > >environment? in this type of environment do you have to commit after every > >DML statement? since multiple users will access the database with the same > >conneciton? > > You may have only, say, 10 connections that are servicing 100 users, but > each user will appear to have his or her own, dedicated connection. This > works because users are going to tend to "open" a connection, do some work, > and "close" a connection in short order. > > The classic example of the utility of a connection pool is a web > site. Since HTTP is a stateless protocol, most JSP pages will open and > close a connection each time a user requests a page. Within the scope of > generating the page, the JSP engine will issue a few SELECT statements and > may do a little DML. Since it takes a fraction of a second (we hope) to > generate a single web page, opening & closing a physical connection would > obviously take an order of magnitude more time than generating the contents > of the page, the application server can be set to maintain a set of > permanent dat
RE: connection pooling from an application server to oracle
Ryan It depends on the application. For most applications the app. server connection pooling works satisfactorily (with grumbling from the DBA). For other applications that isn't good enough. An example might be a high-security financial application where you must trace each connection and transaction back to a specific user. Everyone has their own Oracle username. Bale's book Java Programming with Oracle JDBC describes three connection models for Java programs. http://www.amazon.com/exec/obidos/tg/detail/-/059600088X/qid=1071503575//ref =sr_8_xs_ap_i1_xgl14/103-7713527-1855831?v=glance&s=books&n=507846 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 15, 2003 6:59 AM To: Multiple recipients of list ORACLE-L The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS. they compartmentalize stuff here, so Im having trouble figuring out exactly how this affects the database and how to monitor performance. All I know is that I see a handful of constantly open dedicated connections. I have been told that this is actually alot of users connecting to the database. This concerns me. how do you handle transaction control in this type of environment? in this type of environment do you have to commit after every DML statement? since multiple users will access the database with the same conneciton? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: automate backup and export
John What is your intention? If you have created a test Oracle database on your Linux system just to learn, then just shut the database down and back up all files. If you have some important data in this database that changes frequently, then you need to learn about Oracle backup & recovery. More than a simple script, you need to understand your backup and recovery requirements as well as your scripts so you can ensure the requirements are being met. And you need to test your backup because a crash is no time to find out your method was flawed. All of this is much broader than we can cover in a few short emails or even a web site. Oracle Education teaches a nice week-long course on this. I found the book Oracle Backup & Recovery 101 by Smith and Haisley to be an excellent tutorial for the various types of Oracle backup methods. They take you step-by-step through tutorials on the different methods. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, December 13, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Any reference concerning the rman? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 10:19 PM > Yes. It's called "RMAN". > On 12/12/2003 02:04:46 PM, John wrote: > > Do you know any script for doing export and backup of Oracle 9i R2 server? > > > > My oracle is on a SuSE linux. > > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
Mladen Okay, now you've done it. Bear in mind that I grew up about 100 miles from Bentonville. Yew fancy-schmancy city slickers just don't know what good eatin is. Get a couple of your buddies, their coon dawgs, copius quantities of beer, and just relax in the back yard, drinking, eatin pickles, and shooting anything that comes to mind. Sorry, that is the best I can do on the spur of the moment. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 12, 2003 10:49 AM To: Multiple recipients of list ORACLE-L http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT April, I wasn't saying that they were dumb and I know that the stuff is selling but I must admit that I would have a problem consuming a gallon of pickles before they get moldy and yucky. I'd probably turn into a pickle after that. I wasn't critical of Wal-Mart, they're only catering to the market demand, but I find it incredible that market demands gallon sized jars of pickles. What is next? 50 LBS bag of Hershey's kisses? On 12/12/2003 11:24:25 AM, April Wells wrote: > > A 9 year old little girl who will BUY pickle juice at school will insist on > gallon jars of (good) pickles. Walmart isn't dumb, they know what they can > and can't sell. > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > /\ > / \ > / \ > \ / > \/ > >\< > \ > >\< > \ > Few people really enjoy the simple pleasure of flying a kite > Adam Wells age 11 > > -Original Message- > Sent: Friday, December 12, 2003 9:54 AM > To: Multiple recipients of list ORACLE-L > http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT > > > > > > > Jonathan is correct - WalMart uses Teradata. > > And they're selling gallon-sized Vlasic pickles. I always wondered who > was buying such a monstrosity. It's a bi-annual pickles supply in a single > package. > > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. > > Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [
RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
Mladen I'm pretty confident of one thing -- if they weren't selling, Wal-Mart would quickly stop selling them at that store. Most people don't think about it, but Sam Walton figured out a couple of things early on: 1. If you don't have the item on the shelf, people can't buy it. 2. Hire a smart computer systems manager. 3. Your control of your own data is a competitive weapon. The system they created was flexible enough to be expanded to many, many stores. In his book "Sam Walton: Made in America", Sam lavishes praise on his systems people. The Kmart leadership, on the other hand, was often quoted in the press about how they were able to reduce their I.T. expense. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 12, 2003 9:54 AM To: Multiple recipients of list ORACLE-L http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT > > Jonathan is correct - WalMart uses Teradata. And they're selling gallon-sized Vlasic pickles. I always wondered who was buying such a monstrosity. It's a bi-annual pickles supply in a single package. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
-Original Message- Sent: Friday, December 12, 2003 9:54 AM To: Multiple recipients of list ORACLE-L http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT > > Jonathan is correct - WalMart uses Teradata. And they're selling gallon-sized Vlasic pickles. I always wondered who was buying such a monstrosity. It's a bi-annual pickles supply in a single package. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning in complex environment
Avnish - Since nobody has mentioned it yet (my posts arrive late, so probably will by the time this appears), get Cary Millsap's book Optimizing Oracle Performance http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid =6WIANMIL0H&isbn=059600527X&TXT=Y&itm=1 His methods sound exactly suited to your issues. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: char is going away?
Raj, Jonathan 1. I have heard rumors that in other databases the VARCHAR performance isn't good. In fact, some people that are converting from other databases to Oracle are pleasantly surprised that Oracle handles VARCHAR well. 2. I have been curious about Oracle's statement that you should use VARCHAR2. If I was a suspicious person I would say that sounded like a vendor's attempt to encourage proprietary coding, but I'm not suspicious, no way. My point isn't that VARCHAR isn't there, of course it is, but if you were developing an application to sell and support on several different databases, you might consider CHAR as a safer bet. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Oracle has varchar and varchar2 both ... The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types .htm#10824 HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 1:55 PM To: Multiple recipients of list ORACLE-L DW> If your application is COBOL-based, using CHAR DW> simplifies things quite a bit. True enough. I'd forgotten about COBOL. The semantics of COBOL's PIC X fields match up pretty closely (exactly?) to SQL CHAR fields. DW>My understanding is that VARCHAR2 is not even a SQL standard The keyword VARCHAR2 is not in the standard, but a variable-length type is. I think the standard uses CHARACTER VARYING, or something like that. I don't have time to look it up right now. DB2 uses VARCHAR, without the "2". I'm not sure why Oracle is so outspoken against that same keyword. I'd be interested in finding out. Best regards, Jonathan Gennick --- Brighten the corner where you are ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: accounting software
Grace Take a look at Lawson Software -- http://www.lawson.com Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 9:34 PM To: Multiple recipients of list ORACLE-L can anyone recommend accounting software for mid-range distribution company that uses oracle as database? Best Regards, Grace Lim Suy Sing Comm'l Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
Jonathan My understanding is that VARCHAR2 is not even a SQL standard, and some databases don't handle VARCHAR very efficiently, so if you are trying to sell a product that can adapt to several databases besides Oracle, you might stick to CHAR. If your application is COBOL-based, using CHAR simplifies things quite a bit. Especially if you sell your application to many sites that want to use Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah it wastes a bit of disk space. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
-Original Message- Sent: Wednesday, December 10, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote: GG> Someone told me that Oracle is planning to retire char GG> variable and therefore they need to be replaced by GG> varchar2. Has anyone heard anything about it? I've not heard anything like this. I'm skeptical that it's true. The ANSI standard defines a fixed-length type analogous to CHAR, so phasing out CHAR would seem to take Oracle in a direction *away* from the standard, and that seems out-of-character. Lately, Oracle seems to have emphasized compliance with the SQL standard. Would it even make sense to dispense with CHAR? I admit, I've never found it too useful, but I'm sure there are applications that use it. Any phase-out would surely need to take place over a very long period of time. What good reasons might an application have to use and depend on CHAR variables? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char is going away?
Gene Was another part of the rumor that Oracle was going to retire SQL standard compatibility? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Documenting databases
Alan - First the bad news. Obviously you can't automatically get all that information, but then you knew that. The good news. I think you'll find that information to be very valuable. I try to collect that myself. A spreadsheet or Access database is probably as good a way as any. If you have a help desk, they may be able to store this information as a configuration (or CI) in their tool. Another piece of data to consider is the database links. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> c.com> cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: > Recently our database manager has asked us to do the unthinkable > document our databases! To make matters worse, and without our input, he > went ahead and created a schema and put it in an Access database (using > tables to make it look like a speadsheet). Either we use his idea or come > up with something else. > So, I thought I'd ask everyone on the list how you do it. Text files? > In a database (oracle, or other)? Spreadsheets? What are the pros and > cons? Etc > How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
Markus - Thanks for your ideas. Basically our issue isn't Oracle logins, but Oracle connections (replacing tnsnames.ora). For us, the user doesn't directly log into Oracle, but the application handles the login for them. However, I was searching for an alternative to maintaining tnsnames.ora on each client. I considered the Oracle Names server, but Oracle has announced this is going away in favor of OID. But my network guys favor MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 10:09 AM To: Multiple recipients of list ORACLE-L NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files. We had it once, but this was rather tricky to get it working at that time. Especially the uploading of certificates thet we made ourselves ... - but we had already a solution to update the OID on a daily/hourly basis for user authentication. We then decided not to use/need it, because we only need IAS authentication for users who have an NOVELL account - about thousand people like employees, students, parttimers... MS AD: we don't have it. may I propose: you need an interface or procedure - possibly java or even c. Then configure ORACLE to use this procedure, and update e.g. on an hourly basis. You must make up your mind who (MS or OID) administers - esp changes - passwords. kr MR >>> [EMAIL PROTECTED] 12/09 3:59 >>> Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr >>> [EMAIL PROTECTED] 12/09 1:54 >>> You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 1:54 PM > we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. > BUT: we taylored it to our needs - and do NOT use OID at all. > kr > mr > > >>> [EMAIL PROTECTED] 12/09 9:59 >>> > IIRC Oracle is going to support only OID as LDAP. > You need to set up OID and use a product like DIRXML to propagate updates > from Novell to OID. > > Yechiel Adar > Mehish > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, December 08, 2003 4:34 PM > > > > Hi, > > > > We are in the preliminary analysis of implementing an assurance package > (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web > Services and Forms on AIX 5.2). > > > > We are using Novell eDirectory as our LDAP. > > > > I looked on Metalink but did not find much thing. The way I understand it > is that you must load the LDAP info into Oracle Internet Directory. > > > > Am I right ? > > > > Anybody using Novell eDirectory integrated with Oracle ? > > > > TIA > > > > > > Stephane Paquette > > Administrateur de bases de donnees > > Database Administrator > > Standard Life > > www.standardlife.ca > > Tel. (514) 499-7999 poste 7470 > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephane Paquette > > 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
RE: OpenLDAP instead of OID
Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote: > Dear All, > > I have emailed to Jeff and his link is back up. > > Kind Regards, > > > Hatzistavrou Yannis > > > > -Original Message- > Sent: Tuesday, December 09, 2003 7:19 AM > To: Multiple recipients of list ORACLE-L > > > Stefan Jahnke and Denis Williams have recently posted recipe for > replacing OiD with OpenLDAP. > The road runner page is no longer accessible. Does anybody have a copy? > If so, please publish > the location, because I'm trying it right now. Please, if anybody has > that page, post it again or forward it > privately. Thanks in advance. The message I'm talking about is below. > > > -- > Mladen Gogala > Oracle DBA > > > > -Original Message- > DENNIS WILLIAMS > Sent: Monday, August 18, 2003 11:30 PM > To: Multiple recipients of list ORACLE-L > > > Congratulations Stefan! >Thanks for posting this. > Do you (or anyone else) have any ideas for doing this with Micro$oft > Active > Directory? > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, August 18, 2003 8:15 AM > To: Multiple recipients of list ORACLE-L > > > Hi list > > Some people where interested in feedback regarding the usage of OpenLDAP > instead of OID or Names to resolve TNS strings. Seems to work ;). Here > is > what to do: > > Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use > CygWin to test it locally on my laptop. > > Bill of materials: > > CygWin http://www.cygwin.com, I used the latest version, 1.5.2-1test > > Oracle Client, version >= 8.1.6.x > > OID LDIFS, can be taken from $ORACLE_HOME/ldap/admin, if the OID option > is > installed, or from > Oracle Disks: > Disk3\stage\Components\oracle.oid.server\9.2.0.1.0\1\DataFiles\admin.1.1 > .jar > > HowTo: http://home.nc.rr.com/jtlayton/oid2openldap.html > > Simply follow the howto to get openldap running and include the OID > schemas. > > Then, create an ldap.ora under $ORACLE_HOME/network/admin, which looks > like > this: > > DIRECTORY_SERVERS=localhost:389 > DIRECTORY_SERVER_TYPE=oid DEFAULT_ADMIN_CONTEXT="cn=Manager,dc=world" > > .. and change sqlnet.ora to contain: > > NAMES.DIRECTORY_PATH= (LDAP) > > Finished, enjoy. > Stefan > > Stefan Jahnke > Consultant > BOV Aktiengesellschaft > Tel.: +49 201/45 13-289 > mailto:[EMAIL PROTECTED] > http://www.bov.de > Abonnieren Sie unseren Newsletter: http://www.bov.de/enews > > Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am > 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder > mailto:[EMAIL PROTECTED] > > Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht > unter > fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten > wir > um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die > rechtliche > Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen > ausschliessen. > > As you are probably aware, e-mails sent via the Internet can easily be > copied or manipulated by third parties. For this reason we would ask for > your understanding that, for your own protection and ours, we must > decline > all legal responsibility for the validity of the statements and comments > given above. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stefan Jahnke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > -- > Please see the official
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr >>> [EMAIL PROTECTED] 12/09 1:54 >>> You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 1:54 PM > we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. > BUT: we taylored it to our needs - and do NOT use OID at all. > kr > mr > > >>> [EMAIL PROTECTED] 12/09 9:59 >>> > IIRC Oracle is going to support only OID as LDAP. > You need to set up OID and use a product like DIRXML to propagate updates > from Novell to OID. > > Yechiel Adar > Mehish > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, December 08, 2003 4:34 PM > > > > Hi, > > > > We are in the preliminary analysis of implementing an assurance package > (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web > Services and Forms on AIX 5.2). > > > > We are using Novell eDirectory as our LDAP. > > > > I looked on Metalink but did not find much thing. The way I understand it > is that you must load the LDAP info into Oracle Internet Directory. > > > > Am I right ? > > > > Anybody using Novell eDirectory integrated with Oracle ? > > > > TIA > > > > > > Stephane Paquette > > Administrateur de bases de donnees > > Database Administrator > > Standard Life > > www.standardlife.ca > > Tel. (514) 499-7999 poste 7470 > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephane Paquette > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Markus Reger > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from).
RE: RMAN restore on another server
Brian - My sys admin pleads amnesia on the NFS problem. My recollection was
that it was misconfigured or had a default configuration that expected only
a couple of connections and RMAN actually opens MANY file connections. My
specific symptoms is that RMAN would create the first few data files and
then just stop. Oracle Support made me take NFS out of the mix and then
everything worked.
In your case, I am also concerned about the control file. I was unable to
get 8i to create the control file from the backup although others on this
list reported success with that. I would feel better if you said that you
separately backed up the control file at the end of the RMAN backup, and
manually moved that control file into place on the test system. At least you
would eliminate that as the problem.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, December 08, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)
1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
and other locations as pfiles...edited the init file for new control
locations
etc.
4. The controlfile was wrapping in the backup piece same backup command
5. It is an NSF mount point. (Netapp)
Is there a solution with the NFS issue?
Brian Spears
Database Services
[EMAIL PROTECTED]
Limitedbrands
TECHNOLOGY SERVICES
-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L
Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
Sorry, but that is all my brain can think up on Friday.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the "RMAN-03022: compiling command: set " and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
<mailto:rman81740/[EMAIL PROTECTED]>
2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk ;
12>
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16> set newname for datafile 1 to
RE: RMAN restore on another server
Brian - I think that is the problem -- you can't tell RMAN you are on a
different server. The part I'm not getting a clear picture on is your
control file. For this specific recovery, how is it getting a control file?
Did you move one over from production, or are you waiting for RMAN to cough
it up from the backup pieces? On 8i this tends to be a problem.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, December 08, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
I have ftp'd the backup pieces into the identical backup location as the
orignal server so I have all the stuff available... Im just wondering if I
have to do something to tell it that I am on a different server...
I've restored the controlfile mannually before but on the same server. I
backup the controlfile and wrap in the backup piece with the normal backup.
Brian
-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L
Janardhana - That's a good point.
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
May be you try the following:
If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.
-- Janardhana
-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the "RMAN-03022: compiling command: set " and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
<mailto:rman81740/[EMAIL PROTECTED]>
2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk ;
12>
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16> set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18>
19> set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21>
22> set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24>
25> set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27>
28> set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30>
31> set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33>
34> set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36>
37> set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39>
40> set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42>
43> set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45>
46> set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48>
49> set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51>
52> set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54>
RE: Oracle and Novell eDirectory LDAP
Stephane - Last week the following message was posted. While it relates to MS AD, rather than Novell, the principles are the same and after all LDAP is a standard -- right? ;-) So you may want to scan the archives for this thread. Several people have expressed interest in this topic, and it seems doable, but nobody has posted a success story. From my meager understanding of LDAP, I think you will have to install and run Oracle Internet Directory, at least to get started, then export an LDIF from OID and import it into eDirectory. Depending on how you intend to use LDAP, you may have to continue to synchronize the two. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 03, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Embarrassed by Google/OTN, after stating I had not had time to verify what version integrates with AD, I spent 10 mins on Google and OTN (Oracle Technology Network) and hey presto :- "With Oracle9i Application Server 9.0.4, Oracle will offer prepackaged connectivity solutions for NT Domains and ADS. These solutions will allow Oracle customers to perform two-way synchronization of directory data between the Windows and Oracle environments." Therefore the answer is any version prior to Oracle 9i Application Server 9.0.4 does not have out-of-the-box integration with Active Directory. -Original Message- Sent: Monday, December 08, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor problem
Jacinta Okay, back to my second question. How are you doing connection pooling? Do you have an application server with a connection pooling feature, or are you writing your own connection pooling in Java, or are you using connection pooling on the Oracle database side? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, December 07, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi again :) The app is written in Java. I am using JDBC to connect with oracle. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Jacinta - What language is the app written in? Java? > How are you doing > connection pooling? With Oracle? > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, December 05, 2003 2:54 PM > To: Multiple recipients of list ORACLE-L > > > Dear All > > My application uses connection pooling. I do not > want > to end a connection "con.close()" because this will > end the connection from db but just want to release > the connection. In my app , i specify > releaseconnection . But how come all the cursor > still > open when i query this : > > select user_name, status, osuser, machine, > a.sql_text > from v$session b, > v$open_cursor a > where a.sid = b.sid > > Thank in advanced > > regards > jacinta > > __ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Kean Jacinta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: create table as select
Bulbultyagi My recollection is that with a LONG datatype you cannot use a create table as select, but must use the COPY command. I cannot confirm whether COPY is available in 10g. Sorry. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, December 07, 2003 8:04 AM To: Multiple recipients of list ORACLE-L List , I am using Oracle 9.2.0.1.0 enterprise edn on windows. I have a table with a long datatype column. Is there any way of duplicating this table using the "create table ... as select" command ? or do I have to use the copy command ? Is the copy command present in 10g ? > desc s_warehouse Name Null?Type -- -- . ADDRESSLONG > create table test as select * from s_warehouse ; create table test as select * from s_warehouse * ERROR at line 1: ORA-00997: illegal use of LONG datatype -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN restore on another server
Janardhana - That's a good point.
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
May be you try the following:
If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.
-- Janardhana
-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the "RMAN-03022: compiling command: set " and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
<mailto:rman81740/[EMAIL PROTECTED]>
2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk ;
12>
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16> set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18>
19> set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21>
22> set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24>
25> set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27>
28> set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30>
31> set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33>
34> set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36>
37> set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39>
40> set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42>
43> set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45>
46> set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48>
49> set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51>
52> set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54>
55> set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57>
58> set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60>
61> set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63>
64> set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66>
67> set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69>
70> set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72>
73> set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75>
76> set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78>
79> set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81>
82> set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84>
85> set newname for datafile 24 to
86>
RE: RMAN restore on another server
Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
Sorry, but that is all my brain can think up on Friday.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the "RMAN-03022: compiling command: set " and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
<mailto:rman81740/[EMAIL PROTECTED]>
2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk ;
12>
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16> set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18>
19> set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21>
22> set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24>
25> set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27>
28> set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30>
31> set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33>
34> set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36>
37> set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39>
40> set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42>
43> set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45>
46> set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48>
49> set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51>
52> set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54>
55> set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57>
58> set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60>
61> set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63>
64> set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66>
67> set newname for datafile 18 to
68> '/
RE: Cursor problem
Jacinta - What language is the app written in? Java? How are you doing connection pooling? With Oracle? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Dear All My application uses connection pooling. I do not want to end a connection "con.close()" because this will end the connection from db but just want to release the connection. In my app , i specify releaseconnection . But how come all the cursor still open when i query this : select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid Thank in advanced regards jacinta __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
Well said, Ryan! I have about the same number of instances, all on Sun. Development responsibilities also. One DBA. Time off is difficult. Excellent advice on emailing results. I have found the tools cause you about as much maintenance as they might save, so I favor simple scripts with emailed results. If you have time to visit each instance each day, you have way too much time on your hands. But I can recall those days when I only had 2 instances too. Fondly recall. For user/developer requests, the magic phrase I've found is "can I do that for you tomorrow morning?" Before leaving for the day I prepare a list of tasks for the next morning, and when I arrive I defer anything that I can to concentrate on my list and ticking off tasks on that list. Try to get meetings moved to the afternoon. Just basic time management, and everyone is different. For mature applications, I've found autoextend on datafiles to be a big time-saver. I've used that for many years now and only been bitten by that a couple of times. Much simpler to watch one number (available disk space) than dozens of numbers. For deployment, we are working toward ITIL procedures. We have test, staging, production instances for most databases, so I and developers can deploy against a staging instance before inflicting a deployment on production. Staging is a fresh clone of production. Naming standards are good, but I have found that some sites get so wrapped up in them that they cause more work than they prevent. Often packaged applications are mainly tested against their default configuration so if you insist on changing everything to meet your standards, you end up finding bugs nobody else found. One technique I have had good results with is to prepare an audit sheet and when time is available, pick an instance and audit it for security, performance, recoverability, etc. During the audit, make up a list of tasks to perform on that instance, and as time permits, execute those tasks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 1:09 PM To: Multiple recipients of list ORACLE-L We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. > > From: [EMAIL PROTECTED] > Date: 2003/12/05 Fri PM 01:49:30 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Database management techniques and frameworks > > Folks, > > I thought it'd be interesting to take a survey on what techniques and > frameworks DBA's on this list use to manage their Oracle databases. I > imagine that some of us manage only a single database and instance, but in > those configurations where there are many instances, multiple databases, > different platforms/versions, etc., what are some of the strategies for > management in place? What daily tasks do you perform, and how do you > organize them? How do you manage user requests (individually or as part > of a larger environment)? How do you handle jobs? Organization > techniques? Naming standards? User/application deployment framework, > etc., etc.? > > (Obviously we could write a book about this -- there's an idea! -- but > summaries and pointers would be interesting. Perhaps we can come up with > a best practices document and associated framework for Oracle database > management.) > > Thanks, > > Adam > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send a
RE: Export table to determine extent of block corruption
Rhojel - I'm not sure if export gives you enough information. Usually the reason to export is that if you can export, you have a good copy of the data and you can breathe a little easier. But usually export will fail on the first corrupt block. Your corrupt block may be an index block, so export might succeed. Doing a quick Google search yields http://www.quest-pipelines.com/newsletter-v4/0103_C.htm <http://www.quest-pipelines.com/newsletter-v4/0103_C.htm> . I haven't read it in detail, so I can't vouch for its accuracy. Metalink is another way to get some good advice for a problem like this. The last time I had this problem I saved Note 34371.1, but that may be obsolete now since it was about 5 years ago. But the horror seems like yesterday. Good luck. Now you've given me nightmares. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 04, 2003 9:14 PM To: Multiple recipients of list ORACLE-L Hi Everyone! This is my first time to encounter data block corruption in my entire DBA life(just 2 years FYI) =-) (this is not something to be happy about but heck of an experience). I'd like to know the extent of information that I can get from exporting that table that I believe has the corrupted block.. will I be able to know the absolute file# (AFN), relative file# (RFN), and the block# from the error that EXP will return> Regards, Rhojel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RMAN questions
Ryan - No, the documents imply that it is one or the other. My tasks was to perform a disaster recovery, and it seemed pretty hard to configure a catalog on a test server, so I just tried the controlfile method and discovered it worked. If you are on Oracle 9i, it backups the control file for you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 04, 2003 10:50 AM To: Multiple recipients of list ORACLE-L i must have misread the docs. i thought it was either catalog or control file. didnt know you could do both thanks. > > From: <[EMAIL PROTECTED]> > Date: 2003/12/04 Thu AM 11:04:26 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RMAN questions > > > I suppose just how much redundancy makes you sleep well is up to you. But, > one additional bit of info to keep in mind is that the backup info also gets > stored in the control files, and rman can use those too if no catalog > database is available. Making a copy of a control file after the backup > finishes, and saving that copy, can be a part of the rman backup. That way, > if you lost all control files and your catalog database, rman can use your > saved control file copy get back at least most, if not all, of your stuff. > > > -Original Message- > > > > Any suggestions would be appreciated. I can handle the > > scripting my self. Im just looking for a viable plan. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Perl / MySQL
Now we know MySQL is really ready to give Oracle some competition: Perl Interface to MySQL by Russell J.T. Dyer http://click.unixreview.email-publisher.com/maabITzaa2A6Ea2sdufb/ In the December installment in his MySQL series, Russell reviews the basics of building a MySQL interface with Perl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and Active Directory
Denham - Besides getting it to work? This topic has come up a few times on this list and I have yet to see anyone claim they have it working. I have a few ideas, but haven't had time to look at it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 02, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Hello List, The Company I work for is planning to go the Active Directory route. Does anyone know of any issues with the following versions of Oracle 7.3.x.x and 8.1.7.x.x? Regards Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: an article comparing Oracle to other databases
Patrice - By technical, do you mean a feature comparison or a performance comparison. You might want to research the eWeek benchmark for the three a couple of years ago. They made extensive efforts to produce an objective performance analysis, but even at that they had another article later about the things they had overlooked. These are really complex, sophisticated products that are used in really complex, sophisticated ways at a wide variety of sites, so I think it is very difficult to say anything that applies to many situations. On a perverse note, it is interesting to note that almost every deficiency can be viewed from a different perspective. SQL Server has a reputation for costing less, which means many corporations view it as "cheap". Oracle has a reputation of being harder to manage, which may mean that Oracle DBA salaries are a little higher. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 27, 2003 10:04 AM To: Multiple recipients of list ORACLE-L http://www.ecommercetimes.com/perl/story/32200.html I have yet to see an objective, detailed comparison of Oracle, DB2 and SQL Server. From a technical (i.e. what can it do) as well as from an organisational (i.e. how is it to manage) point of view. Even 3rd party "think tanks" seem to walk on egg shells when evaluating software from major vendors, possibly to avoid alienating any of them. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OS Level Defrag
Sujatha - If it helps, we have Tru64 and 8.1.6 here. My sys admin has defragged the disk quite a few times with no apparent ill effects. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 27, 2003 7:59 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone here do an O/S level defrag of their Oracle filesystems??? Background: (Tru64/8.1.7.4) Sysadmin here were adamant that the Oracle domains were running out of extents and were highly fragmented (O/S level). DBA was adamant that the Oracle filesystems should not be defragmented. I lost the battle and the sysadmins are defragging the domains. I now have a corruption on a table partition with 100 million plus rows on a 50G datafile. I am wondering if the defrag has caused this corruption. The only way I can think of finding out is: Finding the approx date of the corruption using the query SELECT ROWID, from ; (which will do the full tablescan row by row). And then finding when the defrag utility was hitting the particular datafile that is corrupted. But this reasoning is flawed Does anyone have another method of trying to pinpoint if the O/S defrag caused the corruption Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to stop XDB
Tanel - Thanks! That is sort of what I did. I shut down the listener and let them start the other process that wanted port 8080. Then I restarted the listener and it griped because it couldn't have that port, but everything else seemed to come up okay. I don't like rude surprises just as I had my coat to leave for a holiday. I also don't like clever little features I don't use being added automatically. Especially clever little features that have security vulnerabilities posted. I like your idea of removing it from listener.ora. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 26, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Hi! Check note 171658.1 from metalink, it has series of steps for removing XML stuff from database. Alternatively (if I recall correctly) you can just remove the XDB entry from listener.ora. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 12:24 AM > My networking people just notified me that XDB has port 8080 locked. Since I > wasn't aware that Oracle 9.2 had an XDB running, this quite has me baffled. > Is this something I can stop? Oracle has a lot of documentation on how to > configure it, etc., but I don't see a thing on stopping it. Any thoughts > appreciated. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to stop XDB
My networking people just notified me that XDB has port 8080 locked. Since I wasn't aware that Oracle 9.2 had an XDB running, this quite has me baffled. Is this something I can stop? Oracle has a lot of documentation on how to configure it, etc., but I don't see a thing on stopping it. Any thoughts appreciated. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Active Directory and ORACLE passwords
David - I hope you get some good replies. I asked about this awhile back and there didn't seem to be any sites getting MSAD and Oracle LDAP working. Part of the problem is that the world's #1 and #2 software companies don't talk much. I think your first obstacle is finding out the LDAP information and format that Oracle is expecting (I think this is an LDIF). One idea would be to install Oracle LDAP as a test and see if you can export the LDIF and import it into MSAD. Then the next obstacle is how to keep the information maintained in MSAD. Of course you will have to change the Oracle client to point to MSAD, but that seems well documented. For the Oracle connection information (what is in tnsnames.ora), one possibility I saw was to configure Oracle cman, which is pretty trivial. Cman has the capability to import a tnsnames.ora file. It also has the capability to export an LDIF. So in theory you could import your tnsnames.ora file into cman and export an LDIF which you could import into MSAD. Again, I sincerely somebody that has actually tried this will reply. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 25, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the password would be valid and then pass off to the ORACLE database that password. Any information would help. Thanks in advance David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN restore to different machine
Good catch Stephen. My understanding is that you -Original Message- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen >>> [EMAIL PROTECTED] 11/24/03 11:54AM >>> Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup & Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services
RE: RMAN restore to different machine
My apologies, I bumped the "send" button. Stephen - my understanding is that you are correct, the platforms have to be the same at the binary level - i.e.., both Solaris, both Windows, etc. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 3:20 PM To: '[EMAIL PROTECTED]' Good catch Stephen. My understanding is that you -Original Message- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen >>> [EMAIL PROTECTED] 11/24/03 11:54AM >>> Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup & Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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 'ListGur
