RE: ORA-3113 errors after switching W2K server to new network
Paul Sounds suspiciously like an issue we had when se set up our latest system - something in the firewall or network set-up has a TCP time-out in it. TCP (or the network or something I'm no network expert) drops the connection after 60 minutes resulting in client and Oracle server no longer being able to talk to each other (3113 etc). We get no logs either. Sorry I can't actually help here but this error we see is nothing to do with Oracle, Net8 etc and everything to do with the network/firewall. We have not solved it yet but luckily our software is configurable and can disconnect/reconnect every 30 minutes so does not fall fowl of the issue. T¬ _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 08 January 2004 15:39 To: Multiple recipients of list ORACLE-L Hi everybody, one of our Win2K servers, running Oracle 8.1.7, has recently been switched from the University's old network to our shiny new network. All the DNS entries have been successfully switched, everybody can still connect to the databases, and all appeared well. Until our users started reporting ORA-3113 errors (end of file on communiation channel). In every case, this happens after the user's connection has been inactive for somewhat over an hour. There are no messages in the database alert log, no trace files or dump files in the bdump, cdump or udump locations, and no messages in the listener log or in the sqlnet log. But it happens with alarming frequency, and only since the switch to the new network. The network guy who switched the server to the new network says the only change was to replace the server's previous network card with a new gigabit ethernet card. In the absence of any kind of server-side error messages or trace files, I'm more than somewhat stumped. None of the possible explanations I've found in MetaLink seem to apply in this case. Has anyone any ideas? Not only possible solutions, but ideas for further inquiries, or further questions would be welcome! Best regards, Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Verisign and MetaLink
the ntoe I read talked about Oracle Wallets and SSL within Java _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 07 January 2004 15:34 To: Multiple recipients of list ORACLE-L So I got two e-mails today from Oracle Support warning about Verisign Certs expiring today and to check MetaLink (thanks for the advanced warning guys). I've been trying for over an hour now and am getting no joy. Anyone know what the Verisign Certs are used for in Oracle products? I don't think we have any of those products, but... TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- 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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shareplex: datatype unsupported
That goes for Shareplex too (sorry to state the obvious). I've been seriously bitten in recent weeks by problems with their stuff too. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 05 November 2003 14:59 To: Multiple recipients of list ORACLE-L This isn't a direct answer to your question, but make sure you test logical standby thoroughly--I had to abandon the idea of using it due to serious bugs in the apply process, and due to seriously poor performance of the apply process. --- elain he [EMAIL PROTECTED] wrote: Hi, We are evaluating using either Oracle logical standby or Quest Shareplex replication for reporting purposes. It appears that there are quite a few datatypes not supported by Logical standby. Anyone knows what datatypes are not supported by shareplex replication? Tried looking up at quest website but could not find any documentation. Quest claimed that shareplex can replicate database of different versions, for eg from 9i to 8i as long as the 9i new features are not being utilized. Anyone has any experience with that? Thanks. elain _ MSN Messenger with backgrounds, emoticons and more. http://www.msnmessenger-download.com/tracking/cdp_customize -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
10046 level 8 trace - help required with 'direct path write' wait
Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported slow transaction. From what I can tell the biggest offender is a wait seemingly associated with rollback (see below) called 'direct path write'. Is this just a traditional wait for a row lock to be released or something more sinister? Any help much appreciated. Also (daft question time) what units are tim= in? (ie how many seconds between tim=131853898 and tim=131853270). This SE 8.1.7.4.12 on Windows 2000. Thank you T¬ PARSING IN CURSOR #15 len=60 dep=2 uid=38 oct=7 lid=38 tim=131853270 hv=2073223040 ad='8e9a2080' DELETE FROM ROUTING_NEXT_JOB RNJ WHERE RNJ.NEXT_JOB_ID = :b1 END OF STMT PARSE #15:c=0,e=2,p=0,cr=1,cu=0,mis=1,r=0,dep=2,og=0,tim=131853270 WAIT #15: nam='latch free' ela= 0 p1=-1856345836 p2=106 p3=0 EXEC #15:c=0,e=0,p=0,cr=3,cu=14,mis=0,r=2,dep=2,og=4,tim=131853270 XCTEND rlbk=0, rd_only=0 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59401 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59404 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59407 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59410 p3=1 WAIT #14: nam='direct path write' ela= 2 p1=1026 p2=59411 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59414 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59417 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59421 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59425 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59428 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59431 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59434 p3=1 ... WAIT #14: nam='direct path read' ela= 79 p1=1026 p2=41389 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41396 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41397 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41404 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41405 p3=3 FETCH #14:c=100,e=628,p=221,cr=5629,cu=12,mis=0,r=1,dep=2,og=4,tim=131853898 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10046 level 8 trace - help required with 'direct path write'
OK - so I'd not got round to reading a recent previous post on the same issue, seems tim= is in hundredths of seconds for 8i. So I got that bit of the answer. Still pondering on those 'direct path write' waits though. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 30 October 2003 14:44 To: Multiple recipients of list ORACLE-L wait Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported slow transaction. From what I can tell the biggest offender is a wait seemingly associated with rollback (see below) called 'direct path write'. Is this just a traditional wait for a row lock to be released or something more sinister? Any help much appreciated. Also (daft question time) what units are tim= in? (ie how many seconds between tim=131853898 and tim=131853270). This SE 8.1.7.4.12 on Windows 2000. Thank you T¬ PARSING IN CURSOR #15 len=60 dep=2 uid=38 oct=7 lid=38 tim=131853270 hv=2073223040 ad='8e9a2080' DELETE FROM ROUTING_NEXT_JOB RNJ WHERE RNJ.NEXT_JOB_ID = :b1 END OF STMT PARSE #15:c=0,e=2,p=0,cr=1,cu=0,mis=1,r=0,dep=2,og=0,tim=131853270 WAIT #15: nam='latch free' ela= 0 p1=-1856345836 p2=106 p3=0 EXEC #15:c=0,e=0,p=0,cr=3,cu=14,mis=0,r=2,dep=2,og=4,tim=131853270 XCTEND rlbk=0, rd_only=0 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59401 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59404 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59407 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59410 p3=1 WAIT #14: nam='direct path write' ela= 2 p1=1026 p2=59411 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59414 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59417 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59421 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59425 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59428 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59431 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59434 p3=1 ... WAIT #14: nam='direct path read' ela= 79 p1=1026 p2=41389 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41396 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41397 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41404 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41405 p3=3 FETCH #14:c=100,e=628,p=221,cr=5629,cu=12,mis=0,r=1,dep=2,og=4,tim=131853898 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10046 level 8 trace - help required with 'direct path
Paul Oh well spotted, I'd completely missed that, cursor #14 is MUCH more complex and would require a fair degree of sorts. Thanks T¬ _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ..the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 30 October 2003 19:04 To: Multiple recipients of list ORACLE-L John/Tim, The 'direct path read/write' are for cursor #14. The delete is cursor #15. Check the trace file for the preceding cursor #14. Paul -Original Message- Sent: Thursday, October 30, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Tim, As you have seen, this is due to writes to and reads from the TEMPORARY tablespace of that user. This could be due to both SORT segments (SORT_AREA_SIZE overflow) as well as HASH segments due to HASH Joins going to TEMP when they overflow HASH_AREA_SIZE. This can be seen from V$SORT_USAGE.SEGTYPE. Since a DELETE should normally not generate sorting or Hashing, I am assuming that either there are triggers that are forcing this to occur, or this is a view and the INSTEAD OF is performing some inefficient joins... Andy - just curious how a WHERE clause on a DELETE would generate Sort usage (outside of that explained above)... John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 9:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10046 level 8 trace - help required with 'direct path Hi, Tim, Assuming you don't have more than 1000 files, what's your db_files set to and what's select file#, name from v$tempfile? If you do have more than 1026 files, select file#, name from v$datafile. Also show us select * from v$sort_usage if you can run that DELETE again. XCTEND rlbk=0: your transaction end marker says it's not rolling back; i.e. it's committing. Yong Huang --- Andy Rivenes [EMAIL PROTECTED] wrote: Looks sort spillage to disk due to the where clause. Andy Rivenes [EMAIL PROTECTED] At 06:44 AM 10/30/2003 -0800, Tim Onions wrote: Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported slow transaction. From what I can tell the biggest offender is a wait seemingly associated with rollback (see below) called 'direct path write'. Is this just a traditional wait for a row lock to be released or something more sinister? Any help much appreciated. Also (daft question time) what units are tim= in? (ie how many seconds between tim=131853898 and tim=131853270). This SE 8.1.7.4.12 on Windows 2000. Thank you T¬ PARSING IN CURSOR #15 len=60 dep=2 uid=38 oct=7 lid=38 tim=131853270 hv=2073223040 ad='8e9a2080' DELETE FROM ROUTING_NEXT_JOB RNJ WHERE RNJ.NEXT_JOB_ID = :b1 END OF STMT PARSE #15:c=0,e=2,p=0,cr=1,cu=0,mis=1,r=0,dep=2,og=0,tim=131853270 WAIT #15: nam='latch free' ela= 0 p1=-1856345836 p2=106 p3=0 EXEC #15:c=0,e=0,p=0,cr=3,cu=14,mis=0,r=2,dep=2,og=4,tim=131853270 XCTEND rlbk=0, rd_only=0 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59401 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59404 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59407 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59410 p3=1 WAIT #14: nam='direct path write' ela= 2 p1=1026 p2=59411 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59414 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59417 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59421 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59425 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59428 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59431 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59434 p3=1 ... WAIT #14: nam='direct path read' ela= 79 p1=1026 p2=41389 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41396 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41397 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41404 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41405 p3=3 FETCH #14:c=100,e=628,p=221,cr=5629,cu=12,mis=0,r=1,dep=2,og=4,tim=131853898 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com
RE: 10046 level 8 trace - help required with 'direct path write'
Mladen As my db_files parameter is set to 1024 then I take it that p1=1026 refers to temp file #2 confirming what everybody is telling me its sorting to disk. Thanks for your input, I now understand what it is I should be looking at. T¬ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle8i, Failsafe and patchset 12
Jared The URL refers to an alert for NT 4.0, Patrice is talking about Windows 2000 (which is also the MS flavour I'm having problems on), am I being blind here but those are 2 different products? If there is a similar alert for Windows2000 I'd certainly like to hear about it. If anybody is interested in the original Failsafe issue then I can tell you that this morning Oracle have acknowledged it as being a bug (failsafe is looking for Oracle9 libraries!). Fix is "being worked on". T¬ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 23 September 2003 18:45To: Multiple recipients of list ORACLE-LSubject: RE: Oracle8i, Failsafe and patchset 12 You would be well advised to *not* install SP4. It will destroy network performance. Supposedly this can be corrected: http://tinyurl.com/odlwor http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q249/7/99.aspNoWebContent=1 Jared "Boivin, Patrice J" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle8i, Failsafe and patchset 12The latest service pack for Win2K is SP4. Patrice. -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle8i, Failsafe and patchset 12Good question, it's an Oracle8i patchset not a Windows one. _________ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: 23 September 2003 12:50To: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: Oracle8i, Failsafe and patchset 12Tim, Just curious - is Patchset 12 for Windows 2000, or for Oracle? Sorry if it's a dumb question, but I am lost in the context. thanks! Tom Mercadante Oracle Certified Professional -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 8:40 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle8i, Failsafe and patchset 12To anybody using Oracle8i and failsafe, After implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe configuration failsafe (and MS Cluster administrator) stopped being able to control the Oracle service (it can stop it but not start it again - saying things like "file not found"!). All the due diligence exercises have been done and I am convinced the patching was no flawed on my part. I suspect a bug in the patch set and Oracle support are indicating that others may be having the same problem. My database runs fine but has had to be removed from failsafe. So two things: 1 - if you are using failsafe and Oracle8i think very carefully before applying patch set 12 2 - if you have applied patch set 12 either successfully or unsuccessfully with failsafe I'd love to hear from you so I can either put pressure on Oracle for a fix or share some thoughts on what is going on. Many thanks T¬
Oracle8i, Failsafe and patchset 12
To anybody using Oracle8i and failsafe, After implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe configuration failsafe (and MS Cluster administrator) stopped being able to control the Oracle service (it can stop it but not start it again - saying things like "file not found"!). All the due diligence exerciseshave been done andI am convinced the patching was no flawed on my part.I suspect a bug in the patch set and Oracle support are indicating that others may be having the same problem. My database runs fine but has had to be removed from failsafe. So two things: 1 - if you are using failsafe and Oracle8i think very carefully before applying patch set 12 2 - if you have applied patch set 12 either successfully or unsuccessfully with failsafe I'd love to hear from you so I can either put pressure on Oracle for a fix or share some thoughts on what is going on. Many thanks T¬
RE: Oracle8i, Failsafe and patchset 12
Good question, it's an Oracle8i patchset not a Windows one. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: 23 September 2003 12:50To: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: Oracle8i, Failsafe and patchset 12 Tim, Just curious - is Patchset 12 for Windows 2000, or for Oracle? Sorry if it's a dumb question, but I am lost in the context. thanks! Tom Mercadante Oracle Certified Professional -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 8:40 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle8i, Failsafe and patchset 12 To anybody using Oracle8i and failsafe, After implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe configuration failsafe (and MS Cluster administrator) stopped being able to control the Oracle service (it can stop it but not start it again - saying things like "file not found"!). All the due diligence exerciseshave been done andI am convinced the patching was no flawed on my part.I suspect a bug in the patch set and Oracle support are indicating that others may be having the same problem. My database runs fine but has had to be removed from failsafe. So two things: 1 - if you are using failsafe and Oracle8i think very carefully before applying patch set 12 2 - if you have applied patch set 12 either successfully or unsuccessfully with failsafe I'd love to hear from you so I can either put pressure on Oracle for a fix or share some thoughts on what is going on. Many thanks T¬
RE: SharePlex info
Title: Message Shareplex does not use triggers on NT it uses the same underlying technology as it does on Unix "reading" the log files and shipping SQL to the target database. It uses a 3rd party tool called "Knutcracker" to allow it to some ofits UNIX commands on NT. T¬-Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]Sent: 25 August 2003 09:10To: Multiple recipients of list ORACLE-LSubject: Re: SharePlex info Sorry about the late reply but (if I remember correctly from my research about one year ago) Shareplex does something like log mining only on Unix systems. On NT it uses triggers just like replication. Yechiel AdarMehish - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 10:39 PM Subject: SharePlex info You are correct in the first place. SharePlex works as you describe, it mines the log and sends only the absolute minimum to reassemble the transaction on the target. It doesn't send SQL. The target side processes take the data and rebuild a SQL statement from the DDL definitions it got from the data dictionaries of the source and target (just in case you only want a subset of the columns.) Sorry if I confused you. Tony -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:01 PMTo: Aponte, TonySubject: RE: SharePlex info Tony, My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby definitely needs all logs transported to the target site where is does log mining. We considering remote disaster recovery site where we want to have working data and we don't care much about "log" tables. Thank you for valuable info. -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:40 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: SharePlex info Your bandwidth requirements will be the rate of changes to the actual data. The traffic consists of the actual data and control information needed to reassemble the transaction on the target. The source database's other redo payload (i.e., index operations, rollback segment maintenance, etc.) is not used by Shareplex. In our environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU consumption on the source and target sides combined. It varies according to the DML load on the source but not by much. We've never had a problem with it consuming a noticeable amount. I have a question on the comparison between a physical standby and Shareplex replication.Isn't9i's logical standby featurebetter suited for the comparison to Shareplex? I'm assuming that you are considering offloading some processing to another host since you are looking to replicate about 50% of the tables in the source database. HTH Tony Aponte -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex info Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format - How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot - Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which onesounds preferrable keeping in mind minimizing CPU burden on the source database. Any opinion or pointer to any benchmark is highly appreciated. Thanks a lot Vadim
RE: SharePlex
Title: Message I'll add one to the list: nnn) How much downtime and DBA time is required when the Shareplex replication queues get corrupted and you have to rebuild your entire replicated database? (I only add that as I've got to do it tomorrow morning). T¬ From: Nick Wagner [mailto:[EMAIL PROTECTED]Sent: 09 August 2003 00:04To: Multiple recipients of list ORACLE-LSubject: RE: SharePlex I know a little of their product... but I think you should be well aware of the limitations before attempting to implement it. Here are a couple of questions to ask the technical folks over there... 1)What happens when someone applies an Oracle Financials patch to the system. What is the procedure? 2) Do you have anyone else running Financials 11i thatyou could talk to as a reference? 3) Do they support IOT's? (Which Financials has a lot of) 4) How much downtime is normally associated with something like adding a new table or dropping one from replication? Nick -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex We are not running 9i but 8.1.7.4, sorry for not including that earlier. We are rolling out to our international offices and we basically have offices in every time zone. I'm looking at SharePlex for HA, reporting use, and potentially migrating from HP to Linux. They will be on Linux next month. Allan -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex Nelson, SharePlex does the same basic thing that Oracle does for the logical standby, as a matter of fact if your running 9i why not use that instead of Quests's pricey tool? I don't believe there is any additional cost to using logical standby over the second server license that your going to have to pay anyway. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, running Financials 11.5.7. We are interested in this for HA and for reporting instance use. rant We use Cognos as our query tool and the owners of this product tells me that we can't tune the SQL it emits. It makes pretty poor choices, which is not surprising for a gooey, sticky tool designed for end users. It is sort of pretty and if you can drool you too can generate cross products. Anyway , I'd like to get them off the production box. rant/ Does SharePlex allow you to stay close to the production instance in time? Does the store and forward work well? Do you love it? Hate it? Anything you'd like to say about this product I'd like to hear Thanks in advance Allan L. NelsonOracle DBA M-I L.L.C.(832) 295-2238 office(832) 351-4180 fax[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
RE: Integration with IBM Mqueue series
Did anybody get to download the presentation? When I try and get it form the NJ downloads page I get a: The requested URL /download/Oracle PRN Streams.ppt was not found on this server. message. I would very much like to read this. Thanks T¬ _ Tim Onions Speech Machines -Original Message- Sent: 25 July 2003 17:20 To: Multiple recipients of list ORACLE-L I thinks Oracle Streams in 9i does the same thing. Please check for doc on otn or metalink. I attended a workshop on Oracle Streams in NJ yesterday and presenter was Indy Johal. A nice presentation. It may be placed at www.njoug.org. He is also going to present it in Oracle OPENWorld in SEP 2003. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Jul 2003 07:19:24 -0800 Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing
RE: Number of processors and standard edition
Last time I checked it was 4 for Windows NT/2000. Not a UNIX shop so can't comment on that OS. T¬ _ Tim Onions Speech Machines -Original Message- Sent: 29 July 2003 18:04 To: Multiple recipients of list ORACLE-L I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recent reports on outages caused by DB2 and 9iRAC issues
_ Tim Onions Head of Oracle and Web Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]Sent: 18 July 2003 16:55To: Multiple recipients of list ORACLE-LSubject: Recent reports on outages caused by DB2 and 9iRAC issuesReports on "Bugs" in IBM's DB2 which led to "a critical operational situation"http://theregister.co.uk/content/archive/30095.html and http://www.danskebank.com/link/ITreport20030403uk/$file/ITreport20030403uk.pdfReport on Orbitz blaming an outage on Oracle's 9iRAC [and Orbitz going out of 9iRAC] http://www.eweek.com/article2/0,3959,1196879,00.asp and http://www.computerworld.com/databasetopics/data/software/story/0,10801,83186,00.html Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: invalid dbms_shared_pool
This happened to me once - when I was mistakenly ran the script as SYSTEM instead of SYS/internal. Any chance somebody did this on your DB (a long shot I know)? _ Tim Onions Head of Oracle and Web Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 03 April 2003 00:19 To: Multiple recipients of list ORACLE-L thanks Rich , is is hp-ux 8.1.6. db . I haven't tried alter package .. yet . Only thing that's differnet is there was no patch or compilation in last few months . How can the package become invalid one day . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 2:28 PM You don't say what version, but I've seen many SYS packages go invalid in 8.1.x on HP/UX, especially after patching or installing a new option/feature like Oracle Text. I've found that attempting to revalidate them either by hand or by running ?/rdbms/admin/utlrp.sql is futile. One gets fixed and five others break. Fix those five and three more break. Lather. Rinse. Repeat. For better or worse, the only way I've been able to consistently fix this is to take the brute force approach and rerun the ?/rdbms/admin/whatever.sql script that created the packages that are now invalid in the order in which they were originally run when the DB was created. Depending on which packages, this may be best left to off-hours. GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, April 02, 2003 3:09 PM To: Multiple recipients of list ORACLE-L In one of our db i found that dbms_shared_pool package body is invalid . Any idea why that could happen . It's not causing any problem . It's just appearing as one of invalid objects . In fact I am able to execute dbms_shared_pool.keep with out error . Looks like specification are intact . there was no package compilation in many days . Only thing i remeber is , we tried to set keep pool and i misspelled keep_pool ,( but does that cause invalidation , i dont buy it ) -ak -- 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: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Which process is taking up so much CPU???
Hey, it could well be one of mine (or something derived from the same source as I started with) - got all the same words, syntax and style as something I call SessionTopCPU and use to be available off my web site. I think the original inspiration was from Dave Ensor, but I no longer use the report and have long since forgotten almost everything about it (ie I won't be of much help in answering questions). _ Tim Onions Head of Oracle and Web Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 27 March 2003 15:59 To: Multiple recipients of list ORACLE-L Prompt Prompt Show total CPU and statement CPU for current session (requires TIMED STATISTICS = TRUE) Prompt set verify off col UNAM format a20 word heading 'User' col STMT format a56 word heading 'Statement' col RUNT format a08 word heading 'CPU Time' col ltim format a20 word heading 'Logon Time' col etim format a20 word heading 'Connect Time' col PROG format a30 word heading 'Program|Client Terminal Details' col SID format a10 word heading 'SID/|Serial#' col DR format 9 heading 'Disk Reads' col BG format 9 heading 'Buffer Gets' col EX format 9 heading 'Executions' col rsecs format 999,999,999.00 heading CPU time|(seconds) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Passing DB-Link name in a Loop
Hemant In case nobody has yet replied I believe your error is that you cannot use a bind variable in an execute immediate for the db link name as you are trying to do with this statement: exec_string := 'select sum(bytes)/1048576 from dba_data_files@:b1'; Changing it to this might work (I've not checked it myself so no guarantees) exec_string := 'select sum(bytes)/1048576 from dba_data_files@'||remote_db; execute immediate exec_string into db_size; T¬ -Original Message- Sent: 21 March 2003 01:34 To: Multiple recipients of list ORACLE-L Guys, help me here. This SQL [below] returns the error : connecting to AM3C01 declare * ERROR at line 1: ORA-01729: database link name expected ORA-06512: at line 16 [AM3C01] is the first db_link fetched. tti 'Database Sizes (excluding TEMPFILEs) ' center spool DB_Sizes set serveroutput on size 5; declare cursor c1 is select db_link from user_db_links; remote_DB varchar2(128); db_size number; exec_string varchar2(255); begin open c1; loop fetch c1 into remote_DB; exit when c1%NOTFOUND; dbms_output.put_line('connecting to '||remote_DB); -- select sum(bytes)/1048576 into db_size from [EMAIL PROTECTED]; exec_string := 'select sum(bytes)/1048576 from dba_data_files@:b1'; execute immediate exec_string into db_size using remote_DB; dbms_output.put_line('DB : '||remote_DB||':'||db_size); end loop; close c1; commit; end; / spool off Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OIP-04109: Error creating temporary file
Oops - I meant of course Oracle Objects for OLE (OO4O) -Original Message- Sent: 12 March 2001 15:46 To: Multiple recipients of list ORACLE-L I think (stress think) OIP messages are Oracle Objects for NT. -Original Message- Sent: 12 March 2001 15:20 To: Multiple recipients of list ORACLE-L Anyone know what this means...or even what product OIP is? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone used Fail Safe for NT?
Earl I've just done it on a 2 node Win2k cluster but supporting a single database - and it REALLY was easy. Can't see any reason why it shouldn't be easy with more than one DB onthe cluster. Regards -Original Message- Sent: 05 March 2001 22:46 To: Multiple recipients of list ORACLE-L Anyone use Oracle Fail Safe for NT? Compaq just finished a tech/mkt presentation and made it seem oh so easy (for the right $). I am wondering if anyone has done it and in a multi DB env. Cheers, Earl Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).