I am sarting as junior dba today
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: I am sarting as junior dba today

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hello
    Thanks for this site and the people involving in this site .
    I want to know what are all the steps i need to follow in sequential manner .
    I will be working on unix operating system and sunsolaris as server .

    please let me know the steps and so on..

    Thanks
    lnreddy
    html code is off

  2. #2
    Join Date
    Feb 2001
    Posts
    66
    Big Congrats, Inreddy!
    For the steps, your boss must gave to you a plan or someting
    task list, if not, you spend like me the time looking on internet for big money, since december 2000, I waiting for steps.

    Wish you best luck on your new job!

  3. #3
    Join Date
    Feb 2001
    Posts
    114
    Good luck to you, Reddy !!

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    If there are some Sr. DBA, ask some work to do
    from them.

  5. #5
    Join Date
    Feb 2001
    Posts
    41
    its on hell of a job as dba.
    work is never a bowl of sweet cheeries.
    Best Regards,
    Harsh Shah

  6. #6
    Join Date
    Jan 2001
    Posts
    60
    Hi
    Thanks to all of u guys .
    I want to know the steps to proceed .
    i want main scripts
    Thnaks
    lnreddy
    html code is off

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Get to know your database structures. Number of instances that are currently running on your site. What are the depending applications and how cretical their functionality to your organization. Know the tools they us to monitor the database and get some aquaitence with them. Always keep a note of what you do? If u have to delete/update/drop any record/table/schema, always double confirm it and make a temp copy of it such that you would not land into problems in case of mistakes. Then the location of your backup scripts and the type of backup they do. Always be ready to involve in the disaster recovery process. Talk to your DBA regaring the methodologies, and the company practice. Get to practice the recovery process in your test database atleast once a month. Talk to your dba, find out how they get the system alerts, and if there are some mailing list, make a request to add you in that. Check the alert logs of your instance for any possible problems. Know your oracle support CSI/username and password, so that you can go and create tar in case of emmergencies

    I know it is too much to know, don't worry, if it is going to take some time.

    Congratulations! and good luck.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Feb 2001
    Posts
    53

    Wink

    Don't sweat it, you're do just fine. You should be thankful that you have someone to work with. I just got promoted to a DBA gig myself last month, but the sad part is, I'm the only Oracle guy here, and our support with Oracle is non-existant.

    Here's what I have been doing.
    del, drop stuff left and right, and then try to recovery it backup, and if I have trouble, then I come to this forum..hehehe

    here are some of the books I bought with my own money..
    1. Oracle Scripts O'Reily
    2. Oracle Database Admin O'Reily
    3. Oracle8i dba handbook Kevin Loney
    4. Oracle database admin Neol Yuhanna
    5. OCP oracle8i study guide

    if there is something that is good material to keep, let me know guys.

    good luck.

  9. #9
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Hi!
    Listen to What sambavan has to say. He has spoken THE CORRECT thing.
    All the Best to you.

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    This is a compiled version I have collected from this forum from July 2000 about DBA duties and DBA in new shops


    Oracle DBA Daily duties

    DAILY ACTIVITIES :
    · Monitor disk space usage.
    · Monitor CPU usage and kill hanging process
    · Monitor disk I/O activities
    · Check database errors in alert.log file
    · Check Users' login
    · Monitor network error in listener. log file
    · Monitor SQL*Net connection error in SQLNET.LOG
    · Monitor RMAN backup
    · Monitor cronjob errors
    · Monitor users’ errors in bdump/cdump/udump directory
    · Monitor unix messages in /var/adm/messages file for the Disk Array and memory errors
    · Monitor cpu usages by using sar command
    · Run vmstat command to list out virtual memory usage
    · Run ps command to monitor unix processes
    · Run appropriate SQL command to monitor free space in all tablespaces with in database and page it to email account
    · Run appropriate SQL command to monitor rollback segments contention.
    · Run appropriate SQL command to monitor sort area sizes in temp Tablespace
    · Run appropriate SQL command to monitor data buffers so that at least 90 % cache hit ratio can be maintained and send email.
    · Run appropriate SQL command to monitor library so that at least 90% cache hit ratio can be maintained and sends email.
    · Run appropriate SQL command to monitor row cache so that at least 99% hit ratio can be maintained

    If you have standby DB,
    · Check for any error in UPDATING STANDBY DATABASE

    If you do hotbackup,
    · Check for any error in HOTBACKUP




    Oracle DBA duties in a new company

    . List hardware & software vendor, contact phones & E-Mail
    . Machine hardware configuration such as, number of CPU, memory, number of disks. Mirrored? Striped disks? Clustered?
    . Find out if there are any test machines, possible to test any procedure (backup & recovery for example) in any test machines? Essential to ablecarry out tests in test machines
    . How is the database being used, with what applications (any ERPs, E-Commerce, E-Business), how many instances, one per application?
    . Hybrid database?
    . How many users? If the enviroment is Web Based monitor the database for a couple of days
    . Check backup strategy. What software is used, Veritas? RMAN? Suggestion, integrate RMAN with Veritas, if possible Veritas volume manager. What happens if the system goes down, Standby database or Advanced Replication?
    . Uptime, 99.9%, 99.99% or 99.999% of year. 525 minutes, 52 minutes or 5 minutes per year
    . Check database structure:
    Datafile locations, striped at OS level or database level?
    Redo Logs locations, multiplexed?
    Control fileslocations, multiplexed?
    . Check Tablespace, Datafiles free space
    . Backup controlfile to trace then check the parameters in the trace file. Such as MaxDatafiles
    . Check dump directories
    . Check initSID.ora, get a print out
    . Check shellscripts, and PL/SQL scripts if any is used. Try to understand as much what do they do
    . Keep logs of what you have done, everytime youhave hadto modify databaseconfiguration
    . Prepare a list of DAILY ACTIVITIES, WEEKLY ACTIVITIES, MONTHLY ACTIVITIES
    . Prepare ERD of the database to help understanding of the system
    . Have a talk with the old DBA and the developers to see if there are any potential problems they have faced
    . Be a good listener
    . Finally after gathered all necessary information plan a perfomance tuning


    Appropriate SQL commands may be scripts or manually



    [Edited by pando on 03-01-2001 at 02:50 AM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width