Resilient Oracle PL/SQL

Appendix A. Troubleshooting a Native Oracle Installation

This appendix is included to assist readers who have a native Oracle Database installation rather than one installed as a Docker container.

As I began to write the book, I opted for a native installation of Oracle Database on Windows 10. After a while, I had the usual Windows updates applied to the machine. The result was that the Oracle installation started to exhibit errors. So, rather than do battle with Windows, I preferred to move over to a more forgiving environment. This was the reason for hosting the Oracle Database in a Docker container.

I realize not all readers will have the luxury of such an installation and they may have to use a native approach. I hope the following content is of some assistance.

Installation Procedure

As you may be using different platforms, it’s probably best to use some of the web-based resources for installing Oracle, such as Oracle Tutorial or Oracle-Base.

We’ll start using the installation shortly. First, let’s briefly go over some important Oracle terminology.

Container Versus Pluggable Databases

The notions of container and pluggable databases are very important in coming to grips with Oracle Database technology. A container database is what is called the ROOT container. A pluggable database is stored within the container database. A container database can contain one or more pluggable databases.

Let’s start up the mighty SQL Developer product and you should see something like Figure A-1 ...