Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Oracle DBA Guide

Oracle 9i DBA Release 2 (9.2)
Oracle 9i DBA Release 2 (9.2) for Windows
Backup and Recovery Concepts Release 2 (9.2)
Oracle9i Client Installation Guide Release 2 ( for Windows 32 bit
Oracle9i Client Release Notes Release 2 ( for Windows
Oracle9i Data Guard Broker Release 2 (9.2)
Oracle 9i Data Guard Concepts and Administration Release 2 (9.2)
Oracle9i Data Mining Administrator’s Guide Release 2 (9.2)
Oracle9i Database Performance Tuning Guide and Reference Release 2 (9.2)
Oracle 9i Database Tuning with the Oracle Tuning Pack Release 9.0.1
Oracle9i RMAN Quick Reference Release 2 (9.2)
Oracle9i RMAN User’s Guide Release 2 (9.2)
Oracle9i Application Developer’s Guide - Fundamentals Release 2 (9.2)
Introduction to 9i RAC
Oracle 9i RAC Documentation
Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC Quick Installation Guide
Install Oracle 10g RAC by PolyServe
Setup or Configure 9i RAC on Windows
Oracle 10g Release 2 Documentation Library
Oracle 10g Release1 Documentation Library
Oracle 11g Release 1 Documentation Library
Oracle 11g Release 2 Documentation Library
Basic Linux Tutorial
Basic Linux Commands
RMAN in Oracle 10g
Oracle iLearning
Oracle Database Reference Book
1. Expert Oracle Database Architecture 9i and 10g Programming Techniques – By Thomas Kyte (apress publications)
2. Expert Oracle 10g/11g Administration – By Sam R Alapati (Apress Publications)
3. Oracle 9i/10g/11g DBA Handbook – Oracle press (Tata Mcgrahill in India)
4. Oracle Insights – By Thomas Kyte (apress publications)
5. Oracle Tuning – By Donald K Burleson (Rampant books)
6. Oracle Dataguard – By Bipul Kumar (rampant books)
7. Oracle 10g Grid & RAC – By Mike Ault & Madhu Tumma (Rampant books)
8. RMAN Recipes for Oracle database 10g – By Darl Kuhn, Sam R Alapati and Arup Nanda (Apress publications)
9. Linux Recipes for Oracle DBAs – Darl Kuhn, Charles Kim and Bernard Lpouz (Apress publications)
10. Oracle Database 11g, A Beginner’s Guide  – By Ian Abramson, Michael Abbey, Michael J. Corey (Oracle press)
11. Oracle Db 10G RMAN Backup & Recovery – By Matthew Hart and Robert G. Freeman (Oracle press)
12. Pro Oracle database 10g RAC on Linux – By Julian Dyke, Steve Shaw (Apress publications)
13. Oracle 10g RAC: Grid, Services & Clustering – By Murali Vallath (Digital Press)
14. Oracle Database 10g Linux administration By Edward Whalen (Oracle press)

15. Oracle Privacy Security Auditing By Arup Nanda & Donald Burleson (rampant books)


  1. Thanks a lot sir, I am learning oracle DBA and your website is helping me a lot..

    I appreciate your hard work!

    Jazak Allah khair

    1. please follow also this blog .This blog also awesome

  2. Thanks for your appreciation. I really welcome you in my blog. If you have any issue regarding any topics please right to me.

    1. I m learning oracle in windows environment and i know the facts that in real world linux environment is more preferable,
      i just wanted to know the difference in terms of difficulties in both environment.
      one more question!!
      Is it necessary to take oracle training in order to complete OCP cert or is there any alternative for oracle training to complete OCP?


    2. It is not matter in which environment you are learning the database.
      Database skills almost same on each environment but as per market trend
      in Asia specially in India. You can say Linux is most preferable. You
      can fill this gap later after learning perticular Environment.
      As per my kowledge 'Yes', it is essential for OCP to take training
      from any authorized Center.

    3. Thanks a ton for quick reply!!!!

  3. as salam sir.. i want your mail id sir

  4. You can find it on Contact details. Please do not try to chat with you cam mail regarding any issue.

  5. Hello Sir,

    Can u tell me what are the real time tickets that are solved by Rman

  6. hi brother,

    recently i faced interview,these questions i am not answered properly.please provide proper answers.

    1)my db size is 2tb,i will take rman full backup what is my bkp size?
    2)any rman command to estimate the size of db before taking the bkp?
    3)default how many channels in rman?max how many possible to configure?

    1. Dear,

      Generally RMAN full backup (without compression) is the actual size of datafiles. You can query with the DBA segements and find the sum of data block to estimate the actual backup size.
      SQL> select (sum(blocks)*block_size)/1024/1024/1024 from dba_segments;
      As per my knowledge there is no official way to find backup size before taking actual backup.
      But as per the oracle RMAN does not take backup from NEVER USED blocks. So to estimate find the total block size from dba_segements.
      But if you are using any compression technique then the backup estimation also
      depends on the compression technique you are using.
      Related to channel configuration and their operation. Please search and visit my another post
      "How RMAN behave with the allocated channel during backup".
      Hope you will find the solution!

  7. Hi Shahid,

    In a interview, interviewer asked me following questions
    1) Accidentally, 4 million records got deleted and committed. It was noticed after 24 hours. How to recover those deleted records. Conditions : A) No Downtime allowed B) Flashback not configured.

    2) A PLSQL batch has to run exactly on every month 15th either using DBMS_JOB or Scheduler. (Cannot use Interval=> sysdate + 30, since number of days in a month varies)

    1. Hi Shahid,

      Request you to kindly provide your comments on the above questions.


    2. Using logminer utility we can drill the archive log files and get the deleted records.Then using where clause select the required data and spool it.Once spooling is done execute the file where all deleted records will be inserted again from that script.

  8. sir, to take backup of oracle database and then how to restore them

    1. Dear Usman,
      I already uploaded a number of related post. Please use the search option.

  9. Shahid sir

    Currently working as Oracle DBA and your posts are helping me a lot.

    Thanks brother.

    1. Dear,

      For direct reference of any post into your inbox, you can join this blog. To join just open the web link and click on "Join this site" then login with your email id.
      Hope it will help you.
      Wishing you all the best in your career
      Shahid Ahmed

  10. Hi Shahid Ahmed,

    I have completed Introduction to Oracle9i: SQL(1Z0-007), Program with PL/SQL(1Z0-147), Oracle Forms Developer: Build Internet Applications(1Z0-141), Oracle Database 10g: Administration(1Z0-042) I and Oracle Database 10g: Administration II (1Z0-043) exams, I have completed these all exams myself by reading books, and did not attend any institute but they asking instructor name or Oracle university location where i completed those courses when i submit hands-on course, what does it mean will i have to attend any classes in any institute after completing or what shall i write in there? please explain me because i have completed my Masters in computer Science and i could do these certifications my self, which was hard but i managed it luckily...

    1. Dear,

      Now it is recommended OCP exam you have to take training from any oracle authorized ‎training center and must provide the details of training while filling the form because ‎when you take training from that center the oracle will send your starter kit on the behalf ‎of that training center.‎

  11. Ok thanks and what are the ways to take training i'm In UK now and can i take these training online from some where...

  12. Hi Sir,

    Is there any way to increase Home Directory after installation of linux in my VM?

    If there is a solution pls suggest me.

  13. Hello
    i want needed your help

    1. Dear,

      You can write me on my gmail Account on your issues. I will try to answer all.

  14. Thanks for sharing the information

    For more info : Oracle Certifications

  15. Dear Path Infotech,

    Please upload the related link only.

  16. which skills are required for getting apps DBA job?

  17. thanks.for your info.You can find material related to Android Training by following below link.
    Oracle DBA Online Training in USA

  18. I'am planning to join Oracle certified course. I want some expert advice whether i should go for it or not.
    oracle training in chennai|

  19. Useful commentary ! For what it's worth , if your company needs a DA 31 , my boss filled out and faxed a sample version here

  20. Thanks for sharing these information. It’s a very nice topic. We are providing online training classesoracleraconlinetraining

  21. hi i am also the beginner can u explain me about how to find out the archiving are done

  22. Pleae share documents for Oracle APPS DBA

  23. hi asslamualekum sir,
    i am from Hyderabad mostly companies refers experienced Oracle DBA persons but i am fresher then how can i get job as a entry level ORACLE DBA and also i have done Training of ORACLE DBA

  24. Some time I wonder whether I will get the information I am looking for. But you have given complete information which I training in noida

  25. Great information provided. I appreciate your work.

    Oracle DBA Training

  26. Hi thank you for giving this pentastic useful information.
    This information is very useful to me and who are wanted to learn Oracle DBA Online Training through online and offline.

  27. Hey Shahid... Thanks for sharing such a meaningful information.. ORACLE TRAINING IN NOIDA

  28. Hi sir,what happen if we specify parallel=4 in datapump.

  29. Thank for sharing this useful information;
    It is very helpful to who are wanted to learn or update their knowledge on oracle 12c DBA through Oracle 12c DBA online training or offline training.

  30. Spend only daily few hours here we are offering online training class for the following course, like Microsoft. Oracle, sale force, data warehouse, and we also offers free online demo also for more details please visit

  31. This comment has been removed by the author.

  32. Best placement consultancy agency
    BiodataWorld is a business to business (B2B) online recruitment concept. It provides recruiters the most relevant, focused & instant resumes database of the employable candidates to the employer for their recruitment and hiring, as per their requirements and specifications. BiodataWorld gives you the relevant resume database only within the shortest time span of 24*hrs only (72*hrs on weekends) and at the lowest price in the industry.

  33. ORA-00604:error occurred at recursive SQL level 1
    ORA-01009:missing mandatory parameter

    Anyone help me how to solve this problem.
    thanks in advanced for ur anwsers

  34. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in ORACLE DBA 11 G, kindly contact us
    MaxMunus Offer World Class Virtual Instructor led training on ORACLE DBA 11 G. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383

  35. Valuable information thanks for sharing Oracle DBA Online Training
    use above link for blog commenting

  36. This comment has been removed by the author.

  37. Nice and appreciate you on the oracle guidance

    Thanks with SAP Institute

  38. Wow, very nice blog. I like it. thanks for sharing helpful post.
    Oracle Training Institute in Gurgaon

  39. CIITN provides Best Linux training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIITN Provides Best Linux Training in Noida. CIITN is one of the most credible offering hands on practical knowledge and full job assistance with basic as well as advanced level.

    Linux Training in Noida

  40. CIITN is the pioneer of education providing the best PHP training in Noida as per the current industry requirement that enables candidates to land on their dream jobs in companies worldwide. CIITN Provides best PHP training course in Noida. CIITN is a renowned training company providing the best training service and also being the best PHP training institute in Noida rendering practical knowledge through training on projects and a dedicated placement assistance for all. The course curriculum for PHP training course is designed to provide in-depth knowledge that covers all the modules for the training ranging from basic to advanced level. At CIITN PHP training in Noida is supervised and managed by industrial experts having more than 10 years of experience in handling PHP projects. CIITN training comprises of both classroom as well as practical sessions to deliver an ideal environment for students that will enable them to handle difficult and complex situation when they would step into the reality of IT sector.CIITN is an excellent PHP training center in Noida with superior integrated infrastructure and newly designed labs for students to practice and pursue training for multiple courses at Noida. CIITN institute in Noida train thousands of students around the globe every year for the PHP training at an affordable price which is customised as per each candidate’s requirement of modules and content.

    PHP training in Noida

  41. CIITN is the Best Php training institute in Noida and delhi Ncr. You will get Live Project Training on PHP by our PHP expert who have 5+ year industrial experience.Focus on practical and live project training. In our PHP training, we you will learn core PHP, advance PHP, HTML, CSS, JavaScript, jQuery, Bootstrap, Cake PHP and Wordpress.CIITN provides 100% job assistance in PHP training. CIITN is well known PHP coaching center because our 100% PHP students are placed now.

    Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.

    java training institute in noida
    php training in noida
    linux training in noida
    linux institute in noida
    java course in noida

  42. CIITN provides Best Linux training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIITN Provides Best Linux Training in Noida. CIITN is one of the most credible offering hands on practical knowledge and full job assistance with basic as well as advanced level.

    best linux training institute in noida

    linux training in noida

  43. CIIT Noida provides Best MCA Courses in Noida based on the current IT industry standards that help students to get high paying jobs in Top MNCs. CIIT provides Best MCA Training in Noida, Greater Noida, and Ghaziabad. CIIT is one of the trusted MCA training institutes in Noida providing practical knowledge and 100% job assistance with basic as well as advanced level MCA subjects. CIITN is the best MCA college in Noida, greater noida, ghaziabad, delhi, gurgaon regoin.

    At CIIT MCA classes in Noida is conducted by subject experts corporate professionals with 9+ years of experience in managing real-time and live projects. Sofracle Nano Specialized MCA classes Noida is the perfect blend of academic learning and practical sessions to provide maximum exposure to students that transform an average student into a corporate professional whom companies prefer to hire.

    Best MCA College in Noida

  44. Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. This paragraph gives clear idea for the new viewers of blogging, Thanks you. You’re doing a great job Man, Keep it up.
    Oracle Training in Noida

  45. CIITN provides Best java training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs.The curriculum of our Java training institute in Noida is designed in a way to make sure that our students are not just able to understand the important concepts of the programming language but are also able to apply the knowledge in a practical way.

    if you are looking for the best oracle sql certification center in Noida, CIIT is worth to consider. CIIT is a oracle training institute offering best sql course, oracle training, sql certification and oracle dba training at affordable price. Best Oracle training in Noida.

    Java Training in Noida

    best java training in noida


    CIITN provides Big data hadoop training in Noida in Noida as per the current industry standards. Our training programs will enable professionals to secure placements in MNCs. CIITN is one of the most recommended Hadoop Training Institute in Noida that offers hands on practical knowledge/practical implementation on live projects and will ensure the job with the help of advance level Hadoop Training Courses. At CIITN Hadoop Training in Noida is conducted by specialist working certified corporate professionals having 8+ years of experience in implementing real-time Hadoop projects.CIITN is the best Hadoop training center in Noida with a very high level infrastructure and laboratory facility. The most attractive thing is that candidates can opt multiple IT training course at Noida location. We feel proud by announce that CIITN prepares thousands of candidates for Hadoop training at sensible fees structure which is sufficient for best Hadoop training in Noida to attend the Hadoop classes.Hadoop training course includes “Knowledge by Experiments” strategy to get Hadoop training and performing real-time practices and real-time modulation. This extra ordinary practices with live environment experience in Hadoop Training certifies that you are ready to apply your Hadoop knowledge in big corporations after the Hadoop training in Noida completed.

    Big data hadoop training in Noida

    B-12, Sector - 2, Noida, U.P
    State - Uttar Pradesh U.P
    Country - India
    Pin Code - 201301

    Phone - +917290926565
    Mon - Sun: 10am - 6pm

  47. Best Summer Internship In Noida

    These technologies prepare individuals for fields like software programming, technical support, graphic design, software testing, business analytics. Embedded Systems, Industrial Automation Training and more. Candidates go through a series of comprehensive practical sessions where they work on live problems and implement solutions on real-time basis.
    It has a dedicated placement cell which provides 100% placement assistance to students. The benefits that a student gets out of summer training are innumerable. CIITN,Best Summer training Center for B.Tech/CS/CSE/IT/ BCA/MCA/ B.E / / Engineering Student has already accomplished itself successfully in the field of Training and Development after setting milestones and bringing smiles to the faces of more than 1 Lakh students. CIITN was incorporated in the year 2002 and over the years CIITN has grown remarkably into the greatest training giant of Northern India.
    There is no looking back to technology! Those passionate for it need not worry about the professional prospects it offers. Courses and trainings in the field of Computer Science and Applications open a wide array of choices for individuals. All you need to do it prepare yourself right!

    Summer Internship Course In Noida

    Summer Internship Training In Noida