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

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

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

  35. 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

  36. Thanks for the explanation. It’s really helpful. Please keep sharing.
    Oracle Course in Delhi

  37. Learned a lot of new things from your post ,It's amazing article
    Sql server DBA Online Course Bangalore


  38. Really it was an awesome article… very interesting to read…
    Thanks for sharing.........

    oracle dba training in ammerpet

  39. My friend Suggest me this blog and I can say the best blog.Thank you so much for this. weblogic administration training

  40. My Genius Mind is a renowned academic portal that offers impressive academic support to the students.
    Live Chat @
    Read More @
    Western Australia Assignment Help
    Writing Services Melbourne
    Australia Best Tutor
    Hobart Tasmania Assignment Help

  41. It is really helpful !An opportunity to read a fantastic and imaginary blogs.It gives me lots of pleasure and interest. sap abap tutorial for beginners

  42. My Genius Mind is a reputed educational facility providing portal that has been offering high-end Assignment Services Melbourne solutions.
    Live Chat @

    Read More @ Brisbane Queensland Assignment Help
    Instant Assignment Help Tasmania
    Business Management Assignment Help


  43. Management Tutors is one of the Assignment Help UK that has been successfully rendering amazing academic assistance to the students.
    Live Chat @
    Read More @ Assignment Help Uk
    Assignment Help Malaysia
    Management Assignment Help


  45. Live Web Experts is a remarkable academic portal that is known for offering best regulation on Accounting Homework Topic to the scholars at a meagre price.

    Assignment Help Florida
    Online Tutoring Help California
    Essay Writing Services Illinois

  46. nice information provided for more please do visit us at
    Oracle Training in Texas

  47. Thank you for your valuable information.
    visit us:Oracle Training

  48. Dissertation Writing Services Ashford - Help in Dissertation is a remarkable academic portal that is known for offering extensive educational solutions. Parents can even Dissertation Writing Services Ashford.

    Live Chat @

    Read More @

    Dissertation Help Aberdeen UK

    Buy Essay Online Belfast

    Dissertation Services Belfast

  49. My Genius Mind is a well renowned academic portal that so known to offer amazing Management Assignment Help support to the students.

    Contact Information
    My Genius Mind
    Victoria, Melbourne, Australia
    Live Chat @

    Read More About @ Assignment Provider Canberra

    Calculus Assignment Help Adelaide

    Medical Assignment Help Perth

  50. Economics assignment answers NSW – Help with Assignments is a well-known academic portal that offers high-end economics answer help to the universities and college students. Live Chat @

    Read More @ Help with Homework Australia
    Algebra Assignment Solver
    Nursing Homework Assignment Victoria

  51. Amellie Taylor is a renowned academician writing on a series of academic topics. He is associated with the UK Best Tutor, a reliable academic portal. Amellie Taylor is the title of today’s content.
    Live Chat @

    Read More @ Online Homework Help Bristol
    Best Assignment Help Bristol
    Online Essay Writing Bristol

  52. Nursing Assignment Writer Kansas – The Best Tutors is a reliable academic portal that is known to offer exceptional educational assistance to the nursing assignment services students at a small price. Live Chat @

    Read More @ Nursing Assignment Writer Kansas
    Software Engineering Homework Help Alaska

  53. Webtrackker is one of the best Institute in Noida. In this Institutes we have offered to a student to get more and more information for your subject with both parts like theory and practise.

    Contact Us Information

    Webtrackker Technology
    C - 67, Sector- 63, Noida - 201301 (Delhi-NCR), INDIA

    Our Services

    Oracle dba training in Noida
    Python Training in Noida
    Salesforce training in Noida
    SAS Training in Noida
    IOT Training in Noida
    Devops training in Noida

  54. The expert Assignment Help Tutor England with the portals prepare a rough draft initially for the clients to consider. At this stage, modifications can be made if required. Once everything has been found to be good, the expert writes the final content.
    Live Chat @

    Read More @ Civil Engineering Assignment Help London
    Best Assignment Help Bristol
    Physics Assignment Help England

  55. Australia Best Tutor is available providing Help with Assignment Services Melbourne that help the students in preparing a relevant and innovative assignment paper. These experts are highly efficient and well trained.

    Live Chat @

    Read More About

    Assignment Help Melbourne
    Help with Assignment Melbourne
    Mathematics Assignment Help Melbourne
    Engineering Assignment Help Melbourne

  56. My Homework Help Services Australian Territory – Help with Assignments is a reliable academic company offering high-end direction and help to the students pursuing homework help at a very reasonable price.
    Live Chat @

    Read More @ Economics Help Online Victoria

    Management Assignment Help Victoria

  57. Nursing Assignment Writer Arkansas – The Best Tutors is a best academic portal that is known for success help in completing assignment services to the students. Live Chat @

    Read More @ Forensic Accounting Homework Help Alaska
    Pre- Calculus Homework Help Alabama

  58. My Genius Mind is a reputed academic concern that extends best professional Assignment Help to the students. This service can be availed at any time anywhere.
    Live Chat @
    Read More Information @ Accounting Assignment Help Brisbane
    Boston South Australia Assignment Help
    Mandurah Western Australia Assignment Help
    NewCastle NSW Assignment Help

  59. Management Tutors, known for offering fantastic coursework help to the students. It is beneficial to the students in the achievement of their goals and getting good grades by the teachers.
    Live Chat @
    Read More @ Dissertation Help Services Adelaide
    Business Management Help Melbourne
    Project Management Help Queensland
    Operational Management Assignment Brisbane

  60. The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
    Data Science Training in Chennai
    Data science training in bangalore
    Data science online training
    Data science training in pune
    Data science training in kalyan nagar

  61. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Devops training in Chennai
    Devops training in Bangalore
    Devops Online training
    Devops training in Pune

  62. Best Assignment Help NSW – Help with Assignments is best My Assignment custom firms make sure to send unique content. They assume severe research and provide sincere work permanently.
    Live Chat @

    Read More @ Business Finance Assignment Help Victoria
    University Nursing Assignment Help Queensland
    Homework Help Services Victoria

  63. The Best Tutors is a remarkable academic portal that is known for offering online dissertation services responses to the subtle students.Live Chat @ Essay Writing Services Arizona

    Read More @ Nursing Assignment Writer Arkansas
    Assignment Tutoring Help Alabama

  64. Australia Best Tutor is offering online assignment help services Australia at affordable price. Here students are joining for best academics grades and good quality content.Services are under below

    Engineering Assignment Help Brisbane
    Management Assignment Help Brisbane
    Assignment Writing Services Brisbane
    Nursing Assignment Help Perth
    Finance Assignment Help Perth

    Live Chat @

  65. UK Best Tutor is one of the famous and trustworthy academic portals that is known to provide the students with Assignment Help Scotland directly and successfully.
    Live Chat @

    Read More @ Online Assignment Writing UK
    University Assignment Help UK
    Assignment Help Tutor England

  66. Help with Assignments and offers impressive Help Engineering to the students in various subjects. When such tasks are submitted, the students are bound to get high marks or scores.
    Live Chat @

    Read More @ Marketing Management Assignment Help Queensland
    Help with Accounting Assignment Help Australian Territory
    Pay for Finance Assignment Help Queensland

  67. This comment has been removed by the author.

  68. The Best Tutors is a reliable and accessible academic portal that is known for offering exclusively detailed Accounting Homework help to the students.Live Chat @
    Read More @ Electrical Engineering Homework Help Colorado
    Thesis Writing Services Connecticut
    Thesis Writing Services Arkansas


  69. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.
    Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai
    AWS Training in Chennai |Best Amazon Web Services Training in Chennai
    AWS Training in Bangalore |Best AWS training in Bangalore
    Amazon Web Services Training in Tambaram, Chennai|Best AWS Training in Tambaram, Chennai

  70. Thank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me.
    python training in chennai
    python training in Bangalore
    Python training institute in chennai

  71. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    Devops training in sholinganallur
    Devops training in velachery
    Devops training in annanagar
    Devops training in tambaram

  72. Help with Assignments is a renowned academic portal that is known for offering general academic answers, including How to Homework. Live Chat @

    Read More @ Business Finance Assignment Help New South Wales
    Math Answer Online South Australia
    Nursing Assignment Help Queensland

  73. Best Tutors, The students can obtain help from the professional and expert authorities with abundant knowledge, which is given by us as a reliable and popular engineering homework help earner.Live Chat @

    Read More @ Online Homework Help Colorado
    Geometry Homework Help Colorado
    Finance Homework Help Colorado
    Online Homework Help Arkansas

  74. A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.

    rpa training in electronic-city | rpa training in btm | rpa training in marathahalli | rpa training in pune

  75. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us

    angularjs interview questions and answers

    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in chennai

    automation anywhere online Training

  76. This comment has been removed by the author.

  77. Great work did by you. Informative and problem-solving content that users can easily digest can work for all types of blogs. When a user finds something informative on a blog, he/she is more likely to come back from your side.
    Academic Assignment Help

  78. Great work did by you. Informative and problem-solving content that users can easily digest can work for all types of blogs. When a user finds something informative on a blog, he/she is more likely to come back from your side.
    Custom Writing Services