RE: Connection Problem
Hello Mark, all 3 instances are listening on the same port. Cheers Barry. -Original Message- Mark Leith Sent: 16 January 2004 11:14 To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey 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).
'internal' role and 9i
Hello all, I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey 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: 'internal' role and 9i
As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9 that doesn't like it. I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE and INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -Original Message- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L Barry, Why make life difficult? It's just a role, not a data object referenced by applications (hopefully). Change it's name to something that is not a reserved word and move on. There is a list of reserved words in the SQL Language reference. Hope this helps... -Tim Hello all, I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey 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: Tim Gorman 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: Barry Deevey 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: 'internal' role and 9i
This would explain why it worked when I tried it on oracle 8 then. The developers that originally created the application left quite a while ago, so I don't think I'll be able to ask them why they did it this way. But basically you're saying that it shouldn't have been done like this and now it needs to be changed. Not the answer I was hoping for, but at least now I know!! Thanks for your help all. -Original Message- Mercadante, Thomas F Sent: 18 November 2003 14:54 To: Multiple recipients of list ORACLE-L Yong, It seems to me that you are missing the point here. The real point is that you should not have granted select on some table to internal - ever. And a new release caught you on this mistake. And now, you have to fix it. It is not an Oracle problem, but a mis-use of an Oracle internal user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Tim, I checked v$reserved_words. At least in 9.2.0.1, INTERNAL is not in there. Oracle should address this issue. When I trace the SQL GRANT SELECT ON SOMETABLE TO INTERNAL, it stops in parsing. Nonetheless, it's confusing to say the least to create a role called internal. Yong Huang --- Tim Gorman [EMAIL PROTECTED] wrote: Barry, Why make life difficult? It's just a role, not a data object referenced by applications (hopefully). Change it's name to something that is not a reserved word and move on. There is a list of reserved words in the SQL Language reference. Hope this helps... -Tim Hello all, I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: Mercadante, Thomas F 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: Barry Deevey 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
RE: Sun Solaris
David, http://www.sunmanagers.org/ HTH Barry -Original Message- Sent: 16 December 2002 15:59 To: Multiple recipients of list ORACLE-L List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Barry Deevey 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).
Convert PL/SQL to Java
Good morning, Does anybody know of a utility that can convert PL/SQL code to Java code?? Thanks in advance for any replies. Barry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Installer not launching in NT
I had this problem last week. There is a bug when installing Oracle client 8.1.* onto a Pentium 4machine with a processor that is 1500mhz or faster. The workaround is to copy the client cd onto the machine, rename symcjit.dll to something else and then run the setup program from the pc. Cheers, Barry. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 25 July 2002 16:04To: Multiple recipients of list ORACLE-LSubject: Oracle Installer not launching in NT Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks its a Java VM conflict. Any ideas? I need this rather quick so please also reply direct to me and in the meantime I will hit the internet. Thanks, Hannah
Installing an app on a French configured server
Hello all, There is a requirement to install our application at a site that will have both Oracle (8.1.7) Unix (AIX 5.1) configured in the French language. Can anybody please advise me of anything that I need to be aware of in relation to the differences between an English French configuration?? Any help is greatly appreciated. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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).
Oracle client 8.0.5 to 8.1.7
Hi everybody, we've recently upgraded our Oracle client from 8.0.5 to 8.1.7 SQL Worksheet does not seem to have any line numbers - So, if you run any code, it'll give you the line number of the error line, but the code above does not have any line numbers displayed, making it very difficult to find the error line within the code. Has anybody come accross this before and found any workarounds, or is it something you just have to get on with?? Thanks for any replies, they're much appreciated. Best Regards, Barry Deevey Applications Developer Tel: 0117 9154253 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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: Determining Oracle status - thanks!
Hi all, I did have a look for oiconnect, but it doesn't seem to there with 8.1.7 - But you've given me more than enough to go with! Thanks for all of your replies they're very much appreciated. Best Regards, Barry. -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED]] Sent: 18 September 2001 19:45 To: Multiple recipients of list ORACLE-L Subject: RE: Determining Oracle status tnsping $ORACLE_SID works pretty well... Nick -Original Message- From: Barry Deevey [ mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Determining Oracle status Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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: Barry Deevey 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).
Determining Oracle status
Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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: Passing a parameter containing a space to sqlplus
I have just found a reference to the below question within Metalink - You need to quote the string as follows: 'WORD1 WORD2' Apologies for my premature posting. Best Regards, Barry. Hi gurus, I'm trying to pass a parameter from unix into a sqlplus script. The parameter contains a space, i.e. JOB SERVER I have tried passing it with both single and double quotations, but the sql script only accepts the first word in the string. It works fine if the parameter does not contain a space. Can anybody tell me what I'm not doing wrong?? TIA - Your replies are much appreciated. Best Regards, Barry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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).
Passing a parameter containing a space to sqlplus
Hi gurus, I'm trying to pass a parameter from unix into a sqlplus script. The parameter contains a space, i.e. JOB SERVER I have tried passing it with both single and double quotations, but the sql script only accepts the first word in the string. It works fine if the parameter does not contain a space. Can anybody tell me what I'm not doing wrong?? TIA - Your replies are much appreciated. Best Regards, Barry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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).