Database Scanner - Any good?
Hi, My company has bought a product called Database Scanner from Internet Security Systems (ISS). I have a meeting on Wednesday to see how it can be used for our databases including Oracle. Does anyone have any experiences or knowledge to share on this product? Thanks in advance.. Regards, Mike. Oracle DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 32-bit RMAN Catalog and networker interoperating with 64-bit
Title: RE: Purely for your amusement Paula, We Use: Catalog on Solaris 2.7 64bit with 8.1.7.4 using 32bit oracle. Targets are Solaris 2.7 64bit, solaris 8 64bit all with 32bit Oracle 8i. Also NT and W2K. Only one target (solaris 864bit) is a legato client. The legato admin machine is W2K. No problems for us. Rman is very particular , so do restore tests on anything you set up. - Mike. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 28 February 2003 22:45To: Multiple recipients of list ORACLE-LSubject: RE: 32-bit RMAN Catalog and networker interoperating with 64-bit Anyone done this before? Seems like it should work.
RE: RMAN Upgrading to 8.1.74. Voices in my head.
Dennis, Ah, you know that never occurred to me. I'll check it out. Thanks. - Mike. -Original Message- Sent: 18 February 2003 14:04 To: Multiple recipients of list ORACLE-L Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT & W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: "...PLS-00302: Component 'LOCKFORCKPT' must be declared..." (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN Upgrading to 8.1.74. Voices in my head.
RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT & W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: "...PLS-00302: Component 'LOCKFORCKPT' must be declared..." (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: iAS 903 902 install
Barbera, I, too have not touch iAS in the real world. I was on the 9iAS R2 Oracle course 2 weeks ago though (thew!!). I remember the instructor saying that the proper releases are 901 and 902. 904 will be out in spring 2003. The version 903 is not a full release and contains just parts of 9iAS that may be needed to install over 902. Sorry but I can't remember what reasons there may be for needing 903 so check thoroughly. -Original Message- Sent: 17 January 2003 15:40 To: Multiple recipients of list ORACLE-L List: I'm touching iAS for the first time ever. I don't understand even basic stuff about it. The install I have includes 9.0.2 and 9.0.3. The install says "9.0.3 is the first J2EE 1.3 compatible release of Oracle9iAS. ..blah blah.. Oracle9iAS 9.0.3 contains only the J2EE and Web Cache Installation Type of Oracle9iAS and is compatible with Oracle9iAS 9.0.2 infrastructures for clustering, management, and security." Do I need to install 9.0.2 and then install 9.0.3 on top of it to get everyting I need? We're currently in an evaluation phase. Developers want iAS to deploy forms, portal, and build apps with java. I have 9.0.3 installed, but don't really understand what I have, and we're not able to launch a form. Thanks for any help! (This is the most frustrating, confusing product I've ever seen) Barb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Which side of the road?
For some Friday afternoon reading on what country drives on which side of the road and reason for it follow this link: http://www.travel-library.com/general/driving/drive_which_side.html I had half an idea but the site is a good read, in a sad trivia kind of way! Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-L at UKOUG
aining: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > = > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "GIVE a man a fish and he will eat for a day. But TEACH him how to > fish, and...he will sit in a boat and drink beer all day" > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris vs Windows 2000
t; recent versions of Oracle ( like 8.1.7 ), we are trying to do a > comparison of the features, benefits and advantages of using > Win2k Server and Solaris. > > Please don't refer me to such sites as www.kirch.net and > www.osdata.com. The information at www.kirch.net is dated > and applies to NT, not Win2k. > > osdata.com is a nice site, but doesn't really offer comparisons, > just information on each OS. > > There is quite a bit of material available at www.microsoft.com. > > Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ > > PC Mag has a nice article comparing different platforms for use as a > webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp > > They actually chose IBM running Windows 2000. > > Windows 2000 is in use here as a server platform for one database that > is used as the backend to a rather troublesome application. The Win2k > server is running Oracle 8.1.6.2. The database has been bounced 2 or > 3 times in the last year. > > Once was to clear up a strange but non-fatal problem with Oracle. That > was > back in July, the previous system restart had been in December 2001. > Server > and database were up without interruption for 7 months. > > Though I prefer Solaris, I'm having a difficult time coming up with many > valid > reasons for recommending it over Win2k. > > A few that I do have: > > Sun service is superior to Dell service. They've proven this to us. ( We > have other > Sun machines in house ) > > Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to > go past that > I would think we should go with Sun. I don't know about Win2k Advanced > Server, as it > is a 64 bit platform, and I think the licensing would go up quite a bit. > > I welcome all objective comparisons of Solaris and Win2k Server, whether > your own > thoughts, or a link or links to articles you are aware of. > > Thanks, > > Jared > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: oracle or mssql
But this default mssql behaviour is the performance 'gotcha' where readers block writers and writers block readers isn't it? Mike. -Original Message- Sent: 31 October 2002 09:12 To: Multiple recipients of list ORACLE-L 'Dirty reads' in SQL Server means that you can view records that have not been committed. This is implemented by setting the TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED. This is not default behaviour in SQL Server, the default TIL is READ COMMITTED (for very good reason). I can think of very few situations where you would want to see uncommitted records. Dirty blocks in SQL Server/Oracle are the same thing ie. a block/page in cache that has been changed but not flushed to disk. Ade -Original Message- Sent: 30 October 2002 18:43 To: Multiple recipients of list ORACLE-L It sounds like he is saying that, once an "insert, update or delete" statement has been issued (without a following commit), then the records acted upon are now considered "dirty" - i.e. needing writing to disk. this is, of course, NOT what Oracle considers a dirty block. I agree with you, Jared! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 1:21 PM To: Multiple recipients of list ORACLE-L At least one of us has the incorrect understanding of 'dirty' reads, or I am taking you too literally, or something. What are you really saying? Oracle does not allow dirty reads. All queries are consistent to a point in time, the beginning of a transaction, whether implicit (select) or explicit ( start transaction ). SQL Server and Sybase do not guarantee this. The 'dirty' reads you are speaking of sound more to me like sloppy programming. Is that what you're referring to? Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/30/2002 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: RE: oracle or mssql I would like to point out that what you call "dirty reads" are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The "dirty read" method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition > -Oorspronkelijk bericht- > Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > Verzonden:woensdag 23 oktober 2002 20:51 > Aan: Multiple recipients of list ORACLE-L > Onderwerp:RE: oracle or mssql > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: oracle or mssql
09:02:19 -0800 > > > > XENIX maybe. > > > > : ) > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > Systems Admin & Operations | Admin. et Exploit. des systèmes > > Technology Services| Services technologiques > > Informatics Branch | Direction de l'informatique > > Maritimes Region, DFO | Région des Maritimes, MPO > > > > E-Mail: [EMAIL PROTECTED] > > > > > > > > > > -Original Message- > > Sent: Wednesday, October 23, 2002 12:59 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Is MSSQL server available on UNIX? > > > > -Rachna > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Boivin, Patrice J > >INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > _ > > Get faster connections -- switch to MSN Internet Access! > > http://resourcecenter.msn.com/access/plans/default.asp > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mohammad Rafiq > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jenner Mike > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Yechiel Adar > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Di
RE: RE: oracle or mssql
: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
O/T - Disk IOs
Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backup Strategy - Informal Survey
An export with data will probably cause more headaches than it solves in large DBs. A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks. Mike Jenner Database Administrator -Original Message- Sent: 20 September 2002 15:53 To: Multiple recipients of list ORACLE-L Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here & we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: "Freeman; Robert" <[EMAIL PROTECTED]> Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Moving to UK - what are Oracle contracts like?
nclude a line containing: UNSUB ORACLE-L > (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: Manavendra Gupta 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Jenner Mike 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: Large enqueue waits.
Rob, Jared, all, By the time I was able to investigate, the problem had disappeared. No blocking locks and nothing unusual in v$session_wait by that time. I guess I'll set up an automatic script to run perhaps every 10 mins that checks and logs this sort of thing. Unless anyone knows if this is remembered internally.. Mike Jenner Database Administrator -Original Message- Sent: 10 June 2002 16:23 To: Multiple recipients of list ORACLE-L Did you look to see if you had any blocking locks occurring at this time? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, June 10, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi to you all, High enqueue locks. This morning before I got to work there were a group of users who appeared to be hanging at times when they should have been performing updates to certain tables. I tracked it down to what I suspect is high enqueue lock times. [details are below. I don't normally see enqueue high in v$session_event or v$system_event]. I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they don't tell me anything that I can understand :-( By now the sessions that were affected have logged out or been terminated, so I can't put a 10046 level 8 trace on them. Can I see what the enqueue waits were referring to? Thanks in advance, Mike. Details of findings: 1 select event, s.username , time_waited/100,total_waits, total_timeouts 2 from v$session_event e, v$session s 3 where s.sid= e.sid 4 and time_waited > 100 5 and event like '%enq%' 6* order by time_waited desc ; Total Event USERNAME TIME_WAITED/100 Waits Timeout -- -- --- - --- enqueueA 5498.45 17871787 enqueueB 3505.52 11401140 enqueueC 3303.44 10781071 enqueueD209.8969 69 enqueueE 63.2921 21 enqueueF 16.1714 4 6 rows selected. and using Steve's resource_waiters script: SQL> @resource_waiters Event name [buffer busy waits] enqueue SID PROGRAMTIME_WAITED AVERAGE_WAIT -- --- All Disconnected Sessions 7720431 306.021346 78 f45run@scc-corp01 (TNS V1-V2)2098920989 ARC0 oracle@scc-corp01 (ARC0) 2 .25 1 select * from v$system_event 2 where time_waited > 0 3* order by time_waited desc ; Total Time Waitd Average Event Waits Timeout In Hndrds Time - - --- --- --- SQL*Net message from client # 0 3271701695 30.397 rdbms ipc message 1875169 819790 422614554 225.374 slave wait 2213312 ### 167923522 75.870 pipe get 260819 249480 126637278 485.537 pmon timer 277326 27729385337384 307.715 smon timer 2783277685322173 30658.345 enqueue 25297 25128 7741422 306.021 db file sequential read48265252 0 5125270 .106 io done 820132 22440 2847667 3.472 db file scattered read 1677976 0 1585987 .945 log file parallel write 575601 2 1276956 2.218 log file sync3474011089 922192 2.655 Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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
Large enqueue waits.
Hi to you all, High enqueue locks. This morning before I got to work there were a group of users who appeared to be hanging at times when they should have been performing updates to certain tables. I tracked it down to what I suspect is high enqueue lock times. [details are below. I don't normally see enqueue high in v$session_event or v$system_event]. I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they don't tell me anything that I can understand :-( By now the sessions that were affected have logged out or been terminated, so I can't put a 10046 level 8 trace on them. Can I see what the enqueue waits were referring to? Thanks in advance, Mike. Details of findings: 1 select event, s.username , time_waited/100,total_waits, total_timeouts 2 from v$session_event e, v$session s 3 where s.sid= e.sid 4 and time_waited > 100 5 and event like '%enq%' 6* order by time_waited desc ; Total Event USERNAME TIME_WAITED/100 Waits Timeout -- -- --- - --- enqueueA 5498.45 17871787 enqueueB 3505.52 11401140 enqueueC 3303.44 10781071 enqueueD209.8969 69 enqueueE 63.2921 21 enqueueF 16.1714 4 6 rows selected. and using Steve's resource_waiters script: SQL> @resource_waiters Event name [buffer busy waits] enqueue SID PROGRAMTIME_WAITED AVERAGE_WAIT -- --- All Disconnected Sessions 7720431 306.021346 78 f45run@scc-corp01 (TNS V1-V2)2098920989 ARC0 oracle@scc-corp01 (ARC0) 2 .25 1 select * from v$system_event 2 where time_waited > 0 3* order by time_waited desc ; Total Time Waitd Average Event Waits Timeout In Hndrds Time - - --- --- --- SQL*Net message from client # 0 3271701695 30.397 rdbms ipc message 1875169 819790 422614554 225.374 slave wait 2213312 ### 167923522 75.870 pipe get 260819 249480 126637278 485.537 pmon timer 277326 27729385337384 307.715 smon timer 2783277685322173 30658.345 enqueue 25297 25128 7741422 306.021 db file sequential read48265252 0 5125270 .106 io done 820132 22440 2847667 3.472 db file scattered read 1677976 0 1585987 .945 log file parallel write 575601 2 1276956 2.218 log file sync3474011089 922192 2.655 Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: oracle connection
Title: RE: oracle connection I've recently encountered 3113 error e-o-f on com channel, and I followed it through, using trial and error, to the setting of ORA_NLS33. Oracle 8.1.6 installed on Solaris and Dev 1.6.1 installed separately. We started getting the errors and need to specify ORA_NLS33=/hmis11/oracle/1.6.1/ocommon/nls/admin/data explicitly for our server side scripts. After speaking to Oracle support on this, it seems they had the vague suggestion: set it to what works ! - Mike. Database Administrator -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: 04 June 2002 20:14To: Multiple recipients of list ORACLE-LSubject: RE: oracle connection Are you using MTS or dedicated connection? If MTS, first do a client trace, if that turns up nothing, just for kicks try adding (SERVER=dedicated) to your client tnsnames.ora file and see if allows you to log in by bypassing MTS. -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: oracle connection Hi, It's another bad error to diagnose. But, there should be a good note for ora-3113 at metalink. Also, If Oracle can not know that a process is being terminated, there will be no trace for this error. Because Oracle will not have a chance to dump trace file. regards... Alexandre Gorbatchev wrote: > "End of communication channel" is common message when server process is > terminated. You may take a look at alert.log on server-side to see what > could cause it to terminate. It's often there. Also trace file for that > session on the server. > > -- > Alexandre > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, June 04, 2002 2:08 PM > > > hai all. > > > > my database connection has a problem. > > when user start to establish connection... an error returns "End of > > communication channel". So no user can log in. > > > > I've already checked the status of listener , reinstall net8 component, > > trace file. Seems those are oke. > > > > what should i do ? > > > > thanks > > > > rgds > > > > fico > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Softhome - Fico > > 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: Alexandre Gorbatchev > 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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: Legato oracle module.
Thanks to all tips, I'll think about it. I may chose to do my own, as per Sujatha's suggestion. At least I know where I stand, should disaster hit the machine. Mike Jenner Database Administrator C.P.S. Southampton City Council. [EMAIL PROTECTED] 02380 833985 -Original Message- Sent: 29 May 2002 01:23 To: Multiple recipients of list ORACLE-L Hi Mike, I've been using the Legato/RMAN combination for a couple of years now. The recovery catalog resides on the Legato Backup server. Once all the database backups finish, we then do a cold backup of the recovery catalog database straight to tape. I don't know what others do, but this if you can afford downtime for your recovery catalog db this is probably the best way to do it. If you have enough disk space on your server, you actually don't need the Legato plugin. Just dump the backups to disk and get the normal Legato Networker server backup pick them up onto tape. Regards, Sujatha -Original Message- Sent: Wednesday, 29 May 2002 12:23 AM To: Multiple recipients of list ORACLE-L Hi everybody, I've taken responsibility of a couple of Oracle systems on NT (in addition to my nice Solaris DBs). I'm setting up Legato to do the backups online using the Legato Networker Oracle Module. After checking the Legato docs, it seems that the only way of using this module is by integrating it with RMAN. is this right? Now, I'm sure that RMAN can do a good and flexible job. I've played with it a little but I don't like the meeesssyyy way of backing up the RMAN catalog. In the Legato docs , there's a section that warns you : " Preparing For Disaster . Ensure that your RMAN Recovery catalog is being backed up regularly. ." Doesn't this imply that you need to perform the catalog backup outside legato yourself?, so why did we buy it in the first place? I know you could create another catalog to perform cross catalog backups but that all sounds far to complicated and error prone. Anyone have any tips for me? [I'm much happier with my online backup scripts on Unix that I've been using and tweeking for years.] Mike. Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Sujatha Madan 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: Jenner Mike 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).
Legato oracle module.
Hi everybody, I've taken responsibility of a couple of Oracle systems on NT (in addition to my nice Solaris DBs). I'm setting up Legato to do the backups online using the Legato Networker Oracle Module. After checking the Legato docs, it seems that the only way of using this module is by integrating it with RMAN. is this right? Now, I'm sure that RMAN can do a good and flexible job. I've played with it a little but I don't like the meeesssyyy way of backing up the RMAN catalog. In the Legato docs , there's a section that warns you : " Preparing For Disaster . Ensure that your RMAN Recovery catalog is being backed up regularly. ." Doesn't this imply that you need to perform the catalog backup outside legato yourself?, so why did we buy it in the first place? I know you could create another catalog to perform cross catalog backups but that all sounds far to complicated and error prone. Anyone have any tips for me? [I'm much happier with my online backup scripts on Unix that I've been using and tweeking for years.] Mike. Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Rollback usage.
All, Thanks to those who reassured me and pointed me in the right direction regarding 'dbv' wrongly reporting corrupt rollback blocks after a 7 to 8 migration. For those interested: This is bug 1359160. My initial metalink search did not show related notes for some reason but I've found them now. Question though, after shrinking the system rbs, the fix is to access each rollback segment to convert it's header to V8 format however I cannot get the first rbs extent corrected. Is there a reason for this and does anyone have a solution. Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
System datafile corruption.
Guys, I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so I assume the fault is in the system rollback segment. I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any suggestions apart from a full export and import? Dbv extract is below: > Block Checking: DBA = 67108870, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2008 ktu4ubck: size(108) of undo record #1 corrupted. UNDO BLK HEADER: xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: 0x000 0 Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset --- 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 . . 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 Hex dump: 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 . . 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 > grep 'Block Type' dbv_log | wc -l 127 Regards, Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Legato backup.
Hey, just to confirm what I think is obvious... For an oracle database to be backed up on NT with Legato: you need to either; shutdown, cold backup via legato, startup, or online backup mode and legato's "Oracle database" extension, [or some sort of strategy involving oracle export]. And to verify... legato's "backup an in-use file" extension used to backup oracle database datafiles that have not been shutdown... will not give a viable backup ??? A department that has not paid for my section's DBA services has just phoned up with restore problems with a database backed up in this manner! If someone could confirm the obvious, I would be grateful. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Connecting INGRES using database link
//www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho 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: Bellows, Bambi 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: Ahmadsyah Alghozi Nugroho 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: Jenner Mike 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: Set Time Zone
Mike, Here's a thing you may well be able to modify slightly to your requirements. It will be useful only for running the application through Unix. The following is taken from the .profile of an account I set up here in 1999 to test Y2K. Hope it helps - Mike J. echo echo ' Enter new date required in format ddMON' echo read newdate hours=`sqlplus -s user/password <mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 03:15 To: Multiple recipients of list ORACLE-L Can't , not in 8i. 9i has introduced a TIMEZONE datatype where time can be reported offset by the UTC+/- offset. You'd have to build the logic in your application to increment/decrement the sysdate, depending on the user/client location (use a lookup table for location and timezone-offset) when fetching the sysdate. SYSDATE would always return the date on the server where the database instance is running. Hemant Mike T <[EMAIL PROTECTED]>12/12/2001 10:50 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Set Time Zone Hi Gurus, How can I set up a time zone for each region that connect on SAME Database 8i Case: Database in NewYork. Clients in San Franciso, Paris .. When they use "select sysdate from dual ;" ( on Client or server side ) They should see their local time .?? Thanks in advance Tran -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike T 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Jenner Mike 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: some DBA help.
Lalit, Firstly, you should consider creating seperate instances for developement and live data usage. It's bad practice to have any kind of uncontrolled access to live databases such as developers (or even DBAs), no matter how good they are - sooner or later it will cause problems. To define 'types' of privilege and access rights to different users, you can use ROLES. Basically you can assign privs such as SELECT to various table to a role name 'CASUAL' (for example) and so on. Your 'users' should not create or own any database object such as tables, therefore any default tablespace you assign them will not hold data. Generally I create a tablespace called 'USERS' and set this as defualt TS for all users. The application objects and data will be available to the users via privilages via the Roles and possibly via public synonyms. Your questions are very general so I hope this helps. Regards, Mike. -Original Message- Sent: 07 December 2001 09:55 To: Multiple recipients of list ORACLE-L Assume that you are starting a new database and that you need to start adding user to this database. There are three basic types of users: developers (who can create basically all objects in the database), data processors (who can insert data into a given set of tables -CUSTOMER and ORDER TABLE as well as updates these tables) and casual user (who can view data from the INVENTORY and PARTS table). Assume also that every day there may be an unpredictable number of users to be added to the different types of categories. As a DBA, what can you do to make the task of adding user a little bit simpler? Would we assign developers and data processors to the same table space? Why or why not? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lalit Batra 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Max number of sessions
Title: Max number of sessions Yuval, If you mean to estimate how you can push the database to it's limit, I saw some demos the other day of a simulation tool by a company called Simulus. The tool allows you to alter aspects such as H/W config, data and parameters. This may be useful to you. Regards, Mike. -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: 04 October 2001 19:16To: Multiple recipients of list ORACLE-LSubject: Max number of sessions Hi, I would like to find out how to compute/estimate the maximum number of sessions a db can handle. Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc. This is for a db running using MTS. TIA Yuval.
RE: !! *Very* important Oracle-L message !!
send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to select and display 10 records at a time from a table u
set pagesize 10 set pause on select ... enter to display next page of results. - Mike. -Original Message- Sent: 29 August 2001 09:55 To: Multiple recipients of list ORACLE-L using sql query Dear DBA Gurus, How do I select and display 10 records at a time from a table using sql query only? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem connecting to a db
If the account has had TWO_TASK variable set , then I think this will also produce this error. Check/unset TWO_TASK and retry. - Mike. -Original Message- Sent: 17 July 2001 15:06 To: Multiple recipients of list ORACLE-L Logged on as administrator (NT4). Then in svrmgrl: connect internal/oracle Or : connect internal (prompted for password): oracle Same error message either way. Tried it several times, I don't *think* it is being typed wrong... Steven. -Original Message- Gramolini Sent: 17 July 2001 14:41 To: Multiple recipients of list ORACLE-L How is the user logged on to the server before trying to run svrmgrl? I always log on as oracle. hth, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 8:30 AM > I have someone on a remote site who is having problems connecting to a db in > server mgr as internal. > connect internal should work, but it replies with insufficient privileges, I > must be missing something. > > Does anyone have a suggestion what this could be? > > OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as > administrator. > > Thanks, > > Steven. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Hovington > 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: Ruth Gramolini 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: Steven Hovington 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: Jenner Mike 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: 9i Open Day (UK Listers)
I recieved the offical invite on my doormat this morning. I was wonderring whether to go and I see that it starts at 13:00+ which means I can still go the work in the morning. If I decide to go then a get-together /drinks would be great. - Mike. -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Jenner Mike 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: * I'm Looking for an Oracle Financials DBA for Miami,
tion in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Daemen, Remco 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: Mark Leith 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: Jenner Mike 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: * I'm Looking for an Oracle Financials DBA for Miami,
Contract rates are lower as well as permanent salaries and there is none of the 'extra job security' applied to contractors. However I work close to home and the out of hours requirements are minimal, so I'm happy. - Mike. -Original Message- Sent: 20 June 2001 17:37 To: Multiple recipients of list ORACLE-L and the UK. I have pretty much upped my salary by about 225% since I left. One of Her Majestys Disloyal servants :-) -Original Message- Sent: 20 June 2001 16:36 To: Multiple recipients of list ORACLE-L Ron Rogers schrieb: > > I don't doubt that there are openings available in the Govt sector. The pay scale for Govt workers is notoriously lower that the open market. I had a job offer to work for the Dept of Natural Resources in GA but I could not handle the $20K pay cut. > ROR mª¿ªm > Hi, thank you for your replies... and yes, it's the same in Germany, Govt. jobs are paid poorly here, too. | Regards, | | Stefan Jahnke | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Jenner Mike 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: Digestive
I own 1 square foot as well, got my certificate at home to prove it. Hmmm nice. - Mike. -Original Message- Sent: 13 June 2001 15:55 To: Multiple recipients of list ORACLE-L Ross, As part owner of the Laphroaig distillery (see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland > > Them's fighten' words friend! > > Jared > > On Tuesday 12 June 2001 14:18, Mohan, Ross wrote: > > Lagavulin??!?! Yikes, Jared, I am going to > > revoke my "Soul Brother" license from you. > > Don't tell me you like "Laphroaig" as well? > > > > That peaty sh*t should be used to clean road > > tar off SUVs. > > > > Now, if you're talking a fine Glendronach, you've > > got my full attention. > > > > > > > > -Original Message- > > Sent: Tuesday, June 12, 2001 4:54 PM > > To: Multiple recipients of list ORACLE-L > > > > On Tuesday 12 June 2001 12:33, Thater, William wrote: > > > single malt RULES!;-) > > > > Well, yeah, I like that too. > > > > I have some 16 yr old Lagavulin ( spelling? ) in the > > pantry that is just awesome. Fine smokey flavor from > > aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) > > > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > 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). > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Jenner Mike 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: [OT] Jobs in UK
Alex. There have been more taxes and restrictions applied to UK IT contractors in the last year or so prompting more people than usual to move outside the UK for work. This has prompted the UK to grant more visas to non British IT workers. I don't know about the qualifications or details for gaining UK working visa status, try searching the web for UK passport agency ,visa etc.. I've worked in the US and UK and, as always, job availability dramatically varies on actual location. However there is still a demand for quality IT experience, including Oracle DBAs. The main (only in my opinion) site is www.jobserve.com Have fun. - Mike. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 19:58 To: Multiple recipients of list ORACLE-L Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Jenner Mike 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: Rollback Segments
Isn't the concept of a private RBS only applicable to parallel server setups? - Mike. -Original Message- Sent: 09 May 2001 16:21 To: Multiple recipients of list ORACLE-L Hi all, This brings me to a stupid question then. What is the true difference between a public and a private rollback segment? Because if I just think about it like a normal human being I would think that if a user made a Private rollback segment then only that user could use it, but of course I know that can't be the case. Kev -Original Message- Sent: Wednesday, May 09, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Nixon, While SET TRANSACTION can be used to assign a rollback segment to a transaction, it cannot be assigned exclusively to that transaction as you have found. The ability to assign a rollback segment to a transaction and make it read-only for all others is something I've wanted myself for many years, and I know it's been on the official 'wish list' of requested changes by IOUG for some time. Maybe 9i? Anyone know? Jared On Wednesday 09 May 2001 01:40, [EMAIL PROTECTED] wrote: > Hi All, > > Here is my environment; > > NT v4 > Db Oracle Workgroup v8.1.6 > > Rollback Segments > SEGMENT_NAME OWNER TABLESPACE_NAME > -- -- -- > SYSTEM SYSSYSTEM > RBS0PUBLIC RBS > RBS_P1 SYSRBS > RBS_P2 SYSRBS > RBS_P3 SYSRBS > RBS_P4 SYSRBS > RBS_P5 SYSRBS > > > Is it possible to assign one public rollback segment explicitly to one > particular transaction? I tried using SET TRANSACTION USE ROLLBACK SEGMENT > but other users I found out can still use it. So, I guess the best > alternative is to set that RB segment to OFFLINE after using and set ONLINE > before executing the SET TRANSACTION ... Do you know how it can be done > inside Forms? > > Thanks in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Kevin Kostyszyn 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: Jenner Mike 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).
Oracle UPU, named user or site license?
Hi, Question, particularly to UK list members, A couple of months ago I recieved a quote from Oracle for some aditional products and I was quoted prices based on UPUs. (diag pack and tuning pack for Oracle standard edition) I thought that named user was the only pricing method. Are UPUs and named user licenses both available nowadays? Alternatively, we have oracle in 3 separately licensed installations with another one on the way. Before I get the runaround from oracle, does anyone have recent experiences to share about site wide licenses? Thanks, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: OT : Sinclair was RE: Metalink Again
Ahh yes.. The sinclair ZX80,ZX81.. that's where I started, but the jewell was the ATARI 400/800/st/various other aliases as the years went by. I started with a 400 (with the funny keyboard), then accquired an 800 with more memory (32M?) and proper keyboard. I still say those machines were way ahead of their time when they were introduced. I think I had about 50 x 5 1/4" disks with 'multiboot', to have approx 5 games on each side (I too used the neat square holepunch to use 2nd side). Now that's a lot of games! Used it for BASIC during my school exams , plus learning 6502, plus controlling motorised robots via the I/O ports (yes, the joystick ports). A good site for old Spectrum games: http://www.80snostalgia.com/computers/spectrum/index.html Also old kids programs ,all from an English perspective but many are U.S. made. http://www.80snostalgia.com/classictv/index.html Mike. -Original Message- Sent: 05 April 2001 13:30 To: Multiple recipients of list ORACLE-L I used to have a Spectrum +2? One of the little keyboards with rubber keys and a tape drive! Still have it in the loft at my parents with all the original games too! Damn how I used to love sitting in front of a screen blinking red/blue/green colours at me, screaming like a drowning cat while it was loading. I must dig that out for a nostalgia trip! LOL.. Although I am more of a die hard fan of high tech games though!! Quake, Half Life (Counterstrike).. Mark -Original Message- Brian Sent: Wednesday, April 04, 2001 10:24 To: Multiple recipients of list ORACLE-L I've got my Commodore 64. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > Any more spectrum owners out there that want to admit to it ? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Mark Leith 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: Jenner Mike 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).
IBM S/390 disk config.
Hi, Soon I will be installing Oracle 8i on various sections (LPARS) of an S/390 Multiprise 3000 server. My entire experience is of UNIX on Sun/HP/Alpha/NCR. My main reservation is from the RAID-5 comment in IBM's Internal Disk Performance white paper which describes: '.. The Internal Disk feature of the IBM S/390 Multiprise 3000 Enterprise Server allows for the attach- ment of up to 792 GB of RAID-5 disk storage to the internal IO bus ..'. Anyone out there have experience of this config? Is it possible to use another RAID level config? Any other gotchas for Oracle 8i (probably 8.1.7, don't know yet) on IBM's S/390? Any recommendations about sizing the disk read cache (up to 2GB) compared to allocating that as extra Shared_pool and buffer cache? Thanks for any opinions, Mike. Oracle DBA. Southampton City Council. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Anybody using Network Appliance Storage boxes with Oracle?
When I spoke to some technical Netapp people on their stand at the UKOUG in December 2000 they explained that they are able to gain Oracle certification by the way their filers do 'a write confirmation over NFS' (as you put it), which regular nfs does not do. I know a site that uses two full height rack units full of Netapp stuff (don't recall the model numbers) for IO intensive work but they do not use oracle. They are generally very happy with the performance and snapshot capabilities. Regards, Mike. -Original Message- Sent: 21 March 2001 14:06 To: Multiple recipients of list ORACLE-L I'll try and share some of what I've been told by the NetApp reps. This info is a year old. The NetApp box itself is a very trimmed down version of BSD that handles only the networking and disk i/o stuff. Specifically compiled to work with their controllers. It talks to both NFS and NT natively (their own addition). The drives are managed in a specially tuned RAID3 configuration. They say that the disk assignment stuff is not critical because of their caching (sort of the same argument that EMC uses). The NetApp box does a write confirmation over NFS as soon as the cache is updated (???) or something like that. This supposedly is how it can interact with Oracle and store datafiles on an NFS mount. I certainly may be wrong on some of this. Its been a while since I've wandered into that territory. Rodd Holman -Original Message- Sent: Tuesday, March 20, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Hi there! Is anybody out there running Oracle on NetApp Storage Networking box? I was told by some NetApp guys that using their boxes we don't have to worry about distributing datafiles, RBS etc. across the disks because the NetApp OS takes care of all that. Any comments? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney 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: Jenner Mike 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: Offtopic: Canada and America
nt ) > >Before you comment on cultures you have not experienced it would be >advisable >to at least visit there as a tourist. If you work there for a while you >may even >realize that what is "common knowledge" is wrong. After spending six >weeks in >Moscow, 2 years ago, I do not believe anything I read in the media (it >is both >better and worse than it is reported). > >And yes, there is a separate Canadian culture. (Part of which is >wondering if >we have a separate culture.) > > > > >Sigh.., and the day after I promised Jared I would behave. > >Dave >-- >Dave Morgan >Senior Database Administrator >Internet Barter Inc. >www.bartertrust.com >408-910-4183 >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Dave Morgan > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hand, Michael T > 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). > > >The information contained in this communication is >confidential, is intended only for the use of the recipient >named above, and may be legally privileged. If the reader >of this message is not the intended recipient, you are >hereby notified that any dissemination, distribution or >copying of this communication is strictly prohibited. >If you have received this communication in error, please >re-send this communication to the sender and delete the >original message or any copy of it from your computer >system. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: lerobe - Lee Robertson > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Kevin Kostyszyn 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is "MetaWink" Doing Another Rip Van Winkle???
Hmmm, The site support.oracle.com is running Apache/1.3.12 (Unix) ApacheJServ/1.0 on unknown. The site support.oracle.co.uk is running Oracle_Web_Listener/4.0.8.2EnterpriseEdition on Solaris. -Mike -Original Message- Sent: 15 March 2001 20:56 To: Multiple recipients of list ORACLE-L >From a previous post. see: http://uptime.netcraft.com/up/graph/?host=name_you_want_do_know_about ROR mª¿ªm >>> [EMAIL PROTECTED] 03/15/01 01:36PM >>> Does anyone know what hardware it (doesn't) run on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Oratab and ORACLE_HOME.
Hi, Here's a question that's been bugging me.. If I've got Oracle DBMS installed on /oracle/product/8.1.5 and Designer 2k installed on /oracle2/1.6.1 Which one do I set my ORACLE_HOME to? and which location goes in my oratab file? Whichever one I set, I guess I need both locations in my PATH but what order? [I'm on Solaris 2.7 if anyone cares] Thanks, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: OEM - Tunning Pack, Diagnostic Pack....
Hi, I was quoted ?15,000 plus yearly support for tuning pack + diag pack. This was for 2 DBA seats but I think they based it on UPUs since they checked my platform and CPU figures. Anyway It was too expensive for my site. You would think that Oralce would price the product low to encourage easier database tuning and maintenance, which would improve product performance and image. - Mike. -Original Message- Sent: 13 March 2001 08:31 To: Multiple recipients of list ORACLE-L As far as I am aware, the pricing for OEM is per seat, so whoever uses the product will have to be licensed. Also remember that base OEM is free. Clint * Clinton S. Naudé * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 13, 2001 9:46 AM To: Multiple recipients of list ORACLE-L That is not what they told us (starts to be very tricy)! It seems, that for the OEM, licence is based on the number of users. Since we have only few DBA. we thought (at the begining of the story) that this shouldn't cost so much money. Soon we discovered it is not so. Who is right (now this licencing things start to be VERY complex)? Sonja -Original Message- Sent: Monday, March 12, 2001 7:21 PM To: Multiple recipients of list ORACLE-L Oracle has prices for this product based not on users (at least server part - OMS) but on power units. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clinton > Naude > Sent: Monday, March 12, 2001 6:30 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: OEM - Tunning Pack, Diagnostic Pack > > > Yes, its a great set of products every DBA should use. > You would however not want to give each user on the floor a copy, it would > be a total waste of money. > > Clint > > > * Clinton S. Naudé > * Head systems administration > * Tel: 011 685 4304 > * Fax: 011 685 4303 > * Cell: 082 377 1726 > * E-mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, March 12, 2001 1:05 PM > To: Multiple recipients of list ORACLE-L > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Priority Paging on Solaris
Hi, I spoke to Sun support in detail to find out about this parameter. I'm on Solaris 2.6, generic patch Generic_105181-16. priority_paging is default in solaris 2.7 and up but not in 2.6. It is recommended for virtually any solaris 2.6 system since I'm told it may have benifits but has no drawbacks. Sun did not mention any performance, just that the OS handles memory 'better' under certain circumstances. You must be on generic patch at least Generic_105181-09 (which I guess anyone should be on because it is quite old). Regards, Mike. -Original Message- Sent: 09 February 2001 21:51 To: Multiple recipients of list ORACLE-L Yes and Yes. Also, the document skips over some other parameters you should set in addition to priority_paging=1 Check out http://www.unixinsider.com/unixinsideronline/swol-07-1999/swol-07-filesystem 3_p.html which lists these also: set fastscan=131072 set handspreadpages=131072 set maxpgio=65536 Finally, please note that you didn't state what version of Solaris and what patch level you're at. We're at 2.6 and have the necessary kernel patches. J p.s. As to how much performance increase, well, we only had the priority_paging =1 enabled up to this point, the other parameters go in on Sunday. if you email me next week I'll try and get you an update. At 01:40 PM 2/9/01 -0800, Steve Orr wrote: >Has anyone enabled priority paging on Solaris and did you experience any >performance gains as a result? (10-300% performance gains possible according >to Sun.) For a description here's a link: > >http://www.sun.com/sun-on-net/performance/priority_paging.html > >Comments? Recommendations? > > >Steve Orr > > > >Think you know someone who can answer the above question? Forward it to them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker 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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What is the URL showing web servers' popularity
I think you mean this one: http://www.netcraft.com/whats/ Regards, Mike. -Original Message- Sent: 08 February 2001 16:27 To: Multiple recipients of list ORACLE-L I remember seeing a Web page somewhere that showed what web servers large companies are using. I think it's from an Oracle-related site somewhere, but I can't remember which one. TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: On-Call - terms, conidtions and perks!
Sean, Interesting point and getting more valid all the time, as you say. I've worked in places where : 1) there was a laptop/pager provided but no renumeration (7 years ago, I was a junior DBA - didn't know any better!) 2) Rota of call out with (UK pound equivalent of) $6 per weekday, $8 Saturday, $10 Sunday with mobile phone and laptop and pay for any time worked over 1 hour. 3) On-call requirements with mobile phone. renumeration = 1 hour's pay for each 24 hour day of cover (wekday or weekend) plus pay from leaving home to getting home when it was necessary to be at work. I think that 1) above is unacceptable in todays financial requirements for 24/7. Somtimes arranging my life arround a possible call-out made $6-10 per day did not seem worth it but I'm a contractor so it was part of the job when I took it. If I were an employee being asked to provide on-call cover, option 3 plus laptop is pretty much the minimum I would look for. - Mike. -Original Message- Sent: 08 February 2001 10:41 To: Multiple recipients of list ORACLE-L Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
