EveryDay practical solutions for an Oracle DBA | All Posts

INCLUDE_DATA

sliding wardrobes door. металлические двери доставка

What is OPatch, How to use OPatch & List patches

Posted By Sagar Patil

Backup Websphere Configuration

Posted By Sagar Patil

Archivelogs deleted, Unavailable archive files during rman backup

Posted By Sagar Patil

Compare and Display difference between 2 Files

Posted By Sagar Patil

Managing profiles under WAS 6.1

Posted By Sagar Patil

WebSphere : Synchronize Cluster Configuration with Dmgr & Nodes

Posted By Sagar Patil

Websphere JVM hang issue : How to take manual heap or thread dump

Posted By Sagar Patil

FFDC(first failure data capture) folder and Logs

Posted By Sagar Patil

Websphere FAQ : Clustering, Deployment Manager & Node Agent

Posted By Sagar Patil

wsadmin Commands

Posted By Sagar Patil

Websphere Basics

Posted By Sagar Patil

Tuning Java virtual Machines

Posted By Sagar Patil

Webspehere java 100% CPU usage : MustGather Information

Posted By Sagar Patil

Http Error Codes

Posted By Sagar Patil

Was my rman backup successful?

Posted By Sagar Patil

J2EE & Websphere terms explained

Posted By Sagar Patil

Weblogic Configuration after Install

Posted By Sagar Patil

How to Install WebLogic under Windows

Posted By Sagar Patil

WebSphere Logging and Tracing

Posted By Sagar Patil

Websphere Hierarchy of Configuration Documents

Posted By Sagar Patil

Working with WebSphere Configuration Files

Posted By Sagar Patil

Administrating WebSphere : Start/Stop/Status, Kill Sessions

Posted By Sagar Patil

ASM ftp/http Access

Posted By Sagar Patil

Duplicating an ASM Database at Remote Host

Posted By Sagar Patil

Oracle 10g script for User/Role/Object Privileges

Posted By Sagar Patil

Database hanging due to TX-Transaction (row lock contention)

Posted By Sagar Patil

Identifying Blocking Locks/ Contention & Resolving Database Hanging Issue

Posted By Sagar Patil

Execute Immediate with Parameters

Posted By Sagar Patil

How to install OBIEE

Posted By Sagar Patil

The Oracle 10g Scheduler

Posted By Sagar Patil

How to Convert Physical Machines to Virtual Machines with VMware Converter

Posted By Sagar Patil

Maintain RMAN Catalog

Posted By Sagar Patil

Create Standby/Duplicate database using RMAN

Posted By Sagar Patil

Remove Failed Clusterware

Posted By Sagar Patil

11g RAC : Download & Install cluvfy(Cluster verify) Utility

Posted By Sagar Patil

SQLIO SAN/Local Disk Subsystem Benchmark Tool

Posted By Sagar Patil

SQL Server : Identifying Databases with Index Fragmentation

Posted By Sagar Patil

SQL Server : Easy and Fast way to check Backup details

Posted By Sagar Patil

SQL Server : Identifying Index Fragmentation

Posted By Sagar Patil

Database Engine Tuning Advisor : how to Import SQL profiler traces at DTA

Posted By Sagar Patil

Query Performance : Enable execution plan /IO stastics under SQL server

Posted By Sagar Patil

How to carry Multi node EBS install... Under progress

Posted By Sagar Patil

Adding Read Only Access to a Grid Control

Posted By Sagar Patil

SQL Server : Intra Query Parallelism

Posted By Sagar Patil

Troubleshooting Bottlenecks Using Dynamic Memory Views : Part III

Posted By Sagar Patil

Troubleshooting Bottlenecks : Using SQL Server Profiler & Windows System Monitor Together

Posted By Sagar Patil

Troubleshooting Bottlenecks Using SQL Server Profiler : PART IV

Posted By Sagar Patil

Troubleshooting Bottlenecks Using Windows System Monitor : Part I

Posted By Sagar Patil

Shell Script to Delete / Copy/ Zip files older than X hours

Posted By Sagar Patil

Shell Script : Copy files from local folder to a Samba/NFS share

Posted By Sagar Patil

SQL server Simplest data loading script

Posted By Sagar Patil

Change EBS Apps Ports

Posted By Sagar Patil

Healthcheck of EBS Components Using AOL

Posted By Sagar Patil

EBS Intro

Posted By Sagar Patil

An experience with Apps Patching

Posted By Sagar Patil

How to bounce & Debug Apache /Forms : Log files

Posted By Sagar Patil

Backups and Recovery Options on SQL server

Posted By Sagar Patil

In Progress : SQL Server Mirroring (Oracle Standby Database)

Posted By Sagar Patil

Using a Maintenance Plan to Backup SQL Databases

Posted By Sagar Patil

EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

Posted By Sagar Patil

SQL Server Transaction Log Shipping Replication

Posted By Sagar Patil

SQL Server Remote Connection Error : An error has occurred while establishing a connection to the server.

Posted By Sagar Patil

Maintaining SQL Server High Availability

Posted By Sagar Patil

Locks,Monitoring SQL Server Pocesses

Posted By Sagar Patil

How AWR works?

Posted By Sagar Patil

Installing Oracle 9.2.0.6 on Red Hat Linux AS release 5 Update 3

Posted By Sagar Patil

Installing Oracle 10.2.0.1 on Red Hat Linux AS release 4 Update 5 (Nahant Update)

Posted By Sagar Patil

Views Relevant to Oracle Data Guard

Posted By Sagar Patil

How to resolve Replication Errors

Posted By Sagar Patil

Installing E- Business Suite 12 under Linux.. Under Progress

Posted By Sagar Patil

10g RAC Install under RHEL/OEL 4.5

Posted By Sagar Patil

File System to ASM Migration on Standalone Database

Posted By Sagar Patil

Compare and copy files remotely using SCP

Posted By Sagar Patil

Using adadmin to compile an Apps environment

Posted By Sagar Patil

Disk Space Required for EBS 11i & 12

Posted By Sagar Patil

Multi Node to Single Node Cloning

Posted By Sagar Patil

Best way to check patches on Metalink

Posted By Sagar Patil

How to deploy form on server

Posted By Sagar Patil

Log4plsql for PL/SQL Logging

Posted By Sagar Patil

Oracle Projects Overview : Concepts

Posted By Sagar Patil

Introduction to Oracle Payables : Concepts

Posted By Sagar Patil

Oracle HRMS Overview : Concepts

Posted By Sagar Patil

AD and Other Utilities

Posted By Sagar Patil

Write a Message to the Alert Log

Posted By Sagar Patil

How to Configure Notifications at Grid

Posted By Sagar Patil

Delete a Node/Host from OMS using Database API/Removing a target fromOMS

Posted By Sagar Patil

How to start database and Apps

Posted By Sagar Patil

Oracle RDBMS Release Nomenclature

Posted By Sagar Patil

E Business Suite Release 10.7/11.0.x/11i.5.x/12 Component Details

Posted By Sagar Patil

Troubleshooting OAS Instance

Posted By Sagar Patil

Monitoring Oracle E-Business Suite.

Posted By Sagar Patil

How do users interact with Oracle Applications - Part 2

Posted By Sagar Patil

What is Oracle Applications : Part 1

Posted By Sagar Patil

Steps to clone Oracle Applications database from PROD to TEST

Posted By Sagar Patil

E Business Suite Configuration Files…. Under Construction

Posted By Sagar Patil

Installing Oracle Applications R11.5.10.2 Under Windows

Posted By Sagar Patil

Change Display Name Of Targets In a Grid Control

Posted By Sagar Patil

RMAN Offline Backup Script

Posted By Sagar Patil

Manually resolve archive log gap/ Recover Standby / Manual Standby recovery

Posted By Sagar Patil

Start OMS /Stop OMS/Restart OMS

Posted By Sagar Patil

Troubleshooting Grid Control/ Grid Log files

Posted By Sagar Patil

Which jobs are currently active / jobs running

Posted By Sagar Patil

EM Agent Deploy Log Files

Posted By Sagar Patil

Create PLAN_TABLE script

Posted By Sagar Patil

Oracle Enterprise Manager 10g Grid Control Extensions Exchange

Posted By Sagar Patil

Installing Management Agent using Push method from OMS

Posted By Sagar Patil

Using the Job System : schedule/list Jobs (In Progress)

Posted By Sagar Patil

Changing a Threshold

Posted By Sagar Patil

Upload failed with ret=-10 / Agent is Running but Not Ready

Posted By Sagar Patil

Install and Admin OMS (Oracle Management Service) Grid Console

Posted By Sagar Patil

Installing & Configuring Oracle grid Agent (UNIX Standalone/Clustered Install)

Posted By Sagar Patil

Setting up Streams Replication on 9i (9.2.0.8) using EM/Grid

Posted By Sagar Patil

Kill DBMS job before database shutdown

Posted By Sagar Patil

Upload failed with ret=-10 / Agent is Running but Not Ready : Clustered node install

Posted By Sagar Patil

Replication views taking longer to return results/ Truncate views

Posted By Sagar Patil

Install Oracle Management Agent from OMS server

Posted By Sagar Patil

Network Statistics (netstat)

Posted By Sagar Patil

Clone Agent Configuration

Posted By Sagar Patil

Metric Collection Error

Posted By Sagar Patil

Virtual Memory Statistics ( vmstat )

Posted By Sagar Patil

Oracle Installer Failed : TMP space problem

Posted By Sagar Patil

Input Output statistics ( iostat )

Posted By Sagar Patil

Useful Linux Commands : Find files/ Find processes

Posted By Sagar Patil

Modifying the VIP or VIP Hostname of a 10g Oracle Clusterware Node

Posted By Sagar Patil

ADD/REMOVE/REPLACE/MOVE Oracle Cluster Registry (OCR) and Voting Disk

Posted By Sagar Patil

RAC Build on Solaris: Fifth Phase

Posted By Sagar Patil

RAC Build on Solaris : Fourth Phase

Posted By Sagar Patil

RAC Build on Solaris : Third Phase

Posted By Sagar Patil

RAC Build on Solaris : Second Phase

Posted By Sagar Patil

RAC Build on Solaris : First Phase

Posted By Sagar Patil

RAC Build on Solaris, Step-By-Step

Posted By Sagar Patil

Data Guard Rolling Upgrade

Posted By Sagar Patil

Compare Statspack Views with AWR

Posted By Sagar Patil

Oracle Data Guard Views

Posted By Sagar Patil

How to Recover Standby from Primary Database

Posted By Sagar Patil

How to setup RMAN for backup under Windows

Posted By Sagar Patil

Unregister Database From RMAN

Posted By Sagar Patil

Displays partition information for specified index

Posted By Sagar Patil

ORA 600 ORA600 Corrupt UNDO/INDEX/TABLE Segment

Posted By Sagar Patil

Undo Retention , Undo Optimization

Posted By Sagar Patil

Do I need to reorganise my table?

Posted By Sagar Patil

Oracle Undocumented Parameters

Posted By Sagar Patil

ORA-00312: Message 312 not found; Solution

Posted By Sagar Patil

Flashback Query

Posted By Sagar Patil

Function Based Indexes

Posted By Sagar Patil

When to Rebuild a B-Tree Index

Posted By Sagar Patil

Index Monitoring

Posted By Sagar Patil

Building virtual index using the NOSEGMENT clause.

Posted By Sagar Patil

Selecting the Best Join Order : Methods Oracle Uses to Join Tables

Posted By Sagar Patil

Sid from Unix Process ID

Posted By Sagar Patil

Find out SGA PGA Size

Posted By Sagar Patil

Statspack Scripts

Posted By Sagar Patil

API to Retrieve runtime Replication Parameters

Posted By Sagar Patil

How to enable trace in Oracle

Posted By Sagar Patil

FAN (Fast Application Notification) & ONS (Oracle Notification Services)

Posted By Sagar Patil

How does the failover mechanism work?

Posted By Sagar Patil

Can't convert a Table Space into Read Only Mode

Posted By Sagar Patil

TAF can be verified by querying the Oracle-provided views

Posted By Sagar Patil

Rectify Differences Between Replicated Tables

Posted By Sagar Patil

Tuning SQL to drop execution cost

Posted By Sagar Patil

Why Oracle is not updating replicated tables

Posted By Sagar Patil

Get the current Session ID

Posted By Sagar Patil

How to VALIDATE a MultiMaster Replication Setup

Posted By Sagar Patil

Loading or Re-Synchronising Data in a Replication Cluster

Posted By Sagar Patil

Replication Packages/Triggers Missing at new site : ORA-04067: stored procedure OBJECT_NAME$RP does not exist

Posted By Sagar Patil

Transactions Currently Being Propagated to a Remote Master

Posted By Sagar Patil

Average Amount of Time to Apply Transactions at Remote Sites

Posted By Sagar Patil

Tracking the Rate of Transactions Entering the Deferred Transactions Queue

Posted By Sagar Patil

Tracking the Average Number of Row Changes in a Replication Transaction

Posted By Sagar Patil

Determining the Average Network Traffic Created to Propagate a Transaction

Posted By Sagar Patil

Listing General Information About the Error Transactions at a Replication Site

Posted By Sagar Patil

Delete Errors (Transaction Queue, Errors)

Posted By Sagar Patil

Delete MASTER Node: Rollback ADD_NEW_MASTERS Procedure

Posted By Sagar Patil

Replication SQL Scripts

Posted By Sagar Patil

Push Replication Group to NORMAL Status in an Exceptional Case

Posted By Sagar Patil

Enable Archivelog, Put Database into ARCHIVE mode

Posted By Sagar Patil

Drop/Delete Multi-Master Replication

Posted By Sagar Patil

Add a new node using ADD_MASTER_DATABASE : Group Quiescing Method

Posted By Sagar Patil

Monitoring Performance in a Replication Environment

Posted By Sagar Patil

Monitoring Purges of Successfully Propagated Transactions

Posted By Sagar Patil

Monitoring the Deferred Transactions Queue

Posted By Sagar Patil

Monitoring Administrative Requests : Important

Posted By Sagar Patil

List General Information About Master Groups & replication activity

Posted By Sagar Patil

Listing the Master Sites Participating in a Master Group

Posted By Sagar Patil

An example of Conflict Resolution Method

Posted By Sagar Patil

ORA-02055: distributed update operation failed; rollback required

Posted By Sagar Patil

ORA-23419: regenerate replication support before resuming master activity

Posted By Sagar Patil

Add or Alter objects into Existing Mutimaster Group

Posted By Sagar Patil

Dynamic Replication Views

Posted By Sagar Patil

How to setup 2 Way MultiMaster Replication?

Posted By Sagar Patil

V$ views for Performance Monitoring Replication Environment

Posted By Sagar Patil

Remove or Delete Master Site from a Master Group

Posted By Sagar Patil

What is a "QUIESCED mode"

Posted By Sagar Patil

Oracle Advanced Replication - Administration Tasks (Concepts/no SQL)

Posted By Sagar Patil

Adding a new Master Node in an existing Multi Master Cluster

Posted By Sagar Patil

Replication Error "QUISCED" Group. How to use DBMS_DEFER_SYS.EXECUTE_ERROR & DBMS_DEFER_SYS.DELETE_ERROR

Posted By Sagar Patil

Relocating Master Definition Site

Posted By Sagar Patil

Replication Views / Prerequisites for Advanced Replication

Posted By Sagar Patil

Add new Node without Quiescing (RMAN SCN Method)

Posted By Sagar Patil

How to apply patch on RAC Setup

Posted By Sagar Patil

How Histograms can change execution Plan

Posted By Sagar Patil

AWR : How to locate resource limits

Posted By Sagar Patil

Locate Log Switch Interval on Day/Hourly Basis

Posted By Sagar Patil

Which sessions are consuming IO bandwidth, Would return SID list

Posted By Sagar Patil

Identify Master node in RAC cluster

Posted By Sagar Patil

Rman Backup Report from Repository

Posted By Sagar Patil

Bring Cluster Online/Offline

Posted By Sagar Patil

Administering Node Applications

Posted By Sagar Patil

Managing CRS/ Commands

Posted By Sagar Patil

Monitoring Services Using gv$active_services

Posted By Sagar Patil

Oracle Standby Recovery Rate Monitoring

Posted By Sagar Patil

Locate if Dataguard is running in a Managed Recovery Mode in a Cluster

Posted By Sagar Patil

Oracle Data Pump

Posted By Sagar Patil

All clients making use of this ASM Instance

Posted By Sagar Patil

Summary report of ASM disk groups and Space Utilised

Posted By Sagar Patil

Performance summary report of all disks contained within all ASM DiskGroups

Posted By Sagar Patil

Summary report of all disks contained within all disk Groups

Posted By Sagar Patil

Mastering ASMCMD

Posted By Sagar Patil

Display tablespace usage

Posted By Sagar Patil

Enabling ArchiveLog Mode in a RAC Environment

Posted By Sagar Patil

OCR administration utilities

Posted By Sagar Patil

Oracle Clusterware Administration Quick Reference

Posted By Sagar Patil

How to add a New Node

Posted By Sagar Patil

Analyze database for right statistics

Posted By Sagar Patil

How to Backup/Export Oracle Optimizer Statistics into Table

Posted By Sagar Patil

How to retrieve entire SQL + Execution PLAN from Statspack

Posted By Sagar Patil

Locate Hard hitting SQL from Statpack Reposistory

Posted By Sagar Patil

Locate Server Workload from Statspack for days in Past

Posted By Sagar Patil

How to setup RMAN under Windows

Posted By Sagar Patil

How to Monitor rman Backup ?

Posted By Sagar Patil

Replicate/Restore Live DB on Test /Dev Server using Rman

Posted By Sagar Patil

RAC on Windows,Linux with VMWARE, FIREWIRE, NFS

Posted By Sagar Patil

Why RAC need a VIP (Virtual IP address)

Posted By Sagar Patil

DDL create commands for Objects (DBMS_METADATA)

Posted By Sagar Patil

Shell or UNIX OS Commands From PL/SQL

Posted By Sagar Patil

Identifying a Poor performing SQL

Posted By Sagar Patil

How to find out hidden and system Parameters?

Posted By Sagar Patil

ORA 600 Corrupt UNDO/INDEX/TABLE Segment

Posted By Sagar Patil

Estimate Undo Retention , Undo Optimization

Posted By Sagar Patil

10G ASH script :True Session Wait Activity in Oracle 10g

Posted By Sagar Patil

Complete (recursive) object dependency

Posted By Sagar Patil

Find execution time for given SQL from Statpack tables

Posted By Sagar Patil

Resumable Space Allocation / SUSPEND RESUME transactions

Posted By Sagar Patil

Running SHELL script from Oracle PL/SQL

Posted By Sagar Patil

What is a database EVENT and how does one set events?

Posted By Sagar Patil

Clone RAC to non RAC Instance

Posted By Sagar Patil

Re-Create database at Server B from RMAN backup at Server A

Posted By Sagar Patil

Rman backup script to backup entire database : level 0

Posted By Sagar Patil

Data Guard Switover /Standby Build from RMAN Backup

Posted By Sagar Patil

Divert temporary workload to another RAC node

Posted By Sagar Patil

How to run rda on cluster

Posted By Sagar Patil

Any node restarted : CRSSTAT -T returns number of services in UNKNOWN :Fixed

Posted By Sagar Patil

What is causing Redo / Writes/ Log Creation

Posted By Sagar Patil

All OCFS volumes were not available at ocfsconsole config tool

Posted By Sagar Patil

RAC Backup : Copy 1 set of backup at FLASH & other to ext3 Disk

Posted By Sagar Patil

EM grid console active only at RAC 1 Instance

Posted By Sagar Patil

Client side TNS Entry for Failover

Posted By Sagar Patil

Restore part of Database using rman restore

Posted By Sagar Patil

Steps to Convert Enterprise Edition to Standard (DownGrade)

Posted By Sagar Patil

Basic RAC Management Commands

Posted By Sagar Patil

AWR : How to purge old Snapshots?

Posted By Sagar Patil

Disable HBA(Storage Array) to RAC1 /RAC2 Nodes : Test 1

Posted By Sagar Patil

CRS_STAT Services in UNKNOWN/OFFLINE Status : Bring them ONLINE

Posted By Sagar Patil

Public network disconnected at RAC 1 : RAC1 & RAC2 restarted : OCFS issue Fixed : Test 2

Posted By Sagar Patil

Private network cable pulled out of RAC 1 node : RAC2 was restarted

Posted By Sagar Patil

Private network cable pulled out of RAC 2 node : RAC2 was rebooted

Posted By Sagar Patil

ORA-29701 : Unable to connect to Cluster Manager while creating new ASM Instance

Posted By Sagar Patil

ons gsd vip listed OFFLINE at crs_stat

Posted By Sagar Patil

Number of Reboot return CRS-1028: Dependency analysis failed

Posted By Sagar Patil

CRSCTL : Oracle Clusterware Service Administration

Posted By Sagar Patil

Speeding-Up Oracle Export/Import Migration

Posted By Sagar Patil

Managing Backups and Recovering OCR

Posted By Sagar Patil

ASM Dynamic Views: ASM Instance Information

Posted By Sagar Patil

RAC/CRS/Voting disk failover Tests

Posted By Sagar Patil

How to recover from a Loss of Voting Disk

Posted By Sagar Patil

Using ASM on command line

Posted By Sagar Patil

Automatically start ASM/Database/EM/LSNR services

Posted By Sagar Patil

TAF Failover Configuration and Testing

Posted By Sagar Patil

How to use SRVCTL Options: RAC Administration

Posted By Sagar Patil

Oracle Clusterware Log/Clusterware log files

Posted By Sagar Patil

Oracle Installer can't discover ASM disks Ora-15186 Asmlib Error =[ASM_OPEN], ERROR = [1]

Posted By Sagar Patil

CRS didn't start after a REBOOT

Posted By Sagar Patil

ORA-15186 ASMLIB ERROR FUNCTION = [ASM_OPEN], ERROR = [1], ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"

Posted By Sagar Patil

OCFS2 Support Guide Linux/Solaris

Posted By Sagar Patil

Create Data Guard standby on Windows Server

Posted By Sagar Patil

When to Rebuild a B-Tree Index

Posted By Sagar Patil

How to Install Statspack (8i/9i/10g)

Posted By Sagar Patil

Locate Server Workload for a defined timeframe

Posted By Sagar Patil

How to find current Statspack level?

Posted By Sagar Patil

Switchover from primary to standby/ Switchover Primary

Posted By Sagar Patil

A database is creating more than 100 logs every single hour. What is happening ?

Posted By Sagar Patil

Optimizer_index_cost_adj and Execution Plans

Posted By Sagar Patil