مفهوم DBA بشكل عملي
محتويات الكورس و الشروحات القادمه
oracle darabase
oracle instance
oracle database 11g/R2 installation guide for linux x86-64
database 11g/R2 creating with different methods
Views: 1122
Ahmed Ybat
Oracle DBA 11g Tutorial
Shutdown a Database
Shutdown with the NORMAL mode
Shutdown with the IMMEDIATE mode
Shutdown with the TRANSACTIONAL mode
Shutdown with the ABORT mode
Views: 220
Ahmed Ybat
Oracle DBA 11g Tutorial
shared pool - oracle 11g
Library - Sql area and procedure/ sql
data Dictionary cache
block structure
Views: 454
Ahmed Ybat
Oracle Database Process-
Overview of Oracle Processes
Background Processes , System Monitor Process (SMON) , Process Monitor Process (PMON), Recoverer Process (RECO)
Views: 607
Ahmed Ybat
Oracle DBA 11g Tutorial
Redo Log File , archive log file
online redo log
offline redo log file
archive log file
Log Switches
Views: 574
Ahmed Ybat
database buffer cache in oracle 11g
- Memory Structures
- Overview of the System Global Area
Views: 795
Ahmed Ybat
Oracle DBA 11g Tutorial
Starting Up a Database
startup database
nomount database
Mounting a Database to an Instance
open database
Views: 255
Ahmed Ybat
Oracle DBA 11g Tutorial
Background Process part 2
(DBWR,LGWR,CKPT,ARCH)
oracle database writer background process dbwr
log writer background process lgwr
checkpoint background process ckpt
archive process
Views: 472
Ahmed Ybat
قواعد البيانات 8
Oracle DBA 11g Tutorial
concept of control files
The database name
Names , locations of datafiles and redo log files
timestamp of the database creation
current log sequence number
Checkpoint information
Views: 149
Ahmed Ybat
قواعد البيانات 5
Oracle Redo Buffer Cache (Oracle DBA 11g Tutorial
concept of redo buffer cache
Views: 200
Ahmed Ybat
oracle database 11g
server processes
program global area in oracle 11g
user global area in oracle 11g
dedicated server process
Views: 673
Ahmed Ybat
oracle database 11g installation guide part one
linux configure for oracle database 11g installation
oracle database 11g software ::
Link NO 1
www.oracle.com
Link No 2 (linux.x64_11gR2_database_1of2)
http://www.mediafire.com/download/vl9ahz94jjb6ya5/linux.x64_11gR2_database_1of2.zip
(win32_11gR2_database_2of2)
http://www.mediafire.com/download/zkv3sc59rfgszw8/win32_11gR2_database_2of2.zip
54 file (packages for linux ) run.txt file
http://www.mediafire.com/download/g01bbaki6u6chha/rpm_package.rar
Views: 198
Ahmed Ybat
Oracle DBA 11g Tutorial
Oracle Data Files
Overview of Tablespaces and Overview of Datafiles
database block,extents,segments
Views: 168
Ahmed Ybat
قواعد البيانات
Oracle DBA 11g Tutorial
oracle 11g database creation
oracle 11g create database manually . pfile
oracle 11g create database dynamically (dbca) spfile
.....
يفضل ان تقوم بانشاء قاعدة البيانات manually ف البدا ثم بعد ذالك قم بانشاء الداتر بيز باستخدام dbca
ملحوظه لا توجد اي علاقة بين الداتابيز (max (manually
والداتا بيز (text (dbca
Views: 261
Ahmed Ybat
Oracle DBA 11g Tutorial
parameter files (pfile) (init.ora)
server parameter file (spfile)
Parameter Values
difference between spfile and pfile
Views: 285
Ahmed Ybat
oracle enterprise linux 5 installation guide on vmware (V-10)
http://www.oracle.com/technetwork/server-storage/linux/downloads/default-150441.html
https://blogs.oracle.com/sergio/entry/free_oracle_enterprise_linux_d_1
http://distrowatch.com/?newsid=06012
Views: 135
Ahmed Ybat
Oracle 11g Installation Part 2
install oracle database 11g
(installing oracle database 11g release 2 on enterprise linux 5)
www.oracle.com
Views: 175
Ahmed Ybat