Kamran Agayev's Oracle Blog

Oracle Certified Master

About me


I’m Oracle Certified Master and Oracle ACE Director  with 7 years of experience managing UNIX- based Oracle Databases.

As  a  working  IT  professional,  I  have  experience  in  a  wide  range  of  mission  critical  technologies, specializing in database administration best practices for backup and recovery.   I have hands-on experience with real-world Production environments and have risen in the ranks from a developer to a managing DBA.

Currently I’m working at AzerCell Telecom as an Expert DBA and serve as a lecturer teaching Oracle Database Administration at Qafqaz University.

I’m an author of the book – “Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump

I’m also frequent speaker at Oracle related conferences at USA, Japan, China, Thailand, Finland, Turkey and Azerbaijan and also deliver a class about Oracle Database Administration at Qafqaz University and pursue Phd in Computer Science at Institute of Information Technology

I’m available at Twitter, Facebook Linkedin and MSN

177 Responses to “About me”

  1. sunil Says:

    hi sir,
    i am impressed by your remarks for my question in oracle forums.
    i am just about to be graduated.
    can please help in guiding my career in your foot steps.
    i am also very much instrested in working on oracle.
    i am currently preparing for ocp fundamentals exam.
    lokking forward for your reply.

    regards sunil

  2. Kamran Agayev A. Says:

    Hi Sunil
    I’d suggest you to read documentations and some Oracle books. Refer to tahiti.oracle.com and there you can find 2 Days Administration Guides which will guide you through the basic administration tips
    Moreover, you should practice a lot. Without practicing, you will not be able to learn more
    I’d suggest you to refer to Oracle Ace Tonguc Yilmaz’s well written article, related with Oracle Introduction for newbies. You can find it from below link:

    Good Luck. Keep reading, practicing and asking your questions (of course after google-ing it 😉 ) on OTN forums :)

  3. Orhan Eripek Says:

    Privet Kamran!

    tebya pozdravliyayu iz za tvoy krasiviy blog. ya tebya iz oracleturk yahoo group znayu… u menya nick ‘ordba’ i moy blog: http://www.ordba.blogspot.com … ti j azeri i ya znayu shto ti toje znayesh russkiy yazık, iz za etogo hatel tebya po ruskiy pisat.. tak j interesno :))
    esli sprosish, ya v kırgızstane uchilsya 5 let, poetomu znayu po ruskiy i uje 9 let gavaryu…
    xarosho shto u tebya uje est OCA i OCP sertifikat… nedeyus u menya toje budet skora, no poka ne dumayu..

    poka, tebya poka. 😉

  4. Kamran Agayev A. Says:

    Oooo Privet Orhan. Kak dela? :)
    Mashallah vidno shto russkiy ti otlicno znayesh :) That’s perfect!

    Cok memnun oldum sen blog-umda gormeye Orhan. Comment icin, ilgin icin sana tesekkur ediyorum
    Inshallah sen de imtahana hazirlasib o sertifikalari alarsan. Onemli olan sertifika deyil, onemli olan bilgi, ve tecrubedir
    Sene uqurlar arzulayiram :) Blogu tez tez ziyaret et. Gorusuruz kendine iyi bak (Commentim 4 dilde oldu :) )

  5. Krishna Says:

    Hi Kamran Agayev,

    I need the links for Books on RMAN backups and on Datapump.

    And i need some critical scenarious which we face as DBA.

    Thanks & Regards,

  6. Kamran Agayev A. Says:

    Hi Krishna. The link of the book is on my home page :) But this book hasn’t finished yet, so when it’ll be finished, I’ll inform you
    In this book, you’ll see many different scenarious which every DBA may face in his career

  7. aniruddha Says:

    hello kamran. i want to learn oracle and start a career as dba. i am a rhce. but am confused which exam i will go for. will i go for 9i dba exams or 10g dba exams particularly. and there is also 11g. plz advice me which way to go? i also want to learcn rac. and another q, is it necessary to learn pl/sql if i work as dba.

    thx for this wonderful blog. i have completed installing 10g on centos 5.3 using virtualbox v3.

  8. Kamran Agayev A. Says:

    Hi aniruddha and welcome to my blog
    If you’re at the beginning of Oracle career, don’t try to start from exam. Try to read some docs (Administrators Guide and Concept) from http://tahiti.oracle.com

    Then, I’d suggest you to read Sybex books to prepare to Oracle exams. Yes, there’re mainly 3 different versions in Oracle which you can give an exam. 9i is not supported version of Oracle but to be more successful, I’d suggest you to start learning from 9i. Because there’re many things that were automated in 10g. By starting from 10g or 11g, you may be aware of some Oracle features (especially in Performance Tuning). It’s my suggestion. But you can even start from 11g. It’s the new supported version
    But remember, to be 11g OCP by having any 9i or 10g exam, you’ll need to pass only one “New Features” exam. It’s the same for 10g. If you passed 9i exams, you’ll need to pass only one exam to be 10gOCP and another one exam to be 11gOCP

    It’s necessary to know SQL and PL/SQL to be successfull DBA. You don’t need to learn PL/SQL at developers level, but you need to know some basics as well

    Good Luck!

  9. ad Says:

    thx a lot kamran for ur suggestion. i will surly start from oracle 9i.

  10. Rufat Says:

    Salam Kamran muallim . Man ozum Java proqrammistam . Lakin hala hech vaxt Oracle-la islamamisam . Esasen MySQL -le ishlemisem . Database-ler haqqinda yaxshi melumatim var .PL/SQL-i ise bilmirem .
    1. Siz mana hansi kitablari maslahat gorerdiniz ki baslayim oxumaga ?
    2. Eger praktiki masalalarda tetbiq ede bilmeyecemse oxumagin na daracada faydasi olacaq (sadece bizim proyektde Oracle tetbiq edilmir :( )

  11. Kamran Agayev A. Says:

    Salam Rufat

    Evvela sen ozune kankret bir yön secmelisen. DBA olmaq isteyirsen yoxsa Developer? Onlar ferqli ferqli seylerdi. Eslinde her DBA bir developer kimi development-i bilmelidi (bu Oracle-da beledi). Amma her Developer ise DBA kimi administration bilmese de olar

    Eger bundan sonra Java-ya davam edeceksense, onda Oracle baresinde besit administration biliklerini menimseyib esas Development-e guc vermelisen. Yeni SQL ve PL/SQL dillerini advanced seviyyede menimsemelisen

    Bu berede kitablar coxdu. En tovsiye etdiyim kitab, “PL/SQL by examples” kitabidi (fourth edition). Web-den pdf versiyasini tapib oxuya bilersen.

    O ki qaldi praktika meselesine, bu umumi bir problemdi. Tek bizim olkede yox, butun dunya olkelerinde demek olar ki beledi. Sen menim sene tovsiye etdiyim kitabi tap, oxumaqa bashla. Orada olan butun misallari ozunde tetbiq et. Sonra her hansi bir sirketde PL/SQL isine uyqun olaraq Junior isci kimi ise bashlayib gelecekde istedyin praktikani yiqacaqsan


  12. Tanny Says:

    Excellent Blog !

    Basically I m pursuing BE Computer Engg. , and I have lot interest in Database, Datawarehousing & Data Mining.
    I want to pursue my career in DB Administration or Warehousing.

    Q.1 : Is BE + OCA sufficient for starting career in databases ?
    Or are there any other courses that can help me get into Dataware housing ?

    Q.2 : What is scope as fresher ? What things I need to consider for getting entry level job as junior DBA ?

    Thanx for ur help in advance.
    Hope ur advice helps me brighten up my future…..ofcourse as DBA

  13. Kamran Agayev A. Says:

    Dear Tanny

    I think that you’ll start your Oracle career as a Junior DBA. But one thing should be mentioned that administering VLDB (Very large database – data warehouse) and OLTP systems are different. So you need to make a decision for that.

    I’d suggest you to read documentation, read some certification books and practice, practice and practice

    Good Luck !

  14. Tanny Says:

    Thanx a lot sir…..!

    Just one more thing…can u suggest me some books which can help me for practicing at home as I have opted for self-study mode….

    Or should I continue with certification books from oracle press ?

  15. PiterJankovich Says:

    My name is Piter Jankovich. oOnly want to tell, that your blog is really cool
    And want to ask you: is this blog your hobby?
    P.S. Sorry for my bad english

  16. Kamran Agayev A. Says:

    Hi Piter and welcome to my blog
    I’m blogging because I love it. I love to help people and share my knowledge. It’s my hobby and way of life :)

  17. Nadeem Hameed Says:

    Salam o alikum,

    You are simply impressive. May Allah bless you more success in life.


    Nadeem Hameed
    Saudi Arabia.

  18. Kamran Agayev A. Says:

    Va aleykum Salam Nadeem

    Thank you for your comment and may Allah bless you

  19. Don Says:

    Hello Sir,

    Iam a newbie to oracle 10g,i want to make a career in dba and dba most imp job is to keep the data secured and available,sir can i refer your book “BACKUP and RECOVERY”..

  20. Kamran Agayev A. Says:

    Hi Don

    What do you mean with “refer”? I hope you need a pdf version of the book, but unfortunately it’s not available as the book hasn’t finished yet. Good Luck

  21. Mr Babakisiyev Says:

    Salam Kamra mlm. Seminarda verdiyiniz kitablarin adlari ve sertifikat ucun gosterdiyiniz addimlar cox iwe yaradi.
    En azindan indi haradan bawlayib haraya gedeceyimi cox yaxwi bilirem.
    Bunlara gore cox sag olun.
    Blog uda cox beyendim.
    Inwallah daha boyuk ugurlara imza atarsiniz

  22. Kamran Agayev A. Says:

    Salam Babakisiyev
    Bu yolda cox kicik de olsa sizlere yardimim deyibse, bu cox sevindirici bir haldir


  23. Mr Babakisiyev Says:

    Salam Kamran mlm.
    Kamran mlm sizin dediyiniz kimi exam topics print etdim.
    Ve 2 Day DBA oxumaga bawlamiwam. Artiq 60 sehifeden cox oxumuwam ve demek olar ki oxuduqlarimi anlayiram.
    Sizce men exam topic deki movzulari bawdan bawlayib axtarim ve oxuyum, yoxsa 2 Day DBA deki topic ardicilligini izleyim?.

  24. Zeshan Says:

    As’salaamualikum Brother

    Dear Kamran,
    I recently happened to come across your Blog , Your effort is a source of inspiration & quite helpful for newbie like me seeking career as an Oracle DBA. Ma’sha Allah..
    Thank You . May Almighty reward for your effort & keep up the good work

    Jazakallah Khair

  25. Kamran Agayev A. Says:

    Va aleykum salam dear Zeshan and thank you for your kind words

    I’m so happy that my blog posts really help you and I’ll try to not give up and go on with new interesting posts

    Thanks again.

  26. Zekeriya Besiroglu Says:

    Kamran selam,

    Bugun Oracle Ace oldugunu ogrendim, cok sevindim. Basarılarının devamını dilerim.

    En kısa zamanda gorusmek uzere

    Zekeriya Besiroglu

  27. Kamran Agayev A. Says:

    Ilginiz icin tesekkur edirem Zekeriya bey. Sizin egitimlerinize katilmamin bu basarida rolu vardir

    Kendinize iyi bakin.

  28. Oraclelearner Says:

    HI Kamran,

    how in the world are you able to obtain multiple Oracle certifications, author books for Rampant Press, teach Oracle admin courses, and pursue a PHD? You are definitely an inspiration for me.


  29. Amardeep Sidhu Says:

    Man, you can speak 5 languages. Too Good !!!

  30. Kamran Agayev A. Says:

    Yes buddy :) Now willing to learn some French, they have so romantic language :)

  31. Samuel Says:

    Dear Mr. Kamran Agayev,

    Nice to know you, i’m from indonesian. Would you like to help me…I have problem with my oracle database. My Server harddisk was broken but i can recovery the data back. I have installed new OS and oracle 10g in new harddisk. Can I replace the datafile with my old datafile ?

    Thank you sir


    Samuel Eric T

  32. Kamran Agayev A. Says:

    Dear Samuel
    If you have RMAN backup you can perform disaster recovery and recover the database on the different server. Look at the following video tutorial:

    Moreover, you can rename datafile using ALTER DATABASE RENAME FILE in the MOUNT stage
    Good Luck

  33. Eric Tololiu Says:

    Dear Mr. Kamran Agayev,

    Hello sir, would you like to help me ? When I connect to oracle 10g by TOAD or connect by sqlplus, I got this message :
    ORA-01578: oracle data block corrupted (file # 1, block # 38557)
    ORA-01110: data file 1: ‘c:\oracle\product\10.2.0\oradata\orclkdi\system01.DBF’

    I have no backup for system01.dbf datafile. Can you give some information to fix it ?

    Thanks you very much.


    Eric Tololiu

  34. Kamran Agayev A. Says:

    Dear Eric

    Why you don’t have backup of the SYSTEM tablespace? Don’t you know that if you lose the SYSTEM tablespace without having its backup, it means that you lost your database at all! Be careful and take dailiy backups (I hope you’re currently running on the test db)
    If you haven’t backup of the database and you got a Data Block error, use DBMS_REPAIR to mark the block corrupted. For this, you need to create a REPAIR_TABLE using DBMS_REPAIR.ADMIN_TABLES procedure. Then use CHECK_OBJECT procedure to look for the corruption and update REPAIR_TABLE. Then use SKIP_CORRUPT_BLOCKS to tell Oracle to skip the corrupted blocks and use FIX_CORRUPT_BLOCKS to mark the block as a software corrupted

  35. Just a passerby Says:

    I am an experienced DBA and happened to see your blog. Amazing how you keep up with the blog, authoring a book and pursuing a PhD. Inspiring indeed! Keep up the good work.

  36. Tausif Ahmad Says:

    Dear sir,
    i am impressed by your remarks for my question in oracle forums.
    i am just about to be graduated.
    can please help in guiding my career in your foot steps.
    i am also very much instrested in working on oracle.
    i am currently preparing for DBA 9i sql, fundamentals exam.
    lokking forward for your reply.

  37. Kamran Agayev A. Says:

    Hi dear Tausif

    If you want to be an Oracle DBA, you need to read a lot and practice everything you read. I’d suggest you to start reading documentation (Concepts and Administrators Guide) from http://tahiti.oracle.com address. Next, install Virtual Machine, Linux and Oracle and start practicing what you read (you can use my video tutorials as well)

    Moreover, read the following .doc file written by Tonguc Yilmaz

    Good Luck!

  38. madhankumar Says:

    Dear kamran,
    is it important for dba’s to analyze projects and creating db logical design for projects.. i am getting problem for creating tables for projects…and normalization also….is it important for me…i am doing 10g ocp..i like to work in oracle….reply me soon.

  39. Kamran Agayev A. Says:

    Dear MadhanKumar

    Sure, it’s your duty to create such objects, to make logical db design and etc. as a experienced DBA

    So I’d suggest you to read basics of Relational Database Systems

  40. Rovshan Says:

    Salam Kamran bey. Size bir sualim var. Neye gore bizim sizin kimi, Teymur Haciyev ve digerleri kimi Oralce uzre mutexessislerimiz ola ola yerli kurslar xaricden mutexessis devet edirler? Mence onlara az pul vermirler. Hemin pulu bizimkilere versalar(meselen size) daha yaxsi olmaz?

  41. Kamran Agayev A. Says:

    Salam Rovshan

    Oracle Approved kurslarinda ders demek ucun kursdan asili olaraq 3-5 gun ard arda 6-8 saatliq ders demek ucun vaxt lazimdir. Shexsen men, hal hazirda calisdiqim shirketde (AzerCell) kursda ders demek ucun bu qeder vaxtliq icaze almaqim qeyri mumkundur. Ancaq onu da qeyd edim ki, bir il once bashqa shirketde ishlediyim halda bu vaxtim var idi, SoftLine-a bunu teklif etdim, cox sevindiler, lakin mesele yene hell olunmamis qaldi. Sebebini mence hec ozleri de bilmir …

  42. Martin Nash Says:

    Hi Kamran,

    I hope you’re well. Is there any chance of you modifying your WordPress settings so that your full articles show up in the feed? This can be changed in Settings -> Reading -> “For each article in a feed, show”.

    Thanks in advance for considering it.



  43. Kamran Agayev A. Says:

    Hi Martin. Nice to meet you :)

    I’ve changed it

    Take care and keep in touch!

  44. Nirav Says:

    Hi Kamran,

    I show your Vidio Tutorial and it is very very useful. Thanks for sharing.

    I request you to please share a vidio tutoria for Performance Tuning.



  45. Abdul Kalam Says:

    Salam Kamaran,

    After seeing ur blog, i was really impressed, i worked in various platform(Sun solaris, Suse linux,IBM aix) and also different version of DB, quite played some Developer role as well.

    But after seeing ur blog, i am changed my mind to do only core DBA activity. Need more posts of the real time scenarios from side will help all our DBA community.

    Kindly increase ur posting (thrice in a month) of the DBA Real time scenarios. (Hope its hard)

    my heartful thanks for ur great effort and best wishes.

    Abdul kalam.

  46. Kamran Agayev A. Says:

    Dear Abdul Kalam

    I’m very happy that my articles are helpful! Thanks for feedback and wish you every success in your DBA career!

  47. Amin Anwar Says:

    Excellent work n experience keep it up !!

  48. immaculate suja Says:

    hi sir,
    i am completed oracle 10g ocp certification.now i am looking for a oracle 10g dba junior jobs in dubai-uae.how to get the jobs and how to prepare for the interview.
    pls guide me.
    thank you,

  49. ahamed Says:

    hi Kamran
    i am very impresssive saw your video scanrio and
    i want to learn Oracle Datagarud. can give oracle data garud video links

    my heartful thanks for ur great effort and best wishes.


  50. Kamran Agayev A. Says:

    Hi Ahamed. You can check my video tutorial, there’s already a step by step guide on creating a Standby database using RMAN

    Good Luck!

  51. Roshan Says:

    Hi Sir,

    The Book which you are writing Now. When it will get released????. The release date for this book is July 2011. I am waiting for this book since last 6 Months.



  52. Riaz Says:

    Assalam Alikum

    i am Riaz and i am working as an Oracle DBA and Trainer. i am 9i,10g,11g OCP now i want to give Oracle OCM.
    please help me for this

    allah hafiz


  53. Namik Mustafayev Says:

    CV-ye baxdiqca fexr hisleri keciririk :)

  54. Saurabh Gupta Says:

    Hi Kamran,

    I could resolve many of my oracle admin related queries through this blog. Nice efforts.


  55. Aslam Khan Says:

    Hai kamran,

    Thanks for your kind information which u r posting for us…

    and i had installed OEL4 in VMWare and i am trying to connect through putty ..

    i am not able to connect its giving error. network error.

    please give me step by step process how to do that…

    my mail id: aslam2510@gmail.com

    Thanks & Regards,
    Aslam Khan

  56. Ahtesham Mirza Says:

    Aswk Sir, MAY ALLAH give you more Knowledge to share with us . I am very glad about your Achievements . I am trying to learn Oracle DB completed OCA(10g) & waitng to be OCP. Sometime i loose my confidence becz i am not getting job in this field mean want to work on Real project.

    Will you tell me how we can create more than one instance ?

    Pray for my Career in Oracle DB.

  57. Kamran Agayev A. Says:

    You need to be a little bit patient, because no one gets job immediately after learning something. Try to read more and more, make practices, apply for open jobs and you’ll definetly success

  58. Ahtesham Mirza Says:

    Will wait for your Suggestion for my Carrer in Oracle DBA.

    I want to become OCM.

  59. Saurabh Gupta Says:

    Hi Kamran,

    Happily I would like to let you know that I am authoring a book on Oracle 11g Advanced PL/SQL concepts with PacktPub publishers. I would like to seek your help in reviewing process. I would be happy if you could extend your support in this regard or refer somebody to carry on the content reviewing task. I shall be obliged.


  60. Kamran Agayev A. Says:

    Hi Saurabh, nice to meet you

    I can review your book, so feel free to contact me

  61. hardik Says:

    Respected sir,

    I have recently completed my ORACLE 10g OCP certification training.And my exams for certifications are going to be completed in next week.

    I have referred you blog and I found it very much useful for a newbee or an experienced DBA as well.It is very much helpful.

    I have also downloaded all the videos and installation material provided by you on your blog.And I am awaiting for your upcoming book:

    Oracle Backup & Recovery:
    Expert secrets for using RMAN and Data Pump
    Kamran Agayev Agamehdi & Aman Sharma

    I think these will be very much helpful to all DBA persons to learn something new about the Backup and Recovery techniques.

    I want to know something about how to take backup of recovery area into tape for disaster recovery.I have watched the video provided by you for Disaster recovery for disks.I also want to learn about: disaster recovery of the backup we have taken.

    If you can provide some good material or a video for this so that I can get some idea.And It may be helpful for others as well.

    Thank you for hearing from me.

    Best Regards,
    Hardik B Jethava
    phone: +91-9033421584
    Email: hardikjethava@yahoo.com

  62. hardik Says:

    Hello sir,

    I want to find out session details which are log in and log out since last 4 hours without auditing enabled ??
    Can I do this thing??

    Thank you

  63. Kamran Agayev A. Says:

    No you can’t

  64. hardik Says:

    Ok sir.

    thank you.

  65. Akbar Jalaluddin. Says:

    Salam Brother.

    This is really helped me alot. I really appreciate your help.



  66. Alok Srivastava Says:

    Hi Sir,
    I want to buy your book
    Oracle Backup & Recovery:
    Expert secrets for using RMAN and Data Pump
    Kamran Agayev Agamehdi & Aman Sharma

    kindly tell me how can i get this book in New Delhi(India) because if i purchase this book
    online ,shipping charges will be more than cost of book.

    Please suggest me.


  67. Kamran Agayev A. Says:

    Hi Alok

    Unfortunately the book is not available for now, I’ll let you know when it’s published and how you can get it


  68. praveen Says:

    Hi sir

    i have configuring data guard so many times.but log shipping is not happening.can u please post a video on configuring dataguard on rhel4.

  69. Kamran Agayev A. Says:

    You can check my video tutorial on creating standby database and shipping logs and applying them

  70. faz Says:

    bonjour sir,
    j’ai la maitrise en info et reseau et je suis sans emploi, et j ai decide de me lancer dans le projet de devenir un DBA ocp,
    quel conseil ou remarque avez vous a me donner?
    merci g compte sur ces compte, c est important pour moi.

    merci d avance

  71. Kamran Agayev A. Says:

    Hi Faz. Unfortunately I don’t know french language, but I used translate.google.com and understood your comment :) So you want to become an OCP and ask for advice
    I would suggest you to start reading OCP related books, read Oracle documentation and perform practices. Install virtual machine, install Linux+Oracle and start practicing. This is the best way to become OCP. If you would like detailed advice, ask your question in more details.

    Good Luck!

  72. praveen Says:

    Hi sir

    This is praveen

    i’ve done dataguard according according 2 u r video.but i got errors when i hit the command like
    rman target / auxiliary sys/praveen@kpk.Errors r

    initialization of internal recover manager package failed
    error from auxiliary database
    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

  73. Kamran Agayev A. Says:

    You need to add database information to the listener.ora file

  74. praveen Says:

    Hi sir

    This is praveen

    i’ve done dataguard according according 2 u r video.but i got errors when i hit the command like
    rman target / auxiliary sys/praveen@kpk.Errors r

    initialization of internal recover manager package failed
    error from auxiliary database

    u have asked me 2 add database information to listener.ora file.what information i have 2 add.

    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

  75. mehaboob Says:

    Hi Sir,

    I heartly thank u for supporting us to learn and understand the topics by provinding videos and doc’s.

    I have followed your document to configure 10g RAC database on vmware server(linux os).I have followed with same i configured succesfully with 2 nodes.

    I want to add another node to existing RAC database.will u please provide steps for adding node.

    I have tried with OUI i got error OUI-35000: Fatal cluster error encountered.Please help on this.

    I also want to upgrade 10g RAC to 11 RAC database please upload document sir so that we can upgrade my rac database.

    Thanks & regards,

  76. Imran Khan Says:

    Hi Sir,
    I have configured The Event-Driven Publishing API,to distribute reports,destype=mail,
    but its not working for mail,however incase of file it works fine..
    Following is debugged output…

    SQL> /
    * API-Version : 9i *
    * (C) Oracle Corporation, 2000 – 2002 *
    * Debugging turned ON **************************
    *** Length of Paramlist : 1
    OK : Parameter added : GATEWAY=http://myserver.com:7778/reports/rwservlet
    *** Length of Paramlist : 2
    OK : Parameter added : SERVER=rep_myserver_oracleas2
    *** Length of Paramlist : 3
    OK : Parameter added : REPORT=D:\Reports\emp.rdf
    *** Length of Paramlist : 4
    OK : Parameter added : USERID=abc/xyz@mydb
    *** Length of Paramlist : 5
    OK : Parameter added : DESTYPE=mail
    *** Length of Paramlist : 6
    OK : Parameter added : DESFORMAT=PDF
    *** Length of Paramlist : 7
    OK : Parameter added : DESNAME=khan.emran84@gmail.com
    Starting run_report: building url
    *** Building URL (RUN_REPORT)
    OK : URL built :
    *** Submitting HTTP Request
    *** using URL
    OK : Request submitted – Return stream :

    OK : Request submitted – Length of stream : 229
    *** XML-Parsed – Following Structure discovered :
    *** Checking elements!
    serverQueues ()
    *** Checking attributes!
    *** Checking attributes!
    __code = 50159
    __component = REP
    __message = Executed successfully but there were some errors when distribute the
    *** Finished Parsing XML
    Getting value for element: job
    Getting value for element: error
    *** Requesting value for Attribute error.component [REP]
    Getting value for element: error
    *** Requesting value for Attribute error.code [50159]
    Getting value for element: error
    *** Requesting value for Attribute error.message [Executed successfully but
    there were some errors when distribute the output]
    REP-50159:Executed successfully but there were some errors when distribute the
    ERROR at line 1:
    ORA-06512: at "NRSP.SRW", line 264
    ORA-06512: at "NRSP.SRW", line 799
    ORA-06512: at line 15

    Please point out any suggestions..

  77. rohit Says:

    Hello Sir,

    I want to learn about expdp and impdp.

    I do able to perform the expdp of a particular database of one host and when I try to imp into different host it’s not importing.

    Do I need to create those Tables of which I took backup, into the database on another host.

    Although I’ve followed some links for exp and imp bt still no luck for now.I’ve very much confused.

    Plz guide me.If you have any video tutorial then it would be great help.


  78. praveen Says:

    Hi sir
    This is praveen.i was trying 2 create cronjobs.As a root iam able 2 run cron jobs.But as oracle user iam not able 2 run.plz advice me the best possible way 2 execute cronjobs as oracle user.

  79. Himanshu Says:

    Hi Kamran,

    I have seen your Oracle VIDEO Tutorials and read your E-Books and now i am desperate to read this book (Oracle Backup & Recovery:Expert secrets for using RMAN and Data Pump)

    I would like to purchase this book in India but i could not find it.
    From where i can get this book as from rampant-books.com it is too much costly 108$.


  80. Anurag Says:

    Dear Sir,
    I am anurag kumar b.tech graduate in computer science since working as web-application developer from 2010 .
    currently start oracle dba course give me right guidelines for a good dba .

    Anurag Pandey

  81. Alok Says:

    Hi Kamran,

    Hi ,

    Is your book available in INDIA:
    Expert secrets for using RMAN and Data Pump by kamran agayev and Aman Sharma

    How can i get this book in India.

    I tried to buy this book online from rampant’s official site but shipping cost was more than cost of book.
    Book is not available on Flipkart and Amazon also

  82. Kamran Agayev A. Says:

    Unfortunately it’s not available in the market now
    We’re still waiting response from the Rampant Techpress on this issue. Once I get it, I let you know

  83. Imran Says:

    Hi Kamran

    Your site is fantastic. Its great that you are able to share so much valuable knowledge.

    I need some help in installing 10g on Virtualbox running OEL 5.8.. Pls would you contact me, many thanks.

  84. anurag kumar Says:

    Hi currently i am working as a Application developer in php i want to switch the job to Oracle filed so please suggest me which one is better field Oracle DBA or Oracle Application Developer for 10g.
    I have 1 year experience in application developement,i want to become a good oracle dba .

    how to start the career from start up in oracle field

  85. anurag kumar Says:


    please reply me.

  86. manveer walia Says:

    hello sir i want to be a good dba and i want to revive sql and pl/sql please suggest me some journals so that i will be in touch with sql and pl/sql i will be pursuing job by september so please suggest me journals that are sufficient to make me good in sql and pl/sql and also in DBA !! PLZ REPLY


  87. Kamran Agayev A. Says:

    I would suggest you to read some SQL and PL/SQL books
    Check the following books:

  88. Himanshu Says:

    Hi Kamran,

    I am very much interested in Backup & Recovery,So please suggest me some book for the same which should be near by your books topic until your book release in India.


  89. Basha Says:

    Hi Kamran,

    Could you let us know when your book on backup and recovery will be released in India.

    I am very much interested in that book as I am just started focusing on the backup and recovery part.


  90. Sindhuja Says:

    Hi Kamran,

    First I like to Thank you for your nice and useful blogs.

    I working in IT but did my graduation in Biotech. I am a beginner in ORACLE. I have got a assignment to call a unix shell script from ORACLE Procedure.

    Could you please help

    Thank you

  91. Kamran Agayev A. Says:

    Hi Sindhuja
    The following link can help you :)

  92. Sindhuja Says:

    Thanks Kamran.

    But I have already done that which i feel quiet confusing..I was searching for your blog regarding this topic since yours is more explanatory than others :-(

  93. ram Says:

    Configuring rac step on vmware by using your document.

    Asm disk volumes are enabled in node1 but not in the node2
    please let me know how to proceed further

  94. chinmoy Says:

    Dear Sir,

    I want to import full database from a exported datapump file in
    another machine.both the servers are running in widows,oracle version is 10gR2 . please send me the step-by-step procedure.


  95. Kamran Agayev A. Says:

    It’s very simple. Why you don’t want to try it by your own?
    Hint – use impdp utility :)
    Good Luck!

  96. Kaviarasu Says:

    HI Kamran,

    I would like to know the step by step installation of Oracle 11g RAC.Also the book for Oracle RAC…

  97. KajaMaideen Says:


    This is KajaMaideen from India, I am jobless and searching job in java, j2ee, jsp , servlets, . And i have knowledge on db and sql. I am struggling for an entry, Kindly if you can help me out from this and it would be really great full to my efficient career start. I can prove my worth also.

    Thanks and Regards,

  98. Kamran Agayev A. Says:

    I’m sorry but I can’t help you on this issue. Make some google search and you’ll find the way

  99. Efrain Castro Says:


    Excuse me, I have a problem, with oracle 10gr2 install on Linux Centos 5.8 (i386).
    1) ./runInstaller
    2) This is the only error:
    “Checking Network Configuration requirements ..” Status: Not executed
    ´’The overall result of this check is: Not executed <<<<

    3) I have one ethernet card: IP
    4) /etc/hosts centos2.sofhouse.net centos2 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6
    5) uname -n

    Thank you with help me.

    Bogotá, COLOMBIA

  100. Kamran Agayev A. Says:

    Hi Efrain

    Is it a virtual machine?
    Get the hostname using the following command

    [oracle@test ~]hostname

    and add the entry to the /etc/hosts file yourhostname.domain.com yourhostname

    save the file and try to ping the hostname

    ping yourhostname

    And try the installation again. If you fail, you can ignore prerequisites

    ./runInstaller -ignoresysprereqs

  101. Saurabh Gupta Says:

    Hi Kamran,

    Can you please publish a blog post about your experience and feedback during the review of my book? I shall be thankful.

    Saurabh Gupta

  102. Kamran Agayev A. Says:

    Hi Saurabh
    Sure I’ll do it

  103. Nishant Says:

    Hello kamran ,
    could you plz send me the link from where i can download the oracle clusterware 11g for my RAC project on virtual box. Also want to ask one issue , i have only one ethernet port so whether both virtual machines can work on single ethernet port or not(RAC1 & RAC2) ,Actually i’m a beginner in oracle , this RAC project i’m doing on my laptop.waiting for your reply :)

  104. Kamran Agayev A. Says:

    I’d suggest you to check the following document written by friend of mine – Mohammad Azar

  105. Ram kumar Says:

    sir i am not able to install oracle 10g grid can u guide me for that
    any step by step doc for tha

  106. Kamran Agayev A. Says:

    Check my video tutorials

  107. david Says:

    Tanks kamran
    am David from nigeria, please where can i downloaad oracle software compatible for microsoft windows 7. tanks

  108. Kamran Agayev A. Says:

    Hi David
    Have you tried http://www.oracle.com and checked the Download section?

  109. Ibrahim Says:

    i’m proud you, hopefully you will pass everything successfully.

  110. Himanshu Says:

    Hi Kamran,

    Please do something for book “Oracle Backup & Recovery:Expert secrets for using RMAN and Data Pump”

    I am waiting for so long but still not available in India.

    Please make it available if you can :)


  111. Armin Valadkhani Says:

    Hi Mr Agayev
    I have good experiences about Oracle Database Administration and I read Oracle books from Oracle Library and Oracle Press. I want to be professional like you but I think my knowledge is very erratic. Can you help me in this way please?

  112. Kamran Agayev A. Says:

    I’m not an Expert, I’m just a DBA
    Read more books and practice more and more and more

  113. naushad Says:

    how can i get ur book i mean rman recovery.thats is available in india or saudia

  114. Shaikh Says:

    Hello Kamran,

    I was wondering if you have steps to remove instances from RAC in ASM environment without using DBCA.

  115. lokesh Says:

    Hello sir,

    I want to ask something that is there any website where i can do my DBA practicals? Because i am not able to afford to purchase a new pc or a laptop.And i am studying with my self. I read your blogs and i gained more knowledge about the oracle problems that are genearly occurs. and any link if you have where i find more knowledge about OCA so please tell me.And also please tell me is there job in north India? I will be thankful to you.

    With Warm regards
    Lokesh Kumar (India)

  116. Huseyn Says:

    Salam Kamran muellim.Oracle-ya sifirdan bashlamaq uchun hansi kitabi tovsiyye edersiniz?

  117. Kamran Agayev A. Says:

    Salam Huseyn
    Turk Oracle ACE-i Tonguc Yilmazin asaqidaki meqalesini oxumaqi tovsiye edirem :

  118. Monowar Mukul Says:

    Try below to remove an ASM instance

    srvctl remove asm -n rac1 -i +asm1 Note: rac1 is node name; +ASM1 is the instance name

  119. Amins Khan Says:

    Hi Dear Kamran,

    Do you have any format to answer this following question, if not, then from where i can get an idea if anyone knows please reply.

    For a new server:

    Please answer the below questions to be able to proceed with proper sizing.

    – Existing Servers infrastructure, need to know the servers specifications, in terms of OS type & version, number of CPUs/System, amount of memory….etc

    – Existing Storage infrastructure, need to know storage specifications, in terms of storage model, existing capacity (Raw/Usable)…etc

    – Existing Applications/Database, cluster type and software version.

    – Number of users and concurrent users.

    – Network connectivity for the exiting environment and for the new environment required in terms of connection speed (1Gb or 10Gb) and type (UTP & fiber), note if fiber is required then we need to know whether long-range (single Mode) or short-range (multimode) is required.

    – Any special requirement for the new infrastructure.

    – Migration services whether it is required or not.

    – Any support level required also need to be stated

    If you have any standard just please let me know.


  120. lokesh Says:

    Hello sir,

    I want to ask something that is there any website where i can do my DBA practicals? Because i am not able to afford to purchase a new pc or a laptop.And i am studying with my self. I read your blogs and i gained more knowledge about the oracle problems that are genearly occurs. and any link if you have where i find more knowledge about OCA so please tell me.And also please tell me is there job in north India? I will be thankful to you.
    please some one reply
    With Warm regards

  121. Huseyn Says:

    Salam Kamran muelllim.Oracle 11g OCA imtahanini vere bilmek uchun Oracle 10 imtahanindan kecmek mecburidirmi?

  122. Himanshu Says:

    Hallo sir,

    I will have new machine with oracle 11g and i have exported dump from oracle 10g (
    Now i need to import that dump on oracle 11g.

    Is there anything that needs to be taken care in this ?


  123. Kamal Kant Says:

    Hi Kamran Sir,
    I a big FAN & follower of your article on this blog.I want to purchase your Book Oracle Backup & Recovery:
    I am from India , & in my country this book is not available.
    I am going to paris and germany in the month of March 2013.
    Could you please confirm that this Book is available there or not, so that I can puschase it.



  124. Mohammed Mujahid Says:


    Please suggest me good books or documentation for understanding relational database concept in details.I am programmer wanted to learn database concept.

  125. Kamran Agayev A. Says:

    Hi Mohammed
    I’d suggest you to read Database Concepts guide from the following link:

  126. Kamal Says:

    Hi Sir,

    I am from India, this month I am going to Europe tour visiting Germany,france,Italy and switzerland. Sir I want to know is your newly published Book Oracle Backup & recovery
    Available in any of these cointries, so that I can get this valuable book.Hoping for reply

  127. jayachandran Says:

    Hi sir,

    i am jayachandran . your presentations are too good

    can i have some rman guidelines presentation




  128. Emil Says:

    Kamran salam aleykum :) Men de azeri qardawinam. DC-de ishleyirem swift kompaniyasinda :) Bloguva rast geldim, mashallah chox xoshuma geldi senin kimi oracle bilenlerimiz var :) Biz de ishde esasen oralce/C++ istifade ediriy. Artiq 2 ildi ki burda ishleyirem. Amerikada bir qullugun olsa xeber ele :)

  129. Kamran Agayev A. Says:

    Aleykum salam Emil qardas, xos gorduk. Amerikadan Azeri oqullarinin sesi geldikce cox sevinirem, ve umid edirem ki, vetenimizi oralarda layiqince tanidirsiniz inshallah

    Inshallah Sentyabr ayinin sonu ucun boyuk ehtimal USA-e Oracle OpenWorld konfransi ucun gelecem, imkan etsek mutleq gorusek.

    Gorusmek uzere, elaqeni kesme

  130. Emil Says:

    Sentyabrin ilk 15 gunu bakida olacam. Inshallah sentyabrin sonu Amerikadayam.

  131. Govind Kumar Sah Says:

    hello sir, i am Govind from India. I am trying to install oracle 11 g release 2 on Ubuntu 13.04 64bits, But there are many errors (around 12-13) like ‘error in invoking target ‘client_sharedlib’ of makefile’,error in invoking target ‘ntcontab.o’ of makefile , etc. m tried many times but am not able to resolve these errors.
    please guide me.

    Thanks in advance

    Govind, India

  132. Govind Says:

    hello sir,

    This is Govind from India. I am trying to install oracle 11g release 2 on Ubuntu 13.04 64 bit. Everythings are going fine till 68% and then there are 11-12 errors like error in invoking target ‘client_sharedlib’ of makefile. I have tried many times but m not able to resolve these errors. please guide me sir.

    Thanks in Advance

    Govind, India

  133. Kamran Agayev A. Says:

    Hi Govind
    Make sure you’re installing the correct bit version of Oracle Database

  134. Ayo Says:

    please, am new in Data base administration, In-fact, i just want to learn it, have bn search all through form internet to see who can assist me before i come across your site
    please i real need your assistant

    Thanking you anticipation.


  135. Kamran Agayev A. Says:

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


  136. Ayo Says:

    follow the


    thank so much, I have read the article” but not as if as i don’t have knowledge about the Oracle, but the issue is that am just started, am in still in fundamental and i want you be my guardian so i can follow your steps sir,


  137. Vijay Says:

    Dear Kamran,

    congrates for your OCM certification.

    I’m working as Oracle developer for last 6+ yrs (Pl/sql, forms/reports), now i want to learn Oracle E-business suite.
    Could you please suggest, how can I learn this in Dubai.

  138. arun yadav Says:

    hello sir,
    it is very good website indeed.
    i am newly oracle 10g dba (ocp). as i am fresher so i can not get the orcle Dba job. now i am confuse what i have to do and how ??? please help me. it is my lovable field and i want my career in oracle Dba but having no guidance.

  139. Govind Says:

    Hello sir,

    First of all congrates for your OCM certification.

    I am using the correct bit version.

  140. Govind Says:

    And can you send me any link where i can read more information regarding passwordfile( Remote_login_passwordfile = shared) because i want to implement it.

    Thank you sir in advance.

  141. abdulmajeed Says:

    Good day Sir, im so impressed with this blog, may d Almighty increase you in knowledge. Thank you.

  142. Kamran Agayev A. Says:

    Thank you for the feedback my friend. Appreciate!

  143. lokesh Says:

    Plz Kamran sir give me some follow up of my previous mails.


  144. Prashansh Says:

    Dear Kamran
    I love to read your oracle blog and video tutorial.Please post video to configure oracle
    data guard (Primary to Standby).I feel that it is very useful for us.


  145. Kamran Agayev A. Says:

    Hi Prashansh

    Now I’m working on some RAC related video tutorials. Will try to create some DG tutorials afterwards

    Thanks for the feedback


  146. Tiago Says:

    Dear Kamran
    I love to read your oracle blog and video tutorial.
    Thank you for sharing your knowledge.
    I bought his book on RMAN on Amazon, has not arrived yet, but would like to get more experience on RMAN.

    Tiago (From Brasil)

  147. Kamran Agayev A. Says:

    Thanks Tiago and best of luck! Hope you’ll enjoy it

  148. Vishal Says:

    Hi Kamran,
    I want to download oracle 11gr2 software on my ubuntu 13.04 version Operating system in my desktop can u send me the step by step process how to download …….

  149. Kamran Agayev A. Says:

    Go to oracle.com then switch to Downloads menu
    That simple :)

  150. shahram Says:

    Dear kamran,
    I am studying oracle and I am ready for taking first oracle exam. But I am lite worry because I do not have programing background and I think I need more hands on practices, Do you have any recommendations.



  151. Kamran Agayev A. Says:

    Hi Shahram
    I would suggest you to make some practices before taking the exam

  152. Riaz Says:

    Assalam Alikum

    i am Riaz and i am working as an Oracle DBA and Trainer. i am 9i,10g,11g OCP now i want to give Oracle OCM.
    please help me for this

    allah hafiz


  153. Kamran Agayev A. Says:

    Hi Riaz

    Have you checked my OCM journey blog post?


  154. KAMAL Says:

    Hi Sir,
    Your blog are very interesting and full of knowledge.
    Sir,pls post some thing related to DATA GUARD.

  155. kanchan Says:

    hey Kamran,

    I read your blog its amazing work you did. Could you please help me in setup Dataguard. Can you revert over my email ..

  156. Kamran Agayev A. Says:

    Hi Kanchan
    Please check my video tutorials page and find how you can create a Data Guard (Standby database)

  157. Hemant kumar Singh Says:

    Hi sir
    I have done my OCP. I am looking for a job in Oracle DBA. kindly anyone help me how can i get A JOB IN Oracle DBA field

  158. Kamran Agayev A. Says:

    Hi Hemant
    Unfortunately this is not the job search web page. This is a technical blog. Please post your request to the job search pages

  159. fardin Says:

    Hi Kamran,

    I am currently working as Oracle DBA from last 2 years and too planning to make my blog, can i get some guidelines for the same………

  160. Kamran Agayev A. Says:

    All you need is to start sharing your experience and learn “how to start blogging” techniques from google.

  161. Fardin Says:

    Hi Kamran,

    Can you please share some details about this blog.
    i.e. what is size of this blog?
    how much you pay yearly?
    which is the best site to but domain?

    Fardin Shaikh

  162. kanchan Says:

    Thank you so much Kamran.. awesome tutorial …

  163. ROSHI Says:

    Hello kamran
    Need to go through ASM concepts in depth also the grid installation of 11gR2 on single standalone machine and Rac concepts.
    Can you please guide me

  164. Kamran Agayev A. Says:

    Hi Roshi
    I would strongly suggest you to read related documentations and books written on the mentioned topics

  165. Gerald Says:

    Hi Kamran,
    I am eagerly waiting for your new book “Study Guide for Oracle Certified Master 11g Exam” and I can see it will be on Amazon on 1st January 2016. Kindly let me know if it will be available on time as I have planned for the exam in February 2016. My email is included in the “Leave a Reply” section of the page.

  166. Kamran Agayev A. Says:

    Hi Gerald

    I’m currently working on it and hope it will be ready in a few months

  167. Anar Bəylərov Says:

    salam Kamran bəy, təşəkkür edirəm bu şəkildə yararlı blog yaratdığınız üçün.
    Oracle SQL Expert imtahanına hazırlıq üçün birçox kitab yada mənbə tapdım, ancaq sizin tövsiyyəniz dəyərlidir mənimçün,aralarından seçim etmək olduqca çətindir, bu imtahana hazırlana biləcəyim tövsiyyə etdiyiniz kitab(lar)ın adlarını bildirəbilərsəniz şad olaram :)
    öncədən təşəkkürlər.

  168. Kamran Agayev A. Says:

    Salam Anar, tesekkur edirem

    Bu imtahana hazirliq ucun asaqidaki kitabi meslehet gorerdim

  169. Sujeewa Says:

    Hi Kamran,

    I have ordered your book Oracle Certified Master 11g Study Guide through amazon.com on January 10, 2017. Order number 107-1388714-1763462. I ordered it from Maldives. Estimated delivery date was Feb 23, 2017 – Mar 15, 2017.
    I still didnt get the book. Even I do not see the contact seller button when I check my Orders.

    Please can you support me to track the package.

    Best Regards,

  170. Kamran Agayev A. Says:

    Hi Sujeewa

    I would strongly recommend you to contact amazon and provide your order number so they start investigation

  171. Nigar Says:

    Dear Kamran,

    It is really useful that you give a lot of information related with IT. I would like to take advise. I am a Quality manager/ Quality assurance manager. I plan to develop myself in IT area. So I kindly ask you to give me some recommendation such as:

    1) Which software program is essential for my occupation?
    2) Which course is recommended by you?
    and etc.

    Thank you in advance!

    Best regards,


  172. Kamran Agayev A. Says:

    Dear Nigar x. Thank you for the comment.

    There are a lot of different areas in IT, so before starting you have to decide what track you should take. Programming? Network admin? DBA? or something else. After researching and deciding what you want, the next step is to get a course, read related books and practice. In a few months, you will feel like a junior and will keep growing

    Let me know if you need any further information

  173. jae hyun Says:

    Hi Kamran Agayev,

    I have ordered your book Oracle Certified Master 11g Study Guide through amazon.com

    Practice according to the contents of the book.
    The requirement says 32bit program is required, but the contents of the book have a test for
    Should I test it with version?

  174. Kamran Agayev A. Says:

    Hi Jae. Thanks for purchasing the book.
    It doesn’t matter having or Any 11.2 version is ok

    Good luck with the exam!

  175. Sr Says:

    hi Kamran Agayev,

    I saw you’re conducting online courses for 11g OCM in ocmguide.com

    Please let me know how I can download the contents once after making my payments.

    Note: please add a comment window in that page so users can make use of.

  176. Kamran Agayev A. Says:


    Yes, we have already started the course. If you want to join, please let me know so I can add you to the next class. It’s an online course for 2 weeks

  177. Sr Says:

    Thanks Kamran,

    Will you please drop a mail to my mail id as I made my payments for that today.

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>