Oracle DBA Corner

No worries. Just keep this thread alive and pass on anything you learn.
If you need anything else holla

hi Le Moor, thanks for your awonderful contribution, it was really thoughtful of you assisting  young dbas like us(me).
dd my certifications, mcp and ocp in NIIT, but yet to have hands on exp, pls i need your assistance on being a seasoned dba,
having a lot of passion for it.
i wouldnt mind any book you can offer as promised to other folks in the house.((Physical, and logical database, design. entity relationships etc)
i developed myself in linux, apart from windows, and sun solaris.
again whatever assistance that can be rendered to be a succesful dba, thanks
my email is:
olumideking@yahoo.com

please i need help

i was trying to install oracle 10gr2 on an oracle enterprise linux os. when i entered runInstaller, it responded with command not found.

i had "cd" to the database directory in the oracle installation.

please does anyone know the reason and what i can do.

Any Updates?
A little feedback would be nice

If you check my earlier posts. I mentioned I don't have OCP (certifications) material. Whilst I appreciate and understand why a lot of pple go thru the certification route, I personally believe a hands on experience beats certifications any day. i will sooner give my databases to a college drop out with experience that to someone who has 5certifications, but hasnt done a day of real life DB administeration.

But with that said, I will answer your question. Without trying to sound cliche. The key to being a good DBA is common sense application and due diligence. Do not be afraid to break stuff (I mean stuff  in test environments not production). You just need to keep practicing on real databases  and you can use books as a back up. What you will learn in 1month on the Job in a real life oracle environment, you cannot read it up in a year. Because theyare just very different scenarios and the books paint an ideal environment. Something any experienced DBA can tell you couldn't be further from the truth. There are simple questions I can ask anyone purporting to be a dba, that will show if the pereson has just being reading books or if they have handled a database in real life. I need to know that if my database goes down for some reason at 2am, I have some one that can recover the database 'by any means necessary' and have it up and running before business resumes the following morning. And if it is in a High Availability environment, then I need to know my standbys can be used whilst my 'primary' database is being recovered.

Finally, this might not seem like a very sound advice, but the key to been a good dba is to 1st get your foot into the door. even if it means the monetary returns are not immediately gratifying. if you have the requisite experience, the money will come. I dont know how much dba's earn in Nigeria anymore, but I can tell you the average salary for a good dba with 3-5yrs in the US goes from anywhere between $65 - $85 per hr. I know of instances  where people have been brought in to handle disasters for $125hr.

Now, u forgot to give me your email. if you are just starting out. I think I have some materials that might be useful. If you do find it useful let me know, I will get you more. p.s I am not charging anyone anything for any materials I give them. All I ask is that, when someone comes to you with the same request, you should also share any knowledge you might have gained along the line.

Sent yo uan email.
Holla if you have any questions

Cool.
Let me know if u come across any issues you might need someone to explain to you,

biggbrovazz@yahoo.co.uk is my addy

One more question: How much of PL/SQL does a good DBA need to know especially when it comes to scheduling jobs or automating tasks

Thanks LeMoor. the reason was that i had spaces in the path to the oracle database installation directory.

However a new issue came up as runInstaller responded with "unsupported operating system". i using oracle enterprise linux and i thought oracle 10g for linux would run on it since they were from the same vendor.

can i use tweaks or fixes to solve this.

Hello le Moor,i want to get into learn how to use linux os,i have downloaded 1 or 2 books online and was wondering if u could give me a few pointers,was thinking of formatting my harddrive and then partitioning so i can reinstall windows and oracle unbreakable linux or another version of linux,i have basic idea on how to go about it but i hear u need like a partition software?anyway i would like to hear from you regarding this, thanx again and GOD bless

i use a toshiba satellite centrino duo core,120g hard drive,1.5 G ram.

@Le Moor
Thanks for the tips i guess the power of EM really has the ability to make a DBA lazy that tool is just too powerful my PL/SQL is still a work in progress but the schedulers are a bit better for me its not so hard for me to remember the codes.
Have you mailed me yet?

partition magic is best. i use it. you partition your hard disk. you will however have to configure dual booting if you want to to use your windows and your linux. if it is the windows boot loader you prefer then don't install grub to the master boot record

@Le Moor
I understand you are busy i will be expecting your mail.Lol i cant wait to start handling some of these deadline projects

Yeah thats true but it can save you from remembering a lot of codes that ordinarily you wouldnt be able too

@chuckvyl
Did he mean SQL Server and an Oracle RDBMS? of course you can run them  both on a system

hello all
i am ocp and mcdba,though with a lotta theory and no job experience jus got job with a software dev company in ikoyi.

will like everyone to give tit bits on what to expect


thanks

hello Le Moor,i have got some issues, not me anyway my database, i tried to open  enterprise manager and it would not open, so i went to command prompt and typed  emctl start but it gave me a message saying environment variable not set,set  oracle_sid ,so i set the oracle sid as orcl, after that it stll gave me a message saying EM CONFIGURATION ISSUE C:\oracle\product\10.1.0\Db_1\jimspc_localhost_orcl  NOT FOUND,i run oracle on windows xp,so what do i do? i also went to  services and tried starting oracledbconsoleorcl but it wouldnt start, so what now?