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)
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