RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Jack, Any issues with Terminal Services...since Oracle doesn't support Terminal Service's use? Thanks, Ed -Original Message-From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance Me too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2 Webservers) at a colocation facility and have used either PCAnywhere or Terminal Services to access them over the Internet for the last 9 months. The developers have never needed to have access to the servers except to put in the Cold Fusion CD to install CF Server. I've only needed access once, to load some big files that I later imported into a test db on one of the servers (actually, that's when I put in the CF CD, to save the developers a trip). Even then, I really didn't need to be there, I could have transferredmy files via PCAnywhere. If I were the SysAdmin I would have needed access a couple of times to replace failed drives, but the colocation guys took care of that. I recovered our Production db remotely after they replaced the drives. It's very nice to be able to PCAnywhere in to those boxes from home. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent: Wednesday, September 26, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance You can use a tool such as ControlIT to connect to NT machines. Its how I do it, both from the office, and from home. How do all these people who claim you need access to the server room to do the day to day stuff provide remote support? I will be damned if I come in during the middle of the night for a database issue.
OT: Nostradamus: RE: RE: STOP THE PRESS!!
The following quatrain has been circulating the Internet after the WTC bombings. In the City of God there will be a great thunder, two brothers torn apart by chaos, while the fortress endures, the great leader will sucumb. The third big war will begin when the big city is burning. It is NOT by Nostradamus. The original source may be http://www.ed.brocku.ca/~nmarshal/nostradamus.htm. Here is a short excerpt from that page. How does this apply to Nostradamus? Well I will show you... If I make say a thousand prophecies that are fairly abstract for example: In the City of God there will be a great thunder, Two brothers torn apart by Chaos, while the fortress endures, the great leader will succumb Well let us analyse this. For Example what does City of God mean? It could be Mecca, Medina, Rome, Jeruselum, Salt Lake City, or any holy city depending on your religion. What do I mean by thunder--a storm? War? EarthQuake? lots of stuff can be described by thunder. There are a lot of two brothers on this world (I think the Number runs among the Billions) and fortress edure's what--Besiegement, Famine, etc? What Great Leader? How will he succumb? To what? -Original Message- Sent: Wednesday, September 12, 2001 1:15 PM To: Multiple recipients of list ORACLE-L I just got this from a friend. In the City of God there will be a great thunder, two brothers torn apart by chaos, while the fortress endures, the great leader will succumb. The third big war will begin when the big city is burning. On the 11th day of the 19th month that two metal birds would crash into two tall statues in the new city and the world will end soon after. Michel de Nostredame Nostradamus Century 9, Quatrain 16:54 -Original Message- Sent: Tuesday, September 11, 2001 5:12 PM To: Multiple recipients of list ORACLE-L YEAH, CRUSH THE A**HOLE'S and ANYONE or GOVERNMENT who supports this act! * THIS IS AN ACT OF WAR, comparable if not worst than Pearl Harbor * Gene [EMAIL PROTECTED] 09/11/01 12:15PM My heart goes out to our friends in America...this is sad, sad newslet's hope your president makes the right decisions in handling this affair... K. -Original Message- Sent: 11 September 2001 15:55 To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- Please see the official ORACLE-L
RE: Apologies... linux Oracle
Title: Apologies... linux & Oracle O.K...it looks like SCO was bought by Caldera, who sells a distribution of Linux under that name. Ed -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 12:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apologies... linux Oracle Lisa SuSe is the best so I have been told. I am about to install 8i on 7.1 and another guy here is installing 9i on 7.2. Totally untested on my behalf as I haven't started yet but that is the best I have been told. Probably of no use whatsoever !!! Lee -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 21 August 2001 16:51To: Multiple recipients of list ORACLE-LSubject: Apologies... linux Oracle Sorry everyone, I know you were just discussing this recently. What is the most stable combination of Oracle Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. Thank you Lara Croft Oracle Database Administrator Fairfield Resorts, Inc The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.
RE: Apologies... linux Oracle
Title: Apologies... linux & Oracle SCO makes a version of Linux now? Ed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 11:51 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies... linux Oracle Sorry everyone, I know you were just discussing this recently. What is the most stable combination of Oracle Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. Thank you Lara Croft Oracle Database Administrator Fairfield Resorts, Inc
TNSPING Test Script for NT
Can anyone help me with a simple .bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have the TNSPING run for say 1000 loops. Once complete, I can search through the file for errors. Thanks, Ed -- 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: linux
Nope! -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: linux Hi Friends, I have small clarification to be made. Can oracle for linux software be intalled on FREE BSD. Thanks in advance Saravana
RE: Oracle books
It kinda depends on your environment, but I like: Oracle8i DBA Handbook Oracle Press Oracle8i Backup and Recovery Oracle Press Oracle 24x7 Tips and Techniques Oracle Press Oracle Networking 101 Oracle Press Oracle Documentation http://otn.oracle.com This covers much of the core Oracle DBA stuff. For some advanced topics: Oracle Internal Services: Waits, Latches... Steve Adams O'Reilly Unix for Oracle Don Burleson O'Reilly (Can't remember exact name) Oracle Performance Tuning Guy Harrison (Publisher?) Haven't read book yet, but looks good: Oracle STATS Pack Don Burleson Oracle Press Hope that helps Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, May 08, 2001 2:32 PM To: Multiple recipients of list ORACLE-L Being a relatively new and often times struggling Oracle DBA I was wondering what 3 or 4 books everyone recommends as a must have reference/knowledge base in day to day support/programming of their databases. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Myers 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: cdump, bdump, udump
Yeah, as soon as Palm increases the amount of Memory to something like 1GB. ;-) Ed Haskins Oracle DBA Verizon Wireless maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Stock item: We shipped it once before, and we can do it again, probably. -- 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: Oracle vs DB2
Dennis, The IBM Sales Critter hit the nail on the head by saying: that in some cases, IBM is *giving* DB2 away, if there's enough ancillary business (hardware, consulting, etc). It's that ancillary business you better watch out for!! IBM is using DB2 as their Loss-Leader. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 24, 2001 4:28 PM To: Multiple recipients of list ORACLE-L At 10:46 AM 4/24/01 -0800, you wrote: Not true. You can use the Standard Edition for serving web pages. We're doing it. Yep. I've corrected myself on that in another email. One thing I don't get: it's $6,000 Cdn for a 1-user license, right? How is a 1-user license going to do you any good if you're serving web pages? Just interested in how the WE Internet Access works. The 1-user license + WE = a legal DB2 web-database. This according to the IBM salescritter. Got it on paper, too. :-) We had some IBM guys in here late last year, and they couldn't give us any better pricing than what we could get Oracle Standard Edition for. Times change. My salescritter is saying that in some cases, IBM is *giving* DB2 away, if there's enough ancilliary business (hardware, consulting, etc). I guess I should add a disclaimer to my rant at this point. We are a small shop. I mean *SMALL* shop. 30 people in the company. 30K for a web database may be peanuts for a fortune 500 company, but for us, it's significant. YMMV. Dennis Taylor Beware of false economies. -- 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: Recall: Listener.log
Title: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, "Listener.log". Matt, No need to recall...we don't bite!! Ed
MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM buys
Title: RE: News flash - IBM buys Informix REDWOOD SHORES, Calif. Hoping to reassure skittish customers, Oracle Corp. is guaranteeing to install a complex piece of online business software in 90 days or the company will give the product away. The Redwood Shores-based software company will introduce the new promise Tuesday under a new marketing campaign called "The War on the Complexity," CEO Larry Ellison said Monday during a 90-minute meeting with reporters. The pledge amplifies on Oracle's efforts to build upon its leadership in database software to sell more products that help companies automate a wide range of sales and administrative chores. It also represents the latest in a long history of marketing gimmicks for Oracle, which is trying to dominate Internet software like archrival Microsoft Corp. does personal computer software. -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 4:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: News flash - IBM buys Informix Why doesn't he buy IBM ? Rivaldi Oracle DBA -Original Message- From: Haskins, Ed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 3:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: News flash - IBM buys Informix I think Larry should buy Sybase!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 24, 2001 3:21 PM To: Multiple recipients of list ORACLE-L It has been announced today that IBM has purchased Informix. See your local tech news service later today for details. H. Wonder what Larry thinks about this? Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed 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: ORA-04030
128MB of memory is killing you! Oracle's stated minimum requirements are 128MB (but they recommend 256MB). In fact, the Oracle Installer won't even run without 128MB (in 8.1.6 and higher). Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, April 23, 2001 12:56 PM To: Multiple recipients of list ORACLE-L What did you try and resize it to? Remember, you only have 128 mbs. -Original Message- [EMAIL PROTECTED] Sent: Monday, April 23, 2001 12:02 PM To: Multiple recipients of list ORACLE-L How big is your shared pool size ? Do you have many dynamic SQLs ? You may want to keep the sys packages in the shared pool, so that your shared pool won't be fragmented by dynamic SQLs. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Dorozhkin, Anton Anton.Dorozhkin@artificiaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] l-life.rucc: Sent by: [EMAIL PROTECTED] Subject: ORA-04030 04/21/01 07:05 AM Please respond to ORACLE-L I've got a such error when run a PL/SQL scripts on Windows 2000, Orcale 8.1.7 with 128MB memory ORA-04030: out of process memory when trying to allocate 257280 bytes (PLS non-lib hp,PAR.C:parchk:ptb) I've tried to change settings in init.ora but this didn't help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dorozhkin, Anton 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). -- 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).
HYPER VOLUMES - RE: Never split index and data files ...
Dick, Thanks! SAME also suggests using the outer half of each disk for data storage...as I/O performance is increased due to the natural circular shape of the platter. My question...how do you specify which sections of each disk are utilized? From what I've been able to read, I'm guessing that hyper volumes could be used for this?? I'm not sure...haven't had the opportunity to play with this yet. Anyone have an answer for this? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 20, 2001 5:04 PM To: Haskins; Ed; Multiple recipients of list ORACLE-L ED, Damn good question! No I won't take it as sarcastic at all. Now to your point: We had to implement this particular strategy about 4 years ago due to the vendor we bought a disk array from (IPL). They were somewhat ahead of the curve here. Simple theory, they configured the 30GB array as one very large disk drive with all of the disks striped and mirrored. Simply put the SAME principle. Problem, there was only one SCSI channel into the array, OOPS, bottle neck par excellence! Again not too far in the recent past we did a similar thing with some EMC disk, but this time we used 4 SCSI cables with EMC's Power Path software. OH FUDGE, the 4 hyper volumes were all on the same spindle, Damn, bottle neck par excellence again. So as you can see, it makes a wonderful theory, but I haven't seen the pudding, yet. Still trying! Dick Goulet Reply Separator Author: Haskins; Ed [EMAIL PROTECTED] Date: 4/20/2001 9:25 AM Dick, Don't take this the wrong way...it's NOT meant to be sarcastic: You said SAME is a great theory, but I can't and haven't seen it perform well in practice, yet. My question to you: Have you seen it in practice at all? An actual working implementation? For that matter; has ANYONE seen it implemented in a production environment? I'm sure it must be somewhere, but I'm curious if anyone knows where. This is a subject that I'm really into right now...that's why I'm prodding a bit! Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 20, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Steve, I heard about this SAME philosophy at the last NorthEast Oracle Users Group meeting from a individual who works on the utilities for Oracle in the New England Development Office. Although we did not get deeply into the philosophy, I'll agree that it is not the silver bullet, actually it can become a performance detractor. The individual who wrote the paper for Oracle (Anjo Kolk) is a LONG time Oracle person, actually wrote the core of the kernel, so I believe he's probably writing from a purely theoretical point of view. In that light what he's saying would be true, stripe mirror everything and theoretically you should never have an io bottleneck. BUT, many hardware platforms don't handle mirroring very well unless your using a disk array like EMC's. Now that handles the mirror internally so we've alleviated that problem, but EMC likes to break their drives into 'hyper volumes' so your stripping may or may not be across physical drives. Also your stripes can still have the bottle neck of the number of SCSI cards in the computer. In any case taking a little time to insure that redo logs, archive logs, indexes, and data are all REALLY spread out across devices is the only way to go. SAME is a great theory, but I can't and haven't seen it perform well in practice, yet. Dick Goulet Reply Separator Author: Steve Adams [EMAIL PROTECTED] Date: 4/19/2001 11:25 PM Hi All, The author (Anjo Kolk) is an advocate of SAME (stripe and mirror everything). The SAME philosophy is that everything should be striped across all the disks available. Separating indexes from their tables is contrary to that philosophy. I don't agree with it, but that's where he's coming from anyway. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 20 April 2001 6:56 To: Multiple recipients of list ORACLE-L Whoaaa, I sure hope someone can, because I have never heard that before? Kev -Original Message- Ghosalkar Sent: Thursday, April 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Guys, i was checking my statspack report on oraperf and i came across this statement. Never split index and data files to different sets of disks. can anyone xplain the logic behind this. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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
RE: PL/SQL-if-statement
Title: RE: PL/SQL-if-statement Pool Party? Where? I hear that the new power drink "Red Bull" tastes great with Absolut!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 19, 2001 5:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL-if-statement Hi Q, how's lovely MN? That was in response to other people in our company who have their self-important MS certifications spelled out in their entirety in their signature. Instead of spelling out 'Oracle Certified Professional - Database Administrator' in my signature I figured I could be creative. The only title I nixed was Supreme Queen Office B*ch... though it is rather appropriate. I also was promoted to 'Senior Dba' last week but I don't think that's appropriate, either... Titles are nothing ! They pay me way too much for how much goofing off I do. It's been a long week and tomorrow afternoon is Pool Party Time at my house. Everyone's invited :) Captain Morgan and Sir Absolut will be making an appearance. Cheers All!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL-if-statement Lisa Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess Love the new by line - it suits you well - but one question - is that Self Certified Self Important datavbase Deity or did you pass a special OCP exam for that ? ;-) Q "Koivu, Lisa" [EMAIL PROTECTED]@fatcity.com on 04/19/2001 11:40:54 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Have you tried rpad() or lpad()? Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Thursday, April 19, 2001 10:56 AM To: Multiple recipients of list ORACLE-L How can I change this pl/sql code, in the while-statement maybe so that if the field OWNER_NO is NULL, then it should be written six characters? The code looks like this: "IF recCursor.OWNER_NO is null then vOWNER_NO := '00'; else v_OWNER_NO:= to_char(recCursor.OWNER_NO); WHILE length(vOWNER_NO) 6 LOOP vOWNER_NO '0'0' || vOWNER_NO; END LOOP; END IF; How shoud I write to fix this script so therw will be written out 6 characters if the field OWNER_NO is empty. I want to use the WHILE LOOP. Any one whom can help me with this? Roland Sköldblom -- 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: 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 Redo Logs
Yes, I can...I think. What it is saying is...it is possible to have a volume or partition extended over multiple disks. For example; you can have 2 4GB Hard Drives, and it is possible to Format Drive 1 as let's say Drive D:\, then format 2GB of Drive 2 and add it as an "Extended Partition" of D:\. If you have a 5GB datafile (or index), the file would be on one "logical" partition, but two physical hard drives. You don't want to do this! Thus, "Never split index and data files to different sets of disks." (UNLESS: you are using RAID...then it makes sense that your datafiles will be spread over multiple disks). Hope that helps! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, April 19, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Whoaaa, I sure hope someone can, because I have never heard that before? Kev -Original Message- Ghosalkar Sent: Thursday, April 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Guys, i was checking my statspack report on oraperf and i came across this statement. "Never split index and data files to different sets of disks." can anyone xplain the logic behind this. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar 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: 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: server sizing
Lerone, My opinion is that your database on an NT platform will not scale as well as you may hope. You are talking about adding 100-150% more data and tripling your users to 300. I would strongly recommend going to a Unix platform for your database. Also, if the database is going to grow that much...it is likely a write intensive application that would perform better on something other than RAID5...maybe RAID0+1. Certainly there are servers that can handle this load...on NT, but if you are going to that large a server...why not go Unix and increase your performance (I know, an NT box costs less...but if cost isn't an issue!?!). That's just my opinion...and I actually started my IT career as an NT Admin! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 17, 2001 12:35 PM To: Multiple recipients of list ORACLE-L in gaining knowledge about oracle I've been introduced to some concepts, components, and concerns and I'd like to get some general feedback. so, in general how big of a deal is server design? what would you use as criteria for decision making, like the need for multiple controllers and drive/file system configurations. my background is with ms-sql/nt and we're looking at migrating/upgrading to oracle/nt. we've had success with raid 5 via a single controller with multiple channels. I've been to the oracle dba pt 1a and have been exposed to oracle architecture; we never had such concerns so I have no basis of comparison. our instructor and classmates, while knowledgeable, were more developers than system engineers; whereas we'll be more system engineers/administrators than developers. what kinds of metrics/performance should I be looking at, considering, and shooting for from the start? right now we have about 100 users and a 20G DB which *will* increase to probably 300 users and 40G to 50G DB; on average we're looking at about thirty thousand transactions over an 11 hour period; again that'll probably increase to 70,000 to 80,000 transactions over an 11 hour period. reads/writes/queries/indexes, their size and speed, and other such processing metrics, were never a concern. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX 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 being scalable
When you click on the link...add 'tml'(as in ,html) to the URL...it was cut off on the hyperlink provided! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, April 05, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Did you really mean the error page? RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 11:26 AM Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h tml Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- 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: 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: 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: Upgrade from 8.0.6 to 8.1.7
Pallav, Go to http://otn.oracle.com and get the Oracle8i Migration document under "Documentation". That will provide you with what you need! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, March 29, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Hi Guys, Did anyone do an upgrade from oracle 8.0.6 to 8.1.7 version in a Sun Solaris envrionment ?? Can you send me step by step procedure on how to do it, I cant find any good documents on metalink. Thanks! Pallav Kalva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pallav Kalva 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: OPS
FYI: They must also be on Raw Partitions!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, March 27, 2001 10:36 AM To: Multiple recipients of list ORACLE-L For an OPS configuration, disks have to be shared among the nodes, which usually means some kind of common IO bus (SCSI, FCAL, SSA). That means that the nodes must be within cca. 2 miles (3 km). -Original Message- Sent: Tuesday, March 27, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hi all! Does anyone know is it possible to configure OPS between two remote sites? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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: Gogala, Mladen 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).