Oracle Study Guide

For 10g OCP DBA
  • Home
  • Site Map
  • Applying a patch

    Patching 20.11.2008 Comments Off

    unzip the patch then run:

    adpatch defaultsfile=$APPL_TOP/admin/<INST_NAME>/adalldefaults.txt  patchtop=<path_to_top_patch_dir>

  • Patching

    Patching 21.10.2008 Comments Off

    Get release number:

    select RELEASE_NAME from fnd_product_groups;

    See if a patch has already been applied:

    select bug_number from AD_BUGS where bug_number =’&patch_no’;

Category:

  • Administration
    • ASM
    • BLOCK SIZE
    • Database Recovery
    • DBVERIFY
    • GRANTS
    • OEM
    • REDO LOGS
  • APPS
    • AutoConfig
    • Change EBS IP Address
    • Cloning
    • DB Environment Vars
    • Discoverer
    • Environment Vars
    • Patching
    • Problems
    • Resources Online
    • Tricks & Tips
    • Upgrading
    • Workflow
  • Backup & Recovery
  • Certification
  • Configuration
  • DATABASE STRUCTURE
    • Data Dictionary
    • Logical Database Structure
    • Physical Database Structure
    • SCHEMA
  • DATAGUARD
  • Documentation
    • ASM (Automatic Storage Magement)
    • Command Reference
    • DataPump
    • Documentation Library
    • SQL Developer
  • EBS
  • Enterprise Manager
  • FLASHBACK
  • HACKING
  • HEADS UP
  • Installation
    • RAC
  • JDeveloper
  • Linux
  • NXclient/server
  • Online Resources
  • PERL
  • python
  • RMAN
    • RMAN Catalog Setup
  • Scripts
  • Serial-Parallel-Port-Testers
  • SNMP
  • Software
  • Solaris
  • Spiritual
  • SQL & PL/SQL
  • SQLPLUS
  • Startup/Shutdown
  • Streams
  • Tuning
    • INDEXES
    • SQL Tuning
      • TKPROF and sql_trace
  • VNC
  • Windows XP
© Blogname. All Rights Reserved. Entries RSS Comments RSS Login Open Source