RE: Currval and buffer gets
.shtml __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha 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: James McCann 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: Table Partitioning - Opinions
If your queries are using indexes, then 2 million rows will be no problem to Oracle even without partitions. Jim -Original Message- Darren Sent: 12 March 2002 17:45 To: Multiple recipients of list ORACLE-L We are in the process of deciding whether to purchase a license for the partitioning option of Oracle. We are developing a data warehouse, with our largest tables being approx 2 million rows and about 300 Megs in size. We have setup two tables, a standard table ( 2 million rows) and a partitioned table using the data from the standard table. We used two types of indexes for the partitioned table, a standard index, ran the tests and a partitioned index and ran the tests again The tests are basic queries we felt would take advantage of the partitions. We used a simple timing function to determine the time in which it took to process the queries To our surprise we found very little difference between the times to process the queries. Is it possible that the benefit of using a partitioned table only happens with really large tables ( 10 Million rows) ? and as our tables are relatively small, then partitioning would be of no advantage at this time. Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: James McCann 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).
Security assessment tools
Hi, does anyone know of any security assessment tools for Oracle? Preferably one that can be downloaded as a trial version, Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
Hi, while we are on this topic, I would to ask you all about a system I was working on recently. The main problem was that approx. 64 threads were almost continuously doing full table scans on a small table of 800 rows (the developers insisted this was necessary). This table was in 1 or 2 blocks and was having a huge amount of cache buffers chains latching. When we forced the sql to use the index, the latching moved to the index. I did all the usual tricks like spreading the table out across a lot more blocks , increase the spin count etc. with limited success. My view was that with so much activity going on on this small table, the latching would never be fully eliminated, and it was poorly designed code. I just want to check that everyone agrees with me, or would you expect to be able to eliminate the waits even under these conditions? Thanks for your advice, Jim -Original Message- Manning Sent: 28 February 2002 17:14 To: Multiple recipients of list ORACLE-L _db_block_hash_buckets [Mogens Nørgaard] Amen. Contention for cache buffers chains means too much logical IO, ie. find and exterminate heavy SQL. I don't see why the heavy SQL would result in the chain having 66 buffer heads in it, though, or why the sleep count would be so skewed. And my core question is still whether the number of buckets being non-prime is normal or not - it seems awfully wrong to me. That there's a lot of contention *is* a factor of the SQL, but the fact that it's so skewed to only a few chains is what worries me more. Once I have the contention down to a particular latch, but that latch protects a buffer chain with 66 buffer heads in it, how can I find out which ones of the 66 are generating the most attempts at that latch? Tell ya what - can I get a few ppl to run this query? It tells the min/max/avg for the number of buffers associated with each chain and if my numbers are high I can at least have a chance of spreading out the buffers over more chains (by upping the number of latches from 4k to 16k, 32, whatever) - it won't drop the actual IO any, of course, but since I don't have a hard fix on which buffers of the 66 are really the source of my contention, I'm not sure where to go from here. SELECT min(buffers_per), max(buffers_per), avg(buffers_per), sum(buffers_per) FROM ( SELECT count(*) buffers_per, hladdr FROM x$bh b, all_objects o, v$latch_children v WHERE b.HLADDR=v.addr AND b.obj=o.object_id AND v.name LIKE '%cache buffers %' GROUP BY hladdr ) My results: min = 39 max = 119 avg = 55.06 sum = 22 If this shows to be about the same in other (well-tuned) Oracle DB's, then I won't worry as much about the number of buffers in each chain and would then focus on trying to isolate the specific buffers, then the source SQL causing the problem, etc. Given my previous sql trace analyses, I have a good idea what the problem SQL statement is, but it's a bit of a necessary evil right now (a join of a table (260k rows) and a materialized view (2k rows), 6 conditions in there where, and it gets executed a ton, probably on the order of 10x a second at peak) - all indexes that helped performance are created and around already. :( But, ideally I'd like to be able to prove this is the cause of the hot buffers before fixing anything. Thanks, guys!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning 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: James McCann 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: Clash of the DBs in eWeek
I was involved in a similar thing a while ago, with a couple of different databases including a new in memory database, which is meant to be 10 times faster than Oracle. And it was, until Oracle was tuned. It was a different story then! Jim -Original Message- Sent: 28 February 2002 19:43 To: Multiple recipients of list ORACLE-L Do you mean it was SQL Server DBAs tuning Oracle in this test, because that's what they are using for their web-site? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT 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: Igor Neyman 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: James McCann 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: [Fwd: UNIX Performance Issues]
Title: Message Hi, I was at the Sun benchmarking labs in Paris before Christmas, and they had a tool which someone on there was working on. It had a web based interface, and showed everything OS performance related that you could think of. It was also very configurable, and had lots of graphs, charts etc. One of the best thing about it was that it could record the past statistics, for trend analysis. And had good report generation tools. The problem is I didn't catch it's name, and don't know if it's released yet. Sorry. Also, take a look at "High performance oracle tuning with statspack". It has lots of scripts etc. doing the type of thing you want. Jim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James MorleSent: 19 February 2002 13:58To: Multiple recipients of list ORACLE-LSubject: RE: [Fwd: UNIX Performance Issues] Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application
RE: Where does a DBA go from here?
I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: James McCann 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: Where does a DBA go from here?
I meant to say of course Kirti's book Jim -Original Message- McCann Sent: 08 February 2002 11:18 To: Multiple recipients of list ORACLE-L I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: James McCann 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: James McCann 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).
Statspack question
Hi, I just want to check something about statspack. Might seam like a silly question, but I just want to check. In the Instance Efficiency section, you have the hit ratios. Normally when people check these, it is from instance startup. I was just wondering if statspack is the same, or does it work it out just between the 2 snaps you tell it to? i.e. the delta. Cheers, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Statspack question
Thanks John, that's what I thought, but I just wasn't sure if it applied for the ratio's as well, Jim -Original Message- Sent: 31 January 2002 12:55 To: Multiple recipients of list ORACLE-L HI James, This will tell you these percentages during the time you are reporting on. John [EMAIL PROTECTED] wrote: Hi, I just want to check something about statspack. Might seam like a silly question, but I just want to check. In the Instance Efficiency section, you have the hit ratios. Normally when people check these, it is from instance startup. I was just wondering if statspack is the same, or does it work it out just between the 2 snaps you tell it to? i.e. the delta. Cheers, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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: James McCann 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$ / default accounts
Speaking of default accounts with default passwords, here is my list that I check for. Anyone want to compare notes :) i.e. have I missed any? Thanks, Jim perfstat/perfstat TRACESVR ??? is only used with 7.x Databases REPADMIN ??? CTXSYS/CTXSYS DBSNMP/DBSNMP INTERNAL/ORACLE MDSYS/MDSYS MTSSYS/MTSSYS ORDPLUGINS/ORDPLUGINS ORDSYS/ORDSYS OUTLN/OUTLN SYS/CHANGE_ON_INSTALL SYSTEM/MANAGER SCOTT/TIGER -Original Message- Kirti Sent: 31 January 2002 15:25 To: Multiple recipients of list ORACLE-L Stephane, Thanks. Yes, we are properly fenced None of the databases have those default accounts with default passwords. We do not use OEM and that agent. Passwords of critical accounts get changed regularly and often. Database user ids are generated approved by Data Security group before DBAs can add them to databases (so others do not know and can not guess who has what id), and they request reports of access privileges when least expected. So, it's all how you manage your set up. When I joined this company I was going nuts about such things (remote_os_authent, default links by virtue of Oracle Names etc), but as I learned the environment I was comfortable.. And it is helping us more than creating problems and concerns. Cheers ! - Kirti -Original Message- Sent: Thursday, January 31, 2002 2:20 AM To: Multiple recipients of list ORACLE-L Deshpande, Kirti wrote: We use REMOTE_OS_AUTHENT in many of our databases. I know we shouldn't do this, but we have to, and that's another topic... We also use a specific auth prefix. Now, can someone show me how a Windoze user, 'GOD' get in the database when I do not have a user, 'Auth_PrefixGOD' in my database. I say, I have nothing to worry about this setup as long as 'GOD' user in my database is controlled appropriately via roles, grants, profile etc Sure, if I had auth_prefixGOD in the database, I will be looking for another job Right? - Kirti The problem as I see it is that it's fairly easy to get the names of users on a database. The number of databases you can connect to using dbsnmp/dbsnmp or outln/outln is desperately high, and from there you can query ALL_USERS. I must say that I am truly hopeless with any Microsoft OS, so you could safely let me with admin rights on the box when I feel at my most mischievous. But imagine I come with Linux on my laptop, I plug (like many 'nomad' users often do) into your network, manage to connect (as a less-than-nothing user), check the user list, spot something looking like a prefix, and use this information to add with linuxconf a suitably named account to my machine? I am certain that in your case everything is correctly fenced, but I have met many many many databases where the standard in terms of grants was 'TO PUBLIC', and where database links were PUBLIC as well, and usually connected to the other database as the owner of most tables (even as DBA). IMHO, if you really want to be secure, you must first know Oracle and your environment well, and also audit sensitive information. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: James McCann 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$ / default accounts
Big list. Didn't think of searching the directories. That would have been easier and better than searching the docs, as I did, Doh! I'll have to write a procedure to rename/lock them if they exist, Jim -Original Message- Faroult Sent: 31 January 2002 17:41 To: Multiple recipients of list ORACLE-L James McCann wrote: Speaking of default accounts with default passwords, here is my list that I check for. Anyone want to compare notes :) i.e. have I missed any? Thanks, Jim perfstat/perfstat TRACESVR ??? is only used with 7.x Databases REPADMIN ??? CTXSYS/CTXSYS DBSNMP/DBSNMP INTERNAL/ORACLE MDSYS/MDSYS MTSSYS/MTSSYS ORDPLUGINS/ORDPLUGINS ORDSYS/ORDSYS OUTLN/OUTLN SYS/CHANGE_ON_INSTALL SYSTEM/MANAGER SCOTT/TIGER There are many others in the various demos which may or may not have been run. Here here my additional passwords (when no password is specified, it means that the default is identical to the username) BTW it's TRACESVR/TRACE and REPADMIN/REPADMIN List compiled by searching 8.1.7 and 9i directories. RMAN/XX VRR1 VIDEOUSER USER0 to USER9 TEST SECDEMO SAMPLES PUBSUB PRIMARY POWERCARTUSER PO OSE$HTTP$ADMIN/FOO ORDMEDIADEMO ODS OCITEST MOREAU MONITOR MODTEST/YES MMO2 MILLER MIGRATE MFG MDSYS JONES/STEEL JOE/WELCOME (Logminer ;-) ?) JMSUSER IMAGEUSER GPLD GPFD FND FINANCE EVENT DUMMY DEPLOYER DEMO8 CSMIG COMPANY CLARK/CLOTH CDEMOUCB CDEMORID CDEMOCOR CDEMO82 BLAKE/PAPER AURORA$ORB$UNAUTHENTICATED/INVALID AURORA$JIS$UTILITY$ AUDIOUSER AQUSER AQJAVA ADLDEMO ADAMS/WOOD You can add TEST/TEST, DBA, ADMIN, ORACLE etc. to the list. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: James McCann 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$ / default accounts
Jared,
I'll have a go when I get the chance.
Did I hear someone on the list mention that you are bringing out an
Oracle/Perl book?
Jim
-Original Message-
[EMAIL PROTECTED]
Sent: 31 January 2002 18:39
To: Multiple recipients of list ORACLE-L
For those of you that use Perl and DBI, here's a script to check for
default
passwords. If you feel like extending the password list ( hint, hint ), I
wouldn't
mind a bit.
Jared
#!/export/home/oracle/perl/bin/perl
# odpc.pl
# oracle default password check
# Jared Still
# [EMAIL PROTECTED]
use warnings;
use DBI;
use strict;
use Getopt::Long;
my %optctl = ();
Getopt::Long::GetOptions(
\%optctl,
database=s,
username=s,
password=s,
sysdba!,
sysoper!,
z,h,help);
my($db, $username, $password, $connectionMode);
if (
$optctl{h}
|| $optctl{z}
|| $optctl{help}
) {
Usage(0);
}
$connectionMode = 0;
if ( $optctl{sysoper} ) { $connectionMode = 4 }
if ( $optctl{sysdba} ) { $connectionMode = 2 }
if ( ! defined($optctl{database}) ) {
Usage(1);
die database required\n;
}
$db=$optctl{database};
if ( ! defined($optctl{username}) ) {
Usage(1);
die username required\n;
}
$username=$optctl{username};
$password = $optctl{password};
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{
RaiseError = 1,
AutoCommit = 0,
ora_session_mode = $connectionMode
}
);
die Connect to $db failed \n unless $dbh;
# this is a hash of common default accounts and
# the default passwords in hex form
# to extend the list, just use this SQL
#
# select username, password
# from dba_users
#
# use the resulting password for accounts that
# you know are using the default password.
# change the password on a test database is
# necessary to get the correct data.
my %defusers = (
CTXSYS = '24ABAB8B06281B4C',
DBSNMP = 'E066D214D5421CCC',
LBACSYS= 'AC9700FD3F1410EB',
MDSYS = '72979A94BAD2AF80',
OAS_PUBLIC = '9300C0977D7DC75E',
OLAPDBA= '1AF71599EDACFB00',
OLAPSYS= '3FB8EF9DB538647C',
ORDPLUGINS = '88A2B2C183431F00',
ORDSYS = '7EFA02EC7EA6B86F',
OUTLN = '4A3BA55E08595C81',
SYS= 'D4C5016086B2DC6A',
SYSTEM = 'D4DF7931AB130E37',
TRACESVR = 'F9DA8977092B7B81',
WEBSYS = 'A97282CE3D94E29E',
WKSYS = '545E13456B7DDEA0'
);
my $MySql=select username, password from dba_users ;
$MySql .= q{ where username in('} . join(q{','}, keys %defusers) . q{')};
#print sql: $MySql\n;
my $sth = $dbh-prepare($MySql);
use vars qw{$rv};
my $rv = $sth-execute || die error with statement $MySql \n;
while( my $hash = $sth-fetchrow_hashref ) {
#print username: $hash-{USERNAME} password: $hash-{PASSWORD}\n;
if ( exists $defusers{$hash-{USERNAME}} ) {
if ( $defusers{$hash-{USERNAME}} eq $hash-{PASSWORD} ) {
printf(Account %-20s is using a default password\n,
$hash-{USERNAME});
}
}
}
$dbh-disconnect;
sub Usage {
my $exitval = shift;
use File::Basename;
my $basename = basename($0);
print qq{
usage: $basename Oracle Default Password Checker
-database ORACLE_SID
-username DBA account
-password account password
use one of the following options
to connect as SYSOPER or SYSDBA
[-sysdba || -sysoper]
};
exit $exitval;
}
James McCann [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/31/02 08:42 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: OPS$ / default accounts
Speaking of default accounts with default passwords, here is my list that
I
check for. Anyone want to compare notes :) i.e. have I missed any?
Thanks,
Jim
perfstat/perfstat
TRACESVR ??? is only used with 7.x Databases
REPADMIN ???
CTXSYS/CTXSYS
DBSNMP/DBSNMP
INTERNAL/ORACLE
MDSYS/MDSYS
MTSSYS/MTSSYS
ORDPLUGINS/ORDPLUGINS
ORDSYS/ORDSYS
OUTLN/OUTLN
SYS/CHANGE_ON_INSTALL
SYSTEM/MANAGER
SCOTT/TIGER
-Original Message-
Kirti
Sent: 31 January 2002 15:25
To: Multiple recipients of list ORACLE-L
Stephane,
Thanks. Yes, we are properly fenced
None of the databases have those default accounts with default passwords.
We do not use OEM and that agent. Passwords of critical accounts get
changed
regularly and often. Database user ids are generated approved by Data
Security group before DBAs can add them to databases (so others do not
know
and can not guess who has what id), and they request reports of access
privileges when least expected.
So, it's all how you manage your set up. When I joined this company I was
going nuts about such things (remote_os_authent, default links by virtue
of
Oracle Names etc), but as I learned the environment I was comfortable..
And
it is helping us more than creating problems and concerns.
Cheers !
- Kirti
-Original Message-
Sent: Thursday, January 31, 2002 2:20 AM
To: Multiple recipients of list ORACLE-L
Deshpande, Kirti wrote
RE: Databases on Solaris: Online Forum Jan. 22-28
Does anyone know if the book is any good? I'm thinking about getting it, Thanks, Jim -Original Message- [EMAIL PROTECTED] Sent: 24 January 2002 23:25 To: Multiple recipients of list ORACLE-L That could have something to do with the questions not being pointed enough. Could be they're pointless? I was going to provide a couple of examples, but it seems there is too much traffic to this site for me to get back on right now. Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/02 01:45 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Databases on Solaris: Online Forum Jan. 22-28 Hmmm...many (most? all?) of the answers given in the forum however, seem to be pointers to chapters in Mr. Packer's book. Just an observation. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, January 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L This list pays for itself once again. Jared is charging the rest of you too, right? Steve -- 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: James McCann 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: Standby Instance questions and HA
Hi, thanks for you advice. Let me see if I've got it straight... So what you are using is purely OS based. No special Oracle software. There is only one node available at a time, and if it fails, then the second one starts up, in roughly the same state as the first (i.e. no uncommitted transactions lost)? But the power of the second node cannot be utilised in conjunction with the first. Is this correct? Thanks, Jim -Original Message- Smith Sent: 18 January 2002 01:46 To: Multiple recipients of list ORACLE-L You will always have the same issues with fail over technology. Your users will get disconnected. My databases take less then 5 minutes to fail over and that is an acceptable time frame to the client. Its great from my standpoint for maintenance cause I can do it on one node, fail the databases over, and bring the other node up to date. I do not have the Oracle software itself in fail over, just the database. We do not find it to hard to work with here. I have no experience with Sun's so I cannot compare them. Whether or not you go with fail over technology all depends on what you are looking for.You will not lose any committed data with HP's (probably not with anyone else's either). Fail over is automatic when configured correctly. I have seen it happen once that I did not even know, it was that quick. Went to go look for my database on the server and it was not there:-) -Original Message- McCann Sent: Thursday, January 17, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Thanks for your help everyone. Very useful advice, although your scaring me of Sun Clusters. At the minute, Parallel server looks the best, with a standby database remotely for disaster. Does anyone know what the HP solution is like (MC Service Guard)? I think some one on this list gave it a good review in the past . Thanks, Jim -Original Message- Sent: 17 January 2002 17:12 To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun clustering working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun cluster at deleted and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in my business. Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross mit schuss Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:40 AM To: Multiple recipients of list ORACLE-L Subject: Standby Instance questions and HA Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware
RE: Standby Instance questions and HA
Hi, thanks for your advice. Data Guard is available for 8i as well I think. I will have to look into what exactly it does, Jim -Original Message- Sent: 17 January 2002 18:51 To: Multiple recipients of list ORACLE-L I also heard of horror stories regarding Sun Clusters. I worked w/ HP MC Service guard, good product. Now working w/ IBM HACMP, also good product, although more complicated to set up (but then again I am not a IBM'er). IBM tends to do everything their way ;). In the future when I upgrade to 9i, I will use Oracle's Data Guard or maybe look at a 3rd party product such as shareplex (good reviews, but pricey). Gene [EMAIL PROTECTED] 01/17/02 01:05PM Thanks for your help everyone. Very useful advice, although your scaring me of Sun Clusters. At the minute, Parallel server looks the best, with a standby database remotely for disaster. Does anyone know what the HP solution is like (MC Service Guard)? I think some one on this list gave it a good review in the past . Thanks, Jim -Original Message- Sent: 17 January 2002 17:12 To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun clustering working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun cluster at deleted and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in my business. Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross mit schuss Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:40 AM To: Multiple recipients of list ORACLE-L Subject: Standby Instance questions and HA Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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
Standby Instance questions and HA
Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Standby Instance questions and HA
I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. James McCann james@openet-teTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] lecom.com cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: James McCann 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: Standby Instance questions and HA
Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun cluster at deleted and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in my business. Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross mit schuss Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:40 AM To: Multiple recipients of list ORACLE-L Subject: Standby Instance questions and HA Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Baker, Barbara 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: Mohan, Ross 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
RE: Virtual Private Databases
As far as I know, it only comes with Enterprise or Personal, Jim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: 15 January 2002 13:55To: Multiple recipients of list ORACLE-LSubject: RE: Virtual Private DatabasesInteresting . partitioning does not appear to be available on the 8i Standard Edition we installed. Regards,Gary NorwellSenior Systems AnalystHybrid Turkeys__ Copy that.We had the same problem with partitioning.We started to use it without any problems.Then we found out it was a payable option (we paid).Your oracle rep will probably ask you to upgrade to oracle EE if you use it.Yechiel Adar, Mehish Computer Services[EMAIL PROTECTED]
RE: Any other OCP discount code ? S36 code can no longer be used
Cheers, that should save a few pounds. I actually decided to stop being lazy and looked it up myself, Thanks, JIm -Original Message- Ling Catherine (CSC) Sent: 12 January 2002 01:00 To: Multiple recipients of list ORACLE-L used Hi Jim, I use OTN20. 20% discount. Regds, New Bee -Original Message- From: James McCann [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 6:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Any other OCP discount code ? S36 code can no longer be used Hi, could you pass it on to me please, Thanks, Jim -Original Message- Ling Catherine (CSC) Sent: 11 January 2002 06:25 To: Multiple recipients of list ORACLE-L used Dear All, I've found the discount code. Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Friday, January 11, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Subject:Any other OCP discount code ? S36 code can no longer be used Dear Gurus, The education discount code S36 can no longer be used to get 20% discount from the OCP Test. Does anyone know of any discount code ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: CHAN Chor Ling Catherine (CSC) 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: James McCann 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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: How to Trace PL/SQL
Use DBMS_PROFILER. It might have what your looking for, Jim -Original Message- Sent: 07 January 2002 20:11 To: Multiple recipients of list ORACLE-L Is there a way to trace the SQL executed by a PL/SQL program (i.e. stored procedure)? Using DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION... does not seem to work when the session is calling a stored procedure. I'm running 8.1.7.2 on Solaris 2.8. Thanks. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter 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: James McCann 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: Reversing Unused Setting on a Column
, 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: James McCann 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).
