Oracle 18c Express Edition (XE) comes with a container database as default database. Up to 3 pluggable databases are free so XE is a good start for getting familiar with the Multitenant architecture. However, you can still run a Non-Container-Database with Oracle 18c XE. You can simply use the Database Configuration Assistant (dbca) to create such a database.
Note: I do not recommend to run Oracle 18c XE as Non-CDB. The Non-CDB-architecture is deprecated and can be desupported after Oracle 19c. 18c XE is a good choice to get started with the Multitenant architecture which has been around since 2013.
Oracle Database 10g Release 2, Oracle SQL Developer, and Oracle JDeveloper are fully certified on Mac OS X. Turn your Mac into a full-fledged development environment and deploy Xserve-based grids. Oracle Database 10g Release 2, Oracle SQL Developer, and Oracle JDeveloper are fully certified on Mac OS X. Turn your Mac into a full-fledged development.
Oracle Active Session History is available from 10g onwards but it require a additional license and it is available for Enterprise Edition only. This project is a simulation of ASH based on X$ tables and client - system architecture. Jan 19, 2015 It's easy to install your own Oracle Database 'XE' Express Edition database for development. After the XE RPM is installed on Oracle Linux 5 and 6, run its simple configuration script to set up the administration passwords, the listener port (default is 1521), and whether to autostart during boot.
I’m running Oracle 18c Express Edition on my Centos 7.5 VM:
I used the script “/etc/init.d/oracle-xe-18c configure” to configure database and listener. The environment is set; listener and database are up and running:
As only one XE instance can run on an environment, I have to remove this database first. I’ll use dbca (GUI) for this step:
Here are some screenshots:
After deleting the Container database we can create a Non-Container-Database.
Let’s start dbca again:
Oracle Database 11g Express Edition For Mac
OK, we want to create a database > “Next”
Let’s switch from “Typical Configuration” to “Advanced Configuration”.
No changes on this screen, just klick “Next”
As the database instance should be named “XE”, you have to change the global database name to “XE.<yourdomain>”, or simply “XE”. The SID will automatically change to “XE”. As “Create as Container Database” is the default setting, you have to uncheck this checkbox if you want to create a Non-CDB.
Let’s change the file location to “/opt/oracle/oradata/{DB_UNIQUE_NAME}” before we continue.
No changes on this screen, just klick “Next”. (Of course, you could configure the FRA and enable Archiving, but my database runs in Noarchivelog mode).
We will use the default listener (which was configured during the creation of the CDB), so we can continue without any changes on this page.
I’m running my XE database with the maximum amount of memory allowed (2 GB), so I will not change anything on this page (and on the other tabs).
> “Next”
If you don’t want to configure Enterprise Manager Database Express then you can uncheck the checkbox. Otherwise >”Next”.
I tend to use simple passwords for my test databases, so Oracle complains. > “Yes”!
> “Next”
Let’s klick “Finish” to start the creation of the database:
After some time:
And the result is a Non-Container-Database:
Once again, I do not recommend to run 18c XE as a Non-CDB. From application point of view there is basically no difference between a PDB and a Non-CDB.
Of course, you can use DBCA not only to create a Non-CDB, but
- .. to create a database with another SID and database name
- .. a database which is completely using Oracle Managed Files (OMF)
- .. a database with a different characterset
Links:
Oracle Express Edition For Mac Os X
- Oracle database 18c XE on Oracle Technet: https://www.oracle.com/database/technologies/appdev/xe.html