RE: Oracle to Excel
This is how I do it: 1) Set-up an ODBC data source using either the Oracle or MS ODBC driver. 2) In Excel, use the Date->Get External Data menu option 3) Specify the ODBC driver 4) In the Wizard, select the table columns, where and sort or Untick the box and use MS Query where you can type in your own query using the SQL button 5) The data is returned into the spreadsheet Steve Parker E Mail: [EMAIL PROTECTED] --
Latest Release
What is the next release of Oracle 9i database (92020 ??) and when will it be released for Windows 2000 (Next Week ?? ;-) ) Thanks Steve Parker E Mail: [EMAIL PROTECTED] --
Apologies for Off-Topic Question - Where has Oracle-l-OT gone ?
Has the Off-Topic group gone ? Steve Parker E Mail: [EMAIL PROTECTED] --
EJB Support in Oracle 9iR2
Hi, Can anyone confirm if EJB support has been removed from Oracle Database Server Release 2 ? If so, can they point me to a metalink etc article. I am sure I read about this somewhere but can't find any reference to it. If this is correct, then Oracle revenue should go up as everyone buys Application Server.... Steve Parker E Mail: [EMAIL PROTECTED] --
RE: Telephone Alerts
If you are looking for a bigger solution, that as well as SMS, using the SendSMS package I mentioned last time, can also do voice alerts, voice XML, paging, email etc, based on Scheduled database queries and/or Triggers, then take a look at Categoric Xalerts. This is a Java based system that runs on both NT/2000 and Solaris, that allows you to graphically build Alerts to many types of device based on the recipient and time of day, it also allows people to subscribe to alerts via customisable web pages and to set how they want to receive the alerts. There are other alerting packages around but this had the most features and was architecturally better than the other we were looking at. http://www.categoric.com Steve Parker E Mail: [EMAIL PROTECTED] -- Robertson Lee - lerobe <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 13/05/2002 16:33 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Telephone Alerts We used to use telalert by Telamon (looks like they have been taken over now). Seemed to do the job very nicely considering how many times I got woken up in the wee small hours when I was in manufacturing. GRRR http://www.vytek.com/products/urgentmsg/telalert/index.asp HTH Lee -Original Message- Sent: 13 May 2002 15:48 To: Multiple recipients of list ORACLE-L Simon, Working with a tools company that provides a monitoring tool for Oracle - we have had a lot of call for sending alerts to SMS. We've done a fair bit of testing of various SMS providers in the UK so that we can try to recommend a valid solution to our customers - that is able to alert a user with a consistently good response time. The "norm" is to use an "SMS gateway", where you send a standard email to a an SMS Gateway provider - who then forward that email in SMS form to your mobile phone. We've tried various people such as Genie (BT's) now called mmo2, http://www.uboot.com, http://www.iobox.com etc. etc. all of which have had poor response times at various times in the day due to user traffic.. There is also the possibility of getting tools that people have pre-built to send SMS from a desktop - or server.. Many of these are pretty good in GUI form, but when it comes to command line support, they are usually very lacking to none - and let's face it if we wanted to use it, or if you wanted to call it from a shell type script you *need* command line support.. And if there is command line support - most of the time these are made by people in other countries, and don't seem to support our UK service providers such as Orange, One-2-One, and to a slightly lesser extent Vodafone. If we are asked to provide SMS alerts for our tools, we now point our customers to a company called Textforce (http://www.textforce.net) which is actually supposed to be a targeted marketing type site for sending marketing SMS messages. It's a "pay per message" provider - with each SMS being around 7-8 pence.. The only reason we actually recommend to our customers that they use this site - is that throughout our entire testing, this site provided response times (from the time the email was sent, to the time the SMS was received) of between 30 seconds - 4 minutes consistently! Many of the other providers, such as genie, or uboot et al have greatly differing response times - from 20 seconds right up to 14 hours! I'd still be interested though if anybody has any experience with server based tools that are available (for things such as Sun, HP, AIX, NT/2000) that do have command line support, and also support the major UK providers.. HTH 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 -Original Message- Gorbatchev Sent: 13 May 2002 14:48 To: Multiple recipients of list ORACLE-L Some mobile network providers make use of email gateway for sms. In that case you have some email address which is redirected by your provider to your phone. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 13, 2002 3:03 PM We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens Drive NOTTINGHAM NG2 1AL Phone 0115 957 6536 Fax 0115 957 6548 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinio
Re: Telephone Alerts
This is a standalone package if you don't want to write your own. http://www.bai.de/sendsms/sendsms.shtml.en otherwise use Google and search for SMS and ETSI: This one looked particularly useful: http://www.dreamfabric.com/sms/ Steve Parker E Mail: [EMAIL PROTECTED] -- "FOX, Simon" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 13/05/2002 14:03 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Telephone Alerts We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens Drive NOTTINGHAM NG2 1AL Phone 0115 957 6536 Fax 0115 957 6548 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Oracle CPU Licensing
One thing to be wary of is if you want Standard Edition. Typically this can only be used on machines up to 4 CPUs. However, say you want an expandable server that can take 6 CPUs max, but initially you only have 2 CPUs installed, because the server is CAPABLE of having 6 CPUs, you can only use Enterprise edition. Steve Parker Technical Consultant LIS -- E Mail: [EMAIL PROTECTED] -- [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 27/03/2002 22:10 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle CPU Licensing Dennis, This doesn't sound right. Oracle will not try to extort, er, charge money for CPU's that aren't installed. Merely having the slots doesn't count. Having CPU's installed but switched off but installed is not a new concept, having been around in the mainframe world for some time. I wouldn't think Oracle would try to make you pay for CPU's you can't use. Best call your Oracle rep for a definitive answer. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/27/02 07:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle CPU Licensing An analyst recently made a statement that under CPU licensing "Oracle is charging for unused CPU slots". I found this very surprising. I can see two possible interpretations: 1. If the system is capable of holding 8 CPUs, but I only have 4 CPUs installed, Oracle would charge me for 8 CPUs. I find this unacceptable. For one thing, in some machines, a slot can contain either a CPU or memory. 2. Some vendors (HP I believe) have offered an upgrade on demand configuration, where the system is delivered with more CPUs than the customer purchased. If the customer wants additional processing power, the vendor can switch on the additional CPUs, saving a visit by a customer engineer. Another possibility would be if I had a way to limit the number of CPUs that could execute Oracle. This doesn't sound so bad, since it might be easy to increase the number of CPUs without paying additional fees to Oracle. Has anyone heard of this type of license interpretation by Oracle? Our license renewal is coming up soon and we would prefer to not be blindsided. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: 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: my boss wants a report !!!
That's the DBA job for me only 56 days a year ;-) Steve Parker Technical Consultant LIS E Mail: [EMAIL PROTECTED] -- Abdul Aleem se.edu.pk> cc: Sent by: [EMAIL PROTECTED] Subject: RE: my boss wants a report !!! 15/02/2002 10:43 Please respond to ORACLE-L The task of a DBA is to ensure that The database is available to users when they send their commands. Depending upon the business it could be 24x7x56 -Original Message- Sent: Friday, February 15, 2002 3:14 PM To:Multiple recipients of list ORACLE-L - Original Message - > > could anyone point out some more information to include showing the > "performance" of the DB ? > I'd rather use the reporting functionality of the Management Server, especially the "Instance" report OraSnap does similar job hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Abdul Aleem 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: 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: Reliable alerting system that is not so costly??
Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram [EMAIL PROTECTED]> cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 > QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, > London W6 9EJ > Registered in England No 3430894 VAT number - GB 701 8915 43 > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you > received this in error, please contact the sender and delete the material > from any computer > ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram 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: 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: Physical access to servers for maintenance
If you use Citrix on top of NT/2000 Terminal Services etc, your local drives can be mapped. I have used this to install printer drivers etc on a CD in my laptop onto the server. Local printers can be mapped too ! Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- -- 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).
RE: 9i D/l
Mark, Perhaps Oracle have an A and B list. The A list are told as soon as its out, so they can download it quickly. Then the larger B list is told, and they struggle to download it due to demand :-) I too registered to be told when 9i was available for W2k; as soon as I heard about it on the list yesterday morining I started "GetRight" to download it. When I came in at Lunchtime today it was all downloaded - I was amazed ! Good luck and I hope someone else pays your phone bill! Steve Parker Technical Consultant LIS -- E Mail: [EMAIL PROTECTED] -- "Mark Leith" ls.co.uk>cc: Sent by: Subject: RE: 9i D/l [EMAIL PROTECTED] om 18/09/2001 16:45 Please respond to ORACLE-L You know, this list is the greatest! I specifically submitted my name to the OTN site, to be told *apparently* "as soon as the version I am interested in is released" - which was 9i for Win2K. Guess what? The first I hear of this being released was HERE!! Still haven't heard anything from Oracle!! Now all I have to do is log on for 3 weeks to try and download it over my 56k modem :) I can't believe that that the download is over a GIG in size!! 8.1.7 was only close to 600 or so meg! We can't get Broadband services here either! In a CITY! Though I hear of people all around the country (even residencies) and small TOWNS etc. that can get ADSL, but here we are in a CITY and a BUSINESS wanting to get the service, and BT can't supply it to us!! Neither can NTL, because BT haven't installed it in our exchange!! Did I mention we are in a CITY?!?! Grumble grumble, moan, grumble, humph... Mark -Original Message- Gerardo Sent: Tuesday, September 18, 2001 08:05 To: Multiple recipients of list ORACLE-L I think you just have to keep trying. Maybe at different times. I experienced the same as you but with the 9i for Linux download. HTH Gerardo -Original Message- Sent: Monday, September 17, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas 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: Molina, Gerardo 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: UNSU
OT: Re: Whatever became of "ORAC"
In the UK, "ORAC" was a computer of the cult TV series Blake's Seven. "Orac was the most sophisticated artifical intelligence in the universe. It had an amazing array of technical abilities but it also had some problems." Problems It had a snappy voice and was often impatient with anyone unfortunate enough to ask it a question. It also showed little concern for the rest of the crew who it regarded with scorn. In short, Orac would much rather spend time contemplating the mysteries of the universe than spending time with mere mortals. Sorry for the sideline ! Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- "Orr, Steve" w.com> cc: Sent by: Subject: Whatever became of "ORAC" root@fatcity. com 06/08/2001 17:21 Please respond to ORACLE-L Do anyone know whatever became of ORAC. It was an attempt to build an open source web-based DBA tool in Perl but it doesn't look like much has happened. Here's a link. http://www.tux.org/orac-dba/news.html Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: 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 -- suggestions to ensure nerdiness in potential IT staff
I thik LOGO was based on LISP. Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. -- "Thater, William" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: OT -- suggestions to ensure nerdiness in potential IT Sent by: staff root@fatcity. com 02/08/2001 13:50 Please respond to ORACLE-L On Wed, 1 Aug 2001,Pat Hildebrand scribbled on the wall in glitter crayon: ->When I saw the question about boot disks I figured that the answer ->would be very dependent on the computer because I know there were ->computers at that time that didn't use disks. However, the computer ->that I got in 1981 required a boot disk. i started programming on IBM 1440s and 360/20s. on the 20 you had to dial in the IPL code to get it to read the first card. -> ->In fact that computer brings to mind a few other questions from that ->time. Before the introduction of the IBM PC, what was considered the ->operating system for business micro computers? What manufacturer made CP/M [or is it CPM i've seen it written both ways.] ->What is the language that uses a turtle for teaching children about ->computers? What language was it based on? LOGO but i don't remember what it's biased on. bit rot.;-) -- Bill Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] It's got to come from the heart if you want it to work! IBM: Into Building Money -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: 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 -- suggestions to ensure nerdiness in potential IT staff
Oh, I remember reminiscing ! I was all set to become a vetinary surgeon when I met a Commodore Pet, running rat trap and was hooked. That was 25 years ago. (sounds of sobbing and tears hitting the keyboard) Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. -- "Thater, William" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: OT -- suggestions to ensure nerdiness in potential IT Sent by: staff root@fatcity. com 02/08/2001 16:01 Please respond to ORACLE-L On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter crayon: ->we called that 52 card pickup -- take deck, throw in air, run like the devil ->was after us. -> ->I learned EARLY to draw intricate designs on the top of the deck so as to ->make putting it back together simpler. -> ->When projects were due, I'd cut every class but the computer ones, and stay ->in the computer center until midnight,when they closed. Oh the good old ->days! i was one of those geeks who could put object decks back in order by hand.; -) i still have several boxes of card decks. the kids like them for bookmarks. -- Bill Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] It's got to come from the heart if you want it to work! If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. - Robert X. Cringely -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: 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: Oracle *Chocolate* Monitoring Tools/Friday Recipe
They even do a low calorie version with sweetners instead of glucose... What's the point ! Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- lerobe - Lee RobertsonTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Sent by: root@fatcity. com 20/03/2001 08:05 Please respond to ORACLE-L Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. > Applewhite > Sent: Monday, March 19, 2001 11:16 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe > > > Kimberley, > > I'd be surprised if you can get "real" raw sugar in stores. > > When I was in the U.S. Peace Corps in Belize in the mid > '70s, raw sugar was readily available, since sugar was a > primary export from that beautiful little country. If you > let a couple of pounds of raw sugar sit in a brown paper bag > for a day or two, the molasses would settle to the bottom > and puddle - a jar, shaken occasionally, was a better > storage option. > > It was delicious! There's nothing quite like a peanut > butter and raw sugar sandwich! Ironically, the Belizians > preferred refined, white sugar, since it was considered more > "upscale" than the raw sugar. > > BTW, other advantages to living in a sugar-exporting country > included very cheap soft drinks and rum!...Oh, and Reggae! > ;-) > > Jack > > > Jack C.
RE: Standby db license for 8.1.6
Hi, on the subject of licensing, has anyone used something like HPs Resource Manager on HPUX to restrict the amount of CPU usage for Oracle on a multi-CPU system, and therefore saved on licensing costs. It does seems unfair if you need a large server for all your application processes which only uses Oracle as a back-end database, that you have to pay as though Oracle is using all the CPU power !! Cheers Steve Parker E Mail: [EMAIL PROTECTED] -- Dennis Taylor <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: RE: Standby db license for 8.1.6 root@fatcity. com 09/03/2001 23:31 Please respond to ORACLE-L At 01:55 PM 3/9/01 -0800, you wrote: >Hi Dennis, > >In my previous job as a dba in a dot com, it was found db2 to be more >attractive in terms of price/features. > >are u including database clients software, hardware for the database server >and backup infrastructure for the concerned databases > >would be glad to receive ur summary. FYI this is basically what I'm asking: I've specified the server as an intel box with 2x750 Mhz cpu, running either linux or NT. I've specified 3 scenarios in terms of number of servers and number of users, and a fourth as an internet-based database server for a web page. I've asked for the price for each dbms *only*. This should give me an idea of the relative costs for the databases under a number of conditions. If the salescritter attempts to bob and weave, that's relevant information as well. Dennis Taylor ILLEGITIMUS NON CARBORUNDUM. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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: 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 Licensing
Dennis, we have been through this over here in the UK too. It is Either Universal Power Units (UPU) OR Named Users, you would normally purchase the lower unless the figures were so close that you might as well go for unlimited users, especially if you expect to need more named users in the future. (Simplifies support renewal too!) Some Gotchas... In Standard edition the min. named user is 5, not UPU/30 ! (Unless its different outside the UK) Named Users can also access any number of servers if you go for the Named-User-Multi-Server option - BUT NOTE if you are running a load sharing cluster, using OPS for example or Oracle's hot standby, then this also counts as multi-server or the combined UPU value for both (all) servers. The only exception is Failover systems, e.g. using HP's MC/ServiceGuard, HACMP etc; this requires UPU licences for the largest server or Named-User-Single_server. Clear as mud now! This was how it was explained by our Oracle distributor, eventually. Steve Parker E Mail: [EMAIL PROTECTED] -- Dennis Taylor <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: RE: Oracle Licensing root@fatcity. com 06/03/2001 15:35 Please respond to ORACLE-L At 03:00 AM 3/6/01 -0800, you wrote: > >As luck would have it I was evaluating the prices of Oracle and then SQL >Server today. > >My question at this point is, what kind of prices does Microsoft charge >for support, I was pretending to purchase SQL Server and noticed that no >mention is made about product support. > >Using the "Power Unit" method MS and Oracle come out within about $5k of >each other, but when you get to their Enterprise editions, MS is just >under $20k where as Oracle is way out there. The cheaoest I could get >Oracle, with unlimited users (which is what I need). On a 1ghz Intel, >single processor machine with a 2 yr lic, Oracle Enterprise costs $45,600 >(thats if you want support with your DB). > Well, I bow to your superior wisdom, because I'm damned if I can figure it out. Here's what I have: linux box, 2x750MHz intel cpus, want to load Enterprise edition. That gives me 1500 UPU's. According to the web page, UPU's are $100 per. That gives $150,000.00 According to the web page, my minimum user count is 1500/30 = 75. According to the web page, perpetual users are $750 per, so 750x75 = $56,250.00 Now, do I pay the higher number, the lower number, the sum of the numbers, or what? I find it hard to believe that Oracle wants $206,250.00 just for an intel box, but there's nothing on the web page to indicate otherwise. Obviously this is another case of "give us your credit card, then we'll tell you how much you've paid". Can someone clarify this? (for those who are wondering why I don't just phone a salescritter, I have three reasons: 1) I need an answer this week, 2) I need an answer in plain english, and 3) Once a salecritter smells blood, er, money, it's like trying to get two-sided tape off your fingers.) Dennis Taylor In any human endeavor, once you have exhausted all possibilities and have failed, there will be one solution, simple and obvious, highly visible
Re: Stand by db
Just a note that Automated Standby is not included in the standard version of Oracle. Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- "Kevin Kostyszyn" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Stand by db Sent by: root@fatcity. com 27/02/2001 15:55 Please respond to ORACLE-L Hi all, I have a client that wants to implement an Automated Standby DB using Oracle 8i. Has anyone here attempted this and have any pro's and con's on it. It looks pretty simple and straight forward to me, seems the biggest problem will be sizing the redo logs correctly. Any advice would be greatly appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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: 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: MS KB Article
The link isn't actually to Microsoft. If you look closer you will see it actually refers to www.hwnd.net the bit in front is logon detail. Although it may be forced to move from there eventually ! Steve Parker Technical Consultant LIS E Mail: [EMAIL PROTECTED] -- -- 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).