Kamran Agayev's Oracle Blog

Oracle Certified Master

181 Responses to “Step by Step Oracle guides”

  1. tejas patel Says:

    my goal is made a oracle DBA.so please help me…

  2. Kamran Agayev A. Says:

    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

  3. Mohammed.Ateeq Says:

    Hi Kamran,
    I am a newbie in oracle. I have installed VMWare workstation 7 on windows and my guest OS is Linux ES3. I have installed Oracle 10g Rel2 on the guest OS. Most of the things r working f9, except the RMAN. It hangs up when i enter RMAN at command prompt. Please suggest how to proceed. DO i need to check Bash Profile or some other area.

    Thank You

  4. Kamran Agayev A. Says:

    Hi Mohammad
    When you change PATH environment variable and add $ORACLE_HOME/bin directory to it, and when you issue rman target / command, system looks for rman executable in all directories which were registered at the PATH environement variable. There’s an rman executable (non-Oracle rman) at the folder /usr/X11R6/bin and it comes before $ORACLE_HOME/bin directory at the PATH environement variable, so system runs that file.

    So you need to define $ORACLE_HOME/bin directory at the beginning of PATH environement variable and run rman target / command as follows

    export PATH=$ORACLE_HOME/bin:$PATH
    rman target /

    Please let me know if you have solved this issue

    Good Luck

  5. Praneeth Says:

    hi kamran,
    I cleard (java)SCJP,SCWCD certifications.now i want to oracle certification.can you tell me.which certification exam is suitable for me(sql queries). and how can i prepare step by step clearly.
    thank you.

  6. Narsing Says:

    Hi Kamran,

    Iam having 3years of experience in app testing,Now i made my mind to work on a better technology and completed RHCE/OCP 9i but i dnt have any realtime knowledge. Can you tell me how to make my subject strong so that i can put 2years of experience as a oracle Dba.

    Thank You…

  7. Kamran Agayev A. Says:

    Dear Narsing

    I have only one suggestion: “You have to test everything you know. You have practice everything you learn” After making a lot of practicec and being OCP you can start as a junior DBA in any company you’re invited. Why I say junior because you haven’t real time practice. And after working as a junior DBA in any company whicih uses Oracle database, you’ll be assigned a lot of tasks and thus improve yourself

    Good Luck!

  8. zindaba Says:

    hi firstly i want to thank you for the help you giving to us new dbas,i managed to install oracle 10g database after following your guide. now i need help on to install apex on the same database. so you have another step by step guide for that.

    regards

  9. Kamran Agayev A. Says:

    Dear Zindaba

    Unfortunately I haven’t such step by step instruction on APEX installation, but you can check the following link:
    http://tinyurl.com/y7qhzk6

  10. Narsing Says:

    Hi Kamran,

    How are you , Thank you very much for helping me out. Iam having a doubt .
    What are the main advantages of creating DATABASE manully . And hw to allocate SGA to a particular user.

    Regards,

    Narsing

  11. Kamran Agayev A. Says:

    Dear Narsing

    There might some circumstances where you might not be able to use GUI to create a required database. In such situations, the manual creation might be useful
    According to the question on allocation SGA to particular user, I’d suggest you to use profiles (PRIVATE_SGA)
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6010.htm#SQLRF01310

  12. Narsing Says:

    Hi Kamran,

    Hello Big Bro, The information which you had provided is really good but its very high level for me to understand i think unless any realtime experience i cannot understand.

    Can you suggest me how to practice real time at home on network iam having 2 systems. The reason why iam asking this is because lot of my friends are good at concepts but when it comes to implementation stage the cannot explain why it is like that.

  13. Kamran Agayev A. Says:

    Dear Narsing. I thinkg it’s not so high level as you have mentioned. It’s just step by step explanations. I can’t make it more easy :)

    Let me know what problem you face. You can ask your question on OTN forums or drop me an e-mail

  14. Narsing Says:

    Hi Kamran,

    Hey Bro How are you i did not mean that i did not understand. Ok Let me be perfect actually as in my first post i told that iam having 3 years of exp in TESTING and as i dnt have any realtime exp on Oracle DBA iam not getting any calls so i planned to put an experience of 2years as a junior DBA and try but as you know that having knowledge and working in real time environment will be total different. And the question which i asked was based on this. In 1 of the interview they asked me

    How u manage sga,
    What was your role as a junior dba,
    Why you need pga,
    What is database cloning,
    Do u have knowledge on RAC,
    How many databases did you maintained ,
    On which database you worked i.e dev or testing,
    what kind of errors u faced with respect to developers.

    So Brother what exactly i want to know from you is the above mentioned points how can i practice at home with the help of two systems .

    And bro People like you make life easy for people like us. And by browsing your blog iam building confidence day by day. I learnt many things.And iam very thankful to YOU.

  15. Vaibhav Marathe Says:

    I want to start up with the Oracle can you guide me how to start with Oracle. I want to be a Database Administrator.

  16. Kamran Agayev A. Says:

    Dear Vaibvah

    I’d suggest you to read Tonguc Yilmaz’s article from the following link:
    http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc

    Good Luck!

  17. justin Says:

    hi kamran

    can u pls send the datapump architecture and work wrounds will be great help for me

    ur job is fantastic

    justin

  18. Kamran Agayev A. Says:

    Hi Justin

    Just check the following link from the documentation and you’ll get much more information on Data Pump

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

  19. Arvind Says:

    Hi Kamran,
    I really liked the way you explained the steps for installation.
    Can you provide me link/document for Oracle 11gR1 preferable (11.1.0.7) on Oracle Enterprise Linux 5/5.3
    I would really appreciate if anyone else who has experience installing can post the link.

    Thank you
    Arvind

  20. Kamran Agayev A. Says:

    Hi Arvind

    I’m currently working on creating video tutorial on installation Oracle 11g on Linux
    There’re a lot of aricles written on Oracle 11g installation, you can find them from google.com :)

    Good Luck

  21. Khan Says:

    Assalamualaikum WRB

    Hi Kamran

    How are you? hope you are good over there. I trained my Oracle9i in Linux on 2007, i wrote SQL and Fundamentals II exams. Bcoz of some circumstances i need to change my field to Purchasing, now i would like to join as an DBA. I want to refresh all my past scripts of SQL and Oracle. I have installed Oracle10g in my Windows Vista. Please help me to refresh all the scripts from the begining. If you send any tutorial guide or video it’ll be much useful for me and appreciatable for you.

    Regards
    Khan

  22. Kamran Agayev A. Says:

    Va aleykum salam dear Khan

    About whicih script are you talking? Could you elaborate more please?

    I’d suggest you to read “Administration Guide” and “Oracle Concepts” from http://tahiti.oracle.com

    Good Luck

  23. Khan Says:

    Hi Kamran

    Thanks for your prompt response. I would like to learn all the practical lessons with video tutorial or picture view from the basic after installation of Oracle 10g in Windows and i need to know from where i can install the patches. Because i am new to Oracle on Windows, please let me know from the begining to learn. Because i am in the situation to shift the job as DBA, please try to help me out brother.

    Regards
    Khan

  24. Kamran Agayev A. Says:

    Dear Khan

    There’s no enough video tutorials over the net. I’d suggest you to read documentation, make more practices and use Oracle on Linux, because most of databases run on Linux rather that Windows

    Good Luck

    P.S. Please ask your further questions over OTN forum – http://forums.oracle.com or drop me an e-mail to get detailed advice

  25. Khan Says:

    Salamalaikum Kamran

    Thanks for your guidance, it was much useful. I installed my OEM successfully in my Vista, after installing when i startup the database. It requires host credential and database credentials, i entered the credentials as i did. But it shows the error as
    “Error Message
    Couldnot contact the agent. Verify that the url for the agent is null”
    Please clear to solve the problem,, Is there any other credential will use? .
    Waiting for your reply.

    Thanks and Regards
    Khan

  26. Kamran Agayev A. Says:

    Dear Khan

    Please ask your questions over OTN forum – http://forums.oracle.com
    Before asking a question, try to search over the net. There’re a lot of discussions there. Use the following link:
    http://tinyurl.com/35pmmhu

  27. vedat Says:

    Merhaba Kamran Hocam;
    Sİzin anlatımınıza göre centos ve oracle enterprise serverlar üzerine oracle 10g r2 kurdum.Elleirnize sağlık.Şimdi bir sorum olacak.Ben bu iki database i birbirleri ile konuşturmak istiyorum.Yani oracle enterprise üzerindeki oracleden centostaki oracleye yine centostaki oracleden diğerindeki bilgilere ulaşmak istiyorum.Nasıl bir yol izlemeliyim.Teşekkürler.

  28. Kamran Agayev A. Says:

    Salam Vedat

    Bunu men “Creating Duplicate and Standby database using RMAN” videosunda gostermisem. Onu izlesen, goreceksen
    http://kamranagayev.wordpress.com/2010/06/25/rman-video-tutorial-series-creating-duplicate-and-standby-database-using-rman/

    Basarilar

  29. venkatadevendrareddy Says:

    hi kamran,
    i am working as peoplesoft dba on AIX OS.I am looking for more documents and scripts related to peoplesoft admin and any peoplesoft enhancements from oracle company.
    kindly let me know if any new updates.

    Regards,
    p.v.devendrareddy

  30. Kamran Agayev A. Says:

    Dear Devendra

    Unfortunately I haven’t enough information on PeopleSoft DBA blogs. You can find the list of such blogs from google. Use the following address
    http://tinyurl.com/2afl7ns

    Good Luck!

  31. Tejaswi Says:

    Hello Sir.
    I want to become an Oracle DBA.
    I have started learning Oracle 11g DBA with “Oracle for Dummies”,”Oracle Beginners Guide”,”Oracle SQL” which are Oracle Press Books.
    I java if we learn any new concept we practise programs through examples.But in Oracle what kind of examples can we practise with.Where they are available?.
    Also tell me the Best way to Start Learning Oracle 11g DBA.

  32. Kamran Agayev A. Says:

    Hi Tejaswi

    I’d suggest you to get the book of Tom Kyte “Expert Oracle Database Architecture (second edition)”, install Oracle and start reading and practicing the book

  33. Tejaswi Says:

    Thank You Very Much sir.
    I also would like to know Whether the openings for Oracle will be more as For Java Programmers.
    And What wiil be the salary range for a novice Oracle DBA in India?

  34. Ather Hussain Says:

    Hello Kamran

    Do you have any performance tuning video ?

    Ather Hussain
    India
    atherhussain9@yahoo.com

  35. Kamran Agayev A. Says:

    Dear Ather

    As I’m concentrated only on RMAN video tutorials, I haven’t any tuning tutorials for now

  36. Ziya Says:

    Assalamu Alaikum WRWB Dear Brother Kamran,

    You are doing a great Job. Keep it up.
    May Allah swt accept and grant you success in this world and the hereafter.

    Wassalam,
    Ziya

  37. Kamran Agayev A. Says:

    Aleykum salam dear Ziya

    Thank you for your feedback, I really appreciate it. Wish you the same

  38. nassyam basha Says:

    hi Kamran,
    assalam alaikum, khairiat..

    i saw your videos really its amazing… the videos are like “spoon feeding”, thanks for you help… you are helping a lot to world..

    i have one question.
    if i want to migrate database to enterprise to standard edition.. i checked with Metalink, it suggesting to follow exp/imp, but it was updated very old,

    can you tell me what is the better way to migrate database from enterprise edition to standard edition..

    my view is to go with ” transportable tablespaces.”

    waiting for your reply.

    Thanks in advance.

  39. Kamran Agayev A. Says:

    Aleykum salam dear Nassyam

    The only way of converting Enterprise Edition to Sdandard that’s described in metalink, is the following note:

    Converting An Enterprise Edition Database To Standard Edition [ID 139642.1]

  40. Tejaswi Says:

    Hello Mr.Kamram can you suggest me any web site where i canfind the Video on Oracle 11g Architecture?

  41. Mukhtar Ahmad Says:

    Dear Brother Kamran,

    Asalamu-Alikum,

    I see you have been doing a great job by helping society and mankind,thats the best service our Prophet (PBUH)has asked us to do.
    I am a newbie in the field of IT and Oracle in particular,I would like to get your help on me getting hands with Oracle Financials EBS.R12.
    Kindly suugest the best way to acquire indepth knowlege and good hold on the Oracle Financials as I aspire to be a Functional Consultant in Oracle Financials.R12

    Thanks,
    Mukhtar Ahmad

  42. Kamran Agayev A. Says:

    Va aleykum salam dear Mukhtar

    Unfortunately I’m not using Oracle Financials, so can’t help you on this. Check the following google result and contact those admins who use the product you mentioned
    http://tinyurl.com/23dvvva

    Good Luck

  43. Aijaz Khan Says:

    Dear Mr, Kamran

    I need your help. I have a question to you please i will be very thankful to you if you assist me how to do it.

    My Question is: How i can connect two linux virtual machines in vmware?

    I have install vmware workstation on Windows 7 operating system.

    1) In VMware workstation i made 1st virtual machine of linux 4 and install oracle 11g on it with database ready.
    2) In Vmware workstation i made 2nd virtual machine of linux 4 and install oracle 11g on it without database.

    Now my question is i want to play with this two virtual machines as Client and Server.

    1st virtual machine will act as a server
    2nd virtual machine will act as a client

    now i want to connect from client to my server database using two files i.e. listener.ora and tnsnames.ora.

    I justed wanted to know how i can ping with these two linux machines. If you suggest me help with snapshots i will be very thankful to you.

    i dont have two pc though i am working on my laptop someone has suggest me it can be possible in vmware workstation to communicate with client and server.

    Please help me.

    Best regards,

    Aijaz Khan

  44. Kamran Agayev A. Says:

    Dear Aijaz

    I’ve shown it in my “Performing Disaster Recovery with RMAN” tutorial
    You can get it from the following link:
    http://kamranagayev.wordpress.com/2010/03/29/rman-video-tutorial-series-performing-disaster-recovery-with-rman/

    Just change network configuration of both vmware machines to “Host Only” and enable the network. Each machine will get automatically DHCP ip and you’ll be able to ping from one to another

    Good Luck!

  45. seetharam Says:

    Dear Kamran ,

    please assit to do schema separation steps Developement database .
    Thanking u

  46. Kamran Agayev A. Says:

    Could you please elaborate more? Do you want to migrate a schema or anything else?

  47. Avinash Says:

    sir, im having a dought..plz help me…
    im trying to become a dba with self study..my question is -on which os is better to practise dba i.e on windows(gui)or linux(command line)…i dont know much about linux…this is my problem…..plz give me reply….

    Thanks & regards
    Avinash

  48. Kamran Agayev A. Says:

    Dear Avinash

    I’d strongly suggest you to start practicing on Linux. If you don’t know Linux, don’t worry, I’ve video tutorials on installing Linux and Oracle, so you can start from it
    If you want to learn Linux commands, visit the following post
    http://kamranagayev.wordpress.com/2009/02/22/linux-commands-for-oracle-dba/

    Good Luck!

  49. Tejaswi Says:

    Hi Mr.Kamran.

    I have installed Oracle 11g for windows on Windows 7 and installed Solaris 10 x86 on windows 7 as host and Solaris 10 as guest through Oracle Virtual Box.I have also installed Oracle 11g for Solaris on Solaris 10.

    Now i want to make Windows 7 as client and Solaris as Server.How can i do this? Do you have any videos on this.
    Please Reply soon.

  50. Kamran Agayev A. Says:

    Dear Tejaswi

    Unfortunately I don’t have a video tutorial on this. As I’m using a Vmware for creating virual machines, so it’s not a problem to connect from local PC to the vmware machine

  51. Avinash Says:

    Thank You Very Much Sir………….

  52. Tejaswi Says:

    Hello Mr.Kamran.

    I regularly visit many of the top Oracle Blogs.But the thing which i found really good in this blog than others is your blog is very Interactive to those seek your help.

    Thanks a lot for your Kind Service towards us.
    Regard’s Tejaswi

  53. Raghav Says:

    Hello Mr Kamran Agayev,

    At present i am a Sun Certified Java Professional.I want to Become an Oracle DBA since i found it is more challenging than Java.So i need your suggestion for the start up.
    I hope that you would suggest the best.
    Awaiting for your Answer.

  54. Kamran Agayev A. Says:

    Hi dear Raghav

    I’d suggest you to read Tonguc Yilmaz’s (Oracle ACE) introduction for newbies doc from the following address:
    http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc

  55. Tejaswi Says:

    What is the exact Difference between Oracle Application server and Oracle Data Base?

  56. kasante Says:

    thank you for helping the newbie in oracle database. please i want step by step installation of oracle 10gR2 on red hat Linux 9. i will be glad if you would help or you can send it through my mail. thank you.

  57. Kamran Agayev A. Says:

    Hi dear Kasante

    I haven’t tested it yet, but it should be same as in my Oracle+Centos installation. Just try it and let me know

  58. kasante Says:

    hello mr kamran, i try installing i finished the installation on redhat linux 9 and i have set the environmental variables but when i execute sqlplus i receive the following message:( error 6 initializing SQL*plus message file sp1 msb not found. sp2-0750: you may need to set ORACLE_HOME to your oracle software directory.)please help sort it out. thanks

  59. Kamran Agayev A. Says:

    Read the error message again and you’ll see that you need to set ORACLE_HOME environment variable. Please use google before posting such easy questions

    Thanks and good luck

  60. Hemanth Says:

    Hello sir,
    I’m Hemanth.Right now i’m pursuing B.Tech 2nd year under Electronics dept.But i want to become an Oracle DBA.
    I heard about your blog from Tejaswi who had posted some threads in this blog.
    As i’m pursuing engineering i can’t afford time to got for Institutions for Learning DBA.So i would like to prepare at home.
    “Can you suggest me on how to Startup learning and Practise Oracle 11g DBA?”

  61. Kamran Agayev A. Says:

    Dear Hemanth

    I’d suggest you to start reading Oracle documentation from http://tahiti.oracle.com by installing vmware+OEL+oracle on it

    You can start practicing my video tutorials as well

  62. kasante Says:

    thank you very much iam now using oracle on redhat linux 9, thank you very much

  63. kasante Says:

    Dear mr kamran, please i want to work with oracle RAC so i will be happy if you can help me with it. thank you.

  64. Neeraj Says:

    Dear Kamran,
    I want to learn Oracle RAC can you help me on this if you have any Oracle book for learning RAC or video which was created by you please share with me.

  65. Kamran Agayev A. Says:

    Dear Neeraj
    I’ll let you know when the RAC video tutorial will be posted

  66. Sakhavat Says:

    Good work!

  67. Imran Says:

    Assalamualaikum WRB

    Good job kamran, i have a doubt in my certifications.
    I wrote Oracle9i SQL and Fundamentals-II on 2007 and i did Oracle10g AdminI&II with the same testing id of 2007 in this November. I wanna know whether i completed OCP or not?

    Thanks in Advance

  68. Kamran Agayev A. Says:

    Aleykum salam Imran

    After passing all three exams you need to “Complete the Course Submission Form”
    http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=99

    I’d suggest you to register at http://certview.oracle.com and provide your old accout to merge all your exam history with Oracle and there you’ll see your certification status
    Good Luck!

  69. Imran Says:

    Walaikum salaam Kamran

    Very thanks for your help, i have merged the exams which cleared.
    But, when i click the Certification Status its showing as OCA not as OCP.
    see the below view:-

    Test Start Date Exam Number Exam Title Grade Indicator
    20-NOV-10 1Z0-043 Oracle Database 10g: Administration II PASS

    19-NOV-10 1Z0-042 Oracle Database 10g: Administration I PASS

    03-APR-07 1Z0-007 Introduction to Oracle9i: SQL PASS

    30-NOV-06 1Z0-032 Oracle9i Database: Fundamentals II PASS

    Please advice further brother.

    Thanks in advance.

  70. Kamran Agayev A. Says:

    Dear Imran

    In my previous comment I’ve written:

    After passing all three exams you need to “Complete the Course Submission Form”
    http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=99

    So please check the link and complete the course submission form if you have taken any Oracle University class. Without it, you’re OCA

  71. Imran Says:

    Dear Kamran,

    Thanks for your info, i updated the course submission form accordingly.
    Hope i will receive my OCP. :)

  72. mehdi Says:

    Dear kamran,
    hello, how are you? I hope every thing is well.
    my name is mehdi from iran, Azerbaijan. I am very glad to see your web site because you are really senior at oracle. i need your help.
    9 month ago I apply for take state sponsor from victoria in australia in oracle DBA, but they rejected my application in spite of my good resume and experiences(more than 8 years experiences) . I really was shocked due to this matter.
    Mr kamran ,would it be possible send me a sample senior oracle DBA resume that help me to take sponsore this time.
    I look forward hearing from you.
    Best wishes,
    Mehdi

  73. Kamran Agayev A. Says:

    Hi dear Mehdi.

    I’d suggest you to investigate CV of Oracle professionals from http://www.linkedin.com page. There’re a lot of DBA’s registered their CVs and you can find more useful information

    Good Luck!

  74. Mohan Says:

    Hi Kamran,

    Good Morning, i am Mohan from India..i saw ur video’s very nice. i need to how to install oracle 11gr2 on OEL.so i would request you to put that video if possible.

    Thank You,
    Mohan

  75. Kamran Agayev A. Says:

    Dear Mohan

    I’m currently working on 11gR2 installation on OEL, so just keep visiting my blog

  76. Tejaswi Says:

    Hello Mr. Kamran,

    I’m Installing Oracle 11g R2(11.2.0.1.0) On Oracle Enterprise Linux Media Update 6 .

    I’m getting the error as Follows:
    “Oracle Error :: INS-06101
    IP address of localhost could not be determined

    Cause
    The localhost is not mapped to a valid IP address in Hosts file (Eg. /etc/hosts in Unix).”

    I’m Totally a Newbie to Linux Os.

    So i don’t know how to map the Host to a =n Valid IP.

    So, can you please telly me in Detail, how can i solve this Problem

    Thank you in Advance

    Regard’s Tejaswi………

  77. Kamran Agayev A. Says:

    Dear Tejaswi. Please check the following link:
    http://forums.oracle.com/forums/thread.jspa?threadID=982024

  78. suvajit Says:

    We need more more vedio…U r really done a really good job. Please upload more more vedios. it is relly nice to become ur student. What i like in you is u r very transparent. Just simply superb all ur vedios. I am your big fan. I wisj i can meet wid you physically. Thank you thank you thank you so much……

  79. Kamran Agayev A. Says:

    Thank you Suvajit for kind words :)

    I’m currently working on some video tutorials, so jus tkeep visiting my blog

    P.S. I try to attent Oracle OpenWorld Conference every year in San Francisco, so we can meet there :)

  80. David Mayfield Says:

    I want to install sqlplus into putty. Can you give me some insight, step by step. I’m new to the Oracle field and I will be graduating within two months and I want to practice.

  81. Kamran Agayev A. Says:

    What do you mean with installing sqlplus into putty?
    You can install Oracle database and install putty to contact to that database

  82. David Mayfield Says:

    The reason I said that, is because I use sqlplus in putty through my school, however they give me a password, but it expires pretty soon, so I want to configure sqlplus in putty. How can I install oracle and putty to contact to a database.

  83. riaz ahmad ansari Says:

    assalam alikum kamran
    i am from india and i enter in dba field in 2009.i am 9i ocp certified in dba and i am a trainer in india.today first time i read your blog it is very helpfull but i am confused about scn and redo entries plz help me
    khuda hafiz

  84. Kamran Agayev A. Says:

    Aleykum salam Riaz

    For SCN, check the following link:
    http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:48052838748707

    For redo thread, check the following link:
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/onlineredo.htm#sthref853

  85. Kamran Agayev A. Says:

    Dear David

    You should connect to the host server (where database installed) using putty and don’t need to install anything

  86. Tejaswi Says:

    Happy To Know that VIrtual Installation Videos of Oracle 11g R2 on OEL and Solaris are Available ……

    Thanks a lot Mr.Kamran ……

  87. Sanjeev Kumar Says:

    Hello Kamran,

    My heartiest thanks to you for such a wonderfull document related to ORACLE RAC installation.

  88. Tom Says:

    You are doing a lot for this world.
    I have an experience of 1 year on different technology.Now i want to shift to Oracle DBA showing experience of 1 year.
    What are the questions and what level,the Interviwer may ask and what are the difficulties i may face after i join so that i can prepare as of now.
    Regards
    Tom

  89. Abdul Wahab Says:

    Hi Kamran Sir,

    I follow your posts, which are really nice for our day to day life. Thanks a lots for your effort.
    I need one favour from you. I want to install Oracle 10g R2 in text mode in an unix server.
    For that can you please help me how to install Oracle 10gR2 by using response file…
    Sir waiting for your response.
    Thanks in Advance.
    Regards,
    Abdul Wahab

  90. Kamran Agayev A. Says:

    Dear Abdul Wahhab

    Check the following link:
    http://www.oracle-base.com/articles/misc/OuiSilentInstallations.php

  91. Lekha Subash Says:

    Hi Kamran,

    Hope your doing great…I wanted to know where the listener log file in text format will be present.(I mean the location of the listener log file in Text format.).Could you please let me know the location of the file in ORACLE 11g Database.

    Awaiting your reply.

    Regards
    Lekha

  92. Kamran Agayev A. Says:

    Dear Lekha

    It should be at $ORACLE_HOME/rdbms/network/admin/log folder
    Or type lsnrctl status command and you should see the log file destination at the top

  93. Gaurav Says:

    Hi Kamran,

    Please upload patching videos…..

    thanks for other videos …these are very helpful.

  94. Lekha Subash Says:

    Hi Kamran,

    Thank you .Thank a lot for ur help.

    Regards
    Lekha

  95. harsimran Says:

    Hello Kamran ,

    scn range limit

    regards

    Harsimran

  96. Rashid Ali Says:

    salam Kamran Brother
    i am Rashid Ali from pakistan and i want to be oracle developer and also
    i am learning in developer so which step by step guide for oracle developer
    would u prefer me .
    please sir i am waiting ……..

  97. Kamran Agayev A. Says:

    Aleykum Salam Rashid

    I’d suggest you to read Oracle documentation from http://tahiti.oracle.com
    If you’re interested on books, then “Oracle SQL Recipes” and “Oracle PL/SQL by examples” are the most suggested books for the developers

    Good Luck!

  98. Rashid Ali Says:

    Thanks kamran brother
    again thanks very much

  99. ABHI Says:

    hi sir
    i m new to oracle and solaris .I have installed it and have little bit of error while installing ,but when i started my terminal(login with oracle user) i have to use the export ORACLE_HOME,export PATH,export ORACLE_SID with their it’s own value again and again before logging in sqlplus………
    totally helpless…
    no idea what to do..
    and next after entering into the sqlplus (as sys) i am also not able to run EDIT command.It gives SP2-0110 can not create save file “afiedit.buf”

    please help sir..

  100. Kamran Agayev A. Says:

    Hi

    for system default edit /etc/profile and put all environment variables in that file. Logout and login again, and you’ll see that all environment variables were exported automatically
    For any user there is a .profile in the users homedirectory.
    Check my Step by step guide on installing Oracle on Solaris:
    http://kamranagayev.wordpress.com/2010/11/03/step-by-step-installing-oracle10gr2-on-oracle-solaris/

    Now change the profile of the “oracle” user and set environemnt variables:
    gedit /export/home/oracle/.profile

    export ORACLE_BASE=/export/home/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
    export PATH=$ORACLE_HOME/bin:$PATH
    export ORACLE_SID=solaris
    export DISPLAY=:0.0

  101. abhi Says:

    dear sir
    lot of thnx for quick reply.but the problem remain same.
    i have to login again and again to start the sqlplus with export ORACLE_HOME,export PATH,export ORACLE_SID.
    as u have suggested to edit the etc/profile i have done so.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    please look at the etc/profile (login with root user)

    #ident “@(#)profile 1.19 01/03/13 SMI” /* SVr4.0 1.3 */

    # The profile that all logins get before using their own .profile.

    trap “” 2 3
    export LOGNAME PATH

    if [ “$TERM” = “” ]
    then
    if /bin/i386
    then
    TERM=sun-color
    else
    TERM=sun
    fi
    export TERM
    fi

    # Login and -su shells get /etc/profile services.
    # -rsh is given its environment in its .profile.

    case “$0” in
    -sh | -ksh | -jsh | -bash)

    if [ ! -f .hushlogin ]
    then
    /usr/sbin/quota
    # Allow the user to break the Message-Of-The-Day only.
    trap “trap ” 2″ 2
    /bin/cat -s /etc/motd
    trap “” 2

    /bin/mail -E
    case $? in
    0)
    echo “You have new mail.”
    ;;
    2)
    echo “You have mail.”
    ;;
    esac
    fi
    esac

    umask 022
    trap 2 3

    export ORACLE_SID=orcl
    export ORACLE_BASE=/export/home/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
    export PATH=$ORACLE_HOME/bin:$PATH
    export DISPLAY=:0.0
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    and local.profile

    #
    # Copyright (c) 2001 by Sun Microsystems, Inc.
    # All rights reserved.
    #
    # ident “@(#)local.profile 1.10 01/06/23 SMI”
    stty istrip
    PATH=/usr/bin:/usr/ucb:/etc:.
    export PATH
    TMP=/tmp
    TMPDIR=$TMP
    export TMP TMPDIR
    export ORACLE_SID=orcl
    export ORACLE_BASE=/export/home/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
    export PATH=$ORACLE_HOME/bin:$PATH
    export DISPLAY=:0.0

    please sir help me.

  102. abhi Says:

    hi sir i need ur help….please assist me..requested to u…

  103. ashwini Says:

    Hi Kamran.

    I need your help.please i will be very thankful to you if you assist me how to do it.
    I am getting below error while taking schema level export using expdp

    ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [INDEX_STATISTICS]
    ORA-22923: amount of data specified in streaming LOB write is 0

    I have searched on google.com website, but not getting proper solution.database is on windows server 2003 and version is 10.1.0.2

    Please help in resolving the issue.

  104. Kamran Agayev A. Says:

    Dear Ashwini

    Check the following metalink note:
    Expdp fails ORA-39125 while calling DBMS_METADATA.FETCH_XML_CLOB [COMMENT] [ID 780033.1]

  105. ashwini Says:

    Hi Kamran.

    I need your help.please i will be very thankful to you if you assist me how to do it.
    I am getting below error while taking schema level export using expdp

    ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [INDEX_STATISTICS]
    ORA-22923: amount of data specified in streaming LOB write is 0

    I have searched on google.com website, but not getting proper solution.database is on windows server 2003 and version is 10.1.0.2

    Please help in resolving the issue.

    Regards,
    Ashwini

  106. yograj Says:

    HI,

    i need oracle 11g installation on windows. we are using oracle 11 or another machine after installation, need to restore backup as well.

    thanks in advance

  107. Kamran Agayev A. Says:

    Instaling Oralce on Windows is simple. Just download the installation from oracle.com and start installing it

    If you want to restore backups from another server, you can use the following video tutorial :
    http://kamranagayev.wordpress.com/2010/08/24/rman-cloning-database-without-connecting-to-target-db-and-recovery-catalog-11gr2/

  108. syed Says:

    Dear Kamran ,
    I have successfully migrated Oracle database 10 R2 from windows server 2k3 to Linux 5.0 using user video.Thanks for that.

    I want to install Oracle10 R2 on Red Hat Enterprise Linux6.0
    Cloud you send me post Step by Step Installing Oracle Database on Red Hat Enterprise Linux6.0.
    I have complete within two days. Please help Me Send it as soon as possible.
    Thanks in Advanced.

  109. Kamran Agayev A. Says:

    Dear Syed

    Try my step by step installation for OEL 5. It should work

  110. abhi Says:

    dear sir
    lot of thnx for quick reply.but the problem remain same.
    i have to login again and again to start the sqlplus with export ORACLE_HOME,export PATH,export ORACLE_SID.
    as u have suggested to edit the etc/profile i have done so.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    please look at the etc/profile (login with root user)

    #ident “@(#)profile 1.19 01/03/13 SMI” /* SVr4.0 1.3 */

    # The profile that all logins get before using their own .profile.

    trap “” 2 3
    export LOGNAME PATH

    if [ “$TERM” = “” ]
    then
    if /bin/i386
    then
    TERM=sun-color
    else
    TERM=sun
    fi
    export TERM
    fi

    # Login and -su shells get /etc/profile services.
    # -rsh is given its environment in its .profile.

    case “$0″ in
    -sh | -ksh | -jsh | -bash)

    if [ ! -f .hushlogin ]
    then
    /usr/sbin/quota
    # Allow the user to break the Message-Of-The-Day only.
    trap “trap ” 2″ 2
    /bin/cat -s /etc/motd
    trap “” 2

    /bin/mail -E
    case $? in
    0)
    echo “You have new mail.”
    ;;
    2)
    echo “You have mail.”
    ;;
    esac
    fi
    esac

    umask 022
    trap 2 3

    export ORACLE_SID=orcl
    export ORACLE_BASE=/export/home/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
    export PATH=$ORACLE_HOME/bin:$PATH
    export DISPLAY=:0.0
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    and local.profile

    #
    # Copyright (c) 2001 by Sun Microsystems, Inc.
    # All rights reserved.
    #
    # ident “@(#)local.profile 1.10 01/06/23 SMI”
    stty istrip
    PATH=/usr/bin:/usr/ucb:/etc:.
    export PATH
    TMP=/tmp
    TMPDIR=$TMP
    export TMP TMPDIR
    export ORACLE_SID=orcl
    export ORACLE_BASE=/export/home/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
    export PATH=$ORACLE_HOME/bin:$PATH
    export DISPLAY=:0.0

    please sir help me.

  111. Arun Says:

    Hi Kamaran,

    I am migratig oracle 9i DB Schemas to Oracle 11g through exp/imp utilities (This is because of user need). There are two schemas have bigger size nearly 180G and 120G. If I used exp/imp utility then it will take minimum 3-4 full days to complete the activity. I will not get that much down time. Can you please suggest which utility I can used other than exp/imp to migrate those schema which will not take more than 4-5 hrs.

    Thanks in advance and waiting for your precious suggestins.

  112. Arunabh Says:

    Thanks Mr. Kamran,

    Such a good technical stuff to learn. I’ve just step in to oracle clustering. Can u guide me to setup a RHEL 5 based (Cluster suite) cluster with oracle 11g r2 failover in active/passive mode. Where, I node will have the share san volumes mounted and DB running at a time while the passive node will live idle. In case of failure of primary node, the cluster resources (i.e. share san vols, virtual ip etc). will relocated to secondary node, and DB in primary node shutdown properly and then start on secondary node. After resolving the primary node issue, as soon as it get online all the services & resources again shifted to primary node accordingly.

    Regards
    Arunabh

  113. Kamran Agayev A. Says:

    Hi Arunabh

    You can check my Step by Step RAC installation guide for 10g, I’ve already shown how it works

  114. Ahmed Says:

    Assalaamu Alaikum Kamran.

    I regularly visit your Oracle Blog.Your blog help me lot to improve my DBA skills, Your step-by-step guides help me lot, its very Interactive to seek help on oracle DBA topics. Could please suggest me any BLOG on ORACLE 10g Application Server which explain as u do.

    Wassalaam
    Ahmed

  115. Suhas Says:

    Hi Kamran,

    When i try to install oracle10R2 32bit on centos 5.5 64bit on cloud Side and at during package
    installation
    [root@station115 ~]# rpm -ivh compat-libcwait-2.1-2.x86_64.rpm
    ERROR: ld.so: object ‘/lib/libcwait.so’ from /etc/ld.so.preload cannot be preloaded: ignored.
    error: open of compat-libcwait-2.1-2.x86_64.rpm failed: No such file or directory

    So how to solve This problem suggest

  116. Suhas Says:

    [root@station115 PackagesForRHEL5]# rpm -ivh compat-libcwait-2.1-1.i386.rpm
    ERROR: ld.so: object ‘/lib/libcwait.so’ from /etc/ld.so.preload cannot be preloaded: ignored.
    Preparing… ########################################### [100%]
    package compat-libcwait-2.1-2.x86_64 (which is newer than compat-libcwait-2.1-1.i386) is already installed

  117. Nirav Says:

    Hi Kamran,
    I have a doubt, can you please help me? I got your reference from OTN forum where I posted my question which is as follows:

    I am new to RAC. We are planning to install RAC (oracle 11gR2 release on linux x86 os) for self study on a VM machine. What are the specifications needed for it? In terms of RAM, OS free space and CPU, (and any other parameters I missed) to specify to IT people. They will create a VM using these specificaitons and on that VM, we will try to install RAC.

    Thanks a lot!

  118. Kamran Agayev A. Says:

    You can find all information from the documentation:
    http://docs.oracle.com/cd/E11882_01/rac.112/e16795/toc.htm#BEGIN

  119. sankar Says:

    hi am trying to learn people soft dba so explain me the scope of jobs

  120. sharad Says:

    hii bro m new in oracle database..can u tell how i provide grant and role to the user for a particular database?

  121. Kamran Agayev A. Says:

    Check tahiti.oracle.com – Oracle Official Documentation page

  122. Muhd Aarif Says:

    Salam Kamran Bhai,

    I want some useful data based on oracle forms and reports so that I can clear interview and useful for projects…Is there any book where mostly graphics slide get understand all the step of oracle forms 9i/10g…etc…If any kindly provide me the link..I’ll very regardful for you…

    Thanks…
    Salaam Again
    Muhd.Aarif

  123. Kamran Agayev A. Says:

    Hi Aarif

    Unfortunately I don’t have any documentation or book on Forms and Reports. It was more than 5 years I don’t use these tools and hope they will be deprecated in the new future

  124. Swapnil Says:

    I want to install OEM 10.2.0.4 on windows xp on a PC and connect it to a database running on solaris to monitor performance of that database.
    How to start from scratch?
    Can anyone help me

  125. Kamran Agayev A. Says:

    Have you checked my video tutorial on installing OEM Grid Control and deploying agents? If not, then check it
    http://kamranagayev.com/2011/01/31/video-tutorial-installing-oracle-10gr2-grid-control-and-deploying-agent/

  126. goutham Says:

    Dear Kamran,
    I hope you are doing great,I want small information about how to connect two virtual machines.
    can u please provide me documentation regarding that.

    thanks
    regards
    k.goutham

  127. Kamran Agayev A. Says:

    To connect two virtual machines, make sure you’ve set the Network option as “Bridged”. I hope I’ve already shown it at “Performing Disaster Recovery” video tutorial (or may be in another video tutorial where I use two virtual machines)
    Just check it

  128. goutham Says:

    Hi
    Kamranagayev,
    I just got problem when installing oracle 10g on oracle enterprise Linux 5.when i run ./runInstaller from the downloaded software it gets error failed.as the Linux 5 is not compataible to oracle 10g.In your video step by step installing oracle 10g on OEL5 you installed oracle software .can u please give the info regarding changed parameters in order to install oracle10g on OEL5.

    thanks
    k.goutham

  129. Kamran Agayev A. Says:

    Please make sure you’ve followed all steps correctly and if you get the same error again, post the whole message you get

  130. goutham Says:

    Hi
    Kamran,
    I just gone through the step by step process of installing oracle 10g on Oracle Linux 5.
    but when i ran ./runInstaller from the software directory.i am getting this error.could you please go through this and let me know.this is my output

    ./runInstaller
    Starting Oracle Universal Installer…

    Checking installer requirements…

    Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
    Passed

    All installer requirements met.

    Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-24_06-03-48PM. Please wait …[oracle@dev database]$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2012-02-24_06-03-48PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
    at java.lang.ClassLoader$NativeLibrary.load(Native Method)
    at java.lang.ClassLoader.loadLibrary0(Unknown Source)
    at java.lang.ClassLoader.loadLibrary(Unknown Source)
    at java.lang.Runtime.loadLibrary0(Unknown Source)
    at java.lang.System.loadLibrary(Unknown Source)
    at sun.security.action.LoadLibraryAction.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
    at sun.awt.DebugHelper.(Unknown Source)
    at java.awt.Component.(Unknown Source)

    and the screen gets hanged.

    Thanks
    k.goutham

  131. mond Says:

    kamran muellim salam
    bilmek isterdim ki siz niye derslerinizi daha yerlesdirmirsiniz?en sonuncu 2009 cu ildedir.planlarinizda yene dersler yerlesdirmek varmi?

  132. Kamran Agayev A. Says:

    Salam Shaig
    Inshallah gelen ilden Universitetde yeniden derslere davam etsem, yeni dersleri yerlesdirecem

  133. Milind Says:

    Hi Kamran,
    Thanks for your blog, i am planning to install Active/Passive Cluster on Oracle Linux 6.2. So, please can you guide me how to configured such scenario. I have two nodes for that installation, what is the software required for setting this environment. Please reply.

    Thanks,
    Milind

  134. kumar Says:

    Hi ,

    can you please help me install oracle 10g in vmware windows xp? At the time installing, i got the error thrown with there is no host.

  135. Kamran Agayev A. Says:

    Please share the whole error you get

  136. ANIL Says:

    hi,
    can u please explain how to instal the multiple databases on a single server.. am using linux 4.0 and vmware..

  137. shailesh Says:

    Hello kamran,
    Firstly, you r doing a gr8 job by helping all so much..I need a help 4rm u..
    I want to start learning Oracle Forms 10g…i cant understand from where should i start…please suggest me…

    And is it(Oracle forms) better for career???

  138. Sushil Says:

    Hi Kamran,
    Very nice post!
    I have installed Oracle 11g database on Solaris 10 VM running on Windows 7. Now I want to access the database from windows. Can you please explain me how to achive that? Also I want to connect Solaris guest via PUTTY. Please explain this to me. Thanks a lot!

  139. Kamran Agayev A. Says:

    Hi Sushil
    You need to make the type of the Network Adapter as “Bridged”, then make it “Active”, get ip address using /sbin/ifconfig and use it from Putty

  140. Hima Says:

    Hello Kamran,
    I have recently started learning oracle 10g and want to practise, so I tried to install the oracle 10g release 2 database software on VMware Player (linux as operating system). My actual OS is windows XP. I followed the step by step guide which comes along with this software. I got this software from my friend so i dont have the cds but have disk images. There are steps to mount the cd from the cd/dvd drive but not when we have disk images.Now I want to know how do I transfer the .iso files from windows to virtual machine(linux) and mount them on linux. Please guide me.
    Thanks in advance

  141. Kamran Agayev A. Says:

    Check this link:
    http://www.petri.co.il/use-iso-image-files-vmware.htm

  142. Hima Says:

    Further information:It is Oracle Enterprise Linux R5 U4 – VMware player being used

  143. Amit Kumar Says:

    Hi Kamran

    i want to install oracle 11G on Hp-ux 11 v3 can you help or provide me notes about installing oracle 11G on
    HP-UX 11 V3

    Thanks

    Amit Kumat

  144. Kamran Agayev A. Says:

    Check the following link from the documentation for Oracle 11g HP-UX installation
    http://www.oracle.com/pls/db111/portal.portal_db?selected=11&frame=#hp-ux_installation_guides

  145. sarathi Says:

    Hi,
    I’m getting an error ‘COULD NOT READ ANY NLS CATALOG MESSAGE’ while trying to launch oracle runInstaller in RHEL 6,How can i solve this?

    Thanks in advance.

  146. Kamran Agayev A. Says:

    Have you checked google? The first link which I found contains your question:

    When I start Oracle Universal Installer from any location, after setting the PATH environment variable, I get an error that reads “Could not read any NLS message catalog!”. What do I do?

    Oracle Universal Installer needs some files in the directory where the runInstaller (UNIX) or setup.exe (Windows) is running. So, when you invoke runInstaller (UNIX) or setup.exe (Windows), you should invoke it from the directory where this command is present, or you must specify the complete path.

    http://docs.oracle.com/cd/B28359_01/em.111/b31207/a_oui_appendix.htm

  147. abhishek Says:

    Hi Sir,
    Hope you are doing best and wishing good for you future.I am regular viewer of that blog.i am confused and need your help.

    I need little bit guidance for my career regarding Oracle DBA.Here are points–:

    1)I have passed Oracle 11g Oca and have little bit knowledge ,Now i want to move further for OCP.My question is whether should i prefer Oracle Documentation or Oracle Books by ORACLE.

    2)Currently i am working as Software Engineer in MNC and previously I have Oracle DBA experience as for 2 years.So please suggest me how can i develop my skill with practical experience.

    Please sir suggest me so that i can start ASAP.

  148. Sanjay Khed Says:

    I would like to thank you, for a wonderful blog to share your knowledge to people who are interested in Oracle.

    I’m Sanjay Khed, from Bangalore, India into MS Sql Server, interested in learning Oracle from longtime.

    By going through your blog, I feel I can start with toping up my Oracle skill as well and this will be possible by seeing your Step by Step Oracle guides.

    I am will try setup Oracle setup on laptop probably this week end, my laptop has Intel i3 process with 4Gigs of ram, 250 Gigs of hard drive, loaded with windows 7 professional 32 bit OS.

    1. Is this configuration suitable to installing VM Workstation, Oracle Database 11g Release 2 on Linux?

    2. Do I need to download VM Workstation, Oracle Database 11g Release 2 and Linux apart from this software any other software is required?

    I will be thankful in advance for your expert advice.

    Sanjay Khed

  149. Kamran Agayev A. Says:

    Hi Sanjay and welcome to my blog!
    It’s enough for you for the testing purposes

    You need to have OEL (Oracle Enterprise Linux), VM machine (VirtualBox or VMware) and Oracle Database 11gR2

    Good Luck!

  150. shilpa Says:

    hi,
    i want installation procedure for installing oracle 10g on ubantu

  151. abhishek Says:

    Hi Sir,
    Hope you are doing best and wishing good for you future.I am regular viewer of that blog.i am confused and need your help.

    I need little bit guidance for my career regarding Oracle DBA.Here are points–:

    1)I have passed Oracle 11g Oca and have little bit knowledge ,Now i want to move further for OCP.My question is whether should i prefer Oracle Documentation or Oracle Books by ORACLE.

    2)Currently i am working as Software Engineer in MNC and previously I have Oracle DBA experience as for 2 years.So please suggest me how can i develop my skill with practical experience.

    Please sir suggest me so that i can start ASAP.

  152. shilpa Says:

    hi
    now we import and export through imp and exp in command line and want to use datapump so how can i use?

  153. Rajeev Says:

    Hi Kamran,
    At prsent i am at client side and i need to configure active/passive database on linux server (Not RAC). We install database on both the node. (active / passive). Created listner on both the node, created service on both the node. Created database on Shared Server location. Now guide me what to do for active/passive database work in fail-over senerio.

  154. Kamran Agayev A. Says:

    Check my step by step RAC installation document
    You need to create Service and enable failover

  155. farhan Says:

    sir i detail and installation of oracle 11g r2 rac on oel 5.5 through vmware workstation sir can you help me thanks in advance

  156. rambo Says:

    Hi,
    I need you to post some videos related to patches and updates
    or post some docs so that we can read and understand..

  157. kalyani Says:

    Hi Karman,

    I need u r help.How to analyze partition table in 10g.plz its urgnt……….

  158. premraj Says:

    Hi Kamran,

    I am new to RMAN,. could you please send some RMAN backup and recovery guides/video files.

  159. Kamran Agayev A. Says:

    HI Premraj
    Have you checked my video tutorials?
    http://kamranagayev.com/oracle-video-tutorials/

  160. Abdullah Says:

    Hi Kamran,

    Thanks for your support for new beginners like me and everyone,
    i m trying to install oracle 11g rel2 on oel5 but getting os linking errors when executing $./runInstaller
    plz could you suggest any detailed procedure installing 11g Rel2 on oel5.

    & could you plz post how to install 11g rel2 on rac in vmvare.

    Thanks

  161. Kamran Agayev A. Says:

    Hi Abdullah
    It seems you’re installing wrong software. Make sure you’re using same bit for OS and Oracle installation

  162. jayachandran Says:

    Hello Sir,

    I am jayachandran . i am facing an error when open the database is that “end of file communication error”

    so please give some guidelines for this error

    Regards

    Jayachandran

  163. Kamran Agayev A. Says:

    Hi Jayachandran
    Please post output from alert.log file. The information you’ve provided is not necessary

  164. deepthi Says:

    Hi,

    congratulations for getting OCM.

    My name is deepthi.i am working as a oracle dba. Recently , I installed 12c enterprise manager in 12c cloud control .and I deploy the agent on all targets .I am trying to apply patches on all targets at the same time and apply patches on each individual targets.

    and I have one more problem I created rman job on 12c enterprise manager for the first time it went fine job succeeded and I scheduled job repeating every day. after job is failing .

    I used the same script. I dodnt understand what I did wrong. please give some suggestions.

    Thanks,
    Deepthi.

  165. Kamran Agayev A. Says:

    Hi Deepthi
    Check the following link for more information:
    https://forums.oracle.com/thread/667088

  166. Oracle Community Says:

    okay so what if we develop the script manually.. is there any harm in it, plus thank u for sharing the information.

  167. Krishna Says:

    i’m looking for your update of “step by step guide for 11gr2 rac on linux in vmware ‘

    hope will find it soon

  168. Rahul Parmar Says:

    Hi,

    Can you please help in resolving the Load balancing issue for RAC structure having 2 Nodes in which Load balancing is activated on the server side by editing tnsnames.ora file on both the nodes,but still load is observed on single node.

    Please do reply

    Regards,
    Rahul

  169. Kamran Agayev A. Says:

    Hi Rahul
    Make sure you’re connecting using service
    Check the status of the service
    Try to use my load balancing script to check if load balancing is working
    http://kamranagayev.com/2013/01/14/testing-load-balancing-in-oracle-rac/

  170. Kamran Says:

    Dear Mukesh, I am having an issue that We are using Oracle 11g DB & Weblogic server … whenever end user is connect with the Applications, v$session show the Weblogic Server Name and does not show the actual connecting Terminal as well as Operating System Name… There is any way to get the User Terminal as well as OS Name ???

  171. abdullah Says:

    Hello to all,
    i m very much intersted in oracle DBA course,
    after searchimg websites..i became lot confused..with concepts like performance tuning,back-up and recovery,RAC,data guard etc.
    can anyone tell me the flow of learning these concepts

  172. muhammad abdullah Says:

    Hello to all,
    i m very much intersted in oracle DBA course,
    after searchimg websites..i became lot confused..with concepts like performance tuning,back-up and recovery,RAC,data guard etc.
    can anyone tell me the flow of learning these concepts

  173. Kamran Agayev A. Says:

    Hi Muhammad
    Check the following blog post by Tonguc Yilmaz
    http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc

  174. SD Says:

    hi Kamran,
    i am new Jr.DBA. I WANT TO MIGRATE ORACLE 10G ON WINDOWS XP TO REDHAT LINUX. PLEASE HELP ME.

  175. Kamran Agayev A. Says:

    Hi
    Check my video tutorial
    http://kamranagayev.com/2010/08/20/rman-convert-database-video-tutorial/

  176. Sairam Laga Says:

    Dear Kamran,

    I want need help from you and It’s when I was starting install Oracle 11g r2 database, Iam getting this below error please give me a solution

    [oracle11g@DBA database]$ ./runInstaller
    Starting Oracle Universal Installer…

    Checking Temp space: must be greater than 120 MB. Actual 519 MB Passed
    Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed
    Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
    Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-06-13_03-50-49AM. Please wait …
    DISPLAY not set. Please set the DISPLAY and try again.
    Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
    – For csh: % setenv DISPLAY 192.168.1.128:0.0
    – For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
    Use the following command to see what shell is being used:
    echo $SHELL
    Use the following command to view the current DISPLAY environment variable setting:
    echo $DISPLAY
    – Make sure that client users are authorized to connect to the X Server.
    To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
    % xhost +
    To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
    %
    If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
    Typical path for xclock: /usr/X11R6/bin/xclock

  177. Kamran Agayev A. Says:

    Make sure you’ve installed all necessary Desktop and X11 packages.

  178. Hemang Shah Says:

    Useful information shared..Iam very happy to read this article.
    I cleard (java)SCJP,SCWCD certifications.Now i want to oracle certification.can you tell me.Which certification exam is suitable for me(sql queries). and how can i prepare step by step clearly.

  179. aria Says:

    helo respected sir,

    i want to keen intersted about core arcutecture and rac arcuterure. plz

    help mee

  180. munir ahmed Says:

    sir I want to install oracle 11g on linux ubuntu 14.10 but I am finding difficulty in installing,could you please suggest a webpage to help me as most of existing ones are ambiguous in terms of minute details.I am a beginner in using ubuntu

  181. Kamran Agayev A. Says:

    Hi Munir
    I would suggest you to check my blogpost on installation Oracle 11g on Linux
    http://kamranagayev.com/2011/03/21/step-by-step-installing-oracle11g-on-linux/

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>