DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Unix Shell v.s Oracle

  1. #1
    Join Date
    Oct 2000
    Posts
    25
    Santosh, sudip:

    Thank You soo much for the responses~~ it helps a lot.
    Those are greate Shell Scripts links!!! However, I am still wondering How
    to learn using Sehll Scripts to Administer ORACLE from ground up. I already have
    some Background in RDBMS, Data Modeling, ORCLE 8 DBA / Architechture and
    Basic Unix Commands. But How to integrate my knowledge into Unix Shell Scripts.

    Anyone have any advice on where to start?

    Thank you very much~~~~~~


    = D


    in order to benifit other members, following are the previous responses:
    ========================================

    Hi

    Try the following links for Shell scripts and some Info about scripts

    http://orafaq.com/faqscrpt.htm#UNIX

    http://dbasupport.com/oracle/scripts/Detailed/120.shtml

    http://www.bijoos.com/ora7/oracle_unix.htm

    http://www.uaex.edu/srea/#Oracle%20Scripts

    Hope this helped

    Regards
    __________________
    Santosh


    05-29-2001 12:05 AM IP: Logged

    sudip
    Member

    Registered: Feb 2001
    Posts: 147
    I read somewhere that there is book from O'reilly publication called "Unix for DBA's" Pocket edition.
    Heard it is good.
    Cheers

    Santosh Thanx for your links
    __________________
    There Nothing You cannot Do, The problem is HOW.


    05-29-2001 04:18 AM IP: Logged


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Start with the korn/borne shell scripts. First familiarize yourself on using ps, ls, sed, awk, grep, mail and etc. Then write small scripts, that would return some results. Then include some conditional statements like, if then, case and etc and build that basic code. Then Once you become familiar with then go for the loop structures and etc. Once after getting familiar with these, try writing some scripts that would loginto oracle and do some simple queries and format the results and send you a mail on the results and etc. Then you would start to role smooth.

    Hope this would help

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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