Skip to content

Contents

for ORA_SID in `cat /etc/oratab | grep -v \* | cut -f1 -d ‘:’ |grep -v \OEM* | grep -v ‘#’`
ORA_HOME=`grep $ORA_SID /etc/oratab |cut -d : -f 2`

Basics:
- SGA and PGA.
– Types of Checkpoints.
– Installing Oracle 10g with ASM using ASMLib on Red Hat Linux 5 (32-bit) using VMWare 7.
– Recreate oraInventory (Central Inventory) in Real Application Clusters.
– Oracle Background Processes (ASM & DB).
– When is an INDEX not used.
– Block Extent Segment.



ASM:

- Moving spfile across diskgroups.
– Recreate ASM Diskgroup.
– How to move ASM devices from raw device to block device.
– Cloning/Duplicating controlfile between ASM diskgroups.
– ASM and Load Balancing.

General:

- expdp with “query” option.
– Checkpoint and LRU.
– Switchlogfile vs Archivelog current.
– sqlnet.ora parameters.
– ‘exp’ with query.
– Cleaning SYSAUX.
– Mount Options for Oracle files when used with NAS devices.
– How does oracle use memory on Solaris?
– “init” parameters across versions.
– ADDM reports finding “LNS WAIT FOR LGWR REDO” event impacting Instance.
– SGA_TARGET not increasing.
– .ora files.
– sqlnet.ora parameters.
– “exp” with query.
– Cleaning SYSAUX.
– Mount Options for Oracle files when used with NAS devices
– How does oracle use memory on Solaris?
– “init” parameters across versions
– ADDM reports finding “LNS WAIT FOR LGWR REDO” event impacting Instance.
– SGA_TARGET not increasing
– .ora files- sqlnet.ora
– Tracing the client and the server connection
– LATCH
– Database Characterset
– Semaphores
– Oracle Binaries
– Oracle Environment Variables
– ORDER OF BACKGROUND PROCESSES DURING DB STARTUP
– Wait Events
– v$license
– CPU’s and RAM in UNIX
– Row Chaining and Migration
– Data Blocks, Extents, and Segments
– MEMORY_TARGET on Oracle 11g
– Streams – In short
– OS Watcher
– Meanings of four digits in UNIX permissions
– When does DBWn and LGWR write?
– Manual Non-RAC Database Creation
– Data Pump – Attach Job
– Password protecting the LISTENER
– AWR
– RCONFIG- Standalone to RAC Conversion
– Status in v$log
– Taking a System State Dump and Hang Analyzer Trace
– Cloning an existing ORACLE_HOME on Unix
– OCR-Backup and Recovery
– Locks-A Brief Introduction
– Scheduler Details
– Tracing
– Sum of filesizes in a directory in UNIX
– Extracting Application / User SQLs from a Trace File
– Calculating UNDO
– DB Links and Global Names
– 32 or 64 bit
– Software Downloads
– Mechanics of Datapump Job
– Transportable tablespace export and Import
– Flashback and FRA
– Optimizer Hints
– Contents of the controlfile

Scripts: 

- Database Components and Hidden Parameters.
– Generic script for expdp based backup (UNIX/LINUX) — Private
– How to monitor the progress of running parallel query in Oracle database?
– SLEEP Command.
– SQL to find out foreign key relationships between tables.
– Automating Database Startup and Shutdown on Linux
– Scheduler Details
– Automatic Table Partition Adding and Deleting (for 13 months) with schedudler Job
– IP addresses
– Flashback and FRA
– What is 2>&1 in UNIX scripting
– Deleting Files older than 30 Days
– Finding Any Files Modified in the Past 3 Days
– Finding .txt Files Modified in the Past 3 Days
– Finding Files Larger than 10,000k
– Finding the File Last Touched (Modified) in a Directory
– Finding the File Last Accessed in a Directory
– Finding the Largest Files in a Directory
– Finding the Smallest Files in a Directory
– Finding files(s) containing a string in the present directory
– Instance Uptime
– Database Version
– Finding out the Character Set
– Tablespace Utilization
– SGA Summary
– Object Grants
– Object Count per user per tablespace
– High Water Marks
– Sessions
– Finding Own Session ID
– Top Sessions
– Finding System Process ID from Database SID:
– Session Waits
– Finding waits on a particular SID
– Locks
– Table Locking Information
– Finding out the Long Running Queries
– Active Users
– Amount of Archivelogs being generated
– Redo generated per day
– Mailing the Log Switch Frequency of a Database
– Looping ORATAB
– DB Loop Script- Running a script against all the databases on a node
– Database Patching Details
– DB Instances Script Generator
– Scheduled Task on the DB
– Jobs Schedules
– Inserting data using loop
– Export Import using PIPE
– Simple expdp shell script
– Comparing files using dates
– CPU Utilization per Session
– Kill SESS1 schema Idle Session older than 5 days
– IO
– Database NLS
– Script to recreate a USER with it’s privileges


RAC:

- crs_stat customized.
– Unable to start an instance after upgrade.
– User Equivalence / Password less SSH.
– Recreate ASM Diskgroup.
– Tuning Log and Trace levels for Clusterware 11.2.
– inittab.
– Oracle RAC 10g – Cache Fusion.
– DIAGWAIT for “oprocd”.
– hangcheck-timer Kernel Module.
– Sample RAC pfile.
– Cluster Interconnect in Oracle 10g and 11g [ID 787420.1].
– SCAN IP.
– Finding RAC cluster name.
– Placement of voting and OCR disk files in 10gRAC.
– Major Oracle Clusterware components.
– Instance Recovery in Single Instance Database.
– Database/Instance Recovery in RAC.
– Cluster Verify Utility / runcluvfy.
– Time synchronization in Oracle Clusterware 11gR2.
– Modifying the VIP or VIP Hostname of a 10g Oracle Clusterware Node.
– 9i RAC Cache Fusion recovery.
– 9i RAC Cache Fusion.
– Cleanup after a Failed CRS Install.
– RAC ON /OFF.
– VIP.
– Oracle RAC Cache Coherency.
– Administering OCR-Backup and Recovery.
– Administering Voting Disk.
– How to Change the public IP Address in Oracle RAC.
– crsctl & srvctl commands.
– Where is the Voting disk in ASM in Oracle 11g?
– Oracle RAC load balancing and failover.
– Recreate ASM Diskgroup.

Standby and Dataguard:

- Primary and Standby Control files contents
– Sync Check Monitoring between Standby and Primary.
– Primary and Standby Log Check.
– LOG_ARCHIVE_MAX_PROCESSES — How many?
– Resyncing a Physical Standby with incremental backup from Primary
– Data Guard Protection Modes.
– Renaming a datafile on standby / STANDBY_FILE_MANAGEMENT=MANUAL
– Database Failover
– DR Exercise with FLASHBACK
– 10g Dataguard- Step by Step
– Database Switchover Process.


RMAN:
Catalog Database:
- Dropping the RECOVERY CATALOG.
– Upgrading Catalog Database.
– CATALOG Database Views.
– RESYNC CATALOG.
– RMAN Stored Scripts in the Recovery Catalog.
– Resetting a Database Incarnation in the Recovery Catalog.
– Unregistering a database from Catalog database.
– Cataloging Older Files in the Recovery Catalog.
– Creating RMAN Catalog and Registering a Database.
– Size of Recovery Catalog database per production database.

RMAN:
- RMAN backup scheduler (Private).
– Applying an incremental backup to a physical standby.
– RMAN Sample Output.
– RMAN in GENERAL.
– Migrate Database to ASM using RMAN.
– Cross Platform Transportable Tablespace using RMAN.
– RMAN Format Strings.
– RMAN Backup Encryption.
– Lock on Snapshot Controlfile- waiting for snapshot control file enqueue.

Enterprise Manager:
– Installing  11g OMS.
– EMAgent is Thrashing. Exiting watchdog.
– How to change “sysman” password in OMS Setup using emctl.

7 Comments leave one →
  1. May 23, 2013 8:18 PM

    Admiring the persistence you put into your site and in depth information you provide.
    It’s awesome to come across a blog every once in a while that isn’t
    the same unwanted rehashed information. Excellent read!
    I’ve saved your site and I’m including your RSS feeds to my Google account.

  2. May 26, 2013 9:34 PM

    I was examining some of your posts on this internet site and I believe this site is rattling informative! Continue posting.

  3. May 29, 2013 12:28 AM

    I reckon something truly interesting about your web blog so I saved to bookmarks .

  4. May 31, 2013 5:09 PM

    If some one needs expert view concerning running a blog after that i advise him/her
    to visit this web site, Keep up the nice job.

  5. June 7, 2013 2:59 PM

    Your style is really unique in comparison to other folks I’ve read stuff from. Many thanks for posting when you have the opportunity, Guess I will just book mark this web site.

  6. June 11, 2013 9:58 AM

    Very good writing. This article titled Oracle Database Blog | Blog for Oracle Database by an Oracle DBA satisfied my need to read high quality articles for the day. Quick question, I do some writing myself on a different topic, focusing on vehicle history report. Would it be possible for you to critique my writing when you have some time? I would really appreciate that.

  7. Lynne Drehs permalink
    December 30, 2013 8:21 AM

    Yay google is my king helped me to attain this fantastic internet locate ! .Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: