Aprenda Oracle Database Administration Workshop Guide gratuitamente com 103 vídeo(s). Curso online grátis de Gestão de banco de dados | YouCourse.
Aulas do Curso
(103 vídeos)
0 de 103 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Oracle Database Administration Workshop Guide - Oracle DBA freshers & Junior Oracle DBA's & Experts
Oracle Database: Administration Workshop
Oracle Database Server Complete Understanding
Introduction:
==========
Ex…
1
Setting up Oracle Database Environment - Downloading Software from oracle.edelivery.com
Setting up Oracle Database Environment - Downloading Software for Oracle edelivery.
1. Download Oracle Virtual Box and…
2
Oracle Database Architecture || Memory Structure || Background Process || Storage Structures
What is Oracle database server?
Standalone Vs RAC
Connecting to the Database Instance
listener and tnsnames
Oracle Data…
3
Linux Installation and Configuration || Attaching Disk to Linux
Installing your Oracle Software
GI Home for Standalone
Install OH in GUI
OH Installation in Silent mode (Optional)
Clon…
4
ASM Installation and Configuration - Oracle Standalone || Oracle Restart Database Server
Oracle Database Installation Types
Standalone / Single Instance / Oracle Restart (ASM)
RAC / Real Application Cluster
I…
5
Basic Understanding of SQLs in Oracle RDBMS - DML - DDL - TCL - DCL
SQL: Structured Query Language.
It is a common language used by any RDBMS to do basic operations on their RDBMS. Follow…
6
12c ASM and Oracle Home Installation screenshots - ASM Disk Group Creation
Oracle Grid Infrastructure and Oracle Database Installation: System Requirements
Memory requirements:
1 GB for the data…
7
Users & Groups Creation and Oracle Home Directory Creation || Pre-Requisites
Preparing the Operating System:
Create the required operating system users and groups:
Groups:
oinstall
dba
Optional …
8
12C ASM Oracle Restart Database Server Installation - DB creation on ASM Disk Group
As a DBA, you must plan:
The logical storage structure of the database and its physical implementation:
1. How many disk…
9
12c Oracle Home Installation || Database Creation Along with OH Installation
Setting Environment Variables
Oracle environment variables:
ORACLE_BASE: Base of the Oracle directory structure. Recom…
10
12c Database Creation using dbca || DB Creation on ASM DiskGroup || Oracle Restart Database
12c Database Creation using dbca || DB Creation on ASM DiskGroup || Oracle Restart Database
Setting Environment Variabl…
11
ASM Architecture and Management - Complete Understanding of Oracle ASM Internal
Automatic Storage Management
Is a portable and high-performancecluster file system
Manages Oracle database files
Manage…
12
ASM Instance and Database Instance Management or Administration
SQL*Plus provides an additional interface to your database so that you can:
Perform database management operations
Execu…
13
Database Startup and Shutdown Sequence || Startup Dependencies for Standalone and RAC Database
Startup and shutdown databases using OEM irrespective if standalone and RAC database
SQL-Plus Utility
SQL- startup nomo…
14
Configuring Oracle Network || listener-tnsnames-sqlnet || netmgr - netca || tnsping and lsnrctl
Tools for Configuring and Managing the Oracle Network
Enterprise Manager Net Services Administration page
Oracle Net Man…
15
Database Storage and Tablespace Administration Management || Datablock and Tablespace
Database Storage and Tablespace Administration Management || Datablock and Tablespace
Datablock - Extents - Segments - …
16
Archivelog Mode and Alert log File || Enable Archivelog Mode || Verify the Database Alert log
Enabling ARCHIVELOG Mode
To place the database in ARCHIVELOG mode, perform the following steps in Enterprise Manager:
1.…
17
Redo logs Datafiles Controlefile and Archivelog Files || Database Basic Administration
Configuring the Fast Recovery Area
Fast recovery area:
Strongly recommended for simplified backup storage management
Sto…
18
Oracle User Management and User Security || Grants & Roles || Database Auditing
Database User Accounts
Predefined Administrative Accounts
Privileges
Revoking System Privileges with ADMIN OPTION
Revoki…
19
RMAN Backup Recovery Understanding and Complete Guide || level 0 and Level 1 Incremental
RMAN - Database backup:
=======================
rman target /
CONFIGURE CONTROLFILE AUTOBACKUP ON;
backup database plus …
20
19c Oracle DBA Training Announcement || Course Details || Course Starting on 1-Jun-2021
19c Oracle DBA Training starting on 1-Jun-2021.
Do Register Below:
https://docs.google.com/forms/d/e/1FAIpQLSfoZgaYpEL…
21
Oracle Datapump EXPDP & IMPDP || sqlldr and External Table || Loading Data or Loading Data
Data Pump offers many benefits and some new features over earlier data movement tools, such as:
1.Fine-grained object an…
22
Database Migration or Switching to Different Oracle Home || Oracle Home Cloning || Standalone DB
We are basically doing below tasks on this blog
1. Migration or switching database from dbhome_1 to dbhome_2
2. Clonin…
23
Drop Database Manual or Drop Database Using dbca (GUI) and Deinstall Oracle Home || DB & OH Cleanup
We can drop database and Deinstall Oracle Home:
We can drop database using:
1. Using command line - Manual method - "dro…
24
nid (DBNEWID) - Changing DBID and Changing DBNAME in Oracle || NID Utility in Oracle
nid (DBNEWID) - Changing DBID and Changing DBNAME in Oracle
We can change the DBID and Database name using nid command. …
25
Cleanup Old GI and DB homes || Deinstall Old GI & DB Homes After GI and DB upgradation || Inventory
Once we do GI upgrade we will be having old and new GI home on server, Also entry will be available on central inventory…
26
DROP ASM Instance || servctl remove asm || How to Delete ASM from Clusterware? || GI Home Cleanup
DROP ASM Instance using asmca or servctl - How to Delete ASM from Clusterware & GI Home Cleanup?
DROP ASM Instance || se…
27
Jul 2021 Patch Release Information || Jul 2021 CPU & PAD Documentation || CPU & PSU
Login to oracle support / MOS portal and search for required Patches or Jul 2021 Patch Availability Document (PAD) or Ju…
28
dbca options || Manage Template || Create Database || Drop Database || Manage PDBs & Many more
dbca options || Manage Template || Create Database || Drop Database || Manage PDBs & Many more
#dbca #template #DropDat…
29
Jul - 2021 CPU Patching - Standalone Database Patching - 12c & 19c Database Patching - OPatch
Jul - 2021 CPU Patching - Standalone Database Patching - 12c & 19c Database Patching
Jul - 2021 CPU Patching - Standalon…
30
Install 12.2.0.1 Database Binaries or Oracle Home in Silent Mode || GUI Vs Silent Installation
Install 12.2 Database Binaries or Oracle Home in silent mode
Please refer the below URL from more Information:
https://…
31
Oracle Database 21c is available for download on Linux || How to download 21c Database Software?
Finally the most awaited 21c is available for download on Linux flatform:
Download Location:
1. From OTN: https://www.o…
32
21c Oracle Home Installation and Database Creation Using dbca || 21.0.0.0 OH & Database Creation
21c Installation and Database Creation Using dbca - 21.0.0.0:
==========================================================…
33
Day_1 - Oracle DBA training - Environment Set-up for Oracle & Linux Basics || Oracle 19c
1. Environment Setup:
a) Software Download
Linux OS ISO image
Oracle Software
Oracle Patches
VMware Workstation Downloa…
34
Day_2 - Oracle DBA training - Linux Basic Networking & Linux Basic Administration - DNS - DHCP
Setting up DNS and DHCP and name resolution
a) DNS
b) DHCP
c) Nameserver
d) Forward Resolution
e) Reverse Resolution
D…
35
Installation of Oracle Virtual Box Software & Installation of Oracle Linux - Post N/W Configuration
1. Environment Setup:
a) Software Download
Linux OS ISO image
Oracle Virtual Box Download
b) Oracle Virtual Box Instal…
36
Installation of Oracle Linux Server from Ready Machines - How to get Ready VMs for Practice?
1. Environment Setup:
a) Software Download
Linux OS ISO image
Oracle Software
Oracle Patches
VMware Workstation Downloa…
37
How to setup Oracle Lab environment for Practice? Oracle Home Installation & Database Creation
Steps to Perform:
1. Install VM
2. Install pre-requisite rpms oracle-database-preinstall-19c or oracle*
3. Download 19c…
38
Oracle Restart Installation - ASM Installation - Oracle Home Installation & Database Creation
Steps to Perform:
1. Install VM
2. Install pre-requisite rpms oracle-database-preinstall-19c or oracle*
3. Download 19c…
39
Rolling Forward a Physical Standby || DR database is out of sync || archivelog are missing
Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)
Rolli…
40
log archive destination full - What to do? || DB is hung due to FRA is Full
1. log archive destination full, what to do?
2. Unable to switch / generate the archive log due to log archive destinati…
41
19c Oracle Database Installation on Windows Server 2016 | Local Account | Service Account
Domain - HQ
--- Administrator - HQ\administrator (Should not Install using admin account)
--- Service account - HQ\malli…
42
Oracle Database Understanding for Dummies - Oracle DBA Basics
Q1: What is Oracle Database Server?
Q2: What is Oracle Database Instance?
Q3: How to find how many database are running …
43
19c Oracle DBA Training || 17-Feb-2022 New Batch || Online Oracle DBA Training
Oracle Database Training!!! - 19c Oracle Database Training!!!
New DBA batch is starting on 17-Feb-2022. Don't forget to…
44
Day_1_Demo_Session DBA Basis & Basics Prerequisites For DBAs
Oracle Database Training!!! - 19c Oracle Database Training!!!
New DBA batch is starting on 17-Feb-2022. Don't forget to…
45
Day_2_Demo_Session Basics Of Linux & Basics Of Networking For Oracle DBAs
Oracle Database Training!!! - 19c Oracle Database Training!!!
New DBA batch is starting on 17-Feb-2022. Don't forget to…
46
Day_1-Demo_Session_1 - Oracle Database Workshop - Online Database Training
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html
1. Environment Setup:
a) Software Download
Linux OS ISO …
47
Day_2-Demo_Session_2 - Basics of Networking & Linux Basics - DBA Basics
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html
1. Setting up DNS and DHCP and name resolution
a) DNS
b) …
48
19c Oracle Database Training - Online Oracle Training - Database Course Introduction
Couse Curriculum:
https://mallik034.blogspot.com/p/database-training.html
Demo Classes: 21-Apr-2022 and 22-Apr-2022 (Th…
49
Timezone Upgrade After 19c Database Upgrade - DBMS_DST - Time zone file upgrade - v26 Vs v32
Timezone Upgrade After 19c Database Upgrade - DBMS_DST - Time zone file upgrade - v26 Vs v32
High Level Steps:
1. Check…
50
Verifying the sys password || OS Authentication Vs Password Authentication || sysdba password file
Verifying the sys password using TNSNAMES and LISTENER - OS Authentication Vs Password Authentication
Refer the below b…
51
CDB & PDB Backups - Complete Understanding of CBD & PDB Backups - Oracle Multitenant backups
CDB & PDB Backups:
=================
For commands and scripts please refer this blog post:
https://mallik034.blogspot.co…
52
Connecting to CDB & PDB with OS authentication Vs Password Authentication
Connecting to CDB & PDB with OS authentication Vs Password Authentication
1. Connecting to CDB with OS authentication:
…
53
CDB & PDB Recovery
CDB & PDB Recovery:
==================
For commands and scripts please refer this blog post:
https://mallik034.blogspot.…
54
PDB Export & Import - Pluggable Database
PDB Export & Import:
Steps:
1. Create DUMP directory:
2. Table export and import at PDB:
3. Schema export and import at …
55
Manual Database Creation || Silent Mode Database Creation
Manual Database Creation or Silent Mode Database Creation
High Level steps:
=================
1. set the environmental …
56
19c Oracle DBA Training || 30-Jun-2022 New Batch || Course Details & Demo Classes
Database Course:
================
Course Curriculum:
Blog:
https://mallik034.blogspot.com/p/database-training.html
YouT…
57
dbstart & dbshut Automatic startup & Shutdown Databases || Automation
dbstart & dbshut Automatic startup & Shutdown Databases:
1. We have to run these sb start and dbshut as oracle owner on…
58
Day_1_Demo_Session || Oracle Database Workshop & DBA Basics
Database Course:
================
Course Curriculum:
Blog:
https://mallik034.blogspot.com/p/database-training.html
YouT…
59
Day_2_Demo_Session || Basics Of Linux & Networking For DBAs
Database Course:
================
Course Curriculum:
Blog:
https://mallik034.blogspot.com/p/database-training.html
YouT…
60
Filesystem(FS) to ASM || Non-ASM to ASM Database Clone || Easy steps
Non-ASM to ASM RMAN Clone:
High Level Steps:
1. Prechecks on Source and Target Servers:
2. Take Source database backup …
61
Is DR or Standby database build is easy and simple?
Easy and Simple steps to build standby database:
High Level Steps:
1. Prechecks on primary and Standby Servers:
2. Check…
62
pwcopy utility ||Copy password file from ASM to FS
How to copy password file from ASM to FS:
=========================================
https://docs.oracle.com/database/121…
63
19c Oracle Database - Online Training || New batch is starting on 15-Sep-2022
Database Course:
================
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-trainin…
64
Database Training || Course Curriculum || 19c Oracle Online Training
Database Course:
================
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-trainin…
65
Day_1_Introduction_to_Database_Course & Database Basics
Database Course:
================
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-trainin…
66
Day_2_Databases_Course_&_Basics_Of_DBA_&_Standalone_Vs_RAC
Database Course:
================
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-trainin…
67
Webinar - 16 - Back to Basics with DataGuard Basics
Back to Basics with DataGuard Basics:
Agenda:
Data Guard Basics – Quick review
Types of Standby Databases.
Data Guard Ro…
68
19c Oracle Database Online Training || New DBA Batch Starting on 24-Nov-2022 || Live Demo Classes
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
69
Day_1_Demo_Session || Oracle Database Architecture Standalone Vs RAC
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
70
Day_2_Demo_Session || Oracle Database Architecture & Basics of Linux & Networking
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
71
RMAN Clone or RMAN duplicate without Archivelogs || RMAN-05541: No archived logs found
RMAN clone or RMAN duplicate database with No archive logs
==========================================================
If…
72
Oracle_DBA_Training || New Batch Starting on 02-Feb-2023 || Demo Classes
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
73
Day_1_Demo_Session || Database Course Details & Basics Of DBA
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
74
Day_2_Demo_Session | Database Connection | Database Architecture
Course Curriculum:
Check on my Blog:
https://mallik034.blogspot.com/p/database-training.html
Previous Database Batch An…
75
.bash_profile for Oracle?
Why we need .bash_profile?
Make DBA life easy...
it will be in home directory
$ls -ltr $HOME/.bash_profile - In Linux
…
76
Tablespaces Crazy Facts || Oracle DBA
Small File Tablespaces:
=======================
CREATE TABLESPACE TBS1
DATAFILE '/u01/app/oracle/oradata/DEVDB/datafile/…
77
DBA Training || New DBA Batch || 13-Apr-2023 || Oracle 19c Training
Demo Session - Oracle DBA Training - 13-Apr-2023:
Demo Date & Time:
13-Apr-2023 & 14-Apr-2023 (Thu & Fri)
9:00 AM IST …
78
Demo_Session_1 || Database Course || How Database Connectivity works?
Demo Session - Oracle DBA Training - 13-Apr-2023:
Demo Date & Time:
13-Apr-2023 & 14-Apr-2023 (Thu & Fri)
9:00 AM IST …
79
Demo_Session_2 || Confused with Oracle Database Architecture?
Demo Session - Oracle DBA Training - 13-Apr-2023:
Demo Date & Time:
13-Apr-2023 & 14-Apr-2023 (Thu & Fri)
9:00 AM IST …
80
Standalone File System (FS) Database to RAC Database Cloning || RMAN Duplicate Database
Standalone File System(FS) to RAC Database Cloning:
High Level Steps:
===============
1. Prechecks - Take Source DB bac…
81
DBA Automation with .bash_profile
DBA Automation with bash profile
Make DBA life easy...
it will be in home directory
$ls -ltr $HOME/.bash_profile - In …
82
RMAN Insights || Standby Build Vs RMAN Duplciate
RMAN Insights || Standby Build Vs RMAN Duplciate
Lowe Environment build (DEV/TEST/UAT) from PROD:
1. RMAN restore & Rec…
83
PDB save state?
1) List the PDBs and respective Modes
sqlplus / as sysdba
show pdbs
2) Check the Saved State for all PDB’s from DBA vi…
84
Oracle DBA Trainig || New Batch Announcement || 13-Jun-2023
Demo Session - Oracle DBA Training-13-Jul-2023:
Demo Date & Time:
13-Jul-2023 & 14-Jul-2023 (Thu & Fri)
8:00 AM IST to…
85
Day_1_Demo_Session || DBA Course Curriculam || Database Connectivity
Demo Session - Oracle DBA Training-13-Jul-2023:
Demo Date & Time:
13-Jul-2023 & 14-Jul-2023 (Thu & Fri)
8:00 AM IST to…
86
Day_2_Demo_Session || Database Architecture & Database Installation Process
Demo Session - Oracle DBA Training-13-Jul-2023:
Demo Date & Time:
13-Jul-2023 & 14-Jul-2023 (Thu & Fri)
8:00 AM IST to…
87
GI - Grid Infrastructure Maintenance on Restart Server
GI - Grid Infrastructure Maintenance for Restart Server
Refer my blog here
https://mallik034.blogspot.com/2023/08/gi-gr…
88
Unable to connect to PDB - Same PDB Name on 2 CDBs
Unable to connect to PDB?
Issue: Same PDB name on 2 CDBs and tns connection will be in trouble.
12c Multitenant: How to…
89
Database Startup Modes?
Database Startup and Shutdown Sequence - Database Administration
https://mallik034.blogspot.com/2024/02/database-startup…
90
v$instance Vs v$database
Database Startup and Shutdown Sequence - Database Administration
https://mallik034.blogspot.com/2024/02/database-startup…
91
Oracle Database Shutdown Options?
Database Startup and Shutdown Sequence - Database Administration
https://mallik034.blogspot.com/2024/02/database-startup…
92
Find database alert log?
Find database alert log?
https://mallik034.blogspot.com/2024/02/find-database-alert-log.html
Upcoming Batch Schedule li…
93
spfile Vs pfile in Oracle? File System Database
spfile - is Binary file
pfile - is txt file
location of spfile/pfile:
$ORACLE_HOME/dbs
create pfile from spfile:
cr…
94
dbname Vs DB Unique Name Vs Service Name
Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html
#dbname #servicename #oracl…
95
ORA-12547: TNS:lost contact Error for sqlplus / as sysdba connection
ORA-12547: TNS:lost contact Error for sqlplus / as sysdba connection
https://mallik034.blogspot.com/2024/02/ora-12547-tn…
96
Spfile Missing - Create spfile from pfile || Oracle Restart
Spfile Missing - Create from pfile - FS / OracleRestart / RAC
https://mallik034.blogspot.com/2024/03/spfile-missing-crea…
97
Oracle DBA Course - DBA-Batch-28-Mar-2024
Demo Session - 15.DBA-Batch-28-Mar-2024:
Demo Date & Time:
28-Mar-2024 & 29-Mar-2024 (Thu & Fri) IST
08:00 AM IST to 10…
98
Spfile Missing - Create spfile from pfile || FS database
Spfile Missing - Create from pfile - FS / OracleRestart / RAC
https://mallik034.blogspot.com/2024/03/spfile-missing-crea…
99
Useful ADRCI Commands In Oracle
ADRCI In Oracle
Useful ADRCI Commands In Oracle
https://mallik034.blogspot.com/2024/03/adrci-in-oracle.html
Upcoming Ba…
100
Automation Script To Find the ASM Directory & Subdirectory Usage
Automation Script To Find the ASM diskgroup directory & Subdirectory Usage
https://mallik034.blogspot.com/2024/03/automa…
101
?? Oracle DBA Workshop | 3 Hours Live Session | Oracle Architecture
?? Oracle DBA Workshop | 3 Hours Live Session
https://youtu.be/1-1nFjP6lpM
?? Oracle DBA Workshop | 3 Hours Live Sessio…
102
Oracle DBA Tutorial | Users, Schemas, Privileges, Roles, Profiles, Quotas & User Security
Oracle DBA Tutorial | Users, Schemas, Privileges, Roles, Profiles, Quotas & User Security
https://youtu.be/dhjhLMYcIy0
…
