Oracle Database Administration Workshop ( 12c and Higher)

Learn to read ls -l outputs, distinguish directories from files by the first character, and understand user, group, and others permissions with read/write for the group and read-only for others.

Edit the host file to map the hostname to its IP, install prerequisites with yum, create Oracle user and groups, set directory ownership, disable firewall, and set the Oracle password.

Learn the automatic setup for Oracle prerequisites and contrast it with the manual path, including sysctl.conf and security limits steps, and how the setup creates Oracle user and groups.

install oracle database 18c on linux by downloading the 18c linux 64-bit package, unzip, run oracle universal installer, configure a container database with orcl and pdb, and install sample schemas.

Learn how to start an Oracle database from no mount to open, using sqlplus with spfile, understand SGA allocation, and apply SYSDBA and SIS privileges for administration.

Explore how Oracle net services use the oracle listener as a gateway to the database, with listener.ora and tnsnames.ora configuring tcp/ip connections.

Install PuTTY, a free tool to connect to a remote server, and configure host mappings. Log in as Oracle, open sqlplus, and verify connectivity.

Learn multiple ways for the sysdba to log in to Oracle, including operating system authentication, password file login, and password-based logins, plus changing the sis password and security considerations.

Learn to connect with easy connect by supplying user, password, host, port, and service. The listener must be up to resolve services; OS authentication permits sysdba login without the listener.

Compare common users and local users in Oracle 12c and above. A CDB common user is created in the root container and inherited by all pluggable databases.

Understand dynamic performance views, dollar sign and v$ views updated in real time for performance monitoring with memory versus disk reads and live data.

Learn how to query data files in Oracle databases, including using CDB and PDB contexts, querying CDB_data_files and DBA_data_files for file names, file IDs, and tablespace names.

Learn how to keep a pluggable database open after startup by using alter pluggable database save state in Oracle 12c release 2, ensuring the PDB opens automatically in read-write mode.

Explore how v$parameter and v$parameter2 reveal session parameters, including is_session_modifiable and is_system_modifiable, and differentiate static, immediate, and deferred changes for pluggable databases.

Demonstrates the startup parameter file search order, showing Oracle checking spfile, then pfile, then init.ora, and how to create a pfile from an spfile to start the database.

Learn how the Oracle alert log records startup parameters, internal errors, and administrative actions, and locate diagnostic directories via the diag_info view with vi or addr.

Trace files store error information and guidance for tuning, while ADR collects diagnostic data for incidents and supports automatic purging by retention policy and size.

Create a new pluggable database from seed named pdb one, with admin user pdb one admin and dba role, and configure the users tablespace, data files, and file name convert.

Connect to the new pluggable database (PDB One) via listener service names and easy connect, switch to the PDB, and validate connections with sqlplus, sql developer, and tnsnames.ora.

Practice unplugging and plugging pluggable databases (PDBs), open and mount operations, generate a pdb test xml file, and explore data file paths and the no copy temp file reuse approach.

Explore Oracle supplied roles, including the DBA role and its best practice for pluggable databases, plus resource, schedule_admin, and select_catalog_role privileges for developers and tuning.

Create a common user with SYS-like privileges, assign default and temporary tablespaces, grant session, DBA, and sysdba roles, and verify logins and session privileges for auditing.

Create a pluggable database admin by adding a local user in the pluggable database, grant create session and DBA privileges, and verify the admin is restricted to the pluggable database.

Create master and sub master roles, grant system privileges (create session, create table, create view), and grant the master role to a user in an Oracle pluggable database.

The database configuration assistant creates a pluggable database with the PDB_DBA role, but requires additional DBA privileges for the PDB ten underscore admin user.

Discover how the with admin option allows passing system privileges to other users in a pluggable database. Create a test user and grant create session with admin option.

Learn how to create a common profile at the pluggable database level, configuring session per user, idle time, and password settings, then apply it to a common user.

Create a local profile in the pluggable database with session per user unlimited, then set inactive account time to 15 days and assign it to Sarah with required grants.

Explore how Oracle automatically manages storage space using Oracle managed files, local bitmap tablespace management, automatic segment space management, and proactive alerts to prevent file overwrites and capacity issues.

Explore how delete and update statements free space in a data block and how inserts reuse it in the same transaction or after commit, with Oracle coalescing fragmented space.

Explore how to monitor Oracle tablespace usage, configure warning and critical thresholds with dbms_salver, and respond to alerts by resizing data files and managing temporary space.