Search

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 (9.2.0.1.0) for Windows 32 bit
Oracle9i Client Release Notes Release 2 (9.2.0.1.0) 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)

51 comments:

  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

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

    ReplyDelete
    Replies
    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?

      Thanks

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

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

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

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

    ReplyDelete
  5. Hello Sir,

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

    ReplyDelete
  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?

    ReplyDelete
    Replies
    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!

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

    ReplyDelete
    Replies
    1. Hi Shahid,

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

      Thanksyou

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

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

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

      Delete
  9. Shahid sir

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

    Thanks brother.

    ReplyDelete
    Replies
    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

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

    ReplyDelete
    Replies
    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.‎

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

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

    ReplyDelete
  13. Hello
    sir
    i want needed your help

    ReplyDelete
    Replies
    1. Dear,

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

      Delete
  14. Thanks for sharing the information

    For more info : Oracle Certifications

    ReplyDelete
  15. Dear Path Infotech,

    Please upload the related link only.

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

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

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

    ReplyDelete
  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 http://pdf.ac/1KCBKE.

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

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

    ReplyDelete
  22. Pleae share documents for Oracle APPS DBA

    ReplyDelete
  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

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

    ReplyDelete
  25. Great information provided. I appreciate your work.

    Oracle DBA Training

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

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

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

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

    ReplyDelete
  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 www.ittrainingsonline.com.

    ReplyDelete
  31. This comment has been removed by the author.

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

    ReplyDelete
  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

    ReplyDelete
  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 http://www.maxmunus.com/contact
    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
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


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

    ReplyDelete