Tweet
EM GRID: How to Change DB Console Http Port
I fixed a failed 11g dbconsole installation using http://www.oracledbasupport.co.uk/standalone-11g-dbconsole-configuration But Dbconsole picked up port 5500 instead of our usual EM port 1159.
Standalone 11g dbconsole Configuration
I installed Oracle 11g today on RHEL 5.4 but dbconsole failed to startup. Here is a process to fix this issue.
set bash prompt
I need to remind myself on what machine & directory I am working on constantly. The easiest way to do so would be setting PS1 prompt under bash shell.
Websphere : Change application server ports
I have set of JVM ports (9080,9081) accessible thru firewall. This week when I built new websphere clustered ND environment something went wrong and it picked up ports 9081,9082 instead of usual 9080,9081. Here is a process I used to alter them from 9081->9080 & 9082->9081
Wsadmin Details
To administer the WebSphere Application Server environment, wsadmin includes some specialized administrative objects.
Websphere : How to change HOSTNAME using ws_ant scripts
Today I have a new_server which I need to build to my websphere old_server. The first thing to do is rename Hostname from old_server to new_server. Here is a script I used to just do that.
Websphere : Jython script to return performance matrix details of Node
Here is a Jython script to return performance matrix detail of a node for following details :
Free and used JVM heap size,
Free and used Thread pools,
Free and used JDBC connection pools
Free and used Live sessions
Time Travel & Websphere Node/Deployment manager synchronisation
I have websphere 6.x ND servers which time travel in future i.e 2011/2012. One of machine time traveled to 2011, I then had to revert it back to current date i.e 2010. I can now see that configuration under following directories is not updated properly.
DMGR : Aug 5 2010 is the latest. Read more…
Weblogic : Monitor Weblogic through command line
Set the java environment. There is a script for setting the CLASSPATH and PATH so that this tool can work. Read more…
Creating Users /Groups at Websphere
We have to create WAS groups before creating & assigning users.
Script to Auto Start Primary/Standby Database under Linux
The following represents the Oracle recommended method for automating database startup and shutdown of Oracle 10g instances.
Websphere : How to Create Self Signed SSL Certificate for HTTPServer
What is SSL ?
- SSL (Secure Sockets Layer) is an encryption system used on servers to ensure privacy when transmitting data across internet.
- Server needs a public-private key pair and a certificate. The server uses its private key to sign messages to clients.
- To send its public key to clients, the server needs a certificate issued by a certification authority (CA). A certification authority (CA) is a trusted third party that issues certificates.
Clone a WebShere installation on another server
Method 1:
1) Install exact websphere version including fixpack on a new machine
Note you have to make sure to use same install path for example
Websphere : Jython stop & start server scripts
Stop Script:
Let’s check if there are any java (server) process running ?
[was61@ scripts]$ ps -ef | grep java | awk ‘{print $2 ” “ $8}’
18343 /opt/IBM/WebSphere/AppServer/java/bin/java
18521 /opt/IBM/WebSphere/AppServer/java/bin/java
18639 /opt/IBM/WebSphere/AppServer/java/bin/java
18819 /opt/IBM/WebSphere/AppServer/java/bin/java
Jython Script : Get websphere Server Details
This jython script will produce output as below :
$/opt/IBM/WebSphere/AppServer/bin/wsadmin.sh -lang jython -profile serverStatus.py -c “serverStatus()”
JACL Script : Get server status & OS details before deployment
This script is designed to get complete server status details and OS details just before deployemnt. Its designed to help in debugging and simulating the same environment.
Note:No arguments required for this script to run
Websphere ND Install: Install IBM HTTP Server
Go to application server profile and start the server. Start the deployment manager. Go to the administrative console and login.
Is my websphere configured in Development Mode?
WebSphere Portal has concept of Development mode for some time, basic idea is to improve the startup time of portal by delaying the startup of application. The application should be started when it is accessed for first time instead of starting it at the server startup time.
Trend Oracle log history : How much archives created per day/week or in an hour
Count of archive files and size of the redo generated by day
SELECT A.*, ROUND (A.Count# * B.AVG# / 1024 / 1024) Daily_Avg_Mb FROM ( SELECT TO_CHAR (First_Time, 'YYYY-MM-DD') DAY, COUNT (1) Count#, MIN (RECID) Min#, MAX (RECID) Max# FROM v$log_history GROUP BY TO_CHAR (First_Time, 'YYYY-MM-DD') ORDER BY 1 DESC) A, (SELECT AVG (BYTES) AVG#, COUNT (1) Count#, MAX (BYTES) Max_Bytes, MIN (BYTES) Min_Bytes FROM v$log) B;
Websphere: Using PerformanceMonitor Servlet to Monitor Performance Metric
The PerfServlet provides the performance data output as an XML document, The servlet provides a way to use an HTTP request to query the performance metrics for an entire WebSphere Application Server administrative domain.
