Category Oracle

This post describes how to setup Oracle Grid Infrastructure 19c (Oracle ASM and Oracle Restart) and Oracle Database 19c including a Database orcl on RHEL 8 running as a Oracle VirtualBox guest on Windows.

Read More

This post covers some basic tasks regarding Oracle Standby Databases that can pop up from time to time. The tasks are based on a already existing primary/standby database configuration with Oracle Data Guard Broker. The steps used to setup such a configuration are described here.

Read More

It is considered good practice to delete unneeded patches from an ORACLE_HOME in order to save space and reduce the time to install new patches. I made some tests to see the effects of that. More information about the removal of inactive patches can be found in Oracle Doc ID 2942102.1 .

Read More

The following steps can be used to setup a Oracle Physical Standby Database managed by Oracle Data Guard Broker. The software versions are: Oracle GI (Oracle Restart) and DB 19.25 and RHEL 8.10. You need to setup both nodes as described here. Afterwards patch it with RU 19.25 as described here. Delete the orcl database on the second node (see here).

Read More

This post shows the mTLS setup using orapki for the encryption of database connections. Self signed certificates created by orapki and stored in a Oracle Wallet will be used on the db server and on the client machine.

Read More