All Posts

• DWH Terms
• Hadoop Components
• Call Detail Record Generator
• Import ERWin Data Model into Visio
• SQL Queries for DMVs
• tempdb shrink error : File ID of database was skipped because the file does not have enough free space to reclaim
• SQL Server logs, changing level of logging
• How to truncate SQL Server Transaction Log
• SQL Server Permissions of Fixed Database Roles
• Installing, Upgrading PERL Packages
• SQL Server Error Messages
• SQL server SQLDIAG Utility
• SQL Server | How to create a Read Only User/Role
• TSQL | Delete All Objects from Database
• What patches are applied to my SQL Server
• How to use SP_CONFIGURE in SQL Server
• SQL Server Maintenance Scripts : YourSqlDba & SQL Server Maintenance Solution
• How to create a new named instance under SQL 2005/2008
• How to locate SQL server clustered database & it's properties
• Streams | ORA-24082 while disabling a propagation job
• Streams - Capture Process States
• Useful Tables and Views, for Troubleshooting Streams Issues
• Identify Issues and Fix Streams Capture Process
• Cloning Oracle Clusterware (Applicable only to 11.2.0.2.0 and not for any previous Releases)
• Streams/RAC and Database Link Problem
• Streams Performance Data Collection Tools for 10g & 11g
• 11gR2 RAC-Dataguard Sync issue Between Primary & Standby
• Setting up Bidirectional Streams SCHEMA Replication
• Building Tablespace Growth Report from Grid Data
• Oracle Roles and Users audit report
• Streams Replication| Monitoring Streams Capture Processes
• Streams Replication | Monitoring Streams Queues and Propagations
• Streams Replication| Monitoring Oracle Streams Apply Processes at Destination Server
• Monitoring Streams Replication| How to Display Detailed Information About Apply Errors?
• Linux - List file count by Day
• Oracle Streams Introduction
• Finding Backup details from 11g RMAN respository tables
• 11g Grid | Monitoring Management Services and Repository
• Grid false alert "Agent to OMS communication is broken"
• DataGuard Monitorable (Read-Only) Database Properties
• How to Safely Remove a Data Guard Broker Configuration under RAC/NON-RAC setup
• Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]
• Script to Collect Data Guard Primary Site Diagnostic Information [ID 241374.1]
• Understanding 11g Grid Directory Structure , Config & Log files
• Oracle Enterprise Manager to 10g Grid Migration Process
• 11g Grid | How to manually clear EM Grid Control alerts
• How to create SSH tunnels to get around Firewall
• How Grid Enterprise Manager Determines Host and Management Agent Availability
• 11g Grid | Creating and Comparing a Baseline
• Digging deep in Oracle Grid Repository for Information
• GRID 11g| User-Defined SQL Metric alert if a query TOPs CPU Time
• 11g RAC | Using Duplicate target database 11g Active Database option
• Modifying the Default Login Timeout Value for Grid Control 10g/11g
• Replicating RAC database using RMAN at Remote Server
• 11g Grid | Fixing Incident (BEA-101020 [HTTP]) detected in ..Middleware/gc_inst/user_projects
• 11g |Monitoring DataGuard using Broker Commands
• Cleaning up a machine with previous Oracle 11g Clusterware/RAC install
• Oracle 11g Grid| How to add custom shell script to raise user defined alert/notification
• Oracle 11g Grid| How to add a custom SQL UDM (User Defined Metric)
• Oracle 11g Grid | Remove failed EM Agent
• IBM Web Server Plug-in Analyzer for WebSphere Application Server
• Installing Tivoli Common Agent Services Agent/Manager
• Oracle 11g Grid : Using EMCLI to run Remote OS Commands
• Oracle 11g Grid: Using EMCLI , A command line Grid Control Interface
• Oracle 11g Grid | How to stop and start OMS Services
• Oracle 11g Grid | Setting Preferred Credentials to avoid Priv Warnings
• 11g Grid | Where to Locate AWR reports
• Oracle Grid | Tracking OS procsses using User Defined Matrix (UDM)Shell Script
• DMGR HA: How to backup websphere deployment manager for a Disaster Recovery
• Oracle 11g Grid | Installing Grid Agent using "agentDownload" method
• Jython Script to list websphere ports
• Adding Another IBM Http Server Instance at Websphere
• IBM ISA MustGather : Using IBM Support Assistant Lite (ISA Lite)
• Websphere : Using Collector.sh Tool for uploading details to IBM Support
• Websphere : Plug-in Workload Management Failover
• Jython script to Display Websphere Topology
• Websphere : Installing default Applications
• Websphere: Purging first failure data capture log files
• Websphere : Web Server Plug-In Retry Interval
• Dataguard: Recovering lost broker configuration files: Clear Old Configuration & Add New One
• ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at Dataguard Switchover
• Shell Script to Generate Daily/Weekly AWR reports (Email)
• Dataguard : Activating Standby (Failover) when Primary is Down
• Dataguard : ORA-16826 apply service state is inconsistent when changing mode to MaxProtection
• Dataguard : EDIT CONFIGURATION (Change Protection Mode)
• Summary of DGMGRL Commands with Example
• Jython Scripts for Websphere Administration
• DGMGRL : ORA-16789: standby redo logs not configured/ORA-16826: apply service state is inconsistent with the DelayMins property
• Creating Oracle Dataguard Primary/Standby DB on a Single PC
• Websphere 6.1 Network Deployment RHEL 5.x - Silent Install
• Difference between IBM & SUN JVM/ Porting J2EE applications
• Dataguard : Applying CPU(Cirital Patch Update) to Dataguard Environment
• Websphere: startManager.sh doesn't work while startServer.sh does
• Installing application(EAR/WAR) thru wsadmin
• Jython script to pull out stats from websphere
• How to Locate unix process active on a specific Port
• WebSphere Monitoring : Wasstat.sh to parse offline PervServletApp XML output
• Websphere : How to apply a Fix Pack
• Dataguard: Shell script to List Archive gap between Primary & Standby
• Compare Websphere Configuration Details : Visual Configuration Explorer (VCE)
• EM GRID: How to Change DB Console Http Port
• Standalone 11g dbconsole Configuration
• set bash prompt
• Websphere : Change application server ports
• GSK_ERROR_BAD_CERT error configuring SSL between Plug-in and Application Server V6.1
• Wsadmin Details
• Websphere : How to change HOSTNAME using ws_ant scripts
• Websphere : Jython script to return performance matrix details of Node
• Time Travel & Websphere Node/Deployment manager synchronisation
• Weblogic : Monitor Weblogic through command line
• Creating Users /Groups at Websphere
• Script to Auto Start Primary/Standby Database under Linux
• Websphere : How to Create Self Signed SSL Certificate for HTTPServer
• Clone a WebShere installation on another server
• Websphere : Jython stop & start server scripts
• Jython Script : Get websphere Server Details
• JACL Script : Get server status & OS details before deployment
• Websphere ND Install under Windows :Create DMGR, AppServer profile
• Websphere ND Install: Install IBM HTTP Server
• IBM Support Assistant: using Thread & Monitor dump analyzer
• IBM Support Assistant: using Thread Analyzer
• Websphere Diagnostics: Create & Analyze Trace Files
• Is my websphere configured in Development Mode?
• Trend Oracle log history : How much archives created per day/week or in an hour
• Websphere: Using PerformanceMonitor Servlet to Monitor Performance Metric
• Monitoring Application Performance using Websphere Request Metrics
• Monitor SSL Certificate Expiration/Replace Expired SSL Certificates Automatically
• How to Locate Connection Leak in Websphere
• Websphere Dmgr- Node Synchronization : WSX509TrustMa E CWPKI0311E
• Oracle FlashBack Error : ORA-16014: log 3 sequence not archived, no available destinations
• Configuring Websphere Plugin with NAGIOS Monitoring System
• Websphere Administrative Security ON/OFF
• How to Create and Install websphere Self Signed Certificates
• How to use Log Analyzer at IBM Support Assistant Workbench
• Websphere : Node Synchronise problem
• Where to download Websphere Fix Pack
• Websphere Diagnostic & Tuning Tools : IBM Support Assistant Workbench
• Websphere Garbage Collection : How it's done
• WebSphere Security: Switch off username/password prompt while shutting down services
• Websphere HTTP plugin failover in a clustered environment
• How to Analyze JVM logs (SystemOut.log, SystemErr.log & startServer.log)
• Diagnosing IBM Websphere Service logs
• Setting the session timeout for the administrative console
• Websphere File Synchronization Service: Replicate changes from Dmgr to NodeAgent
• Logging commands executed through Websphere(WAS) Admin Console
• Where is Websphere profile config stored
• Websphere Routing a Request using Plugin-cfg.xml
• Websphere : Deploy/Update J2EE Application using GUI Deployment Manager
• How to Install SSL certificate under Websphere/Http server
• Websphere Application Server Clusters
• Websphere Silent Installation
• Websphere : Federation of the WAS nodes
• Websphere : Deploy an Application using GUI Deployment Manager (Dmgr)
• Websphere Application Server Security
• Websphere Clustering and Work Load Management
• Websphere Application Server Logs
• Script to auto-start Websphere services on RHEL after a reboot
• Monitor/List Apache Active Connections : Websphere JVM Connections
• What is Oracle OPatch, How to use OPatch & List patches
• Backup Websphere Configuration using backupconfig.sh
• Archivelogs deleted, Unavailable archive files during rman backup
• Compare and Display difference between 2 Files
• WebSphere : Synchronize Cluster Configuration with Dmgr & Nodes
• Websphere JVM hang issue : How to create heap or thread dump
• Websphere First Failure Data Capture (FFDC) Logs
• Websphere FAQ : Clustering, Deployment Manager & Node Agent
• Websphere Basics
• Tuning Java virtual Machines
• Webspehere java 100% CPU usage : MustGather Information
• Http Error Codes
• Was my rman backup successful?
• Websphere FAQ/Terms Explained
• Weblogic Configuration after Install
• How to Install WebLogic under Windows
• WebSphere Log Files /Logging performance data with TPV
• Websphere Hierarchy of Configuration Documents
• WebSphere Configuration Files
• Administrating WebSphere : Start/Stop/Status, Kill Sessions
• ASM ftp/http Access
• Duplicating an ASM Database at Remote Host
• Oracle 10g script for User/Role/Object Privileges
• Database hanging due to TX-Transaction (row lock contention)
• Identifying Blocking Locks/ Contention & Resolving Database Hanging Issue
• PLSQL Help: Execute Immediate with Parameters
• The Oracle 10g Scheduler
• How to Convert Physical Machines to Virtual Machines with VMware Converter
• Maintain RMAN Catalog
• Rman Script to Create Standby/Duplicate database using RMAN
• Remove Failed Clusterware
• 11g RAC : Download & Install cluvfy(Cluster verify) Utility
• SQLIO SAN/Local Disk Subsystem Benchmark Tool
• Database Engine Tuning Advisor : how to Import SQL profiler traces at DTA
• Query Performance : Enable execution plan /IO stastics under SQL server
• SQL Server : How to Enable Intra Query Parallelism
• Troubleshooting Bottlenecks Using Dynamic Memory Views : Part III
• Troubleshooting Bottlenecks : Using SQL Server Profiler & Windows System Monitor Together
• Troubleshooting Bottlenecks Using SQL Server Profiler : PART IV
• Troubleshooting Bottlenecks Using Windows System Monitor : Part I
• Shell Script to Delete / Copy/ Zip files older than X hours
• Shell Script : Copy files from local folder to a Samba/NFS share
• SQL server Simplest data loading script
• Change EBS Apps Ports
• Healthcheck of EBS Components Using AOL
• An experience with Oracle EBS Patching :Upgrade from 12.0.2 -> 12.0.4
• How to bounce & Debug Apache /Forms : Log files
• Backups and Recovery Options on SQL server
• Using a Maintenance Plan to Backup SQL Databases
• EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..
• SQL Server Transaction Log Shipping Replication
• SQL Server Remote Connection Error : An error has occurred while establishing a connection to the server.
• Maintaining SQL Server High Availability
• Locks,Monitoring SQL Server Pocesses
• AWR : How to run Reports
• Installing Oracle 9.2.0.6 on Red Hat Linux AS release 5 Update 3
• Installing Oracle 10.2.0.1 on Red Hat Linux AS release 4 Update 5 (Nahant Update)
• Views Relevant to Oracle Data Guard
• Multimaster Replication :How to resolve Replication Errors
• 10g RAC Install under RHEL/OEL 4.5
• Compare and copy files remotely using SCP
• Using adadmin to compile an Apps environment
• Disk Space Required for EBS 11i & 12
• Multi Node to Single Node Cloning
• Best way to check patches on Metalink
• How to deploy form on server
• Log4plsql for PL/SQL Logging
• Introduction to Oracle Payables : Concepts
• Oracle HRMS Overview : Concepts
• AD and Other Utilities
• Write a Message to the Alert Log
• How to Configure Notifications at Grid
• Delete Host from OMS using Database API | Removing a target from OMS
• How to start database and Apps
• Oracle RDBMS Release Nomenclature
• E Business Suite Release 10.7/11.0.x/11i.5.x/12 Component Details
• Troubleshooting OAS Instance
• Monitoring Oracle E-Business Suite.
• How do users interact with Oracle Applications - Part 2
• Steps to clone Oracle Applications database from PROD to TEST
• Installing Oracle Applications R11.5.10.2 Under Windows
• Change Display Name Of Targets In a Grid Control
• RMAN Offline Backup Script
• Manually resolve archive log gap/ Recover Standby / Manual Standby recovery
• 10g Grid : Start OMS /Stop OMS/Restart OMS
• 10g Grid : Troubleshooting Grid Control/ Grid Log files
• 10g Grid | EM Agent Deploy Log Files
• Display execution plan in SQLPLUS - plan_table script
• Oracle Enterprise Manager 10g Grid Control Extensions Exchange
• Installing Management Agent using Push method from OMS
• Using the Job System : schedule/list Jobs
• Changing a Threshold
• Upload failed with ret=-10 / Agent is Running but Not Ready
• Install and Admin OMS (Oracle Management Service) Grid Console
• Installing & Configuring Oracle grid Agent (UNIX Standalone/Clustered Install)
• Upload failed with ret=-10 / Agent is Running but Not Ready : Clustered node install
• Replication views taking longer to return results/ Truncate views
• Network Statistics (netstat)
• Clone Agent Configuration
• Metric Collection Error
• Virtual Memory Statistics ( vmstat )
• Oracle Installer Failed : TMP space problem
• Input Output statistics ( iostat )
• Useful Oracle DBA Linux Commands
• ADD/REMOVE/REPLACE/MOVE Oracle Cluster Registry (OCR) and Voting Disk
• RAC Build on Solaris: Fifth Phase
• RAC Build on Solaris : Fourth Phase
• RAC Build on Solaris : Third Phase
• RAC Build on Solaris : Second Phase
• RAC Build on Solaris : First Phase
• RAC Build on Solaris, Step-By-Step
• Compare 9i Statspack & 10g AWR Views
• How to Recover Standby from Primary Database
• How to setup RMAN catalog for Backups
• Display partition information for a specified index
• Undo Retention , Undo Optimization
• Do I need to reorganise my table?
• Oracle Undocumented Parameters
• ORA-00312: Message 312 not found; Solution
• Flashback Query
• Function Based Indexes
• When to Rebuild a B-Tree Index
• Index Monitoring
• Building virtual index using the NOSEGMENT clause.
• Selecting the Best Join Order : Methods Oracle Uses to Join Tables
• Sid from Unix Process ID
• Find out SGA PGA Size
• Statspack Scripts
• API to Retrieve runtime Replication Parameters
• How to enable trace in Oracle
• FAN (Fast Application Notification) & ONS (Oracle Notification Services)
• How does the failover mechanism work?
• Can't convert a Table Space into Read Only Mode
• TAF can be verified by querying the Oracle-provided views
• Rectify Differences Between Replicated Tables
• Tuning SQL to drop execution cost
• Get the current Session ID
• Loading or Re-Synchronising Data in a Replication Cluster
• Replication Packages/Triggers Missing at new site : ORA-04067: stored procedure OBJECT_NAME$RP does not exist
• Average Amount of Time to Apply Transactions at Remote Sites
• Tracking the Rate of Transactions Entering the Deferred Transactions Queue
• Tracking the Average Number of Row Changes in a Replication Transaction
• Determining the Average Network Traffic Created to Propagate a Transaction
• Listing General Information About the Error Transactions at a Replication Site
• Delete Errors (Transaction Queue, Errors)
• Delete MASTER Node: Rollback ADD_NEW_MASTERS Procedure
• Replication SQL Scripts
• Push Replication Group to NORMAL Status in an Exceptional Case
• Enable Archivelog, Put Database into ARCHIVE mode
• Drop/Delete Multi-Master Replication
• Add a new node using ADD_MASTER_DATABASE : Group Quiescing Method
• Monitoring Performance in a Replication Environment
• Monitoring Purges of Successfully Propagated Transactions
• Monitoring the Deferred Transactions Queue
• Oracle Advanced Replication :Monitoring Administrative Requests
• List General Information About Master Groups & replication activity
• Oracle Advanced Replication | Listing the Master Sites Participating in a Master Group
• An example of Conflict Resolution Method
• ORA-02055: distributed update operation failed; rollback required
• ORA-23419: regenerate replication support before resuming master activity
• MultiMaster Replication | Alter objects into Existing Mutimaster Group
• Dynamic Replication Views
• How to setup 2 Way MultiMaster Replication?
• Oracle Advanced Replication | Remove or Delete Master Site from a Master Group
• What is a "QUIESCED mode"
• Oracle Advanced Replication - Administration Tasks (Concepts/no SQL)
• Adding a new Master Node in an existing Multi Master Cluster
• Replication Error "QUISCED" Group. How to use DBMS_DEFER_SYS.EXECUTE_ERROR & DBMS_DEFER_SYS.DELETE_ERROR
• Oracle Advanced Replication | Relocating Master Definition Site
• Replication Views / Prerequisites for Advanced Replication
• Add new Node without Quiescing (RMAN SCN Method)
• How optimizer stats with Histograms can change execution Plan
• AWR : How to locate resource limits
• Which sessions are consuming IO bandwidth, Would return SID list
• Identify Master node in RAC cluster
• Bring Cluster Online/Offline
• Managing CRS/ Commands
• Oracle Standby Recovery Rate Monitoring
• Oracle Data Pump
• Summary report of ASM disk groups and Space Utilised
• Performance summary report of all disks contained within all ASM DiskGroups
• Mastering ASMCMD
• Display tablespace usage
• Enabling ArchiveLog Mode in a RAC Environment
• Oracle Clusterware Administration Quick Reference
• Analyze database for right statistics
• How to Backup/Export Oracle Optimizer Statistics into Table
• Locate Hard hitting SQL from Statpack Repository
• Locate Server Workload from Statspack for days in Past
• How to setup RMAN under Windows
• How to Monitor rman Backup ?
• RAC on Windows,Linux with VMWARE, FIREWIRE, NFS
• Why RAC need a VIP (Virtual IP address)
• DDL create commands for Objects (DBMS_METADATA)
• Shell or UNIX OS Commands From PL/SQL
• Identifying a Poor performing SQL
• How to find out hidden and system Parameters?
• ORA 600 Corrupt UNDO/INDEX/TABLE Segment
• Estimate Undo Retention , Undo Optimization
• 10G ASH script :True Session Wait Activity in Oracle 10g
• Complete (recursive) object dependency
• Find execution time for given SQL from Statpack tables
• Resumable Space Allocation / SUSPEND RESUME transactions
• Running SHELL script from Oracle PL/SQL
• What is a database EVENT and how does one set events?
• Rman backup script to backup entire database : level 0
• How to run rda on cluster
• What is causing Redo / Writes/ Log Creation- Statspack 8i/9i
• All OCFS volumes were not available at ocfsconsole config tool
• RAC Backup : Copy 1 set of backup at FLASH & other to ext3 Disk
• EM grid console active only at RAC 1 Instance
• Convert Oracle Enterprise Edition to Standard (DownGrade)
• 10g RAC Management Commands
• AWR : How to purge old Snapshots?
• ORA-29701 : Unable to connect to Cluster Manager while creating new ASM Instance
• ons gsd vip listed OFFLINE at crs_stat
• CRSCTL : Oracle Clusterware Service Administration
• Speeding-Up Oracle Export/Import Migration
• RAC : Managing OCR Backup and Recovering OCR
• ASM Dynamic Views: ASM Instance Information
• RAC/CRS/Voting disk failover Tests
• How to recover from a Loss of Voting Disk
• Using ASM on command line
• Automatically start ASM/Database/EM/LSNR services
• TAF Failover Configuration and Testing
• RAC | How to use SRVCTL Command
• Oracle Clusterware Log/Clusterware log files
• Oracle Installer can't discover ASM disks Ora-15186 Asmlib Error =[ASM_OPEN], ERROR = [1]
• ORA-15186 ASMLIB ERROR FUNCTION = [ASM_OPEN], ERROR = [1], ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
• OCFS2 Support Guide Linux/Solaris
• Creating Data Guard Primary/Standby on 2 Windows Servers
• How to Install Statspack (8i/9i/10g)
• Locate Server Workload for a Defined Timeframe
• How to find current Statspack level?
• Switchover from primary to standby/ Switchover Primary : No Dgmgrl
• A database is creating more than 100 logs every single hour. What is happening ?
• Oracle Performance Tuning | Effect of Optimizer_index_cost_adj parameter on Oracle Execution Plans