Kamran Agayev’s Oracle Blog

Kamran Agayev’s Oracle Blog

61 Responses to “Oracle VIDEO Tutorials”

  1. Girish said

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

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

  4. Girish said

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

    Tesekkurler Kamran bey

  7. Roshan Fanse said

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

    It should be available for the March 2011

  9. shahid said

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

  10. Javid said

    Teshekkurler!!!

  11. Kumar Ramalingam said

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

    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

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

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

  16. sharravanan said

    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. Thank you Sharravanan 🙂

  18. Suman Das said

    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

    Can you upload video regarding RAC configuration

  20. Hi Amirtesh

    I’m currently working on it

  21. Ahmed said

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

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

    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

    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

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

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

    Dear Kamran,

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

  32. Thanks for feedback Syed

  33. mehdi said

    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

    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

    HI HOW TO INSTALL RAC

    I DONT KNOW PLEASE TELL ME

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

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

    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

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

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

    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

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

    regards
    Rashid Ali

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

    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

    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

    Hello Sir

    I must say your blog is much useful.

    Thaks a lot

  49. purvi patel said

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

    Thanks sir

  52. Ashraf İslamsevər said

    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

    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

    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

    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

    how to install oracle forms 11g in windows 7

  57. takreem said

    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. Installing Oracle products on Windows is simple, all you need is choose the product (item) and Click “Next” buttons

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

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

  61. Allam said

    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:

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 )

Connecting to %s

 
%d bloggers like this: