Oracle Linux 7.6 Virtualization

Download and install the software—Oracle Linux 7.6, Oracle VM VirtualBox, and Xmanager Power Suite—from the Oracle Software Delivery Cloud, then create a Linux virtual machine for Oracle Database 19c.

Create and configure a new Linux 7.6 virtual machine in VirtualBox, setting 8 GB memory, 80 GB dynamic storage, boot order, two processors, ISO attachment, and bridged networking.

Install Oracle Linux 7.6 in Oracle VM VirtualBox by configuring VM settings, selecting server with GUI, configuring network and hostname, creating root and user accounts, and completing Guest Additions.

Learn to connect an Oracle Linux 7.6 vm remotely via ssh using Xshell and PuTTY, after disabling SELinux, stopping firewalld, and enabling sshd.

Install required packages for Oracle ASM and database 19c on Oracle Linux 7.6, including ASMLib, oracleasmlib, and oracleasm-support, then configure the hosts file with a static IP and hostname.

Configure Linux kernel parameters for Oracle database installation by tuning file, kernel, and network settings, including shm, fs, and net parameters, via sysctl and limits adjustments.

Configure and persist Linux resource limits for Oracle and grid by editing /etc/security/limits.conf, setting soft and hard limits for open files, processes, stack, and memory across reboots.

Create and configure the oracle and grid users, assign primary and secondary groups, and establish the Oracle inventory group, database groups, and ASM groups for Oracle software installations.

Create Oracle directories with correct owner, group, and permissions per OFA. Configure Oracle base, home, and inventory paths, and use chmod and chown with symbolic and numeric notation.

Configure Oracle and grid user profiles on Linux, setting bash_profile with ORACLE_HOME, ORACLE_SID, PATH, ORACLE_TERM, TNS_ADMIN, and LD_LIBRARY_PATH, and manage umask and TEMP/TMPDIR.

Download the Oracle grid infrastructure 19c zip from Oracle's site, connect as the grid user, transfer the zip to the grid home directory with Xftp, and prepare for installation.

Install Oracle Grid Infrastructure 19c on Linux by extracting the zip, running gridSetup.sh, configuring a standalone server, and creating an ASM disk group with /dev/oracleasm/disks*.

Create a new disk group RECO with external redundancy using the ASM Configuration Assistant, then verify the listener and ASM instances are ready.

Upload the Oracle Database 19c software to the oracle home directory on a Linux system by downloading the 64-bit Linux zip from Oracle and transferring it via Xftp.

Install Oracle database 19c software on a Linux system by extracting the zip file, running the installer, and completing prerequisite checks for a single instance enterprise edition.

Configure and create Oracle Database 19c on Linux using the database configuration assistant, set data and recovery storage, enable archiving, configure the listener, and verify readiness.

Configure and run Oracle Enterprise Manager Database Express 19c using the web interface, troubleshoot listener access, fix grid permissions to the xdb wallet, and verify EM Express accessibility.

Unlock the hr sample user in Oracle database 19c by navigating multitenant architecture, switching from cdb to pdb, configuring tnsnames.ora, and issuing alter user hr identified by password account unlock.

Upload and install Oracle JDeveloper 12c in the Oracle home on Linux after downloading two files; fix permission with 755, then complete installation and launch JDeveloper.

Connect the hr sample user schema to Oracle JDeveloper 12c by configuring a database connection, switching to the pluggable database pdb, and verifying access to hr tables like employees.

Download Oracle SQL Developer 21.2.1 from the official site and upload it to the Linux server. Verify JDK 8, unzip the package, and run ./sqldeveloper.sh to launch.

Connect the hr user schema to Oracle SQL Developer 21.2.1 using basic and TNS methods, after switching the session to pdb, and fetch data from employees to verify the connection.

Connect to the hr user schema with SQLcl and run queries on departments and employees, then export results as csv, json, or xml using set sqlformat.

Learn to install Oracle SQL Developer Data Modeler 21.2 on Linux, and use it to create, browse, and edit logical, relational, and physical models with forward and reverse engineering.