Monday, November 30, 2015

EBS R12 Form Socket Mode Change





EBS R12 Form Socket Mode Change
Environment:
Apps Tier– Oracle EBS R12.1.3 on Oracle Linux EL 6.7 64bit
Database Tier– Database 11.2.0.4 on Oracle Linux EL 6.7 64bit
Instance Name: VIS
Accounts – applmgr (Apps Tier) and oravis (DB tier)
Host Names: ebsapps.oracle (Apps tier) and ebsdb.oracle(db tier)
Application Environment set to applmgr user (VIS_ebsapps.env)
Database Envinoment set to oravis user(VIS_ebsdb.env)

Oracle Notes:
Using Forms Socket Mode with Oracle E-Business Suite Release 12 (Doc ID 384241.1)
Check Form Mode
·         Log in to Apps tier with applmgr account
$grep frmConnectMode $CONTEXT_FILE
servlet
Enabling Socket Mode
·         STOP EBS services & enables Maintenance mode using adadmin
$cd $ADMIN_SCRIPTS_ALL
$adstpall.sh apps/apps

·         Execute following command
$FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket -port=9030 -runautoconfig=No
-       9095 is default port number

·         Execute System Command (Optional)
$netstat –a

·         Run Auto Config
$cd $ADMIN_SCRIPTS_ALL
$adautocfg.sh

·         Start EBS Application Services
$cd $ADMIN_SCRIPTS_ALL
$adstrtal.sh apps/apps
Manually Start/Stop From
·         Start Form Server
$INST_TOP/admin/scripts/adformsrvctl.sh start
·         Stop Form Server
$INST_TOP/admin/scripts/adformsrvctl.sh stop
·         Status Form Server
$INST_TOP/admin/scripts/adformsrvctl.sh status

Thursday, November 26, 2015

EBS R12 Components Installed Versions

How to Check EBS R12 Installed Tools Version:

Execute following Scripts to know each component versions.



  • Orace As 10g Version:   cat $CONTEXT_FILE | grep ias_version
  • Apache Version: $IAS_ORACLE_HOME/Apache/Apache/bin/httpd –v
  • Perl Version: $IAS_ORACLE_HOME/perl/bin/perl -v|grep built
  • Java Version: sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
  • Client JRE Version: cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
  • JAVA Plugin Version: cat $CONTEXT_FILE | grep plugin
  • Forms Version: $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
  • Reports Version: $ORACLE_HOME/bin/rwrun | grep Release
  • PLSQL Version: $ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
  • Form Communication Mode: If bellow returns some value it is in servlet mode, if not socket mode.
          cat $FORMS_WEB_CONFIG_FILE|grep serverURL=


  • OUI Version: $IAS_ORACLE_HOME/oui/oraparam.ini | grep OUI_VERSION

  • DB Version: select banner from v$version;
  • Application Release: select release_name from apps.fnd_product_groups;