Career Advice
As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Career Advice
Sadly, I do agree with you, but its a silly world out there. You cant get a job working with these packages without experience, and you cant get experience if you dont work with these packages. So my alternatives are few to none. Indeed, the Tecsys applications are comparable to many complex applications in the market so I think that really works in my favour. But hiring managers want to see the big names on your resume it wont matter that Tecsys is just as complex. I guess the next step would be find a position where one of these other applications is actually used. Perhaps just getting familiar with one of these would help me get my foot in the door. Thanks Jared. Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: December 17, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Career Advice
Wow... as talented and knowledgeable as you are, you are one really bored DBA. You must work alone, or be self-employed. Or maybe you are trying to tell me to read between the lines... In any case, I won't get into a silly argument with you. Thanks for your advice, Saira -Original Message- Mladen Gogala Sent: December 17, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Have you ever considered a career in country music? Try getting Stand By your man just right and the rest will come. You have to learn both kinds of music, country and western. May Jake and Elwood be with you. On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Saira Somani-Mendelin 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: Career Advice
Hi Allan, Please call me Saira :) All you are saying is true. I find that in my present role, I don't have access to the applications source code so I have to look at the database for performance tuning (which should be the case anyway to start). On the other hand, I'm the only one at this job so I have a lot of flexibility about how much I know about the application - luckily, I own all of it so I am able to experiment at my leisure. Thank you for taking out the time to write all your thoughts. You've given me much to think about. Saira -Original Message- Nelson, Allan Sent: December 17, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Hi Somani, This is, of course, just one opinion. YMMV. I would recommend that you go deep enough on the Oracle server until you would be willing to take the junior off your title. The reason for this recommendation is that the server is an intricate piece of software that rewards study and experimentatation. If you were to go for any of the large ERP's that are out there you will find that they each have a great deal of application specific administration that has little or nothing to do with the database directly. There is literraly 1000's of pages of documentation for the server and more 1000's of pages of documentation for the ERP's. Frequently, an ERP will have certain rigidities in the database configuration that will not permit you to gain knowledge about certain areas of the server technologies. Query tuning in an ERP environment is an order of magnitude more difficult because you don't own the sql. The query source is available but in general query tuning can turn into a cooperative effort with your ERP vendor or you will find upgrades to be significantly harder projects. When you control the source it is a lot easier to learn that particular area. Similarly, the ERP's all lag the server releases in terms of feature usage. In ERP's there is generally a division between functional folks who do the transaction and business related setup and problem resoultion. Technical people generally focus on the interface between the OS environment and the applications. For instance, on the tech side you might have responsibilities for the forms server (Oracle Finapps) and the web servers, where a functional person might setup GL and be responsible for transaction and data problems in that area. If you shop has an installation of much more than moderate size you will most likely have to specialize. Most ERP's will take 3 to 5 years to learn reasonably well. I know only a handful of people that are genuinely competent in more than one. Just some thoughts. That's a nice complicated question you asked Allan -Original Message- Saira Somani-Mendelin Sent: Wednesday, December 17, 2003 11:44 AM To: Multiple recipients of list ORACLE-L As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services
RE: Career Advice
Is it that difficult though? Just to get familiar with it if youve worked with other similar software before? I guess youd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no? Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eric king Sent: December 17, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 17, 2003 1:09 PM Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Career Advice
That is an excellent guideline. I find myself as somewhere in the middle of those two spectrums, a little more towards the second one. My personal belief is that languages can be learnt - like Java or any other code - if you possess the skills. I can read and understand 4GL code without ever being exposed to it. I think learning the fundamentals, the inner workings, the internals is key to success. I'm being led towards a generalist type of role/career path and I'm starting to wonder if it's the right one. I live in Toronto, so maybe the employment market is different here from other metropolitan areas, but I'm finding a huge demand for applications specialists. But like anything in IT, I'm sure it will subside in a couple of years, by the time I'm up to speed :) If there is anything I have learnt from working with this particular software package from Tecsys, is not to trust their documentation or their advice even (as you point out). They ported their application from Informix to Oracle, so we are experiencing the pains they never had to in their pre-release days. But luckily, I am somewhat in control of how the applications are implemented and enhanced. I like the fact that I can adapt to the new without much effort. I think that's valuable - but try telling that to a recruiter or an HR person. You've given me great perspective on what is important. Thanks, Saira -Original Message- Odland, Brad Sent: December 17, 2003 2:54 PM To: Multiple recipients of list ORACLE-L There is no set formula now. But learning a fair amount of SQL, Oracle Database and Unix Administration can do you no wrong. IN my experience the companies or people that hire you because of big names on your resume are NOT the ones you want to work for. IT administration work has become more specialized of late. In particular DBA work has become more low level or hardware close at least from my perspective. As you become more familiar with the application running on the database you begin to drift more and more towards the business end user. The result if your technical understanding shifts from data reliability and security to how the data is used and perceived by the users. Your choice as a young IT professional if to determine where your particular natural talents are best utilized. Ask yourself these two questions and be honest with yourself: 1. Are you a people person with compassion and empathy for people's problems and do you have the ability to visualize data in format that business users can comprehend? 2. Are you a good technical troubleshooter with the ability track down solutions wherever they reside in the network, OS, database, middleware or client If you answered yes to the first and you find yourself helping user understand the data better then continuing in the business analyst support role would be the direction for you. If you find yourself as the support person for the analysts and work at the OS level with the system admins then the DBA route is problem better suited to you. As you choose where you are headed remember to celebrate the SKILLS and TALENTS you have on your resume. Skills you have like people skills, communication and troubleshooting rather than highlight anyone package or technology. Talents are ease of learning or a programming language like PL/SQL, SQL, perl or korn shell. The tools are all similar how you were able to learn to use them is better. Many times in down economies a new employee is brought into IT because the different perspective is desired. The successful IT professional has to have the ability to drift with the tide of technology and adapt to change rapidly and to help lead the way through unknown territory with confidence. You can't trust the vendors and you can't trust the documentation all the time but you can trust your own abilities to sift through the chaff to find direction. Looking at the IT world as a whole is the best place to start. Seeing the strata from the network to OS through the database, middleware, workstation and finally enduser is the view that will help you succeed. Knowing where you are and how to overlap the boundaries is the best way navigate an IT career. What we do is not rocket science but you can't do rocket science without us. Good luck in your future. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Career Advice
Little Caesars. $5 CDN (Seriously). -Original Message- Mladen Gogala Sent: December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, Odland, Brad wrote: My career advice to you is: do whatever sells. Even if it is wearing a sandwich board that says, Hot Large Pizza Now $5.00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Saira Somani-Mendelin 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: Career Advice
Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. I've hesitated to learn Perl - don't know why, but now I find I have to know it to do my job better, esp when I'm working with Oracle. Shell programming is also getting lots of attention from me. I worked with PostgreSQL when it first came out and then I forgot about it. Thanks for the insight. Saira -Original Message- Mladen Gogala Sent: December 17, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Or maybe you are trying to tell me to read between the lines... I'm not. I was just kidding. I don't know any of this stuff (SAP, Siebel, Oracle Apps) and I do make my living. Frankly, I don't like specialists, because they end up just like pandas: no bamboo shoots, and they starve. Black bears and racoons are more to my liking: they eat anything (one of my neighbors lost two cats when she moved from NYC to CT) and thrive. Being an oracle DBA looked like a safe proposition just two years ago. Now I'm doing lots of perl, some PHP, linux, samba, I started playing with PostgresSQL (cool stuff) and I made oracle database just one among my skills. I'm quickly honing skills of a standup comedian, too. Please, do not misunderestimate me. My career advice to you is: do whatever sells. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Saira Somani-Mendelin 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: Career Advice
Sounds like a fun time J no really Thanks for all the details. Right now I have one computer that is used by everyone. I have a spare laptop but I can always buy a couple of cheap computers to set up a mini lab. Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Odland, Brad Sent: December 17, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Career Advice If you need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo linux box at home is a great learning exersize. (I've yet to do the Gentoo thing, RedHat right now) (You need at least two computers at home...List how many computers do you have at home.be honest...even the dead ones...) And to do so without useing the Database configuration assistant. Then go through upgrades to 9.2.0.4 Set up some locally managed tablespaces, enable archive logging, write some hotbackup and coldbackup scripts, alter datafiles, make new ones, load some bogus data, do exports, imports. Drop table and recover them from exports, break the database, recover from backupsset up procedures for adding new users of pretend application. Create roles for developers, users and analysts...write a PL/SQL program to generate gobs of fake test data. Hotbackups everynight, nightly processing jobs, trunc tables and move data around Fiddle with connection manager, OMS, OEM, the agent and Oracle Names. Run various DBA tools TOAD, dbVisualizer do some connections with JDBC and setup apache with PHP and write a few goofy pages to query the data dictionary and format output to your browser. Convert OraHoo0.5 from Oracle function to OCI functions (that's a fun exercise) All of that is free and downloadable with plenty of documentation. That experience alone will do a ton for you and keep you busy at home for months. pretty much all of the network, OS and database skills are covered. And you can say you've been exposed to performing these tasks and if you put all your scripts your write on a cd you can take it with you for a long time. We all have our pile o'scripts we take with from place to place. Have fun! Brad O. -Original Message- From: Saira Somani-Mendelin [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Career Advice Is it that difficult though? Just to get familiar with it if youve worked with other similar software before? I guess youd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no? Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eric king Sent: December 17, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 17, 2003 1:09 PM Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands
RE: Career Advice
, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: 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: Saira Somani-Mendelin 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).
bad SQL day...help please
List, Please excuse the content of this question. I haven't had a breakthrough yet so I'm hoping for some assistance... it may seem trivial to some but for some reason I am SQL-ly challenged today. I have a table which holds historical transaction records. Each PICK or RPCK record should have a corresponding SHIP record with a match on quantity, sku, and order_id. I have to create an exception report where if for any PICK/RPCK record there isn't a corresponding SHIP record, I should be shown the PICK/RPCK record. In other words, each sku has records in multiples of 2 - i.e. 1 PICK/RPCK, then 1 SHIP record; 2 PICK/RPCK records, then 2 SHIP records. I know what I want in English, but I'm having trouble designing the query in SQL. In the table below, you can see that SKU 117127 has a PICK record but no SHIP record, same case for SKU 701206. Is someone kind enough to offer me some SQL advice? Thanks in advance, Saira OB_OID SKU TRANSACTQTY 50340 115227 RPCK36 50340 115227 SHIP36 50340 115304 RPCK36 50340 115304 SHIP36 50340 174040 RPCK12 50340 174040 SHIP12 50340 177127 PICK36 50340 177144 PICK24 50340 177144 SHIP24 50340 177624 PICK24 50340 177624 SHIP24 50340 177634 PICK48 50340 177634 SHIP48 50340 19 PICK20 50340 19 SHIP20 50340 20020 RPCK6 50340 20020 SHIP6 50340 701079 PICK100 50340 701079 SHIP100 50340 701206 RPCK30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: SQL*Plus errors... how to hide?
I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira -Original Message- Sent: November 6, 2003 3:54 PM To: [EMAIL PROTECTED] Cc: Saira Somani-Mendelin Catch the error in an exception clause and ignore it. SQL set serveroutput on SQL run 1 declare 2 x number ; 3 begin 4 x := to_number ('123^') ; 5 exception 6 when value_error 7 then 8dbms_output.put_line ('Bad Number') ; 9 when others 10 then 11raise ; 12* end ; Bad Number Procedura PL/SQL completata correttamente. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: SQL*Plus errors... how to hide?
Hee hee... I am indeed a novice, but I make fairly sound judgments based on the name of a function :) -Original Message- Jamadagni, Rajendra Sent: November 7, 2003 9:30 AM To: Multiple recipients of list ORACLE-L Don't tell me you tried it g MG, another feather for your Cap ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 07, 2003 9:17 AM To: Multiple recipients of list ORACLE-L I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: Saira Somani-Mendelin 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: SQL*Plus errors... how to hide?
I'm sure there are many ways to perform complex validations a shell script. And I needed a simple solution so I opted for the easy way. Unfortunately, I'm not an expert shell programmer yet. Fortunately, I did receive many good suggestions from the list to help me progress in my quest to learn Korn Shell. Thanks, Saira -Original Message- Thater, William Sent: November 7, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: The sleeping beauty suggestion works extremely well, if you are patient. Patience, you know, is a virtue and my goal is to promote fair and balanced view to the database. me, i want my patience RIGHT NOW!;-) BTW, is there any chance of validating the input before it gets passed to the procedure? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Before God we are all equally wise - and equally foolish. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).
SQL*Plus errors... how to hide?
List, I have a shell script that executes a sql*plus script (which executes a procedure) based on user input. But what if the user inputs an invalid datatype? The exception section handles the error and displays a user-friendly message but I still get an error stack. I want to hide this from the user. How can I do this? I have set feedback and echo options off. See output below: PO Reconciliation Batch Release Enter batch number to be released: yrugis You have entered an invalid number! Exiting program... **[I want to suppress the errors below]** BEGIN RELEASE_PO_B_H('yrugis'); END; * ERROR at line 1: ORA-01722: invalid number ORA-06512: at TRAIN65D.RELEASE_PO_B_H, line 16 ORA-06512: at line 1 Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).
PL/SQL - can't accept user input - then how?
List, Please forgive the repetitious nature of this query, but I haven't yet found an answer that satisfied me. Environment: AIX 5.1 Oracle 8.1.7 Trying to create an SQL script which calls a procedure to update a record based on information provided by the user via a screen prompt. I know PL/SQL is not interactive by nature. I have tried the ACCEPT command in the .sql script before the procedure call, which is wrapped in a shell script but it doesn't wait for my input, just carries on executing the rest of the .sql script. I am now thoroughly confused about how to do this. And I doubt I am the only one. I do need the user to provide me with a parameter so I can locate the record for update. Don't hesitate to tell me to RTFM or book or website, just tell me WHICH ONE(S) to read :) Thanks much, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Third party application - how to begin performance tuning efforts?
Thanks for your suggestions. You have provided me with some excellent ideas. Saira -Original Message- Mladen Gogala Sent: September 26, 2003 1:05 AM To: Multiple recipients of list ORACLE-L efforts? Yes, that's a great idea for forcing plans. Thanks for thinking of that. Essentially (this part is for the original poster, Saira Somani), you create a small copy of your production database, by using exp rows=no, if necessary and then repeat the query in that small database, where you can tweak the parameters, the structure and the quantity of data. That means that you can force full table scans, hash joins and alike, then, when you are reasonably satisfied with the execution plan, create an outline and trensplant it to your production database. Stephane, it's a great idea. I'll write it to my book of spells. On 2003.09.25 23:14, Stephane Faroult wrote: Outlines ? Mladen Gogala wrote: Saira, you can turn on tracing, you can analyze tables, create histograms and create indexes. The first thing to do would be to take 10046 trace, level 12 and analyze it with tkprof. Then, you should find the few most expensive SQL statements and see whether something quick and easy could be done, like index creation, for instance. If not, and the performance isn't satisfactory, then determine where is the problem and contact the vendor. No big science there and nothing more you can do. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Saira Somani-Mendelin Sent: Thursday, September 25, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Subject: Third party application - how to begin performance tuning efforts? List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Saira Somani-Mendelin 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: Third party application - perf tuning...etc.
Dennis, The ERP vendor started off using Informix and ported their application to Oracle. We are 1 of 2 Oracle installations and they do not have much Oracle expertise in their company - they don't provide any administrative type manuals for the SA or DBA with respect to their products. I wish they would write an Oracle chapter or at least release an internal document which would explain all this. I do think that with their new release, they will be providing some tips for tuning so maybe I can just hold off until then. The on-line forum is a great idea and there is one in which we actively participate. Thanks, Saira -Original Message- DENNIS WILLIAMS Sent: September 25, 2003 5:15 PM To: Multiple recipients of list ORACLE-L eff Saira Here is my tip. Every vendor must take an approach and if they support many databases there will be some compromises in their architecture. The vendor probably has a chapter in a manual about how they interface with Oracle. Read this, but don't skim it like most of us do because we have way too much to read. No, ponder each word and try online experiments to try and learn what every detail means. In a former life I worked for a vendor and I wrote that Oracle chapter. For some reason it is hard to write that sort of thing so everyone can understand it. Once you really understand the vendor's approach, you are miles ahead in understanding your tuning alternatives. Also if it is an ERP vendor, there is probably an online user forum somewhere and you can get a lot of specific advice there. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 25, 2003 3:35 PM To: Multiple recipients of list ORACLE-L efforts? List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: 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: Saira Somani-Mendelin 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).
Third party application - how to begin performance tuning efforts?
List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Reducing the number of databases
Title: Message Unfortunately, thats what we have! And yes, my resume is on-line Our database configuration and installation was outsourced and so was the installation of our ERP. So guess what happened? No consultation with the support analyst and now they want to split the schemas into multiple instances. Go figure J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: September 19, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Additional money might be saved by having only one database which would assume the role of QA, development and production. That would mean that developers test in production and their own QA. You can save a bundle on oracle licenses that way. In addition to that, if you switch to noarchivelog mode, you can save a small fortune on the backup tapes. Smart thing to do in that situation would be to put your resume online before stuff hits the fan. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guang Mei Sent: Friday, September 19, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Here we have 3 environments formost applications (dev, QA andprod) and all Oracle version are the same (8173 now). It works fine. And to save Oracle license costs, we also consolidated some db servers byputting multiple instances onone server machine.No problem so far. Guang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AK Sent: Friday, September 19, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Reducing the number of databases I have seen more requirement for individual development databases ( where ind schema is not possible ) due to complexity of application . Developers step on each other if they work of same database . A pl/sql developer is invalidating procedure while a java developer is trying to make his program work. -ak - Original Message - From: Stephane Paquette To: Multiple recipients of list ORACLE-L Sent: Friday, September 19, 2003 8:59 AM Subject: Reducing the number of databases Hi, We have around 120 databases. Most applications have 5 environments (dev, test, integrated test, acceptance, prod) some applications have more.The applications are a mix of home developped and bought application (peoplesoft, harvest, compass,...) New applications are coming in. New databases will appear soon with DB2UDB. All servers are unix/aix, there are15 production server and around 10 servers for the dev, test, integrated test and acceptance databases. All databases are at 8172 except 6-7 databases and planning to go to 9i in 2004. Off course we see the migration like a pain. We want to reduce the number of databases and instances. To obtain a significative gain I think we must reduced to around 60 databases. Anybody has done the task to consolidate on less servers and les databases ? One way to do it would be to go with 2 instances of dev 2 instances of test 2 instances of integrated test 2 instances of acceptance all prod instances are standalone. Food for thought backup Oracle version availability naming convention of objects security ... All feedback is welcome. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 et (514) 925-7187 [EMAIL PROTECTED] Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: ORA-16014
Here is are the complete entries from the alert log: ARC0: Error 19510 closing archivelog file '/apps/oracle/archive_logs/current/archT0001S006362.ARC' ARC0: Archiving not possible: error count exceeded ARC0: Failed to archive log# 2 seq# 6362 ARCH: Archival stopped, error occurred. Will continue retrying Wed Sep 3 12:00:03 2003 ORACLE Instance THLI - Archival Error ARCH: Connecting to console port... Wed Sep 3 12:00:03 2003 ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ARCH: Connecting to console port... ARCH: ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ARC0: Beginning to archive log# 2 seq# 6362 ARC0: Completed archiving log# 2 seq# 6362 Archiver process freed from errors. No longer stopped. So it seems to be resolved? Please comment. Thanks, Saira -Original Message- Sent: September 3, 2003 12:11 PM To: '[EMAIL PROTECTED]' Received this alert minutes ago. There is no disk space shortage. What else can I check for? ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).
ORA-16014
Received this alert minutes ago. There is no disk space shortage. What else can I check for? ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: How to keep root out?
Title: Message Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to keep root out? Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W
RE: [stupid] vi question
Well that would explain it, I suppose. Unfortunately, these files were ftp'd by our ERP vendor so I really can't reverse the ftp situation. Thank you all for your suggestions. I will give them a try. Saira -Original Message- Stephen Lee Sent: August 6, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Like mebbe you ftp'ed the file from the windows box in bin mode. FTP again, but in ascii mode this time. ftp box (user / password) ftp ascii 200 Type set to a ftp get the_file -Original Message- There's the :set list and :set nolist commands. But in your case, I think you got ahold of a MSDOS/Windows text file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).
SQL*Loader - append to a table while checking column against another table
List, I have been given a csv file to load into an Oracle table. This table has no referential integrity constraints (it is checked via the application) so I could end up inserting a bogus record. Is there any way for me to check for the existence of a record in another table while loading data using SQL*Loader? Here's the process I use right now: Load records into a temporary table. Query these records against the reference table. If record doesn't exist, spool it into a file, give it back to the BA, get them to fix it, then go through the whole process again until there are no bad records. Seems like a roundabout way to do things - it definitely works for me but I just wonder if there is an easier way. Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).
OT: [stupid] vi question
Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: running 9i database and 11i apps on Linux - Good idea?
Yes I think so. I went the other way knew Linux well and moved over to AIX. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fedock, John (KAM.RHQ) Sent: July 30, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: running 9i database and 11i apps on Linux - Good idea? I am looking for advice, links, white papers, etc.on the feasibility of upgrading our current old Oracle Financials system and upgrading the database (9i) and the new 11i app onto Linux servers. If I know Unix well, can I hit the ground running with Linux? TIA. John John Fedock K Line America, Inc. www.kline.com * [EMAIL PROTECTED]
RE: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Saira Somani-Mendelin 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 9i Lite and cellular technology
I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Lite and cellular technology
Thank you. As per your suggestion, I have been able to locate some pertinent information and terminology starting with CDPD. Thanks! Saira -Original Message- Goulet, Dick Sent: July 15, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Saira, If you have a Metalink Account do a search on CDPD. There is a forum discussion on what your asking. May create more questions than answers, but that's what the forums are for. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 15, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Goulet, Dick 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: Saira Somani-Mendelin 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).
ORA-01722 while using sqlldr
I'm hoping for expert assistance. I'm using SQL*Loader to load some 2200+ records (comma delimited) into a table and running into this problem for the modcnt field: The control file reads: modcnt DECIMAL EXTERNAL -- I'm sure this is where my problem is. I have tried almost every datatype that the control file will accept - some bleed into the next column which is a date field, messing up that column, etc with ORA-01841 (full) year must be between -4713 and +, and not be 0. The datatype in the table is: MODCNT NUMBER -- no precision defined The value in the file for this field is always 0. And when I start to load the file, I receive this error (I'm testing with a few random records from the 2200+ and each have the same error): Record 1: Rejected - Error on table LC_F, column MODCNT. ORA-01722: invalid number Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: SQL*Loader problem - constraint violation
After reading some archives on google, I came up with this solution: Drop the index. Use sqlldr to append to the table - for the id column, use: (lc_rid sequence (max,1) ...) Recreate the index. However, when I did this, I received an error message saying that I can't have duplicates in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Saira Somani-Mendelin 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: SQL*Loader problem - constraint violation
Ok. I must be legally blind :) Can this happen to anyone or just me? I will try this again with my bifocals on. Thank you for pointing it out kindly!! Saira -Original Message- Sent: July 8, 2003 8:46 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Saira It looks like your index is being created on the LOC column, right? CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) So your change to the lc_rid column did not fix this problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 08, 2003 9:29 AM To: Multiple recipients of list ORACLE-L After reading some archives on google, I came up with this solution: Drop the index. Use sqlldr to append to the table - for the id column, use: (lc_rid sequence (max,1) ...) Recreate the index. However, when I did this, I received an error message saying that I can't have duplicates in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: Saira Somani-Mendelin 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: Saira Somani-Mendelin 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).
SQL*Loader problem - constraint violation
I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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).