Oracle 11g New Features for Database Administrators (DBA)
1.Installation, Database Upgrades and Change Management
• Installation New Features Support
• Role and Privilege Changes
• Deprecated Components
• New Initialization Parameters Affecting Database Creation
• DBCA Enhancements
• Upgrading to Oracle Database 11g
• Database Replay
• The SQL Performance Analyzer
• Patching in Oracle Database Control
2.Database Diagnosis and Repair
• Introducing Automatic Diagnostic Repository (ADR)
• Configuring the ADR
• Using adrci Tool
• Using The Support Workbench in the OEM
• Database Health Monitor
• Data Recovery Advisor
• SQL Test Case Builder
• Data Block Corruption Parameters
3.Database Administration
• Automatic Memory Management
• Automatic Maintenance Tasks
• Oracle Flashback-Related New Features
• Flashback Data Archive
• Oracle Flashback Transaction Backout
• Virtual Columns
• New Data Partitioning Schemes
• DDL Lock Timeout
• Explicit Locking of Tables
• Invisible Indexes
• Read-Only Tables
• Shrinking Temporary Tablespaces and Tempfiles
• Creating an Initialization Parameter File from Memory
• Restore Point Enhancements
• Database Resident Connection Pooling
• Comparing and Synchronizing Database Objects
• SQL*Plus New Features
• Online Application Maintenance
• Oracle Advanced Compression Option
• Oracle Scheduler New Features
• Lightweight Jobs
• Remote External Jobs
• Finer-grained Dependency Management
• Enhancements in Oracle Database Resource Manager
4.Performance Tuning
• PL/SQL Native Compilation
• Server Result Cache
• Client Side Result Cache
• Enhanced Oracle Process Monitoring
• Subprogram Inlining
• SQL Tuning Automation
• SQL Access Advisor Enhancements
• Changing Statistics Preferences
• Enhanced Statistics Maintenance
• SQL Plan Management
• ADDM New Features
• AWR New Features
• Setting Metric Thresholds for Baselines
• Performance-Related Changes in Database Control
• Miscellaneous New Performance Tuning Features
• Real-Time SQL Monitoring
5.Database Security
• Stronger Password Hash Algorithm
• Security Out of the Box
• Anti Network Attacks Parameters
• Tablespace Encryption
• Fine-Grained Access Control for UTL* Packages
• Further Security New Features
6.Backup and Recovery New Features
• Enhanced Block Media Recovery
• RMAN Substitution Variables
• New RMAN Configuration Parameters
• The Multisection Backups
• Creating Archival Backups
• VALIDATE Command
• Configuring an Archived Redo Log Deletion Policy
• Active Database Duplication
• Importing and Moving Recovery Catalogs
• Virtual Private Catalogs
• Miscellaneous New Features in RMAN
7.Data Pump Utilities
• Compression Enhancement
• Encryption Enhancements
• Reusing a Dump File
• Remapping Data
• Renaming Tables During Export or Import
• Data Pump and Partitioned Tables
• Ignoring Nondeferred Constraints
• External Tables Based on Data Pump Driver
• Enhancement in the Transportable Parameter
8.Automatic Storage Management (ASM)
• SYSASM Privilege and OSASM Group
• Upgrading ASM using DBUA
• Upgrading ASM Manually
• ASM Restricted Mode
• Diskgroup Attributes
• Checking Diskgroup
• asmcmd Utility Commands
• Fast Rebalance
• Miscellaneous ASM New Features
9.PL/SQL New Features
• PL/SQL New Features
10.Data Warehousing
• SecureFiles
• Accessing a LOB Using SQL and PL/SQL
• Online Redefinition
• Partition Change Tracking (PCT)
• PIVOT Operator Enhancements
• Partitioning Improvements
Showing posts with label Oracle 11g. Show all posts
Showing posts with label Oracle 11g. Show all posts
Tuesday, March 31, 2009
Oracle 11g Deprecated Components
Oracle 11g Deprecated Components
Following are the components deprecated in Oracle 11g:
o iSQL*Plus
o Oracle Workflow
o Oracle Enterprise Manager Java Console
o Oracle Data Mining Scoring Engine
o Raw storage support (installer only)
Following are the components deprecated in Oracle 11g:
o iSQL*Plus
o Oracle Workflow
o Oracle Enterprise Manager Java Console
o Oracle Data Mining Scoring Engine
o Raw storage support (installer only)
Friday, January 30, 2009
Upgrading form Oracle 10g to 11g and Configuring Oracle Apex
After Upgrade 10g to 11g Oracle Apex
Note : Oracle Application express comes default with Oracle 11g Database,we have to configure ..
Install Oracle 11g Apex
cd $ORACLE_HOME/apex
create apex tablespace
(eg. create tablespace apex datafile '/db/orcl/apex01.dbf' size 1024M;)
sqlplus '/as sysdba'
SQL>@apexins apex apex apex TEMP /i/ none
Thank you for installing Oracle Application Express.
Oracle Application Express is installed in the FLOWS_030000 schema.
The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
-- Updating user account expiration. -------
timing for: Upgrade
Elapsed: 00:00:00.13
JOB_QUEUE_PROCESSES: 10
Performing Application Express component validation - please wait...
Completing registration process.
Validating installation.
timing for: Validate Installation
Elapsed: 00:02:43.26
timing for: Complete Installation
Elapsed: 00:13:14.01
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @apxconf.sql
PORT
----------
8080
Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
Enter a password for the ADMIN user [] oracle
Enter a port for the XDB HTTP listener [ 8080] 8080
...changing HTTP Port
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
User altered.
SQL> @apex_epg_config.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Enter value for 1: /u02/app/product/11.1.0/db_1
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/u02/app/product/11.1.0/db_1/apex/images'
Directory created.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:03:04.41
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
SQL>Col Comp_name Format a35
Col Status Format a12
Select Comp_name, status, Version
From Dba_Registry
Order by Comp_name;
COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
JServer JAVA Virtual Machine VALID 11.1.0.6.0
OLAP Analytic Workspace VALID 11.1.0.6.0
OLAP Catalog VALID 11.1.0.6.0
Oracle Application Express VALID 3.0.1.00.08
Oracle Data Mining VALID 11.1.0.6.0
Oracle Database Catalog Views VALID 11.1.0.6.0
Oracle Database Java Packages VALID 11.1.0.6.0
Oracle Database Packages and Types VALID 11.1.0.6.0
Oracle Enterprise Manager VALID 11.1.0.6.0
Oracle Expression Filter VALID 11.1.0.6.0
Oracle Multimedia VALID 11.1.0.6.0
COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
Oracle OLAP API VALID 11.1.0.6.0
Oracle Rules Manager VALID 11.1.0.6.0
Oracle Text VALID 11.1.0.6.0
Oracle Workspace Manager VALID 11.1.0.6.0
Oracle XDK VALID 11.1.0.6.0
Oracle XML Database VALID 11.1.0.6.0
Spatial VALID 11.1.0.6.0
Note : Oracle Application express comes default with Oracle 11g Database,we have to configure ..
Install Oracle 11g Apex
cd $ORACLE_HOME/apex
create apex tablespace
(eg. create tablespace apex datafile '/db/orcl/apex01.dbf' size 1024M;)
sqlplus '/as sysdba'
SQL>@apexins apex apex apex TEMP /i/ none
Thank you for installing Oracle Application Express.
Oracle Application Express is installed in the FLOWS_030000 schema.
The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
-- Updating user account expiration. -------
timing for: Upgrade
Elapsed: 00:00:00.13
JOB_QUEUE_PROCESSES: 10
Performing Application Express component validation - please wait...
Completing registration process.
Validating installation.
timing for: Validate Installation
Elapsed: 00:02:43.26
timing for: Complete Installation
Elapsed: 00:13:14.01
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @apxconf.sql
PORT
----------
8080
Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
Enter a password for the ADMIN user [] oracle
Enter a port for the XDB HTTP listener [ 8080] 8080
...changing HTTP Port
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
User altered.
SQL> @apex_epg_config.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Enter value for 1: /u02/app/product/11.1.0/db_1
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/u02/app/product/11.1.0/db_1/apex/images'
Directory created.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:03:04.41
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
SQL>Col Comp_name Format a35
Col Status Format a12
Select Comp_name, status, Version
From Dba_Registry
Order by Comp_name;
COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
JServer JAVA Virtual Machine VALID 11.1.0.6.0
OLAP Analytic Workspace VALID 11.1.0.6.0
OLAP Catalog VALID 11.1.0.6.0
Oracle Application Express VALID 3.0.1.00.08
Oracle Data Mining VALID 11.1.0.6.0
Oracle Database Catalog Views VALID 11.1.0.6.0
Oracle Database Java Packages VALID 11.1.0.6.0
Oracle Database Packages and Types VALID 11.1.0.6.0
Oracle Enterprise Manager VALID 11.1.0.6.0
Oracle Expression Filter VALID 11.1.0.6.0
Oracle Multimedia VALID 11.1.0.6.0
COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
Oracle OLAP API VALID 11.1.0.6.0
Oracle Rules Manager VALID 11.1.0.6.0
Oracle Text VALID 11.1.0.6.0
Oracle Workspace Manager VALID 11.1.0.6.0
Oracle XDK VALID 11.1.0.6.0
Oracle XML Database VALID 11.1.0.6.0
Spatial VALID 11.1.0.6.0
