This discussion is archived
13 Replies Latest reply: Dec 13, 2012 12:10 PM by NickRobheart RSS

Basic question

NickRobheart Newbie
Currently Being Moderated
Hi,
I'm a DBA aspirant and know what contents I have to cover for DBA course. As I being novice had to cover some prerequisites from Linux and SQL, however quite not sure what basics really required on Linux/SQL to fulfill the course.
So my question is what are the basic contents required in Linux/SQL to get a good command over the subject?
Any information is appreciated.
Thanks in advance
  • 1. Re: Basic question
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Well Reading is good Start , Oracle Documentation lot of example about SQL , and there's courses for Linux Command and online Tutorial that you can use them for free , Add to this There's Course called Linux For DBA (Or Something Like this). Search On Google Will Give lot of option .

    Linux :
    http://bit.ly/P7vbGi

    SQL:
    http://bit.ly/P7vfG3
  • 2. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    Hi, getting information on source codes and commands for both Linux and SQL is fine. For the learning part, will it have to be just system basic commands being required or whether or not going into advanced learning is required?
    For example: As in Linux, we do have System Administrations commands or permissions sort of (or) just basic commands to get a hold of it
    Thanks
  • 3. Re: Basic question
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    at first beginners command is enough but you need to know exactly how to use these command and make sure how to use them , such as ls , mkdir , cp , mv , ssh , ftp , .... after while from start using these command you by yourself you will getting board and try to learn something new ... actually command not just to save them and i will use them when i need you need to use them to know when you will need them . this is easy to save .
  • 4. Re: Basic question
    Marco V. Expert
    Currently Being Moderated
    I would suggest you to download, install and do practice with a virtualized environment: a good starting point could be this link
    http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

    In my old company I had also root pwd to access my machines, but I used it for system administrator and not for database activities.
    When I needed it I simply access into my Linux box using my Oracle account.
    It's always recommended to use the less privileged user.

    On my current company I have only oracle account and some sudo privileges.
  • 5. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    Thanks for the prompt response. Definitely appreciate the links shared .
    Also have a quick question, did find the download for 11g from source: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

    But couldn't find the download link for 10G Release . Can you help me with it if you find it ?
  • 6. Re: Basic question
    rp0428 Guru
    Currently Being Moderated
    >
    But couldn't find the download link for 10G Release
    >
    There isn't one. Only the latest version of the database is available for download. Why would you even want 10g? That version has be out of scope for several years now.

    If you need an earlier version you have to contact Oracle support.
  • 7. Re: Basic question
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    If you need to download 10G you should Open SR .
  • 8. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    Thanks for the prompt responses
  • 9. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    This thread is answered though but using the same for few other questions in my mind which needs to be cleared.
    Hope no one mind if I continue.

    I have got my Oracle licensed training eKit 10g WorkshopI and WorkshopII pdf files from Oracle today and everything seems legit.
    My question was, will 11g also be available as an eKit fom Oracle for an ask ?

    Also another question is, I'm in process of 11g OCA preparation first and so Workshop-I is mainly for OCA (which includes both SQL Fundamental 1 and Admin I )
    and whereas Workshop-II (which includes Admin II paper) is solely for 11g OCP right ?? Did I get the process/names right for my understanding ?

    Source: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:Datab11g
  • 10. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    A gentle bounce !
  • 11. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    Need few more questions to be answered . Thanks in Advance,
  • 12. Re: Basic question
    EdStevens Guru
    Currently Being Moderated
    NickRobheart wrote:
    Need few more questions to be answered . Thanks in Advance,
    Patience, Grasshopper.

    YOur "gentle bounce" went up in the middle of the night for the entire Western hemisphere.
  • 13. Re: Basic question
    NickRobheart Newbie
    Currently Being Moderated
    Glad, but would have appreciated if it was an answer to my question :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points