Kamran Agayev's Oracle Blog

Oracle Certified Master

126 Responses to “Oracle VIDEO Tutorials”

  1. Girish Says:

    Hi Kamran Agayev,

    Good video tutorial on “Performing disaster recovery with RMAN”.
    I have a question for you… What if the destination mount points are different? How the RMAN Performance the recovery with different destination mount points?


  2. Kamran Agayev A. Says:

    Hi Girish

    In such case you’ll SET NEWNAME FOR DATAFILE 1 TO ‘/filename’ command to change the default location of the specified filename

  3. Badr Says:

    Awsome tutorial! Very comprehensive and very well commented!
    Loved it! Can´t wait for the next one.

  4. Girish Says:

    Thanks Kamran for your reply.

    I have some more question.

    Rman backup has been taken with nocatalog
    source rman backup: /u01/backup/rman

    This rman backup has to be restored on a remote server with different mount points. How this can be carried out? Please provide steps.


  5. Kamran Agayev A. Says:

    Dear Girish

    For this you need to use SET NEWNAME FOR DATAFILE command as it’s explained in the following documentation:

  6. Nesimi Says:

    Tesekkurler Kamran bey

  7. Roshan Fanse Says:

    Hi Kamran,

    Just want to know when is your Oracle Backup and recovery book will be available in the market.

    I really want to buy that book.

    Please reply as soon as possible.



  8. Kamran Agayev A. Says:

    Hi Roshan

    It should be available for the March 2011

  9. shahid Says:

    could u please provide me a link for video trainning for implementing oracle streams………

  10. Javid Says:


  11. Kumar Ramalingam Says:

    Hello Kamran,
    I would like to get your feedback on the flashback archive (total recall) feature on 11gR2. I am trying to test it on 11gR2 on linux x86-64 and it is not working. The documentation does not demand any special setting on the database or init parameters.
    All I am doing is to create a tablespace, create a flashback archive and put a table under FBA mode. First of all the history tables are not being created. Then the FBDA background process dumps ORA-00942 error trying to find out the “supposed to be available” history tables..

    Have you tested this on single instance and RAC?
    On a single instance, this seems to take a while to create the history tables. Only after performing DML activity on that table,the tables are created. Do you have any insights? Any help would be appreciated.


  12. Kamran Agayev A. Says:

    Dear Kumar

    Have you read my article on Flashback Data Archive?

    I’ve shown a real-world demonstration on this feature

  13. Kumar Ramalingam Says:

    Yes, I did see that. Would you tell me what was OS you tested on? I tested on a single instance 11gR2 and it created those history tables after a while. But it did create those tables.
    When I tested on our development environment which is a 3 node RAC, it is not at all working. I have a SR open on this issue and awaiting response.
    Did you observe the SYS_FBA tables as soon as you put your tables on FB mode? There is definitely an issue here. Please let me know your observations on this.

  14. kavita yadav Says:

    Hi ,
    Sir iam trying to install oracle10g on OEL 5.5 …….but in my case when i run ./runInstaller it takes my ORACLE_HOME as
    u1/oracle/oracle/product/10.2.0/db_1 then i browse it and make it as
    u1/oracle/product/10.2.0/db_1 then i start with installation and when it is been prompted to logged in as root and execute the script first one i execute the second where u hve shown i.e cd $ORACLE_HOME/ when i execute iam not taken into db_1 directory Sir iknow iam going some where wrong so can u pls rectify me or tell me where am i going wrong

    Regards & Thanks

  15. Kamran Agayev A. Says:

    Dear Kavita

    Please follow my video tutorial and you’ll definetly success with installation

  16. sharravanan Says:

    Well ,I visit your video blog its very useful .. Thank u So much for your valuable effort . Keep uploading interesting things Even i forwarded the link to my all friend who r all career related to Oracle.

  17. Kamran Agayev A. Says:

    Thank you Sharravanan :)

  18. Suman Das Says:

    Hello Kamran Sir, thank you very much for these awesome informative videos of Oracle ASM and Grid control. Appriciate your help for posing these videos as always.

  19. Amritesh Says:

    Can you upload video regarding RAC configuration

  20. Kamran Agayev A. Says:

    Hi Amirtesh

    I’m currently working on it

  21. Ahmed Says:

    Hi Kamran,

    I was wondering if you have any Performing Disaster Recovery with RMAN tutorial for windows. Looks like the one you have is in linux. Sorry if this is an ignorant question.

  22. Kamran Agayev A. Says:

    Dear Ahmed

    As most companies uses Oracle on Linux, I try to perform all my video tutorials on Linux

    In windows it’s same, except you need to create a Windows Service using oradim utility

  23. Lekha Says:

    Hi Kamran,

    I am Lekha from India.I am very much interested in learning oracle dba stuff.As I am a newbie for this domain.I request you to suggest me some topics where I can start up and also I request you to provide me some links or documents where I can learn the basic things.


  24. Kamran Agayev A. Says:

    Hi Lekha

    I would suggest you to start reading documentation from http://tahiti.oracle.com :

    Moreover, you can watch my video tutorials and have base knowledge on some practical Oracle administration

  25. Bhoodev P Sharma Says:

    Thanks Kamran for putting such a great effort to help others and
    My self Bhoodev from India have find your documentation in good way
    Thanks once again

  26. Lekha Says:

    Hi Kamran,

    Thank you.Thankx a lot for the reply.I have one doubt using SQL Loader .How to upload xml files data using sql loader?


  27. Lekha Says:

    Hi Kamran,

    I have oracle 10gR2 in my system using VMWare I installed it.Now I wanted to upgrade that from 10g to 11g release 2.So,I request you to please provide me the steps of upgrading from 10gR2 to 11gR2.?

    Awaiting your reply.


  28. Kamran Agayev A. Says:

    Dear Lekha

    You can try two ways:

    – Using DBUA (Database Upgrade Assistan)
    – Using manual way

    I’d suggest you to follow the installation guide from the documentation:

  29. Bhoodev P Sharma Says:

    Thanks Dear Kam
    What is difference in creating RAC on VMware Server or VMware Workstation and which one is preferred and why
    Do you have some video of Oracle RAC which can help in going through to Oracle RAC
    Thanks in advance

  30. Kamran Agayev A. Says:

    Dear Bhoodev

    This week I’m going to post a very long, step by step explained guide for installing Oracle RAC on vmware. For the next week, I hope I’ll post its video tutorial as well

  31. Imtiaz Syed Says:

    Dear Kamran,

    Thanks for your time & splendid work which is highly appreciated, Keep it up.

  32. Kamran Agayev A. Says:

    Thanks for feedback Syed

  33. mehdi Says:

    Hi Kamran,
    I implemented a snapshot replication
    can i sync it by export and import when data is out of sync
    best reghrads ,

  34. ravi Says:





  35. ravi Says:



  36. Kamran Agayev A. Says:

    Check my blog. I’ve a step by step tutoril on this which consists of 150 screenshots!

    You can downoad all software from http://www.oracle.com

  37. Sadock Says:

    Kamran your doing a good job,God bless your work if you believe in HIM!

    But some of the VIDEO Tutorials (if not all) don’t have clear sound (low volume). Please can you rectify on this b’coz I am in high demand of your video to improve my Oracle Database Expertize

  38. Kamran Agayev A. Says:

    Hi Sadock

    Sure I believe in Allah, Most Gracious, Most Merciful

    Thanks for the feedback, I’ll try to increase the volume on my next video tutorials

  39. Sadock Says:

    Sorry Kamran

    Is it not possible to rectify on the current video tutorials, b’coz i need them, but they are disappointing me on volume especially these tutorial Installing ASM on Linux and Windows, and Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS


  40. shanmuk Says:

    hi sir
    am shanmuk
    am thinking to write oca can u suggest me the book and if any videos available to self prepartion

  41. Kamran Agayev A. Says:

    Dear Shanmuk, it depends on which version you’re going to give the exam. Check amazon.com by searching “oracle exam guide” keywords

  42. saheed Says:

    dear kamran

    Thanks for taking time to come up with site like this God will bless you. Please my

    problem is not only RMAN . i have done my OCA certification 10g, and am willing to

    do the OCP 10g(Admin ii 043) but i need the complete OCP video tutorial, to

    enable me study for the exam. Though i have OCP texbooks but i comprehend

    fastly with the video tutorial. i have done everything possible but could not get one.

    I beg you in the name of God kindly help me. If there is anybody in the house that

    can help. my email address is (silvadexy@yahoo.com)

  43. Kamran Agayev A. Says:

    Dear Saheed

    I’ve seen a video tutorial for OCP certification, but don’t think that it really helps you to get the OCP certification. There’s only a voice in the background whcih reads a text and demonstrates some basic steps ,that’s all

    I’d suggest you to read the documentation, make practices based on the subjects of the exam and read any certification book

    Good Luck!

  44. Rashid Ali Says:

    salam kamran brother plz send me video tutorial of oracle forms 10g plz
    i am waiting

    Rashid Ali

  45. Kamran Agayev A. Says:

    Salam Rashid

    I used Oracle Forms for some years, but now as I’m a DBA, I’m not using it and don’t have any video tutorial

  46. M. Arshad Says:

    Hello kamran , i saw your side that is very fantastic and clearly define regarding rman.
    Kamran i have a facing problem regarding rman backup and recovery oracle 9i.
    Can you help me. If you help me i would thankful to you.

    Please reply me and give me some issue solution.


    E-mail: arshad_0255@yahoo.com

  47. gaurav nigam Says:

    Hi Sir,

    Thanks for uploading such a nice VT.
    could u plese upload a video or provide any document related to Full Database Reorganization.

    thanks in advance.

  48. purvi patel Says:

    Hello Sir

    I must say your blog is much useful.

    Thaks a lot

  49. purvi patel Says:

    Hello Sir,

    I have some questions. Can u please tell me how can i learn managing oracle 10g on linux and oracle 10g RAC?

    I am waiting

    thank youu

  50. Kamran Agayev A. Says:

    Dear Purvi

    Here are my suggestions:

    – You can attend “Managing Oracle database on Linux” Oracle University
    – Install and configure RAC, start reading documentation and make practices
    – Read books that’re written for RAC on Oracle. The first one is the book “Real Application Clusters Handbook” for Gopalakrishnan, and the second one RAC for 11g “Overview of Oracle 11g R1/R2 Real Application Clusters Essentials” for Syed Jaffar Hussein

    Good Luck!

  51. purvi patel Says:

    Thanks sir

  52. Ashraf İslamsevər Says:

    Allah razı olsun qardaş.bu əməyin əvəzi inşallah cənnət olsun.çox həvəsli işləyirəm sizin tutoriallarla.inşallah bunların sayını artırmaq lazımdı biizniallah

  53. purvi patel Says:

    Hello sir,

    I am trying to create partitions on redhat 5 which i have installed in virtual box for practice.can u please tell me how can i accomplish this?


  54. Frank Ebo Quansah Says:

    I am Biochemist and an Oracle OCA working my way up to change my career and to
    OCP. Level. I love Oracle So much.
    Thanks for this tutorial.
    God Bless

  55. purvi patel Says:

    hello sir,

    can u please tell me that how can i get the practice scripts for 10g admin 1 and admin 2(the one which are given in practice after each chapter) ?

    i dont have that scripts

    thank u

  56. Kamran Agayev A. Says:

    Hi Purvi

    What do you mean with practice scripts? Do you mean OU course? If so, you can’t find it from anywhere, it’s used at OU courses only

  57. vasundhara Says:

    how to install oracle forms 11g in windows 7

  58. Kamran Agayev A. Says:

    Installing Oracle products on Windows is simple, all you need is choose the product (item) and Click “Next” buttons

  59. takreem Says:

    hello ,

    I am new to oracle world , i want to become Oracle DBA, so how should i start and how should i prepare for it . plz give me some useful material and videos to get knowledge.


  60. ashish Says:

    Great work … Thanks a lot for taking effort .. keep it up ..

  61. Allam Says:

    Hi Kamran,

    Can you please post the videos for the below topics. I would be more happy to follow your blog as it gives immense energy and confidence when we listen your videos and articles.

    Explain the general architecture of Oracle Data Pump
    Use Data Pump Export and Import to move data between Oracle databases

    Allam M

  62. Girish Says:

    Excellent Tutorial!

    Thank you!

  63. mramadhani Says:

    Hi Kamran.

    thanks you very much for your very very useful of video tutorials….. i have gone through with creating duplicate with RMAN….

    i could manage to clone 9i to 9i but the major consign is we have oracle ebusiness suite 11i backed is 9i…..so when I resnchronize clone using RMAN the login does not displayed.
    kindly please suggest any i would appreciated you help.



  64. Kamran Agayev A. Says:

    Please post the whole error you get

  65. John A Says:

    Hi Kamran,
    I am getting the following error. Do you know why?
    RMAN> duplicate database to “test” backup location ‘/nas/temp/’ nofilenamecheck;

    Starting Duplicate Db at 12-DEC-11

    RMAN-00571: ===========================================================

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    RMAN-00571: ===========================================================

    RMAN-03002: failure of Duplicate Db command at 12/12/2011 12:31:18

    RMAN-05501: aborting duplication of target database

    RMAN-05579: CONTROLFILE backup not found in /nas/temp/


  66. John A Says:

    Hi Kamran,
    It is working fine now. The issue was that I was ftping the files as another user and “oracle” user did not have read permissions on those files. Once the permissions were set right it is working now.. Thanks for your great tutuorial.

    John A

  67. syed Says:

    Thankx for sharing your knowledge with video tutorials
    Really good work!!!

    I would request you to upload videos for oracle 10g architecture concepts … Hope u will do it!!

    pls tell me when it will be available, as m learning oca now..


  68. syed Says:


    i request you to upload dba architecture videos as m doing oca certification 10g.. pls help me out on this..


  69. Raj Gupta Says:

    Hello Sir,

    This is Raj Gupta, I have around 2 years exp. as Oracle DBA. Currently I am associated with Wipro Ltd.. Hope you heard that name? Thanks a lot for this effort I like your all valuable video of Oracle video tutorial.. Sir Now I want to install Oracle RAC system in my home computer for the same I have checked your site I got one of the link for the same and I am trying for the same. Sir I would like to request you if you have any video for Oracle RAC installation On VMware (Linux) then I please share with on your blog/site.

    Raj Gupta(India)

  70. sarah Says:

    hi kamran.

    i followed your Instructions for “database converted” i modified converted database and modified successfully but when i try for sqlplus it gave me error command not found,i have fresh linux there is no database installed before.
    do i need to install database for db_1 directory or we can use the converted database?
    plz looking for more help.


  71. sadiq Says:

    i need clear oracle architecture 10g or 11g
    please upload video tutorials

  72. Kamran Agayev A. Says:

    Check this link for the Oracle Architecture 10g

  73. Amit Mukherjee Says:

    Dear Kamran,

    I really like your all video tutorial. It’s really very good. Could you please upload a RAC installation and configuration video.


  74. Kamran Agayev A. Says:

    Hi Amit

    Check my step by step RAC guide

  75. Amit Mukherjee Says:

    Many Thanks Kamran.. I really appreciate your knowledge in Oracle Field :). From this blog we all are benefited.. And really this is the best blog I ever seen.

    Thanks again for your kind help.

  76. Kamran Agayev A. Says:

    You’re welcome Anit! Thanks for feedback

  77. Muhd Aarif Says:

    Salam Kamaran Bhai….

    I want to know that is there any book or full tutorial on ORACLE FORMS9i/10g/11g into your site where each thing get understand with good graphic..kindly confirm as I’ve some books on forms/reports but they are not so useful for me to do the well work on D2K and for clearing interview…Kindly reply with best book or tutorial….I’ll be very regardful for u….Thanx….

  78. Amit Mukherjee Says:

    Dear Kamran,

    Could you please upload a Dataguard installation and configuration video. Also if you have some video on oracle streams then please upload the same

    Many thanks in advance.


  79. Kamran Agayev A. Says:

    Hi Amit, check the following tutorial:

  80. Amit Mukherjee Says:

    Many Thanks Kamran..

  81. rohit Says:

    Hello Sir,

    How are you doing???

    I’m a great fan of yours as the videos provided by you helped me a lot.

    I want to know configuring RAT(Real Application Testing) on Oracle 11g.

    If you have any link or material that works then would be great help.

    Please assist me.


  82. vikas dharmadhikari Says:

    Hi Sir,
    I am installing oracle 10g on RHEL 6 ,64 bit but i could not installed it
    so please will you share how to install oracle 10g on RHEL 6 ?

  83. Kamran Agayev A. Says:

    Have you checked my video tutorial and step by step article?

  84. Fuqi Says:

    These are great efforts you have done. These videos are very useful who are new in this field. I am also new one. i am trying to install RAC 10g on Linux from your snapshot tutorial, but i fail to do so. Can you provide the video of Installing RAC on Linux.I will be very thankful to you. There are so many people who are demanding the same. Thanks

  85. hh Says:

    Oracle Middleware Architecture authentication and authorization for the users?

    I’m new to Oracle based applications and I have been assigned a project to understand company’s authorization process which comprises mostly of Oracle based applications.

    I have been asked to study –

    1. Understanding of Oracle middleware architecture – authentication, authorization, Application User Privileges.

    2. Oracle ebusiness suite framework

    But due to number of application and different versions of applications I’m not sure where to begin with.

    Where do I start considering no prior experience with Oracle based applications?

    Thanks for your time!

  86. ram prasad Says:

    hi kamran. I want to install rhel 5.0 on my laptop.I am using Vmware workstation.At the same time i want to install oracle 10g r 10.2.0.So can u suggest me how may mount points are required for installing oracle.

    pls tell me abt this also.how many mount points are required for linux? how much space should i reserve for each mount point?.What are the rpms required for oracle 10g installation.

    few days back when i am trying to install oracle 10g, i created a oracle user.But whn i log in to the system the prompt i am getting is bash 3.1$.I am not getting a oracle user prompt directly.In this prompt whn i issue any command it is throwing an error as Permission denied.Please tell me a solution for this problem.

  87. Shweta Says:

    Sir i just want to Rac Notes and how to installed it with video. If possible please tell me job of oracle dba for fresher level

  88. Noor Zaman Says:

    Hello Sir .. my name is Noor Zaman from Pakistan.. Sir i need Utl email Sending configuration video.. sir can u send me…? for Oracle 10g

  89. Nilesh Says:

    Sir can you send me tutorial for installation oracle rac on windows. And sir ur video is very very helpful…
    Thanks Sir

  90. Kamran Agayev A. Says:

    I haven’t already created the RAC tutorial for Windows yet

  91. Faisal Says:

    when i am going to login from oracle user on my REDHAT LINUX5, following error appeared.
    $HOME/.dmrc is being ignored … the file should be owned by the user and have 664 permision, user’s HOME directory should be owned by the *.dmrc

  92. Kamran Agayev A. Says:

    Check the following link:

  93. vinay Says:

    your videos are really awesome and if by any chance do you have any videos related to performance tuning would be really helpful sir.

  94. syed Says:

    how to backup in multipaths using RMAN backup..pls help me out!!i did configure with disk 1 and disk 2 but its not working any other option pls explain…

    thanks in advance

  95. OraDBA Says:

    Great Work Kamran !. your videos are blessings !.

    Please post a Video of Oracle 11gR2 RAC configuration.


  96. Nikil Says:

    Hi Kamran
    Can you please post video for 10gR2 RAC(I see the screen shot, then you also have the video) and 11gR2 RAC Installation and configuration for OEL5.


  97. Kamran Agayev A. Says:

    I’ve already posted a step by step guide for installing 10g rac on vmware:

  98. Sanchit Gupta Says:

    Mind blowing….

  99. Huun Ecem Says:

    Thank you!

  100. jagadesh Says:

    hello sir,
    please provide me oracle upgrade from to 11.2.03 step by step…

    Thanks in advance

  101. Kamran Agayev A. Says:

    I would suggest you to read Oracle Upgrade Guide from the documentation

  102. Tamil Says:

    HI Kamran,

    just now i completed my graduation ,i like to study Oracle DBA,kindly suggest me how to learn and understand the concepts,and also about the materials too,please suggest me ……

  103. Kamran Agayev A. Says:

    I’d suggest you to read the following article written by Turkish Oracle Expert – Tonguc Yilmaz


  104. ben Says:

    you are such a great man.welldone for the good work u’v bin doing.Pls can you do something like video on RAC?

  105. shilpa Says:

    Hi Sir,
    I want Video tutorials of real issues that faced by DBA

  106. Satish M Says:

    Grate work you doing sir ,

    Please share some SGA internal and
    link for internal of oracle

  107. PANKAJ Says:

    Hi Sir,

    Can you please shared the Detail Focus on RMAN

    I want Video tutorials of RMAN for Backup & Recovery

  108. PANKAJ Says:

    Thanks in Advance..

  109. Rajesh Says:

    Hi Kamran,

    Nice article. Expecting more video tutorials from you.
    Especially from High Availability options and Tuning.

    Keep going..


  110. Yaseen Says:

    Hi Kamran,
    Excellent .. May Allah Bless you with more knowlege.
    ut would be helpful if you can tel me how to download these videos for future references.
    Thanks in advance.

  111. Mohanraj Says:

    Hi Kamran.
    your postings are really superb and very very helpful.
    thanks a lot and keep update this will be very use full newbies.

    Thanks and rgs

  112. Kamran Agayev A. Says:

    Hi Mohanraj, thank you for the feedback

  113. BHARATH Says:

    hello sir,
    please provide me oracle upgrade from 11GR1 TO 11GR2 step by step…

    Thanks in advance

  114. Shahriyar Says:

    SALAM aleykum.

    Oracle DBA öyrənmək və bu sahədə karyera qurmaq üçün My/MsSQL və ya digər yardımçı proqramlar öyrənməliyəm?
    Sizə işinizdə uğurlar,ALLAH elminizi artırsın.Amin.

  115. Kamran Agayev A. Says:

    Salam Shahriyar
    Xeyr, Oracle oyrenmek ucun MSsql ve ya MySql db-lerini oyrenmek shert deyil

  116. Ratnesh Says:

    Hi Kamaran,

    Great posting of videos.


  117. Mohamed Gani Says:

    Hi Kamran,

    Thanks for your videos. Where will I get audio files for Oracle 11gR2 RAC (Installation/Administration/Maintenance)?. I like to hear the audio files when I am driving. In Dubai, most of the times we struck in traffic, hence audio files are useful for the guys like me to listen peacefully. Kindly advise ASAP.

  118. Kamran Agayev A. Says:

    Hi Mohamed
    Unfortunately I don’t think Oracle Audio books can be useful at this moment. So I don’t have any plan to work on it

  119. Roshan Says:

    Hi Sir,

    Saw your ASM on 10R2 installation, that was absolutely perfect.
    Need To install 11gR2 ASM and Grid on Linux.

  120. Mohamed Gani Says:

    Expecting more vidoes on High Availability options and Performance Tuning.

  121. jagadesh Says:

    Hello Sir,

    i’m expecting on performance issue on Oracle 11gR2 as well as how many index creation can be done for table & how to keep update parameter to avoid performance issues ..can you please provide videos on it…

  122. Femi Adeyemi Says:

    Thanks for this video tutorial

  123. FANGAMOU Says:

    Good morning everybody,
    It’s possible to change the DB name after the installation but under certains conditions. What are those conditions exactly?

  124. Kamran Agayev A. Says:

    Hi Fangamou
    There’re a lot of blog posts related with changing database name. Check the following link:

  125. Zulal Bayramov Says:

    Hi Kamran,
    Do you have the heteregenous os data guard installation tutorial? (primary-windows,standby-linux)
    Thank you.

  126. Kamran Agayev A. Says:

    Hi Zulal. For heteregenous data guard installation/configuration you can refer to Mahir Quluzade’s post

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>