After seven years, the much anticipated Oracle 18c Express Edition (XE) has finally seen the light of day.
Reaction to the new version can be summed up as…
Gerald Venzl, the person we have to thank for this new and vastly improved version of XE, has already published an installation guide.
At this point you may well ask yourself that what – apart from gratuitous puppy pics and cheesy-snack-based puns – is the difference between that post and this.
Well, if you’re a long-time user of 11gXE and you’re looking to upgrade then you will find 18cXE a rather different proposition.
The introduction of Multitenant databases aside, 18cXE differs greatly from it’s predecessor in terms of it’s functional scope.
Wheras 11gXE was – broadly speaking – functionally equivalent to Oracle Standard Edition, the approach for 18cXE has been to shoe-horn in as many Enterprise Edition features as possible.
No doubt, this will leave you anxious to play with the new version. However, there are some “home comforts” that were present in the old version that you’ll need to configure yourself this time around.
What I’m going to go through is :
- Installing 18cXE on a Red Hat compatible distro (CentOS7)
- Connecting to the database and exploring the containers
- Checking the TNS Listener
- Manual and Automatic Startup and Shutdown of the database and listener
- Setting and persisting the Oracle environment variables
- Accessing Enterprise Manager Express
- Installing the HR demo application in a Pluggable Database (PDB)
- Configuring the firewall to allow remote access to Oracle
The steps documented here have been performed on a vanilla installation of CentOS7. As such, they should work pretty much unaltered for other Red Hat based distros based on or similar to Red Hat Enterprise Linux (RHEL) version 7.
Before all of that though… Continue reading