INCLUDE_DATA

Recent Articles


What is OPatch, How to use OPatch & List patches

Posted By Sagar Patil

Patch is an Oracle supplied utility to assist you with the process of applying interim patches to Oracle's software. OPatch is a Java-based utility which requires the Oracle Universal Installer to be installed. It is platform independent and runs on all supported operating systems. OPatch supports the following:
* Applying an interim patch.
* Rolling back the application of an interim patch.
* Detecting conflict when applying an interim patch after previous interim patches have been applied. It also suggests the best options to resolve a conflict.
* Reporting on installed products and interim patch. Read more...

Backup Websphere Configuration

Posted By Sagar Patil
backupConfig.sh backup_file [options]
backupConfig.sh myBackup.zip -nostop -logfile backupConfig.lst

Read more...

Archivelogs deleted, Unavailable archive files during rman backup

Posted By Sagar Patil

I carried a big data upload and as a result of it my archive volume filled up in no time. As matter of urgency I started moving archive logs without backup to another destination. The next thing to go wrong was my nightly backup. Read more...

Compare and Display difference between 2 Files

Posted By Sagar Patil

Comparing Files is one of very common task as a DBA, System Administrator. There are tonnes of Oracle,Websphere,linux configuration files. Often I have to compare one server to another and locate changes between environments. Read more...

Managing profiles under WAS 6.1

Posted By Sagar Patil

WAS_HOME=/opt/IBM/WebSphere/AppServer/bin

$ ./manageprofiles.sh -listProfiles
[Dmgr, Node] Read more...

WebSphere : Synchronize Cluster Configuration with Dmgr & Nodes

Posted By Sagar Patil

In a Network Deployment environment, the deployment manager maintains the master repository for all of the WebSphere Application Server nodes and servers that it manages in the cell. Copies of the files that each node needs are replicated to that node by a process known as synchronization. Read more...

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

Posted By Sagar Patil

You should check if application server process is running to determine a crash. To do this, you need to know process ID of application server. You can find process ID at server name.pid file in:

Read more...

FFDC(first failure data capture) folder and Logs

Posted By Sagar Patil

Often the websphere default systmout,systemerror logs doesn't provide detailed information on error. In such cases have a look at directory logs under /opt/IBM/WebSphere/AppServer/profiles/Profile01/dmgr/logs/ffdc & /opt/IBM/WebSphere/AppServer/profiles/Profile01/Node/logs/ffdc Read more...

Websphere FAQ : Clustering, Deployment Manager & Node Agent

Posted By Sagar Patil

How does Deployment Manager and node Agent work together? Does deployment manager send message to node agent actively or node agent sends message to deployment manage? Read more...

wsadmin Commands

Posted By Sagar Patil

Print Server Configuration

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

Read more...

Websphere Basics

Posted By Sagar Patil

WebSphere architectures contain one or more computer systems, which are referred to in WebSphere terminology as nodes. Nodes exist within a WebSphere cell. A WebSphere cell can contain one node on which all software components are installed or multiple nodes on which the software components are distributed. 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 & Websphere terms explained

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...

Duplicating an ASM Database at Remote Host

Posted By Sagar Patil

You can use the create RMAN DUPLICATE command to duplicate database from target database backups while still retaining the original target database. The duplicate database can be either identical to the original database or contain only a subset of the original tablespaces. A duplicate database is a copy of the target database that you can run independently for a variety of purposes.

Read more...

Oracle 10g script for User/Role/Object Privileges

Posted By Sagar Patil

Imagine you have to drop an Oracle user and create it with all privs/roles again.  This often happens in test cycle of 3rd party products. The privs are sent to user on ad hoc basis to get around the installation errors and then comes requirement to replicate it on another server.  How do you do it?  Attached script will create a spool file for user granted roles, object Privileges
Read more...