INCLUDE_DATA

Recent Articles


wsadmin Commands

Posted By Sagar Patil

Print Server Configuration

$WAS_HOME/Dmgr/bin/wsadmin.sh -conntype none -lang jython

Read more...

Tuning Java virtual Machines

Posted By Sagar Patil

Webspehere java 100% CPU usage : MustGather Information

Posted By Sagar Patil

Perform the following setup instructions:
1.    Follow instructions to enable verbosegc in WebSphere Application Server Read more...

Http Error Codes

Posted By Sagar Patil

Have you ever wondered what the codes listed at Apache acces_log mean

172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET HTTP/1.1" 200 554
172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET  HTTP/1.1" 304 -
172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET HTTP/1.1" 304

Read more...

Was my rman backup successful?

Posted By Sagar Patil

I have more than 100 database servers. How can I report if my backup was successful?
Normally one can use shell scripts and grep rman log for errors but here is a better way
Read more...

J2EE terms in simple words

Posted By Sagar Patil
  • What is an "Application Server"? An application server is a server computer on a computer network dedicated to running certain software applications. Generally, an application server is a software engine that delivers applications to client computers.

Read more...

Weblogic Configuration after Install

Posted By Sagar Patil

After an install run config.bat to create default weblogic configuration Read more...

How to Install WebLogic under Windows

Posted By Sagar Patil

Read more...

WebSphere Logging and Tracing

Posted By Sagar Patil

Plug-In Logs
WebServer http Plugin will create log, by default named as http-plugin.log, placed under PLUGIN_HOME/logs/
Plugin writes Error messages into this log. The attribute which deals with this is
< Log > in the plugin-cfg.xml
For Example
< Log LogLevel="Error" Name="/opt/IBM/WebSphere/Plugins/logs/http_plugin.log" / > Read more...

Websphere Hierarchy of Configuration Documents

Posted By Sagar Patil

Hierarchy of directories of documents

In a Network Deployment environment, changes made to configuration documents in the cell repository, are automatically replicated to the same configuration documents that are stored on nodes throughout the cell. Read more...

Working with WebSphere Configuration Files

Posted By Sagar Patil

Application server configuration files define the available application servers, their configurations, and their contents. Read more...

Administrating WebSphere : Start/Stop/Status, Kill Sessions

Posted By Sagar Patil

Check Server Status:

cd /opt/IBM/WebSphere/AppServer/profiles/Profile01/Node01/bin
serverStatus server1
serverStatus -all (returns status for all defined servers)
serverStatus -trace (produces the serverStatus.log file)

Read more...

ASM ftp/http Access

Posted By Sagar Patil

XDB enable use of FTP and HTML protocols to access and manage files located on ASM disksgroups. Files can be easily browse or moved in/out from ASM this way.

Read more...

Protected: Duplicating an ASM Database at Remote Host

Posted By Sagar Patil

This post is password protected. To view it please enter your password below:


Oracle 10g script for User/Role/Object Privileges

Posted By Sagar Patil

Attached script will create a spool file for user granted roles, object Privileges

Read more...

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

Posted By Sagar Patil

My Statspack has following details.

Enqueue activity DB/Inst: Snaps: 1791-1808
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Read more...

Identifying Blocking Locks/ Contention & Resolving Database Hanging Issue

Posted By Sagar Patil

One of my 10.2.0.1 database was hanging despite allocating ample opf resources. The CPU, Memory,Disk accesses were normal but under heavy load server would freeze for no valid reason. I had to raise TAR with Oracle.

Read more...

Execute Immediate with Parameters

Posted By Sagar Patil

Example 1 : Running Execute immediate with an OUT parameter.

I wanted to output a count of tables to see if there is a data difference between Live/Test. I would have created a SQL script but it is hard to share with other developers so I found creating a procedure handy.

Read more...

How to install OBIEE

Posted By Sagar Patil

Step-1 Run the G:\obiee_windows_x86_101341\Windows\Server\Oracle_Business_Intelligence\setup.exe to display the welcome page.

Read more...

The Oracle 10g Scheduler

Posted By Sagar Patil

Oracle 10g's DBMS_SCHEDULER provides significant improvements over DBMS_JOB for scheduling jobs and tasks. Let's take an overview of new functionalities that the Oracle Scheduler provides for DBAs.

Read more...

How to Convert Physical Machines to Virtual Machines with VMware Converter

Posted By Sagar Patil

The VMware Converter is amazing piece of software which will:
1) Import a Virtual Machine from a physical machine
2) Configure newly created Virtual Machine to make an existing image bootable

Read more...

Maintain RMAN Catalog

Posted By Sagar Patil

Below is a windows BATCH script used to Maintain RMAN catalogue. The script accepts 3 parameters Target SID, Target password and catalogue password.

Read more...

Create Standby/Duplicate database using RMAN

Posted By Sagar Patil

Duplicate Database using rman

connect target rman/%password%@primary_server
connect auxiliary sys/%password%@standby_server
connect rcvcat rman/%password%@recovery_catalog
run {
set until time '27-JUL-2009 10:59:00';
allocate auxiliary channel tp1 type "sbt_tape";
allocate auxiliary channel tp2 type "sbt_tape";

Read more...

Remove Failed Clusterware

Posted By Sagar Patil

If you have already uninstalled Oracle Clusterware using the Oracle Universal Installer - Please download attached file cleanup.zip that contains a copy of the logpartformat.exe and the guioracleobjmanage.exe (plus necessary dll).

Read more...

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

Posted By Sagar Patil

How do I install CVU from OTN? Download From Here

Read more...