Kamran Agayev’s Oracle Blog

Kamran Agayev’s Oracle Blog

Oracle VIDEO Tutorials

Here you can find all my Oracle VIDEO Tutorials

Video Tutorial – Installing ASM on Linux and Windows  (.mp4 format)

Video Tutorial – Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS (.mp4 format)

Video Tutorial – Installing OEL and Oracle 10gR2      (.mp4 format)

RMAN Video Tutorial Series – Upgrading and Moving Recovery Catalog with IMPORT CATALOG command using RMAN in Oracle 11g    (.mp4 format)

RMAN Video Tutorial Series – Cloning database without connecting to the target database and recovery catalog in Oracle 11gR2    (.mp4 format)

RMAN Video Tutorial Series – Convert database from Windows to Linux using RMAN     (.mp4 format)

RMAN Video Tutorial Series – Creating Duplicate and Standby database using RMAN     (.mp4 format)

RMAN Video Tutorial series – Performing Disaster Recovery with RMAN     (.mp4 format)

RMAN VIDEO Tutorial series – Performing Block Media Recovery with RMAN     (.mp4 format)

Using rlwrap to get command line history in SQL*Plus – Video Tutorial    (.mp4 format)

61 Responses to “Oracle VIDEO Tutorials”

  1. Girish said

    June 29, 2010 at 12:32 pm

    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?

    Thanks..

  2. Kamran Agayev A. said

    June 29, 2010 at 2:45 pm

    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 said

    July 30, 2010 at 6:57 pm

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

  4. Girish said

    August 5, 2010 at 12:06 pm

    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.

    Thanks
    Girish

  5. Kamran Agayev A. said

    August 5, 2010 at 2:54 pm

    Dear Girish

    For this you need to use SET NEWNAME FOR DATAFILE command as it’s explained in the following documentation:
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm#sthref585

  6. Nesimi said

    August 16, 2010 at 12:27 pm

    Tesekkurler Kamran bey

  7. Roshan Fanse said

    August 17, 2010 at 5:05 pm

    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.

    Thanks

    Roshan

  8. Kamran Agayev A. said

    August 17, 2010 at 5:32 pm

    Hi Roshan

    It should be available for the March 2011

  9. shahid said

    August 28, 2010 at 2:18 am

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

  10. Javid said

    November 21, 2010 at 9:58 pm

    Teshekkurler!!!

  11. Kumar Ramalingam said

    November 23, 2010 at 12:36 am

    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.

    Thanks

  12. Kamran Agayev A. said

    November 23, 2010 at 10:20 am

    Dear Kumar

    Have you read my article on Flashback Data Archive?
    “https://kamranagayev.wordpress.com/2010/07/21/oracle-flashback-data-archive-total-recall/”

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

  13. Kumar Ramalingam said

    November 24, 2010 at 2:04 am

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

  14. kavita yadav said

    January 16, 2011 at 1:36 pm

    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
    Kavita

  15. Kamran Agayev A. said

    January 17, 2011 at 1:13 am

    Dear Kavita

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

  16. sharravanan said

    February 3, 2011 at 11:35 am

    Hi,
    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. said

    February 3, 2011 at 1:49 pm

    Thank you Sharravanan 🙂

  18. Suman Das said

    February 10, 2011 at 12:37 am

    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 said

    March 15, 2011 at 3:05 pm

    Can you upload video regarding RAC configuration

  20. Kamran Agayev A. said

    March 15, 2011 at 5:09 pm

    Hi Amirtesh

    I’m currently working on it

  21. Ahmed said

    March 16, 2011 at 7:50 pm

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

    March 16, 2011 at 10:08 pm

    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 said

    March 18, 2011 at 10:35 am

    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.

    Regards
    Lekha

  24. Kamran Agayev A. said

    March 18, 2011 at 10:37 am

    Hi Lekha

    I would suggest you to start reading documentation from http://tahiti.oracle.com :
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm

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

  25. Bhoodev P Sharma said

    March 18, 2011 at 8:51 pm

    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 said

    March 20, 2011 at 9:17 am

    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?

    Regards
    Lekha

  27. Lekha said

    March 21, 2011 at 11:29 am

    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.

    Regards
    Lekha

  28. Kamran Agayev A. said

    March 22, 2011 at 12:09 am

    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:
    http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/toc.htm

  29. Bhoodev P Sharma said

    March 31, 2011 at 8:46 pm

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

    April 1, 2011 at 9:30 am

    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 said

    April 27, 2011 at 2:57 pm

    Dear Kamran,

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

  32. Kamran Agayev A. said

    April 27, 2011 at 4:35 pm

    Thanks for feedback Syed

  33. mehdi said

    April 30, 2011 at 5:17 pm

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

  34. ravi said

    May 19, 2011 at 4:56 pm

    HI THIS IS RAVI I AM A TRAINER DBA I WANT TO LEARN 10G RAC OR 11 RAC PLEASE — I DON T KNOW HOW TO INSTALL
    AND HOW TO GET ALL SOFTWARE REGARDING RAC -CRS OR RAC PLEASE SUGGEST ME FROM WHERE I GET THAT SOFTWARE
    AND STEP HOW TO INSTALL IF VIDEO IS THERE IT IS GOOD FOR ME PLEASE LET ME KNOW I M WAITING TO YOUR RESPONSE.

    I HAVE 1LAPTOP AND I CAN ARRAGE 1 SYSTEM ALSO PLEASE PLEASE TELL ME HOW TO INSTALL RAC AND CRS SOFTWARE

    WHAT IS THE BASIC REQUIREMENT FOR THAT ,IF BOOK IS THERE IT IS GOOD.

    REGARDS,
    RAVI
    FROM INDIA

  35. ravi said

    May 19, 2011 at 4:56 pm

    HI HOW TO INSTALL RAC

    I DONT KNOW PLEASE TELL ME

  36. Kamran Agayev A. said

    May 20, 2011 at 9:53 am

    Check my blog. I’ve a step by step tutoril on this which consists of 150 screenshots!
    https://kamranagayev.wordpress.com/2011/04/05/step-by-step-installing-oracle-10g-rac-on-vmware/

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

  37. Sadock said

    June 14, 2011 at 6:35 pm

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

    June 16, 2011 at 3:08 pm

    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 said

    June 16, 2011 at 9:51 pm

    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

    Sadock

  40. shanmuk said

    June 24, 2011 at 6:53 pm

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

    June 25, 2011 at 1:50 am

    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 said

    July 11, 2011 at 10:13 pm

    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. Rashid Ali said

    July 13, 2011 at 9:41 pm

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

    regards
    Rashid Ali

  44. Kamran Agayev A. said

    July 14, 2011 at 9:10 am

    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

  45. Kamran Agayev A. said

    July 15, 2011 at 3:21 pm

    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!

  46. M. Arshad said

    July 20, 2011 at 6:17 pm

    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.

    Thanks.

    M.Arshad
    E-mail: arshad_0255@yahoo.com

  47. gaurav nigam said

    July 26, 2011 at 2:56 pm

    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 said

    August 6, 2011 at 4:40 pm

    Hello Sir

    I must say your blog is much useful.

    Thaks a lot

  49. purvi patel said

    August 9, 2011 at 3:21 pm

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

    August 11, 2011 at 1:58 pm

    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
    http://www.packtpub.com/oracle-11g-r1-r2-real-application-clusters-essentials/book

    Good Luck!

  51. purvi patel said

    August 11, 2011 at 3:36 pm

    Thanks sir

  52. Ashraf İslamsevər said

    August 12, 2011 at 7:39 pm

    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 said

    August 21, 2011 at 2:59 pm

    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?

    thanks

  54. Frank Ebo Quansah said

    August 25, 2011 at 5:03 pm

    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 said

    September 2, 2011 at 4:22 pm

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

    September 12, 2011 at 3:21 am

    how to install oracle forms 11g in windows 7

  57. takreem said

    September 15, 2011 at 10:29 pm

    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.

    Thanks

  58. Kamran Agayev A. said

    September 16, 2011 at 7:09 pm

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

  59. Kamran Agayev A. said

    September 16, 2011 at 7:17 pm

    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

  60. ashish said

    September 21, 2011 at 8:33 am

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

  61. Allam said

    October 2, 2011 at 11:41 pm

    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

    Regards,
    Allam M

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

 
%d bloggers like this: