7 Replies Latest reply: Sep 20, 2013 7:10 AM by EdStevens RSS

    Installing Oracle 11gR2 on Linux over existing XE installation

    user13021053

      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

          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

            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

              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

                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

                  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

                    >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

                      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.