1 person found this helpful
On my lab system I have XE, SE and Oracle DBMS (+GI) working without any issues. In different homes of course.
ps -elf | grep -i pmon | grep -v grep
0 S grid 3434 1 0 80 0 - 124982 poll_s 10:33 ? 00:00:00 asm_pmon_+ASM
0 S oracle 3654 1 0 80 0 - 454628 poll_s 10:33 ? 00:00:00 ora_pmon_TEST
0 S oracle 8240 1 0 80 0 - 316502 poll_s 10:53 ? 00:00:00 xe_pmon_XE
0 S oracle 9820 1 0 80 0 - 58585 poll_s 11:07 ? 00:00:00 ora_pmon_abc
select * from v$version;
Oracle Database 11g Express Edition Release 18.104.22.168.0 - 64bit Production
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
Oracle Database 11g Release 126.96.36.199.0 - 64bit Production
Thank you. I was reasonably sure it was possible, but it's good to know for certain. Beyond the obvious (different homes and ports), are there any pitfalls to watch out for during the install? The one hit I got from Google suggested installing XE first. This makes sense as the installation of XE is not particularly configurable.
1 person found this helpful
Maintaining different versions or editions is a matter of putting each installation in it's own ORACLE_HOME, as usual. However, OS release 7 is very different from previous releases and this is not just about systemd and grub2. If you are not familiar with release 7, but know previous OS versions, get ready to Google what happened to all the tools you knew. There is no OS upgrade path, so you will have to install everything from scratch.
How are you planning to migrate the existing installation to the new server? If you are looking for a certified installation you require Oracle 188.8.131.52 or later. If this is a same platform installation as your previous install you can simply copy the database data files or use RMAN to restore the database.
Regarding the software installation, there are plenty of pitfalls. Your easiest option to get this done right is to use the oracle-rdbms-server-11gr2-preinstall package that ships with Oracle Linux. If you can, I suggest to use Oracle Linux instead of RHEL. The 11gR2 preinstall package from Oracle requires the Oracle UEK kernel due to software dependencies.
The 11gR2 XE installer under RHEL or OL 7 will fail for various reasons. The installation is not even compatible with the XFS file system. There are a number of other issues that will need to be addressed too. Instructions you can find on the web to install XE under RHEL or OL 7 don't work. It is possible, but you need the right instructions. Coincidentally, I have been busy testing and writing an XE installation guide for OL 7 and it's nearly finished. I might be able to post the URL in several days.
Btw, have you considered running your previous environment in a virtual machine? You could, for example, convert your existing hard drives to virtual disks and the use the complete previous system in VirtualBox. Perhaps not a bad idea to get you working on the new system as quickly and painless as possible. The following might give you some idea how this can be done How To Convert a Linux System Disk to VirtualBox in Mac OS X .
...There is no OS upgrade path, so you will have to install everything from scratch.
...How are you planning to migrate the existing installation to the new server?
I'll be installing everything from scratch. Much of my current setup is dated. In particular my version of Tomcat is very old, my ORDS version is dated and I haven't upgraded Application Express to the 5.1 release. As for the Oracle database, I'll be using expdp and impdp to pull the data over because I want to do some reorganization during the transfer.
If you can, I suggest to use Oracle Linux instead of RHEL.
Wish I could. The hosting company (Rackspace) does not offer Oracle Linux as an option -- I specifically requested it.
...The 11gR2 XE installer under RHEL or OL 7 will fail for various reasons.
...I might be able to post the URL in several days.
The first part bites. The second I'd be very interested in.
Btw, have you considered running your previous environment in a virtual machine?
Not feasible, unfortunately. We own a perpetual license for Oracle 11g SE1 which can only be used on a two-CPU system. I'm sure you're aware of Oracle's draconian rules about virtual servers and CPU counts. To prevent any possibility of being caught out on an audit, this is being installed on a bare-metal 2-CPU system. I could VMs on this system, but doing so would add complexity and overhead without providing significant benefits.
In any event, I don't want to bring over my current system unchanged. The current setup has a number of minor (but annoying) problems beyond the versioning ones noted above. Our current hosting company insisted on installing all of the software themselves (i.e. so that they could charge man-hours for the installation) and frankly they didn't do a great job of it. It functions, but has some quirks that I'd just as soon get rid of during this evolution.
XE "particulars" (11.2 on OL6.8).
1. Should be installed by root (sudo) as it is rpm (or transform rpm to "source", copy to necessary directory or install from source).
2. Installs into Requires /u01/app/oracle by default (creates this directory while rpm2cpio).
3. dba ownership for /u01/app/oracle (could be temporary changed with "chown oracle:dba /u01/app/oracle" and returned back after installation).
4. Creates DB in /u01/app/oracle/oradata/XE with name ORCL by default.
5. Started by /etc/init.d/oracle-xe
I installed XE 184.108.40.206 on OL 7 without any problems.
VBox. OL 7.2 updated to 7.3. oracle-xe-11.2.0-1.0.x86_64.rpm.zip.
uname -a Linux ol7-01.test.com 4.1.12-61.1.25.el7uek.x86_64 #2 SMP Wed Jan 11 19:01:23 PST 2017 x86_64 x86_64 x86_64 GNU/Linux
cat /etc/oracle-release Oracle Linux Server release 7.3
ps -elf | grep -i pmon | grep -v grep 0 S oracle 11875 1 0 80 0 - 322056 poll_s 14:43 ? 00:00:00 xe_pmon_XE
ps -elf | grep -i listener | grep -v grep 0 S oracle 4632 1 0 80 0 - 59375 poll_s 14:41 ? 00:00:00 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
findmnt -l / TARGET SOURCE FSTYPE OPTIONS / /dev/mapper/ol-root xfs rw,relatime,seclabel,attr2,inode64,noquota
select * from v$version;
BANNER -------------------------------------------------------------------------------- Oracle Database 11g Express Edition Release 220.127.116.11.0 - 64bit Production PL/SQL Release 18.104.22.168.0 - Production CORE 22.214.171.124.0 Production TNS for Linux: Version 126.96.36.199.0 - Production NLSRTL Version 188.8.131.52.0 - Production
When I installed XE 11gR2 under OL 7.3 the installation would constantly fail, showing the following in the database alert.log:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-19502: write error on file "/u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_3_%u_.log",
block number 1 (block size=512)
ORA-27072: File I/O error
I don't know what exactly caused the issue, but the problem went away when not using an XFS filesystem.
I've seen some reports that the XE installation, when running the configure part, which clones the XE database, fails under OS release 7.
There are also a number of other things that don't work properly and need to be addressed:
/var/tmp/rpm-tmp.E80bPL: line 78: [: -gt: unary operator expected
/var/tmp/rpm-tmp.E80bPL: line 82: bc: command not found
/var/tmp/rpm-tmp.DdAH1W: line 257: [: 18446744073692774399: integer expression expected
Again, I don't know the cause for the ORA-27072: File I/O error - it's not the available disks space. The problem happens sometimes. I guess the question is compatibility with 184.108.40.206 and XFS. Support for XFS started with OS release 7, which is certified starting with 220.127.116.11.
Before installation I updated OS. Could be an issue with kernel version as my installation was under the most recent.
I certainly tried the last available update. The problem occured in any kernel, RHCK, UEK3 and UEK4. In my opinion, XFS compatibility of XE is questionable. Again, it may or may not work and I have not been able to figure out the circumstances so far.