Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Oracle Database Administration Workshop

All Note

---

• Exame:

  • Oracle Database Administration I Exam Number: 1Z0-082

• Online Course:

  • Udemy: Oracle Database Administration Workshop ( 12c and Higher)

---

Catelog

• Intro

• Local Virtual Machine

• Database Instance

  • Startup
    • Lab: Startup
  • Shutdown
    • Lab: Shutdown mode
  • Parameter File
  • Parameters

• Pluggable Database

  • Create and Clone Pluggable Database
  • Drop Pluggable Database
  • Plugging and Unplugging Pluggable Database

• Net Services Architecture

  • Listener
  • TNS Name
  • Login SQLP*LUS
  • Listener Control Utility (lsnrctl)
  • Oracle Net Configuration Assistant (netca)
  • Oracle Net Manager (netmgr)
  • Database Link

• Memory Structures

  • System Global Area (SGA)
    • Database Buffer Cache
    • Redo Log Buffer
    • Shared Pool
    • Large Pool
    • Java Pool
    • Fixed SGA
  • Program Global Area (PGA)
  • User Global Area (UGA)

• Process Architecture

  • Client Processes
  • Server Processes
  • Background Processes
  • Slave Processes

• Storage Structures

  • Physical Storage Structures
    • Data File
    • Control File
    • Online Redo Log
  • Logical Storage Structures
    • Data Blocks, Extents, Segments
    • Tablespaces
    • Undo

• Users, Roles and Privileges

  • User Account
  • Privileges and Roles
  • Common Users & Local Users
    • Grant Admin Privileges
  • User Profile

• Miscellaneous

• Automatic Diagnostic Repository (ADR)

---

• Moving Data

  • SQL*Loader
  • External Table
  • Moving Data Between PDBs

---

• Backup and Recovery

  • Overview

  • Backup

    • Back Up Control File

  • Recovery

• Lab

  • Lab 14-1

---

SELECT name FROM v$controlfile;
SELECT is_recovery_dest_file FROM v$controlfile;
SELECT block_size FROM v$controlfile;
SELECT file_size_blks FROM v$controlfile;
SELECT con_id FROM v$controlfile;
SELECT name, block_size, file_size_blks FROM v$controlfile;

---

Lab: get the database name

• Command to return database name
  • Method 01:
    • check the tnsname.ora
  • Method 02:
    • Return the processes name to which Oracle listens.

# check for the presence of Oracle System Monitor (SMON) processes.
# ps -ef: Lists information about all currently running processes in a detailed format.
# grep smon: Searches for lines containing the string "smon" in the output
# grep -v grep:  ensures that the grep process used for searching is not included in the results.
ps -ef | grep smon
ps -ef | grep smon | grep -v grep

---

TOP