Good DBA

Today my article is based on general thoughts about Oracle DBA with some technical details.

In Oracle Technology we never feel boring.  Because it is very vast we have always new things for learn and we never become 100% expert.

So... Lets Start , J

•  What is Oracle DBA ?

DBA is Database Administrator which handle Database. and Oracle is biggest Database software in world right now which we use for maintain company data.

Life of DBA is very challenging.

DBA face new , new issue related to oracle database and try to solve, sometime small issue will take lots of time to sort it out.

• When we call a person is Complete DBA.

1. A person must be able to handle all database version with two OS platforms

Like Windows Linux/Solaris/Unix

2. A person must be able to handle all backup and recovery related senario.

3. A person must be able to handle & Solve Performance related issues.

Above three are major work which include alots of things.

If you want to be good DBA then you have to always read,read,read oracle related forms, documentation, article, blogs etc. Involve in Meetings and Groups.

• From where I get Real Time Exprience ?

This is very most important and difficult question :)

because without exprience we can't get job or without job we can't get real time exprience J

So First understand what is real time exprience ?

Read Time experience means where so many users working in your Oracle DB and DBA have to maintain that database, if any error comes DBA have to fix as soon as possible.

Now if we remove REAL TIME word in experience then we can get only experience without Job ?

Ans: Yes,

How ? i will show you.

• First understand what is experience?

Experience means we have to good concept with some practical knowledge in Oracle DB.

Now Question is how can get good concept knowledge with some pratical knowledge ?

1. Buy On PC with minimum 512 RAM with 80 harddisk.

2. Install Oracle 10g Database or Oracle 11g

It is free you can download here

http://www.oracle.com/technology/software/products/database/index.html

Note: Oracle 11g is also released on Windows or Linux Platforms

3. Download below books from Oracle Documentation

1. Oracle Concept

2. Oracle Administrator Guide

3. Oracle Sql Reference Guide

4. Oracle Performance Tunning Guide

4. Now start reading with step by step first read 1 pointed books then 2 and so on.

5. If you face in problem means any error message or anything which you don't    

understand then please refer oracle forms.

1. Oracle OTN forms

http://forums.oracle.com/forums/category.jspa?categoryID=18

2. OraFAQ forms

http://www.orafaq.com/forum/

3. Asktom

http://asktom.oracle.com/pls/asktom/

 4. Some Oracle guru's Blog

http://jonathanlewis.wordpress.com/

http://tkyte.blogspot.com/

http://DBAcode.blogspot.in/

-I am not Oracle Guru's but visit my blog also :)

www.oracle-dba-help.blogspot.in

- Some good Site

http://www.akadia.com/

http://www.psoug.org/

After Follow above instruction you will be very good Oracle Knowledgeable person.

•  How can I get Oracle Job ?

Keep in mind below things when you going for interview

1. Make sure you have very good RESUME/CV created.

If anybody want to know about how to create CV for oracle please email me ,I will check and correct your CV.

2. First decide In which subject you are very powerful ?

 - Administration

 -  Backup and Recovery

 - Performance Tunning

3. Good Dress Code

Hope this article give you good understand about Oracle Certification , Experience and Job.

• What are some ORA-ERROR which every DBA face in his/her life.

1. ORA-00600/ORA-07445

Clause: Most likely it is related to bug

Solution: go to metalink and apply patch set.

2. ORA-03113

Clause: It is generic error means lots of reason behind this.

Solution: Depends on condition but best way to search on google/forms.

3. ORA-04031

Clause: Mis-configuration of SGA, insufficient memory

Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory

4. ORA-12154

Clause: Wrong TNS_ENTRY is used.

Solution: Using NETCA tools configure tns entry or check tnsnames.ora file for correct entry.

5. ORA-12368

Clause: It is generic error lots of reason

Solution: Edit SQLNET.ORA and change NONE from NTS "SQLNET.AUTHENTICATION_SERVICES=NONE"

6. ORA-12500

Clause: It is generic error lots of reason

Solution: increase "processes" parameter, increase physical memory

7. ORA-12528

Clause: It is BUG in 10g (if you face this error in 10g)

Solution: Don't use TNS_ENTRY with connect string or edit listener configuration from STATIC to DYNAMIC.(search on my blog for more)

Below are some question which everyone is confused

• When you face performance related problem ??

1. it is related to Instance (SGA Configuration)

2. it is related to Client machine ( SYSTEM configuration)

3. it is related to Network delay

Check database performance through

-StatsPack report

-AWR report

-TK*PROF tool

-SQL trace etc

See Also :  

How to Prepare for DBA Interview 

General tips for DBA Interview*HOT*

Server Maintenance Tasks for a DBA

General Tips to Prepare for an Oracle DBA Job Interview  *HOT*