This discussion is archived
7 Replies Latest reply: Sep 20, 2013 5:10 AM by EdStevens RSS

Installing Oracle 11gR2 on Linux over existing XE installation

user13021053 Newbie
Currently Being Moderated

Have anybody successfully installed 11gR2 (Enterprise Edition) over existing XE installation?

I have some problems doing this on CENTOS

  • 1. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    sb92075 Guru
    Currently Being Moderated

    user13021053 wrote:

     

    Have anybody successfully installed 11gR2 (Enterprise Edition) over existing XE installation?

    I have some problems doing this on CENTOS

     

    No Oracle version is certified on Centos.

     

    Problem Exists Between Keyboard And Chair

  • 2. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    user13021053 Newbie
    Currently Being Moderated

    I know, but XE was working fine so I hope R2 also can work. And verification result looks OK in the installation log:

     

    INFO: Architecture: This is a prerequisite condition to test whether the system has a certified architecture.

    INFO: Severity:CRITICAL

    INFO: OverallStatus:SUCCESSFUL

     

    Probably I should not bring Centos issue into consideration. Actually I'm interested in anybody installed RG2 over XE on any Linux OS.

  • 3. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    sb92075 Guru
    Currently Being Moderated

    multiple editions and/or multiple versions can easily & peacefully co-exist on the same system; just ensure separate ORACLE_HOME  exist & are maintained.

  • 4. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Care to elaborate on what "some problems" are ? What clues exist in the install log file (the name and location are documented in the Install Guide) ?

     

    As noted, Centos is not a supported distro, so any issues with the install of the software, or with the working (or not) of the software, you will have to troubleshoot on your own. Just because XE "works" does not necessarily mean that the EE edition will "work"

     

    HTH
    Srini

  • 5. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    user13021053 Newbie
    Currently Being Moderated

    This is the error when I start sqlplus:

    sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

    and that's exactly the problem: there is no such file in $ORACLE_HOME/lib

    Also I've noticed that many executable files in the $ORACLE_HOME/bin directory (including 'oracle') have 0 bytes.


    I was running installer in silent mode. Now I want to connect to Linux from my Windows machine through VNC and  try install Oracle using graphical interface. First of all I check if I can see some graphics, so I login as root and run xclock. Small window with a clock is opened, although there are 2 warnings:

    [root@CENTOS04 ~]# xclock

    Warning: Missing charsets in String to FontSet conversion

    Warning: Unable to load any usable fontset

    [root@CENTOS04 ~]#

     

    DISPLAY variable for root is as following:

    [root@CENTOS04 ~]# echo $DISPLAY

    :1.0

    [root@CENTOS04 ~]#

     

    Then I do su oracle (automatically inheriting all root's environment) and after that xclock does not work:

    bash-4.1$ xclock

    No protocol specified

    Error: Can't open display: :1.0

     

    In my /etc/sysconfig/vncservers I have these settings:

    VNCSERVERS="1:root 2:oracle"

    VNCSERVERARGS[1]="-geometry 800x600"

    VNCSERVERARGS[2]="-geometry 1920x1200"

     

    So why xclock does not work for 'oracle' user?

     



  • 6. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    sb92075 Guru
    Currently Being Moderated

    >So why xclock does not work for 'oracle' user?

    OS configuration is lacking & incomplete.

     

    You could avoid these problems by using any supported OS; like Oracle Linux which is also free

  • 7. Re: Installing Oracle 11gR2 on Linux over existing XE installation
    EdStevens Guru
    Currently Being Moderated

    user13021053 wrote:

     

    This is the error when I start sqlplus:

    sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

    and that's exactly the problem: there is no such file in $ORACLE_HOME/lib

    Also I've noticed that many executable files in the $ORACLE_HOME/bin directory (including 'oracle') have 0 bytes.


    I was running installer in silent mode. Now I want to connect to Linux from my Windows machine through VNC and  try install Oracle using graphical interface. First of all I check if I can see some graphics, so I login as root and run xclock. Small window with a clock is opened, although there are 2 warnings:

    [root@CENTOS04 ~]# xclock

    Warning: Missing charsets in String to FontSet conversion

    Warning: Unable to load any usable fontset

    [root@CENTOS04 ~]#

     

    DISPLAY variable for root is as following:

    [root@CENTOS04 ~]# echo $DISPLAY

    :1.0

    [root@CENTOS04 ~]#

     

    Then I do su oracle (automatically inheriting all root's environment) and after that xclock does not work:

    bash-4.1$ xclock

    No protocol specified

    Error: Can't open display: :1.0

     

    In my /etc/sysconfig/vncservers I have these settings:

    VNCSERVERS="1:root 2:oracle"

    VNCSERVERARGS[1]="-geometry 800x600"

    VNCSERVERARGS[2]="-geometry 1920x1200"

     

    So why xclock does not work for 'oracle' user?

     



    xclock is an x-11 application.  The output is redirected to a specified IP address and port where there is supposed to be an x-server (like Exceed or xming) process running.  Install xming on your local machine and configure your ssh client to allow x-11 port forwarding.  With port forwarding you don't have to worry about +xhost commands or setting of DISPLAY, both of which you will most likely read about if you google this issue.

     

    And don't log on as root.

     

    And use a supported OS.  There is simply no excuse not to, given the cost.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points