Recommended Books
1. ORACLE DOCUMENTATION – http://tahiti.oracle.com
please read the following guides for attaining ultimate knowledge (for 11g release 2)
a. concepts
b. administrator’s guide
c. 2 day DBA
d. utilities
e. backup and recovery basics
f. backup and recovery advanced user’s guide
g. performance tuning guide
h. 2 day+ performance tuning guide
i. oracle clusterware and oracle RAC administration and deployment guide
j. 2 day+ RAC guide
k. Data Guard Concepts and Administration
l. Data guard broker
2. Expert Oracle Database Architecture 9i and 10g programming techniques – by Thomas Kyte (apress publications)
3. Expert Oracle 10g/11g Administration – by Sam R Alapati (apress publications)
4. Oracle 9i/10g/11g DBA Handbook – Oracle press (Tata Mcgrahill in India)
5. Oracle Insights – by Thomas Kyte (apress publications)
6. Oracle Tuning – by Donald K Burleson (rampant books)
7. Oracle Dataguard – by Bipul Kumar (rampant books)
8. Oracle 10g Grid & RAC – by Mike Ault & Madhu Tumma (rampant books)
9. RMAN Recipes for Oracle database 10g – by Darl Kuhn, Sam R Alapati and Arup Nanda (Apress publications)
10. Linux Recipes for Oracle DBAs – Darl Kuhn, Charles Kim and Bernard Lpouz (Apress publications)
11. Oracle Database 11g, A Beginner’s Guide – By Ian Abramson, Michael Abbey, Michael J. Corey (Oracle press)
12. Oracle Db 10G Rman Backup & Recovery – by Matthew Hart and Robert G.Freeman (Oracle press)
13. Pro Oracle database 10g RAC on Linux – By Julian Dyke, Steve Shaw (Apress publications)
14. Oracle 10g RAC: grid, services & clustering – By Murali Vallath (Digital Press)
15. Oracle Database 10g Linux administration By Edward Whalen (Oracle press)
16. http://www.oracle.com/technology/pub/articles/tech_dba.html
17.Oracle Privacy Security Auditing by Arup nanda and Donald Burleson (rampant books)
Amol said
Hi Pavan,
Your all published DB artical are excellent and easy to understand to any person.But,still you are not published doc regarding “Patchset”
so please publish the same and also i want to join the apps dba and RAC course.mail me all the details at amolzode@gmail.com
Pavan DBA said
Hi Amol,
thanks for your comments first of all…
Surely I will take your suggestion and will post an article in next week. I have sent mail reg the course details.
uday said
Hello !
Iam 2010 pass out working as an Analyst can i show up this experience as DBA. iam not good at coding, do u think i can do this oracle dba. My parents are very tensed for ma future and iam unable to decided as in whats the best career option. Is it advisable to keep fake experience since i dont have good academics. can you plz help me with this.
I would be great full to you if you can let me know about it.
Thanks
uday
Pavan DBA said
Hi Uday,
I mailed you…
Janardhannaidu.narra said
Hi pavansir this jana i am 2007 passout how can i apply jr dba sir
Pavan DBA said
Hi Jana, only way is to upload ur cv in all job sites and attending calls
Preethi Singh Thakur said
Hi pavan,
Just gone through your blog, it contains very good information.
It is useful to all.
PLease Help me in out:
I want to perform the Upgradation of 10.2.0.4 to 10.2.0.5 on linux x86-64bit Server.
We are using RAC Database with two Node cluster (csdb1 and csdb2).
PLease send me Step by step procedure to perform upgradation with pre-requesits and post installation steps.
Thanks and Regards,
Preethi Singh Thakur
Oracle DBA
preethi.thakur@wipro.com/preeti.thakur@tatacommunications.com
Pavan DBA said
Hi Preethi,
Thank you very much for your comment on my blog.
Reg doc you asked for, I don’t have a specific doc for that. But, to upgrade to 10.2.0.5, you would be using applying 10.2.0.5 patchset. That patchset contains README file which contains all the steps that need to be done for RAC env also. So, you can follow those steps and can complete the task.
Preethi Thakur said
Hi Pavan,
Thanks a lot but I have already gone through the README.txt file of the patchset.
Even I have completed the Oracle upgradation from 10.2.0.4 to 10.2.0.5 on 2Node RAC Database.
Any know looking forward for some useful inputs in your blog regarding RAC Performance Tuning Techniques.
Regards.,
Preethi Singh Thakur
Pavan DBA said
thats good to hear. will surely share some information regarding that
anil said
Hi Pavan,
I have some doubts can you please clarify ?
1)In Data Guard ,we can check log applying primary to standby in v$archived_log .what to do if log is not applying?
2)what is command to check high cpu utilization other than top command in unix?
Thanks,
Anil
Pavan DBA said
Hi Anil,
1. If archive log is not getting applied, check the alert log file of standby database which gives you the reason.
2. see this link which contains some nice commands we can use – http://www.cyberciti.biz/tips/how-do-i-find-out-linux-cpu-utilization.html
anil said
Thanx Pavan garu.
Pavan DBA said
welcome….
Sarat Babu said
Can you plz provide oracle 10g/11g DBA Hand Book or any link which i can download
Pavan Kumar said
http://www.4shared.com/office/xh2taBTV/OracleDatabase11gDBAHandbook.html
surendra babu said
hi pavan sir,
can u send me the step by step oracle 10g dataguard document for me?
Pavan Kumar said
http://pavandba.files.wordpress.com/2009/11/dataguardphysicalstandbystep.pdf
Ayub said
Hi sir,i’m Ayub and i need information regarding any oracle freshers in hyd??
Pavan Kumar said
Hi Ayub, any fresher openings i will be posting in the blog itself. so keep on watching it….
venkatesh said
may i know sir what are the rman new futures in 11g?
Pavan Kumar said
there are many features. some of them are listed below
http://www.oracleracexpert.com/2011/12/oracle-recovery-managerrman-new.html
surendra babu said
hi sir,
i m mca 2011 fresher and completed oca and preparing for ocp .
can u tel how to get dba as a fresher?
Pavan Kumar said
Hi Surendra, getting a dba job as fresher is a little bit tough task. But its not impossible. Get the best knowledge by reading documentation and I believe once you are done with OCP, surely companies will show interest in taking you. so keep on trying……..
surendra babu said
thanks sir
please tell me , is there any consultancies or clients in hyderabad for oracle dba ?
Pavan Kumar said
consultancies will work mostly for exp professionals and not for freshers (atleast I suppose). So, the way before you is to depend on naukri and all other job sites, keep watching fresher related websites etc
surendra babu said
k thank you sir
Bhanu said
Hi Pavan,
If there is more ‘logfile sync’ on the instance then it is a symptom of sluggish I/O?
Pavan Kumar said
Hi Bhanu, Yes logfile sync is bcz of more I/O. see this wonderful link http://www.pythian.com/news/1098/tuning-log-file-sync-event-waits/
venkatesh said
thanks a lot sir for providing information .
Pavan Kumar said
You are welcome Venkatesh
surendra ababu said
hi sir,
i want to do oracle certification. all r telling write 10g but i want to write 11g whichone best ?
tell me exam procedure and center names?
Pavan Kumar said
It is better to go for 10g as 11g is still need to more implemented. For details on how to write and etc, visit this link
http://pavandba.com/category/certification/
surendra babu said
hi sir ,
i created on table with 3 columns
i entered data in two columns only
i didnt enter any values in third column so what that third column contains null or empty?
Pavan Kumar said
it depends on how you inserted the data. if you have used space in 3rd column, then garbage value will be there or else a null value.
to clarify, plz give me the insert statement you used.
surendra babu said
hi sir,
sql> create table sample(no number(5),name varchar2(20),address varchar2(20));
sql> insert into sample(no,name) values(100,’sai’);
sql> insert into sample(no,name) values(200,’sure’);
i used the above statements for inserting so please tel me which value is there in third column?
Pavan Kumar said
Hi Surendra,
as you are not inserting any value through insert statement, your table contains NULL value
DurgaprasadPolaki said
Hi sir Good evening,
I durgaprasad completed mca in 2010 batch.My doubt is :CAN WE ENABLE UNDO&ROLLBACK IN ONE DATABASE?IF YES HOW,IF NO WHY?.Pls give me answer for this.
Pavan Kumar said
earlier till 8i, we used to have rollback segments. but those are replaced with undo tablespace from 9i. even though both stores old images, managing rollback segments involves more manual intervention from dba, whereas undo can be managed automatically. now answering to your question, we cannot have both rollback segments and undo tablespace enabled at the same time as oracle can detect only one place to store old images…..
Anjana Mahen said
Hi Pavan,
Your blog is very nice and informative. Thanks alot for your collection.
And i am looking for some real time docs for streams replication..
Pavan Kumar said
Hi Anjana, thanks very much. I am going to upload so many docs including streams soon… plz keep watching this space
Sunil said
Sir ,
backup recovery book which one is best
sam alapati or freeman?
I just want to read 1 book
which one you suggest
Pavan Kumar said
Hi Sunil, i have not read book by freeman. so cannot comment on that. but sam alapti’s book is good one in terms of understanding easily
Sarfraz haroon said
Hii! Buddy,
eu really doing the great job Man, as its fairly difficult to find all the relevant materials all at one place,i need your kind support too, recently i started taking up 10g classes on linux platform but the problem i am facing is, i am unable to prepare for ocp certification in parallel with that as i am still unaware of the paaterns and Questions and all…
Plsss!!! mail the related dumps of 10g certification.
yours thankfully
Sarfraz Aaron.
Pavan Kumar said
Hi Sarfraz, I don’t have any dumps with me and even i will not recommend them. You can use Oracle documentation for all your needs. Let me know if you need any help out of it
Sarfraz haroon said
offcourse, i do. from where can i get the oracle documentation and please suggest me one good book for 10g too.
Pavan Kumar said
its from http://tahiti.oracle.com and the list of books i already mentioned in “Recommended Books” page of my blog
binod said
sir .
I am using oracle 9i in window xp. here I created two database nunu and neha ..presently am working on database named neha. now I want to jump on the database nunu..
I have given a command in command prompt as follows : -
cmd> set oracle-sid=nunu1
echo%oracle%sid
nunu1
cmd>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 – production on wed Dec 15 23:09:48 2010
copyright (c) 1982,2002,oracle corporation. All right reserved.
startup pfile = ‘C:\oracle\admin\nunu\pfile\init.ora’
oracle instance started
ORA-01102: cannot mount database in EXCLUSIVE mode
How can I solve this problem.plz help me
Pavan Kumar said
there could be some problem with pfile or service. check services.msc and try to start service for nunu. also check pfile if everything is fine.
Pavan Kumar said
also check your alert log file for more details of the problem
venkat said
hi pavan,
this is venkat, iam new for oracle DBA , presently am in job searching, so plz if u hav any real time scenarios ,plz forward to me.
Pavan Kumar said
th greatest advantage of dba is whatever you practise is the same wht u r gng to do in real time. hw good u practise, those many real time scenarios are there in ur pocket.
ofcourse all the problems and solutions i posted in my blog are also real time
kumar said
hi,
pavan garu,
i want oracle patching steps.
Pavan Kumar said
Hi ravi, when ever you download a patch from oracle support, it contains readme file which gives clear steps for installing a patch.
normal patches we will install using Opatch and patch sets we will install software and upgrade database later.
kiran said
hi pavan
this is kiran. can u do a favour for me
Iam looking for oracle 11g dba student guide from oracle press. plz forward me if u hav.
Pavan Kumar said
hi kiran, i don’t have it
kiran said
its k, n tx 4 ur reply
priyanka reddy said
Hai Sir !
Very nice cing of ur blog.Thanks for helping n in guiding all d cand’s to hire for MNC’s.I waz very much happy to c dis.Thank u very much.Can i have ur Personal Mail ID.I need to give my details n in future waz up i need to do.So i need ur lotssssssssss of help frm u.So pls,can i have ur ID.
Thanks for ur Beautiful Blog………………
Pavan Kumar said
hearty thanks for your comments and we humans are to help each other and i believe that is humanity….
mymailbox.21@gmail.com is my personal id n even you cn chat with me if am online (almost i do…)
Dinesh said
Hi,
Hope you are doing good. I need your help on the traning of oracle apps DBA. I am botany graduate with 7+ years IT experience.
I am working as a oracle production support associate mostly into performance tuning and scripting activity.
What will be the duration of the course. Which course is best to do. And what is the fees.
Thank you.
Pavan Kumar said
had sent mail.plz have a look
Munna said
Hey pavan,
Hope you are doing fine.
Please let me know the book name for unix shell scripting.
–Munna
Pavan Kumar said
Hi Munna, yes i am good. thank you.
for Unix shell scripting, i feel a book by yaswant kanitkar (author of let us C) from BPB publications is easy and i followed the same
Munna said
Hi Pavan,
Can you pease help me to get this book.
–Munna
Pavan Kumar said
hi munna, you mean you need soft copy of this?
Munna said
Hey Pavan,
Means like , how can i get this book , i have searched in net but not able to find.
If you have a soft copy of this book then please send it to me.(munnamia.2005@gmail.com)
-Munna
Pavan Kumar said
you can get this from any book shop…even i too don’t have soft copy.if i found, surely i will mail you