Re: Oradim & Certification

My .02$ on oracle certification:
I had originally planned to go for the DBA certification but have found myself sidetracked into the developers track. I studied for about 80-100 hours over two weeks (My wife is VERY supportive and understanding!!) with the class material for Forms I and the STS software(full version). I passed the test easily and have come up with some things that the more experienced programmers in the office weren't aware of / didn't remember. The reason I did it that way was so I would only know the oracle methods for performing a certain action. There are a great many ways to do the same thing but on an Oracle test they want the Oracle answer. In my opinion, experience can hurt you for the test in these cases. I work with a programmer that completely shuns the wizards in Reports.(I am taking the test on Wednesday) He would have absolutely NO chance of passing the test without a great deal of study (we will see Wednesday how well I do with no report experience) but he can do much more with the tool than I can at this point.

My point (and yes I do have one) is that you should if at all possible get the oracle class books to study from. The test I have taken seem to follow them very closely. They will make your life much easier and give you the Oracle methods that the test is looking for. I have two of the big red OCP manuals and neither goes into anywhere near enough details for me to be comfortable taking a test. Having a machine to practice on will help tremendously. I also can not recommend the STS software highly enough. ( You can usually find all 5 test on Ebay for 50$. ) It is an accurate representation of the actual test and will help pinpoint areas you need to study. If you can get these two or three items I believe you should be able to pass the test with about 2 -3 weeks preparation for each.

Rexbone <rexbone_at_talk21.com> wrote in message news:993mdh$eei$1_at_neptunium.btinternet.com...
> New to this list and am about to embark on getting my Oracle DBA
> certification so will probably end up asking u lot some daft
> questions, but hopefully i in turn can help others out soon. To start off
> with i have a couple of queries the first about certification and the
> second about oradim.
>
> First...
> Been working with oracle for about 2.5 years as a developer and
> touched on DBA stuff having done a 1 week hands on course some
> time ago not having strained myself it's now time to get my nose
> amongst the books and i would like to ask you how long do u think
> it should take an average joe to complete the DBA certification
> doing evening study 5/6 times a week for a couple of hours? If you
> can't relate to this how did u do the certification and has it improved
> your ability/job lot in the market, ?
>
>
> Second...
> Having created the service and instance successfully, i think? but
> where is the log file to verify this, tried to look in my
> oracle_home\rdbms but no log file, am using 8.1.6 server. When i
> run oradim to create a service and instance, does it do it
> immediately or do i have to reboot? Can i take it that an instance is
> running in memory? Oradim confuses me! Have tried... D:\>oradim - shutdown
> -sid fistsid -usrpwd system -shuttype srvc,inst -shutmode i DIM- 00018:
> Failed to stop Oracle Service O/S-Error: (OS 1060) The specified service
> does not exist as an installed service.
>
> Cheers
> Rex
>
>
Received on Mon Mar 19 2001 - 09:01:34 CST