Orcale Tutorial Content

Loading...

Getting Started - البدء مع إدارة قواعد البيانات
  • أنواع مستخدمي قواعد البيانات:
  • مهام مسؤول قاعدة البيانات:
  • SQL Statements:
  • Identifying Your Oracle Database Software Release - تحديد إصدار اوركل
  • About Database Administrator Security and Privileges- أمان وامتيازات مسؤول قاعدة البيانات
  • Database Administrator Authentication - مصادقة مسؤول قاعدة البيانات
  • Creating and Maintaining a Database Password File - إنشاء ملف كلمة المرور
  • Oracle Architectural Components - مكونات قاعدة البيانات أوركل
  • ﻤﻜﻭﻨﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Oracle Instance
  • Oracle Database
  • Installing Oracle Database - تثبيت الأوركل
  • Installing oracle database 10g in windows
  • Creating and Configuring Database - إنشاء قاعدة البيانات
  • ﺍﻟﺘﺨﻁﻴﻁ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﻟﻁﺭﻴﻘﺔ ﺍﻟﻴﺩﻭﻴﺔ علي Windows:
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍل(DBCA)
  • About Creating an Oracle Database
  • About Selecting a Character Set
  • Prerequisites for Database Creation
  • Creating a Database with the CREATE DATABASE Statement
  • Specifying CREATE DATABASE Statement Clauses
  • Specifying Initialization Parameters
  • Controlling The Database -التحكم في قاعدة البيانات
  • التحكم في قاعدة البيانات - Controlling The Database
  • ﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Opening a Database in Read-Only Mode
  • Opening a Database in Restricted Mode
  • Managing Tablespaces and Data files
  • ﻤﻔﺎﻫﻴﻡ ﻋﺎﻤﺔ ﻋﻥ ﺍل: Tablespaces
  • عملي
  • Control File & Redo Log Files
  • Control File
  • ﺘﻐﻴﻴﺭ ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Redo Log Files
  • Administrating Users - إدارة المستخدمين
  • ﺇﻨﺸﺎﺀ ﻭﺇﺩﺍﺭﺓ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ
  • Quota
  • ﻭﺴﻴﻠﺔ ﺍﻟﺘﺤﻘﻴﻕ
  • ﺍﻟﺼﻼﺤﻴﺎﺕ - Privileges
  • ROLES
  • PROFILES
  • Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
  • Database Security
  • ﻤﺭﺍﻗﺒﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ - AUDITING
  • Oracle Net Services & Database Link & Metrlized Viewِ
  • Oracle Net Services
  • ﺍﻟﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻭﺼﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • External Procedures
  • Clients Side
  • Database Link
  • Materialized Views
  • Undo Management & Flashback Technology
  • UNDO MANAGEMENT
  • Flashback Query
  • Flashback Table
  • Flashback Versions Query
  • Flashback Transaction
  • Flashback Drop
  • Flashback Database
  • Managing Shared Servers
  • Why Shared Server
  • Dedicated Server
  • Shared Server Architecture
  • ﻤﺘﻰ ﻨﺴﺘﺨﺩﻡ ﺍل Shared Server ؟
  • Using Globalization Support
  • Globalization
  • ﺍﺨﺘﻴﺎﺭ وتغيير ﺍل Character Set
  • ﻤﺴﺘﻭﻴﺎﺕ ﺍل Globalization
  • ﺍﺴﺘﺨﺩﺍﻡ ﺍل Zones Time
  • Logical Backup & Recovery
  • Use Export Utilities to Export Data
  • TABLES EXPORT Using Export Utilities
  • SCHEMAS EXPORT Using Export Utilities
  • TABLESPACE EXPORT Using Export Utilities
  • DATABASE EXPORT Using Export Utilities
  • Use Import Utilities to Import Data
  • TABLES IMPORT Using Import Utilities
  • SCHEMAS IMPORT Using Import Utilities
  • DATABASE IMPORT Using Import Utilities
  • DATA PUMP
  • TABLES EXPORT Using Data Pump
  • SCHEMAS EXPORT Using Data Pump
  • DATABASE EXPORT Using Data Pump
  • TABLES IMPORT Using Data Pump
  • SCHEMAS IMPORT Using Data Pump
  • DATABASE IMPORT Using Data Pump
  • SQL*Loader
  • Physical Backup & Recovery
  • Physical Backup
  • ﻜﻴﻑ ﻨﻬﻴﺊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺘﻌﻤل ﻓﻲ ﺍﻟﻨﻤﻁ ARCHIVELOG؟
  • Cold Backup
  • Full Database Recovery
  • Loss of a Non-SYSTEM Data File
  • Loss of a SYSTEM Data File
  • Loss of an Un-archived Online Log Files
  • Loss of Control Files
  • Loss Unbackup Datafile
  • Damage Tempfile
  • Damage Temporary Tablespace
  • Damage Online Logfile Member
  • Point in Time Recovery
  • Backup and Recovery Options
  • Hot Backup
  • Recovery Manager (RMAN)
  • مقدمة
  • مكونات ال Recovery Manager (RMAN)
  • ﺃﻨﻭﺍﻉ ﺍﻻﺘﺼﺎل ﺒﺎل RMAN
  • ﺨﻴﺎﺭﺍﺕ وأنماط ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ
  • RMAN Configuration Setting
  • Recovery Catalog
  • RMAN Backups
  • Data Files Backup
  • Tablespaces Backup
  • Archived Redo Log Files Backup
  • Control File Backup
  • Database Backup
  • Incremental Backups
  • RMAN Commands
  • Complete Recovery
  • Incomplete Recovery
  • Restore ControlFile and spfile
  • Managing Resources
  • Consumer Groups
  • Resource Manager Plans
  • Resource Manager Configuration
  • Create Consumer Group
  • Update Consumer Group
  • Delete Consumer Group
  • Privileges & Resource Manager
  • Join To Consumer Group
  • Move Active User To Other Consumer Group
  • Create Resource Manager Plans & Directive
  • Update Resource Manager Plans
  • Update Resource Manager Plan Directives
  • Delete Resource Manager Plan Directives
  • Delete Resource Manager Plans
  • Create Simple Plan
  • Consumer Group Mapping
  • Automating Tasks with the Scheduler
  • The Scheduler Architecture
  • Jobs
  • Programs
  • Schedules
  • Using Programs and Schedules
  • Job Classes
  • Windows
  • (Privileges) ﺍﻟﺼﻼﺤﻴﺎﺕ
  • Job Logs
  • Dealing with Locking
  • Shared & Exclusive Locks
  • Manual Lock Table
  • The Enqueue Mechanism
  • Lock Contention
  • Deadlocks
  • Diagnostic Sources
  • Alert Log
  • Background Trace Files
  • Server-Generated Alerts
  • Editing Thresholds
  • User Trace Files
  • Instance-Level SQL Tracing
  • Session-Level SQL Tracing
  • Dealing With Database Corruption
  • Block Corruption
  • ﺍﻜﺘﺸﺎﻑ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ (Detecting Block Corruptions)
  • The DBVERIFY Utility
  • The ANALYZE Command
  • DBMS_REPAIR Backage
  • ﺍﺴﺘﺭﺠﺎﻉ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ ﺒﻭﺍﺴﻁﺔ ﺍل:RMAN
  • Managing & Monitoring Memory
  • The System Global Area
  • The Shared Pool
  • The Database Buffer Cache
  • The Default, Keep, and Recycle Pools
  • The Nonstandard Block Size Pools
  • Sizing the Database Buffer Cache
  • The Log Buffer
  • The Large Pool
  • The Java Buffer
  • The Steams Buffer
  • Automatic Shared Memory Management
  • Enable Automatic Shared Memory Management
  • The Program Global Area (PGA)
  • Performance Tunning
  • Invalid Objects
  • Unusable Indexes
  • Rebuild Invalid Inexes
  • Optimizer Statistics
  • Gathering Statistics
  • The Automatic Workload Repository (AWR)
  • The Automatic Database Diagnostic Monitor (ADDM)
  • The SQL Tuning Advisor
  • The SQL Access Advisor
  • The Mean Time to Recover Advisor
  • The Segment Advisor
  • The Undo Advisor
  • Installing Oracle Database - تثبيت الأوركل

    Installing oracle database 10g in windows

    ﻤﺘﻁﻠﺒﺎﺕ ﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل:

    ﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل ﻤﻥ ﺃﻫﻡ ﻤﻬﺎﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ، ﻭﻴﺤﺘﺎﺝ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﻻﹰ  ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﺍﺴﺘﻴﻔﺎﺀ ﺍﻻﺤﺘﻴﺎﺠﺎﺕ ﺍﻟﻤﻁﻠﻭﺒﺔ ﻟﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل ﻗﺒل ﺍﻟﺒﺩﺀ ﺤﺘﻰ ﻻ ﺘﻔﺸل ﻋﻤﻠﻴﺔ ﺍﻟﺘﺜﺒﻴﺕ، ﻭﻤﻥ ﺍﻻﺤﺘﻴﺎﺠﺎﺕ ﺍﻟﻤﻁﻠﻭﺒﺔ ﻟﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل:-

     ﺸﺭﻜﺔ ﺃﻭﺭﻜل ﺘﻭﺼﻲ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺤﺠﻡ ﺍﻜﺒﺭ ﻤﻥ ﺍﻟﺫﺍﻜﺭﺓ ﺭﻏﻡ ﺃﻥ ﺍﻟﺤﺠﻡ ﺍﻷﻗل ﻟﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل 512 MB ، ﺃﻴﻀﺎ ﻴﺤﺘﺎﺝ ﺍﻭﺭﻜل ﻟﻤﺴﺎﺤﺎﺕ

    ﻜﺒﻴﺭﺓ ﻓﻲ ﺍﻟﻘﺭﺹ ﺘﺼل ﺇﻟﻰ 4.4 GB ﻟﺘﺨﺯﻴﻥ ﺍلSoftware Oracle ﻭﺃﻴﻀﺎ ﻟﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    ﺒﺎﻟﻨﺴﺒﺔ ﻟﻤﺘﻁﻠﺒﺎﺕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻓﺘﻌﺘﻤﺩ ﻋﻠﻰ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﺍﻟﻤﺴﺘﺨﺩﻡ ﻭﻴﻤﻜﻥ ﻤﺭﺍﺠﻌﺔ ﺍلOracle Documentation

    ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻭﺭﻜل ﺘﺩﻋﻡ ﻋﺩﺩ ﻤﻥ ﻨﻅﻡ ﺍﻟﺘﺸﻐﻴل ﺍﺒﺘﺩﺍﺀً ﻤﻥ ﻟﻴﻨﻜﺱ ﻭﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل Windows ﻭﺃﻴﻀﺎ ﻋﺩﺩ ﻤﻥ ﻨﻅﻡ ﺍﻟﺘﺸﻐﻴل ﺍﻷﺨﺭﻯ ﻤﺜل

    (Solaris, IBM AIX, HP-UX)

     

    : Optimal Flexible Architecture (OFA)

    ﺍﺒﺘﺩﺍﺀ ﻤﻥ ﺍﻹﺼﺩﺍﺭ ﺍﻭﺭﻜل 8 ﺒﺩﺃﺕ ﺍﻭﺭﻜل ﺍﺴﺘﺨﺩﺍﻡ الطريقة (Optimal Flexiable Architecture (OFA ، ﻭﻫﻰ ﻁﺭﻴﻘﺔ ﻟﺘﺜﺒﻴﺕ ﻤﻠﻔﺎﺕ ﺍﻻﻭﻜل ﺒﺸﻜل ﻤﻨﻅﻡ ﺒﺤﻴﺙ ﻴﺘﻡ ﻭﻀﻊ ﻫﻴﻜﻠﺔ ﻟﻤﻠﻔﺎﺕ ﺍﻻﻭﺭﻜل ﻴﺴﻬل ﻤﻌﻬﺎ ﻋﻠﻰ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺇﺩﺍﺭﺓ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ، ﻭﺫﻟﻙ ﻤﻥ ﺨﻼل ﺇﻨﺸﺎﺀ ﻤﺴﺎﺭﺍﺕ ﻭﻤﺠﻠﺩﺍﺕ ﻟﺘﻨﻅﻴﻡ ﻭﻀﻊ ﺍﻟﻤﻠﻔﺎﺕ ﻤﻤﺎ ﻴﺴﻬل ﻋﻤﻠﻴﺔ ﺍﻹﺩﺍﺭﺓ ﻭﺭﻓﻊ ﺍﻷﺩﺍﺀ، ﻭﺘﻡ ﺍﺴﺘﺨﺩﺍﻡ ﻫﺫﻩ ﺍﻟﻬﻴﻜﻠﺔ ﻟﻌﺩﺓ ﺃﺴﺒﺎﺏ-:

    1- ﺘﺴﻬﻴل ﺇﺩﺍﺭﺓ ﻭﻤﺭﺍﻗﺒﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    2- ﺘﻨﻅﻴﻡ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺨﺯﻴﻥ.

    3- ﺘﻴﺴﻴﺭ ﺍﻻﻨﺘﻘﺎل ﺒﻴﻥ ﻋﺩﺩ ﻤﻥ ﻗﻭﺍﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    4- ﺘﺩﻴﺭ ﻭﺒﺸﻜل ﻜﺎﻑ ﻨﻤﻭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    5- ﺍﻟﻘﻀﺎﺀ ﻋﻠﻰ ﺘﺠﺯﺌﺔ ﺍﻟﻤﺴﺎﺤﺎﺕ ﺍﻟﺘﺨﺯﻴﻨﻴﺔ ﺍﻟﺨﻴﺎﻟﻴﺔ.

    6- ﺘﻨﻅﻴﻡ ﻜﻤﻴﺎﺕ ﻜﺒﻴﺭﺓ ﻤﻥ ﺍل .Software

     

    ﺘﺤﺩﻴﺩ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ: -

    ﺃﻴﻀﺎ ﻗﺒل ﺒﺩﺀ ﺍﻟﺘﺜﺒﻴﺕ ﻫﻨﺎﻙ ﺒﻌﺽ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ ﺍﻟﺘﻲ ﺘﺴﺎﻋﺩ ﻋﻠﻰ ﺘﺜﺒﻴﺕ ﻭﺍﺴﺘﺨﺩﺍﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ:

    BASE :ORACLE:-

    ﻟﺘﺤﺩﻴﺩ ﺍﻟﻤﺴﺎﺭ ﺍﻟﺫﻱ ﺴﻭﻑ ﻴﺤﻭﻯ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﺭﻜل ، ﺃﻭ ﻴﺤﻭﻯ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍﻻﻭﺭﻜل.

    C:\ORACLE\PRODUCT\10.1.0\

     

     HOME ORACLE:-

    ﻟﺘﺤﺩﻴﺩ ﺍﻟﻤﺴﺎﺭ ﺍﻟﺫﻱ ﺴﻭﻑ ﻴﺤﻭﻯ ﺍل.Oracle Software

     C:\ORACLE\PRODUCT\10.1.0\DB_1\

     

    :ORACLE_SID

    ﻟﺘﺤﺩﻴﺩ ﺍﺴﻡ ﺍلInstance والإسم الإفتراضي للInstance هو (ORCL) ﻭﺘﻘﺘﺭﺡ ﺍﻭﺭﻜل ﺃﻥ ﻻ ﻴﺘﻌﺩﻯ ﺍﻻﺴﻡ ﺜﻤﺎﻨﻴﺔ احرف.

     

    :NLS_LANG

    ﻟﺘﺤﺩﻴﺩ ﺍﻟﻠﻐﺔ ﻭﺸﻜل ﺘﺨﺯﻴﻥ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

     

    ﺨﻁﻭﺍﺕ ﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل: -

    ﻟﺤﻅﺔ ﺒﺩﺀ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺜﺒﻴﺕ ﻭﻗﺒل ﺒﺩﺀ ﺍﻨﻁﻼﻕ ﺍلInstaller Universal Oracle ﻭﻫﻰ ﻋﺒﺎﺭﺓ ﻋﻥ

    ﻭﺍﺠﻬﺔ ﺼﻤﻤﺘﻬﺎ ﺍﻭﺭﻜل ﺒﺎﻟﺠﺎﻓﺎ ﻟﺘﺜﺒﻴﺕ ﺍﻷﻭﺭﻜل، ﻗﺒل ﺍﻨﻁﻼﻕ ﻫﺫﻩ ﺍﻟﻭﺍﺠﻬﺔ ﻴﺘﻡ ﺍﻟﺘﺄﻜﺩ ﺃﻟﻴﺎ ﻤﻥ ﺍﻟﺤﺩ ﺍﻷﺩﻨﻰ ﻤﻥ ﺍﻟﻤﺘﻁﻠﺒﺎﺕ ﺍﻟﻤﻁﻠﻭﺒﺔ ﻟﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل

    ﻓﻲ ﺤﺎل ﺇﻥ ﻨﻅﺎﻤﻙ ﻻ ﻴﻔﻲ ﺒﻭﺍﺤﺩ ﺃﻭ ﺃﻜﺜﺭ ﻤﻥ ﺍﻟﻤﺘﻁﻠﺒﺎﺕ ﻴﻤﻜﻨﻙ ﺍﺨﺘﻴﺎﺭ ﻤﻭﺍﺼﻠﺔ ﺍﻟﺘﺜﺒﻴﺕ ﺒﻭﺍﺴﻁﺔ – ignoreSysPrereqs ﻭﻟﻜﻥ ﻤﻊ ﺫﻟﻙ ﻓﺈﻥ ﺍﺤﺘﻤﺎل ﻨﺠﺎﺡ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺜﺒﻴﺕ ﺴﻭﻑ ﻴﻨﺨﻔﺽ ﺒﺸﻜل ﻜﺒﻴﺭ.

    ﻓﻲ ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻴﻅﻬﺭ ﻟﻨﺎ ﻓﻲ ﺍﻟﺠﺯﺀ ﺍﻷﻭل ﻤﺴﺎﺭ ﺍلOracle source  ، ﻭﻫﻭ ﺍﻟﻤﺴﺎﺭ ﺍﻟﺫﻱ ﻴﺤﻭﻱ ﻤﻠﻔﺎﺕ ﺘﺜﺒﻴﺕ ﺍﻷﻭﺭﻜل، ﺃﻤﺎ ﻓﻲ ﺍﻟﺠﺯﺀ ﺍﻟﺜﺎﻨﻲ ﻴﺘﻡ ﺘﺤﺩﻴﺩ ﻤﻜﺎﻥ ﺘﻨﺯﻴل ﻤﻠﻔﺎﺕ ﺍﻻﻭﺭﻜل ﺃﻭ ﻤﺎ ﻴﺴﻤﻰ

    ﺒﺎلOracle Home، ﺒﺎﻟﻁﺒﻊ ﻴﻤﻜﻨﻙ ﺘﻐﻴﻴﺭ ﺍﻟﻤﺴﺎﺭﺍﺕ ﺤﺴﺏ ﺍﺤﺘﻴﺎﺠﺎﺘﻙ.

    ﻓﻲ ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻴﺘﻡ ﺍﺨﺘﻴﺎﺭ ﻨﻭﻉ ﺍﻟﺘﺜﺒﻴﺕ، ﺍلOracle Universal Installer  ﺘﺨﺘﺎﺭ ﻓﻲ ﺍﻷﺼل Edition Enterprise ﻭﻤﻴﺯﺓ ﻫﺫﺍ ﺍﻟﻨﻭﻉ ﺃﻨﻪ ﻴﻭﻓﺭ ﻤﺴﺘﻭﻯ ﺴﺭﻴﺔ ﺍﻋﻠﻲ ﻭﺃﻴﻀﺎ ﻴﺤﺘﻭﻯ ﻋﻠﻰ Data Guard ﻭﺃﻴﻀﺎ ﻋﺩﺩ ﻤﻥ ﺍﻟﻤﻴﺯﺍﺕ ﺍﻟﺘﻲ ﺘﺩﻋﻡ Data Warehousing ، ﻴﻤﻜﻨﻙ ﺃﻴﻀﺎ ﺃﻥ ﺘﺨﺘﺎﺭ ﺍﻷﻨﻭﺍﻉ ﺍﻷﺨﺭﻯ ﺍﻟﻤﺘﺎﺤﺔ ﻤﻥ ﺃﻨﻭﺍﻉ ﺍﻟﺘﺜﺒﻴﺕ. ﻤﺜﻼﹰ ﺍﻟﻨﻭﻉ Custom ﻴﺘﻴﺢ ﻟﻙ ﻓﺭﺼﺔ ﺍﺨﺘﻴﺎﺭ ﺍﻟﻤﻜﻭﻨﺎﺕ ﺍﻟﺘﻲ ﺘﺤﺘﺎﺠﻬﺎ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻻﺨﺘﻴﺎﺭ ﻨﻭﻉ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﺘﺭﻴﺩ ﺇﻨﺸﺎﺀﻫﺎ، ﻴﻤﻜﻨﻙ ﺩﺍﺌﻤﺎ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻻﺤﻘﺎﹰ.

    ﻓﻲ ﺤﺎل ﺃﻨﻙ ﺘﺭﻴﺩ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻵﻥ ﻴﻤﻜﻨﻙ ﺍﺨﺘﻴﺎﺭ ﺍﻟﻘﺎﻟﺏ ﺍﻟﻤﻨﺎﺴﺏ ﻟﻘﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺘﻙ ﻤﺜﻼﹰ Data Warehouse، ﺃﻭ ﻴﻤﻜﻨﻙ ﺍﺴﺘﺨﺩﺍﻡ ﺍﻟﺨﻴﺎﺭ Advanced ﻟﺘﻬﻴﺌﺔ ﻗﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺘﻙ ﻜﻤﺎ ﺘﺭﻴﺩ، ﺒﺎﻟﻁﺒﻊ ﻜل ﻨﻭﻉ ﻤﻥ ﺃﻨﻭﻉ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻴﺤﺘﻭﻱ ﻋﻠﻰ ﻤﻴﺯﺍﺕ ﻭﺨﺼﺎﺌﺹ ﺘﺨﺘﻠﻑ ﻋﻥ ﺍﻷﺨﺭﻯ، ﻟﺫﺍ ﻋﻠﻲ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﺨﺘﻴﺎﺭ ﺍﻟﻘﺎﻟﺏ ﺍﻟﻤﻨﺎﺴﺏ. ﺍﻟﺨﻴﺎﺭ ﺍﻷﺨﻴﺭ ﻟﺘﺠﺎﻫل ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻵﻥ، ﻴﻤﻜﻨﻙ ﺇﻨﺸﺎﺅﻫﺎ ﻻﺤﻘﺎﹰ ﻴﺩﻭﻴﺎﹰ ﺍﻭ ﻋﻥ ﻁﺭﻴﻕ ﺍﻷﺩﺍﺓ (Database Configuration Assistants (DBCA.

    ﻗﻤﺕ ﺒﺎﺨﺘﻴﺎﺭ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﺨﻁﻭﺓ ﺍﻟﺴﺎﺒﻘﺔ ﻓﻴﻠﺯﻤﻙ ﻫﻨﺎ ﺘﺤﺩﻴﺩ ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ  Global Database Name ، ﺇﺫﺍ ﻜﻨﺕ ﺘﻌﻤل ﻓﻲ Domain ﻴﻜﻭﻥ ﺸﻜل ﺍﻻﺴﻡ ﻜﺎﻷﺘﻲ

    Database_name.Domain ، ﺃﻴﻀﺎ ﻴﻠﺯﻤﻙ ﺘﺤﺩﻴﺩ ﺍﺴﻡ ﺍلSID) Instance)  ﻭﻟﻴﺱ ﺸﺭﻁﺎﹰ ﺃﻥ ﻴﻁﺎﺒﻕ

    ﺍﺴﻡ ﺍلInstance ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ، ﺍﻻﺴﻡ ﻴﺠﺏ ﺃﻥ ﻴﺒﺩﺃ ﺒﺤﺭﻑ ﻭﺃﻥ ﻻ ﻴﺘﺠﺎﻭﺯ ﺜﻤﺎﻨﻴﺔ ﺤﺭﻭﻑ.

    ﺃﻴﻀﺎ ﻴﻠﺯﻤﻙ ﺍﺨﺘﻴﺎﺭ ﺍلSet Character ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ، ﻜﻤﺎ ﻴﻤﻜﻨﻙ ﺇﻨﺸﺎﺀ Schema Sample ﻟﻠﺘﺩﺭﻴﺏ.

    ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻻﺨﺘﻴﺎﺭ ﺘﻭﻉ ﺍﻟﺘﻁﺒﻴﻕ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻓﻲ ﺇﺩﺍﺭﺓ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ؛ ﺍل Grid Control ﻴﺴﺘﺨﺩﻡ ﻹﺩﺍﺭﺓ ﻋﺩﺩ ﻤﻥ ﻗﻭﺍﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺴﻭﺍﺀ ﻜﺎﻥ ﺫﻟﻙ ﻓﻲ ﻨﻔﺱ ﺍﻟﺠﻬﺎﺯ ﺃﻭ ﺃﺠﻬﺯﺓ ﻤﺨﺘﻠﻔﺔ ﻭﻟﻜﻥ ﻟﻜﻲ ﻴﺘﻡ ﺍﺨﺘﻴﺎﺭﻩ ﻻﺒﺩ ﻤﻥ ﻭﺠﻭﺩ Agent ، ﻜﻤﺎ ﻴﻤﻜﻥ ﺍﺨﺘﻴﺎﺭ  Database Control ﻹﺩﺍﺭﺓ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻫﻭ ﻴﺴﺘﺨﺩﻡ ﻹﺩﺍﺭﺓ ﻗﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺕ ﻭﺍﺤﺩﺓ ﻓﻘﻁ.

    ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻻﺨﺘﻴﺎﺭ ﻤﻜﺎﻥ ﻭﻜﻴﻔﻴﺔ ﺘﺨﺯﻴﻥ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ (Files Control & Files Data & Files Log Redo)، ﺍﻟﺨﻴﺎﺭ ﺍﻷﻭل File System ﻭﻫﻭ ﺍﻟﺘﺨﺯﻴﻥ ﻋﻠﻲ ﻤﺴﺘﻭﻯ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل، ﺃﻤﺎ ﺍﻟﺨﻴﺎﺭ ﺍﻟﺜﺎﻨﻲ ASM ﻹﻨﺸﺎﺀ ﻭﺇﺩﺍﺭﺓ ﺍﻟﻤﻠﻔﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍﻷﻭﺭﻜل، ﺃﻤﺎ ﺍﻟﺨﻴﺎﺭ  Raw Devices ﻓﻬﻲ ﻁﺭﻴﻘﺔ ﻤﺘﻘﺩﻤﺔ ﻟﺘﺨﺯﻴﻥ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    ﻤﻥ ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻴﻤﻜﻥ ﺘﻬﻴﺌﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻋﺒﺭ ﺍﻟﺨﻴﺎﺭ Enable Backups Automated  ﻜﻤﺎ ﻴﻤﻜﻥ ﺘﺄﺠﻴل ﺫﻟﻙ ًﻋﺒﺭ ﺍﻟﺨﻴﺎﺭ Do not Enable Backups Automated.

    ﻓﻲ ﺤﺎل ﺘﻬﻴﺌﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻴﻠﺯﻤﻙ ﺘﺤﺩﻴﺩ ﻤﻜﺎﻥ ﺘﺨﺯﻴﻥ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻓﺎﻷﺼل ﺃﻥ ﻴﺘﻡ ﺍﻟﺘﺨﺯﻴﻥ ﻓﻲ ﻤﻨﻁﻘﺔ ﺘﺴﻤﻲ Flash Recovery Area  ﻓﻬﻲ ﻤﻨﻁﻘﺔ ﺘﺘﻡ ﺇﺩﺍﺭﺘﻬﺎ ﻭﺍﻟﺘﺤﻜﻡ ﻓﻴﻬﺎ ﻋﺒﺭ ﺍﻷﻭﺭﻜل،

    ﻭﺤﺘﻰ ﺘﺘﻡ ﻋﻤﻠﻴﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺒﻨﺠﺎﺡ ﻻﺒﺩ ﻤﻥ ﺍﻟﺘﺤﻘﻕ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻤﻥ ﺨﻼل ﺍﻟﻤﺴﺘﺨﺩﻡ ﻭﻜﻠﻤﺔ ﺍﻟﻤﺭﻭﺭ.

    ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ لتعيين ﻜﻠﻤﺎﺕ ﺍﻟﻤﺭﻭﺭ ﻟﻤﺴﺘﺨﺩﻤﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﺭﻜل، ﺘﺴﺘﻁﻴﻊ ﻭﻀﻊ ﻜﻠﻤﺔ ﻤﺭﻭﺭ ﻤﺨﺘﻠﻔﺔ ﻟﻜل ﻤﺴﺘﺨﺩﻡ ﻋﺒﺭ ﺍﻟﺨﻴﺎﺭ Use Different Passwords for these Account

    ، ﻭﺘﺴﺘﻁﻴﻊ ﺘﺤﺩﻴﺩ ﻜﻠﻤﺔ ﻤﺭﻭﺭ ﻟﺠﻤﻴﻊ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﻋﺒﺭ ﺍﻟﺨﻴﺎﺭ Use The Same Password For All Account.

    ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﻋﺒﺎﺭﺓ ﻋﻥ ﻤﻠﺨﺹ ﻟﻠﺨﻴﺎﺭﺍﺕ ﺍﻟﺘﻲ ﻗﻤﺕ ﺒﺘﻬﻴﺌﺘﻬﺎ ﺃﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺜﺒﻴﺕ. ﺘﺴﺘﻁﻴﻊ ﺍﻟﺘﺭﺍﺠﻊ ﻭﺍﻟﺘﻌﺩﻴل ﻓﻲ ﺒﻌﺽ ﺍﻟﺨﻴﺎﺭﺍﺕ ﺍﻟﺘﻲ ﻗﻤﺕ ﺒﺎﺨﺘﻴﺎﺭﻫﺎ ﻭﺫﻟﻙ ﺒﺎﻟﺭﺠﻭﻉ ﺇﻟﻰ ﺍﻟﺨﻠﻑ Back.

    ﻻﺤﻅ ﻭﺃﻨﺕ ﺘﻘﻭﻡ ﺒﺘﺜﺒﻴﺕ ﺍﻷﻭﺭﻜل ﺃﻨﻪ ﻴﻭﺠﺩ ﺩﺍﺌﻤﺎﹰ ﺨﻴﺎﺭ Help ﻟﻠﻤﺴﺎﻋﺩﺓ.

     

    ﺍﻵﻥ ﺒﺩﺃﺕ ﻋﻤﻠﻴﺔ ﺍﻟﺘﺜﺒﻴﺕ، ﻓﻘﻁ ﻴﻠﺯﻤﻙ ﺍﻻﻨﺘﻅﺎﺭ ﻗﻠﻴﻼﹰ.

    ﻴﺴﺘﻁﻴﻊ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻹﻁﻼﻉ ﻋﻠﻲ ﺍلLog File ﺍﻟﺨﺎﺹ ﺒﺎﻟﺘﺜﺒﻴﺕ ﻤﻥ ﺨﻼل ﺍﻟﻤﺴﺎﺭ ﺍﻟﺫﻱ ﻴﻅﻬﺭ ﻓﻲ ﺍﻟﺸﺎﺸﺔ.

    ﺇﺫﺍ ﺍﺨﺘﺭﺕ ﻓﻲ ﺍﻟﺨﻁﻭﺍﺕ ﺍﻟﺴﺎﺒﻘﺔ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺘﺜﺒﻴﺕ ﺍﻻﻭﺭﻜل ﻓﺴﺘﻅﻬﺭ ﻟﻙ ﻫﺫﻩ ﺍﻟﺸﺎﺸﺔ ﺍﻟﺘﻲ ﺘﻘﻭﻡ ﺃﻭﻻ ﺒﺘﻬﻴﺌﺔ ﺍلOracle Net، ﻭﺜﺎﻨﻴﺎﹰ iSQL*Plus ﻭﺃﺨﻴﺭﺍ ﺇﻨﺸﺎﺀ ﻭﺘﻬﻴﺌﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﻭﺍﺴﻁﺔ

    .(Database Configuration Assistance (DBCA

    ﻴﺘﻡ ﺍﻵﻥ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﻭﺍﺴﻁﺔ ﺍﻷﺩﺍﺓ.(Database Configuration Assistance (DBCA

    ﻭﻓﻲ ﻫﺫﻩ ﺍﻟﻠﺤﻅﺔ ﻴﺘﻡ ﺇﻨﺸﺎﺀ ﻤﻠﻔﺎﺕ ( Redo Files  & Control Files & Data Files ) ﻜﻤﺎ ﻴﺘﻡ ﺍﻨﺠﺎﺯ ﻋﺩﺩ ﻤﻥ ﺍﻟﻤﻬﺎﻡ ﺍﻟﺘﻲ ﻜﺎﻥ ﻴﺘﻭﺠﺏ ﻋﻠﻴﻙ ﻋﻤﻠﻬﺎ ﻴﺩﻭﻴﺎﹰ ﻟﻭ ﻟﻡ ﺘﺴﺘﺨﺩﻡ ﺍل Database Configuration Assistance ، ﻜﺈﻨﺸﺎﺀ ﺍلData Dictionary ﻭﺇﻨﺸﺎﺀ ﻋﺩﺩ ﻤﻥ ﺍﻟﺤﺯﻡ ﻭﺍﻹﺠﺭﺍﺀﺍﺕ ﺍﻟﺩﻭﺍل ﺍﻟﺘﻲ ﻨﺤﺘﺎﺠﻬﺎ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    ﺍﻟﺸﺎﺸﺔ ﺍﻷﺨﻴﺭﺓ ﻋﺒﺎﺭﺓ ﻋﻥ ﻤﻠﺨﺹ ﻟﺠﻤﻴﻊ ﻋﻨﺎﻭﻴﻥ ﺍﻟﺘﻁﺒﻴﻘﺎﺕ ﺍﻟﺘﻲ ﻗﻤﺕ ﺒﺎﺨﺘﻴﺎﺭﻫﺎ ﻤﺜل (Oracle Enterprise Manager & iSQL*Plus)

     

    --------