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: