Lost in Space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Lost in Space

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Lost in Space

    Hi Folks,

    You are hired as a DBA for an Oracle 8.1.7 database on Solaris. You are new to Unix. The system admin is on sick leave for a week.
    What type of unix commands should you be using just to check the database?

    I already setup my laptop to talk to the database but I wanted to access the following on the box.( I know I am getting some Unix books)
    but just need some quick commands to do these things.
    How do I get to the
    -Alert log
    -Init.ora...(That I can get to it from the command line) but need to access that on unix box.
    -Check datafiles
    -Check tablespaces

    Any recommendations and advice are welcomed
    Thank you
    Last edited by Ablakios; 10-22-2004 at 03:41 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    cd /path/to_whatever (a lot like DOS)

    cd $ORACLE_HOME/rdbms or whatever

    What are you environment variables?
    env|more

    What from Oracle is running on the box?
    ps -ef|grep ora

    How to become the user 'oracle' (or whatever the name is)
    su - oracle

    Where is the home directory for 'oracle'
    As oracle, just enter cd and hit return, then enter pwd

    You can also look in /etc/passwd to see oracle's home directory

    Where the files are:
    same commands in SQL*Plus as you use on Windows

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    I reccomend "Unix for Oracle DBA's" an O'Reilly handbook that is about $8. Start creating aliases and learn some basics, this book will get you there and you can breeze through it in a day.
    I remember when this place was cool.

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    The ones on my bookshelf are:

    Oracle9i UNIX Administration Handbook
    UNIX Shell Programming
    UNIX Power Tools
    Solaris 8 The Complete Reference
    Instant UNIX
    UNIX in a Nutshell
    UNIX Made Easy

    Holy cow, with that many UNIX books, I just realized I'm on the verge of being a UNIX geek. Gotta remember that the upshot is "Chicks dig UNIX."

  5. #5
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Guys
    I thank you all for the input and your prompt response.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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