<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>EveryDay practical solutions for an Oracle DBA</title>
	<link>http://oracledbasupport.co.uk</link>
	<description>This is my blog to list day to day issues I faced while working as a Oracle DBA/Consultant. I worked on every aspect of back end Oracle database and this blog should reflect some of it.</description>
	<lastBuildDate>Thu, 02 Sep 2010 16:06:35 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Listing Websphere Configuration Details to Compare Difference between Installations</title>
		<description><![CDATA[I have many websphere 6.x ND clustered servers and growing every single week. Lots of them are upgraded from previous websphere installations to ND 6.x now.
We have admin shell scripts written but they are not portable.  There is diff in naming conventions for profile, Cluster name, Application Server name etc. We have some issues and [...]]]></description>
		<link>http://oracledbasupport.co.uk/listing-websphere-configuration-details-to-compare-difference-between-installations/</link>
			</item>
	<item>
		<title>How to Change DB Console Http Port</title>
		<description><![CDATA[I fixed a failed 11g dbconsole installation using http://oracledbasupport.co.uk/standalone-11g-dbconsole-configuration But Dbconsole picked up port 5500 instead of our usual EM port 1159.
How can we change dbconsole port from 5500 to 1159?
Before proceeding take backup of these 3 files
-     /u01/app/oracle/product/11.2.0/dbhome_1/$HOST_NAME%SID%/sysman/config/emoms.properties
-    /u01/app/oracle/product/11.2.0/dbhome_1/$HOST_NAME%SID%/sysman/config/emd.properties
-    /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_$HOST_NAME/config/server.xml
-bash-3.2$ emca -reconfig ports -DBCONTROL_HTTP_PORT 1159  -SID TEST
STARTED EMCA at 27-Aug-2010 11:02:03
EM Configuration Assistant, [...]]]></description>
		<link>http://oracledbasupport.co.uk/how-to-change-db-console-http-port/</link>
			</item>
	<item>
		<title>Standalone 11g dbconsole Configuration</title>
		<description><![CDATA[I installed Oracle 11g today on RHEL 5.4 but dbconsole failed to startup. Here is a process to fix this issue.
Create   emca.rsp response file with following entries
ORACLE_HOSTNAME=dbserver1.dbdmz.oracledbasupport.net
SID=%TEST%
PORT=1521
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
LISTENER_OH=/u01/app/oracle/product/11.2.0/dbhome_1
DBSNMP_PWD=manager
SYSMAN_PWD=manager
SYS_PWD=manager
Now run emca with following options
-bash-3.2$ ./emca -config dbcontrol db -silent -respfile emca.rsp
STARTED EMCA at 27-Aug-2010 09:34:29
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
27-Aug-2010 [...]]]></description>
		<link>http://oracledbasupport.co.uk/standalone-11g-dbconsole-configuration/</link>
			</item>
	<item>
		<title>set bash prompt</title>
		<description><![CDATA[I need to remind myself on what machine &#38; directory I am working on constantly. The easiest way to do so would be setting PS1 prompt under bash shell.
For example,
Name of Server : Server1
Pwd : /opt/IBM/WebSphere/AppServer/profiles/Profile01/Node
TAG : [Dev] Uatf]
export TAG=Dev/Uatf/Test
export PS1=&#8216;${HOSTNAME:0:10}-$(echo $PWD&#124;awk &#8220;{print substr(\\$1,length(\\$1)-24,25)}&#8221;)-${TAG:0:4}# &#8216;
returned  Server1-/logs/uatf_server_member1-Dev#
To Display HOSTNAME In caps do
export PS1=&#8217;$(echo ${HOSTNAME:0:10}&#124;tr &#8220;[a-z]&#8221; &#8220;[A-Z]&#8220;)-$(echo [...]]]></description>
		<link>http://oracledbasupport.co.uk/set-bash-prompt/</link>
			</item>
	<item>
		<title>Websphere : Change application server ports</title>
		<description><![CDATA[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-&#62;9080 &#38; 9082-&#62;9081
Login at deployment manager -&#62; Sselect Servers -&#62; Application Servers [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-change-application-server-ports/</link>
			</item>
	<item>
		<title>GSK_ERROR_BAD_CERT error configuring SSL between Plug-in and Application Server V6.1</title>
		<description><![CDATA[This morning my websphere decided to stop responding. Websphere services restart didn&#8217;t help. The Httpd log was not helpful except throwing these errors so I turned to http_plugin.log

[Thu Jul 29 10:58:08 2010] [notice] SSL0198W: System is running without a security library capable of directly rejecting  insecure SSL client renegotiation.  Aborting HTTPS requests that span SSL [...]]]></description>
		<link>http://oracledbasupport.co.uk/gsk_error_bad_cert-error-configuring-ssl-between-plug-in-and-application-server-v6-1/</link>
			</item>
	<item>
		<title>Wsadmin : Everything you want to know</title>
		<description><![CDATA[To administer the WebSphere Application Server environment, wsadmin includes some specialized administrative objects.
Object Name Description



AdminConfig
Object used to view and manipulate configuration elements   (xml files).


AdminControl
Object used to view and manipulate active application   server objects (MBeans)


AdminApp
Object used to install and manipulate applications.


AdminTask
Object used to execute administrative and server   management commands.


Help
Object used [...]]]></description>
		<link>http://oracledbasupport.co.uk/wsadmin-everything-you-want-to-know/</link>
			</item>
	<item>
		<title>Websphere : How to change HOSTNAME using ws_ant scripts</title>
		<description><![CDATA[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.
Download “Configuration management scripts for V6	ConfigScripts.zip” from  http://www.ibm.com/developerworks/websphere/library/samples/SampleScripts.html
Sample exportImport.xml attached here http://oracledbasupport.co.uk/wp-content/2010/08/exportImport.xml
[websphere@new_server config_management]$ /opt/IBM/WebSphere/AppServer/bin/ws_ant.sh -profileName dmgr -buildfile exportImport.xml -DstartManager=yes -DoldHostName=old_server [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-how-to-change-hostname-using-ws_ant-scripts/</link>
			</item>
	<item>
		<title>Websphere : Jython script to return performance matrix details of Node</title>
		<description><![CDATA[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
[was61@Server1 .scripts]$ wsadmin.sh -f check_was.py -i heapsize -s  Server_member1
WASX7209I: Connected to process &#8220;dmgr&#8221; on node Server1_Manager using SOAP connector;  The type [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-jython-script-to-return-performance-matrix-details-of-node/</link>
			</item>
	<item>
		<title>Time Travel &amp; Websphere Node/Deployment manager synchronisation</title>
		<description><![CDATA[I have websphere 6.x ND servers which time travel in future i.e 2011/2012.  One of the machine time traveled to 2011. Then I had to revert it back to current date i.e 2010. Now I see that the configuration under following directories is not updated properly.

DMGR : Aug 5 2010 is the latest.
[was@Server1 Profile01]$ ls [...]]]></description>
		<link>http://oracledbasupport.co.uk/time-travel-websphere-nodedeployment-manager-config-synchronisation/</link>
			</item>
	<item>
		<title>Bash : Send output of one command/s to another</title>
		<description><![CDATA[Here, I wish to list all files with name &#8220;web.xml&#8221; in directory &#8220;prweb&#8221;
[was61@Server1]$  du -a &#124; grep /web.xml &#124; grep prweb &#124; tee &#8220;ls -lrt&#8221;
60      ./dmgr/config/cells/eugbbopg10lt_Cell/applications/j2ee14.ear/deployments/j2ee14/prweb.war/WEB-INF/web.xml
60      ./Node/config/cells/eugbbopg10lt_Cell/applications/j2ee14.ear/deployments/j2ee14/prweb.war/WEB-INF/web.xml
60      ./Node/installedApps/eugbbopg1blp_Cell/j2ee14.ear/prweb.war/WEB-INF/web.xml
To view and save the output from a command at the same time:
ipconfig &#124; tee OutputFile.txt


]]></description>
		<link>http://oracledbasupport.co.uk/bash-send-output-of-one-commands-to-another/</link>
			</item>
	<item>
		<title>Weblogic : Monitor Weblogic through command line</title>
		<description><![CDATA[Set the java environment
There is a script for setting the CLASSPATH and PATH so that this tool can work.
&#62; source setWLSEnv.sh
CLASSPATH=/dsk2/local/bea81/jdk141_02/lib/tools.jar:/dsk2/local/bea81/weblogic81/server/lib/weblogic_sp.jar:
/dsk2/local/bea81/weblogic81/server/lib/weblogic.jar:/dsk2/local/bea81/weblogic81/server/lib/ojdbc14.jar:
:/dsk1/AdvIngres/ing26/ingres/lib/edbc.jar:/dsk1/AdvIngres/ing26/ingres/lib/edbc.jar
PATH=/dsk2/local/bea81/weblogic81/server/bin:/dsk2/local/bea81/jdk141_02/jre/bin:/dsk2/local/bea81/jdk141_02/bin:
/dsk1/AdvIngres/ing26/ingres/bin:/dsk1/AdvIngres/ing26/ingres/utility:/dsk1/AdvIngres/ing26/ingres/files:
/dsk1/AdvIngres/ing26/ingres/lib:/dsk1/AdvIngres/ing26/ingres/SUNWspro/bin:/sbin:/usr/sbin:/bin:/usr/bin:
/usr/ucb:/etc:/usr/etc:/opt/fw/bin:/var/adm/psmfc/bin:/usr/openwin/bin:/usr/local/bin:/usr/psmfc/bin:
/usr/ccs/bin:/usr/lib/nis:/opt/gnu/bin:/usr/local/bin
Your environment has been set.
Verify that the java environment is set properly
Success
&#62; java weblogic.Admin
weblogic.Admin is a command-line utility for managing WebLogic Server. 
Try: weblogic.Admin help LIFECYCLE   Starting, stopping, discovering servers
weblogic.Admin help INFO        Retrieving info about [...]]]></description>
		<link>http://oracledbasupport.co.uk/weblogic-monitor-weblogic-through-command-line/</link>
			</item>
	<item>
		<title>Creating Users /Groups at Websphere</title>
		<description><![CDATA[We have to create WAS groups before creating &#38; assigning users.

Click on Manage groups and add a new groups , here “WAS Monitor”



Click on “Save “



Click on “Create” at  right hand pane &#38; you will see a FORM like one below

Click on “Group Membership” and select WAS Operator role we just created.


Now refer to following [...]]]></description>
		<link>http://oracledbasupport.co.uk/creating-users-groups-at-websphere/</link>
			</item>
	<item>
		<title>Script to Auto Start Primary/Standby Database under Linux</title>
		<description><![CDATA[The following represents the Oracle recommended method for automating database startup and shutdown of Oracle 10g instances.
Once the instance is created, edit the &#8220;/etc/oratab&#8221; file setting the restart flag for each instance to &#8216;Y&#8217;.
dev:/u01/app/oracle/product/10.2.0:N
Change N to Y
dev:/u01/app/oracle/product/10.2.0:Y
Next, create a file called &#8220;/etc/init.d/dbora&#8221; as the root user, containing the following.
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle [...]]]></description>
		<link>http://oracledbasupport.co.uk/script-to-auto-start-primarystandby-database-under-linux/</link>
			</item>
	<item>
		<title>Websphere : How to Create Self Signed SSL Certificate for HTTPServer</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-how-to-create-self-signed-ssl-certificates-for-httpserver/</link>
			</item>
	<item>
		<title>Clone a WebShere installation on another server</title>
		<description><![CDATA[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
2) create dmgr and nodeprofile on a NEW machine
3) Stop the dmgr, nodeagent and all application server on OLD machine
4) Tar/zip up complete dmgr profile directory and node profile from OLD machine [...]]]></description>
		<link>http://oracledbasupport.co.uk/clone-a-webshere-installation-on-another-server/</link>
			</item>
	<item>
		<title>Websphere : Jython stop &amp; start server scripts</title>
		<description><![CDATA[Stop Script:
Let&#8217;s check if there are any java (server) process running ?
[was61@ scripts]$ ps -ef &#124; grep java &#124;  awk &#8216;{print  $2 &#8221; &#8220;  $8}&#8217;
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
Copy this script at your node and use it as &#8220;wsadmin.sh -f stopCell.py&#8221; (No arguments)
#&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-
#  Name: stopCell.py
#  Role: Gracefully terminate all active server processes in the cell
# [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-jython-stop-start-server-scripts/</link>
			</item>
	<item>
		<title>Jython Script : Get websphere Server Details</title>
		<description><![CDATA[This jython script will produce output  as below :
$/opt/IBM/WebSphere/AppServer/bin/wsadmin.sh -lang jython -profile serverStatus.py -c &#8220;serverStatus()&#8221;
WASX7209I: Connected to process &#8220;dmgr&#8221; on node eugbbopg11lt_Manager using SOAP connector;  The type of process is: DeploymentManager
Server               &#124;        Cell       &#124;         Node         &#124; Status
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8211;
dmgr                &#124; Server1_Cell &#124; Server1_Manager &#124; running
server_member1         &#124; Server1_Cell &#124; Server1_Node01  &#124; running
server_member2 &#124; Server1_Cell &#124; Server1_Node01  [...]]]></description>
		<link>http://oracledbasupport.co.uk/jython-script-get-websphere-server-details/</link>
			</item>
	<item>
		<title>JACL Script : Get server status &amp; OS details before deployment</title>
		<description><![CDATA[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
I have added JACL script output first, scroll down to see the actual script.
[was61@Machine1 ~]$ /opt/IBM/WebSphere/AppServer/bin/wsadmin.sh -user sagar -password 1234 -f getdetails.jacl
WASX7209I: [...]]]></description>
		<link>http://oracledbasupport.co.uk/jacl-script-get-server-status-os-details-before-deployment/</link>
			</item>
	<item>
		<title>Websphere ND Install under Windows :Create DMGR, AppServer profile</title>
		<description><![CDATA[Let&#8217;s start network deployment install, Click on the launchpad.exe

Next

Select none. Installation carries on…..
Uncheck the check box as shown in the following figure. And you will be able to create the deployment manager profile using Profile creation tool.
To open the profile creation tool from the command prompt
D:\Program Files\IBM\WebSphere\AppServer\bin\ProfileManagement/pmt

2. Go to program files and profile management tool [...]]]></description>
		<link>http://oracledbasupport.co.uk/websphere-nd-install-under-windows-create-dmgr-appserver-profile/</link>
			</item>
</channel>
</rss>
