Recommended Books
1. ORACLE DOCUMENTATION – http://docs.oracle.com/database/121/index.htm
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)
Pavan DBA's Blog 
Janet said
Is there an update for 12c?
Pavan DBA said
it is same documentation for 12c also. other books, i will update
hashim khan said
Iam 2014 pass out. iam not good at coding, do u think i can do this oracle dba. iam very tensed for ma future and iam unable to decided as in whats the best career option. Is it advisable to keep fake experience in oracle. can you plz help me with this.
I would be great full to you if you can let me know about it.
Pavan DBA said
plz send mail to me on mymailbox.21@gmail.com
Ramaiah Madineni said
Same problem for me also
venkatakrishnareddy bhadduri said
so pls provide links for syntax in oracle like show user,list of table space,descv$ datafile like .all syntax and uses
Pavan DBA said
you can find this in oracle documentation.
PJ said
Hi Pavan,
For a beginner Oracle dba guy which book you gone advice?
&
what book you gone advice for day to day Oracle DBA activities?
thanks in advance.
Pavan DBA said
oracle documentation is always best
https://docs.oracle.com/database/121/nav/portal_4.htm
Vipul said
Hi sir
Sir i wants to get the book of RMAN which has prefessional practical knowledge and all basic commands used in RMAN and also have the real time activity. So please suggest me which book should follow.
Pavan DBA said
you need to read oracle documentation
https://docs.oracle.com/database/121/BRADV/toc.htm
Sulata Panda said
hello sir,
I am Sulata Panda , working as Computer engineer in a steel plant and my platform is in ERP.
I have all the data base access and I wanted to be a DBA so that I can swich to software line. So colud you please guide me how to do and the best possible ways……Waiting for your early response.
Pavan DBA said
if u want to do self learning, plz read these books
https://pavandba.com/recommended-books/
or u can get trained from institute.
Diksha said
Hi,
I’m in 2nd year B.Tech-CSE, I wish to give DBA certification exam but do not know where to start my studies from. It would be very kind of you if you could suggest me some books to begin with.
Pavan DBA said
you can try reading sam.r.alapati book. also other books in my recommended books section of my blog.
rakesh said
Is OCA, OCP certificate helpful to getting job. is that necessary.
Pavan DBA said
yes. OCP will help you
Syamkumar said
Hi Pavan
This is Syamkumar now i m working as pl/sql developer , i want to be DBA , i m in confusion of choosing path like ORALCE DBA OR oracle apps dba .
which is best choice oralce dba ? or oracle apps dba ? . or both should learn ?
Thanks in Advance.
Pavan DBA said
in order to become apps dba, u need to learn dba. so go for both
abdullah alnoor said
Great Blog. Find my blog on :http://www.trainerbd.com/blog/
D.Imran said
Hi, This is Imran I need basic Interview Question for Oracle 11g dba…please send me the interview question …. this is my mail id d.imran.oca@gmail.com
Pavan DBA said
already there in my blog. plz check out
vivek said
Sir i am just fresher (BE) having knolg of C C & looking job in IT
can i require to learn more or directly go 4 interviews also should i go to consultancy or onlin job portal
Sir Plz reply to my email, i need your guidance….
Pavan DBA said
online job portal and other reference openings
Kumar said
Hi Pavan,
I had seen you blog on the Oracle DBA which is very simple and easily understandable but I am beginner for DBA and I am from database develpedment background and I am planning to shift to DBA professional so kindly can you provide any material which you had written since I had seen many articles on DBA but I am not understanding. Please provide material to my mail id : baluonly@gmail.com
Pavan DBA said
i dnt have any specific material, best is always oracle documentation
Ahmed said
HellOoo Sir,
I’m new one with oracle i just have basic information . . i want to become professional with this field , ,kindly may u give me what is the first point i should follow , and which is the best book for me to improve myself from zero . . . I’m looking to see your reply.
Thank you.
Pavan DBA said
already listed in this page about good books
Priyanka said
Hello Sir,
I have knowledge of sql. I am looking forward to do oracle 11g: sql fundamentals certification. Kindly help with the books to be followed.
Thank you.
Pavan DBA said
u will get e-book from google for that sql exam code. i think it is 1z0-051. search with this. also read sql documentation from oracle
Tekson IT said
Great Information admin thanks For Your Information and Any body wants
learn Oracle ADF through Online for Details Please go through the Link
Best Online Oracle ADF Training by IT Professional Trainers
This Will Helps you aalot.
nitin said
Sir,
i have completed b.sc(computer science) in 2013 and done oracle dba10g course with ocp certification but i am not getting job still.
How i improve my database knowledge and what is important topics for fresher dba in industry can u list the topics so i will improve my knowledge.
Pavan DBA said
u need to have good knowledge on adv topics like tuning, cloning, dataguard etc. so get good hands-on
nitin said
sir,
I have completed b.sc(computer science) in 2013 and dba course and ocp certification but still i m not getting job.Please suggest me solution or improve my knowledge on database.Can i get fresher dba jobs in company.
Pavan DBA said
only dba is not enough. u need to learn apps dba or rac for the current market situation
Madhvesh said
Hi Pawan
I am madhvesh from delhi, I often read your blog for oracle DBA topic.
presently i am working as oracle DBA but now i want to move as oracle Apps DBA
kindly suggest me how can i learn oracle Apps DBA.
please kindly suggest me..
Thanks in advance..
Pavan DBA said
i suggest to take either classroom or online course from a real time exp person to understand things better.
gaurav said
Hey Pavan,
I have completed OCP in oracle 10g. But i want to go to oracle apps DBA side. Can you please me some books or concerned training.
Thanks,
Gaurav
Pavan DBA said
i am not sure about books. for training plz contact training@kannatechnologies.com or call to 040-40036087
Niranjan said
Hi Pavan,
I am not having any knowledge on DBA, however i am more interested in learning the performance tuning of query(s)…can you please help to achieve my interest.
Secondly, You can direct me to right book/blog on Oracle hints in detailed.
Thanks in adv…
Niranjan
Pavan DBA said
hi, you can read oracle sql tuning books which are available over google. one of the best one is sql tuning from rampant books.
Nitesh bhardwaj said
Hi
sir I am Nitesh from Chandigarh.I have completed b.tech(cse) in 2013 and done 6 month training in oracle 10g… Now I am looking for a job in database field, So how can i start my career as a fresher in database field……. pls tell me I am very upset about my career.waj
email: niteshbhardwaj2@gmail.com
Pavan DBA said
hi nitesh, now a days only oracle dba will not help freshers to get dba job. so i suggest to learn apps dba or rac so as to get more chances.
manoj said
hi sir,
I am manoj from new delhi. i completed bca in 2004 and since then i have been working in bpo. i want to move to database. i have basic unix and sql knowledge. please advise should i go for database and my chances of getting of jobs after such long duration. I have checked my job portals, they only requires experience people.
Pavan DBA said
hi manoj, yes it would be better to go for dba role. plz chat with me at my personal id mymailbox.21@gmail.com for more understanding and guidance.
manoj said
Hi Sir, thanks for quick reply.
i have sent chat request at your id. Please let me know when you have time. i have few doubts that i want to clear.
Pavan DBA said
sure. when ever you see me online, you can ping me. mostly i will be there at 10 PM IST.
Samir Feddy said
Hi pavan,
I am new to Oracle Database. I have been reading famous book “Expert Oracle Database Architecture” by Thomas kyte. At page no. 62 he has said that “This dedicated server process is not (by definition) part of the instance.”
But in the docs@oracle.com documentations at almost most of the places they have mentioned that dedicated server is part of an instance. Interestingly Tom Kyte has coauthored book. I got confused because Dedicated server process would also have PGA so it will be part of Memory so it should be part of instance. So has Tom Kyte said for that particular dedicated process and why? He must have said that with some reason? What is that?
I have also asked my trainer. But I didn’t get satisfactory answer.
Thanks.
Pavan DBA said
Hi Samir,
server process is not part of the instance. it resides on RAM(memory), but will not be inside instance. (there will be many such processes which runs outside of instance)
simple to say, if RAM is like a box of storage, inside that instance, server process etc are its articles.
don’t know if this clarified your question, but anything still left out, please reply.
Samir Feddy said
hey thanks..
but what in case of shared server process?
again it wudn’t be part of instance. Right?
confused a bit.
Pavan DBA said
no. in that also server process will not be part of instance.
Dileep said
Dear Pavan,
I suppose to do certification on Oracle 11g,Can you please mail me the OCA Dumps.
Thanks,
Dileep
Pavan DBA said
hi dileep, plz send email to mymailbox.21@gmail.com
Ankit Kahn said
Hello Sir,
I am preparing for 1z0-050 exam. Which documents should I refer in order to prepare for the exam.
Your guidance would be invaluable.
Thank you for your efforts.
Regards
Ankit Kahn
ankitkahn@gmail.com
Pavan DBA said
hi ankit, u need to read oracle documentation. along with that there will be 1z0-050 exam guide book from oracle press. you can prepare that as well
Ankit Kahn said
thanks pavan
Saurav said
Hi Pavan sir
Recently came across your Site. First of all…Thanks a lot for sharing your knowledge and helping out lots of People in DBA field…Really you doing a great Job.Hats Off to you…
As i am new in Oracle field,Sir Can you suggest me how to backup and recovery procedures Step by step if I try these in my Own machine where I have created a database…
Thanks & regards,
Pavan DBA said
thanks for your kind words
you can get all the scenarios here
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm
Babu Raj said
Dear sir,I am babu from chennai
How possible to get a job(oracle DBA) without experience? because most requirement for experienced candidates.
I am MCA fresher and completed DBA course and
Now am I searching job.
Pavan DBA said
along with dba if u do apps dba or rac courses, then chances are more. but comparatively fresher dba jobs will be less.
Babu Raj said
You mean, if done the course of oracle DBA+Apps DBA+oracle RAC after freshers have more chances to get job. otherwise
freshers difficult to get job.
Pavan DBA said
yes
sasmita said
Hey pavan
I am sasmita i want to do oracle dba dataguard and rac course online with practice with real life enviroment.Do you provide any vertual lab,server etc..
Pavan DBA said
yes, we do provide. please call to 040-40036087 / 8008500064 for more details.
gsrao said
can you 4rd the user guide of the doc’s on export/import and data pump..?
Pavan DBA said
best doc is here
http://docs.oracle.com/cd/E11882_01/server.112/e22490/toc.htm
yogi said
Hi Pavan
i just want to ask one question i am having 6 years of gap and i completed training on both apps and core and done certfication also so did i need to any real time things or i can go for interviews plz suggest
Pavan DBA said
if u have practised all the concepts well, then u can go for interviews.
yogi said
Thanks for u r reply but one more thing in interviews i had attended they are asking about concurrent manager issues in realtime . As i have no realtime experience i am felling difficult to answer those . So can u help me on this please
Pavan DBA said
unfortunately I am not apps dba to help you on this.
hima said
hi pavan,
thax 4 ur post in blog
harsh malik said
hi pavan…..i am graduate in bsc math. science from delhi university….honestly i ruined my career and still i am fresher @23…….i want to become top dba in oracle and having interest in this field……..so tell the way to start ( any beginner’s course and training , i want to start with pure beginning in database field )
my email id is : harsh_malik28@yahoo.com……….plz reply me on my email id
Vaishraj said
Pavan,
1) Can you recommend a good book(concise and easy to understand) for Oracle 11g RAC concepts and administration
2) Good Oracle Apps DBA and training for Oracle Financials in Hyderabad.
Thanks
Pavan DBA said
hi,
1. rac, i suggest to go for oracle documentation. i have specified how to access it in my blog itself.
2. for apps dba i am not sure as i dnt have apps dba knowledge.
surendra said
hi pavan sir,
can u tel me which process is responsible for validating a user ?
can u tel me if i issue
$ sqlplus scott/tiger@orcl
what happen in background?
thanks
Pavan DBA said
PMON is the responsible process to do authentication of user. when user issues above cmd, pmon will verify for user existence in data dictionary tables and nce verification is successful, it will allow user to connect
arun said
hello sir, this is arun from delhi..kanna technologies should open there branch in delhi..delhi lacks a good quality institute. I am looking forward for kanna tech to open branch in delhi..many well known institutes from hyd, banglore etc are and have opened branch’s in delhi. Although there is an open for online classes but i believe there is no substitute of classroom training. I really enjoy ur blog. Its really great piece of work. I am into hardware, networking (mcse, ccna) and handled bit of database oracle 9i..can i switch to oracle dba or app dba. Few of my friends have guided me as my previous experience might help my cause or seen as an added advantage. what do u suggest sir..
Pavan DBA said
your suggestion is welcome, but due to location constraints we are not moving to open new branches. regarding your question, yes you can switch to oracle dba without any issues. thanks for your comments on my blog
akash said
Hello sir,
rite now i am in b.tech final year(information technology) and i wanna make my carrier as a oracle dba.so i have some questions:
1.which version should i choose (9i / 10g /11g) to get oca certs?
2.How to prepare for certs?( book or online material / dumps)
3.series of certs for future and better growth?
Thanks
Pavan DBA said
1. it should be 11g. 9i and 10g are out of market now
2. yes. I have already recommended books in my blog. you can follow them and you need to have good hands on
3. first OCA and OCP would be enough
playpiyush said
sir
please send me rman backup recovery and patching cloning documents with real time commands
Pavan DBA said
rman backup n recovery scenarios you can get it from google.
patching and cloning docs are already there in my blog’s “important docs” page. please check out
Debasis said
Hi Pavan,
I am looking forward to start a DBA career in Oracle. Would like to understand if Linux (RHCE) cert. is required as a prequisite/advantage for OCA or can it be done latter. Also would like to know the good training inst. for DBA in hyd.
Kindly suggest.
Regards
Pavan DBA said
Linux certification is not at all req for dba. we need to learn only commands of linux and some shell scripting.
if u wish you can join kanna technologies where i am training people on DBA. details are there in my blog
pravin said
dear sir,this is pravin,how to get job easily as a oracle dba,i have 3 yrs of work exp,…..now i m on banch so want to switch…..
which type of question they will ask in interview round….
Pavan DBA said
getting a job easy is only when you have good knowledge on high end topics like upgrade, cloning, patching, migration, tuning, dataguard and rac. so prepare well in these areas… all the best
pravin said
hi sir
send me the rman step by step detail…
Pavan DBA said
what you mean by rman step by step? i didn’t get you
Narendra said
Hi Pavan,
This is Narendra.i am very happy to join ur blog.Thank You.
ramesh said
hi pavan sir,
can u send me the step by step oracle 10g RMAN BACKUP,How to take? and How to recover ? document for me?
Pavan DBA said
i have replied to your email
here said
Hi sir good evening,
just gone thru your blog, honestly, u r doing a commendable job. i like your concept of sharing knowledge. the world needs more people like u. wishing you the very best in all your endeavors. keep up the good work.
Pavan DBA said
thank you very much
gouthamk10 said
Hi
i recently started learning oracle apps dba .i wanted to install oracle e-business suite 12.1.1. on OEL 5.5.can you please give steps to download and install e-business suite.
thanks
k.goutham
Pavan DBA said
Hi Goutham, I am only Oracle dba and doesn’t have apps dba knowledge
jaspreet matharu said
Hi pawan,,
I passed out my graduation as a BCA in the year 2011 and completed my oracle dba 10g training and certifications(oca and ocp from pearson) , believe me on this that I throwed my heart out for seaching my first job as a dba but hopelessly today I am a employer in some bpo(call center). so please telll me that when should I again start my search in dba profiles , I mean to say that how much experience should I get in th bpo so as to avail me the dba post in IT industry.
Pavan DBA said
you can still keep on trying by continuing in current job. to discuss more, plz chat with me in gmail. my id – mymailbox.21@gmail.com
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
Click to access 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
https://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
Oradbapool said
Hi Munna i have soft copy of unix shell programming by yaswant kanitkar