Re: New born DBA.....
Hi ! Welcome to the world of DBAs. And you have got some good suggestions too.. This mailing list a good place to ask questions (and get answers). Read Kevin Loney and Rama Velpuri. The titles are Oracle 8i DBA Handbook and Oracle 8i Backup and recovery hand book. Religiously try all the backup/recovery case studies. You will become master one day.. :0 Read Oracle Documentation. It has plenty of information in it. Espicially Oracle Server Concepts and Performance Tuning Manuals along with Backup Recovery manuals. Read the mails/newsgrups. It is nice place to simulate experience. There is another DBA listserv also there. Subsribe to both the lists and brose the mails. Read ***ALL** mails from Steve Adams, John Kanagaraj (Where is he now a days), Gaja Vaidyanatha, etc.. ( Use the mailbox message rules (or fileter rules!!) for better spam control. I have few message rules which redirects some mails to TRASH based on the sender.(May be able to give the list offline..:) And here are few websites.. http://www.orafaq.org http://www.ixora.com.au http://www.jlcomp.demon.co.uk http://www.lonyx.com Wish you all the best !! = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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 born DBA
shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) Question for the authors here (offline responses ok): with book-writing for technical issues, are these usually work-for-hire affairs or royalty-based? I ask as a DBA who does a small amount of (travel-related) freelance writing on the side. With the relatively higher price tag of technical books but lower number of sales, e.g.: SELECT count(*) from BOOK_SALES where SUBJECT = 'DATABASE ADMINISTRATION'; SELECT count(*) from BOOK_SALES where SUBJECT = 'PERSONAL FINANCE'; Which works out better for technical authors? Work-for-hire (flat one-time fee, publisher purchases the copyright) or royalties? My guess is work-for-hire unless the royalties are a generous percentage of list price (versus net). I've heard co-authors of technical books receive as little as USD (or should that be USC) 25 cents a book when royalties are paid. Thanks. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana 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 born DBA.....
Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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 born DBA.....
Also there is a book by Heidi Thorpe Oracle 8I Tuning and Administration where there is a big chapter about database monitoring. Alex Hillman -Original Message- From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:20 PM To: Multiple recipients of list ORACLE-L Subject:Re: New born DBA. start by reading the administrators guide and welcome to the world(Dr DBA slaps the bottom side of the newborn) :) joe Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New born DBA.....
Here is a quick list: Daily checks - Oracle Alert file logs - system resources - backups - archive logs - error logs Weekly checks - free space in Tablespaces, Tables, Indexes and Clusters Monthly checks - fragmentation in Tables, Indexes and Clusters Ben Poels Queen's University -Original Message- Xing Sent: Tuesday, March 27, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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 born DBA.....
You could also download and use the following checklists which are always handy to refer to when starting up: http://www.geocities.com/tbcox23/dba_checklist13.doc http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf Good luck on that HUGE rollercoaster of a learning curve ORACLE!! HTH Mark -Original Message- William Sent: Wednesday, March 28, 2001 01:26 To: Multiple recipients of list ORACLE-L Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: 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).
Re: New born DBA.....
Check out First Steps on our site. -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 1:45 AM Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). -- 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).
Re: New born DBA.....
start by reading the administrators guide and welcome to the world(Dr DBA slaps the bottom side of the newborn) :) joe Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).