Skip to main content

Search This Blog

DBA Master

"Check the Error Log, Find the Solution, Execute with Properly"

Linux
PostgreSQL
ORACLE 19C
MySQL

ORACLE 19C

Get link
Facebook
X
Pinterest
Email
Other Apps

Oracle 19C Database Installation

Oracle Database 19c Software Installation
Oracle 19C non-container database (non-CDB) creation
Oracle 19C Create and Configure a Single Instance Database

SQL

Oracle Editions
Oracle Version History and features
What is SQL? and History of SQL?
Oracle Database Objects and Naming Rules
Oracle Database Data Types
Oracle Languages
Oracle Constraints
Operators and Functions
Set Operators, Sub Query and Joins
Views, Synonym and Sequence
Oracle Index
SQL Loader and External Table

Oracle PL/SQL

PL/SQL Introduction
Operators, IF condition Statements, CASE and Looping structures
Procedures
Functions
Packages
Cursor
Exception
Trigger
Dynamic SQL

Oracle 19C Database Administration

1. Oracle Architecture and Components

Oracle Architecture
SQL Processing or Query Flow
Instance - SGA
Instance - PGA & UGA
Oracle Process
Oracle Background Process
Physical Storage Structure
Logical Storage Structure
Parameter File
Control File
Oracle REDO Management (LOG File)
Archive Log Management
Oracle Database Startup and shutdown
Auto Startup and shutdown
Oracle Net Service
Data dictionary

2. Oracle Multitenant Architecture and Commands

3. Oracle Tablespace Management

Tablespace
UNDO Management

4. Managing the Users and Profile

5. Oracle Database (DB) Link

6. Oracle DBMS Scheduler

7. Oracle Flashback Concepts

8. Oracle Database Backup, Recovery and Clone Concepts

Physical Backup, Recovery and Clone
Data Pump
RMAN Backup and Restore
RMAN Recovery Catalog
Recover the SP file and Control File
Database Clone Using RMAN Backup Sets and Active Database
RMAN Working Scenarios

9. Oracle Up-Gradation and Patching

Upgradation from 12c to 19c
Oracle Patching - Opatch Utility

10. Oracle Data Guard Concepts

Dataguard Configuration in Oracle 19C Container Database
Oracle 19C Dataguard Swithover without DataGuard Broker
Dataguard Broker Configuration in Oracle 19C
Switchover Activity and Revert Back Use Dataguard Broker in Oracle 19C
Failover Activity Use Dataguard Broker (DGMGRL) in Oracle 19C
Fast-Start Failover Enable the Broker (DGMGRL) in Oracle 19C

11. Oracle Performance Tunning Concepts

Oracle Indexes
Automatic Indexing in Oracle 19C
De-fragmentation
Materialized View
Table Partitions
Oracle 19C Performance Tunning - PART 1

12. Oracle Utility Tools Like NID, CSSCAN, ORAPWD, DBC and OERR

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Powered by Blogger

Theme images by Muthu Siva Malaichamy

DBA Master

Pages

Linux
PostgreSQL
ORACLE 19C
MySQL

Popular Posts

Oracle Database 19C Performance Tunning - PART 1

Advantages: 1. Improved Query Performance • Optimized SQL execution plans lead to faster query response times. • Reduces unnecessary full table scans and improves indexing strategies. • Parallel execution tuning speeds up large data processing tasks. 2. Better Resource Utilization • Efficient use of CPU, memory, disk I/O, and network resources. • Reduces contention on Redo Logs, Undo Tablespaces, and Buffer Cache. • Helps in load balancing across multiple instances in RAC (Real Application Clusters). 3. Increased System Scalability • Ensures that the database can handle a growing number of users and transactions. • Proper tuning allows scaling without degrading performance. • Optimized parallel processing ensures better performance on multi-core servers. 4. Lower Infrastructure Costs • Reduces the need for add...

Oracle 19c Database Software Installation in OEL8

Pre-requisites for OS level: Set the static IP Address Disable the Firewall (systemctl stop firewalld & systemctl disable firewalld) set SELINUX=permissive on /etc/selinux/config ##Need to restart the server use init 6 Oracle Installation Pre-requisites Methods Automatic Setup Manual Setup Automatic requisites Setup: (avoid step 1 to step 5): dnf install -y oracle-database-preinstall-19c Install the dependencies: curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm Manual Setup: step 1: Add the karenl parameters and values vi /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel....

PostgreSQL Opensource Installation in RHEL or Oracle Linux(OEL) 8 and above

Types OF Installation Binary(Packages) Source RPM (Red hat Package Management) Notes: Once Installed the PostgreSQL set Password for postgres (OS Level) User. Login the root user and set password like passwd postgres Binary Installation: (Online Installation – Internet Must) Step 1: goto https://www.postgresql.org/ and click Download Choose Packages on Top Left Cornor Step 2: Select Your Operating System. Choose Linux and select your Linux distribution( Redhat/centos ). and scroll down Step 3: Select PostgreSQL Version. Example Choose 17 Step 4: Select Linux Platform. Example select Red Hat enterprise, CentOS, Scientific or Oracle version 8 Step 5: Select OS architecture Type. Example Select x86_64 Step 6: Copy the Script and paste your terminal Example: # Install the repository RPM: sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Disab...

Oracle RMAN Backup And Restore

RMAN: (Oracle 8) RMAN (Recovery Manager) is a utility provided by Oracle Database to perform backup, restore, and recovery operations. It is a command line tool. Features of RMAN in Oracle 19c Comprehensive Backup Capabilities: Full and incremental backups. Block-level backups for efficient data storage. Archived redo log backups. Fast Recovery Area (FRA) integration for centralized backup storage. Efficient Recovery Options: Point-in-time recovery (PITR). Complete and incomplete recovery. Flashback database capabilities for quick undo of changes. Multitenant Database Support: RMAN fully supports container databases (CDBs) and pluggable databases (PDBs). Provides flexibility to back up and recover individual PDBs or entire CDBs. Automatic Space Management: Manages disk space in the FRA. Automatically deletes obsolete backups and archived logs. Data Deduplication and Compression: Backup optimization through block-level deduplication. Built-in compression algorithms to reduce storage req...

Oracle Patching Using Opatch Utility

Opatch: It is a utility for patching Oracle software, specifically Oracle databases and related products. It is used to apply, roll back, and check Oracle patches, including interim patches, one-off patches, and bundle patches. Types of Patches: Patch Type Purpose Release Frequency Includes Security Fixes? Includes Bug Fixes? Includes New Features? One-off Patch Fix a specific issue As needed No Yes No PSU (Patch Set Update) Security + Bug fixes Quarterly Yes Yes Minimal CPU (Critical Patch Update) Security fixes only Quarterly Yes No No RU (Release Update) Security + Bug + Functional changes Quarterly Yes Yes Yes BP (Bundle Patch) Exadata/Windows patch...