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:
– 2-node Oracle 11g RAC on VMWare with OpenFiler.
– SGA and PGA.
– Startup and Shutdown.
– 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:

– – 2-node Oracle 11g RAC on VMWare with OpenFiler.
– 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.

21 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

  8. September 2, 2014 12:36 AM

    Quality content is the key to attract the people to go
    to see the web site, that’s what this website is providing.

  9. December 13, 2016 8:29 AM

    Thank you for publishing this awesome article. I’m a long time reader but
    I’ve never been compelled to leave a comment. I saved
    your blog in my rss feed and shared it on my Twitter.
    Thanks again for this great article!

  10. May 9, 2017 8:28 PM

    I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored subject matter stylish.
    nonetheless, you command get bought an edginess over that you wish be delivering the following.
    unwell unquestionably come more formerly again as exactly the same nearly a lot often inside
    case you shield this increase.

    • May 24, 2017 5:27 PM

      Thank you for the comment. Its been very long I updated my blog. Coming months will have a fresh load of 12c and Exadata.

  11. June 11, 2017 7:04 AM

    I used to be able to find good advice from your blog articles.

    • June 20, 2017 6:15 PM

      Thank you for your comments. I have uploaded a post on installing Oracle 2 node RAC on Vmware with OpenFiler under “RAC” section. Any sort of feedback is highly appreciated.

  12. June 20, 2017 12:32 AM

    This is a topic that is near to my heart… Take care! Exactly where are your contact details though?

    • June 20, 2017 6:14 PM

      Thank you for your comments. I have uploaded a post on installing Oracle 2 node RAC on Vmware with OpenFiler under “RAC” section. Any sort of feedback is highly appreciated.

  13. June 24, 2017 11:04 PM

    bookmarked!!, I love your web site!

  14. July 17, 2017 6:57 PM

    This web site is really a walk-through for all of the info you wanted about this and didn’t know who to ask. Glimpse here, and you’ll definitely discover it.

  15. July 18, 2017 2:46 AM

    I will right away snatch your rss feed as I can not to find your email subscription hyperlink or newsletter service. Do you’ve any? Please allow me realize so that I may subscribe. Thanks.

    • July 27, 2017 7:20 PM

      Hi,
      Not aware of any option as such on wordpress. Let me know, and I will have it enabled. And, THANK YOU for your comments.

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