RE: Application Server Caching
SAP R/3 has taken advantage of this approach for a long time now. It buffers tables based on settings in the R/3 data dictionary and can buffer single rows, groups of rows, or entire tables. Tables which are used to store configuration information are typically fully buffered, while transactional tables are buffered using either single rows or generic keys. Tables which have high concurrency arent generally buffered at all to prevent inconsistent views of the data from different application servers. All app servers in a given system synchronize their buffers (default every 60 seconds if memory serves); if a buffered row is updated, its marked dirty in the buffer, then the dirty bits are syncd to the other app servers. The first app server to request that row re-validates the buffer. They also handle sequences in a similar way; SAP uses number ranges rather than relying on vendor specific sequences. A number range is just a table of min, max, current numbers basically. For something like sales orders, it doesnt really matter if you skip a few numbers occasionally, so they allow you to buffer these as well, and control how many are buffered. For example, in a system with 2 app servers and a buffer size of 10 with a number range and current number 1000, the first application server will reset the current field in the table to 1010 and allocate 1000-1009 for itself; all requests for a sequence for that number range are answered locally on that app server. The disadvantage to this is that if the app server crashes, you can lose potentially 10 numbers from your sequence, and your sales orders (or whatever youre numbering) can get out of sequence (i.e. not monotonically increasing over time). Generally this isnt a problem, but they do allow you to disable this for each individual number range if you have contractual or legal requirements for doing so. Having directly seen the performance impact of both table and sequence buffering on the application server, I can attest that its very useful. A buffer access on the app server is a micro-second operation, whereas a database access over the network thats served from the DBs buffers is on the order of 10s of milliseconds. One that has to go clear to disk can be in the 100s of milliseconds from the applications point of view. Granted these numbers improve every year with technology, but the idea is that memory is faster than database buffers, which are in turn faster than going clear to disk for something Cheers! Rich -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!Ehttp://www.orafaq.net -- Author: Rich Holland 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: full recovery
Sorry it took so long to get back to you; I've been caching the list for awhile and am just starting to catch up. :-) Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users Beware!' Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > DENNIS WILLIAMS > Sent: Friday, November 07, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: full recovery > > Rich - Could you point to the place where Robert states that bit about > controlfiles to trace? Thanks. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, November 07, 2003 1:59 PM > To: Multiple recipients of list ORACLE-L > > > I believe that an 'alter database backup controlfile to trace' loses the > RMAN data stored in the control files if you're not using a repository (if I > remember right from RF's book). > > Since we're not using a repository, we've got controlfile autobackup on (in > 9i use 'configure controlfile autobackup on'). We dump these disk copies > via filesystem backups as a safety measure. We also do a backup database, > archivelogs, and then control (but all in one step; I'm not sure I'm clear > on the reason for separating them into three backup sets) > > Rich > -- > Rich Holland(913) 645-1950SAP Technical Consultant > print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Mercadante, Thomas F > > Sent: Friday, October 24, 2003 2:35 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: full recovery > > > > > > AK, > > > > First, your normal backup should backup your database in the following > > order: > > > > Database, archivelogs and then control file. I actually do > > this in three > > separate Rman steps. This is so that the most recent control file is > > backups up after all of the data. This allows your to perform an > > incoimplete-recovery-restore to as late a time as possible. > > Also, consider > > adding a database trigger that, upon startup, perform an > > "alter database > > backup controlfile to trace;" Keep a copy of this trace file > > someplace safe > > as a sanity check. You could use it to recreate your > > controlfiles if all > > else fails. > > > > Your recovery steps are as follows: > > > > 1. restore oracle software from tape. > > 2. restore config files ( init.ora , listener. ora ). > > 3. startup instance with nomount. > > 4. run Rman to restore the control file from tape. > > 5. Alter database mount > > 6. run Rman to restore database files > > 7. alter database open resetlogs. > > 8. perform a brand-new Rman backup (database, logs & controlfile) > > > > turn the system back to the users (with many back-pats from > > management). > > > > You should be testing this on a regular basis. > > > > Good Luck! > > > > Tom Mercadante > > Oracle Certified Professional > > > > -Original Message- > > Sent: Friday, October 24, 2003 2:15 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Here is a scenerio : > > I am taking full database backup everynight using rman to tape . which > > includes archive logs and control file. Not using > > catalog.Also have a backup > > of complete file system including oracle software and > > configuration files ( > > init.ora , listener.ora etc.. ) > > I lost the host on a particular day at 12 am afternoon. Now I want to > > restore this db to latest possible time to another host ( > > with same name ) > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rich Holland > 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 H
RE: rman backup
Sorry to respond to such an old thread (man I'm way behind), but what if the "expected" location of the archived logs isn't large enough? For example, let's say we have a 10G archive directory, and we dump 5-10G of logs per day. I have to go to a backup made a week ago. That's 35-70G worth of logs if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it "roll" through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > DENNIS WILLIAMS > Sent: Tuesday, October 28, 2003 3:00 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: rman backup > > AK >When you have RMAN back up archived logs, IIRC, in a recovery RMAN first > restores those archived logs to the location that Oracle will expect them to > be, and I believe that is done as part of the RESTORE DATABASE command. In > my situation, I found no advantage from having RMAN store the archive logs, > so I have no experience there, just what I've read in the manual. > Only RMAN can perform the RESTORE DATABASE command, but once you > complete that command, you can complete the recovery using svrmgrl. From > everything I've seen, RMAN just issues the RECOVER DATABASE command to > svrmgrl or SQL*Plus. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, October 28, 2003 1:15 PM > To: Multiple recipients of list ORACLE-L > > > Thanks Dennis for Reply, > My confusion is , does RMAN sees only those archived logs which are backup > using rman or it can use current archived log as well stored in original > format at other disk ? > > -ak > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, October 28, 2003 10:49 AM > > > > AK - Unless you specify otherwise, RMAN will automatically apply archive > > logs to bring the database up to the time of failure (your recover > database > > statement). This is why it is good to run disaster recovery tests on a > > regular basis, to ensure everything is ready, and you can try different > > recovery times. You will see that RMAN will not complete its recovery if > the > > archived logs are not available. > > > > > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Tuesday, October 28, 2003 11:44 AM > > To: Multiple recipients of list ORACLE-L > > > > > > We take daily rman backup each nite at 10pm . Which means in worst case we > > risk one day of work. Now suppose something wrong goes before 10 pm . > Then > > Can I recover my database till time using previous day rman backup and > > currently available archived logs. > > > > Or in nutshell is it possible to run { restore databse; recover database } > > from rman and then apply remaing archived logs from a separated disk ( not > a > > rman backup ). > > > > Thanks, > > -ak > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: AK > 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). Y
RE: Convert to Locally-Managed Tablespaces
The release specific bits are stored in release specific tablespaces, which are migrated to new tablespaces during the upgrade. You can reclaim the space afterward. For example, upgrading 4.0B to 4.6C will cause a migration of data from PSAPES40BD to PSAPES46CD, among others. Newer releases based on WAS 6.20 and higher use PSAP instead (e.g. PSAPDEV620 or PSAPPRD620 for a DEV or PRD db running 6.20). Upgrades are done the same way, e.g. PSAPDEV620 -> PSAPDEV630 and you can free up PSAPDEV620's segments afterward. Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of DENNIS WILLIAMS > Sent: Tuesday, January 06, 2004 3:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Convert to Locally-Managed Tablespaces > > > Jared - I don't know SAP, but other canned applications have > a "wonderful" > process they put you through every few years called an > upgrade. Often you > end up creating another database and moving the data. This is a great > opportunity for the DBA to fix some issues like this. > However, since SAP is > used by some REALLY large organizations with really, really > large amounts of > data, perhaps SAP uses a different practice. I would like to > know if that is > the case. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Monday, January 05, 2004 8:09 PM > To: Multiple recipients of list ORACLE-L > > > Tanel, > > That's a good idea. I briefly considered this, but > didn't really dig into it. > > The systems I need to do this on is our SAP systems, and > downtime is a precious commodity, especially for production. > > I just may try this on our test system. The problem with > SAP of course, and many other ERP's is that there are 22k+ > tables, which could consume a bit of time. > > The amount of fragmented space that would be recovered is > probably not worth the trouble of this procedure, depending > on how much time it takes. > > I see that you too need to keep the original tablespace names, > is this SAP per chance? > > If you have already performed a test of this, what kind of > times are you seeing, along with relevant platform information, > and the number of tables/indexes? > > Jared > > > On Mon, 2004-01-05 at 16:49, Tanel Poder wrote: > > Hi! > > > > > This is what I will need to use on our systems, as there > are about 400 > gig > > > of data and indexes. 200 gig of data is too large to > export/import, at > > least > > > it is for this project. So dbms_space_admin it will be. > > > > I'm about to do a reorg+conversion of a 250GB 8.1.6 > database in next week, > > here's what I'll do (there is practically no free space for > temporary > > usage): > > > > 1) Export index definitions (normal export with rows=n) > > 2) Drop all indexes > > 3) use alter table move with parallel 16 and nologging to > move all tables > to > > old index tablespaces (the indexes consumed more space than tables) > > 4) drop and recreate data tablespaces > > 5) use alter table move again to move tables back (the > segments have to > > reside in original tablespaces, otherwise I could have > skipped this step) > > 6) drop and recreate index tablespaces > > 7) get index definitions out of exportfile and modify them > to add parallel > & > > nologging (with big sort area size) > > 8) rebuild indexes > > 9) do a full backup > > > > It might help to recreate index tablespaces even before > step 3, to speed > up > > parallel table moving a bit.. > > > > Maybe you want to test this Jared, this approach is much faster than > > export/import, because everything can be done with direct > path operations > > and nologging (import doesn't have direct path facility, so > regular array > > inserts are used, which always require logging as well). > > Also, your tables/datablocks will be optimized after moving > them (which is > > not the case with dbms_space_admin) and you don't have to > have any space > for > > reorg in case your cleared index tablespace can temporarily > accommodate > your > > data. > > > > > IIRC one of the drawbacks of using dbms_space_admin to convert is > > > that you won't be converting to nice unifo
RE: full recovery
I believe that an 'alter database backup controlfile to trace' loses the RMAN data stored in the control files if you're not using a repository (if I remember right from RF's book). Since we're not using a repository, we've got controlfile autobackup on (in 9i use 'configure controlfile autobackup on'). We dump these disk copies via filesystem backups as a safety measure. We also do a backup database, archivelogs, and then control (but all in one step; I'm not sure I'm clear on the reason for separating them into three backup sets) Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mercadante, Thomas F > Sent: Friday, October 24, 2003 2:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: full recovery > > > AK, > > First, your normal backup should backup your database in the following > order: > > Database, archivelogs and then control file. I actually do > this in three > separate Rman steps. This is so that the most recent control file is > backups up after all of the data. This allows your to perform an > incoimplete-recovery-restore to as late a time as possible. > Also, consider > adding a database trigger that, upon startup, perform an > "alter database > backup controlfile to trace;" Keep a copy of this trace file > someplace safe > as a sanity check. You could use it to recreate your > controlfiles if all > else fails. > > Your recovery steps are as follows: > > 1. restore oracle software from tape. > 2. restore config files ( init.ora , listener. ora ). > 3. startup instance with nomount. > 4. run Rman to restore the control file from tape. > 5. Alter database mount > 6. run Rman to restore database files > 7. alter database open resetlogs. > 8. perform a brand-new Rman backup (database, logs & controlfile) > > turn the system back to the users (with many back-pats from > management). > > You should be testing this on a regular basis. > > Good Luck! > > Tom Mercadante > Oracle Certified Professional > > -Original Message- > Sent: Friday, October 24, 2003 2:15 PM > To: Multiple recipients of list ORACLE-L > > > Here is a scenerio : > I am taking full database backup everynight using rman to tape . which > includes archive logs and control file. Not using > catalog.Also have a backup > of complete file system including oracle software and > configuration files ( > init.ora , listener.ora etc.. ) > I lost the host on a particular day at 12 am afternoon. Now I want to > restore this db to latest possible time to another host ( > with same name ) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland 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 and Oracle
"Design and Implementation of the [UNIX || 4.x BSD] Operating System" by [Bach || McCusic et all] Should both have excellent overviews of shared memory, semaphores, and why they're useful. If you want even more nitty gritty, pick up a decent book on pthreads programming and you'll also learn about things like mutex locks, etc. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Veeraraju_Mareddi > Sent: Friday, August 22, 2003 10:19 AM > To: Multiple recipients of list ORACLE-L > Subject: UNIX and Oracle > > > Dear Friends, > > Any good article to explain the above subject, SHARED Memory > & Sema phores on SUN / LINUX for Oracle. I just know what is > shared memory , sema phores are. But never involved > practically much. Please also send me some typical > configurations , with explanation(if possible ) > > Please send me details about ur UNIX production Oracle > systems, and lot of examples. Any good we site with pictorial > information. > > NOTE: This is just for information only. > > Thanks a lot. > Regards > Rajuveera > ** > > This email (including any attachments) is intended for the > sole use of the intended recipient/s and may contain material > that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any > review or reliance by others or copying or distribution or > forwarding of any or all of the contents in this message is > STRICTLY PROHIBITED. If you are not the intended recipient, > please contact the sender by email and delete all copies; > your cooperation in this regard is appreciated. > ** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Veeraraju_Mareddi > 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: Rich Holland 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).
Oracle Utilities book?
Has anyone read this yet? http://tinyurl.com/kis0 It looks like a useful reference, but I thought I'd get other opinions before I purchase it -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!Ehttp://www.orafaq.net -- Author: Rich Holland 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: Export direct=Y|N
I don't know the answer for sure, but can hazard a guess. :-) 65535 is typically the maximum number of bytes that can be written with a single write() system call. If you use a shorter record length, you'll execute multiple write()'s for each 64K of data, which involves multiple trips through kernel land. If you use larger values, you're not buying anything unless it's a multiple of 65535; i.e. if you specify 65536 you'll be back to 2 writes per chunk. Specifying 2x65535 will require the same two writes, and gets 65534 more bytes transferred than the previous example! It's a very small incremental time, but over the course of a 20G export all those round trips between kernel and user space can really add up -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E . about to export SYSTEM's tables via Direct Path ... > EXP-00067: Table DEF$_AQCALL will be exported in conventional path. 24a26 > EXP-00067: Table DEF$_AQERROR will be exported in conventional path. 29a32 > EXP-00067: Table DEF$_LOB will be exported in conventional path. 33a37 > EXP-00067: Table DEF$_TEMP$LOB will be exported in conventional path. 127c131 < . about to export OUTLN's tables via Conventional Path ... --- > . about to export OUTLN's tables via Direct Path ... 130,136c134,140 < . about to export DBSNMP's tables via Conventional Path ... < . about to export OPS$ORACLE's tables via Conventional Path ... < . about to export CW30_AUDITOR97's tables via Conventional Path ... < . about to export CW30_LAC_MANUAL's tables via Conventional Path ... < . about to export DISPUTES2's tables via Conventional Path ... < . about to export DISPUTES3's tables via Conventional Path ... < . about to export BANK's tables via Conventional Path ... --- > . about to export DBSNMP's tables via Direct Path ... > . about to export OPS$ORACLE's tables via Direct Path ... > . about to export CW30_AUDITOR97's tables via Direct Path ... > . about to export CW30_LAC_MANUAL's tables via Direct Path ... > . about to export DISPUTES2's tables via Direct Path ... > . about to export DISPUTES3's tables via Direct Path ... > . about to export BANK's tables via Direct Path ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland 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: Do Not Call
I think the backend is probably just /dev/null. It's much faster than Oracle, and requires a lot less space to store those 10,000,000 phone numbers! Besides, then they don't have any pesky follow-up issues. "You registered? Sorry, we don't have a record of that... Please register again..." -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!Ehttp://www.orafaq.net -- Author: Rich Holland 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: LISTENER ON LINUX
Try 'lsof -i |egrep "(TCP|UDP)" to see what's got the address bound. Lsof is a freely available tool that should be installed on all unix boxes, IMHO. :-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Seema Singh > Sent: Wednesday, July 02, 2003 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: LISTENER ON LINUX > > > Hi, > When I am trying to start listener on Linux box ,getting error > TNS-12542: TNS:address already in use > TNS-12560: TNS:protocol adapter error > TNS-00512: Address already in use >Linux Error: 98: Address already in use > I checked no process fro listener and no port used by another > process. Let me know how to fix that pl thx -Seema > > _ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Seema Singh > 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: Rich Holland 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: oraInst.loc question
Title: Message Thanks for the response April. I ended up just hacking Opatch to auto-configure the oraInst.loc files based on which instance of Opatch is being called. Suboptimal still, but better than having to (remember to) manually move 'em myself. I'd forget to tie my shoes in the morning if I didn't trip over the laces. :-) --Rich Holland (913) 645-1950 SAP Technical Consultantprint unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent: Wednesday, June 04, 2003 2:23 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oraInst.loc question We have one oraInst.loc file for each individual set of binaries (two on production, three in development/test) and every time we patch/upgrade/install we rename the oraInst.loc file to whatever we are working on. Not an optimal solution, but the only one I really have found so far. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Rich Holland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 04, 2003 1:01 PM To: Multiple recipients of list ORACLE-L Subject: oraInst.loc question I have two Oracle installations on the same host. Between installs I updated /etc/oraInst.loc and /var/opt/oracle/oraInst.loc accordingly so that I have two inventory directoies, one per installation. My question is that /etc/oratab has a facility for multiple installations via ':<$ORACLE_HOME path>:N' entries, but the oraInst.loc appears to be for a single installation. Now in order to apply patches and such, I have to modify /etc/oraInst.loc every time (it appears Opatch is ignoring the /var/opt/oracle version). Has anyone found an easy way to use multiple oraInst.loc files or to use a single oraInst.loc file for multiple inventories? I'm strongly considering hiding opatch and replacing it with a wrapper script that rewrites the oraInst.loc files prior to calling the 'real' opatch executable, but thought I'd see if there's an easier way first. :-) Thanks! Rich Holland SAP Technical Consultant Guidance Technologies, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Those installing Oracle 9i on AIX 5.2L
Title: Message Interestingly, IBM doesn't seem to come with any decent man pages. It's not just your SA's this time! I installed every single man page package from all 5 of the 5L CD's and can get man pages for most system commands, nothing C-programming related, etc. It's random enough that I type "man foo" and then google for "foo aix" to find the answer. IBM has always been "different" about including online documentation. When I started with AIXen (back in the 3.1 days) they included the InfoExplorer CD-ROM which required specific software to view it. You couldn't just insert it into any old CD-ROM drive on another system and read it. That's fine if you have dozens of AIXen around. At the time, I had a single IBM server that hosted all the department's XTerms. When it went down, there was no paper documentation -- it was all on that confounded CD-ROM that we coudn't read on a PC or Sun workstation! :( At least now they're HTMLifying it all, but they still insist on being "different" and not including nroff man pages. *sigh* I think that's my BIGGEST complaint about AIX ("Ain't Unix")... --Rich Holland [EMAIL PROTECTED] SAP Technical Consultantprint unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent: Wednesday, June 04, 2003 5:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Those installing Oracle 9i on AIX 5.2L We don't GET access to man pages here... they take up too much space... so does the C compiler. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 04, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Those installing Oracle 9i on AIX 5.2L As root, from other session, you can run 'slibclean' (check the man pages for more info). Then there is no need to rename/remove so *.so library files. - Kirti --- April Wells <[EMAIL PROTECTED]> wrote: > > I got several "can't write to .so" errors... but renaming > those files allowed it to finish... and I always get those errors. > > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > > You will recognize your own path when you come upon it, because you will > suddenly have all the energy and imagination you will ever need. > > ~ Jerry Gillies ~ > > -Original Message- > Sent: Wednesday, June 04, 2003 1:51 PM > To: Multiple recipients of list ORACLE-L > > > Raj, > > On more thing to remember. If you are going to apply the 9.2.0.3 patchset, > be sure to pick the 5L version, not the RS6000 version of the patchset to > download. If you pick the wrong one, it will be full of errors. If you > pick the 5L version, it installed for me without error. > > Ruth > > - Original Message - > To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> > Sent: Monday, June 02, 2003 8:39 AM > > > Hi all, > > If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you > have a list of APARS that _must_ be installed? > > I am talking about regatta (p690) servers if that matters ... > > Thanks in advance > Raj > > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain prop
RE: Those installing Oracle 9i on AIX 5.2L
The APARs I have listed for my 9.2.0.2 install on pSeries is: maint level 02 or greater (oslevel -r) IY22854 IY26778 IY28766 IY28949 IY29965 IY30150 IY34248(bad memory leak in bos.perf.libperfstat < 5.1.0.35) IY22844(??? we installed it for SAP; see OSS note 514798 if you run R/3) IY19744(security - xntpd buffer overflow) IY23041(security - lpd buffer overflow) If you install ML 04 it'll include these automagically for you. I think that's IY44478, but search the APARs for "Maintenance" and it should jump right out at you -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!Ehttp://www.orafaq.net -- Author: Rich Holland 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).
oraInst.loc question
I have two Oracle installations on the same host. Between installs I updated /etc/oraInst.loc and /var/opt/oracle/oraInst.loc accordingly so that I have two inventory directoies, one per installation. My question is that /etc/oratab has a facility for multiple installations via ':<$ORACLE_HOME path>:N' entries, but the oraInst.loc appears to be for a single installation. Now in order to apply patches and such, I have to modify /etc/oraInst.loc every time (it appears Opatch is ignoring the /var/opt/oracle version). Has anyone found an easy way to use multiple oraInst.loc files or to use a single oraInst.loc file for multiple inventories? I'm strongly considering hiding opatch and replacing it with a wrapper script that rewrites the oraInst.loc files prior to calling the 'real' opatch executable, but thought I'd see if there's an easier way first. :-) Thanks! Rich Holland SAP Technical Consultant Guidance Technologies, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland 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: AIX 5L - what is it?
Title: Message 5L is the designation for "Linux affinity". The output of 'oslevel -r' will tell you your release and maintenance level. For example, 5100-02 means you're running AIX 5L 5.1 maint level 02. The reason there are two different downloads is that 64-bit code is OS dependant; 64-bit 4.3.x code is NOT binary compatible with the 5.x 64-bit operating environment. All 32-bit code is compatible. Rich -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vladimir BaracSent: Monday, March 31, 2003 8:58 AMTo: Multiple recipients of list ORACLE-LSubject: AIX 5L - what is it? Hello to everyone I see two options for 9i download at "technet" site - "AIX" and "AIX based 5L systems". What does that difference mean? How do I find out whether server is one or the other? Thanks, Vladimir Barac
RE: Statspack recomendations.
I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Bob Metelsky > Sent: Thursday, January 23, 2003 4:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Statspack recomendations. > > > > > > > Go to bookpool.com. Best prices on tech books. I've ordered > > several books from them and have always been happy. > > > > Yes definetly... But this one > > "Conducting the Oracle Job Interview" > > Is not available at bookpool or amazon... > (personally I like the "buy used" books from amazon) quite a > few deals > there Ive always been reasonably pleased with the service as well. > > Thanks > bob > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bob Metelsky > 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: Rich Holland 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: HPUX SCSI Performance
Title: RE: HPUX SCSI Performance Have you checked the queue depths? There are several parameters your admin can use to tune SCSI performance, but this is typically the first place to start with OLTP systems. You might also look at your buffer cache settings (HP-UX ships with these set at 10-20% I believe; in an Oracle environment, smaller cache often makes sense (anything from 2-10 depending on your I/O patterns). Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of david hill Sent: Wednesday, February 05, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance HPUX 11i version 1.6 for itanium on vxfs -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance What OS? What filesystem? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 05, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: investigating database lockup
Did you happen to dig up the ML note number for Steve? I'd be interested in reading it; I've had some hangs in < 8.1.7.4 systems that I've "fixed" by rebooting. Getting out and slamming all the doors seemed to fix things, but I *HATE* those solutions, never knowing the root cause of the problem Also, if you have any pointers to more info about using oradebug in general, that would be helpful; I haven't ever used this tool, though it sounds incredibly useful. :) Thanks! Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John > Kanagaraj > Sent: Friday, January 31, 2003 8:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: investigating database lockup > > Steve, > > I have seen such a hang occur when there is a lot of untuned buffer-get > intensive SQLs on a 8.1.7.3 database. There is a nasty 'cache chain > buffer' > latch issue in 8.1.7.3. You haven't mentioned the subversion, so you might > consider an upgrade to 8.1.74 if this is true and the situation reoccurs. > I > have also seen severe contention for the shared pool/library cache latches > bring the system to a virtual halt. You mentioned many of the v$ tables, > but > I think you missed out one that can be very useful: V$SESSION_WAIT. A > rollup > of count by event will reveal volumes about what's going on currently. > Steve > Adams has a 'waiters' sql in his site that will also help. You can then > build monitors around such scripts that will alert you before they reach a > threshold. Besides, there is a ML note that can help in determining > apparent > hangs - top among them are the oradebug hanganalyze command.. Let me know > and I can dig up the note number. > > Hth, > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > I don't know what the future holds for me, but I do know who holds my > future! > > ** The opinions and statements above are entirely my own and not those of > my > employer or clients ** > > > -Original Message- > Sent: Thursday, January 30, 2003 11:43 AM > To: Multiple recipients of list ORACLE-L > > > This morning I have experienced a couple of strange lockups of our > database. > The symptoms were the database was nonresponsive to any activity, freeze > on > login to sqlplus, active sessions freeze as soon as they interact with the > db. There is no alert log activity. The systems cpu usage soars to 100%, > and an oracle process, once a shared server and once a dedicated server, > is > dominating the usage(info gathered from top). > > The first time I killed the shared server process, and the database picked > up and operated normally. Then a half hour later the dedicated connection > popped up. The dedicated connection was owned by one of our oltp > processes > that pretty well runs without issue 24/7, so I decided to bounce the db to > hopefully clear up the issue. > > Our system is Oracle 8.1.7 on Solaris 8. In short, I am hoping to get > some > ideas in tracking down what happened. I have some sql scripts that I have > used to identify problem sessions/sql in the past. They focus on > v$session, > v$sess_io, and v$sqltext. Unfortunately, these did me little good because > while the trouble was occurring I couldn't interact with the database > while > the sessions were active. > > I am soliciting actively for any Hints, Tips, or Ideas you may have, > > Thanks, > Steve McClure > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: John Kanagaraj > 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: Rich Holland 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: help meeeee please - related with c 5.1 in aix
You should only need the xlC runtime environment (includes & libs), not the actual compilers. The runtime environment should be shipped on your original installation CD's (email me directly if you need to know which of the 5 AIX cd's it's on and I'll check when I get back to the office). You should be able to do an 'lslpp -l |grep xlC' and see the xlC.rte package as described in the installation. This is not the actual compiler; it's just the linker and libs/headers you need to re-link Oracle, and is free. Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Paulo Gomes > Sent: Friday, February 07, 2003 10:59 AM > To: Multiple recipients of list ORACLE-L > Subject: help me please - related with c 5.1 in aix > > guys, > instalation notes on 9ir2 say tht i have to have c 5.1 on this system. > do you know here i can get it? > or at least how i can install a rpm package in aix? > thanks in advance > Paulo > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Paulo Gomes > 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: Rich Holland 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: JDK directory home
I downloaded 1.4.1_64 from IBM's web site and it worked fine. Interestingly enough, 9.2.0 created /oracle/jre for me as well, where it proceeded to install the 1.3.1 JDK; I blew it away and slime-linked it to the 1.4.1_64 install location (/usr/java I think). Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ehresmann, > David > Sent: Friday, February 14, 2003 6:14 PM > To: Multiple recipients of list ORACLE-L > Subject: JDK directory home > > List, > > When installing 9iRel2 on AIX 5.1L there comes a point when it asks for > the: > > "Choose JDK Directory Home" >"Enter the location of JDK (1.3.1) on your system" > > I have looked through the Oracle install pdfs and the Oracle Release notes > and can not find the directory it is asking for. What is the proper > location? > > thanks, > > David Ehresmann > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ehresmann, David > 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: Rich Holland 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: AIX & Oracle 9.2
All 4.x 32-bit applications run on 5.1 without modification. 4.x 64-bit applications need to be recompiled however; for Oracle this should just be a relink operation. Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Henry, Keith > Sent: Thursday, February 13, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > Subject: AIX & Oracle 9.2 > > > If I have Oracle 9.2 on AIX 4.3.3 and we upgrade to AIX 5.1, do I need to > re-install the Oracle 9.2 software or will it all just work after the > upgrade? Anybody know? > > Keith H. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Henry, Keith > 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: Rich Holland 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: Do user processes apply against shmmax limit?
Also set priority paging on. Priority paging will give application > first priority then free memory will be allocated to file cache( Solaris > 2.6 > and 7. Solaris 8 is set dynamically). > > * ORACLE CONFIGS > set shmsys:shminfo_shmmax =204800 -- increase to 409600 > set shmsys:shminfo_shmmin=1 > set shmsys:shminfo_shmmni=300 > set shmsys:shminfo_shmseg=30 > set semsys:seminfo_semmap=500 > set semsys:seminfo_semmni=200 > set semsys:seminfo_semmns=2000 > set semsys:seminfo_semmsl=1000 > set semsys:seminfo_semmnu=500 > set semsys:seminfo_semume=150 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > 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: Rich Holland 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: 1M STRIPE SIZE BEST?
Ethan, EMC is recommending a 2-cylinder stripe depth now (960KB) which is pretty close to the 1MB that Oracle's SAME (Stripe and Mirror Everything) configuration recommended in the Optimal Storage Configuration Made Easy paper. Other recommendations: - use at least 4-member or 8-member striped metavolumes to distribute load across multiple disk adapters on the back end; don't go above 8 though or you're likely to run into disk queue depth issues - use powerpath to do load balancing on the front end - put redo logs on the first hyper of the physical disk (outer hyper) Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Post, Ethan > Sent: Wednesday, November 20, 2002 5:54 PM > To: Multiple recipients of list ORACLE-L > Subject: 1M STRIPE SIZE BEST? > > A number of papers recommend a stripe size of 1 M (even for EMC) for > volumes > containing data files. I also have the following email from Eyal Aronoff > of > Quest dated Nov 2000. A number of the white papers are more recent. > > > The reasons for a larger stripe size on a non-RAID 5 device are: > 1) Sequential reads are faster if you can take advantege of the read ahead > built into the disk caching > 2) If a 64K read does not start on the first block of the stripe, two > "spindled" are locked for the duration of the read > > However, lately we have been testing some EMC gear and it looks like EMC > have optimized both of those for smaller strip size too. > > The bottom line - I no longer have an opinion one way or another. The > undelying technology just changes too rapidly. > > Eyal > > > Your opinions/comments as far as a "best" practice in setting stripe sizes > would be greatly appreciated. > > Thanks, > Ethan > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > 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: Rich Holland 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: AIX vs Solaris
http://www.google.com/ and search for: vmtune depth queue Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of VIVEK_SHARMA Sent: Wednesday, November 20, 2002 12:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: AIX vs Solaris Could you give Some Detail of Tuning the Depth Queue ? Our Configuration :- Solaris Box Connected to XP512 HP Storage (Hitachi packaged) with VXFS Filesystems Thanks -Original Message- From: Rich Holland [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 17, 2002 7:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AIX vs Solaris John, You should be able to tune the SCSI device queue depth; I’ve done this on HP-UX and Solaris systems, but haven’t had to under AIX yet. I don’t have an AIX system handy to verify this, but I’m 90% sure you can do it. AIX also supports async I/O where HP-UX doesn’t (not sure about Sun), which is a big win in an Oracle environment. Rich Holland Guidance Technologies, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John Shaw Sent: Wednesday, November 13, 2002 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: AIX vs Solaris We had an aix box and ended sending it back and going with sun - only because we had a hitachi san and there seems to be a bug between ibm and hitachi - something about depth queue. >>> [EMAIL PROTECTED] 11/13/02 12:48PM >>> Hello, What are the major differences between AIX and Solaris regarding operating system features? We are planning a new machine purchase; currently we are on a Sun machine running Solaris, but IBM is making a strong proposal to management (meaning significantly less cost), and we are wondering what would need to be changed. We use korn shell scripts extensively, and features such as crontab, background processing, the sqlplus < sure what this is called). I'm fairly sure these are standard in most flavors of unix, but I have never had contact with AIX. Does anyone know what features differ between the two OS's? If we went with Solaris, we would go with Solaris 9 running Oracle 9.2 on a Sun 4800. Thanks for any responders. -- 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).
RE: AIX vs Solaris
John, You should be able to tune the SCSI device queue depth; I’ve done this on HP-UX and Solaris systems, but haven’t had to under AIX yet. I don’t have an AIX system handy to verify this, but I’m 90% sure you can do it. AIX also supports async I/O where HP-UX doesn’t (not sure about Sun), which is a big win in an Oracle environment. Rich Holland Guidance Technologies, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John Shaw Sent: Wednesday, November 13, 2002 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: AIX vs Solaris We had an aix box and ended sending it back and going with sun - only because we had a hitachi san and there seems to be a bug between ibm and hitachi - something about depth queue. >>> [EMAIL PROTECTED] 11/13/02 12:48PM >>> Hello, What are the major differences between AIX and Solaris regarding operating system features? We are planning a new machine purchase; currently we are on a Sun machine running Solaris, but IBM is making a strong proposal to management (meaning significantly less cost), and we are wondering what would need to be changed. We use korn shell scripts extensively, and features such as crontab, background processing, the sqlplus < sure what this is called). I'm fairly sure these are standard in most flavors of unix, but I have never had contact with AIX. Does anyone know what features differ between the two OS's? If we went with Solaris, we would go with Solaris 9 running Oracle 9.2 on a Sun 4800. Thanks for any responders. -- 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).
RE: AIX vs Solaris
IBM has some very exciting technology in the pSeries line. Their Regatta line (p690) are incredible Unix-based mainframe class systems; similar to Sun's Sunfire and HP's Superdome lines. The really cool thing is that you can get those same chips in a 4-CPU configuration 4U rackmount box for like $50K. Those make VERY nice development systems. :-) As far as which system to purchase, that depends a lot on how much management wants to invest in re-training. From a Unix standpoint AIX isn't very hard to learn -- it's sort of a mix-match of SYSV and BSD compared with Solaris and HP-UX's SYSV roots (SunOS was BSD-based until Solaris 2.x). >From the standpoint of configuring physical hardware, adding disk to the system, doing LVM striping, etc. they've all got similar commands (e.g. lspv on AIX vs pvdisplay on HP-UX; not sure what Sun's using these days, and it probably depends on whether or not you're using Veritas, etc). The point is that it's just a syntactical re-learning, but the concepts are all the same. HP and IBM both have fairly decent sysadmin assistant tools (AIX uses SMIT and HP uses SAM). In comparison, I've always been less than impressed with Sun's Admintool, though I've heard it's somewhat improved in Sol9. With regard to price performance, the three vendors seem to leap frog quite a bit, with no clear "leader of the pack" over a long period of time. I think it's a safe bet to go with any of them, although it remains to be seen how effective HP's new Itanium strategy will be... the PA-RISC chips were a very nice line, as have been the Sparc/UltraSparc lines, and the IBM Power-based CPU's. I'm curious to see if Itanium will be able to provide the raw horsepower to keep up with Sun and IBM over the long term, but I don't think they'd bet the farm if they didn't think they could do it Rich Holland Guidance Technologies, Inc. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of DENNIS > WILLIAMS > Sent: Wednesday, November 13, 2002 4:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: AIX vs Solaris > > Bill - You may want to check with your system administrators. My > understanding is that the two systems are pretty much identical from the > user standpoint, but that AIX is quite a bit difference from the sys > admin's > point of view. It may make a difference, depending on your sys admin's > background, but maybe not enough to change the purchase decision. >Another thing to consider: what is the timeframe of your purchase. We > have gotten very good use from our Dec/Compaq/HP Alphas, but decided not > to > continue investing in the line. We looked around and Solaris seems to have > the strongest path to the future. Most Unix vendors, like HP, seem to be > planning to switch to the Intel Itanium, the chip without a proven > "today", > let alone tomorrow. I don't know what IBM plans for the future in terms of > chips. If this is just a single system purchase, then it probably doesn't > matter so much. > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 13, 2002 12:49 PM > To: Multiple recipients of list ORACLE-L > > > > Hello, > > What are the major differences between AIX and Solaris regarding > operating system features? > > We are planning a new machine purchase; currently we are on a Sun machine > running Solaris, but IBM is making a strong proposal to management > (meaning significantly less cost), and we are wondering what would need to > be > changed. We use korn shell scripts extensively, and features such as > crontab, background processing, the sqlplus < sure what this is called). I'm fairly sure these are standard in most > flavors of unix, but I have never had contact with AIX. Does anyone know > what features differ between the two OS's? > > If we went with Solaris, we would go with Solaris 9 running Oracle 9.2 > on a Sun 4800. > > Thanks for any responders. > > -- > 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 wan
RE: RE: Changing dump destinations in init.ora
Yes, the SPFILE is stored in binary format in the database, but you can sort of work around it. To create a text file from the SPFILE, you can issue: CREATE PFILE 'pfilename' FROM SPFILE 'filename'; And vice versa with: CREATE SPFILE = 'filename' FROM PFILE = 'pfilename'; When starting the instance, you can also specify an alternate SPFILE: SQL> startup pfile=filename There's also some new syntax for the ALTER SYSTEM command to specify the scope of the change: ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE | BOTH; Rich Holland Guidance Technologies, Inc. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, February 13, 2002 3:43 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: Changing dump destinations in init.ora > [...] > during the discussion on database management it was revealed that init > files are on the way out, probably in 9i version 2. Their being replaced > by an SF file that is humanly unreadable and consequently unmodifiable. > Seems we'll have to do all modifications with the assistance of an alter > database or alter system command. > On the plus side, if your starting a database remotely you'll not need a > copy of the init.ora locally. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rich Holland 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: DBA-Database Storage using Net Appliance
NetApp Filers use WAFL (Write Anywhere File Layout. WAFL is similar to other Unix filesystems like FFS in that it's a block-based file system using inodes to describe files. It uses 4K blocks with no fragmentation. Each WAFL inode has 16 block pointers that point to data blocks. Unlike FFS, all the block pointers in a WAFL inode refer to blocks at the same level. For files smaller than 64K the 16 inode blocks point to data blocks. Larger files use indirect pointers (inode blocks point to other inode blocks). Very large files use double inderect pointers (inode -> inode -> inode -> data). Very small files use the inode blocks themselves instead of the block pointers. WAFL stores file system metadata in files (inode file, block-map file, and inode-map file. Keeping this data in files allows the Filer to write the data anywhere on the disk (rather than to a "superblock" like FFS), which is where the WAFL name comes from. This also allows the Filer to schedule writes to the same RAID stripe to avoid the 4-1 write penalty you usually incur when you update a single block in a stripe. Other nice features from a sysadmin point of view are the fact that the Filer will automatically increase the size of your filesystem when you add another disk, and the use of snapshots. Snapshots are really cool if you haven't seen them before. Basically from the point in time the snapshot is taken, the filesystem has to write all new data (including meta-data) to new locations on the disk instead of overwriting the old data. If WAFL used a superblock like FFS, this wouldn't be possible. If data is changed, the Filer uses a copy-on-write technique to keep the old block avialable for any snapshots which reference it. I've never used a Filer for Oracle applications; I've only used EMC due to the size & availability requirements of the implementations I've worked on, but I know it's been done by others. If you poke around at http://www.netapp.com/ you can probably find Dave Hitz' original white papers on WAFL and the design of the filer (formerly called FAServer) if this sort of thing interests you. Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Berkmeyer, > Sue > Sent: Thursday, February 14, 2002 10:29 AM > To: Multiple recipients of list ORACLE-L > Subject: DBA-Database Storage using Net Appliance > > Hi Everyone, > > I am getting pressure from the system guys to use a Net Appliance > filer for Oracle Applications databases. I currently have the Apps > Release > 11.0.3 production database on a Sun E4500, 4G RAM, 6CPU@400Mhz and a Sun > storage array with a mix of 4 and 9G drives. The production datafiles are > on Raid 0+1. The production software is mirrored only. Sequential files > are not "raided". I have gone out to the Net Appliance web site and have > download papers about how to implement Oracle on the filer. I would like > to > hear from real users rather than the vendor about how this works. > Therefore > I am curious to find out anyone's experience with this storage technology > - > good or bad. If anyone has any insights about the Net Appliance > technology > itself i.e. raid level, etc. that would be great too. We are also > considering a new Sun direct attached storage solution. Thanks for your > time. > > National Renewable Energy Laboratory > Sue Ellen Berkmeyer > Database Administrator > Phone: 303-275-4143 > Fax: 303-275-3603 > E-mail: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Berkmeyer, Sue > 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: Rich Holland 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).