@azum,

I found d resource u suggested. many thanks. But b4 then I had earlier tried to remove d oracle software manually n d result b say I messed up my system. I can't succesfully remove it now , thus I can't re-install. I have oracle 10g on Solaris n 4 nw thats d one am using

jabbok:

@azum,

I found d resource u suggested. many thanks. But b4 then I had earlier tried to remove d oracle software manually n d result b say I messed up my system. I can't succesfully remove it now , thus I can't re-install. I have oracle 10g on Solaris n 4 nw thats d one am using

Yes you definitely can.
If you have manually started to uninstall it, then complete it that way. All you need to do is to clean Oracle out of your system. It is tricky though, but you can complete remove Oracle from your system by using the REGEDIT. Let me know if you want to go that way and i will gladly write down the steps for you. It is tricky because if you dont do it carefully, you will screw up your Operating System, and will need to re-install your OS.

But let me know and i will write down the steps to follow.

hey guys! its been a while now, Le Moor and hey azum welcome to the dba corner even though i have not been posting for a long time now, but he i am back now, @ azum do ou haveany materials on pl/sql? as in i need to start from scratch again so thank in advance @ jabook what you encountered on enterprise manager happened to me on a windows o/s and i sovled but i dont knowwhere i kept the report but i f u check some of my earlier posts from last year you are sure to find it and i wonder why EM keeps doing that, any idea guys?anyway take care and God bless
oh that oracle mentoring corner is a good idea azum and also a pl/sql mentoring corner would suite me and anyone else just fine too

jimblaze:

hey guys! its been a while now, Le Moor and hey azum welcome to the dba corner even though i have not been posting for a long time now, but he i am back now, @ azum do ou haveany materials on pl/sql? as in i need to start from scratch again so thank in advance @ jabook what you encountered on enterprise manager happened to me on a windows o/s and i sovled but i dont knowwhere i kept the report but i f u check some of my earlier posts from last year you are sure to find it and i wonder why EM keeps doing that, any idea guys?anyway take care and God bless
oh that oracle mentoring corner is a good idea azum and also a pl/sql mentoring corner would suite me and anyone else just fine too

Thanks Jimblaze for the welcome. I do have loads and loads of materials on virtually any topic in Oracle, This is so because i found out long ago that the only way to make a way is to read, read and read more. This field is for ever changing. Some of these materials are proprietary from some of the places i have worked before though. So let me know exactly what you're looking for and i will see if its among what i have.

@azum,

please kindly give me d steps as it regards using REGEDIT.
Many thanks

jabbok:

@azum,

please kindly give me d steps as it regards using REGEDIT.
Many thanks

Here you go:

1. Start -> Run
2. Type Regedit in Run. This opens up a new window, The Registry Edit Window
3. Expand the HKEY_LOCAL_MACHINE folder
4. expand the SYSTEM folder
5. you will see the CONTROLSET group of folders and the CURRENTCONTROLSET folder. There are 3 of them
6. in each of these CONTROLSET folders open the SERVICES folder
7. In the SERVICES folder delete any key starting with Oracle. When you try to delete these keys you will be asked to confirm the delete. Confirm the delete and the keys will be permanently deleted.
8.Then go to the SOFTWARE folder still in the HKEY_LOCAL_MACHINE
9. delete the ORACLE key there
10. go to the HKEY_CLASSES_ROOT folder
11. Delete any key starting with ORA

After you complete the steps above delete the Oracle folder from the C:\ drive. Then reboot your system. Once your system comes back up check and you will realise it is has been cleaned out of Oracle Software. You can now conveniently re-install Oracle.

NOTE: PLEASE BY CAREFUL AS YOU NAVIGATE THE REGISTRY OF YOUR SYSTEM. A WRONG STEP WILL CAUSE YOU TO HAVE TO REINSTALL YOUR WINDOWS OS.

anyway, if you are on yahoo messenger let me have your email address. i can add you to mine and work you through these steps.

@azum,

thanks u can add me, the email na xxxxxxxxx@yahoo.com. I will b xpecting 2 meet u online soon

Many thanks

hey azum, i would love anything on PL/sql programming from the basics really, like pl/sql fundamentals, thanks and i will send my email when you are ready

jimblaze:

hey azum, i would love anything on PL/sql programming from the basics really, like pl/sql fundamentals, thanks and i will send my email when you are ready

Send your email and will see what i have.

I need to know How much of PL/SQL does a DBA really need to know??
Thanks

jabbok:

I need to know How much of PL/SQL does a DBA really need to know??
Thanks

A hard question to crack. Honestly it all depends on the individual. I have worked with DBAs who can hardly write or debug a simple code of SQL. I have also worked with DBAs who are gurus in SQLs. I started out originally as an Oracle Developer before changing course to become a DBA so that may account for whatever knowledge i have of SQL & PL/SQL. My take is that no knowledge is lost. I love being on top of things as a DBA and as such i tend to have good knowledge of what is happening around me than is necessary for the ordinary DBA to know.
As a Production DBA you may make do with the basics knowledge of SQL and PLSQL. But as a Development DBA, you definitely need some sound knowledge of PLSQL to work with developers and programmers.

But all in all you definitely need some knowledge of SQL and PLSQL to become OCP certified.

hey azum how do i send you a personal message on this forum without everyone else seeing my email add?

jimblaze:

hey azum how do i send you a personal message on this forum without everyone else seeing my email add?

Unfortunately this forum does not provide room for PM - Private Messages.

Long time I been in here. Good to know peeps holding it down.

kudos Azum.

@all

Is there anyone proficient in the use of the oracle e-business suite?

CABALI,AZUM,JIMBLAZE,JABBOK , U shud come 2 my rescue , `ve bn an OCP since 2005 `vent really had a hands-on experience in the field but right now i really want2 go deeper, am thinking of ORACLE on UNIX n presently am having studies on linux/unix admin.
Am seeking for ur constructive advice on this from u guys,with respect to serious tutoring arrangements and `ve 2 say am really glad to see this kinda thread, BIG UPs,meN!!!!

I wont mind having ur contacts, THX my email add is ogbjeff@yahoo.com

jaffa:

CABALI,AZUM,JIMBLAZE,JABBOK , U shud come 2 my rescue , `ve bn an OCP since 2005 `vent really had a hands-on experience in the field but right now i really want2 go deeper, am thinking of ORACLE on UNIX n presently am having studies on linux/unix admin.
Am seeking for ur constructive advice on this from u guys,with respect to serious tutoring arrangements and `ve 2 say am really glad to see this kinda thread, BIG UPs,meN!!!!

I wont mind having ur contacts, THX my email add is ogbjeff@yahoo.com

@Jaffa, just sent you an invite on YM.

cabali:

Long time I been in here. Good to know peeps holding it down.

kudos Azum.

@all

Is there anyone proficient in the use of the oracle e-business suite?

@Cabali, I have done some e-Business Suite DBA job? So maybe i might just be able to answer your question or in a worst case scenerio direct you where you can get info. So shoot.

@ azumok my yahoo ad is jimblaze_au77 so pls send any thing about pl/sql and to jaffa just keep on reading and try and try and find a place to get some hands experience even if you dont get paid for now. also subcribe to oracle magazine its free and hey cabali long time

jimblaze:

@ azumok my yahoo ad is jimblaze_au77 so pls send any thing about pl/sql and to jaffa just keep on reading and try and try and find a place to get some hands experience even if you dont get paid for now. also subcribe to oracle magazine its free and hey cabali long time

Just added you to my YM. Give me a few days to gather these materials together. Once i do i will let you know.

ok thanks i added you as well so i will be expecting it

jabbok:

I need to know How much of PL/SQL does a DBA really need to know??
Thanks

Ohh it does help a great deal to know your PL/SQL although its one of my least favorite parts of Oracle but hey you would need it to schedule your jobs access some packages make use of constraints like triggers or when you need to make calculations that your ordinary SQL code can't do i.e when you want to automate tasks and stuff it can be the difference between a good DBA and a great DBA.I can't stand PL/SQL though but i know its necessary

jimblaze:

@ azumok my yahoo ad is jimblaze_au77 so pls send any thing about pl/sql and to jaffa just keep on reading and try and try and find a place to get some hands experience even if you dont get paid for now. also subcribe to oracle magazine its free and hey cabali long time

What's good man? I am sure you must be earning top naira or is it dollars by now? Have you laid your hands on 11g yet?

A-40:

Ohh it does help a great deal to know your PL/SQL although its one of my least favorite parts of Oracle but hey you would need it to schedule your jobs access some packages make use of constraints like triggers or when you need to make calculations that your ordinary SQL code can't do i.e when you want to automate tasks and stuff it can be the difference between a good DBA and a great DBA.I can't stand PL/SQL though but i know its necessary
What's good man? I am sure you must be earning top naira or is it dollars by now? Have you laid your hands on 11g yet?

Honestly you dont need so much PLSQL to be a good DBA unless you are a Development DBA. To be a great DBA you need to know and master things like Performance Tuning, Disaster Recovery etc rather than PLSQL. And to be a Super DBA then you need to be a guru in one of the HA features of Oracle.
I am not doing much work in 11g yet because it is still the first release. Will do much when the second release comes out. The first release of any product is always bug full.
@Jimblaze,
Please go to www.ensips.com and open an account. Then send me the username and password so i can upload the PLSQL zip file for you. Can email it because of the size. Once you do that let me know.

@

azum:

Honestly you dont need so much PLSQL to be a good DBA unless you are a Development DBA. To be a great DBA you need to know and master things like Performance Tuning, Disaster Recovery etc rather than PLSQL. And to be a Super DBA then you need to be a guru in one of the HA features of Oracle.
I am not doing much work in 11g yet because it is still the first release. Will do much when the second release comes out. The first release of any product is always bug full.
@Jimblaze,
Please go to www.ensips.com and open an account. Then send me the username and password so i can upload the PLSQL zip file for you. Can email it because of the size. Once you do that let me know.

@

In some cases it does help i agree though that Performance Tuning,Disaster Recovery,Backup Management matter to a larger extent but then there are also scenarios where you would need your PL/SQL especially when you are dealing with Dynamic Performance Views and all its not just something you can really run from so you might as well be good at it as there are rarely jobs where you would not have to do some Development at one time or another

A-40:

In some cases it does help i agree though that Performance Tuning,Disaster Recovery,Backup Management matter to a larger extent but then there are also scenarios where you would need your PL/SQL especially when you are dealing with Dynamic Performance Views and all its not just something you can really run from so you might as well be good at it as there are rarely jobs where you would not have to do some Development at one time or another

Dont get me wrong. As a DBA it is good to know PLSQL. But except you're a Development DBA supporting developers, your need to use PLSQL is minimal. PLSQL is different from SQL. You dont need PLSQL to analyze the Dynamic Performance views. You use simple SQL to retreive data from views as a general rule. For the last 6 years as a DBA, i have no need to use heavy PLSQL. And i am talking about large databases in the magnitude of several terrabytes for large corporations that can not afford to be down for a second. I doubt if there is any environment in Nigeria that meets that criteria.
What i am saying is that there is more for a DBA to learn than PLSQL. DBA job is far more complex than what simple knowledge of PLSQL entails. If you're a DBA and use heavy PLSQL then you're simply a Development DBA. Or better still a Developer/DBA.

Azum,
Kudos on a job welldone. I like the way you are holding it down. Been very busy of recent, and i would also try and contribute as much as I can on this topic.

Great advice you have been giving here and I cannot but agree with all of them.

On the 11g, I spoke to an Oracle consultant/salesman recently and he said, the 11g is the first database that hasa been relatively bug free. Most of the features on 11g are features that Oracle had tested on 10.2.04 but refused to turn them on for commercial customers. So they had a relatively longer period testing it out. We have about 2 databases in 11g in test environments presently, and all I can say is, they are stable and a very big leap in the database 'self-managing' direction.

Also, Performance Tuning is the the core of most database requirements. The average user wants (either external on the street or internal within a company) do not really care how you store their data, all they want is to be able to retrieve or manipulate their data and get results in a timely manner (sometime even with unrealistic expectations giving the realities on ground). So as a DBA, providing the enabling environment is a key role. I have stated somewhere before also on this thread that PL/SQL is not a pre-requisite to be a good dba. it is an added advantage and knowing it definitely has a lot of advantages, but having a basic understanding and being able to get a general idea of the proc is usually enough for the average dba. Unless ofcourse it is a development support role.

I dont have time to log in too often, as I am away from my base now and cant log in during the day. But seeing how you have revived the thread has encouraged me.

Pardon my argumentative stance you are the expert here and i am still working my way up but most books i have read keep drumming the importance of having the ability to manage and use PL/SQL and its programs.I do think you are right on just about everything in your last post. I made a mistake with the dynamic performance views example what i actually meant was PL/SQL comes in handy when dealing with data pump export and data pump import programs and also fine grained auditing.
@Le Moor
Long time bro.How have you been?I do think it would be nice if this thread was revived

A-40,
I am cool. Been busy, our implementation went live in August last yr, and had to stay on to provide post go-live support. Everything is stable now and I have moved on to another place. WHich is why i havent been on here as much.

A-40, Azum
I think it might also depend on the way the environment is structured. I have seen environments were most if not all of the procedures are called from within applications sitting databases. Where this is the case, depending on the SLA, most of the time DBA's shouldnt be tuning application codes, u leave that to the developer .  Unless ofcourse you are allowed to tune application code in your environment (and for obvious reasons, this isnt a best case scenario). DYnamic Perfomance Views are basically views, but as the name suggests, they are being constantly updated. You only need SQL to query the views in itself and i am not very sure why you would need PL/SQL to access the this (but I would be the 1st to concede I dont know it all, and I could be wrong).
Also, the Datapump import and Datapump export are just faster than the traditional Import and Export utilities, but they are also basically hte same thing (think landline and Optic fibre for internet access. Same thing but different speed because datat is accessed and transported differently.)
This link gives a broad overview of the diff,
http://www.dba-oracle.com/t_differences_imp_impdp_import_data_pump.htm
Again if you are just transporting data across maybe schemas or even full database refreshes, I still do not see how a knowledge of PL/SQL is imperative in this scenarios.

With all these said, a knowledge of PL/SQL is DEFINITELY an advantage, and if you have a flair for it and are adept at it, it gives you an edge. As a DBA you will come across stored procedures, pl/sql, but you can also get by without it.

p.s it is good to be argumentative, we are all learning here.

hey guys, good to c that everyone is back in full force and no i havent used 11g yet but i hope to soon so kudos to a40,azum, le moor, cabali and all that have not let this thread die, may the Holy Spirit nourish our mental faculties for us to be the best Dba's in the world

@Le Moor,

Nice to have you back. The more we have here the merrier. Hopefully we can all learn from each other.

Thanks.

Felix

hey azum i cant find where to open and account on ensips.com? and A-40 whats cooking in the dba world?

@jimblaze
Amen bro its been a while though and its great rubbing minds with y'all steel sharpeneth steel and for now not too much is happening besides me waiting to try out 11G wrap up school and take a full plunge into the whole Oracle DBA world
@Le Moor
Yeah you told me about the project i figured it must have taken up your time.As for the PL/SQL debate i did gain a lot from you and azum i dont intend on dabbling too much on development so im just willing to do what it takes to be a great DBA on the data pump export and import example you would agreee with me that the quicker you can move tablespaces and schemas the better
Does anyone here have any form of material or experience on Oracle RAC (Rapid Application Clusters)

@A-40,

Do u mean Real Application Cluster?

A-40:

@jimblaze
Amen bro its been a while though and its great rubbing minds with y'all steel sharpeneth steel and for now not too much is happening besides me waiting to try out 11G wrap up school and take a full plunge into the whole Oracle DBA world
@Le Moor
Yeah you told me about the project i figured it must have taken up your time.As for the PL/SQL debate i did gain a lot from you and azum i dont intend on dabbling too much on development so im just willing to do what it takes to be a great DBA on the data pump export and import example you would agreee with me that the quicker you can move tablespaces and schemas the better
Does anyone here have any form of material or experience on Oracle RAC (Rapid Application Clusters)

Hello everybody,

I need a DBA job, I dont mind d pay. pls HELP