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?
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.
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
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
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.
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.
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.
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.
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.?
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
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
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.
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
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
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
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.
– 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
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
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.
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
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.
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.
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.
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.
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.
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….
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
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?
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.
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
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…
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.
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 ……
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.
Yaseen
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.
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.
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…
June 29th, 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..
June 29th, 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
July 30th, 2010 at 6:57 pm
Awsome tutorial! Very comprehensive and very well commented!
Loved it! Can´t wait for the next one.
August 5th, 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
August 5th, 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
August 16th, 2010 at 12:27 pm
Tesekkurler Kamran bey
August 17th, 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
August 17th, 2010 at 5:32 pm
Hi Roshan
It should be available for the March 2011
August 28th, 2010 at 2:18 am
could u please provide me a link for video trainning for implementing oracle streams………
November 21st, 2010 at 9:58 pm
Teshekkurler!!!
November 23rd, 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
November 23rd, 2010 at 10:20 am
Dear Kumar
Have you read my article on Flashback Data Archive?
“http://kamranagayev.wordpress.com/2010/07/21/oracle-flashback-data-archive-total-recall/”
I’ve shown a real-world demonstration on this feature
November 24th, 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
January 16th, 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
January 17th, 2011 at 1:13 am
Dear Kavita
Please follow my video tutorial and you’ll definetly success with installation
February 3rd, 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.
February 3rd, 2011 at 1:49 pm
Thank you Sharravanan
February 10th, 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.
March 15th, 2011 at 3:05 pm
Can you upload video regarding RAC configuration
March 15th, 2011 at 5:09 pm
Hi Amirtesh
I’m currently working on it
March 16th, 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.
March 16th, 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
March 18th, 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
March 18th, 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
March 18th, 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
March 20th, 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
March 21st, 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
March 22nd, 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
March 31st, 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
April 1st, 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
April 27th, 2011 at 2:57 pm
Dear Kamran,
Thanks for your time & splendid work which is highly appreciated, Keep it up.
April 27th, 2011 at 4:35 pm
Thanks for feedback Syed
April 30th, 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
May 19th, 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
May 19th, 2011 at 4:56 pm
HI HOW TO INSTALL RAC
I DONT KNOW PLEASE TELL ME
May 20th, 2011 at 9:53 am
Check my blog. I’ve a step by step tutoril on this which consists of 150 screenshots!
http://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
June 14th, 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
June 16th, 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
June 16th, 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
June 24th, 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
June 25th, 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
July 11th, 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)
July 15th, 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!
July 13th, 2011 at 9:41 pm
salam kamran brother plz send me video tutorial of oracle forms 10g plz
i am waiting
regards
Rashid Ali
July 14th, 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
July 20th, 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
July 26th, 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.
August 6th, 2011 at 4:40 pm
Hello Sir
I must say your blog is much useful.
Thaks a lot
August 9th, 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
August 11th, 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!
August 11th, 2011 at 3:36 pm
Thanks sir
August 12th, 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
August 21st, 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
August 25th, 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
September 2nd, 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
September 16th, 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
September 12th, 2011 at 3:21 am
how to install oracle forms 11g in windows 7
September 16th, 2011 at 7:09 pm
Installing Oracle products on Windows is simple, all you need is choose the product (item) and Click “Next” buttons
September 15th, 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
September 21st, 2011 at 8:33 am
Great work … Thanks a lot for taking effort .. keep it up ..
October 2nd, 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
November 11th, 2011 at 10:25 pm
Excellent Tutorial!
Thank you!
December 1st, 2011 at 7:55 pm
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.
Thanks
mramadhani.
December 9th, 2011 at 7:00 am
Please post the whole error you get
December 12th, 2011 at 7:37 pm
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/
Thanks
JohnA
December 12th, 2011 at 11:07 pm
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.
Thanks
John A
December 19th, 2011 at 8:13 pm
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..
JazakAllah
December 20th, 2011 at 6:31 pm
REALLY GOOD WORK!!!
i request you to upload dba architecture videos as m doing oca certification 10g.. pls help me out on this..
Jazakallah
December 25th, 2011 at 1:57 pm
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.
Regards’
Raj Gupta(India)
January 25th, 2012 at 9:53 am
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.
sarah
February 11th, 2012 at 6:17 pm
hi
i need clear oracle architecture 10g or 11g
please upload video tutorials
February 12th, 2012 at 4:19 pm
Check this link for the Oracle Architecture 10g
http://kamranagayev.com/2009/08/10/oracle-10gr2-architecture-learn-it-by-heart/
February 13th, 2012 at 6:55 pm
Dear Kamran,
I really like your all video tutorial. It’s really very good. Could you please upload a RAC installation and configuration video.
Regards
Amit
February 14th, 2012 at 9:54 am
Hi Amit
Check my step by step RAC guide
http://kamranagayev.com/2011/04/05/step-by-step-installing-oracle-10g-rac-on-vmware/
February 14th, 2012 at 12:21 pm
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.
February 14th, 2012 at 1:54 pm
You’re welcome Anit! Thanks for feedback
February 18th, 2012 at 6:02 pm
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….
March 8th, 2012 at 9:31 am
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.
Regards
Amit
March 8th, 2012 at 9:33 am
Hi Amit, check the following tutorial:
http://kamranagayev.com/2010/06/25/rman-video-tutorial-series-creating-duplicate-and-standby-database-using-rman/
March 8th, 2012 at 9:45 am
Many Thanks Kamran..
March 9th, 2012 at 10:31 am
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.
regards,
rohit
March 20th, 2012 at 1:24 pm
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 ?
March 21st, 2012 at 6:49 pm
Have you checked my video tutorial and step by step article?
http://kamranagayev.com/2009/05/01/step-by-step-installing-oracle-database-10g-release-2-on-linux-centos-and-automate-the-installation-using-linux-shell-script/
http://kamranagayev.com/2010/04/25/video-tutorial-installing-oel-and-oracle-10gr2/
March 26th, 2012 at 11:34 am
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
April 9th, 2012 at 7:13 am
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!
May 18th, 2012 at 6:02 am
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.
May 25th, 2012 at 6:33 am
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
June 1st, 2012 at 6:27 am
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
June 4th, 2012 at 7:11 am
Sir can you send me tutorial for installation oracle rac on windows. And sir ur video is very very helpful…
Thanks Sir
June 4th, 2012 at 8:45 am
I haven’t already created the RAC tutorial for Windows yet
June 25th, 2012 at 8:21 pm
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
June 27th, 2012 at 3:55 am
Check the following link:
http://mihirknows.blogspot.com/2008/06/homedmrc-file-is-being-ignored-solved.html
June 27th, 2012 at 3:38 pm
sir,
your videos are really awesome and if by any chance do you have any videos related to performance tuning would be really helpful sir.
July 7th, 2012 at 1:48 pm
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
July 14th, 2012 at 4:29 pm
Great Work Kamran !. your videos are blessings !.
Please post a Video of Oracle 11gR2 RAC configuration.
Oradba
July 25th, 2012 at 6:31 pm
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.
Thanks
August 2nd, 2012 at 7:33 am
I’ve already posted a step by step guide for installing 10g rac on vmware:
http://kamranagayev.com/2011/04/05/step-by-step-installing-oracle-10g-rac-on-vmware/
August 29th, 2012 at 2:26 pm
Mind blowing….
September 14th, 2012 at 6:43 pm
Thank you!
October 3rd, 2012 at 2:42 pm
hello sir,
please provide me oracle upgrade from 10.2.0.4 to 11.2.03 step by step…
Thanks in advance
October 30th, 2012 at 11:36 am
I would suggest you to read Oracle Upgrade Guide from the documentation
http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
October 14th, 2012 at 4:40 am
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 ……
October 30th, 2012 at 11:28 am
I’d suggest you to read the following article written by Turkish Oracle Expert – Tonguc Yilmaz
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
October 15th, 2012 at 1:12 pm
you are such a great man.welldone for the good work u’v bin doing.Pls can you do something like video on RAC?
October 19th, 2012 at 6:11 am
Hi Sir,
I want Video tutorials of real issues that faced by DBA
November 7th, 2012 at 1:34 pm
Grate work you doing sir ,
Please share some SGA internal and
link for internal of oracle
November 8th, 2012 at 7:34 am
Hi Sir,
Can you please shared the Detail Focus on RMAN
I want Video tutorials of RMAN for Backup & Recovery
November 8th, 2012 at 7:35 am
Thanks in Advance..
November 9th, 2012 at 5:05 am
Hi Kamran,
Nice article. Expecting more video tutorials from you.
Especially from High Availability options and Tuning.
Keep going..
Regards,
-Rajesh
December 20th, 2012 at 3:27 am
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.
Yaseen
July 29th, 2013 at 11:36 am
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
Mohanraj.S
August 5th, 2013 at 4:02 am
Hi Mohanraj, thank you for the feedback
October 30th, 2013 at 7:13 am
hello sir,
please provide me oracle upgrade from 11GR1 TO 11GR2 step by step…
Thanks in advance
BHARATH
February 6th, 2014 at 8:11 pm
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.
June 17th, 2014 at 3:55 am
Salam Shahriyar
Xeyr, Oracle oyrenmek ucun MSsql ve ya MySql db-lerini oyrenmek shert deyil
April 15th, 2014 at 2:23 pm
Hi Kamaran,
Great posting of videos.
Thanks.
September 10th, 2014 at 5:26 am
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.
September 16th, 2014 at 5:21 am
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
Thanks
September 21st, 2014 at 12:44 pm
Hi Sir,
Saw your ASM on 10R2 installation, that was absolutely perfect.
Need To install 11gR2 ASM and Grid on Linux.
October 22nd, 2014 at 3:24 am
Expecting more vidoes on High Availability options and Performance Tuning.
January 3rd, 2015 at 5:52 pm
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…
March 19th, 2015 at 6:03 am
Thanks for this video tutorial
March 20th, 2015 at 8:28 am
Good morning everybody,
It’s possible to change the DB name after the installation but under certains conditions. What are those conditions exactly?
April 7th, 2015 at 5:19 am
Hi Fangamou
There’re a lot of blog posts related with changing database name. Check the following link:
http://bit.ly/1FwPgx8
August 6th, 2019 at 7:28 am
Hi Kamran,
Do you have the heteregenous os data guard installation tutorial? (primary-windows,standby-linux)
Thank you.
August 6th, 2019 at 8:57 am
Hi Zulal. For heteregenous data guard installation/configuration you can refer to Mahir Quluzade’s post