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
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 .
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
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 .
I would suggest you to download, install and do practice with a virtualized environment: a good starting point could be this link
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.
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 ?
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.
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 ?