Wednesday, March 30, 2016

WebLogic Server Performance


https://blogs.oracle.com/imc/entry/weblogic_server_performance_and_tuning


For all server JVM you could edit the file  default value is 
-Xms256m -Xmx512m" and you can change it based on your requirements


 /user_projects/domains/TEST_DOM/bin/setDomainEnv.sh


if [ "${JAVA_VENDOR}" != "HP" ] ; then
        if [ "${VM_TYPE}" = "HotSpot" ] ; then
        ##      WLS_MEM_ARGS_64BIT="-Xms256m -Xmx512m"
                WLS_MEM_ARGS_64BIT="-Xms1024m -Xmx2048m"
                export WLS_MEM_ARGS_64BIT
##              WLS_MEM_ARGS_32BIT="-Xms256m -Xmx512m"
                WLS_MEM_ARGS_32BIT="-Xms1024m -Xmx2048m"
                export WLS_MEM_ARGS_32BIT
        fi
fi

Monday, March 28, 2016

HZ_DQM_SYNC.REALTIME_SYNC(oracle.apps.ar.hz.DQM.realtimesync

Event Error Name: 100
Event Error Message: ORA-01403: no data found
Event Error Stack:
HZ_DQM_SYNC.REALTIME_SYNC(oracle.apps.ar.hz.DQM.realtimesync


Solution : Data Quality Management: DQM Synchronization 11i (Doc ID 1926067.1)

Tuesday, March 22, 2016

How to Setup Proxy for your old version of oracle Application 11.5.10.2

Download Oracle Fusion Middleware  11g web Tier.


#!/bin/ksh
# .profile for 11gAS ebs
#
export TWO_TASK=PRO0TS
export MWLS_HOME=/apps2/ebs/product/proxy_tst2
export ORACLE_HOME=$MWLS_HOME/webtier_pro0ts
export ORACLE_INSTANCE=/apps2/ebs/product/proxy_tst2/pro0ts_inst
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib32:/usr/lib:$LIBPATH
export PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/bin:$ORACLE_INSTANCE/bin:$ORACLE_HOME/opmn/bin::$ORACLE_HOME/OPatch:$ORACLE_INSTANCE/config/usr/bin:$PATH
OH=$ORACLE_HOME; export OH
OI=$ORACLE_INSTANCE; export OI

alias cdi='cd $OI'
alias cdo='cd $OH'

echo
env | sort | egrep 'ORA|TNS


  • Setup up your environments
  • you can edit 

/apps2/scratch/PROPERTY/FMW/Disk1/stage/Response/staticports.ini


Copy the modified ini files in temp directory for later conig.sh purpose.
./runInstaller



After your installation is completed.

edit your ssl conf file under

/apps2/ebs/product/inst/config/OHS/ohs1/ssl.conf based on your requirements 

ProxyRequests off
 NameVirtualHost *:4459
ServerName ebs.xxx.xxx
ServerAlias ebs
ProxyPass / http://ebs.xxx.xxx:4009/
ProxyPassReverse / http://ebs.xxx.xxx:4009/
   SSLEngine on
   SSLProxyEngine on
   SSLCipherSuite TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_3DES_EDE_CBC_SHA
   SSLProxyCipherSuite TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_3DES_EDE_CBC_SHA
   SSLProtocol -all +TLSv1

   SSLWallet "/apps2/oracle/local/certificates/wrkdir"
   SSLProxyWallet "/apps2/oracle/local/certificates/wrkdir"
   ErrorLog "${ORACLE_INSTANCE}/diagnostics/logs/${COMPONENT_TYPE}/${COMPONENT_NAME}/4459_error_log 43200"
   TransferLog "|${ORACLE_HOME}/ohs/bin/odl_rotatelogs ${ORACLE_INSTANCE}/diagnostics/logs/${COMPONENT_TYPE}/${COMPONENT_NAME}/4459_access_log 43200"
SSLVerifyClient None
   SSLProtocol nzos_Version_1_0 nzos_Version_3_0
   SSLCRLCheck Off


on the oracle application side apache side. you need to comment out the port number in httpd.conf 

 Port: The port to which the standalone server listens. For
# ports < 1023, you will need httpd to be run as root initially.
#
Port 4010
Listen 4010 


#
# Listen 4459
#


How to over ride your default port number in 12.2 for opmn, ohs

Before start Installing R12.2, take backup staticports.ini and  edit your 
 Stage122/TechInstallMedia/ohs11116/Disk1/stage/Response/staticports.ini file based on your requirements.


Oracle Solaris on SPARC (64-bit) requirement for R12.2

Hello:

If you are planning to move R12,2 on Solaris please check the oracle doc.

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Oracle Solaris on SPARC (64-bit) (Doc ID 1330702.1)

http://docs.oracle.com/cd/E26401_01/doc.122/e22953.pdf

How to find out your JKS keystore and store password in (EBS)

Source env
sqlplus apps/#########

set serveroutput on
declare
spass varchar2(30);
kpass varchar2(30);
begin
ad_jar.get_jripasswords(spass, kpass);
dbms_output.put_line(spass);
dbms_output.put_line(kpass);
end;

Thursday, March 17, 2016

LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

I renamed my oracle home /apps/ebs/product/oa11idev/12.1.0.2
I ran the opatch lsinventory

List of homes on this system:

 Home name= OraDB12Home6, Location= "/apps/ebs/product/12.1.0.2"

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo.

Action:
under my central inventory ContentsXML/inventory.xml, I added my new inventory home.


save the file.
$ opatch lsinventory 
...
......

oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

opatch napply -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /apps/ebs/product/oa11its/db11g/11.2.0.4
Central Inventory : /apps/ebsoraInventory
   from           : /apps/ebs/product/oa11its/db11g/11.2.0.4/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /apps/ebs/product/oa11its/db11g/11.2.0.4/cfgtoollogs/opatch/opatch2016-04-25_15-11-54PM_1.log

List of Homes on this system:

  Home name= PRO0TS, Location= "/apps/ebsproduct/oa11its/db11g/11.2.0.3"
 OPatchSession cannot load inventory for the given Oracle Home /apps/ebs/product/oa11its/db11g/11.2.0.4. Possible causes are:
   No read or write permission to ORACLE_HOME/.patch_storage
   Central Inventory is locked by another OUI instance
   No read permission to Central Inventory
   The lock file exists in ORACLE_HOME/.patch_storage
   The Oracle Home does not exist in Central Inventory

UtilSession failed: OracleHomeInventory gets null oracleHomeInfo
Log file location: /apps/ebs/product/oa11its/db11g/11.2.0.4/cfgtoollogs/opatch/opatch2016-04-25_15-11-54PM_1.log 

OPatch failed with error code 73

 /apps/ebs/product/oa11its/db11g/11.2.0.4 this home was corrupted.

solution:
go to your inventory location .eg /apps/OraInventory/ContentsXML

take copy of inventory.xml file.

remove the previous home from xml file and save.

go to   /apps/ebs/product/oa11its/db11g/11.2.0.4/oui/bin   

./runInstaller -ignoreSysPrereqs -attachHome ORACLE_HOME="/apps/ebs/product/oa11its/db11g/11.2.0.4" ORACLE_HOME_NAME="SID"


test opatch lsinventory