Transcript Installation

Oracle Installation and
Management in a nutshell
Installation
• Pre-Installation checks:
• Ignore the result:
./runInstaller -ignoreSysPrereqs
Installation - OUI checks
Installation
Oracle Database 11g Installation
Changes
• Addition of new products to the install
• SQL Developer
• Movement of APEX from companion CD to main CD
• Warehouse Builder (server-side pieces)
• Oracle Configuration Management (OCM)
• New Transparent Gateways
• Removal of certain products and features from the installation:
• OEM Java Console
• Oracle Data Mining Scoring Engine
• Oracle Workflow
• iSQL*Plus
Enterprise Manager 11g
• Database Control
Parameters
•
Classes of parameters
228
Advanced
Parameters
29
... some
"_"-Parameters
Basic
Parameters
Automated Routine Tasks:
Backup & Recovery
• Use RMAN
• Use Unified Scheduler to configure
regular, scheduled backups
• Use Recovery Area for on-disk backups
Weekly
Archive
To Tape
• Recovery Area is self-managing
• old files aged out, current files
maintained
• Perform incremental backups
Nightly Apply
Incremental
Backup
• Only changed blocks backed up — fast
and space efficient
• Backed up files can be merged with the
original
Production
• You perform a full database backup only Database
Work Area
once!
Logs &
Backups
Recovery Area
Automated Routine Tasks
• System statistics (statistics_level=typical)
• Every 60 minutes statistical data will be collected, analyzed
and kept for 7 days by default
• Additionally data will be collected and evaluated for active
sessions
• Changes on data inside the database will be monitored in the
background
• Default jobs
• Object statistics
• Free up segments
Default Jobs
• 2 default jobs run once a day in a specified time frame:
• GATHER_STATS_JOB:
Gathering of statistics for the whole database
• AUTO_SPACE_ADVISOR_JOB:
Find out segments with space to free up and with many migrated rows
Instant Client
• For OCI-, OCCI-, Pro*C, ODBC- and JDBCapplications
• No Oracle client installation necessary
• Most simple deployment
•
•
•
•
Download from OTN
Copy it to the target systems
Set TNS_ADMIN
That's all ...*
• http://www.oracle.com/technology/tech/oci/instantclien
t/instantclient.html
* For ODBC a batch file has to be executed because the Windows ODBC management has to be notified
QUESTIONS
ANSWERS