Step by Step Oracle guides
Here, I’ve collected all my “Step by Step Guides” which help you to understand basic concepts very easily
Installing CentOS on VMware – Step by Step
Step by Step installing Oracle 10g RAC on VMware
Step by Step installing Oracle 11gR2 on Oracle Solaris 10
Step by Step installing Oracle 11gR2 on OEL 5.5
Step by Step Installing Oracle Database 10gR2 on Oracle Solaris 10
Create Database Manually – Step by Step instruction
December 8th, 2009 at 12:31 pm
my goal is made a oracle DBA.so please help me…
December 11th, 2009 at 12:08 pm
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
January 5th, 2010 at 12:26 am
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
January 5th, 2010 at 4:52 pm
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
January 19th, 2010 at 6:11 am
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.
March 17th, 2010 at 2:38 pm
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…
March 18th, 2010 at 9:38 am
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!
April 19th, 2010 at 2:43 pm
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
April 19th, 2010 at 4:44 pm
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
April 23rd, 2010 at 6:19 am
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
April 23rd, 2010 at 9:56 am
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
April 28th, 2010 at 10:42 am
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.
April 28th, 2010 at 10:45 am
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
May 19th, 2010 at 7:27 am
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.
May 29th, 2010 at 12:25 am
I want to start up with the Oracle can you guide me how to start with Oracle. I want to be a Database Administrator.
May 30th, 2010 at 10:48 pm
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!
July 2nd, 2010 at 11:39 am
hi kamran
can u pls send the datapump architecture and work wrounds will be great help for me
ur job is fantastic
justin
July 2nd, 2010 at 1:36 pm
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
July 2nd, 2010 at 8:27 pm
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
July 3rd, 2010 at 12:36 am
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
July 3rd, 2010 at 11:02 pm
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
July 4th, 2010 at 2:04 am
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
July 4th, 2010 at 4:05 pm
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
July 5th, 2010 at 9:11 am
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
July 6th, 2010 at 12:23 am
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
July 7th, 2010 at 2:36 pm
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
July 31st, 2010 at 7:08 pm
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.
August 2nd, 2010 at 1:50 pm
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
August 4th, 2010 at 9:12 am
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
August 4th, 2010 at 1:49 pm
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!
September 6th, 2010 at 7:48 pm
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.
September 7th, 2010 at 5:36 pm
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
September 7th, 2010 at 6:39 pm
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?
September 9th, 2010 at 10:12 am
Hello Kamran
Do you have any performance tuning video ?
Ather Hussain
India
atherhussain9@yahoo.com
September 10th, 2010 at 1:04 am
Dear Ather
As I’m concentrated only on RMAN video tutorials, I haven’t any tuning tutorials for now
September 15th, 2010 at 1:36 pm
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
September 15th, 2010 at 6:57 pm
Aleykum salam dear Ziya
Thank you for your feedback, I really appreciate it. Wish you the same
September 19th, 2010 at 12:01 pm
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.
October 5th, 2010 at 3:34 pm
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]
September 30th, 2010 at 5:24 pm
Hello Mr.Kamram can you suggest me any web site where i canfind the Video on Oracle 11g Architecture?
October 17th, 2010 at 12:25 am
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
October 19th, 2010 at 10:43 am
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
October 30th, 2010 at 3:43 am
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
October 30th, 2010 at 6:31 pm
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!
November 2nd, 2010 at 3:39 pm
Dear Kamran ,
please assit to do schema separation steps Developement database .
Thanking u
November 2nd, 2010 at 5:16 pm
Could you please elaborate more? Do you want to migrate a schema or anything else?
November 11th, 2010 at 3:01 pm
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
November 12th, 2010 at 10:18 am
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!
November 11th, 2010 at 5:30 pm
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.
November 12th, 2010 at 10:20 am
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
November 12th, 2010 at 2:23 pm
Thank You Very Much Sir………….
November 14th, 2010 at 9:55 pm
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
November 14th, 2010 at 10:06 pm
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.
November 16th, 2010 at 12:39 am
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
November 15th, 2010 at 1:53 pm
What is the exact Difference between Oracle Application server and Oracle Data Base?
November 16th, 2010 at 12:00 am
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.
November 16th, 2010 at 12:37 am
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
November 18th, 2010 at 12:11 am
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
November 18th, 2010 at 10:13 am
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
November 22nd, 2010 at 7:12 pm
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?”
November 23rd, 2010 at 10:19 am
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
November 23rd, 2010 at 5:32 pm
thank you very much iam now using oracle on redhat linux 9, thank you very much
November 30th, 2010 at 8:44 pm
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.
December 3rd, 2010 at 8:23 pm
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.
December 6th, 2010 at 10:15 am
Dear Neeraj
I’ll let you know when the RAC video tutorial will be posted
December 8th, 2010 at 3:10 pm
Good work!
December 15th, 2010 at 10:48 am
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
December 15th, 2010 at 10:51 am
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!
December 15th, 2010 at 1:13 pm
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.
December 15th, 2010 at 1:16 pm
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
December 19th, 2010 at 2:56 pm
Dear Kamran,
Thanks for your info, i updated the course submission form accordingly.
Hope i will receive my OCP.
January 24th, 2011 at 11:47 am
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
January 24th, 2011 at 4:44 pm
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!
February 23rd, 2011 at 6:43 pm
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
February 24th, 2011 at 11:43 am
Dear Mohan
I’m currently working on 11gR2 installation on OEL, so just keep visiting my blog
February 24th, 2011 at 5:36 pm
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………
February 25th, 2011 at 12:02 am
Dear Tejaswi. Please check the following link:
http://forums.oracle.com/forums/thread.jspa?threadID=982024
February 28th, 2011 at 7:08 pm
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……
February 28th, 2011 at 7:10 pm
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
March 9th, 2011 at 11:00 pm
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.
March 9th, 2011 at 11:57 pm
What do you mean with installing sqlplus into putty?
You can install Oracle database and install putty to contact to that database
March 17th, 2011 at 9:43 pm
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.
March 17th, 2011 at 11:56 pm
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
March 18th, 2011 at 12:08 am
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
March 18th, 2011 at 12:20 am
Dear David
You should connect to the host server (where database installed) using putty and don’t need to install anything
March 27th, 2011 at 11:33 am
Happy To Know that VIrtual Installation Videos of Oracle 11g R2 on OEL and Solaris are Available ……
Thanks a lot Mr.Kamran ……
April 8th, 2011 at 3:37 pm
Hello Kamran,
My heartiest thanks to you for such a wonderfull document related to ORACLE RAC installation.
April 18th, 2011 at 2:31 pm
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
June 10th, 2011 at 8:50 pm
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
June 16th, 2011 at 3:09 pm
Dear Abdul Wahhab
Check the following link:
http://www.oracle-base.com/articles/misc/OuiSilentInstallations.php
June 15th, 2011 at 12:01 pm
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
June 16th, 2011 at 3:04 pm
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
June 16th, 2011 at 10:31 pm
Hi Kamran,
Please upload patching videos…..
thanks for other videos …these are very helpful.
June 21st, 2011 at 12:13 pm
Hi Kamran,
Thank you .Thank a lot for ur help.
Regards
Lekha
July 5th, 2011 at 7:32 pm
Hello Kamran ,
scn range limit
regards
Harsimran
July 6th, 2011 at 4:49 pm
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 ……..
July 8th, 2011 at 10:03 am
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!
July 8th, 2011 at 7:37 pm
Thanks kamran brother
again thanks very much
July 15th, 2011 at 5:08 pm
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..
July 15th, 2011 at 5:16 pm
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
July 15th, 2011 at 9:04 pm
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.
July 19th, 2011 at 8:35 am
hi sir i need ur help….please assist me..requested to u…
July 20th, 2011 at 2:29 pm
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.
July 22nd, 2011 at 3:18 pm
Dear Ashwini
Check the following metalink note:
Expdp fails ORA-39125 while calling DBMS_METADATA.FETCH_XML_CLOB [COMMENT] [ID 780033.1]
July 22nd, 2011 at 12:42 pm
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
July 23rd, 2011 at 2:49 pm
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
July 25th, 2011 at 1:41 pm
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/
July 23rd, 2011 at 5:11 pm
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.
July 25th, 2011 at 11:37 am
Dear Syed
Try my step by step installation for OEL 5. It should work
July 30th, 2011 at 1:41 pm
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.
August 8th, 2011 at 6:55 pm
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.
September 5th, 2011 at 4:30 pm
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
September 16th, 2011 at 7:12 pm
Hi Arunabh
You can check my Step by Step RAC installation guide for 10g, I’ve already shown how it works
October 26th, 2011 at 7:50 am
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
December 9th, 2011 at 8:26 am
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
December 9th, 2011 at 8:29 am
[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
January 11th, 2012 at 8:04 pm
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!
January 13th, 2012 at 7:38 am
You can find all information from the documentation:
http://docs.oracle.com/cd/E11882_01/rac.112/e16795/toc.htm#BEGIN
January 22nd, 2012 at 9:01 am
hi am trying to learn people soft dba so explain me the scope of jobs
February 11th, 2012 at 6:46 am
hii bro m new in oracle database..can u tell how i provide grant and role to the user for a particular database?
February 12th, 2012 at 4:20 pm
Check tahiti.oracle.com – Oracle Official Documentation page
February 20th, 2012 at 9:59 am
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
February 20th, 2012 at 10:18 pm
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
February 20th, 2012 at 5:58 pm
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
February 20th, 2012 at 10:37 pm
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/
February 22nd, 2012 at 8:53 pm
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
February 23rd, 2012 at 5:56 am
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
February 23rd, 2012 at 8:09 pm
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
February 24th, 2012 at 6:24 am
Please make sure you’ve followed all steps correctly and if you get the same error again, post the whole message you get
February 24th, 2012 at 6:09 pm
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
February 28th, 2012 at 5:00 pm
kamran muellim salam
bilmek isterdim ki siz niye derslerinizi daha yerlesdirmirsiniz?en sonuncu 2009 cu ildedir.planlarinizda yene dersler yerlesdirmek varmi?
February 29th, 2012 at 5:59 am
Salam Shaig
Inshallah gelen ilden Universitetde yeniden derslere davam etsem, yeni dersleri yerlesdirecem
March 14th, 2012 at 7:01 am
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
March 14th, 2012 at 3:49 pm
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.
March 21st, 2012 at 6:50 pm
Please share the whole error you get
March 30th, 2012 at 10:33 am
hi,
can u please explain how to instal the multiple databases on a single server.. am using linux 4.0 and vmware..
April 9th, 2012 at 8:50 am
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???
June 14th, 2012 at 4:49 am
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!
June 15th, 2012 at 7:30 am
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
June 26th, 2012 at 5:56 pm
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
June 27th, 2012 at 3:54 am
Check this link:
http://www.petri.co.il/use-iso-image-files-vmware.htm
June 26th, 2012 at 5:59 pm
Further information:It is Oracle Enterprise Linux R5 U4 – VMware player being used
August 27th, 2012 at 7:18 am
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
September 14th, 2012 at 5:18 am
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
September 13th, 2012 at 7:08 am
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.
September 14th, 2012 at 5:14 am
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
October 17th, 2012 at 12:55 am
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.
October 18th, 2012 at 9:08 am
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
October 30th, 2012 at 11:26 am
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!
November 1st, 2012 at 5:19 am
hi,
i want installation procedure for installing oracle 10g on ubantu
November 2nd, 2012 at 2:35 pm
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.
November 8th, 2012 at 1:46 pm
hi
now we import and export through imp and exp in command line and want to use datapump so how can i use?
December 1st, 2012 at 10:18 am
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.
December 24th, 2012 at 6:25 am
Check my step by step RAC installation document
You need to create Service and enable failover
December 11th, 2012 at 11:34 am
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
December 30th, 2012 at 12:20 pm
Hi,
I need you to post some videos related to patches and updates
or post some docs so that we can read and understand..
January 31st, 2013 at 8:06 am
Hi Karman,
I need u r help.How to analyze partition table in 10g.plz its urgnt……….
February 12th, 2013 at 11:47 am
Hi Kamran,
I am new to RMAN,. could you please send some RMAN backup and recovery guides/video files.
February 15th, 2013 at 1:08 pm
HI Premraj
Have you checked my video tutorials?
http://kamranagayev.com/oracle-video-tutorials/
March 15th, 2013 at 4:12 pm
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
June 13th, 2013 at 5:52 am
Hi Abdullah
It seems you’re installing wrong software. Make sure you’re using same bit for OS and Oracle installation
April 19th, 2013 at 5:07 am
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
April 25th, 2013 at 9:09 am
Hi Jayachandran
Please post output from alert.log file. The information you’ve provided is not necessary
July 22nd, 2013 at 4:19 pm
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.
August 5th, 2013 at 4:04 am
Hi Deepthi
Check the following link for more information:
https://forums.oracle.com/thread/667088
August 1st, 2013 at 9:42 am
okay so what if we develop the script manually.. is there any harm in it, plus thank u for sharing the information.
January 29th, 2014 at 12:02 pm
i’m looking for your update of “step by step guide for 11gr2 rac on linux in vmware ‘
hope will find it soon
May 8th, 2014 at 5:28 am
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
June 11th, 2014 at 8:45 am
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/
May 8th, 2014 at 10:48 am
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 ???
May 21st, 2014 at 2:00 pm
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
May 21st, 2014 at 2:01 pm
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
June 11th, 2014 at 8:28 am
Hi Muhammad
Check the following blog post by Tonguc Yilmaz
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
June 9th, 2014 at 12:45 pm
hi Kamran,
i am new Jr.DBA. I WANT TO MIGRATE ORACLE 10G ON WINDOWS XP TO REDHAT LINUX. PLEASE HELP ME.
June 11th, 2014 at 8:19 am
Hi
Check my video tutorial
http://kamranagayev.com/2010/08/20/rman-convert-database-video-tutorial/
June 13th, 2014 at 4:33 pm
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
June 17th, 2014 at 3:52 am
Make sure you’ve installed all necessary Desktop and X11 packages.
November 11th, 2014 at 7:15 am
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.
January 20th, 2015 at 11:25 am
helo respected sir,
i want to keen intersted about core arcutecture and rac arcuterure. plz
help mee
April 3rd, 2015 at 9:54 am
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
April 7th, 2015 at 5:15 am
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/