RE: LSNRCTL Password
I tried host=localhost on some test boxes and clients could not connect. Next I'll try host = 127.0.0.1 (7.4 on Sun 2.6) Mike -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: LSNRCTL Password Downside only if you want to have listener on different box - maybe for load balancing. Alex Hillman -Original Message- Sent: Thursday, May 10, 2001 7:01 PM To: [EMAIL PROTECTED]; Hillman, Alex Neat trick., hadn't thought of that. Any downsides to using localhost? Jared On Thursday 10 May 2001 14:52, Hillman, Alex wrote: This is why I now use localhost instead of hostname. Alex Hillman -Original Message- Sent: Thursday, May 10, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Alex, Could you explain please how somebody with DBA provileges on another node can shutdown listener on another node without logging as user of the node where listener is running. I fully agree with Jared. We encountered this when I duplicated the Prod server (including the SQL*net config file) onto a Test box and bounced the test box. The listener.ora file contains the name of the Prod server and the automatic stop/start script executed a 'lsnrctl stop' as part of shutdown - this sent a STOP signal to the identified host (the Prod server). This stopped the listener on another system!! It is quite easy to test this out - you can create a dummy listener.ora on the Prod box, point that to the Dev box and stop the listener from Prod... Hth, John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Lanteigne, Mike 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: OFA and SAN - Why not group all db files on its own mount poi
Hi Lisa, Thanks for the response. The SAN is very new here. Our first test server is supposed to be hooked up to it this week. After that we start to play. I will look into the tuning software for EMC, however from the meetings I've been to, it looks like we'll (the DBA group) have little say in the SAN setup, including ..mapping all the way back into the physical controller... Too bad, that sounded like fun. The only drawback I see about equating a mount point to a database instance is that new mount points will have to be created for each new database. No big deal in the static production environment, however could be a pain in dev and test (assuming I follow the same strategy in these environments). In fact, I have no idea how I'd even make a mount point, or allocate storage to it? (SAN PFM I guess). Thanks again Mike Hi Mike, If you are running EMC hardware, there are several utilities you can use to determine if EMC's cache is performing up to par. There are also utilities to alleviate any i/o contention that may appear if the EMC cache does not take care of i/o problems. I can't tell you exactly what they are though, the sysadmins used them, not me. I've worked in two places where we ran EMC hardware (symmetrix) and was told it should not make a difference if you follow the standard or not from an i/o point of view. However, I just couldn't get over the thought that i/o will never be a problem. Add to it I've heard contradicting stories from EMC support staff, in MN and here in FL. I think there is still merit to mapping all the way back into the physical controllers in the symmetrix, but it's a royal pain in the behind. When the EMC guy talked through it, it was difficult for me to follow. I still have the documentation but I couldn't tell you exactly what it meant. (I am not an SA !!) It's a lot of work for what little performance boost you may see. If you are interested in seeing this tuning software (I'm not talking about Precise/SQL DBTuner, it's lower level than that) I'd suggest contacting your EMC support staff. Sorry I couldn't be more specific, but I can tell you I've set up databases both ways (OFA and not) and haven't experienced huge i/o problems. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess Hello List, I'm planning an upgrade of four databases on one server from 7.3.4 to 8.1.7 on Solaris. We are in the initial stages of implementing a Storage Area Network (SAN) project, initially 10TB on EMC hardware. The database server will use the SAN for its storage so I will have no decision on where datafile are actually stored (those involved in a SAN implementation know what I mean). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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 database development life cycle practices
Hello all, Again turning to the wisdom of the list. I'm looking for information on database developments and application development practices. You know the DBA vrs developer thing this list loves so much. Any good resources you know about that I can look into? Any good methodologies you follow? What do you use the dev database for? That kind of thing. I'm especially interested in any work practices you follow. Do you have these work practices documented? Do the developers consider you (DBAs) an asset to the development cycle? Any info appreciated. Thanks Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Real-life Stand-by DB implementation stories?
I have got a question about Data Guard: Do you have to have Enterprise Edition for it to work? We did not use Managed Standby Database functionallity, because it needed Enterprise Edition licence - and it meens a huge extra cost. Docs just say 8.1.5 or higher and UNIX. I checked with Oracle support to see if we are licensed to use, it and we are, however we have enterprise licenses. You'll probably have to check with your support person. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Real-life Stand-by DB implementation stories?
That auto fail over feature is called Data Guard, and its out now (at least the docs are). It will work with 8.1.5 or higher on UNIX OS in a non parallel server environment. Basically as far as I can tell, it runs agents on both primary and standby servers, and will auto fail over to the standby if needed. Another cool function is that it will switch your primary and standby database if you want, then switch them back. Server maintenance options arise with switching feature. I hope to test this during the coming months, so I may have some real insight later. Anyone use this yet? Mike -Original Message- From: Szecsy Tamas [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Real-life Stand-by DB implementation stories? Yes we did. It's on windows NT. We have implemented manually managed standby database, with a db job on the primary database archiving online redo log files every five minutes to minimize data loss in case of a crash of the primary database. The standby database server ftps *iwth a windows nt scheduled job, running every 15 minutes) new archive log files to it's local drive and applies them to the standby database if it's not in read-only mode for reporting. It's working since a more than a year, never had any problems with it. If Windows NT server is kept away from frequent install/deinstall of various applications then within my experience it is a stable solution. By the way, if Oracle Technet can be believed, Oracle 9i will have an automatic fail over feature for the standby database. My view is that you should use Oracle 8.1.7. Oracle 8.1.6 has some problems with read-only mode combined with managed standby database - or so I heard. Regards, Tamas Szecsy === Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that makes a difference. Thanks, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall 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: Szecsy Tamas 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: Lanteigne, Mike 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).
OFA and SAN - Why not group all db files on its own mount point?
Hello List, I'm planning an upgrade of four databases on one server from 7.3.4 to 8.1.7 on Solaris. We are in the initial stages of implementing a Storage Area Network (SAN) project, initially 10TB on EMC hardware. The database server will use the SAN for its storage so I will have no decision on where datafile are actually stored (those involved in a SAN implementation know what I mean). So... I'm looking at the OFA docs - where datafiles from different databases are on different mount points mostly for I/O purposes e.g.: Non SAN OFA: md03/ oradata/ db_1/ system01 data01 control01 redoG1M1 redoG2M1 db_2/ system01 data01 control01 redoG1M1 redoG2M1 md04/ oradata/ db_1/ index01 temp01 control02 redoG1M2 redoG2M2 db_2/ index01 temp01 control02 redoG1M2 redoG2M2 In a SAN implementation, it seems to me that since I/O is no longer a parameter I can control, why not group each database on its own mount point e.g.: md03/ oradata/ db_1/ system01 data01 index01 temp01 control01 control02 redoG1M1 redoG1M2 redoG2M1 redoG2M2 md04/ oradata/ db_2/ system01 data01 index01 temp01 control01 control02 redoG1M1 redoG1M2 redoG2M1 redoG2M2 I know it looks scary. Lets say I separate the control files on separate mount points. In reality the SAN puts the files all over the place, making copies on multiple volumes, so I think I'm fooling myself by thinking I'm buying anything by using separate mount points. Any thoughts? Anyone set up a dir structure using a SAN. Admin seems simpler the second way. Thanks Mike Lanteigne -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Anyone using Peoplesoft Financials 7.x on Oracle 8.0.x?
Hi Nuno, I'm new to the wonderful world of PeopleSoft, so I probably can't provide much insight. Why keep the discussion off list? Keeping it on the list helps us other newbies and allows the more experienced PS DBAs (Dick et al) a chance to comment on any replies you get. Just my 2 cents Mike -Original Message- From: Nuno Souto [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:56 PM To: Multiple recipients of list ORACLE-L Subject: Anyone using Peoplesoft Financials 7.x on Oracle 8.0.x? If so, please ping me via e-mail. Use address below. I need to ask a coupla questions re maintenance/versions. OT to this list, so I won't bother the others here with them. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cdump, bdump, udump
I must be 'old' because I miss my paper docs. I still print out some of the pdf docs, must be a confort thing! Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: Lanteigne, Mike 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: Cold Fusion and Oracle
Cylir Check the CF docs on the Allaire web site. It's been a while for me, however set up a data source on the CF server using ODBC and Net80, then use that data source name in the CF SQL. Something like datasource name = XXX. Like I say, It's been awhile. Oh, I think the enterprise version of CF will run stored procedures too, although I never had the enterprise version. Mike Lanteigne The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 5:34 PM To: Multiple recipients of list ORACLE-L Subject: Cold Fusion and Oracle Hi!.. DOes any one here have any information of where I could possibly find some information on Cold fusion and Oracle Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Lanteigne, Mike 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 can I find real-life-examples about ORACLE installation
FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: ERWIN HELP
ERWIN comes with a Getting Started book, holds a lot of info for a little book. However the online help should contain all the info you need. Just keep clicking and you'll figure it out. Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: ora dba [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Subject: ERWIN HELP Hi: I am trying to document and reverse engineer an Oracle 8i database. Could you please let me know where I can find documentation on HOW TO use the ERWIN tool to do the same. Any books available in market that you can recommend would also help. Thank you __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ora 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: Lanteigne, Mike 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: More Metalink Venting - Cannot catch error 22
Ruth, Out of curiosity, how did you get back the data! Mike -Original Message- From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 12:41 PM To: Multiple recipients of list ORACLE-L Subject: Re: More Metalink Venting - Cannot catch error 22 The other nite I truncated every table in one of my production databases. I called Support and when the analyst asked my if she could ask me to open the TAR on Metalink I said 'NO, I can't . This is an emergency and it's production.' She answered my question about the recovery, that tables were back in less than an hour, and I apologized, on Metalink for my behavior. Sometimes you just have to take a stand! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 12:11 PM Well, I just went to open a TAR and discovered yet another Metalink catastrophe. Not content with slow service and error messages they've come up with a new one: When I go to create a TAR it asks me to, among other things, 'SELECT A PLATFORM'. This is a required field. There is nothing in the drop down list. It is not possible to type anything in. If I try to hit Continue it tells me Platform is a required field. Will someone please shoot me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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).
OT - Performance impacts with column and table aliases in SQL Ser
Hello all, I know, I know - An Oracle list. However some of us work with many databases (our shop has Oracle, SQL Server, Adabas, and Sybase), so maybe someone on this list can help. The subject line should give enough info to delete the message if you hate the 'other' databases. I was asked recently if alasing all columns and tables in SQL statements in stored procedures has any performance impacts. I've never noticed any problems using aliases, nor have I seen any reference to performance hits due to using aliases. The app is an MS component design thing in which all the database calls are made from the data tier (VB) to stored procedures in SQL Sever. Any thought on this? Mike Lanteigne The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: URGENT: Hot Standby Graceful failover and failback
I think you may be trying to do a little too much with the current standby architecture. Oracle now has product called Data Guard that will let you do what you want. I've only read the docs on Data Guard, but supposedly you can switch primary and standby database, and switch back without re-creating anything. Good luck Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Leng Kaing [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: URGENT: Hot Standby Graceful failover and failback Good morning everyone, HELP! HELP!!! It's very early in the morning and I'm still struggling with the Oracle Hot Standby - 8.0.5 and 8I. ARGH! Ok, I got the failover going. I can activate the standby database and use it as a normal database. But when I try to turn it into a standby database again and then reactivate it again, it errors out on me. Oracle Support just tells me that I'm not supposed to use it this way. HUH? I'm not trying to put it back in standby mode so I can recover from the original primary database! I want to put it back in standby mode to similulate a total primary site loss. And always have a standby database to activate. Ok, I may be rambling on a bit here. Very tired. So here's what I've done so far: 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from backup created in step 3, and replaced the current control files with the standby controlfiles created from stop 4 7. mounted the database in standby mode again 8. tried to activate the new standby database but it failed with ORA-1152 and ORA-1110 complaining that the system.dbf is not restored from a sufficiently old backup. Argh! How do we have a continuous failover and failback scenario? Any help would be greatly appreciated. I've just discovered Lawrence To's article on Graceful Switch Over and Switch back as well. The following from page 11 scares me: "Graceful switchover and switchback are not possible when the production database's online redo logs are not accessible. A graceful switchover and switch back is NOT possible whenever a production database or standby database executes one of the following: - alter database open resetlogs or - alter database activate standby database (which does an implicit resetlogs operation)" HUH??? There are certainly times when we have to do a resetlogs. One of the problems our Unix boxes have at the moment is a redo log corruption so there are not choices but to resetlogs. So what does this all mean? That if we resetlogs we can't ever have continuous failover and failback? ARGH!! What am I dealing with here! I need a holiday from this crazy scenario! Ok, please let me know if you've had any success with what I'm describing here. Am I aiming for the impossible? Surely not! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ __ ___ http://movies.yahoo.com.au - Yahoo! Movies - Now showing: Dude Where's My Car, The Wedding Planner, Traffic.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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: Lanteigne, Mike 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: 32bit v. 64bit Oracle
Stephen, Last time I checked Metalink (couple of weeks ago), 8.1.7 64-bit status was "projected" with Sun Sparc Solaris. I filled out a TAR asking when it will be certified, and they told me to check Metalink (even offered me walk me though the web pages)! Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: paquette stephane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Re:32bit v. 64bit Oracle Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on Solaris ? Oracle.store only shows Oracle 816 64 bit for Solaris. If you do not need to adress a huge SGA, what are the benefits are running Oracle 64bit instead of Oracle 32 bit ? --- [EMAIL PROTECTED] a crit : Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Lanteigne, Mike 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).
Can one listener affect another?
Hi all, Something strange happened here this morning. I created a standby database on our standby box this morning (Sun server OS 2.51 Oracle 7.3.4.5), all went well. I check the status of the listener on the standby box, it was up (I don't know why I even cared). The production listener went down shortly afterwards (I may have stopped the standby listener, however I don't think I did). The standby listener.ora file has HOST = "production box", not the "standby box" (replicated nightly from production to standby). I checked both listener.log files and a "stop" is in both log files at the same time (production and standby). So, can stopping (or just getting status) from one listener affect another listener on another box if both listener.ora file entries "HOST = XXX" are the same ? Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Unix memory used
Thanks Jared and Jacques and Dave and Michael, I seem to remember a discussion on top a couple of years ago, that's why I was suspect about the numbers it was showing. I've been to the sun big admin page, lots there to read. I'll track down some of the other suggested sites, as well as look for that book. Thanks again Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: Unix memory used Mike, The amount of memory available as shown by 'top' is of little use, as Solaris gobbles up nearly all of it leaving little free, regardless of how much you have. Use vmstat to determine the paging rate. I can't think of a good number at the moment, and my Solaris books are currently packed away. You also want to check the page scan rate ( I think that's the right term ). It is tunable, and will take up a lot of CPU if set incorrectly. If there is *any* swapping taking place, it is too much and you need more memory, barring problems such as memory leaks. The Solaris book by Adrian Cockroft is a must have if you are doing any tuning work on Solaris. It will explain clearly everything I have alluded to here. Jim Munro's book is a must have if you want info on Solaris internals. Jared On Wed, 4 Apr 2001, Lanteigne, Mike wrote: Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga Total System Global Area 6278336 bytes Fixed Size 39816 bytes Variable Size 4567352 bytes Database Buffers 1638400 bytes Redo Buffers 32768 bytes I'm looking for some ammunition to make a case to increase the RAM. Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following: Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday) I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it. Thanks, Mike Lanteigne The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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). Jared Still [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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).
Unix memory used
Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga Total System Global Area 6278336 bytes Fixed Size 39816 bytes Variable Size 4567352 bytes Database Buffers 1638400 bytes Redo Buffers 32768 bytes I'm looking for some ammunition to make a case to increase the RAM. Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following: Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday) I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it. Thanks, Mike Lanteigne The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Unix memory used
Michael, Yes, that's what I want to do. In fact, I've pin pointed some areas, such as redolog buffers that can user larger memory segments. However I do not want to do this at the expense of the servers total memory use. That's why I'm wondering about the overall memory use (all databases and apps). Just out of curiosity, what makes you say I'm not using all the memory I have? Thanks Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix memory used Just from looking at what you've described, you don't use the memory you have on the machine. But I'm on the outside looking in. If your databases are memory bound, my recommendation is to look into tuning your database memory first, and expanding each SGA. I'm also assuming that this is only a database server. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject:Unix memory used Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga Total System Global Area 6278336 bytes Fixed Size 39816 bytes Variable Size 4567352 bytes Database Buffers 1638400 bytes Redo Buffers 32768 bytes I'm looking for some ammunition to make a case to increase the RAM. Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following: Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday) I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it. Thanks, Mike Lanteigne The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Armstead, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: What is best practice - differenet schema/different dbs
Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: What is best practice - differenet schema/different dbs
Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Lanteigne, Mike 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).