TIP 112# : Quick tips on Weblogic

Very often I login to a customer site and I end up to search in document for couple things :
  • How to setup NodeManager so the customer could use Admin console for Weblogic startup
  • How to make username/password encrypted so the command line does not ask for username/password at time of startup
  • Quick and easy guideline for patching
  • How to check Weblogic version
Above items are nothing new but I thought to post details here for my quick access.This post is a quick reminder for myself which is copied from Oracle document.

To enable startup scripts and start Node Manager:

1.   Navigate to the following directory
2. MW_HOME/oracle_common/common/bin
MW_HOME is the directory where Oracle Fusion Middleware is installed.
3.   Run the setNMProps.sh script to set the StartScriptEnabled property to true before starting Node Manager:
4. ./setNMProps.sh
This is a one-time action. After you run this script, you can skip this step before starting Node Manager again.
5.   Start Node Manager with the startNodeManager script.
UNIX script: WL_HOME/server/bin/startNodeManager.sh
Windows script: WL_HOME\server\bin\startNodeManager.cmd

To avoid username/password at startup:

To avoid prompts for a user name and password on startup after you start a Managed Server the first time, you can create a boot.properties file in the domain-home/servers/server-name/security/ directory. This file would include the following lines:
The boot.properties file will be encrypted the first time that the Managed Server is started.

Patching mechanism on Weblogic :

Basically bsu is the tool to apply the patches on Weblogic install. The following shows an example on how patch is applied and how it is verified.

To apply

copy patch to $MW_HOME/utils/bsu/cache_dir
unzip patch
remove patch zip file (rm p1......zip)
./bsu.sh -install -patch_download_dir=$MW_HOME/utils/bsu/cache_dir -patchlist=FCX7 -prod_dir=$WL_HOME
To verify
./bsu.sh -view -status=applied -prod_dir=$WL_HOME

Checking Weblogic version:

[oracle@oracle2qa bin]$ . ./setDomainEnv.sh
[oracle@oracle2qa APEXDomain]$ java weblogic.version

TIP 111# : ODA and CPU license

Last week, I was working on a customer with ODA x4-2 which we found 5 CPU licenses are sold for EE deployment. My first reaction was on how to put 5 CPU license (10 cores) in ODA x4-2. As you may know, the multiplier of 4 cores can be activated in X3-2 and above and multiplier of 2 in ODA v1. In this post, I am trying to explain what is the minimum core requirement for various ODA server with virtualized and non-virtualized deployment.

We all know that "pay as grow" is one of the great feature of Oracle Database Appliance. In other words, you could start with as minimum core as possible and then scale up.
However, due to CPU specification on various ODA version, there is some limitation in regards to minimum number of cores which could be setup as it is shown in below :
Min license

10 day rule
10 day rule
10 day rule
10 day rule

Couple notes :
  • 10 day rule is to have all instances in EE or RAC1 only on one ODA node and without paying license to be allowed to flip over to the second node in case the first node is not available only for 10 days per calendar year.
  • Since ODA platform is x86, the contributing factor is 0.5. This is where you can see all multiplier of 0.5 in the table.
  • On ODA x3-2 and above odd number of CPU can not be setup unless ODA is setup as virtualized platform.
  • Virtualization provides more flexibility in terms of lowering the number of the required CPU specially for EE or RAC1. If you are dealing with small customer, you may end up to go virtualized even ODA is purposed only for database deployment.
Hope this post clarifies some confusion.

TIP 110# : GoldenGate DDL replication

I have to setup a DDL replication for a customer and as usual I use include to filter schema which I want to be replicated as below :

Interesting enough, I see that GoldenGate does not capture DDL although the filter should work fine. The following is reported in GoldenGate log with my surprise :
Oracle GoldenGate Capture for Oracle, ext_test.prm:  DDL operation excluded [not included by any filter]
, optype [CREATE], objtype [TABLE], objowner [SCHEMA1], objname [TAB]
The same situation does occur using different DDL options such as MAPPED. Further investigation revealed that it is a bug which is reported in Doc ID 1475618.1 and the workaround is not to use " for schema, in other words, the following works with no issue :
 DDL &
So no " for DDL options when you setup DDL for GoldenGate. Hope this simple tips helps.

TIP 109# : Linux OS requirement for Oracle DB installation

Since the most issues with software installation or relinking problem on database installation are created due to missing OS requirements, Oracle published a master notes for OS requirement for various Linux version :
This should come handy for any DB installations.
Enjoy reading !

TIP 108# : Become Golden DBA for GoldenGate environment (Basic)

Become Golden DBA for GoldenGate environment is delivered in OOW2013 and more topics around this will come which include but not limited to the following :
  • Golden DBA for 2 way GoldenGate replication
  • Golden DBA and troubleshooting GoldenGate
  • Golden DBA and advanced configuration on GoldenGate
  • Golden DBA and Tuning GoldenGate
For those of you who joined the session or would like to follow up, pdf version of the session is available on https://github.com/shervsh/Presentation/ and it will be available on OOW. 
Please drop me a line if you are interested in upcoming sessions or you would like to have ppt version.
Thanks everyone for joining the session, I will post answers to various questions in upcoming posts.