Kamran Agayev's Oracle Blog

Oracle Certified Master

Step by Step installing Oracle 11g R2 on OEL 5.5

Posted by Kamran Agayev A. on March 21st, 2011

In this step by step tutorial I’m going to show you the installation of Oracle 11gR2 on OEL 5.5

As in every my step by step and video tutorials, I use VMware virtual machine, so here also I start with creating a virtual machine

P.S. Actually I was preparing this tutorial for CentOS, but somehow mixed .iso images :) So the name of the virtual machine appears as “CentOS” but the installation is made on OEL. However, you can try the same tutorial for CentOS as well

Click Next

Select Typical and click Next

Select Linux and “Red Hat Enterprise Linux 5″ as an OS version and click next

Provide the name of virtual machine and specify the location and click next

Select “Use bridged networking” and click Next

Specify the size of the virtual machine and click Finish

Delete Floppy, USB Controller and Sound Adapter devices, set Memory to 1024 Mb, mount ISO image of the OEL 5.5 OS and click OK

Click “Power on” button to start the virtual machine

Click enter

Select Skip button

Click Next

Select Installation language and click next

Select the keyboard and click next

Click on Yes

Click Next

Click on YES to remove the partition and click next

Click Next

Select the country and click next

Provide the password of the root user and click next

To install required packages for Oracle installation select “Customize now” and click Next

Desktop Environments

                                                  GNOME Desktop Environment  

Applications

                                                  Graphical Internet

Development

                                                  Development Libraries

                                                  Development Tools

                                                  GNOME Software Development

                                                  Java Development

                                                  Legacy Software Development

                                                  X Software Development  (Select libxpdevel and openmotif)

Servers

                                                  Server Configuration Tools

                                                  Web Server

                                                  Windows File Server

Base System

                                                  Administration Tools

                                                  Base

                                                  Java

                                                  Legacy Software Support (select compat-db)

                                                  System Tools  (select sysstat)

                                                  X Window System

Click Next to start the installation

Click on Reboot button

Click Forward

Choose the first option and click Forward

As we use the virtual machine for testing purpose, disable the firewall and click Forward

Disable Selinux and click Forward

Click Forward

Specify the time and date and click Forward

We don’t need to create a user so click Forward

Click Finish button to finish the installation of OEL

Login with the root user

From VM menu, select Install VMWare tools

If the vmware installation cd doesn’t appear automatically, Eject the previous cd (installation of OEL), doublt click on Computer and double click on Cd-rom device. This will initialize the vmware tools cd

Double click on .rpm package

Click on Apply to start the installation

After you set all configurations, open new terminal and run vmware-config-tools executable and finish the installation of vmware tools

Now let’s create a user and groups for Oracle installation

[code]groupadd  oinstall
groupadd  dba
useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
passwd oracle
[/code]

Change the /etc/sysconfig.conf file to add (change) kernel parameters that are required for Oracle installation

The file should be as follows:

[code]

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
[/code]

To make the active in the current session, run /sbin/sysctl -p command

Change /etc/pam.d/login file and add the followingn line:

[code]

session required pam_limits.so

[/code]

Change /etc/security/limits.conf and add the following lines:

[code]

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
[/code]

Create necessary directories for Oracle home

Change the entry of .bash_profile file of the oracle user and add following lines:

vi /home/oracle/.bash_profile

[code]

export ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
[/code]

Now copy downloaded oracle installation files to the /tmp directory

Switch to the /tmp directory and unzip both files with oracle user. This will create a new folder called “database”

Logout from root user, login with oracle, switch to the /tmp/database directory and run installation by running the following executable

[code]

cd /tmp/database

./runInstaller

[/code]

Select Create and configure a database and click next

Select the first option and click Next

Provide the name of the database and the password and click next

Specify the folder for the inventory directory and click Next

In the prerequisite check we was informed that we need to install three packages as well. So mount the .iso file of the OEL installation, switch to the Server folder

Install all three packages with rpm -Uvh command as it’s shown above

Click on Check Again button and you’ll see that those notifications are disappeared. Check “Ignore all” checkbox and click Next

Click Finish button to start the installation

DBCA tools automatically will start to create the database named mydb

After all, the installation finished successfully. Get the url of the database control

Open a web browser and paste that url to the address field. Click “or you can add an exception” link

Click on “Add Exception” button

Click Get Certificate and Confirm Security Exception buttons

Provide the password for sys user and password, select SYSDBA and click Login button

Switch to the installation page and run both shell scripts with root user

Open a new terminal, export ORACLE_SID variable and connect to the database

I hope by following my step by step instruction, you’ll also install Oracle 11gR2 on OEL successfully

97 Responses to “Step by Step installing Oracle 11g R2 on OEL 5.5”

  1. Ivan Kartik Says:

    Maybe I’m blind but this definitely does not look as Centos ;-)

  2. Nesimi Says:

    Thanks Kamran teacher.

  3. Kamran Agayev A. Says:

    Hi Ivan. This is OEL, as I’ve mixed .iso images of OEL and Centos and thus named vmwware machine as Centos while the installation was on OEL :) I hope there’s no big difference between installing Oracle on both OS

  4. Yogesh Twari Says:

    Bookmarked !!

    Thanks a lot.

  5. Victor Says:

    Hello again Kamran:

    Congratulations on the 11gR2 OEL tutorial! I have waited for it & now it is here. I will be spending some time here to get everything right.

    Thanks again.

  6. Victor Says:

    Karam:

    I am noticing that after you make the changes to the /etc/security/limits.conf file, in the next step you are logged in as oracle@localhost:/home/oracle & no longer root@localhost:~. After changing the /etc/security/limits.conf file, should one reboot machine and login as oracle & not as root?

  7. Kamran Agayev A. Says:

    You don’t need to reboot. You can change the user to using “su – oracle” and continue the installation

  8. fritz Says:

    when i connect with ssh to the server, the ulimits are not set correctly, only when doing a “su”.
    i’ve set limits.conf, checked, pam config, and sshd_config, everything looks fine. so, whats wrong?
    thx

  9. Kamran Agayev A. Says:

    Dear Fritz
    To change those configurations you need to connect to the server with a root user

  10. Iss Says:

    Hello Kamran,

    Once again a remarkable job. I have learned a lot from your tutorials. its very easy to follow and very precise. keep up the good work

    thanks

  11. Victor Says:

    Hello Karam:

    I am at the final step of this installation, and everything has worked perfectly up to this last step, including OEM.

    After I open a new terminal, export ORACLE_SID variable and connect to the database:

    [oracle@localhost ~]$ sqlplus / as sysdba
    bash: sqlplus: command not found

    Contents of my .bash_profile file:

    PATH=$PATH:$HOME/bin

    export PATH
    export ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
    export PATH=$ORACLE_HOME/bin:$PATH

    I also changed this to:

    PATH=$PATH:$HOME/bin

    export PATH
    export ORACLE_HOME=/u01/home/oracle/product/11.2.0/dbhome_1
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
    export PATH=$ORACLE_HOME/bin:$PATH

    After I got the “bash: sqlplus: command not found” message in terminal, & got the identical message again.

    My software location is: /u01/app/oracle/product/11.2.0/dbhome_1

    I executed the following configuration scripts as root user:

    /u01/app/oraInventory/orainstRoot.sh
    /u01/home/oracle/product/11.2.0/dbhome_1/root.sh

    Where did I go wrong?

    Regards

  12. Victor Says:

    **UPDATE**

    Created a second installation successfully.

    USED: Oracle VM VirtualBox 4.06
    Oracle Enterprise Linux 5.6
    Oracle 11gR2

  13. santosh Says:

    Hi Kamran,

    Thanks much for detailed explanation, I didn’t find the OEL in ISO image format to download on edelivery.oracle.com site, where can I donload ISO image for OEL ?

    Also is there anyway to install from OEL from Zipfiles (disks) which I downlaoded to my laptop ( not burned to CD’s )

    Please guide me.

    Thanks

  14. Kamran Agayev A. Says:

    Dear Santosh

    Check the following link to download OEL :
    https://edelivery.oracle.com/linux

    Moreover, install Vmware as I’ve shown and mount the downloaded .ISO file to the vmware. In that case you don’t need to burn it

    Good Luck!

  15. sai Says:

    Hi Kamran,

    I have unzipped both the zip folders of 11gr2 software into single folder database.
    When I am trying to install the Oracle Software I am getting the following error

    Unable to find the file
    /u01/app/oracle/product/11.2.0/db_1/owb/external/oc4j_applications/applications/WFALSNRSVCApp.ear

    Can you please guide me how to solve this issue.

    Thanking you in advance

    Regards,
    Sai

  16. Kamran Agayev A. Says:

    Dear Sai
    Check the following link:
    http://forums.oracle.com/forums/thread.jspa?threadID=971703

  17. Kamran Agayev A. Says:

    Hi Saj
    This is because you didn’t extract both zip files under the same directory. Check it again and let me know

  18. ST Says:

    Dear Kamran,

    I agree with most people who posted here. Your tutorial is precise and easy to follow. thanks for sharing the knowledge.

    We have CentOS4.8 running in a VM. I have installed Oracle 10g (10.2.0.1.0) on this Linux CentOS4.8 virtual machine following your “Oracle 10g install guide on CentOS”. It worked beautifully.

    Now, On the same box, I just installed Oracle 11g (11.2.0.2.0) following this guide you wrote. In the end, it says “Oracle has been installed successfully”. However, when I tried to start the EMConsole, I did

    emctl start dbconsole
    OC4J Configuration issue. /opt/oracle/oraclehome_112/db_1/oc4j/j2ee/OC4J_DBConsole_myhostname_p not found.

    where p is the instance name.

    and this directory, OC4J_DBConsole_myhostname_p, does not exist on the file system.

    My setup:
    Oracle 10g resides in its oracle_home, which is different from 11g’s oracle_home.
    When installing 11g, I have chosen the option “Create the startup database” and I have created same database (instance = p), running on the same port 1521 (as the instance installed under 10g); however,
    during my install of 11g, I did shutdown oracle 10g completely (including the listener, sqlplus and EM console).

    for 11g, I can

    sqlplus /nolog
    SQL>conn / as sysdba;
    SQL>startup;
    SQL>select status from v$instance;
    OPEN
    SQL>select * from v$version;
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production

    listener is up and running. The only thing that fails is that Enterprise Manager could not be started.

    Do you off the top of your head know what might be causing my issue?
    Any pointers would be greatly appreciated.

    thanks,
    ST

  19. ST Says:

    Kamran,

    Don’t worry about it. I resolved it.

    I did

    ./emca -deconfig dbcontrol db -repos drop

    ./emca -config dbcontrol db -repos create

    then, I could start dbconsole fine.

    thanks
    ST

  20. Neeraj Vasudeva Says:

    Nice tutorial, overall looks like not much changed from 10g installation to 11g… except for some minor changes. Overall good job, though would recommend a small thing.. may be u can type the instruction above the screenshot, instead of typing it below screenshot.

  21. Kamran Agayev A. Says:

    Dear Neeraj, thank you for the feedback!

  22. yunussYunus SIMSEK Says:

    Dear Kamran,

    Thank you for this priceless tutorial, I have successfully installed both OEL 5 and Oracle 11gR2 into Oracle Virtualbox., but my question is how am I gonna make Oracle 2 start atomically with Linux.
    because last time I restart to my system and I couldn’t started Oracle database.

    Thank you again.

  23. Kamran Agayev A. Says:

    Dear Yunus, check my following blog post and replace commas when you copy/paste the code from wordpress:
    http://kamranagayev.wordpress.com/2008/12/22/automatically-startup-and-shutdown-database-in-linux-os/

  24. Paracha Says:

    Xelent

  25. Zayad Says:

    Thanks Kamran for installation steps it was helpful I am getting some package related error can you let me know from where can I download the package and steps to apply them as i am completely new to linux environment I am installing it on Oracle Enterprise Linux.Pls see below package error

    Checking for sysstat-7.0.0; Not found. Failed <<<<
    Checking for compat-libstdc++-33-3.2.3; found compat-libstdc++-33-3.2.3-61-i386. Passed
    Checking for libgcc-4.1.1; found libgcc-4.1.2-48.el5-i386. Passed
    Checking for libstdc++-devel-4.1.1; found libstdc++-devel-4.1.2-48.el5-i386. Passed
    Checking for unixODBC-2.2.11; Not found. Failed <<<<
    Checking for unixODBC-devel-2.2.11; Not found. Failed <<<<
    Check complete. The overall result of this check is: Failed <<<<
    Problem: Some packages required for the Oracle Database 11g to function properly are missing (see above).
    Recommendation: Install the required packages before continuing with the installation.

  26. Zayad Says:

    I have resolved it no need to reply

    Thanks Kamran for your steps in installation

  27. Zayad Says:

    Hello Kamran,
    I am unable to resolve the below error for last 2 days can you pls help

    Error

    Checking Network Configuration requirements …
    Check complete. The overall result of this check is: Not executed <<<<
    Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses. However, the primary network interface on the system should be configured with a static IP address in order for the Oracle Software to function properly. See the Installation Guide for more details on installing the software on systems configured with DHCP.“

    My etc\hosts file is
    127.0.0.1 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6
    192.168.0.1 localhost.localdomain localhost

    network-scripts\etho

    DEVICE=eth0
    BOOTPROTO=none
    HWADDR=00:1E:0B:C8:24:78
    ONBOOT=yes
    TYPE=Ethernet
    NETMASK=255.255.255.0
    IPADDR=192.168.0.1
    USERCTL=no
    PEERDNS=yes
    GATEWAY=255.255.255.0
    IPV6INIT=no

    Pls help

  28. Manuel Cantú Reinhard Says:

    Great!

  29. Yousef Says:

    Hi kamran
    i tried to run the code:

    . / runInstaller

    but I couldn’t
    it says permission denied.
    Thanks

  30. Kamran Agayev A. Says:

    It seems you’ve unzipped the installation with root user. Change the owner of the whole installation folder to oracle and run the installation again

    chown -R oracle:oinstall

  31. Tushar Kanti Says:

    Thanks a lot Kamran. I’m really new to Oracle and I had attempted 6 times to install oracle but your step by step install of 11G really helped a lot.

  32. ndah Says:

    After installation, I try to use sqlplus and I receive this message

    [oracle@localhost ~]$ export ORACLE_SID=orcl
    [oracle@localhost ~]$ sqlplus / as sysdba
    bash: sqlplus: command not found

    Help me to resolve this problem

  33. Kamran Agayev A. Says:

    Hi

    You need to export PATH correctly. Check the following command:
    export PATH=$ORACLE_HOME/bin:$PATH

  34. Saber Says:

    Thank you so much Mr. Kamran for your efforts causing very helpful document not only for learners but also equally helpful for on job consultants etc..

    I need to upgrade oracle 10.2.0.1 to 11.2.0.1
    Please help me the document as well as the images .. On SunOS
    Thanks in advance.

  35. Kamran Agayev's Oracle Blog » Blog Archive » Step by Step Oracle installation All in One e-book Says:

    [...] 3. Step by Step installing Oracle 11g R2 on OEL 5.5 [...]

  36. Yair Finish Says:

    hi,
    Im intend to install oracle Grid Control-11 and start with DB installation as describe in this artical.
    however, i wonder what else required to complete the installation. do u additional articals for the rest of installation?

    yair F

  37. Yair Finish Says:

    Kamran,
    i cant execuet the command sqlplus / as sysdba
    i got like the guys complained above.

    [oracle@HodVipGC ~]$ sqlplus / as sysdba
    -bash: sqlplus: command not found
    [oracle@HodVipGC ~]$

    i have checked the ./bash_profile and it seems to be ok.

  38. Kamran Agayev A. Says:

    This installation steps are for Oracle 10g Grid Control, so please refer to the documentation for additional steps

  39. Kamran Agayev A. Says:

    Check PATH environment variable. It should contain $ORACLE_HOME/bin

  40. Vivek Says:

    I am installing Oracle 5.7 on Oracle Virtualbox, not able to find sysconfig.conf mentioned in below step.

    “Change the /etc/sysconfig.conf file to add (change) kernel parameters that are required for Oracle installation”

    Is this sysctl.conf?

    -Vivek

  41. Kamran Agayev A. Says:

    Yes, it should be /etc/sysctl.conf

  42. Dominik Says:

    Everything works fine at first time. After Centos reboot I cannot start em and cannot connect to database via sqlplus. I obtain information that myhostname_p not found.
    How to start emca?

  43. Vivek Says:

    Kamran,

    I am installing Oracle 11gr2 on oracle linux 5.7 (oracle virtualbox) getting below problem, i tried several solutions provided on internet but nothing worked

    Please help…

    oracle@localhost database]$ ./runInstaller
    Starting Oracle Universal Installer…

    Checking Temp space: must be greater than 120 MB. Actual 15603 MB Passed
    Checking swap space: must be greater than 150 MB. Actual 5951 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/OraInstall2011-12-13_10-24-29AM. Please wait …[oracle@localhost database]$ Exception in thread “main” java.lang.NoClassDefFoundError
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:164)
    at java.awt.Toolkit$2.run(Toolkit.java:821)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
    at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source)
    at com.jgoodies.looks.LookUtils.(Unknown Source)
    at com.jgoodies.looks.plastic.PlasticLookAndFeel.(PlasticLookAndFeel.java:122)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:242)
    at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783)
    at javax.swing.UIManager.setLookAndFeel(UIManager.java:480)
    at oracle.install.commons.util.Application.startup(Application.java:758)
    at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
    at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
    at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
    at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
    at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

  44. cedric Says:

    Kamran,

    The initial installation worked fine but when I rebooted my box I lost the connection or something. Now when I enter sqlplus / as sysdba I receive this error. ORA-12162: TNS:net service name is incorrectly specified
    I was able to get it working but loose it every time I reboot. How can I fix the problem and correct it so I will not loose the information

  45. Kamran Agayev A. Says:

    If you want the database to be started when the system is up, check the following link:
    http://kamranagayev.com/2008/12/22/automatically-startup-and-shutdown-database-in-linux-os/

  46. Kamran Agayev A. Says:

    Hi Dominik
    You need to set ORACLE_SID and ORACLE_HOME environment variables to make EM run

  47. Yalesh Says:

    Great I installed Successfully without any error
    but my EM not yet started
    and my URL is at the end of installation is
    https://localhost.localdomain:1158/em

    How can I get my EM?

  48. Kamran Agayev A. Says:

    Make sure you’ve set ORACLE_SID environment variable correclty, restart the listener and start OEM again

  49. Samir Aliyev Says:

    Salam Aleykum.

    Kamran bey, tewekkurler. )

  50. zns Says:

    I am almost beginner in this area – need some help. I have installed Oracle Linux 5.2 on my Windows 7 machine. I have configured as per your steps; so far it is okay. I hope Enterprise Linux dvd 20100405 contains 2 zip files of Oracle Linux versions. My problem is that I cannot connect Internet to download these files in the VM. I have downloaded them in the Windows 7 machine but not sure how to trandfer to VM and go farther.

    Thanks in Advance.

  51. Isidoro Says:

    Hi, Kamran,

    Sucessfully my 11gR2 installed. Thanks for the manual.

    Thanks.

  52. sameer Says:

    Hi all

    please help me … when apply this command emctl startup show this message.

    EM Configuration issue ./u01/home/oracle/product/11.2.0/db_1/localhost.localdomain_mydb not found

    consequently the database control is not open bus sqlplus is very good work,

    please help me to solve it .

    thx

  53. Kamran Agayev A. Says:

    If you’ve installed VMWare tools, then you can drag and drop any file from local PC to vmware and vice verse

  54. Kamran Agayev A. Says:

    If you haven’t changed ip address or hostname, then try to recreate the EM

  55. sameer Says:

    plz how i can check that ip address and hostname ; and you mean from VMwaer or /etc/hosts file ,

    Thanks in advance.

  56. Vijay Says:

    Hi,
    I want to know the required softwares.

    Please check the below softwares, I have downloaded.
    Virtual machine

    1. VMware-server-2.0.2-203138.exe
    VMware Server 2 for Windows Operating Systems.
    A master installer file containing all Windows components of VMware Server.
    MD5SUM(¹) a6430bcc16ff7b3a29bb8da1704fc38a
    SHA1SUM(¹) 39683e7333732cf879ff0b34f66e693dde0e340b

    OR

    1. Oracle VM
    x86 64 bit
    Oracle VM 3.0.3 Media Pack for x86_64 (64 bit)

    OEL

    2. https://edelivery.oracle.com/linux
    oracle Linux
    x86 64 bit
    Oracle Linux Release 5 Update 7 Media Pack for x86_64 (64 bit) 2/6.5G

    Database

    3. Oracle 11g R2

  57. sameer Says:

    I’m waiting you Mr. kamran

  58. Ameeta Says:

    Thanks a lot for the detailed and clear step-by-step instructions. Finally after about 10+ items I was successfully able to install Oracle 11g.

  59. Kamran Agayev A. Says:

    Congratulations!

  60. Shashank Says:

    Hi kamran,
    I appreciate your work and Thanks a lot for such a detailed doc.I have a question for u,and the question is why its not prompting to enable archiving mode and selection of SGA size…while installing?

  61. Kamran Agayev A. Says:

    It has to ask you if you’ve checked “Database-General” option when creating the database

  62. Shashank Says:

    Got it Kamran.Thank you.

  63. hari Says:

    why am i getting permission denied when i execute /etc/pam.d/login

  64. Praveen Says:

    Awesome!!!. Worked like a magic. Thank you for your time.

  65. raghu Says:

    Ignoring required pre-requisite failures. Continuing…
    Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-03-24_02-41-15AM. Please wait …
    Invalid source path ‘../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles’ specified for unzip. Unzip command failed. Please check oraparam.ini and specify a valid source path.
    : No such file or directory

    this is my problem please help me

  66. Kamran Agayev A. Says:

    Check the following link:
    https://forums.oracle.com/forums/thread.jspa?threadID=954055

  67. redoxi Says:

    Hi;
    I want to thank you for this tutorial and explanation of this wonderful way of installing Oracle 11gR2 on CentOS.
    you really help me.
    thank you again.
    ;)

  68. redoxi Says:

    hello;
    after installing Oracle 11gR2 successfully under centos, I reboot my laptop and I find that the url: http://localhost:1158/em does not work. But, I can access in SQL mode.
    kamran help me sir if you like me;
    and thank you in advance.

  69. Kamran Agayev A. Says:

    For this, you need to start the Enterprise Manager
    emctl start dbconsole

  70. Jonny Says:

    Hi Kamran
    i can’t access https://localhost:1158/em
    i also run command: emctl start dbconsole but “bash: emctl: command not found”
    can u advise me ?

  71. Kamran Agayev A. Says:

    Hi Jonny
    You need to switch to the $ORACLE_HOME/bin directory and run
    ./emctl start dbconsole

  72. Jonny Says:

    Hi Kamran
    thank you for your reply, i already switch to $ORACLE_HOME/bin = /u01/home/oracle/product/11.2.0/db_1/ and run emctl start dbconsole but still got error: -bash: emctl: command not found
    can you advices me more
    Thank you very much !

  73. Mahesha Says:

    I have installed oracle 11g on centos.But when I run sqlplus / as sysdba. The following error message displays
    bash:sqlplus:comand not found
    What is the solution for this

    Thank you.

  74. vinod Says:

    Hi kamaran,
    i red your document Install Oracle 11g Release 2 on OEL 5.5.
    its good and easy to do install oracle 11g database. i would like to
    know more from you. Could you explain the installation procedure
    withour using runinstaller file i.e, using command line without
    graphical mode.

  75. Kamran Agayev A. Says:

    Hi

    I’m currently working on the different kind of video tutorials. You can try different installation types by your own

    Thanks

  76. Kamran Agayev A. Says:

    You need to make sure your PATH environment variable is set correctly
    export ORACLE_HOME=/….(export HOME variable)
    export PATH=$ORACLE_HOME/bin:$PATH
    sqlplus / as sysdba

  77. Jonny Says:

    Hi Kamran
    with my .bash_profile, can you check for me if it’s wrong?

    vi /home/oracle/.bash_profile
    export ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
    export PATH=$ORACLE_HOME/bin:$PATH

    i already switch to $ORACLE_HOME and run emctl start dbconsole but still error: -bash: emctl: command not found then can’t start web console via https://localhost:1158/em
    Can u advise me about this ?
    Thank you !

  78. Kamran Agayev A. Says:

    Could you please post output of the following commands?

    cd $ORACLE_HOME
    pwd

  79. Jonny Says:

    Hi Kamran
    Thank you for your reply.
    This is output of command:
    /root

    pls advices me more.
    Thank you very much !

  80. Jonny Says:

    I also switch to oracle user and run follow command and this is output:
    /u01/home/oracle/product/11.2.0/db_1

  81. Pankaj Soni Says:

    I would like to really appreciate your tutorial.
    I am getting few issues in my oracle configuration:
    1) I am not able to access the em outside the virtual system i.e. em only opens in virtual system from https://localhost:1158/em and https://192.168.0.50:1158/em
    when I try to open https://192.168.0.50:1158/em from physical host, it gives 404 page not found error.
    My network connectivity is fine as I usually connects to the virtual system from putty.
    2) same type of issue while connecting to database via sql developer from physical system.

    Details of environment:
    virtual box used
    host os: win 7 x64
    linux: OEL x64
    oracle: 11g r2 x64
    Thanks in advance…

    Let me know if you need more information to address the issue

  82. Kamran Agayev A. Says:

    Can you ping the virtual box from the outside. In Vmware, you need to set the Network Device to be “Host-only” in order to be able to access it from outside

  83. Mehmet Bayram Says:

    Hi Kamran,

    very useful document.

    thank you for helping !

  84. Web Development Says:

    You have given it in very simple steps. I was getting error due to not copying disk 2 files in disk 1.
    Thanks,

  85. Elvin Says:

    Slm Kamran bey.
    Dedikleriniz eyni ile edirem mma installation zamani error verir ,95 % catanda [INS-20802] Oracle Net Configuration Assistant failed. errorunu verir.

    log fileda ise bu melumatlar var .
    Oracle Net Services Configuration:
    INFO: #
    INFO: # An unexpected error has been detected by HotSpot Virtual Machine:
    INFO: #
    INFO: # SIGSEGV (0xb) at pc=0xa45ab498, pid=12077, tid=3086346448
    INFO: #
    INFO: # Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
    INFO: # Problematic frame:
    INFO: # C [libnnz11.so+0x3c498]
    INFO: #
    INFO: # An error report file with more information is saved as hs_err_pid12077.log
    INFO: #
    INFO: # If you would like to submit a bug report, please visit:
    INFO: # http://java.sun.com/webapps/bugreport/crash.jsp
    INFO: #
    WARNING: /u01/app/oracle/product/11.2.0/dbhome_2/bin/netca: line 178: 12077 Aborted $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $*
    INFO:
    WARNING:
    INFO: Completed Plugin named: Oracle Net Configuration Assistant

  86. viswa Says:

    Hi Kamran,

    I am able to install the oracle 11g R2 on vmware centos 6.3, with nat network adapter,
    I have configured the port forwarding settings, but i am unable to access oracle from host.

    Are there are setting i have configure in host.
    thanks in advance

    Regards,
    Viswanath Etikala

  87. Kamran Agayev A. Says:

    Hi Viswanath
    You need to activate the ethernet device from OS. Type system-config-network and activate the first device, get the ip using /sbin/ifconfig and connect from the host

  88. Kamran Agayev A. Says:

    Salam Elvin
    Boyuk ehtimal hansisa lib faylin qurmamisan. Installation-i normal bitirib netca-ni sonra da calisdira bilersen. Ve eslinde local host-da db-ye qosulmaq ucun listener ve tns-e ehtiyac yoxdur

    Uqurlar

  89. sushil_sk Says:

    Kamran Sir

    I had follwed this installation procdedure. With the mentioned confign.
    My host system is Acer 64 bit Windows 7., And 4GB RAM.
    I am using VMWARE wks 8. I have installed OEL 5.5 and 11g .R2. Linux
    My prblem is that my DBCA and NETCA confiuration shows failed. So i m not able to create the database.
    Kindly suggest.

  90. Kamran Agayev A. Says:

    And what error you get?

  91. sushil k Says:

    Installation done successfully Sir. The error was installation process comes till 99% and hangs , it was happening due to 64bit OEL , 64 bit Host system and 32 bit Oracle. ITs resolved now thank you

  92. Habib Says:

    Excellent tutorial, and by the everything let’s say that that work smoothly.

    Could you add or reference me to a tutorial where I can install SQLdeveloper tool without any drawback. Here is my issue, after following your tutorial, I installed sqldeveloper on Centos, tutorial found: http://dba010.wordpress.com/2011/07/25/install-sql-developer-on-centos-5/#comment-243

    And sqldeveloper works fine now, BUT, I have encountered that now my whole database engine is down?.
    1. I type on the shell dbca it returns me command not found.
    2. Go to https://localhost.localdomain:1158/em/ the entreprise manager is down too.

    Some tips, any help?…..I am newbie..:-(

    Best regards and thanks in advance,
    Habib

  93. Habib Says:

    Hello Mr. Kamran,

    I appreciate the fact that you took some of your time in order share your knowledge with the rest of us. I have installed a few times Oracle DB w/ Centos 5.8 and went successfully, on top of it, I followed your your steps posted here in your site, it went smooth as well, on Oracle 5.5, as per your screenshot posted here, with only one exception:

    When I type sqlplus /nolog , is returning Command not found, plus is odd because the db is up, I can see http://localhost:1158/em, it’s up, but I really need to use the command line.

    PD: I followed up strictly your steps……any extra suggestion for the PATH as I know this is the issue.

    Best regards,
    Habib

  94. Habib Says:

    Update!!

    I fixed the variables.

    Regards,
    Habib

  95. SankarG Says:

    Thanks…………..

  96. noaman Says:

    Dear kamran,

    I want to access Em but 404 page not found error come after enter succussfully emctl start dbconsole command from linux 5.3, browser open lnxdb.localhost:1158/em and when I press open application server than appear this message 404 error come with new brwser screen. other proble is that my network ping itself is ok but other network not ping even DNS and default gateway given. please resolve this issue

  97. Kamran Agayev A. Says:

    Could you please try to start EM using emctl start dbconsole command?

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=""> <strike> <strong>