Oracle 11g 培训笔记----01 Oracle, 笔记, 培训

下载狂

第一部分的笔记已整理好了，我将会把学习oracle database 11g的心得和笔记不定期在更新我的博客中，同时会尽量与论坛同步。有点比较抱歉的是，我的笔记是用英语来写，不是我故意拽，因为讲课是用英语进行的。
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.

下载狂

我整理资料到半夜。
看贴的朋友，请回个帖，以示鼓励，谢谢
呵呵

calvin

当然要顶啦

feng198148

学习下喽!!ding

ccxxx

can you put it all into a single PDF file?

snowpop

辛苦，感谢

gkb

你太棒了，  不过英文的  水平不行看不懂

gkb

对  你的博克 多少 告诉下