Oracle 18c was the first database released in the Oracle Cloud Infrastructure (OCI), and the server on-premises version became available several months later. Of course, you can use the supported versions of the Oracle Database back to 12c depending on the virtual machine shape that is chosen. Oracle provides a couple of different options forRead More
Category: Oracle Certification and Database
The last step before the installation starts using the GUI installer is to save the response file. The arrow in Figure 1-10 points to the button to save the response file. After reviewing everything that was configured by walking through the installation screens, click this button before clicking the Install button. Figure 1–10. Saving theRead More
For the database installation, the ./runInstaller command is executed and provides similar screens to walk through with groups and configurations. The database response file can be found and edited as shown in the example. Here is the database home: $ cd /u01/db23c/install/response $ vi db_install.rsp Here is an example of the values to provide forRead More
Here are some of the steps for the graphical installation. Figure 1-5 shows the configuration options for the Oracle Grid Infrastructure installation. Figure1-5.Oracle Grid Infrastructure installation options Figure 1-6 shows the ASM disk groups and the discovery path of the raw devices. Figure 1–6. Oracle Grid installation ASM disks After a few more steps ofRead More
The Oracle Grid Infrastructure needs to be installed before the database software to use ASM for the database. The file system can be used for the database without using ASM, but there are several advantages to using ASM, and you need to just present raw disks such as /dev/sdx for the installation. The disk groupsRead More
Usually, the easiest way to obtain the Oracle software is to download it from the Oracle website (oracle.com/downloads). Make sure you download the correct versions for the OS you want to install it on. If you are working with Linux systems, you can just install with yum and the RPM package. $ yum -y installRead More
The tasks associated with this step vary somewhat for each database release and OS. You must refer to the Oracle installation manual for the database release and OS vendor to get the exact requirements. Another excellent tool here is the pre-installation checklist and the installer itself, as it does a verification and helps fix issuesRead More
If you work in a company with a system administrator (SA), then steps 1 and 2 are usually performed by the SA. If you don’t have a SA, then you have to perform these steps yourself (this is often the case in small companies, where you may be required to perform many different job functions).Read More
Suppose you are new on the job and your manager asks you how long it will take to install a new set of Oracle Database 23c software on a server. You reply that it will take less than an hour. Your boss is incredulous and states that previous DBAs always estimated at least a dayRead More
Some Oracle utilities use the value TNS_ADMIN to locate network configuration files. This directory is defined as ORACLE_HOME/network/admin. It typically contains tnsnames. ora, listener.ora, and sqlnet.ora Oracle Net files. The listener.ora files are now typically with the Oracle grid installation and not in the database home. The listeners are normally maintained by the system thatRead More