RE: looking for job
Surendra, Sorry, I don't know of any jobs for you ... Do you live in the New Jersey area?I'm looking myself, actually. I have a question about Sony in New Jersey ... I hear they're doing some SAP work, and I was wondering if you know of any positions either available or opening up for SAP Basis or SAP Basis/APO Contractors. Do you know anything about the project? Randy Kirkpatrick home: (303)772-7467 cell: (303)885-2102 -Original Message- Surendra Sent: Thursday, February 14, 2002 8:29 AM To: Multiple recipients of list ORACLE-L Hi List, I am sorry to post this OT request.But considering the job market outside, I am tempted to give a try. I will be coming out of my project by the end of this month. Please mail me at [EMAIL PROTECTED], if you have any Oracle DBA openings. Thanks, Surendra Consultant DBA Sony, NJ-USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra 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: Randy Kirkpatrick 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: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, Don't waste your time installing 8.0.5 unless you plan to go back to it some time in the future (Back to the Future?). Install 8.1.7 and patch to 8.1.7.2 (or higher). Copy your datafiles to the new system. Make sure that you copy them to the exact directory structure that existed previously! If you don't, you will run into major difficulties, especially if you haven't done a backup control file to trace! Read all the documentation on the migration, and perform the migration which should be relatively painless. Randy Kirkpatrick home: (303)772-7467 cell: (303)885-2102 -Original Message- Sent: Tuesday, February 12, 2002 8:29 AM To: Multiple recipients of list ORACLE-L Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith 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: Randy Kirkpatrick 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 Masters certification !!!
I think he's catching on !!! -Original Message- Rowski Sent: Tuesday, February 12, 2002 3:09 PM To: Multiple recipients of list ORACLE-L I don't want to go for Oracle Masters because of the compulsory training from Oracle. Why should I spend big money on training when I have real world experience. Thanks Jason --- Joe Raube [EMAIL PROTECTED] wrote: It depends on which way you want your career path to go... administrator or developer? it really depends on what you want to do. Why not go for Oracle Master?? (big grin) -Joe --- Jason Rowski [EMAIL PROTECTED] wrote: Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ? Which is better - Sun Solaris administration or JAVA certification ? Thanks Jason __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Randy Kirkpatrick 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: OT : ERP tool for evaluation
Andrey, Are you blessed with the unenviable task of a possible ERP solution for your company? Obtaining evaluation versions of most of these packages is for the most part unavailable. I have experience with Baan and SAP if you have any questions. Randy Kirkpatrick home: (303) 772-7467 cell:(303) 885-2102 -Original Message- Sent: Monday, February 04, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Dear all ! I need to get an ERP package / tools such as Oracle Applications / SAP / PeopleSoft etc Would anyone please suggest where can i get it for evaluation, i.e. free or fairly cheap for a limited time period. Thanks a lot! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Randy Kirkpatrick 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).
Backup and Recovery
Listmembers, Are there any "gotchas" with restoring just one datafile from a hot backup and applying the archive logs? Will applying the archive logs only affect the restored datafile? For instance, if I have a hot backup from Monday and all the archive logs to the current date and a disk crashes which contains the datafile, can I restore just the datafile and apply all the archive logs from Monday forward?Are changes only applied to the restored datafile? Randy Kirkpatrick home: (303) 772-7467 cell: (303) 885-2102
RE: Becoming a DBA questions
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Randy Kirkpatrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: JR DBA needed in DC Area
. . . 150K if you're certified! . . . -Original Message- Todd Sent: Monday, January 07, 2002 8:50 AM To: Multiple recipients of list ORACLE-L Is the starting salary 100K ? :) -Original Message- Sent: Monday, January 07, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Pardon the intrusion but we are looking for a person to join our company as a Junior DBA and I thought of giving this list a try to see if there are any interested candidates out there. The basic requirements for this position are - QUALIFICATIONS: * 1+ Oracle DBA experience Oracle 8, and or Oracle 8i * Experience with SQL, stored procedures, PL/SQL * Understanding of Oracle database administration concepts * Oracle DBA experience on a UNIX platform * Bachelors in EE/CS * Oracle Certification a plus * U.S. citizenship or permanent residency required POSITION DESCRIPTION: * Provide production database support in a 24x7 environment. * Assist in installing and configuring new databases, setup monitoring procedures, implement backup and recovery procedures, troubleshoot and resolve database problems. * Must have administrative experience with installation, configuration, security setup, performance tuning, backup and recovery of Oracle databases. * Good verbal and writing skills This is a full time staff position so no sub-contractors or third parties please. For immediate consideration, please send your resume to [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patel Bhadresh 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: Thompson, Todd 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: Randy Kirkpatrick 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: Becoming a DBA questions
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinard Xing 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. === message truncated === __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Randy Kirkpatrick 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: Centralized Alert Log Monitoring
I like your plan a lot. I'd like to hear about you accomplish step 2. I already use a centralized monitoring database to store statistical data and use Excel to graph the results (or I was doing this last time I worked with Oracle - still looking for my next position!). Randy -Original Message- Michael (TEM) Sent: Monday, January 07, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Dennis: I read an article in Oracle Magazine about a technique called 'Do-it-yourself Views' (called DIY$ views in the article). The article is at http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dynamic.html. If you have 8i or above this would work for you. Basically, it allows you to read flat files with a 'SELECT' statement. I've been thinking about a tool like this, too. My plan is something like this: 1) Create a 'DBAMON' database instance. This instance needs current database links to each instance you want to monitor. 2) Write the scanning algorithm in PL/SQL, and store it in the DBAMON instance. 3) Create a DIY$ view in each database. A DIY$ view is kinda like but not quite the flat-file select in 9i. A DIY$ view is file-specific. So you create a view and call it something like DIY$ALERT_LOG in each database instance, and each instance knows where the alertSID.log file is and how to read it. 4) Create a job using DBMS_JOB in the DBAMON database to periodically scan each instance's DIY$ALERT_LOG view and look for errors. 5) If the job finds any errors, use the UTL_SMTP package to send you an e-mail, or beep your pager, or whatever. The beauty of this method is that it's all done from inside Oracle, and doesn't rely on outside factors such as WinBatch, ksh, csh, sh, Kix, bash, or Perl (sorry, Jared). My DBAMON database is on my NT workstation, and I can read alert_SID.log files from both NT and UNIX operating systems. So far, I've got step 1 done, step 3 done on a test database, and am working on step #2. Film at 11:00 if you're interested. Remember, YMMV! Cheers, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Monday, January 07, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Hi All, Currently I am the only DBA for the 15 productin databases in our company. I have written shell scripts on all database servers to parse the alert.log file and look for Oracle errors and send page/E-mail if problems are found. While this works it is sometimes painful to maintain - if I want to change something I have to go to different servers to change the scripts one by one. I figure it would be nice if we can have a centralized solution where I can monitor alert logs remotely and don't have to hop from server to server. Are there any tools/scripts that enable DBAs to do this? I know OEM can do that with the Advanced Events but now you have to buy the Diagnostics pack for that. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Randy Kirkpatrick 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: Becoming a DBA questions
Either he's full of crap, or they're paying him way too much unless he has some other managerial responsibilities. The only way to make 200K is to be a sought-after independent consultant (at $100 an hour or so). The going rate in the Denver area is $40 - $60 an hour (sometimes up to $75, but never $100!) Randy -Original Message- [EMAIL PROTECTED] Sent: Friday, January 04, 2002 11:16 AM To: Multiple recipients of list ORACLE-L Lemme get this right. This guy is a *new* DBA. He's making 150k and he's not even a senior DBA, where he can make 200k? That's all from me. I'm gonna go sulk now. Jared DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: Becoming a DBA questions [EMAIL PROTECTED] m 01/04/02 09:05 AM Please respond to ORACLE-L The following eweek article might be of interest. If the link gets mangled, the article is at http://www.eweek.com Following the Data to a DBA Job by Jeff Moad. http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Randy Kirkpatrick 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: Becoming a DBA questions
I'm sorry ... but a little over $100K + $7K is way over what any reasonable person would pay for a newbie DBA! I stand by my previous message ... this is full of crap unless he's doing more than DBA work! (Or the company is EXTREMELY generous and I want on board!) Randy -Original Message- WILLIAMS Sent: Friday, January 04, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Note that the article doesn't say that he is making $150K. It says that at his old position he was making a little over $100K, and getting Oracle certified got him a $7K increase. Well, changing jobs and getting a 7% increase isn't a big deal. It says that this position has a potential maximum of $150K. I would rate the article as misleading but not an outright lie. -Original Message- Sent: Friday, January 04, 2002 2:20 PM To: Multiple recipients of list ORACLE-L I agree also, I've been working with Oracle since version 4 and the rates here in austin,tx are anywhere from $35/hr to $75/hr, and chances are pretty slim finding an company willing to pay $75/hr for an senior person, and usually its an 1099 job when it comes to $75/hr job. dan whatley Randy Kirkpatrick wrote: Either he's full of crap, or they're paying him way too much unless he has some other managerial responsibilities. The only way to make 200K is to be a sought-after independent consultant (at $100 an hour or so). The going rate in the Denver area is $40 - $60 an hour (sometimes up to $75, but never $100!) Randy -Original Message- [EMAIL PROTECTED] Sent: Friday, January 04, 2002 11:16 AM To: Multiple recipients of list ORACLE-L Lemme get this right. This guy is a *new* DBA. He's making 150k and he's not even a senior DBA, where he can make 200k? That's all from me. I'm gonna go sulk now. Jared DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: Becoming a DBA questions [EMAIL PROTECTED] m 01/04/02 09:05 AM Please respond to ORACLE-L The following eweek article might be of interest. If the link gets mangled, the article is at http://www.eweek.com Following the Data to a DBA Job by Jeff Moad. http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Randy Kirkpatrick 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: Dan Whatley 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
RE: A DBA's career development
I went the ERP route after having been an Oracle DBA for 3 years in 2001 when I was recruited by SAP to become a Basis consultant even though I had no SAP experience whatsoever (I think there were around 40 of us, many without any previous SAP experience). They put me in boot camp and fully trained and certified me in SAP Basis, but then the market dried up and they were unable to keep me (and many others) billed at their ridiculous rate. As a consequence, I was laid off along with 10 others from the new hires. (I believe SAP America also laid off to what amounted to close to 8% of their workforce the next month). But, I firmly believe the shake-down was merely an adjustment and partly due to the economy as well customers demanding more value for their money. ERP will be around for a long time and people with those skills are very much in demand. I've been contacted by recruiters all over the country (but I have no desire to relocate!). I think it's very desirable to be working for a shop running ERP, SCM, or CRM packages as well as multiple flavors of databases because many companies are branching out and taking a best of breed approach and the experience will prove to be valuable. Randy Kirkpatrick home: (303) 772-7467 cell: (303) 885-2102 -Original Message- J Sent: Thursday, January 03, 2002 6:40 AM To: Multiple recipients of list ORACLE-L Some people mentioned ERP -- here is a newsletter on ERP, but not limited to Oracle. If you enjoy reading ERPCentrals Newsletter, please tell a friend or colleague about it. Anyone can sign up for a free subscription on our Web site at http://www.erpcentral.com e.g. of Oracle-related items: All you need is. . .Oracle? http://www.erpcentral.com Earthweb.com December 20, 2001 It was less than a year ago that Larry Ellison informed Oracle users that the companys 11i application suite would provide all the functionality they needed to run their businesses, without custom programming to add special features or tie in products from other software vendors. (Read) Oracles hard sell illustrates industrywide problems http://www.erpcentral.com CNET News.com July 2, 2001 In a special case study, we analyse corporate software sales, and examine why the industry is in the dire straits it finds itself in It is a scene repeated countless times in the corporate jungle: a company endures months of sales pitches, pays millions of dollars for new software, discovers massive problems, and spends far more to fix the product than the original cost of buying it. Oracle Special: Customers pay the price http://www.erpcentral.com CNET News.com July 2, 2001 Software consultants bemoan the fact that they only have time to be reactive - there is no time for forward planning The project deadline was considered ambitious even for the frenetically paced high-tech world. At the height of the dot-com mania last year, Oracle promised a small business-to-business startup that it would install 60 percent of the software it needed in two months. When that deadline slipped, Oracle said it could finish 30 percent in that timeframe. Even that proved unrealistic. Larry to Everyone: King Me! http://www.erpcentral.com Fortune June 25, 2001 Oracles Larry Ellison thinks he knows how to simplify matters for corporations: Just buy everything from him. Monday, Historically, enterprise software has been mind-numbingly complex. Different packages manage everything from financials to manufacturing to human resources. But Larry Ellison, CEO of Oracle, thinks he knows how to simplify matters for the corporations that purchase the stuff and then rely on it completely: Just buy everything from him. (Read) 2001 was dismal for ERP. I can't find the particular item that I am basing this statement on, but here is a related one: e.g. Overcoming Tech Fatigue Syndrome http://www.erpcentral.com Clickz.com, October 22, 2001 I spent some time recently with business leaders in the Bay Area. We discussed a number of topicsfinance, marketing, alliance, and exit strategies. But, surprisingly, one subject area never came up: e-business, the Internet, or anything even remotely related to information technology. I think that to become an IT Architect doing ERP you need to be part of a shop that already does it (? mind you, I am not an ERP person, so I probably don't know what I am talking about, please correct me if I'm wrong). You must know clients already, and they have to be comfortable working with you, because of the impact -- they have to trust you. Hence potential higher revenues if you are reliable at ERP and do a great job. Once they hire a firm to do an ERP project, will the client still need its services once that project has completed? That must be a challenge, continually looking for future contracts. I imagine you have to be comfortable making presentations to Board members. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin Operations Bedford Institute
Re: database administration questions
For questions 11 and 12: All different kinds of companies use Oracle DBAs (or have hired!) DBA's. They range from restaurant chains main offices, hospitals, Defense Contractors, Internet Companies,Office Supply just about any field you can think of. All of the above are currently hiring in the Denver area, although competition is fierce! I have seen a couple junior positions, but they require at least training and some work with Oracle. Internet companies are still risky, but defense contractors like Raytheon and Lockheed are sure bets, although may require security clearances(both are hiring in the Denver area for certain specialized Oracle related positions). Companies are extremely "picky" at the moment and are requesting specific skill sets. For current real examples in the Denver area: Oracle DBA with Sybase, DB2, and Access experience as well as Unix and NT administration with a Bachelors degree. Another is Oracle DBA with SQL server with strong C / Pro C programming skills. Another is Oracle DBA and SAP Basis Administration experience (which I have the good fortune to have experience in and hopefully will be hired by the company soon!). Still another is for a 10 year+ Unix Admin (HP9000 preferred) who has recent Oracle DBA experience. I think you get the picture. For question 13 Getting started in Oracle seems to be pure luck. For example: A systems administrator can be asked to do some DBA duties if the main DBA becomes too busy or leaves the company. In this case, the employer may send the administrator to some Oracle classes and eventually he becomes a bona fide Oracle DBA (you can say this outloud with a Redneck accent!). So, your best bet is to work for an Oracle shop where you have a chance for exposure to Oracle, ask to be involved with Oracle projects and Oracle training. Randy Kirkpatrick home: (303) 772-7467 cell: (303) 885-2102 - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, December 24, 2001 12:55 AM Subject: Re: database administration questions 1) %50 DBA , %50 Developer 2) Yes 5) all , Java and xml are more. 6) XML, VB 7) Yes , but I did not too. 8) Yes,OCP 9) Learning oracle will be enough to fill your all time. 10) This email list 11) I am interested in the answer of this question too. 12) I am interested in the answer of this question too. Bunyamin Karadeniz %50 DBA + %50 Developer - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 24, 2001 10:15 AM Subject: database administration questions Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to learn? 10) Are there any associations or other groups that you belong to as a DBA? 11) What kinds of companies hire DBAs? 12) What companies do you recommed to work for? Know of any currently hiring? 13) With my background, what is the best way to advance and work my way into a real DBA position? Thank you, whom ever reads this and answers back with at least some answers to some of the questions. I really appreciate your help!!! Please, respond to me at [EMAIL PROTECTED] smiles, me thank you!
Re: database administration questions
All different kinds of companies use Oracle DBAs (or have hired!) DBA's. They range from restaurant chains main offices, hospitals, Defense Contractors, Internet Companies,Office Supply just about any field you can think of. All of the above are currently hiring in the Denver area, although competition is fierce! I have seen a couple junior positions, but they require at least training and some work with Oracle. Internet companies are still risky, but defense contractors like R@ytheon and L0ckheed are sure bets (the weird spellings are to prevent "Trend SMEX Content Filter has detected sensitive content."), although may require security clearances(both are hiring in the Denver area for certain specialized Oracle related positions). Companies are extremely "picky" at the moment and are requesting specific skill sets. For current real examples in the Denver area: Oracle DBA with Sybase, DB2, and Access experience as well as Unix and NT administration with a Bachelors degree. Another is Oracle DBA with SQL server with strong C / Pro C programming skills. Another is Oracle DBA and SAP Basis Administration experience (which I have the good fortune to have experience in and hopefully will be hired by the company soon!). Still another is for a 10 year+ Unix Admin (HP9000 preferred) who has recent Oracle DBA experience. I think you get the picture. For question 13 Getting started in Oracle seems to be pure luck. For example: A systems administrator can be asked to do some DBA duties if the main DBA becomes too busy or leaves the company. In this case, the employer may send the administrator to some Oracle classes and eventually he becomes a bona fide Oracle DBA (you can say this outloud with a Redneck accent!). So, your best bet is to work for an Oracle shop where you have a chance for exposure to Oracle, ask to be involved with Oracle projects and Oracle training. Randy Kirkpatrick home: (303) 772-7467 cell: (303) 885-2102 - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, December 24, 2001 12:55 AM Subject: Re: database administration questions 1) %50 DBA , %50 Developer 2) Yes 5) all , Java and xml are more. 6) XML, VB 7) Yes , but I did not too. 8) Yes,OCP 9) Learning oracle will be enough to fill your all time. 10) This email list 11) I am interested in the answer of this question too. 12) I am interested in the answer of this question too. Bunyamin Karadeniz %50 DBA + %50 Developer - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 24, 2001 10:15 AM Subject: database administration questions Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to learn? 10) Are there any associations or other groups that you belong to as a DBA? 11) What kinds of companies hire DBAs? 12) What companies do you recommed to work for? Know of any currently hiring? 13) With my background, what is the best way to advance and work my way into a real DBA position? Thank you, whom ever reads this and answers back with at least some answers to some of the questions. I really appreciate your help!!! Please, respond to me at [EMAIL PROTECTED] smiles, me thank you!
Re: Move data from Oracle into Access
As long as you're planning to keep it in Oracle, the ODBC method is the way to go. If you're trying to do something else where you need to physically move the data easily, then you can use a select statement to create a comma delimited file (quoted or not quoted). You can then easily use the Access tools to import the data. You'll need to concatenate the data as follows. SELECT ''||column_1||','||column_2||','||column_3||','||',' FROM table WHERE this condition is met This way you get exactly what you want in the format you want. You can change the order of the columns. order of the data, etc. based on your select statement. Make sure you spool to a file and that your environment is set correctly to handle the amount of data. Randy Kirkpatrick Oracle DBA / SAP Basis Administrator (303) 772-7467 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 9:20 AM do you have an odbc connection? you can select directly from oracle into the ms access table. --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please... ;) I assume that there is no tool for Access to read Oracle dmp-files, right? Is spooling it out into an ASCII file (blanks or comma-seperated) the only way? I just need a single table (no refs or the like). Any ideas? This is 8.1.7 on Solaris. Thanks, Helmut __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Randy Kirkpatrick 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: Another Oracle DBA gets The Bullet in the UK - Seeking an O
RS It's very difficult to deal with people when you're kept s busy and isolated! I know that I can get very focused and forget about other people around me and their menial jobs when mine is the important job since I'm the DBA! Randy Kirkpatrick (303)772-7467 -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject:RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Randy , I am sourly lacking in people's skills..thats the point I was trying to make..(which didn't work..Obviously..!!). When I am working 42 hours continuously I don't have time to think about hurting somebody's delicate feelings. RS --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Thanks for sharing some tips. I think that in hard times it is worth considering how valuable you are considered by the people that pay your salary. Aside for the objective or true value of the DBA to the organization, I think there are two other aspects. 1. How perceptive your manager is. We can't pick our boss (usually) and can't control their technical background or their perceptiveness. I have had some non-technical managers that were remarkably perceptive. 2. Most of us didn't become DBA's because we had excellent communication skills. Most of us picked a technical career because we noticed in school that we were better at figuring out technical puzzles. Often we tend to concentrate on resolving the puzzles as quickly as possible and ignore the communication aspect, assuming that everyone will see that we are busy and will assume that we are doing really important stuff that nobody else is smart enough to figure out. However, these assumptions don't always pan out. Recently my company made a larger commitment to Oracle (not in terms of the DBA staff, I'm still soloing). I thought this was great because I interpreted it as more job security. However, suddenly there was more emphasis on ability to communicate. I am now working on ways to enhance my people skills. The book I have found that speaks in simple enough terms for me is Dale Carnegie's classic How to Win Friends and Influence People. Any other resources along these lines would be appreciated. Most of the current self-help books are more along the lines of how to get rich. Gave that idea up a long time ago. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 07, 2001 2:15 PM To: Multiple recipients of list ORACLE-L O my boss asked me to stop including him on all the emails etc. he says if I don't say anything to you then you are doing a good job I say I need you to be my boss we are a small group and everyone seems to speak at mega-volume. Everyone knows what everyone else's problem is and who fixed it and how. My teammates know what I do -- I tell them they don't really need me, but that's because we have it under control. They tell me I'm nuts -- and I have to say, it's gratifying to hear thank goodness you are back whenever I come back from vacation. --- Kimberly Smith [EMAIL PROTECTED] wrote: The way around that is to actually let them know what preventative stuff you did. I provide my manager with a weekly report and in there is a section called application maintenance and administration. I even put in there when I spend time with a developer showing them some SQL or PL/SQL tricks. Now, my teammates think I do nothing. Even after I sit there for an hour
RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O
RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Thanks for sharing some tips. I think that in hard times it is worth considering how valuable you are considered by the people that pay your salary. Aside for the objective or true value of the DBA to the organization, I think there are two other aspects. 1. How perceptive your manager is. We can't pick our boss (usually) and can't control their technical background or their perceptiveness. I have had some non-technical managers that were remarkably perceptive. 2. Most of us didn't become DBA's because we had excellent communication skills. Most of us picked a technical career because we noticed in school that we were better at figuring out technical puzzles. Often we tend to concentrate on resolving the puzzles as quickly as possible and ignore the communication aspect, assuming that everyone will see that we are busy and will assume that we are doing really important stuff that nobody else is smart enough to figure out. However, these assumptions don't always pan out. Recently my company made a larger commitment to Oracle (not in terms of the DBA staff, I'm still soloing). I thought this was great because I interpreted it as more job security. However, suddenly there was more emphasis on ability to communicate. I am now working on ways to enhance my people skills. The book I have found that speaks in simple enough terms for me is Dale Carnegie's classic How to Win Friends and Influence People. Any other resources along these lines would be appreciated. Most of the current self-help books are more along the lines of how to get rich. Gave that idea up a long time ago. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 07, 2001 2:15 PM To: Multiple recipients of list ORACLE-L O my boss asked me to stop including him on all the emails etc. he says if I don't say anything to you then you are doing a good job I say I need you to be my boss we are a small group and everyone seems to speak at mega-volume. Everyone knows what everyone else's problem is and who fixed it and how. My teammates know what I do -- I tell them they don't really need me, but that's because we have it under control. They tell me I'm nuts -- and I have to say, it's gratifying to hear thank goodness you are back whenever I come back from vacation. --- Kimberly Smith [EMAIL PROTECTED] wrote: The way around that is to actually let them know what preventative stuff you did. I provide my manager with a weekly report and in there is a section called application maintenance and administration. I even put in there when I spend time with a developer showing them some SQL or PL/SQL tricks. Now, my teammates think I do nothing. Even after I sit there for an hour helping them out. Just cause I do my job right the first time and there really are no issues. But they don't really count. -Original Message- Sent: Tuesday, November 06, 2001 7:50 PM To: Multiple recipients of list ORACLE-L O my $0.02 the problem is, if we do our jobs properly, they don't have problems. And if they don't have problems they figure nothing ever goes wrong with the database, why do I need the DBA? except of course, that the reason nothing goes wrong is because we catch it before it happens. Catch-22... if we do it right they don't think they need us, if it breaks they scream that we should have found it before it happened and prevented it --- Sujatha Madan [EMAIL PROTECTED] wrote: I totally agree with Martin. Any company with an Oracle DB that's worth it's salt, needs a proper DBA!!! A lot of big companies
RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4
Robert, Maybe, maybe not. If someone on this list can give me a lead to a position in northern Colorado, then the extra exposure would be more than welcome. I was laid off a couple of weeks ago and I'm finding DBA jobs in this area hard to come by which is a completely different situation than what was happening just ten months ago. Randy Kirkpatrick (303)772-7467 resume: http://resumes.dice.com/randywk -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4 Yet surprisingly naive in the use of Internet lists :-) -Original Message- Sent: 31 October 2001 01:00 To: Multiple recipients of list ORACLE-L Bill, I'm a 3 year DBA with SAP Basis, NT Admin, and Unix admin experience. If you come across something in Northern Colorado, please let me know. I'm available immediately. Randy Kirkpatrick (303)772-7467 My resume is at http://resumes.dice.com/randywk. -Original Message- From: OraStaff [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Subject:Certified Oracle DBA Needed in Little Rock Arkansas area-4 Great company in Central Arkansas (45 minutes outside of Little Rock-the capital) needs an Oracle DBA to join its' I.T. staff. This company is currently running Oracle 7.3 and 8.0 on VMS and 8.1.5 on NT.. migrating to 8.1.7 on UNIX platforms. Since most of their employees live in Little Rock and make the commute, this company offers a 4 day/9 hr a day work week. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - 3+ Years Oracle DBA experience - Leadership skills and/or experience - B.S. in Computer Science or related technical discipline. - Oracle DBA certification - U.S. citizenship or Permanent residency is also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary-D.O.E., but in the 80K range. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Little Rock/DBA Leader/Kari All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Randy Kirkpatrick 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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
RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4
Bill, I'm a 3 year DBA with SAP Basis, NT Admin, and Unix admin experience. If you come across something in Northern Colorado, please let me know. I'm available immediately. Randy Kirkpatrick (303)772-7467 My resume is at http://resumes.dice.com/randywk. -Original Message- From: OraStaff [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Subject:Certified Oracle DBA Needed in Little Rock Arkansas area-4 Great company in Central Arkansas (45 minutes outside of Little Rock-the capital) needs an Oracle DBA to join its' I.T. staff. This company is currently running Oracle 7.3 and 8.0 on VMS and 8.1.5 on NT.. migrating to 8.1.7 on UNIX platforms. Since most of their employees live in Little Rock and make the commute, this company offers a 4 day/9 hr a day work week. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - 3+ Years Oracle DBA experience - Leadership skills and/or experience - B.S. in Computer Science or related technical discipline. - Oracle DBA certification - U.S. citizenship or Permanent residency is also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary-D.O.E., but in the 80K range. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Little Rock/DBA Leader/Kari All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Randy Kirkpatrick 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: New Oracle Install and Old Data Files
The datafiles contain the tablespaces which contain the data for the tables, indexes, etc. If she has all the datafiles, then she'll have access to all the data. I haven't tried it, but this should work for the system tablespace as well. Randy Kirkpatrick -Original Message- [EMAIL PROTECTED] Sent: Monday, October 29, 2001 7:00 AM To: Multiple recipients of list ORACLE-L But does she just want the old tablespaces or does she want the tables and indexes that were in those tablespaces? I don't think that simply recovering the tablespaces will recover the tablespace contents, though it is the way to start. Doesn't Oracle have a recovery tool -- pay big bucks, they come in and recover your database and then remove the tool -- that will do this? Randy Kirkpatrick To: Multiple recipients of list ORACLE-L randywk [EMAIL PROTECTED] @usa.netcc: Sent by: rootSubject: RE: New Oracle Install and Old Data Files 10/26/2001 09:00 PM Please respond to ORACLE-L Regina, Yes there is - but you probably don't want to do it yourself if you're not a DBA ... do a backup control file to trace: alter database database backup controlfile to trace; shut down the database and modify the sql in the file you created so it contains the information for the tablespaces you need. use the sql file to start up the database hopefully everything starts ok. Can't guarantee what happens to integrity, etc. if you don't have all the tablespaces. Randy Kirkpatrick -Original Message- Harter Sent: Friday, October 26, 2001 5:10 PM To: Multiple recipients of list ORACLE-L Okay People, I am not the DBA and don't have all the details but this is our situation the way it was explained to me: We had a server crash to the point where Unix and Oracle had to be reinstalled, however the disks containing our data tablespaces (that is, everything but the system tablespaces) are still good, and apparently for several reasons, we have not had a good backup for at least a week. Is there anyway to get a new Oracle install to recognize old tablespaces? TIA, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Randy Kirkpatrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Randy Kirkpatrick 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 ODBC Drivers ???
Faiz, I've often run into problems with Microsoft's ODBC drivers. Use drivers from Oracle. The error message sounds like a permissions problem but ... the driver shouldn't be referencing RDB so it sounds like you're using the wrong driver anyway. Get the Oracle driver from your client software CD or download it from http://metalink.oracle.com (as long as you have an account - and you should or someone in your company does). Randy Kirkpatrick home: (303)772-7567 mobile: (303)885-2102 -Original Message- QURESHI Sent: Saturday, October 27, 2001 6:10 AM To: Multiple recipients of list ORACLE-L Hello All: When I am trying to connect using ORacle's ODBC Drivers I am getting the following error . I am using Oracle 7.1 database. Microsoft's ODBC Drivers for Oracle does not work. Any help would be appreciated ? SQLSTATE : S1000 NAtive Error Code:-2003 Driver Message:[Oracle][ODBC][Rdb] Connect Ret 0 Err#10061 WSAECONNREFUSED Connection refused Thanks Regards, Faiz _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FAIZ QURESHI 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: Randy Kirkpatrick 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: New Oracle Install and Old Data Files
Regina, Yes there is - but you probably don't want to do it yourself if you're not a DBA ... do a backup control file to trace: alter database database backup controlfile to trace; shut down the database and modify the sql in the file you created so it contains the information for the tablespaces you need. use the sql file to start up the database hopefully everything starts ok. Can't guarantee what happens to integrity, etc. if you don't have all the tablespaces. Randy Kirkpatrick -Original Message- Harter Sent: Friday, October 26, 2001 5:10 PM To: Multiple recipients of list ORACLE-L Okay People, I am not the DBA and don't have all the details but this is our situation the way it was explained to me: We had a server crash to the point where Unix and Oracle had to be reinstalled, however the disks containing our data tablespaces (that is, everything but the system tablespaces) are still good, and apparently for several reasons, we have not had a good backup for at least a week. Is there anyway to get a new Oracle install to recognize old tablespaces? TIA, Regina -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Randy Kirkpatrick 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).