Problem
You want to install Oracle Database 19c for non-prod purposes the simplest and easiest way with minimal configuration steps
Solution
1. Complete your database server setup. For example, checkOracle Linux 8 -- Minimal Installation In a VirtualBox VM
2. Install Preinstallation RPM:
$ sudo dnf install oracle-database-preinstall-19c
Verify log file:
/var/log/oracle-database-preinstall-19c/backup/<timestamp>/orakernel.log
3. Download Database Installation RPM from https://www.oracle.com/ru/database/technologies/oracle19c-linux-downloads.html
4. Perform RPM-based software-only installation of Oracle Database 19c:
Note. Oracle Base and Oracle Home directories are preconfigured to /opt/oracle and cannot be changed. Ensure /opt/oracle path has sufficient space.
$ sudo dnf localinstall <path>/oracle-database-ee-19c-1.0-1.x86_64.rpm
Optionally install latest Release Update
5. Database creation and configuration can be controlled/performed by these scripts:
/etc/sysconfig/oracledb_ORCLCDB-19c.conf
/etc/init.d/oracledb_ORCLCDB-19c
It is advisable to keep the aforementioned scripts as templates and clone them to editable versions of specific deployment scripts, for example:
$ cd /etc/sysconfig/
$ sudo cp oracledb_ORCLCDB-19c.conf oracledb_MYCDB1-19c.conf
$ cd /etc/init.d
$ sudo cp oracledb_ORCLCDB-19c oracledb_MYCDB1-19c
$ sudo sed -i 's/ORCLCDB/MYCDB1/g' oracledb_MYCDB1-19c
Optionally, edit /etc/init.d/oracledb_MYCDB1-19c to tune the parameters passed to the DBCA utility
6. Create a new container database MYCDB1:
$ sudo /etc/init.d/oracledb_MYCDB1-19c configure
7. If Oracle Home had been previously patched or Release Update had been deployed to the Oracle Home, then modified SQL files need to be loaded into the database:
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
For reference:
- Oracle Database Install FAQ(18c & higher) : Changes,New Features(RPM Based Install & Read Only Oracle Home & Other Features) (Doc ID 2438532.1)
- 18c : Installing Oracle Database Using RPM Packages (Doc ID 2425736.1)
No comments:
Post a Comment