RE: 2G trace files - solved...sort of
Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Weird ORA-00060 (deadlock) with pragma autonomous
What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman repository db when an rman resync was run. I've patched to 9.2.0.4 and the error has gone away. ...JIM... [EMAIL PROTECTED] 9/8/03 11:09:27 PM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James PEARSON INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LINUX instance startup problem
Most modern versions of linux have shared memory/semaphore parameters set high enough that oracle can start (unless, of course, you have an exceptionally large SGA). (Note 187397.1) If this is a fresh install (in particular a download from OTN) of 8.1.7, locate the glibc-2.1.3-stubs.tar.gz patch from Oracle. (http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html). There is also a good document entitled: Oracle RDBMS OTN Downloads: Files, Sizes and Directions (Note 209555.1) -- James Seema Singh wrote: Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: APPS 11i (Linux) question
Senthil Kumar D wrote: Hi Group, I'm installing apps 11.5.8 on Linux 8. Rapidwiz , first unzipping some 55 components. After 54th component is hanging and the unzip process is getting defunct. Anybody faced the same issue during the installation. Any help on this Reg. Thanks, Senthil. Yes. Basically, rapidwiz has decided that your unzip process has taken too long and killed it. So, you have two choices: 1. (This is the preferred choice) Download the newest version of the RapidWiz. The problem you are facing exists in the RapidWiz that ships on the media (and in the one that immediately followed it). It should be corrected in the newest release of RapidWiz. 2. (This can be somewhat confusing) Identify which files did not unzip completely (by culling through the log files) and unzip them manually. Personally, it's just alot easier to download the latest version of RapidWiz (The version of RapidWiz on the media is _ALWAYS_ out of date). As of today (19 June, 2003) the latest patch for RapidWiz is 2981384 (159M - Generic Platform) and contains RapidWiz version 11.5.8.18. You can determine your current version of RapidWiz by running the RapidWizVersion command. -- James = James J. Morrow mailto:[EMAIL PROTECTED] Senior Technical Consultant Nascent Systems Dallas, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java.sql.SQLException: ORA-21243896
DBA's, Has anyone ever seen this: 15:37:19 06/11 [DBUG] [ConnectionPoolC] SvcsConnectionFinished Reading properties horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection SQLException occured while while creating pool for horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection java.sql.SQLException: ORA-21243896: Message 21243896 not found; product=RDBMS; facility=ORA IRIX64 Error: 67108868: Unknown system error This is from the connection pool log in BEA, it show up when re-deploying the application from BEA??? TAI ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test delete
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Interesting lesson on ARCHIVELOG mode
Some of you on the list might find this interesting. I just wanted to relate a story with respect to an incident experienced in the last few days on one of our test databases. Environment is Compaq Tru64 Unix / Oracle 8.1.7.4. A few days ago, I remember talking to a junior DBA who assists me in the Oracle area, concerning excessive space usage on one of the Unix machines running a test database environment. I noted that the database was running in ARCHIVELOG mode with automatic archiving (of course), and generating a great many archived logs since there was considerable activity on that instance/database. We discussed the matter and agreed that there was no need to have ARCHIVELOG mode turned on in this case. So I told my assistant DBA to go ahead and make the database NOARCHIVELOG, which I thought she understood. Yesterday, she comes to me with a host of problems she has been experiencing on that test database, one of which was many failed attempts to import a 2 Million row table from another database's export. It seemed that the import would just hang after importing about 130,000 rows. She repeatedly cancelled the import, resorted to cycling the database, creating a another table with just a subset of the columns of the original, limiting the number of rows imported at one time, fooling with the buffer parameters of the import control file, trying SQL*LOADER, and so on. Quite frustrated, she came to me for advice. I had forgotten about the ARCHIVELOG mode issue a few days earlier, so I began scratching my head as I looked unsuccessfully for signs of trouble in alert logs and traces. I thought maybe a rollback segment had run out of room, lost its brains, or maybe temp space had become a problem. But again, no sign of any of these issues in alerts or traces. Suspecting database corruption, I took a full export to see if export would report any corrupted blocks. That worked flawlessly. I began to wonder if we should just start from scratch and recreate the database. Then something interesting became apparant. Looking at V$DATABASE, I noticed that the database was still in ARCHIVELOG mode! When I asked about this, it seems that she thought that simply commenting out the init.ora parameters: log_archive_start=true log_archive_dest=whatever log_archive_format=whatever and then recycling the database would take care of the whole issue of ARCHIVELOG mode, making the database become NOARCHIVELOG mode. Well, guess what.it didn't. The lesson learned was that with the database still in ARCHIVELOG mode and automatic archiving turned off, obviously enough DML would cause the database to hang whenever it did a log switch, awaiting us DBAs to manually archive the filled redo logs. Realizing this, of course we then did the prudent thing: alter database noarchivelog and lived happily ever after. Had I continued to assume database corruption and just had her recreate the database, it WOULD have indeed solved the problem BUT ONLY because the database would have come up in NOARCHIVELOG mode. However, it certainly would have bothered me as to why the database had become corrupted in the first place. I am very happy to know what actually happened, that the database wasn't corrupted at all. It was just someone's misunderstanding in not realizing that ARCHIVELOG mode and automatic archiving are two related but totally different things! Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle position on hints 9.2.0.X
After spending 2 ½ days trying hints, init parameters, re-writing the query, a completely useless TAR, etc. to get a query that runs in 1 second on 8.1.6.X to go faster than 1 minute on 9.2.0.2 I found a new to 9.2.0.X dynamic init parameter optimizer_dynamic_sampling, if I understand it correctly this parameter forces the optimizer to try harder to get an efficient execution plan. Check the FM there are some interesting things that each level causes the optimizer to do. The default is optimizer_dynamic_sampling=1 I've tried optimizer_dynamic_sampling = 5 7. The query in question has several joins across database links. In 8.1.6 the 10046 trace shows 68 I/O's to the remote database in 9.2.0.2 with optimizer_dynamic_sampling =1 10046 shows 1.4 million I/O's to the remote database. With optimizer_dynamic_sampling = 5 the I/O's are back to 68. Check this parameter it saved us from re-writing a bunch of sql... ...JIM... [EMAIL PROTECTED] 3/11/03 7:33:56 AM Hi, We recently upgraded from 7.3.4 to 8.7 (management plans on getting to that Y2K problem shortly ;-) We had an SQL statement that really needed a hint in 7.3.4. After upgrading to 8.7, I removed the hint and it runs much faster without it. I spend some of my spare time testing SQL with hints removed now. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Mark Richard [SMTP:[EMAIL PROTECTED] snip 1) You are limiting functionality when the database is upgraded - I have seen several examples where Oracle went from 7 to 8 and noone looks at every SQL statement to reevaluate the validity of every hint. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: POLL: Database to DBA ratio
On the Oracle side there's 2 of us (myself and one other) supporting 20 databases, so that makes us 10:1. However, in addition to this there is also the IBM mainframe/Software AG Adabas side where it is my privilege to support the 5 legacy database environments by myself. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: POLL: Database to DBA ratio
31:1 will be 40:1 by the end of the year. I have a second guy in training as the second DBA. 3:1 oracle app servers 23 24X7 medical databases of one type or annother 8 Dev/Test databases 1 production app server 2 dev/test app servers ...JIM... [EMAIL PROTECTED] 3/11/03 8:59:20 AM I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OS/390 Oracle Client TNS-3506
DBA's We are trying to get an Oracle client running on OS/390 so CICS and (pro*COBOL) can connect to a remote Oracle DB. After install we are trying to run TNSPING as a first step to demonstrate something is working, here is the error: TNS-03506: Failed to create address binding Any help would be appreciated, so far the TAR we have open hasn't produced anything. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? In (my) order of importance: 1. SQL and PL/SQL 2. Whatever shell scripting language your environment supports (sh,ksh,csh,bash on Unix, typically, and the Windows Batch language if your database is on Windows) 3. Whatever language the applications you're supporting are written in. 4. Perl. Learning the local default scripting language for your environment (ksh or Windows Batch) should be extermely high on your list as you can't always be certain that Perl (or whatever your favorite happens to be) will be installed on a given system. If you're maintaining an Oracle Apps Environment, C would be a good one to learn (or at least familiarize yourself with) as even a basic knowledge of C can help you to troubleshoot the compile/link process used so commonly with the Applications. Also, if you don't know it and you work on a unix environment, I suggest you learn the basics of the vi editor. (It's also basically the only one that you can be certain to have). Emacs may be wonderful, but vi is _always_ there... -- James Nascent Systems, Inc. Senior Technical Consultant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Teradata baned from IOUG???
DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry Ellison become immortal? http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Base conversion
to go! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Has anyone ever seen ORA-11928 ???
Stephane, Thanks for the info, an MVS error is interesting??? I'm not on MVS, the source database is V 9.2.0.1 (Solaris), the trigger is updating a V 8.1.7.2 (SGI) db via database link. I may need to increase the DISTRIBUTED_TRANSACTIONS init parameter. It is currently set at 46 and this db gets updated via db link from several other instances. ...JIM... [EMAIL PROTECTED] 1/20/03 3:07:59 PM James Howerton wrote: DBA's We are getting an intermittent ORA-11928 in conjunction with ORA-2063 and ORA-4088 during a batch load that runs every 5 minutes. (See below) It only happens once every few days and at different times. When we re-run the transaction it loads correctly. I also get ORA-11928 in an OEM alert on another database from time to time. The log shows: new connection cannot be established. ora-11928: Message 11928 not found; product=rdbms; facility=ora. However I have never been unable to establish a connection and I get an event cleared the next time OEM checks??? ORA-11928 is not listed in the FM, Metalink, or google. Thoughts anyone. ...JIM... ERROR text... 20030118060618_healthquest_280 java.sql.SQLException: ORA-11928: Message 11928 not found; product=RDBMS; facility=ORA 01/18/2003 06:11:07 ORA-02063: preceding line from ADT_HRZ ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Jim, If you have a look in oraus.msg (the primary source of information for error messages) you will find the following : / 11000 - 11999 Reserved for mvs sql*net errors LU 6.2 strikes again ? I guess that you must be accessing ADT_HRZ through a database link in your trigger. You should have some specific documentation for MVS / SQL*Net somewhere, the error message is likely to be explained into it. You may also find some useful information in sqlnet.log files you may collect here and there. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Has anyone ever seen ORA-11928 ???
DBA's We are getting an intermittent ORA-11928 in conjunction with ORA-2063 and ORA-4088 during a batch load that runs every 5 minutes. (See below) It only happens once every few days and at different times. When we re-run the transaction it loads correctly. I also get ORA-11928 in an OEM alert on another database from time to time. The log shows: new connection cannot be established. ora-11928: Message 11928 not found; product=rdbms; facility=ora. However I have never been unable to establish a connection and I get an event cleared the next time OEM checks??? ORA-11928 is not listed in the FM, Metalink, or google. Thoughts anyone. ...JIM... ERROR text... 20030118060618_healthquest_280 java.sql.SQLException: ORA-11928: Message 11928 not found; product=RDBMS; facility=ORA 01/18/2003 06:11:07 ORA-02063: preceding line from ADT_HRZ ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle DBA Profession hard?
-Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, January 08, 2003 3:13 PM I'm curious. Does everyone here think the IT profession is hard? Does everyone think that being a DBA is harder than say, a teacher, or a sales clerk, or something else? I don't understand the attitude. Or maybe I'm just lucky. The IT field is wide-open for everyobe to find a niche where they are comfortable. And it is certainly a better field than nursing (hours, pay and exposure to multyitude of diseases suck!), teaching (while working with most kids would be fun, the pay is tough and the hard-luck kids are tougher), retail (wanna work in Home-Depot?). Moving the whole ORAWOMAN issue back On Topic and specifically with respect to what Thomas Mercadante brought up, I just couldn't resist answering this question he posed. I was an Electrical Engineer for about 7 years out of school. But you know, in the following 23 years I've been in the IT field, (10 years IBM mainframe technical support, then 4 years Software/AG Adabas DBA, finally the last 6 years adding Oracle DBA to the mix), I've come to absolutely love dealing with the hardware, operating system, and database technical issues that make up the IT profession from my perspective. HOWEVER, there are a number of the people-related unpleasantries that sometimes make the whole thing unbearable. For instance - The IT profession seems to have far more than its share of people who: * Leap out of their seats whenever there is a problem, doing everything in their power to divert blame and resposibility to somebody else or something else - the system, the database, the network, and those whose responsibility it is to take care of those things. It's never THEIR system, their program, their logic, their procedures at fault. * Display a total lack of patience, wanting everything and wanting it done NOW. * Display an arrogance that would rival il Duce (Mussolini). * Strut around like they are some clever genius because they know a few commands from some manual that make a machine do something. (By the way, they like to hide the manual so nobody else can find out what they know.) * Come up with stupid ideas that make no sense for the environment because they read some blurb in a technical journal. * Use the jargon from those journals in such an inane manner while really displaying their total ignorance to those who know what the terms mean. * I could go on and on, but for brevity sake we'll leave it at that. I'm sure you get the picture. And it's these (above) kinds of people who seem to have the time to politic and ingratiate themselves with higher powers and thus end up in the management slots, making technical people's lives miserable. So from my perspective, what could be just one of the most wonderfully logical, organized, rewarding, creative and satifsying professions is more often than not, turned into a stressful nightmare. Who knows, maybe ANY profession can become that way - even being a florist or raising puppies. As for me, I am looking to start backing out of this whole scene and get back into something where the above negatives can be minimized, at least for a while. Jim D. Present Adabas and Oracle DBA - Future something else. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix for oracle dba -- Suggest a book ?
I've found a wonderful resource in the following book: Oracle DBA on Unix and Linux by Michael Wessler http://www.samspublishing.com It covers some of the differences in features between 8i and 9i as well as handling the specifics of administrating Oracle specifically on Unix platforms. Highly recommended (at least by me). Jim Damiano Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle. any such book available ? kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OAS 4.0.8.1 move
Kurt, If the ip address/hostname are not identical on the new box it won't run, you have to re-install it from cd. All of the network configs are hard coded during install and there is no way to change them. I went through this a couple of years ago when the SA changed the ip address to a 10 .10... on a dev box. ...JIM... [EMAIL PROTECTED] 12/18/02 5:43:42 AM I have a 4.0.8.1 Oracle Application Server implementation on a Solaris 2 .6 box that I am trying to move to a new, presumably identical, box. We are moving it by simply copying all of the datafiles from one box to the other. We can not get it to start! If any one can offer a suggestion, it would be appreciated. Our current problem (after issuing owsctl start) is: - Please wait while the command is being processed on host frog ... Starting ORB process... waiting for ORB to be ready... ORB is not responding. Please restart manually... OWS-20214: The OAS processes can not be started, because the CORBA orb processes can not be started. - there is an associated file, oasoorb674.out, which contains: YDUT-1571, ydcnm.c 789: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 YDUT-1571, ydcnm.c 493: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 Init function of module ydn returned an error ERROR: load of module ydn failed - The only differences between the boxes are the IP and the 'name resolution'. The source box uses dns first but the target box resolves names locally first and then uses dns. The nodenames are the same. owsctl start -nodemgr works owsctl status -T works Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG 2003
I paid $85 last year, which was suppose to include a hard copy of Select Magazine, I think I got two one at IOUG and one in the mail. ...JIM... [EMAIL PROTECTED] 11/27/02 1:26:39 PM Dues were $75.00 last year. Weaver, Walt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: IOUG 2003 Speaking of IOUG, did anyone else get a membership renewal email recently? Seems to me the annual dues have gone up significantly this year. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, November 27, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Okay, so I'm trying to get costs for conferences etc so my boss can budget for them. I go to the IOUG site and look at costs for the 2003 conference. I see register online so I click on it. They have it set up for speaker registration already, and ask for the email confirmation code you received. Has anyone on this list, who submitted an abstract, actually RECEIVED a response? Either acceptance or rejection? I haven't. How can you set something up to allow people to register if they don't know which way to register? Sheesh. I can't even register for the University Session I want because I don't know what status I should use when registering. Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The future DBAs?
Arup Nanda wrote: Fellow DBAs and other DBA wannabes, Ever wondered the best path into a DBA career? Microsoft offers a brilliant way. MSN Careers at http://editorial.careers.msn.com/articles/nofuture/ suggests some jobs are effectively dead, like farmers and sewing machine operators and how the experts in that field can progress to the next logical career move. Guess which profession's logical career move is database administrator? See the excerpt from the webpage here in the attachment as a picture. I just couldn't resist posting it here. May be they are referring to SQL Server DBAs? Arup Nanda Apparently this Susan Aaron (the author of the article) didn't even bother to read the job descriptions in her bls.gov links for the Order Clerk and Database Administrator positions. The bls.gov descriptions seem to show absolutely no link between the two positions. Oh, and apparently, all of the secretaries and Word Processors of the industrialized world have been replaced by voice recognition, OCR, or have otherwise been shipped overseas... who knew? (All the execs I know dictate to tape and fed-ex it to a sweatshop deep in outer mongolia... seems it's cheaper and faster...) Makes me feel terribly antiquated for typing things myself... I suppose I should fire up that room full of monkeys at typewriters... never know when you might need to write a Shakespeare play... -- James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle SAN Experiences?
David, You might find one of my whitepapers interesting: Sane SAN is the title. You can get it at: www.scaleabilities.com/whitepapers.shtml www.oaktable.net Also, you will find a paper on integrating solid state disks into a SAN, and whether that makes any sense to real sites or not. Best regards James -- James Morle Author of Scaling Oracle8i: Building Highly Scalable OLTP System Architectures
Re: Solaris vs Windows 2000
Mark Leith wrote: Firstly, can I say that any NT/2K administrator that feels they need to install Microsoft Office (or just Outlook), and feels they need to upgrade the web browser for a production Oracle database system should be shot on site! The same goes for things like IIS (Microsoft's integrated web server) as this again is a known security flaw.. Apache runs just fine on Win2K (Oracle installs it on the windows platform as well). The same also goes for Perl, and I believe Jared is most surely a Perl man! There is also no longer a 4 CPU limit on windows systems. This does of course depend upon the version of the Operating system that you buy, but Win2K Datacentre Server supports up to 16CPUs. (http://www.winntmag.com/Articles/Index.cfm?ArticleID=7597) I'll conceed the 4-cpu limitation is past. However, a search of various hardware vendor sites reveals: DELL: PowerEdge 8450 -- Max 8 Pentium III Xeon CPUs PowerEdge 7150 -- Max 4 Itanium CPUs PowerEdge 6600 -- Max 4 Xeon MP CPUs http://www.dell.com/us/en/biz/products/series_rkopt_perf_servers.htm http://www.dell.com/us/en/biz/products/series_pedge_servers.htm Hewlett-COMPAQard: HP lxr8500 series -- Max 8 Pentium III Xeon CPUs HP rx9610 series -- Max 16 Itanium CPUs http://netserver.hp.com/products/highlights_lxr8500.asp http://www.hp.com/products1/servers/rackoptimized/rx9610/index.html http://www.hp.com/products1/servers/operating/windows.html I'm kinda curious as to why they don't show any Itanium-based servers on the Windows Server page that scale beyond 4 CPUs. IBM: xSeries 360 -- Max 4 Xeon MP CPUs xSeries 440 -- Max 8 Xeon MP CPUs http://www.pc.ibm.com/us/eserver/xseries/ http://www.pc.ibm.com/us/eserver/xseries/x440.html Unisys, however, does make a 32-way box. ES7000 Series -- Max 32 Itanium 2 or Xeon CPUs http://www.unisys.com/products/es7000__servers/index.htm One thing I'm somewhat curious about. How much do you have to pay in terms of M$FT licensing for Win2000 Data Center on a 32-way box? (I can't seem to find published pricing out there... so I'm prone to believe that it may be heavily discountable). I stumbled across the following link a couple of weeks ago Jared, and book-marked it for later reading.. I still haven't managed to read it as yet, so can't comment, but it looks like it applies.. http://www.winface.com/article.html And yes, excellent article. Apart from the other URLs that you have already posted, I haven't seen any decent comparison sites out there. HTH Mark Now, as far as any NT/2000 admin that feels the need to install. Unfortunately, part of the big selling point of Windows as a server platform is that you don't need those expensive unix admins to run it. The theory being that any idiot can administer Windows NT/2000. As a result, many NT/2000 server installations *DO* end up with IIS, Outlook (or at least Outlook Express), Office, and other unnecessary garbage installed on it because the administrators either don't know better or simply don't care. Now, you know as well as I do that: 1) Nobody in their right mind wants any idiot doing it. 2) While any idiot can probably _do_ the job (to some extent) Even Windows takes a skilled administrator to properly setup and maintain. 3) The truly _GOOD_ NT/2000 admins are every bit as hard to find (if not harder because of the size of the talent pool) as a good Unix admin. And are (or at least should be) almost as expensive. -- James SNIP old posting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris vs Windows 2000
Jared -- I tend to agree with your statements. Although, personally, I tend to think that Windows NT/2000/XP is a wholly inappropriate environment for any enterprise database. The general reasons I tend to choose to back my statements: 1. Scalability. (I'm sorry, clustering is an availability solution, not a scalability one. If you can't grow beyond 4 CPUs [Intel's problem more than M$FT's, here] and need to, then an Intel platform is not for you.) 2. Managibility. I can do practically anything I need to on a unix box over a 300bps modem, if necessary. (This omits, of course, inserting media and hitting the power switch... oh, and installing oracle now that they have this java-based installer... fortunately, that's not *that* common of an occurance in ordinary maintenance) 3. Did I mention scalability? Most *nix platforms scale in a much more linear fashion. (i.e. 2 cpu's are more likely to give you double the performance on a RISC-based system than on an x86 based one.) Note: I'm saying only that RISC systems tend to be *more* linear than x86 ones. 4. Supportability. (yeah, I know, not really a word). I've supported Oracle on both (especially Oracle Applications). Personally, unix platforms tend to provide much more useful information when something does go wrong. The standard Microsoft error message of it's broke doesn't really tell me anything useful. 5. Security. How many security flaws have been found in 'doze? And don't even get me started on M$FT Look-out! (otherwise known as a security hole that occasionally delivers mail). It's also nice that *nix platforms are immune to all of the _really_common_ virii that hit the news these days (Melissa, I Love You, etc.). (Not that *nix is truly immune to virii... but the big-bad-ugly-ones you hear about tend to exploit flaws in... hows that again? Right... Windows and Lookout... Although it helps somewhat that the *nix security model tends to compartmentalize things a bit more than windows does [by default]). 6. Do you *really* want all of the overhead of a tightly-coupled GUI on a _server_? Admittedly, Windows 2000 does appear to be far more stable than previous versions. And the NT-derivatives don't tend to crash in a wholesale manner like the Windows/386 derivatives ('95,'98,ME). But, personally, I should _NEVER_ have to reboot a machine to upgrade/patch a web browser. -- James == James J. Morrow Nascent Systems, Inc. Dallas, TX mailto:jmorrow;warthog.com [EMAIL PROTECTED] wrote: Dear List, Believe me, I am not trying to rehash an old topic, start any flame wars, nor look for supporting evidence for my admitted bias toward unix operating systems. Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. This is for an SAP implementation. We are currently running SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget just which server ) As part of our process to upgrade the system to 4.6c and more recent versions of Oracle ( like 8.1.7 ), we are trying to do a comparison of the features, benefits and advantages of using Win2k Server and Solaris. Please don't refer me to such sites as www.kirch.net and www.osdata.com. The information at www.kirch.net is dated and applies to NT, not Win2k. osdata.com is a nice site, but doesn't really offer comparisons, just information on each OS. There is quite a bit of material available at www.microsoft.com. Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ PC Mag has a nice article comparing different platforms for use as a webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp They actually chose IBM running Windows 2000. Windows 2000 is in use here as a server platform for one database that is used as the backend to a rather troublesome application. The Win2k server is running Oracle 8.1.6.2. The database has been bounced 2 or 3 times in the last year. Once was to clear up a strange but non-fatal problem with Oracle. That was back in July, the previous system restart had been in December 2001. Server and database were up without interruption for 7 months. Though I prefer Solaris, I'm having a difficult time coming up with many valid reasons for recommending it over Win2k. A few that I do have: Sun service is superior to Dell service. They've proven this to us. ( We have other Sun machines in house ) Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to go past that I would think we should go with Sun. I don't know about Win2k Advanced Server, as it is a 64 bit platform, and I think the licensing would go up quite a bit. I welcome all objective comparisons of Solaris and Win2k Server, whether your own thoughts, or a link or links to articles you are aware of. Thanks, Jared
RE: services on windows?????
Dear List, I had a situation on a lone Windows/NT system a couple of years ago, where I had installed 8i and was testing a number of facilities prior to going online with an application. Since I wasn't familiar with NT, I played around a bit, the final step of which was to test recovery with a cold backup. So I did a shutdown immediate and took a cold backup of the database (while having left the Oracle services up). Frankly I didn't **purposely** leave the services up because it didn't enter my mind that I had to do so or not. All I know is that when I blew away the existing database control, data, and log files, and restored them with the cold backup for a test of recovery, the database would not start back up. (I didn't note what the specific error messages were because I was in a big hurry at the time and could't mess around with it.) I DO know that I was stunned at this because on UNIX and Netware, I never had such a thing occur. So, I rebuilt the database from scratch, reloaded, and then tried the recovery scenario again. This time I did the shutdown immediate and then shut down the Windows Oracle service for the database before doing the cold backup, took the backup, blew away the existing database, restored the cold backup database files, and restarted the database successfully without incident. Having been in a hurry, maybe originally I did something illogical or idiotic which was the reason for my obtaining the results I did (when in reality it had nothing to do with Window services, I don't know.) I always meant to go back and revisit that whole issue but haven't had the time or inclination I guess. Given what is being said in this discussion, I would like to do so in a methodical manner to see if I can get down to the fact of the matter. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman fun :), nightmare and long
On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and archivelog all delete input is finished. I had problems cloning a database because RMAN back's up the controlfile first and then does the level backup etc. ...JIM... [EMAIL PROTECTED] 10/4/02 8:53:27 AM The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: problems creating a context index
Make sure you're LISTENER and tnsnames.ora have PLSExtProc set-up. I have a separate listener for PLSExtProc: listener.ora LISTENER_PLS = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) SID_LIST_LISTENER_PLS = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /DEV_ORACLE/bin/app/oracle817/product/8.1.7) (PROGRAM = extproc) ) ) tnsnames.ora EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ...JIM... [EMAIL PROTECTED] 9/12/02 9:33:23 AM Hello All; I am being plagued with an error I can't get my hands around when I try to recreate a context index. The index existed previously, but when I tried to sync new data I got an error, then I attempted rebuilding the index from scratch and got the same error (see below). I checked the $ORACLE_HOME/lib directory and found the library that the error indicates as missing. Any help would be greatly appreciated! sql statements executed: call Ctx_Ddl.Drop_stoplist ('my_stoplist') / call Ctx_Ddl.create_stoplist('my_stoplist') / drop index TFNR_DISPLAY_NAME_IDX_C / create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) indextype is ctxsys.context parameters ('stoplist my_stoplist') / error returned: Call completed. Call completed. drop index TFNR_DISPLAY_NAME_IDX_C * ERROR at line 1: ORA-01418: specified index does not exist create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: ConText error: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed: No such file or directory ORA-06512: at CTXSYS.DRUE, line 122 ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 34 ORA-06512: at line 1 Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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 Howerton 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).
upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4
DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct from 8.1.6.x to 9.2.0.1... ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Desperately seeking help in deciphering part of sqlnet
Rick, Are you trying to connect across a firewall? Also can you ping both directions client - server, server - client? Here is what I think is important in you're trace file: nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err: entry ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 nsopen: unable to open transport ...JIM... [EMAIL PROTECTED] 8/19/02 3:18:21 PM Hi, I am getting a ORA-12535 timeout error when connecting to server. I can tnsping Ok. The environment is Oracle 8.1.6 using NET8 on Win NT. Below is what I believe is relevant part of trace file. However I cannot determine cause of error. Any helps is appreciated. Thanks Rick nttbnd2addr: using host IP address: 172.31.2.6 nttbnd2addr: exit nsmal: 420 bytes at 0x1364890 nsmal: 1712 bytes at 0x1370d68 nsopen: opening transport... nttcon: entry nttcon: toc = 1 nttcnp: entry ntvlin: entry ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err: entry ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 nsopen: unable to open transport nsmfr: 1712 bytes at 0x1370d68 nsmfr: 420 bytes at 0x1364890 nsmfr: 196 bytes at 0x136e540 nsmfr: 140 bytes at 0x1372b68 nladtrm: entry nladtrm: exit nioqper: error from nscall nioqper:nr err code: 0 nioqper:ns main err code: 12535 nioqper:ns (2) err code: 12560 nioqper:nt main err code: 505 nioqper:nt (2) err code: 60 nioqper:nt OS err code: 0 niomapnserror: entry niqme: entry niqme: reporting NS-12535 error as ORA-12535 niqme: exit niomapnserror: returning error 12535 niomapnserror: exit niotns: Couldn't connect, returning 12535 niotns: exit -- 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 Howerton 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: RMAN recovery stuck
Dennis, Try this: sql startup mount; sql exit rman target sys/password nocatalog then, run { allocate channel d1 type disk; restore database; recover database until cancel; alter database open resetlogs; } Is you're controlfile coming from the RMAN backup set ora are you copying it from the production box? I discovered the control file is backed-up during an RMAN Level 0 at the beginning of the process before the datafiles, therefore the backed-up control file doesn't know about the backup set being run ( at least this was the case during a database clone attempt). ...JIM... [EMAIL PROTECTED] 8/15/02 6:29:16 PM Oops, I forgot to clarify that I have the production database in archivelog mode, but the recovery database not in archivelog mode. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 15, 2002 5:08 PM To: '[EMAIL PROTECTED]' James I think you may have put your finger on a possible misconception of mine. Here is my situation/understanding. - On production, - Archive logging. - RMAN backup to disk without shutting the database down. - Not using RMAN to backup the archive logs. - Disaster recovery scenario. - This is a burn the server scenario. Imagine the computer room no longer exists. All you have is the backup tape from the offsite storage. No stringent recovery timeframe. If you tell the managers that it will take you a week to recover the data, no big deal. If you tell them you cannot recover the data because you forgot to copy some critical file to tape, that is a big deal. - I would assume that all of you that use RMAN have performed such a test. - My concept was to perform the equivalent of a cold backup/cold recovery. Just recover using the RMAN backup set that was written to disk and subsequently written to tape. - What RMAN commands should I use to perform this recovery? I have made assumptions, but they may not be correct. - I assumed this would be an incomplete recovery since I can't recover to the present time. So I inserted the SET UNTIL TIME command because I think that is how you get RMAN to perform an incomplete recovery. I picked a time just after the end of the RMAN backup. - Do I need any archive logs under this scenario? I can change my production procedure to use RMAN to backup the archive logs if that is what is required. - Do I need the RECOVER DATABASE command? Any ideas would be appreciated. Thanks for everyone's patience while I flail around with this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 15, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Dennis, This is just a wild guess and I'm probably wrong but I saw in you're original post this DB was not in archivelog mode, try putting it in archivelog mode and running the restore again??? ...JIM... [EMAIL PROTECTED] 8/15/02 2:58:31 PM Okay, I implemented everyone's comments and re-executed the RMAN recovery. Here is what I did and the results. 1. Action: Removed alter database open resetlogs from the run statement. Result: No change. 2. Action: Added trace=1 to the allocate channel command. Result: No trace file is produced in udump. 3. Action: Reviewed Note 145624.1 Result: Did not see the solution to my problem. Most of the suggestions seem appropriate to backup rather than recovery jobs. 4. Action: Added log and debug trace statements to rman invocation line. Result: Produced log and trace file. The trace file at the point of the recovery hang contains the following: krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #10 completed immediately RMAN-08523: restoring datafile 6 to /ora05/ams/data0501.dbf krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #11 completed immediately RMAN-08523: restoring datafile 00017 to /ora05/ams/rbs01.dbf krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #12 completed immediately RMAN-08523: restoring datafile 00025 to /ora05/ams/mls_data0401.dbf krmxrpc: xc=5372006336 kpurpc2 returned 3123 krmxrpc: xc=5372006336 starting longrunning RPC #13 to target: DBMS_BACKUP_RESTO RE.RESTOREBACKUPPIECE krmxr: xc=5372006336 started long running rpc krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: callback returned TRUE, skipping sleep krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 1 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 2 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 4 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 8 seconds And the trace continues with this statement. Any suggestions would be appreciated, as are the suggestions to this point. I'm
RE: RMAN recovery stuck
Dennis, This is just a wild guess and I'm probably wrong but I saw in you're original post this DB was not in archivelog mode, try putting it in archivelog mode and running the restore again??? ...JIM... [EMAIL PROTECTED] 8/15/02 2:58:31 PM Okay, I implemented everyone's comments and re-executed the RMAN recovery. Here is what I did and the results. 1. Action: Removed alter database open resetlogs from the run statement. Result: No change. 2. Action: Added trace=1 to the allocate channel command. Result: No trace file is produced in udump. 3. Action: Reviewed Note 145624.1 Result: Did not see the solution to my problem. Most of the suggestions seem appropriate to backup rather than recovery jobs. 4. Action: Added log and debug trace statements to rman invocation line. Result: Produced log and trace file. The trace file at the point of the recovery hang contains the following: krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #10 completed immediately RMAN-08523: restoring datafile 6 to /ora05/ams/data0501.dbf krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #11 completed immediately RMAN-08523: restoring datafile 00017 to /ora05/ams/rbs01.dbf krmxrpc: xc=5372006336 kpurpc2 returned 0 krmxrpc: xc=5372006336 RPC #12 completed immediately RMAN-08523: restoring datafile 00025 to /ora05/ams/mls_data0401.dbf krmxrpc: xc=5372006336 kpurpc2 returned 3123 krmxrpc: xc=5372006336 starting longrunning RPC #13 to target: DBMS_BACKUP_RESTO RE.RESTOREBACKUPPIECE krmxr: xc=5372006336 started long running rpc krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: callback returned TRUE, skipping sleep krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 1 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 2 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 4 seconds krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0, sid=13 krmxr: sleeping for 8 seconds And the trace continues with this statement. Any suggestions would be appreciated, as are the suggestions to this point. I'm about ready to think it is TAR time. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 14, 2002 2:23 PM To: '[EMAIL PROTECTED]' I am trying to perform an RMAN disaster recovery task. While I use an RMAN catalog to make backups, I am trying to recover using just the control file information. Oracle 8.1.6, Compaq/HP Tru64 I start RMAN with rman target sys/password nocatalog then, startup mount run { set until time to_date('08/11/2002 01:00:00','MM/DD/ HH24:MI:SS'); allocate channel d1 type disk; restore database; recover database; alter database open resetlogs; } Everything appears normal for awhile. In the alert log RMAN tries to find each file, doesn't find them. Then it successfully recovers 5 data files (including system and rollback) and reports success in the alert log. Then . . . nothing for hours. RMAN doesn't return an error. The RMAN shadow processes are still present but with no CPU consumption. Nothing is written to the alert log. I check V$SESSION_WAIT, and the only entry for the RMAN shadow processes is one is SQL*Net message to client with seconds_in_wait = 0, state = waited unknown time. In V$SYSTEM_EVENT, time_waited and average_wait are zero for all events. The following events have values of total_waits that are increasing: Increase in total_waits in 10-minutes rdbms ipc message 401 pmon timer 57 control file parallel write 56 SQL*Net message to client24 SQL*Net message from client 24 virtual circuit status5 dispatch timer3 smon timer1 Archiving is turned off. I have attempted this recovery many times using different RMAN backup sets, but the system always hangs at this point. Any ideas would be appreciated. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat
RE: RMAN recovery stuck
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: 20 Instances 1 Machine
Your biggest problem is not going to be physical RAM or disk space (either of those could simply be purchased large enough). However, you *will* encounter a problem with Shared Memory. 32-bit (and even 64-bit) operating systems have a finite amount of shared memory addressable for use by 32-bit applications (namely the RDBMS shipped with the Oracle Applications). This number is 1.7GBytes on HP/UX and, I think, 2GBytes on Solaris. This Shared Memory limitation is systemwide. The Oracle RDBMS uses shared memory heavily for major components of the SGA. As a result, if you're running a 32-bit version of Oracle, this number represents the sum of all SGA's running on that machine at the time. (So, at 500M/instance, you'll run out somewhere between 3 and 4 instances). Possible solutions would be: 1) Use a 64-bit version of the Oracle RDBMS as certified for your platform. A 64-bit version of Oracle would address shared memory from a much larger total pool (most likely an absurdly large number), thus avoiding this 32-bit Shared Memory problem. 2) Consider using something like Sun's System Domains to partition a big box into multiple virtual machines. Each of these Domains would have it's own shared memory pool. 3) Consider using seperate machines. Personally, I'd vote for seperate machines. I tend to prefer only one production system exist on any given host as it tends to eliminate much of the performance-oriented fingerpointing that is bound to come up. Additionally, running a large number of production instances on a single host can be alot like putting all of your eggs into one basket. It may be cheaper, but if something happens to that basket, everything's hosed. As far as hardware: Lots of disk, plenty of I/O channels, and plenty of CPUs. Without actually knowing the nature of your applications, I'd say you're probably looking in the SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). Post, Ethan wrote: I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: 11i installation ???
Leslie Lu wrote: Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie Bear in mind that Oracle Applications 11i has certain dependencies that are specific to the M$FT Windows NT/2000 platform. Most notably: Visual C++ 6.0 and MKS Toolkit (both of which are additional cost items, totalling between $600-$1000). There are several documents on metalink you may want to look at if you've had a failed install (on Windows... similar docs exist for Unix): DocID: 137200.1 Checklist when OUI Fails for Windows DocID: 143976.1 How to clean up a failed install of OA 11.5 on an NT Platform As far as how long the install takes: On Unix, once you've built your staging area, it can take upwards of 2-3 hours to do a full install of the VIS demo instance. Mostly determined by the speed of your system (CPUs/Memory/Disk). On NT, it can take a bit longer. Especially if you factor in the additional time required to install the prerequisites. (MS Visual C++, MKS Toolkit, GNUMake). And, of course, there are at least 5 reboots involved... (More if you're into patching things current...) -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
April Wells wrote: Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the point is... Oracle SUPPORT seems to be of the opinion that rather than trying to figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid solution'. I'm guessing there IS a REASON it is doing this... and that it is only doing it in one of my three financials instances CONSISTENTLY... and NOT the one that was the source of the recent clone. ajw SNIP April -- Yes, this is a valid work-around. And, No, in _my_ opinion, this should not consider the problem solved. There is (obviously) a bug somewhere that is causing the instance to hang when you do a shutdown immediate. That bug should be addressed and/or corrected. I seem to remember a time when some of the conventional wisdom stated that you should ONLY do shutdown abort and NEVER do shutdown immediate. However, when I started digging into the whys of this statement, what I was able to come up with was a bug in a particular release of the Oracle RDBMS on HP/UX (I think it was 7.1.3, but I'm not sure). Interestingly enough, the DBA's I was speaking to that *SWORE* you should never do shutdown immediate were all on HP/UX. So, from my standpoint, (and the stated purpose of each of the shutdown commands), SHUTDOWN IMMEDIATE is the correct shutdown. Abort/Startup/Shutdown Normal *will* work in your situation as a valid work-around. However, the bug should still be investigated and corrected. Have you investigated pro-actively upgrading the RDBMS to a (slightly) more current version? (I'm not suggesting 9i here, but as I recall you're 8.1.7.3. I believe that an 8.1.7.4 exists, just maybe not on AIX). -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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)
%2Fclearstation.etrade.com%2Fcgi-bin%2Fdetails%253FSymbol%253DORCL Seems to show ORCL mostly following NASDAQ. (sorry about the ugly URL) regards, ep | Original Message: | - | From: Tim Gorman Tim@SageLogix=2Ecom | Date: Mon, 15 Jul 2002 13:02:06 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: Re: McCain on Larry Ellison and Corporate Responsibility /=20 | Re: OT - unix | | Nope=2E | | I just thought that people are innocent until proven guilty=2E One=20 | thing about someone in Ellison's position is that it would be=20 | impossible for him to *ever* sell stock without having the unfounded | accusations you've quoted being hurled at him=2E So, are you saying=20 | that it is OK to throw such accusations around, when you don't know | anything about anything? Or is there further substantiation for what | you're saying? Does that mean he should never sell stock? Or should | he just live his life and ignore the critics? | | I respect and admire Sen=2E McCain as much as I respect and admire=20 | anyone, but he is not infallible and he (and his staff) can certainly | be off the mark=2E=2E=2E - Original Message - To: Tim Gorman Tim@SageLogix=2Ecom; ORACLE- L@fatcity=2Ecom Sent: Monday, July 15, 2002 10:49 AM unix Tim, It is my understanding that Oracle's stocks have gone up and down wildly several times=2E As you say, the only time I've heard that Larry Ellison cashed out before a plunge happened was the recent one that McCain brought up=2E I'm afraid I fail to see what you think people should conclude from all that=2E Are you saying that it is ok for stock holding workers and investors to get gigantically screwed just because Larry Ellison has only done it once? SNIP -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Weird Windoze 'AT' Behavior
You may want to check a couple of things: 1. Be careful which editor you use. (Consider locating an old copy of the MS-DOS QEdit shareware program. It's small, and very clean). Or, use the DOS EDIT utility. (If you feel the need for a windows editor, notepad is probably your cleanest choice.) 2. DOS sometimes needs an end-of-file marker (Ctrl-Z). Some things won't recognize the last line without it. 3. Or, if you're a *nix bigot like me, install cygwin (http://www.cygwin.com). You'll get a unix-like cron utility as well as some decent scripting tools... Farnsworth, Dave wrote: I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. Thanks, Dave -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: {9i New Features: Joins}
All, Here is a sample of 9i new features. You all should have a user on DBA9 (moray.hs.uab.edu) to try this out, if not let me know. ...JIM... [EMAIL PROTECTED] 7/15/02 10:48:28 AM Welcome to the latest installment of 9i new features. This will not be all exhaustive but just a sample. Here is the table scripts to build the data for testing purposes. drop table dept; drop table emp; create table dept ( dept_id varchar2(5) not null, dept_name varchar2(50) not null); alter table dept add constraint dept_pk primary key(dept_id); create table emp ( emp_id number(5) not null, emp_name varchar2(50) not null, dept_id varchar2(5) null); alter table emp add constraint emp_pk primary key(emp_id); insert into dept values ('HR','Catbert'); insert into dept values ('PAY','Payroll'); insert into dept values ('IT','Computer Geeks'); insert into dept values ('MANAG','PHB'); insert into dept values ('EXECU','Big Cheeses'); insert into dept values ('SECRE','Secretary Pool'); insert into dept values ('DBAS','Database Admins'); insert into dept values ('SLIME','Slimy Induhviduals'); insert into dept values ('NWORK','Always Blame On'); insert into dept values ('DUH','No Clue People'); insert into emp values(10,'Bubba Jones','EXECU'); insert into emp values(11,'Honcho Man','EXECU'); insert into emp values(12,'Junior','NWORK'); insert into emp values(13,'Help Desk','NWORK'); insert into emp values(14,'Ima Dumb','DUH'); insert into emp values(15,'Dont Be','DUH'); insert into emp values(16,'Bosses Aid','SECRE'); insert into emp values(17,'Doy Doofus','MANAG'); insert into emp values(18,'Keep em Running','DBAS'); insert into emp values(19,'Look at me','SLIME'); insert into emp values(20,'HR Troop','HR'); insert into emp values(21,'Big Pain','USERS'); Ok now we have some test data, lets look at the various joins. In the old days(and we're NOT going to talk about sub queries), we really only had equi-joins and a single outer join. Now we have: 1. Natural join: This is a join between 2 or more tables where the columns names match between the tables, like in our table, the dept_id column is the same name between the dept_name AND the same datatype. OLD: select emp_id, emp_name, dept_name from dept, emp where dept.dept_id = emp.dept_id; NEW: select emp_id, emp_name, dept_name from emp natural join dept; Notice the results we get 11 rows but we have 12 rows in emp. A natural join is an equi-join where you DON'T have to put the join condition in the where clause. There is a bit more to this one, check the using clause also, hint its used if the column names match but maybe the data types don't, etc. 2. Cross join: Your and my favorite, also known as a cartesian join. OLD: select emp_id, emp_name, dept_name from dept, emp; NEW: select emp_id, emp_name, dept_name from dept cross join emp; Useful?, I think thats up for debate :) 3. Outer join: This is where you join two tables and want to see all of the rows even if there is NO match. You could outer join to the left or right but not both at the same time. Now you can do left or right outer and even full outer, examples follow: Left: We want to see all employees even if they dont belong to a dept. OLD: select dept.dept_id, dept.dept_name, emp.emp_id from emp, dept where dept.dept_id(+) = emp.dept_id order by emp_id; NEW: select dept.dept_id, dept.dept_name, emp.emp_id from emp left outer join dept on (emp.dept_id = dept.dept_id) order by emp.emp_id; Right: We want to see all depts even if they dont have employees. OLD: select dept.dept_id, dept.dept_name, emp.emp_id from emp, dept where dept.dept_id = emp.dept_id(+) order by emp_id; NEW: select dept.dept_id, dept.dept_name, emp.emp_id from emp right outer join dept on (dept.dept_id = emp.dept_id) order by emp.emp_id; Full: We want to see all emps with or without being assigned to a dept and all depts with or without employees. OLD: No such single statement quewry exists, you had to do it via 2 queries and a union statement like this: select dept.dept_id, dept.dept_name, emp.emp_id from emp, dept where dept.dept_id = emp.dept_id(+) union select dept.dept_id, dept.dept_name, emp.emp_id from emp, dept where dept.dept_id(+) = emp.dept_id; NEW: select dept.dept_id, dept.dept_name, emp.emp_id from emp full outer join dept on (emp.dept_id = dept.dept_id) order by emp.emp_id; Thats about it for today, all hate email to /dev/null, all good stuff to [EMAIL PROTECTED] Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Oracle on Linux ... Production Strength ???
with Oracle datafiles). If you're not actively using this feature, then changes will get logged and that will tend to encroach on your usable space on the filesystem. 4. As you move towards production. Consider using a completely PRIVATE LAN connection between your Database Server and the NetApp Filer. (Ideally, directly wire using crossover cable, the 100BaseT interface on the Filer to a 100BaseT interface in your Database server. Have a seperate interface for both devices [db server filer] on the public net for regular access. Run *ALL* of the NFS traffic over the PRIVATE network). This way, your [relatively inefficient] NFS traffic won't have to compete with other traffic and the high amount of traffic generated by NFS won't impede your public network. I'd caution against saying well, we're on a switched network anyway because, regardless, the switch will incur additional workload handling that NFS traffic. Extra nics and crossover cable are, in the long run, cheap. Unfortunately, NetApp tries very hard to sell their product into the Oracle space. (sometimes too hard). While their product is amazing at things that NFS (or an NT file server) is good for, personally, I'll take locally-attached disk any day for my Oracle databases. But hey... When the only tool in your toolbox is a hammer, suddenly everything starts to look like a nail. -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: DOS Script for pop up question ?
Bob Robert wrote: All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob Well, the simplest answer would be to use the Pause command. This assumes, of course, that you don't really care what key they press... simply: echo Hit Control-C to abort or... pause Will return: Hit Control-C to abort or... Press any key to continue I'm pretty sure that the DOS batch language doesn't have any get keystroke functionality built-in. However, the CMD language might. A search on google for dos cmd batch get (http://www.google.com/search?sourceid=navclientq=dos+cmd+batch+get) yields this link: http://www.simtel.iif.hu/pub/msdos/batchutl/ Which has a whole slew of MS-DOS based utilities. I'm sure one of them would have a little *.exe that would read a line or a character from stdin. Additionally, you could consider Cygnus for Windows (aka Cygwin) available through redhat.com. Cygwin is a Windows tool that gives you Unix functionality. Including some of the popular unix shells for scripting (Bash, Tcsh). This product (free, as in beer) provides the same functionality as the (much more expensive) MKS Toolkit (available from MKS Software... http://www.mks.com). The MKS toolkit is required for Oracle Applications 11i on MS Windows NT/2000. http://freshmeat.net/projects/cygwin/?topic_id=45%2C74 or http://cygwin.com -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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).
Addit'l DBA Resources needed for Adv Rep/Dist DB?
Greetings all, To this point in time, our organization has pretty much had vanilla Client/Server and Web Apps accessing Oracle RDBMS on Tru64 Unix, Netware, and Windows/NT. However, we are considering future applications which may involve doing Distributed Database and Advanced Replication. In just a high-level sense, what are the implications to the DBA staff? I.E. Would it be not much impact and no big deal, or would it complicate our DBA's lives drastically and by orders of magnitude? Thanks very much for your always valuable insights, JDamiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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).
CA sues Quest Software for code theft
Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product. http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 PROBLEM
you did not install the new runInstaller for 817 so it is using the old version. You have to use the runInstaller from the CD or your install directory. Basically install the new runInstaller and you should be ok. -Original Message- Sent: Tuesday, June 04, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi List, I am still facing with my Upgrade Problem, Today I findout some thing which can be the cause of problem, Just want to check with you guys. I am using runInstaller for installing the patch4 on 8.1.7.0, today I just check the runInstaller and findout that there is a link for runInstaller to my 8.1.6 home directory, I mean I am using runInstaller 8.1.6 for this purpose, Now my question is this could be a problem or NOT, If this is a problem how can I change this link to point to the runInstaller to 8.1.7 instead. Here is more detail 8.1.7 home /u04/app/oracle 8.1.6 home .u01/app/oracle runinstaller under /u04/app/oracle/bin just a link to runinstaller on /u01/app/oui/install Can I just copy runinstaller 8.1.7 to /u01/app/oui/install directory and use the link or not? Thanks for your Help Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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 A 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: Jr.DBA, Mid level DBA, Sr.DBA
I beg to differ. All Real DBA's should be platform independent. (and if that platform comes from M$FT, they should probably be undergoing intense therapy). -- James [EMAIL PROTECTED] wrote: Better run like WIND!! All Real DBA's use HP. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 5/31/2002 11:01 AM AIX? Come on all really senior DBAs work on SUN (ducking and running broken field pattern :) ) --- Freeman, Robert [EMAIL PROTECTED] wrote: A few thoughts... SNIP Really Sr. DBA: Is busy installing the latest version of Oracle on AIX, and SNIP -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: So, What is a 'Production DBA'?
Peter Barnett wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] Much of this may have already been said, but, here's my $0.02 ($0.012 after taxes): Generally, the term Applications DBA (note the plural form of Application there), refers to one who is concerned with the Oracle Applications (or Oracle Financials, or the Oracle Cooperative Applications, or the Oracle E-Business Suite, or whatever they're calling the bundle this week). That said, there is a pretty significant difference between an Applications DBA and a Regular DBA. Mostly, the Applications DBA would tend to do less of the data-modeling and, in some degree, less of the developer-handholding than a Regular DBA. Also, prior to the advent of a simple little trick they decided to give a complex-sounding name server-partitioning, the Regular DBA would probably have been much more familiar with the *newer* features of the RDBMS. (The Oracle Apps being such a behemoth that they generally don't (didn't) make use of many of those features). For example: Roles, Defined referential integrity constraints (relatively new to the Apps), partitioned tables/views, star schemas, replication, etc. Although, like anything, your degree of exposure to these features may somewhat depend on the systems you're supporting/implementing. Now, as to a Production vs. a Development DBA (Development probably being a more appropriate term in most cases). A Production DBA is generally more concerned with the overall availability and stability of the system (Backup/Recovery, Performance [identifying bad code and bashing the developer over the head with it], datafile placement, Failover, etc.). A Development DBA probably has more direct input into the design of the system (Normailzation, ERDs, tuning bad code before it goes into production). The Development DBA also probably has to/gets to deal with the Developers more frequently. So, IMHO, a good Production DBA would more likely have a Systems Administration background. While a good Development DBA would more likely have a Development background. And, a Great DBA should have some of both. -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Financials Client question
Actually, there have been (in the past) several issues where Java-ish things have problems with the Pentium 4 processor. Most notably: Note: 178050.1 Jinitiator will not install on Pentium 4 (IV) systems Note: 145839.1 Oracle Apps 11i not supported on MS Windows NT/2000 with Pentium 4 Note: 136038.1 ALERT: Win NT/2000 - 9iAS v.1.0.2.2.1 Unsupported on Pentium 4 Note: 132884.1 Unable to run Jinitiator 1.1.8.3 on Pentium 4 machines I believe that most of these issues may have been addressed, however, if you are going to have Pentium 4 clients in your environment, I recommend that you make yourself familiar with these issues and test on a few machines before you order the bulk of them. It is my understanding that there may still exist issues with the Pentium 4 chip as it relates to *SERVER* side deployments. (i.e. 9iAS on Win NT/2K and 11i on Win NT/2K servers). So, as always, proceed with caution. If you have doubts/concerns, it is always best to log a TAR and get support to help resolve your fears... -- James Tim Gorman wrote: Maria, The Jinitiator is an applet required by Oracle Developer's Forms Server, mainly for authentication purposes. As an applet, it is extremely sensitive to the version of the browser and Windows, but not so much the hardware. However, for someone to assert that the applet is sensitive to the version of the hardware seems suspect. Despite the proven experience claimed by these folks, I would suggest that they have less-than-perfect powers of observation, reasoning, and deduction. Confusing the importance of hardware components as opposed to software components should not build confidence. They are apparently equating Pentium 3s with one version of Windows and browser and Pentium 4s with another version of Windows and browser, when in fact there is a good deal of overlap that is possible. It would have been more helpful if they had taken the time to examine the software versions rather than the hardware, as the software versions surely matter more. ...they would not happen to be PC resellers, would they? It would explain both their orientation as well as their motivation... :-) You can find a great deal of more relevant information on MetaLink. From the front-page of MetaLink, click on the left-hand navigation button for Product Lifecycle and on that page, click the button for Certification. Then, choose from the drop-down lists to find E-Business Suite and Jinitiator, and finally choose the version of Windows you are using on the client to find the certified, supported versions of the software. The navigation in this section of MetaLink is pretty confusing, but the supported configurations and versions of Jinitiator can be found here... Please note that the type of CPU hardware is never prompted for; it is simply not a criteria. At the very least, these experts (to which your company is outsourcing a critical business function) are sufficiently vague about important technical details that you are quite correct to hesitate before believing any statements they make without some form of corroboration. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 2:18 AM We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the clients must either be Pentium 3s and below or all Pentium 4s. Mixed network of Pentium 3 and 4s will not work. I was told it was because of the JInitiator being invoked from the server. to quote: Let us further clarify that, through our proven installation/setup experience, the Shooman Application works on a network environment of mixed Pentium 3s and earlier computers. As of this writing, we have yet to prove that Shooman works properly in a network of Pentium 3 (or older) workstations mixed with Pentium 4s. However, we have proven that the application works if ALL workstations are Pentium 4s. It therefore follows that, should you purchase the latest Pentium 4 computers, you must issue ALL your Shooman users with this model in order for the system to work properly. (Shooman refers to the Oracle Application residing on a server named Shooman) I am completely ignorant of Oracle Applications as I have 0 experience in managing it. I'd really appreciate your opinion if we are being fooled or not. I am very concerned about this because as we all know PCs become obsolete in months... time will come we will have to change PCs...maybe move on to Pentium 5/6... This can pose a problem for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist
Re:Compressing Export Dumps/WinZip
Patrice, Yes, that's right. On our Tru64 Unix platforms, I was amazed to find that even though I knew the export dump files to be binary files and (what I assumed to be) not only Oracle-extent-compressed, but binary-data-compressed...that in using gzip/gunzip we were achieving compression percentages of up to 50% and even more. Jim Damiano -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, compressed exports can still get 85% compression when zipping them with WinZip. Obviously Oracle compressed=y doesn't mean compress the export file, it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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).
DB Version Ugrade - Thank you
Dear List, First, I wanted to apologize for the redundant postings about the topic DB Version Upgrade with CreateDB/Import Risky???. I sent entries of the text of the message from my home accounts to my account at work and obviously screwed something up, such that it sent each to the LIST as well. Secondly, thank you all for the responses, advice, and ammunition I need to deal with just another needless confrontational issue. I surely hate confrontation, but at least this time I have totally impartial opinions to back my case. Again, THANK YOU all! JDamiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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).
DB Version upgrade with CreateDB/Import Risky???
Hello fellow Oracle DBAs, I really need your opinion on this matter: I routinely do upgrades of Oracle software and databases on all types of systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to time). On one Windows/NT 4 system where I am presently doing an upgrade from a lower version of Oracle 8 to 8.1.7, I am dealing with a particular System Administrator for the NT box who knows a little about Oracle, but that is obviously laboring under some misconceptions. He strongly believes that the ONLY way one should upgrade a database (once the software has been upgraded) is to do a migration (presumably as detailed in the Oracle Migration manual) and he is URGING me to do it this way. On small databases (i.e. less than 10G) where downtime is not an issue, the way I have always done it and the way I intend to do it this case is: (1) Take a full database export under the old version (2) Install the Version 8.1.7 software (3) Recreate from scratch the database under the new software (4) Do a full database import to the new database. For our systems, I as the DBA believe and have found this to be a fully reliable, quick, and clean method and the preferable way to do it, rather than go through the migration procedure. He on the other hand believes that NOT doing it via the migration route is very risky. Without going into a long spiel with him about what an upgrade IS as far as the database itself is concerned (i.e. the data dictionary objects being brought up to the new version), and why the way I intend to do it with a full import is perfectly acceptable to accomplish this, I'd like to just offer this person the opinions of some of you out there in ORACLE-L List Land where the Oracle DBA expertise is highly respected for its stature, I.E. so he doesn't have to believe me. In other words, I don't want to try to convince him against his will..I'd rather have impartial competent experts give him unbiased testimony. Thus I humbly solicit your opinion on this matter. I believe that my above procedure is a simple and fully reliable way of bringing the database up to the new software level..or perhaps it is ***I*** that am laboring under the misconception??? May I please have your take on this. Much appreciate, JDamiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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: One way replication in multimaster environment
Would you be able to send sample of your scripts. Thanks. -Original Message- Sent: Friday, May 03, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Very interesting question. Couple years ago, I had very similar problem: I had one central database, which had to consolidate data from multiple source databases (having identical schemas) in real time with as little delay as possible after transaction occurs on the source database, and at the same time source databases should not be getting data from their piers (or from central database). I looked at the advanced multimaster replication (offered by Oracle) and didn't find a way to use it as a solution to my problem. I ended up designing my own replication process and writing code (triggers and queue for replicated data on the source databases and stored procedures and replicating job on the central database) to support it. Of course, this solution means, that I have to modify replication code (triggers and stored procedures) every time, when there are changes to the database schema (but this does not happen very often), and my solution does not replicate DDL. So, when new release of our product comes out, it includes necessary code to modify source and central database schemas and replication code appropriately. So far, so good: this solution works reliably on multiple installations. Forgot to mention also, that it accounts also for the time intervals, when network between source and destination databases is down, or database on any side of replication is down: replicated data queue on the source databases takes care of these problems. Also, conflict resolution is taken care of by assigning source_id (which is part of PK on each of replicated table) to every replicated record. Also, process of setting up my replication is very simple (it's automated with the scripts, I wrote), so our field engineers are doing it on customer sites without having any knowledge about databases. So, I'd love to see, if someone has a solution, which utilizes replication provided by Oracle, to this pretty common (in my mind, anyway) problem. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 12:18 AM hi experts, In my replicated environment, i have one site (example: site X) that consolidate data from other sites (example : site Y and Z). I'm using multimaster to push transaction from site Y and Z to site X. How can i set - off the replication in site X , cause i dont want site X to push the changes to other sites or to disable row-level replication. any idea ? Thanks -- 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 A 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).
Advice on going about a minor upgrade.
Greetings fellow-DBAs, We have a web application which exists on a Windows/NT 4 box running Oracle Standard Server 8.1.6. A new application to be added to that platform needs Oracle 8.1.7 (They've even specified needing Patch Set 8.1.7.2.1 and ODBC driver 8.01.74.00). I have just ordered the Oracle 8.1.7 Server for Windows NT and would like to ask what you think in terms of direction I should take for the upgrade. Here is my plan: (1) Have the NT System Administrator back up the entire system (2) Take a full export of the existing database Either Option1: (3a) Install Oracle 8.1.7 (4a) Build the database from scratch (5a) Import the full export from #2 Or Option 2: (3b) Deinstall Oracle 8.1.6 (4b) Install Oracle 8.1.7 (5b) Build the database from scratch (6b) Import the full export from #2 Or Option 3: (3c) Install Oracle 8.1.7 (4c) Migrate the existing database. Any pros, cons, or suggestions with respect to what I've laid out here? As always, thank you very much in advance for all the sound advice you've historically offered. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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: 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: EMC Storage Array Issue
One Reply from Oracle Dear Customer, Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1685984 - DBWR TERMINATES WITH ORA-27062 AFTER ONE AIOWAIT TIMEOUT WARNING Password = Platform = Sun SPARC Solaris Product= Oracle Server Version= 8.1.6.3 Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. -Original Message- Sent: Tuesday, April 16, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Do you have any more info on this BUG? I can't find anything that appears close to this on Metaclink. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James A [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: EMC Storage Array Issue We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James A 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: EMC Storage Array Issue
We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -Original Message- Canaan Sent: Monday, April 15, 2002 11:34 AM To: Multiple recipients of list ORACLE-L We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = something not 0) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you correct it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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 A 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: disk subsystem performance question
John, We have the Hitachi 5800 series with RAID 5. The sales guys also said their system is s fast we need not worry about such minor details. Don't believe them!!! Write speed is SLOW. After we added bare drives for redo log files, archive logs, conrtol files it made a dramatic difference in DB performance. Hitachi some Sa's don't want to set up RAID 1+0 because it makes more work for them than a RAID 5 install. HTH ...JIM... [EMAIL PROTECTED] 4/10/02 10:38:26 AM Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor details. I'm having a hard time believing that given our I/O problems on the 7700E. Performance is given a high priority here. What I would like to know is others' experience with disk subsystems - specifically Hitachi but EMC and others as well have you been able to throw the disk in and forget it or have you had success in getting to the dirty details? Have you tested or noticed an improvement with smaller, faster drives in a disk subsystem like the Hitachi or have you traveled that path and found no noticeable improvement? I'm looking for either a) ammunition that my view is correct, or b) I'm wrong and we can get bigger drives which will make Enterprise Planning very happy from a $$$ standpoint because our Hitachi capacity will last longer. We are running Oracle 8.1.7 / AIX 4.3.3 / Peoplesoft Financials version 8. 2 production databases , one 400 GB and the other about 1TB. We've got some other production DBs but these are our big guys. Thanks in advance for any and all input - any help is greatly appreciated. I'd be happy to share any info we have found up to this point and our experiences on the 7700E as well if anyone is interested - despite the fact I will probably bore you to death :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA -- 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 Howerton 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: Rman ... what do YOU need
I agree with Ethan. 1. Please give some good examples for working the various storage management products, Veritas, Tivoli, Legato, etc? I've spent a huge ammount of time trying to get the transport layer working properly. 2. Cloning (I can share the scripts I've used) again I had a lot of difficulty getting this to work with Veritas Netbackup. 3. Anything to enhance business continuity, disaster recovery procedures. Thanks ...JIM... [EMAIL PROTECTED] 4/9/02 1:40:39 PM A section on itegration and best practices with various storage management products. In one case I back up to a Tivoli Storage Management server. Storage group said I would need an addtional product to use TSM with RMAN and that I would still not be able to have some functionality. Never cared enough to try to figure it all out. At the moment I have my own hot backup scripts. Would like to know what else is being done and what the limitations are. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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 Howerton 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: WHICH UNIX FOR ORACLE?
Yes, let's not miss an opportunity to remind Evil Bill of his contribution to the wonderful world of UNIX. Xenix/286... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Boivin, Patrice J Sent: 04 April 2002 21:09 To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? How about XENIX? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 04, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP, it was Windows. Who cares that it's not as stable as I would like. You should have seen the VP grin at me with this patronizing smile when he said, I'll approve $35,000 for this project!, like he had done me a huge favor. I wanted to growl. -- 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: James Morle 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-00600 error
Title: Message Bunyamin, It's bug id 2177050. The bug report talks about temp tables, but that's a red herring really - it happens without temp tables being used. Cheers James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 04 April 2002 09:23To: Multiple recipients of list ORACLE-LSubject: Re: ORA-00600 error Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 9:33 PM Subject: RE: ORA-00600 error Are you running 8.1.7.3? This is a known bug, with a patch available. Regards James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 03 April 2002 18:21To: Multiple recipients of list ORACLE-LSubject: ORA-00600 error Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
DBA's supporting CERNER
DBA's, If there are any DBA's on the list supporting CERNER medical applications please contact me off list. We are in the decision/planning stages of aquiring this product and I would like to get some advise on how much care and feeding this beast requires. Thanks Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Remote DB Installation
First let me say, It *CAN* be done. Given the right set of circumstances. You will need: 1. Some way of displaying X-Windows 2. A telnet or ssh session into the box. In all likelyhood, there will be a firewall involved somewhere, so some form of TCP/IP tunnel (VPN) would probably be required. While you can run X over a wide-area network, it can be rather slow and painful. (And I'm betting the ping-times between the US and Central America probably aren't all that great). So, I'd strongly recommend that you use either VNC (freely available from ATT Labs) or PC/Anywhere to control a PC with X-Windows software (Exceed/Reflection) on it. (VNC and/or PC/Anywyere will make the slow line speed much more bearable). Oh, and obviously, you'll need the proverbial well-trained monkey to load the CD into the drive for you... KENNETH JANUSZ wrote: I have a possible opportunity to install an Oracle DB (8i or 9i) for a company located in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Cronjob misbehaving
Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a) Make sure your script sources the user's .profile or, better yet: b) Adopt a standard by which any script you may want to possibly submit through cron defines the important environment settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.) -- James Simon Waibale wrote: Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh /ops/scripts/recompile.log 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database Objects for specified Shema in FLAG ## Author : C.S Waibale Simon ## Date written : 2002-03-19 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do #j:=1 #$i=${i:-$(crypt flag passwds |awk '{print $j}') #done SQLPLUS=/ops/product/817/bin/sqlplus #Do not export the password variables ! FLAGPASS=${FLAGPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag /usr/scripts/passwds |awk '{print $2}')} WHPASS=${WHPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $3}')} echo Recompiling Invalid Database Objects in the FLAG instance #This can be sustitued with generic code $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql -recompile.log Recompiling Invalid Database Objects in the FLAG instance Message file sp1lang.msb not found Error 6 initializing SQL*Plus Message file sp1lang.msb not found Error 6 initializing SQL*Plus Message file sp1lang.msb not found Error 6 initializing SQL*Plus What could be broken ?? The script runs correctly from comand prompt. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale 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). -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I keep getting a file not found error: RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle=EML_L0-EML- 455497207-2852-1, parms= I'm missing something somewhere??? Origin DB EML on dolphin... Duplicate DB EMLC on cobra... rman RMAN connect target sys/@eml RMAN connect rcvcat rman/@ds8i RMAN connect auxiliary / RMAN the usual file re-definition redo log file descriptions RMAN run { RMAN allocate auxiliary channel t type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1; 5 duplicate target database to EMLC RMAN } RTFM no help Oracle TAR no help Sun ticket - completely useless (we get our Veritas support from Sun [ big mistake]) TIA ..JIM... [EMAIL PROTECTED] 3/6/02 11:53:34 AM I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) [EMAIL PROTECTED] 03/06/02 10:48AM Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts 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 Howerton 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). winmail.dat
Re: Oracle Hungry for Money
Scott, We also have a higher ed site liscense, isn't partitioning included in the Enterprise Edition??? ...JIM... [EMAIL PROTECTED] 3/13/02 1:02:33 PM Watch out! I just got off the phone with our Oracle sales rep. He was asking me if I needed information on Partitioning or OLAP for our data warehouse project. I told him that we are on 8.1.7, so the OLAP option isn't available. To keep him from going into a long speil on Partitioning, I told him that I have already implemented that, which is true. He jumped on that and told me that we aren't licensed for it. He followed up with sending me a quote for $23,800 to cover the fact that we are using the option, which we didn't pay for. I was always told that we have a site license (higher ed), and he said that our license was purchased prior to Partioning being available, so that doesn't count. I'm telling everyone about this as a heads-up. It appears that Oracle is digging for money, and I feel that the approach that was used was done to trick me into admitting that I had implemented the feature. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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 Howerton 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 on Linux articles
I have to strongly disagree with the 'bigger is better' methodology of this article! For example, allowing 100% of the Linux buffer cache to be dirty, then only running a 5 second load pretty much guarantees that very little physical I/O was performed. The author is also misinformed about the workings of the log buffer, and the interaction of Oracle blocksize with the filesystem block size. In some ways, though, I agree with the subtitle: Gladiator-like performance. In this case, the Gladiator runs faster than any man alive, until he reaches the wall of the amphitheater, where he has to stop and be eaten by the lion after all ;-) James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Marin Dimitrov Sent: 12 March 2002 12:33 To: Multiple recipients of list ORACLE-L Subject: Oracle on Linux articles Linux Maximus, Part 1: Gladiator-like Oracle Performance - http://www.linuxjournal.com//article.php?sid= 5840 Linux Maximus, Part 2: the RAW Facts on Filesystems - http://www.linuxjournal.com/article.php?sid=5841 (the discussions after the articles are quite interesting too) hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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 on Linux articles
Hi Steve, The author is also misinformed about the workings of the log buffer, and the interaction of Oracle blocksize with the filesystem block size. I didn't see any discussion of this in the article. ? This is two separate issues: a) log buffer - this was discussed insofar as 'open it up really big', and b) block sizes - this was implied from his not understanding the reasons for the larger block sizes not making a bigger difference. Could you briefly explain your understanding of the workings of the log buffer and the interaction of Oracle blocksize and filesystem block size? Yes, no problem: Log buffer: The log buffer flushes under certain conditions; an explicit commit, buffer 1/3 full, or every 3 seconds if one of the former conditions has not occurred. In the case of the online transaction, the former case will have always been true for a TPC-C transaction. For the load, either the former or secondary condition will have always been true, depending upon the loading code. At no point in the article did the author suggest a rationale for any of the tuning actions, and this was a classic example. A useful datapoint at this stage would have been how long the sessions were waiting for space in the buffer compared to log file switching time, compared to physical I/O time. I would suggest that a far more significant gain in performance would have been gained from much bigger log files, and a relatively small log buffer. Oracle blocksize vs FS blocksize: The author noted a large improvement going from 2KB to 4KB blocks. He fails to mention that the block size of the filesystem (assuming default ext2) is 4KB. This is far more significant, both from the standpoint of 2KB-4KB and 4KB-8KB Oracle blocksizes. In the 2-4 case, the system was issuing twice as many system calls under 2KB blocks for the same number of physical reads as the $KB case. In the 4-8 case, the system was having to break open each I/O call into two physical reads/writes, because the filesystem block size is the only unit of I/O. So, if the filesystem had a blocksize of 8KB, the gain at 8KB would have been more significant. All this discussion completely ignores the other efficiency gains with larger blocks, especially inside Oracle. Without seeing any Oracle wait events (again), it's all pure speculation as to where the real bottlenecks moved to! Really, the thing that went against the grain was the 'tuning in a vacuum' approach of the author. It's so unnecessary to do when there is so much instrumentation available. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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).
Re: lights?
There is something similar in Kansas City, MO. A church designed by Frank Lloyd Wright (on the Plaza) has a shaft of light projecting straight up from the roof. The shaft of light was part of the original design by FLW. However, at the time, the lights required to achieve the intensity and coherency required by the design would have weighed too much for the roof to support. About 10 years ago, they finally implemented the design using high-intensity halogens (which, of course, weigh significantly less). http://www.geocities.com/CollegePark/Campus/5886/ccc3.jpg [EMAIL PROTECTED] wrote: Rachel, From what I heard on NPR, they need to avoid blinding pilots and distracting migratory birds with the lights. It was rather awesome on tv. Please let us know how it looks in person. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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 on Linux articles
Hi Steve. I also see your point, of course, and it's often a fine line to tread. However, if making something well tuned were a simple case of plugging in numbers, it would already be configured that way. Of course, some defaults are plain silly! The reality is, and the point behind my objections, that calling this 'low hanging fruit' deceives the reader into not using his/her brain. For example, it's not high-ROI to tune a system (as I believe this system was tuned) to run for a *short period* like greased lightning. Here's my nutshell description of 'Tuning': Tuning is about avoiding unnecessary work. Think about it for a second. If work has to be done, you can't rob Peter to pay Paul... The work has to be done in the end. It's just a case of minimizing the cost of getting the necessary work done. But your point stands. Chattr +A, for example is a no-brainer (but if anyone has other information, I'd love to hear it). I think there are two actions that are needed to achieve what you're looking for: always-wins, in a list (such as chattr), and a methodology (sorry, I hate that word too) for the other stuff. For sure, there is a no-brainer decision process for this that's just as simple as the always-wins. The danger is unsubstatiated advice. Like not using raw devices - I hope nobody follows that advice without looking very hard at the whys and whats! Glad you liked the book. It would be nice to make a 9i version, but the publisher is 'disappointed with the sales' and isn't interested. Regards James Thanks James. OK, now I see where you're coming from... like the esteemed published author that you are, you're wanting a complete treatise on Oracle database tuning. :-) But my sense was that the article was merely addressing quick and dirty tuning options or low hanging fruit as the author put it. Given that the audience was a Linux forum and not an Oracle DBA forum I believe these tuning efforts were intended to be for a generic Oracle/Linux implementation. Here's a quote from the author, Remember, I said that we'd start by looking at some very high ROI approaches. That means we're looking for items so easy and apparent in terms of applicability and impact that we only need observe the runtime differences in the TPC to see if we're on the right track. The author stated that the default Oracle parameters are useless and started with them as a baseline and gave us benchmarks to prove his point. That's all... nothing more nothing less. Do we need to look at wait events BEFORE changing some default init.ora settings, increasing db_block_size, or using locally managed tablespaces? Is chattr +A *.dbf something we should do on all Linux/Oracle databases using ext3 filesystems? Isn't there a general concensus that Linux kernel 2.4.x performs better? I appreciated seeing benchmarks on the kernel versions. I guess my point is that the default Oracle/Linux configurations are insufficient and there's probably a GOOD list of recommended default settings that are appropriate as a good starting point for 90% of all typical Linux/Oracle implementations. Has anyone published such a list? After starting with a good default installation then it would be nice if we had a public domain benchmarking database with data and TPC benchmarking code. Then someone could walk through a complete tuning effort with all the instrumentation as a teaching exercise on how to identify and remove bottlenecks. With something like this we could actually run the tests ourselves without having to take someone's word for it. Not only that, since nothing remains the same, it could be a good mechanism for quickly testing performance impacts with Oracle and Linux software upgrades and revisions. Sounds like the makings of a new book. ;-) Steve Orr Bozeman, MT BTW, I REALLY like your book. -Original Message- Sent: Tuesday, March 12, 2002 11:00 AM To: Multiple recipients of list ORACLE-L Hi Steve, The author is also misinformed about the workings of the log buffer, and the interaction of Oracle blocksize with the filesystem block size. I didn't see any discussion of this in the article. ? This is two separate issues: a) log buffer - this was discussed insofar as 'open it up really big', and b) block sizes - this was implied from his not understanding the reasons for the larger block sizes not making a bigger difference. Could you briefly explain your understanding of the workings of the log buffer and the interaction of Oracle blocksize and filesystem block size? Yes, no problem: Log buffer: The log buffer flushes under certain conditions; an explicit commit, buffer 1/3 full, or every 3 seconds if one of the former conditions has not occurred. In the case of the online transaction, the former case will have always been true for a TPC-C transaction. For the load, either the former
RE: 817
That should be patch if you got it off Oracle site. The base release is Oracle 8.1.7.0.0. Release 3 is the approved patch which brings you to 8.1.7.3.0. If you want further info search Oracle Metalink. good luck. -Original Message- Sent: Tuesday, March 12, 2002 12:30 PM To: Multiple recipients of list ORACLE-L HI ALL, I WAS LOOKING FOR 817 PATCH3 FOR 817 BUT THE ONLY THING WHICH I FOUND WAS 817 RELEASE3 IS THIS MEAN 8.1.7 PATCH3 OR NOT? I HAVE HEARED FOR UPGRADING FROM 8.1.6 FIRST INSTALL 8.1.7 THEN UPGRADE IT TO PATCH3 BUT I DON'T KNOW WHERE CAN I DOWNLOAD PATCH3. THANKS Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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 A 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 TO 8173
yes should be considerably faster. I am doing this now. You might also think of exporting your database without indexes and rebuilding them after the import is complete. -Original Message- Sent: Friday, March 08, 2002 7:18 PM To: Multiple recipients of list ORACLE-L DEAR LIST, Simple question for upgrading, Is it ok if i install 817 separatley then patch 8173 and finally import the database from 816 to 8173, isn't it faster in this way the database is a small database and no need to link and all other things, any idea???in this case how can i use the same SID name The other question is , then is there any way to uninstall 816? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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 A 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I keep getting a file not found error: RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle=EML_L0-EML- 455497207-2852-1, parms= I'm missing something somewhere??? Origin DB EML on dolphin... Duplicate DB EMLC on cobra... rman RMAN connect target sys/@eml RMAN connect rcvcat rman/@ds8i RMAN connect auxiliary / RMAN the usual file re-definition redo log file descriptions RMAN run { RMAN allocate auxiliary channel t type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1; 5 duplicate target database to EMLC RMAN } RTFM no help Oracle TAR no help Sun ticket - completely useless (we get our Veritas support from Sun [ big mistake]) TIA ...JIM... [EMAIL PROTECTED] 3/6/02 11:53:34 AM I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) [EMAIL PROTECTED] 03/06/02 10:48AM Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts 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 Howerton 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 for Big(ish) Databases
Bill, In general terms, I would say that it is certainly suitable. That answer is based upon the information you provide below. The real answer could only be ascertained by evaluating other requirements: A) Availability B) Scalability C) 'Cost' of each user - what do the transactions look like Don't fall into the trap of treating the machine as a PC - many implementations of Linux/Oracle apply the cost-reduced approach all the way across the system. You save money on the server and OS, but you should still make sure your I/O requirements are well catered for. From a CPU standpoint, you are probably more than OK. A quad Xeon machine has more power than you need in all likelihood (again, APPLICATION DEPENDENT - a single user can suck down 4 Xeons if they want to...). Memory, no problem - 4GB should be more than enough, and Linux is pretty well proven up to this level. The big downsides are thus: A) PCI bus bandwidth. Unless you go for a system with multiple PCI buses (they are available, but I've not personally run Linux on one of these), you are limited to a maximum theoretical bandwidth of width*clock: 33MHz * 32-bit= ~132MB/s, 66MHz*64-bit= 528MB/s. B) Crash Dumps. If you hit an OS problem, who do you go to, and what do you give them? C) Memory bandwidth. RDRAM or at least DDR memory solutions should be used where possible. This is where the P4 is actually worth considering. Forget all the 'extensions' stuff, though - Oracle is pretty much a pure INTEGER compute load. The thing you get that's worth having with the P4 is 400MHz front side bus - Memory Bandwidth! I would recommend, in the complete absence of any real workload knowledge ( ;-) ) to go for a 2-way P4 system based upon the ServerWorks GC-HE chipset. Something like the Dell PowerEdge 4600. This will give you a) memory bandwidth more balanced against the CPU power, b) lots of PCI bandwidth. Hope that is of use. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Buchan Sent: 04 March 2002 10:18 To: Multiple recipients of list ORACLE-L Subject: Linux for Big(ish) Databases We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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 Morle 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: Korn Shell Q
eval foo.sh $FOO Should do the trick... -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Post, Ethan Sent: 06 March 2002 19:23 To: Multiple recipients of list ORACLE-L Subject: RE: Korn Shell Q No that did not work, thanks. I remember the command I am more specifically looking for, it is a command that says to do expansion twice on a line, anyone remember what this is? basically if you have a variable that looks as follows echo $FOO -g dba apps the double quotes will get exanded another time so they are picked up correctly when you call foo.sh $FOO - Ethan -Original Message- Sent: Wednesday, March 06, 2002 12:32 PM To: Multiple recipients of list ORACLE-L Ethan, I had a similar problem when using the getopts command when using it in conjuction with nohup and the . I found by throwing ksh in the syntax everthing worked. i.e. nohup ksh setup.ksh -a parameters This may or may not work for you but it's worth a try. Scott -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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 Morle 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).
Automated Standby Database tool for Unix Linux
March 5, 2002: Relational Database Consultants, Inc. (RDC) - Proudly announces the release of the Standby Wizard For Unix Linux. The Standby Wizard is a GUI interface that automates the creation, maintenance, and fail-over functions of Oracle's standby database paradigm. With the Standby Wizard you can create an unlimited number of exact duplicate databases from your production database. The Standby Wizard also makes a great QA and testing tool with its ability to duplicate even the most complex of databases in only a few minutes. 30-Day evaluations are available for download at: http://www.relationalwizards.com/html/standby_database_download.html __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Forgy 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: replication question
Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
Thanks tons Kevin, that is the information I was looking for. Great, quick response. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question I have used both. Replication, like archive log movement , happens whenever you set it up to happen. That can be anywhere from every minute to once a day to beyond. It just depends on your needs. In the case of my old job, we had replication happeningat different times for different tables. Our key table was replicating IMMEDIATELY uponany changes to the parent table. This happened via trigger.Other , not so important tables, would replicate at anywhere from 30 to 60 minutes. We did this using scheduled jobs. I see two realnice advantages ofreplicated databases. One, they are accessible.i.e. you can run reports, queries, etc on them. They are nothing more than instancesthat get updated via a foreign database. Two,depending on what kind of software you use, you can update the database from an outside source. We used to have data sent down from our DB2 database into our Oracle database using an oracle product called Replication Services (nothing more than triggers and a specific data structure) and an IBM product called Data Propogator. Archive log transport for standbys can happen in multiple ways also. The newer oracle versions support direct archiving from a production database to a standby database. I have not tried this yet but we are looking into it. Our current standby databases are brought up to date with a shell script that is scheduled via cron every 20 minutes. The thing about the standbys, they areall or nothing ... you can not just say I want only tables 1-10 to be updated. They all are. Also, in the older oracle versions, the standbys could not be accessed via software so you could not use them as any sort of read only database. This is not the case in a replicated database. But, they are also very easy to rebuild and resetup. Just copy your production files over, create a standby control file, and bring the databse up in standby mode. Very easy. Now... which would I recommend ??? Depends on your needs. If you really need to access that copy of the database for other purposes and you only want certain tables to be updated, then I would consider replication. If, on the other hand, you do not have to access the data (until such a time as your production gets killed and you need your standby up) and you need a fast way to rebuild the second database, I would suggest the Standby approach. Kevin -Original Message-From: James Ambursley [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K
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: Perf Advice Needed: cache buffers chains, high waits, _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).
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: Old Chestnut: Tablespace Fragmentation
Your best best is to quantify this mathematically. Take the following example: Case 1: 100GB table, one extent Case 2: 100GB table, 1000 extents Assume: a) track to track seeks are 'free' b) random seeks are 20ms c) Block size is 16KB d) db_file_multiblock_read_count=16 e) multiblock read time=8.6ms (29MB/s conservative for 10k drives) f) total # reads=409600 g) one drive only (a very big one...) Case1: Time for FTS= 409600*8.6ms=3522s (~ 1 hour) Case2: Time for FTS= 3522s (as above) PLUS 1000*20ms= 20s - TOTAL=3542s The difference is minor in this case (0.5% greater elapsed time) and 1000 extents would put each at ~100MB in this case. If you had cue Dr. Evil voice 1 million extents, it would be a different story - about 668% longer... Hope that helps - there's an infinite number of shades of grey, so it's important to do the math! Regards James Bill Buchan wrote: I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full table (batch) scan, no concurrent transactions on the database (so no contention for the disk), no fragmentation at the file system level, initially empty buffer cache (startup), read-only operation so DBWR isn't doing anything on this disk. Basically I want to read one data file from end to end. Surely it would make sense to have the disk read moving smoothly from one end of the disk to the other rather than bouncing about all over the place as it may do with multiple extents randomly allocated. Any thoughts? Thanks - Bill. -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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 learning network v Oracle CBT-Select
[Erik Williams] What is OPP? http://otn.oracle.com/partners/oraclepartnerprogram.html -- 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).
itrprof broken?
Does itrprof seem broken for anyone else? trace files I analyzed with it yesterday are failing now, and even tiny files aren't working: 500 Servlet Exception java.lang.OutOfMemoryError no stack trace available Their link for asking questions is 404'd right now: http://www.unal-bilisim.com/qa/discus/ Is there another site that's running that same code or something else that can analyzer Event 10046 trace logs? Daniþment Gazi Ünal: Any ideas? itrprof's been such a wonderful tool, I'd really miss not being able to use it any more :( Thanks!! 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).
Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
db_block_buffers = 360448 db_block_lru_latches = 4 db_block_size = 8192 _db_block_hash_buckets = 720896 Ok, what I have so far is: - using itrprof, I saw that 35% of my elapsed time was based on waits of cache buffers chains latches. - checking v$latch_children (latch#=66), there are a good number (8-10 I'd guess) of the 4096 children that have a very high (10k+) number of sleeps - the rest of the children (of this type latch) have sleep counts are 10-12, so we have a ton of contention on a low # of cache buffers chains latches. - joining with x$bh (v$latch_children.addr=x$bh.hladdr), I see that the most contentioned-for of these latches (51,240 sleeps!) has 66 blocks on the chain. Checking with all_objects, I'm noticing that these blocks are scattered in some of the more important (and most-accessed) tables and indexes - The other latch children that have high sleep counts also have 30-50 buffers in their chains Questions: - to me, 66 seems awfully high - is it? - the sleep count is obviously high from what I can tell - is it definitely tied to the buffer chain this latch is protecting being so long and just happening to be 66 buffers that are mostly important tables and indexes? - I haven't set it by hand, but _db_block_hash_buckets = 720896 and this is 11 * 2^16. Everything I've read says it should be a prime number (and that jives with my comp sci background) - why is it not prime, why is it exactly twice db_block_buffers? - the number of children for cache buffers chains is 4096. Now, increasing that could have a positive effect on distributing the contention, but since the sleps are so heavily skewed to only a few of the children as it stands, I don't get the feeling that's the right fix. Anyone have any advice to offer? Pages/URL's that can help give some advice? It's worth noting that these latches are basically non-existant as wait events at low load - log file sync is about the only wait event I see at low loads, and I'm working on reducing my commit counts much further to help tackle that. Thanks!! 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).
replication setup questions
I am thinking of implementing replication for remote sites. What I have not been able to gather from documentation to date is what are the pre steps required to setup a replicated site(master destination) what are the steps to bring the replicated site online after the master definition site has failed is replicating to remote sites a band-width hog are there any issues creating a replicated site when the main site has RMAN implemented is there a detail step by step document which shows how to create a replication master site including the pre-configuration steps We are using 8.1.7.3 on solaris 2.6. Our database currently generates hundreds of megs of redo because of all the transactions occurring. But the database itself is about 50 gigs. Thanks winmail.dat
RE: Linux Cluster
I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If you have a choice, use FC, preferably switched! Oracle version: 9.0.1.2 Is it fun? I always say - If you really want to learn about how Oracle instances work, run OPS. I don't say that anymore, because they changed the name to RAC. But that's the only change to the saying. I love it though, it's loads of fun, but very much in a masochistic way. In the particular case of Linux, if anyone worked on any big multi-node OPS configurations about ten years ago, you have a good idea of what it's like now on Linux Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Henrik Ekenberg [EMAIL PROTECTED] Sent: 22 February 2002 15:03 To: Multiple recipients of list ORACLE-L Subject: Linux Cluster Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- -- - There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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 Morle 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).
Compare, Merge and replicate between Oracle and MS Access
Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James 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: Compare, Merge and replicate between Oracle and MS Access
The Oracle server is on our internal network, the MS Access is on a server from ISP, which is outside of our network. The cost to eliminate the MS Access, merge all application to our Oracle is too high, so we decide to stay the way it is. It's not real replication, just copy(move) the data from Oracle to MS Access in batch process, but we want to automate the process. -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare, Merge and replicate between Oracle and MS Access Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James 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: Khedr, Waleed 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: Xing, James 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: Compare, Merge and replicate between Oracle and MS Access
Thanks Dennis, link to Oracle in Access through ODBC is one option, actually good idea.., if I can get through the network. the Access and Oracle are on different network. -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare, Merge and replicate between Oracle and MS Access James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single table, single source, etc. Simple is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make deletes faster.
[Bjørn Engsig] You should consider doing a create newtable as select with the oposite conditions as your delete, followed by a truncate/drop, exchange partition or whatever. Delete is really hard against the undo segments. Anyway to lessen that? like nologging on the delete itself, putting the table into nologging during the delete (if that's an option, which it probably isn't), etc? -- 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).
Re: Oracle error ORA-04031
[[EMAIL PROTECTED]] I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large pool,unknown object,sort subheap,sort key) error, and am having a hard time solving the issue. http://www.cryer.co.uk/brian/oracle/ORA04031.htm -- 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).
RE: [Fwd: UNIX Performance Issues]
Title: Message 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, or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 22:11To: James MorleSubject: [Fwd: UNIX Performance Issues]Hi James,I've got no idea whether this is of interest or not to you, but you probably know a bit about this topic.Mogens Original Message Subject: UNIX Performance Issues Date: Thu, 14 Feb 2002 07:43:26 -0800 From: "Rahul Dandekar" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are i n real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic. Thanks, ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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?
Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: [Fwd: UNIX Performance Issues]
Title: Message 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 info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data for capacity planning and proactively anticipating chronic problems. or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. You said it! I want co-relation of Application Load, UNIX System Load and Database Statistics. And not just when the problem arises. So, that's what I am trying to develop. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Orig
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 u
RE: [Fwd: UNIX Performance Issues]
Title: Message Hi Rahul. Interesting, as ever! See below 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 15:49To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Getting interesting, isn't it? I have added my response... - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 8:58 AM Subject: 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. How can I get the current I/O load on the system? I don't know exactly what metric I am looking for. But I want to establish some baseline metric for each machine and then hunt for spikes from the gathered data. The metric can be "I/O load on system bus in Mb/sec" (like the netstat info packets input and output). I don't want individual disk statistics. I just want a overall number, which I can snapshot. I know what you're after, but it's just not going to work that way! A network adapter is a single serial resource with a finite limit. An I/O subsystem is an arbitrarily complex *set* ofresources with a finitecapacity on each! For example, if you were to just measure the aggregate I/O rate across your SAN (or whatever), that may well return a good number. However, one disk in there could be assuming 50% or more of the load due to hotspots. This disk would probably be providing multi-SECOND response time, and because it's the hot disk, will be slowing nearly everything down. Your aggregate stats would not show this. You need per-disk, per-controller, and if you've got a very busy system you might want to start worrying about backplane capacity. There's no easy way to measure that one, however. 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. If I have only one card then why the total and hme0 data are different (by about 10%)? I suspect it is reporting the lo0interface in the total, but not showing it individually. Check out the options for netstat (I don't have Slowlaris in front of me right now). 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! +Rahul 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
RE: Email -- DB (export/parse)
I believe Netscape have a utility to convert Outlook datafiles to 'mbox' format, which is more easily parsed. James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Walter K Sent: 19 February 2002 16:18 To: Multiple recipients of list ORACLE-L Subject: Email -- DB (export/parse) Hi, Does anyone know of a utility that would allow me to export email, from say Outlook or Outlook Express, directly to a database or to a flat file (delimited) for import into a database? It doesn't need to be fancy, basically just date/time, to/from, subject, body. Thanks. -w __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- 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 Morle 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: Fw: Just got back from SQL*Server 2000 training...
See below... Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. I think the real key is that the value of 10GB is quoted as an extreme example! Just affirms my opinion that SQL-Server is where Oracle was over 10 years ago James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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).