Category: Oracle Certification and Database

Categories
Installing in the Cloud Oracle Certification and Database Oracle Network Files Directory

Installing in the Cloud- Installing the Oracle Binaries

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

Categories
Installing in the Cloud Oracle Certification and Database Stopping the Database

Save the Response File for Additional Installations- Installing the Oracle Binaries

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

Categories
Installing in the Cloud Oracle Certification and Database The Value of Saving Time

Run the Installer for Database- Installing the Oracle Binaries

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

Categories
Oracle Certification and Database Oracle Network Files Directory Stopping the Database

Run the Installer for Grid- Installing the Oracle Binaries-2

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

Categories
Oracle Certification and Database Oracle Network Files Directory The Value of Saving Time

Run the Installer for Grid- Installing the Oracle Binaries-1

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

Categories
Database vs. Instance Installing in the Cloud Oracle Certification and Database Oracle Network Files Directory Stopping the Database The Value of Saving Time

Obtain the Oracle Installation Software- Installing the Oracle Binaries

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

Categories
Database vs. Instance Oracle Certification and Database

Ensure That the OS Is Adequately Configured- Installing the Oracle Binaries

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

Categories
Database vs. Instance Installing in the Cloud Oracle Certification and Database

Create the OS Groups and Users- Installing the Oracle Binaries

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

Categories
Database vs. Instance Oracle Certification and Database Oracle Network Files Directory

Installing Oracle- Installing the Oracle Binaries

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

Categories
Database vs. Instance Oracle Certification and Database Stopping the Database

Oracle Network Files Directory- Installing the Oracle Binaries

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