Oracle 11g 培训笔记----01
上一篇 / 下一篇 2008-01-25 22:24:18 / 个人分类:学习笔记
Oracle Database 11g: New Features for Administrators
一、Oracle Database 11g: Focus Areas
• Manageability
• Availability
• Performance
• Business intelligence and data warehousing
• Security
• Information management
– Content management
– XML
– Oracle Text
– Spatial
– Multimedia and medical imaging
• Application development
– PL/SQL
– .NET
– PHP
– SQL Developer
* Note: Many DBA's job will be done automatically by setting parameters.
*Note: The Next Generation Databas is Self-Managing Database
- -- Manage change
---- Manage performance and resources
---- Manage fault
*Note: Why call oracle 10g or 11g ? as g means grid computing
*Note: Oracle By Example series: Oracle Database 11g
–http://otn.oracle.com/obe/obe11gdb/index.html
二、Installation and Upgrade Enhancements
• Addition of new products to the install:
– Oracle Application Express
– Oracle Configuration Manager (OCM)
– SQL Developer
– Warehouse Builder (server-side pieces)
– Oracle Database Vault
* Note: there is new patch called Hot patch which can be applied with database online (don't need to shutdown your database when applying patch. Isn't it cool?) But not all patches have hot patch.
• Removal of certain products and features from the installation:
– OEM Java Console
– Raw storage support for data files (installer only)
– Oracle Data Mining Scoring Engine
– Oracle Workflow
– iSQL*Plus
• Better conformance to OFA in the installation:
– Prompt for ORACLE_BASE explicitly
– Warnings in the alert log when ORACLE_BASE is not set
*Note: run SQL script. (utlu111i.sql) to analyzes the database to be upgraded before upgrade to oracle 10g
The Pre-Upgrade Information Tool checks for:
• Database version and compatibility
• Redo log size
• Updated initialization parameters (for example,SHARED_POOL_SIZE)
• Deprecated and obsolete initialization parameters
• Components in database (JAVAVM, Spatial, and so on)
• Tablespace estimates
– Increase in total size
– Additional allocation for AUTOEXTEND ON
– SYSAUX tablespace
*Note: the steps for upgrading to oracle 11g from 10g
1. upgrade oracle software (run utlu111i.sql before upgrade)
2. Upgradae database to 11g (SQL> STARTUP UPGRADE)
3. Run utlu111s.sql to display the results of the upgrade
Prepare to Upgrade
1. Become familiar with the features of Oracle Database 11g, Release 1.
2. Determine the upgrade path.
3. Choose an upgrade method.
4. Choose an OFA-compliant Oracle home directory.
5. Prepare a backup and recovery strategy.
6. Develop a test plan to test your database, applications,and reports.
• Direct upgrade to 11g is supported from 9.2.0.4 or higher, 10.1.0.2 or higher, and 10.2.0.1 or higher.
• Examples
– 7.3.4 -----> 9 .2.0.8 -----> 11.1
– 8.1.7.4 -----> 9.2.0.8 -----> 11.1
Upgrade Method
1. Database Upgrade Assistant (DBUA)
– Automated GUI tool that interactively steps the user through the upgrade process and configures the
database to run with Oracle Database 11g, Release 1
2. Manual upgrade
– Use SQL*Plus to perform. any necessary actions to prepare for the upgrade, run the upgrade scripts, and
analyze the upgrade results.
Key DBUA Features
• Configuration files
– Creates init.ora and spfile in the new ORACLE_HOME
– Updates network configurations
– Uses OFA-compliant locations
– Updates database information on OID
• Oracle Enterprise Manager
– DBCA allows you to set up and configure EM DB Control.
– DBCA allows you to register a database with EM Grid
Control.
– If EM is in use, DBCA enables you to upgrade the EM catalog and make the necessary configuration changes.
• Logging and tracing
– Writes detailed trace and logging files (ORACLE_BASE/cfgtoollogs/dbua/<sid>/upgradeNN)
• Minimizing down time
– Speeds up upgrade by disabling archiving
– Recompiles packages in parallel
– Does not require user interaction after upgrade starts
• Security features
– Locks new users in the upgraded database
• Real Application Clusters
– Upgrades all nodes
– Upgrades all configuration files
Command-Line Syntax
• Silent mode run $ dbua –silent –dbName <Oracle database>
• Backup location $ dbua –backupLocation
• Custom scripts $ dbua -postUpgradeScripts
• Initialization parameters $ dbua –initParam
• Help $ dbua -help
• EM configuration $ dbua –emConfiguration
*Note: • Set the COMPATIBLE initialization parameter to 11.1 to make full use of the Oracle Database 11g, Release 1 features.
– 10.0.0 is the minimum compatibility required for 11.1.
Deprecated Features in Oracle Database 11g, Release 1
• Oracle Ultra Search
• Java Development Kit (JDK) 1.4
• CTXXPATH index
• To migrate to automatic undo management:
1. Set UNDO_MANAGEMENT=MANUAL.
2. Execute your workload.
3. Execute the DBMS_UNDO_ADV.RBU_MIGRATION function.
4. Create an undo tablespace based on previous size result.
5. Set UNDO_MANAGEMENT=AUTO.
• UNDO_MANAGEMENT not set implies AUTO mode.
Hot Patch
• Applying a hot patch does not require instance shutdown, relinking of the Oracle binary, or instance restart.
• OPatch can be used to install or uninstall a hot patch.
• OPatch detects conflicts between two hot patches, as well as between a hot patch and a conventional patch.
• Hot patches may not be available on all platforms.
• Some extra memory is consumed.
• There may be a small delay (a few seconds) before every Oracle process installs or uninstalls a
• Not all bug fixes and diagnostic patches are as a hot patch.
• Use hot patches in situations when down time feasible.
• When down time is possible, you should install relevant bug fixes as conventional patches.
相关阅读:
- Oracle 层次查询 小结 (yanbo_shu, 2008-1-12)
- 金蝶举办应用开发商认证培训,完善合作伙伴生态链 (dg0769, 2008-1-13)
- Oracle ERP & Oracle EBS 春节财务班开始报名了 (lululu3898, 2008-1-14)
- 学习笔记之-100小时学会SAP(18) (斓芯, 2008-1-23)
- 首期“友商在线管理服务”应用实务培训讲座在深结束 (kdbos, 2008-1-24)
- 学习笔记之-100小时学会SAP(19) (斓芯, 2008-1-25)
- 学习笔记之-100小时学会SAP(20) (斓芯, 2008-1-25)
TAG: Oracle oracle ORACLE 笔记 培训