Oracle Database Blog

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.
– Startup and Shutdown phases.
– 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.
– Oracle Processes.
– Block Extent Segment.

ASM:
– ASM
– ASM memory_max_target and memory_target
– 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:
– markup html on .
– 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
– Oracle Text Indexes  (link: https://iwebsurfer.wordpress.com/2022/12/20/oracle-text-indexes/)

 

Scripts:
– memory used by each session
– recommendations for DB errors
– drop private database link as “sys”
– create private db link as “sys”
– Session Details for a Given Time Period
– time taken by a sql_id
– generating trace
– running a script in the background.
– user info
– grant on multiple tables
– sessions related
– gather statistics
– my sid
– skipping corrupt blocks while backing up a database with RMAN.
– stale statistics
– tablespaces – misc
– DB Health Check Shell script for output as html over mail – Private
– Query to find roles, privs, obj privs for a schema.
– RMAN restore status.
– parallel delete.
– crsctl formatted output.
– Removing special characters (^M / Control M).
– Sync Check Monitoring between Standby and Primary.
– DB State – A shell script approach.
– 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:

– crsctl formatted output
– relocating scan listener
– 2-node Oracle 11g RAC on VMWare with OpenFiler
– ASM memory_max_target and memory_target
– crs_stat customized
– Case: Unable to start one 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:
– switchover pre-checks
– Important Dataguard Docs
– Correct SCN number and Log gap resolution.
– 11g Standby build – Step by Step
– 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.

 

Goldengate:

• Basic GG replication
•  

 

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

 

Exadata:
– Exadata Events
– exadata commands and outputs

 

Python: 
– Date and Time

 

Tours and Travel:
– Kukke Subramaniam Swamy Temple

 

Generic:
– AADHAR and Biometics-lock / unlock
– Add date and time in an excel cell, automatically