Orcale Tutorial Content
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Using Globalization Support
ﻤﺴﺘﻭﻴﺎﺕ ﺍل Globalization
ﻴﻤﻜﻥ ﺃﻥ ﺘﻜﻭﻥ ﺍلGlobalization ﻤﺤﺩﺩﺓ ﻓﻲ ﺃﻱ ﺃﻭ ﺠﻤﻴﻊ ﺍﻟﻤﺴﺘﻭﻴﺎﺕ ﺍﻟﺘﺎﻟﻴﺔ:
1 - The Database: ﻭﻴﺘﻡ ﺘﺤﺩﻴﺩ ﺍلDatabase Globalization ﻟﺤﻅﺔ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.
SELECT * FROM NLS_DATABASE_PARAMETERS; |
2 - The Instance: ﺘﻬﻴﺌﺔ ﺍلInstance Globalization ﺴﺘﺘﺠﺎﻭﺯ ﺘﻬﻴﺌﺔ ﺍلDatabase Globalization ﻓﻠﻭ ﻜﻨﺕ ﺘﺴﺘﺨﺩﻡ ﻤﺜﻼﹰ ﺒﻴﺌﺔ ﺍلRAC ﻭﻫﻲ ﺃﻜﺜﺭ ﻤﻥ Instances ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
ﻓﻤﻥ ﺍﻟﻤﺤﺘﻤل ﺃﻥ ﺘﺨﺘﻠﻑ ﺘﻬﻴﺌﺔ لInstance Globalization ﻟﻜل Instance، ﻓﻌﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل ﻴﻤﻜﻥ ﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﻤﻥ ﺃﻤﺭﻴﻜﺎ ﻭﺃﻭﺭﺒﺎ ﺍﻟﺩﺨﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻜﻼﹰ ﻤﻥ ﺨﻼل Instance
ﻴﺘﻡ ﺘﻬﻴﺌﺘﻬﺎ ﺤﺴﺏ ﺍﺤﺘﻴﺎﺠﺎﺘﻬﻡ ﺍﻟﻤﺨﺘﻠﻔﺔ. ﻓﺎﻹﻋﺩﺍﺩﺍﺕ ﺍﻟﺴﺎﺭﻴﺔ ﺤﺎﻟﻴﺎﹰ ﻓﻲ ﺍلInstance ﻴﻤﻜﻥ ﻋﺭﻀﻬﺎ ﻤﻥ ﺨﻼل NLS_INSTANCE_PARAMETERS View ﻭﺍﻟﺫﻱ ﻴﺤﺘﻭﻱ ﻋﻠﻲ ﻨﻔﺱ ﺤﻘﻭل
ﺍلNLS_DATABASE_PARAMETERS ﻤﺎ ﻋﺩﺍ ﺜﻼﺜﺔ ﺼﻔﻭﻑ ﻻ ﺘﻨﻁﺒﻕ ﻋﻠﻲ ﺍلInstance.
SELECT * FROM BLS_INSTANCE_PARAMETERS; |
3 - The client environment: ﻋﻨﺩﻤﺎ ﻴﺒﺩﺃ ﺍلOracle User Process ﻓﻲ ﺍﻟﻌﻤل ﻓﺈﻨﻪ ﻴﺘﻔﻘﺩ ﺍﻟﺒﻴﺌﺔ
ﺍﻟﺘﻲ ﻴﻌﻤل ﺒﻬﺎ ﻻﻟﺘﻘﺎﻁ ﺍلdefault Globalization ، ﻫﺫﻩ ﺍﻵﻟﻴﺔ ﺘﻌﻨﻲ ﺃﻨﻪ ﻤﻥ ﺍﻟﻤﻤﻜﻥ ﻟﻠﻤﺴﺘﺨﺩﻤﻴﻥ ﺍﻟﺫﻴﻥ ﻴﺭﻏﺒﻭﻥ ﺒﻀﺒﻁ Globalization ﻤﺨﺘﻠﻔﺔ ﻤﻥ ﺘﻬﻴﺌﺔ ﺍلClient
ﺒﻤﺎ ﻴﺘﻭﺍﻓﻕ ﻤﻊ ﺍﺤﺘﻴﺎﺠﺎﺘﻬﻡ ﻭﻤﻥ ﺜﻡ ﻓﺈﻥ ﺍﻷﻭﺭﻜل ﻴﻠﺘﻘﻁ ﻫﺫﻩ ﺍﻹﻋﺩﺍﺩﺍﺕ ﺘﻠﻘﺎﺌﻴﺎﹰ ﺩﻭﻥ ﺍﻟﺘﺩﺨل ﻤﻥ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭ ﺍﻟﻤﺒﺭﻤﺠﻴﻥ. ﺘﺴﺘﻁﻴﻊ ﺘﻬﻴﺌﺔ ﺍلClient ﻋﻥ ﻁﺭﻴﻕ ﺘﻬﻴﺌﺔ
ﺍﻟﻤﺘﻐﻴﺭ (NLS_LANG environment variable) ﻫﺫﺍ ﺍﻟﻤﺘﻐﻴﺭ ﻴﺤﺩﺩ ﻜﻼﹰ ﻤﻥ Set Character & Territory & Language.
ﻻﺴﺘﺨﺩﺍﻡ ﺍﻟﻠﻐﺔ ﺍﻟﻔﺭﻨﺴﻴﺔ ﻓﻲ ﻜﻨﺩﺍ NLS_LANG= NLS_LANG=FRENCH_CANADA.WEISO8859P١ .
ﻭﺒﻐﺽ ﺍﻟﻨﻅﺭ ﻋﻥ ﺍلDatabase and Instance Globalization ﻓﺈﻥ ﻤﺴﺘﺨﺩﻡ ﻫﺫﺍ ﺍلClient ﺴﻭﻑ ﻴﺘﻡ ﻋﺭﺽ ﺍﻟﺭﺴﺎﺌل ﻭﺘﻨﺴﻴﻕ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻓﻘﺎﹰ ﺍﻟﻠﻐﺔ ﺍﻟﻔﺭﻨﺴﻴﺔ ﺍﻟﻜﻨﺩﻴﺔ.
ﻋﻨﺩﻤﺎ ﻴﻘﻭﻡ ﺍﻟﻤﺴﺘﺨﺩﻡ ﺒﺈﺭﺴﺎل ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟلServer ﻓﺈﻨﻪ ﺍﻟﻤﺴﺘﺨﺩﻡ ﺴﻭﻑ ﻴﺩﺨل ﻫﺫﻩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﻟﻠﻐﺔ ﺍﻟﻔﺭﻨﺴﻴﺔ ﺍﻟﻜﻨﺩﻴﺔ ﻭﻟﻜﻥ ﺍلServer ﻴﺨﺯﻥ ﻫﺫﻩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻓﻘﺎﹰ ﻟلDatabase Globalization Setting .
ﻋﻤﻠﻴﺔ ﺍﻟﺘﺤﻭﻴل ﺒﻴﻥ ﺍلClient-Site and Server-Site Globalization ﺘﺘﻡ ﻋﻥ ﻁﺭﻴﻕ ﺍل Oracle Net ﻭﻟﻜﻥ ﻤﻥ ﺍﻟﻤﺤﺘﻤل ﺃﻥ ﻻ ﺘﺘﻡ ﻋﻤﻠﻴﺔ ﺍﻟﻌﻤﻠﻴﺔ ﺒﻨﺠﺎﺡ.
ﻟﺘﺤﻭﻴل الClient Globalization
C:\>set NLS_LANG= FRENCH_CANADA.WEISO8859P1 |
٤ - The Session :ﻟﺤﻅﺔ ﺍﻻﺘﺼﺎل ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻴﺴﺘﻁﻴﻊ ﺍﺴﺘﺨﺩﺍﻡ ﺍﻷﻤﺭ ALTER SESSION ﺃﻭ ﺍﻟﺤﺯﻤﺔ DBMS_SESSION ﻟﺘﻬﻴﺌﺔ ﺍلGlobalization Session ،
ﻋﺎﺩﺓ ﻤﺎ ﻴﻤﻜﻥ ﺍﻟﻘﻴﺎﻡ ﺒﺫﻟﻙ ﺒﺭﻤﺠﻴﺎﹰ ﻭﺭﺒﻤﺎ ﻋﻥ ﻁﺭﻴﻕ Logon Trigger .
Alter session set nls_date_format='dd.mm.yyyy'; |
ﺘﻬﻴﺌﺔ الSession Globalization تتجاوز الDatabase and Instance and Client Globalization .
ﻴﻤﻜﻥ ﺍﺴﺘﻌﺭﺍﺽ ﺍلGlobalization Settings ﺍﻟﺤﺎﻟﻴﺔ ﻓﻲ ﺍلSession ﻋﻥ ﻁﺭﻴﻕ V$NLS_INSTANCE View
5 - The statement: ﻭﻫﺫﺍ ﺍﻟﻤﺴﺘﻭﻱ ﻫﻭ ﺁﺨﺭ ﻤﺴﺘﻭﻱ ﻤﻥ ﺍلGlobalization ﻭﻴﺘﺠﺎﻭﺯ ﺠﻤﻴﻊ ﺍﻟﻤﺴﺘﻭﻴﺎﺕ ﻭﺘﺘﻡ ﺇﺩﺍﺭﺘﻪ ﺒﺭﻤﺠﻴﺎﹰ،
ﺩﺍﺨل ﻜل Statement ﺤﻴﺙ ﻴﺘﻡ ﺍﺴﺘﺨﺩﺍﻡ NLS Parameter ﻓﻲ الSQL Functions .
-------------------------------------