Friday, November 16, 2018

Java Web Start

Using Java Web Start with Oracle E-Business Suite (Doc ID 2188898.1)

Tuesday, October 9, 2018

E B S Default Port

Table of Ports Used by Oracle E-Business Suite

Variable NameDescriptionDefault ValueTechnologyComponent
s_dbportPort on the database server used by the database listener1521RDBMSTNS listener
s_rpcportRPC port on the concurrent processing server that receives incoming Report Review Agent requests1626ApplicationsApplication tier TNS listener
s_formsport(a)Port on the Forms server used by the Forms Listener9000Forms 10Forms
s_mwaPortNoMSCA Server Port Number10200ApplicationsMobile
s_mwaDispatcherPortMSCA Dispatcher Port Number10300ApplicationsMobile
s_webportPort on the webserver where http server listens for non-SSL requests8000Oracle Fusion MiddlewareOracle HTTP Server
s_webssl_portPort on the webserver where http server listens for SSL requests4443Oracle Fusion MiddlewareOracle HTTP Server
s_active_webportValue of this variable is set to value of s_webport when Listener is configured in non-SSL mode and to the value of s_webssl_port when ssl is configured8000/4443Oracle Fusion MiddlewareOracle HTTP Server
s_jtfuf_portJTF fulfilment server port11000ApplicationsJTF
s_ons_localportOracle Notification Service6100Oracle Fusion MiddlewareOPMN (manages OHS & oc4j)
s_ons_remoteportOracle Notification Service6200Oracle Fusion MiddlewareOPMN
s_ons_requestportOracle Notification Service6500Oracle Fusion MiddlewareOPMN
s_ohs_adminportOHS Administration Proxy Port9999 Oracle HTTP Server
s_java_object_cache_portJava Object Cache Port12345Oracle Fusion MiddlewareJava Object Cache
(a) Forms server (socket mode) is optional (and not recommended) in Oracle E-Business Suite Release 12. The default is servlet mode.

Table of Ports Used by WebLogic Server

Oracle E-Business Suite Release 12.2 uses WebLogic Server (WLS) as its servlet container. WLS uses the following ports:

Variable NameDescriptionDefault ValueFirewall ConfigurationTechnologyComponent
s_nm_portWLS Node Manager Port5556 Oracle Fusion MiddlewareWLS
s_wls_adminportWLS Admin Server Port7001Internal application tiers assumed to be on same subnetOracle Fusion MiddlewareWLS
s_wls_oacoreportWLS OACORE Application Port7201 Oracle Fusion MiddlewareWLS
s_wls_formsportWLS FORMS Application Port7401 Oracle Fusion MiddlewareWLS
s_wls_oafmportWLS OAFM Application Port7601 Oracle Fusion MiddlewareWLS
s_wls_forms-c4wsportWLS FORMS-C4WS Application Port7801 Oracle Fusion MiddlewareWLS
s_wls_wcportletportWLS Portlet Application Port8889 Oracle Fusion MiddlewareWLS
s_wls_oaeaportWLS OAEA Application Port6801 Oracle Fusion MiddlewareWLS

Oracle E-Business Suite Processes

 Processes Used by Oracle E-Business Suite


Process NameDescriptionScript
tnslsnrApplications RPC listener processadalnctl.sh
opmnProcess manager (starts httpd)adopmnctl.sh
httpdApache Web Server Listeneradapcctl.sh
java -Dweblogic.Name=AdminServerWebLogic Administration Serveradadminsrvctl.sh
java weblogic.NodeManagerNode manageradnodemgrctl.sh
java -Dweblogic.Name=oacore_server1oacore managed serveradmanagedsrvctl.sh start oacore_server1
java -Dweblogic.Name=forms_server1Forms managed serveradmanagedsrvctl.sh start forms_server1
java -Dweblogic.Name=oafm_server1oafm managed serveradmanagedsrvctl.sh start oafm_serverS1
FNDSM
FFTM
RCVOLTM
POXCON
INTCM
FNDCRM
PALIBR
MRCLIB
FNDLIBR
INVLIBR
Concurrent Manageradcmctl.sh
java oracle.apps.jtf.fm.engine.processor.Processor java oracle.apps.jtf.fm.engine.remote.RemoteCommandFulfillment Server processjtffmctl.sh
 Forms Server (a)adformsrvctl.sh

Thursday, September 27, 2018

How to get your apps password if you forgot

drop FUNCTION apps.decryptappspwd;


create FUNCTION apps.decryptappspwd(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
 RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

Function created.



 select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA
3110B72BE0743CD4576B

SQL> SELECT apps.decryptapps pwd('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA3110B72BE0743CD4576B') from dual;

APPS.DECRYPTAPPSPWD('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D91653
--------------------------------------------------------------------------------
APPS

Wednesday, June 27, 2018

How to restore /etc/inittab file in OL6.9?

Accidentally /etc/inittab file removed.

Cause GUI is not coming up. It goes to single user mode.

How to restore the file?

Once you login into single user mode as root.

#echo "id:5:initdefault:" > /etc/inittab
#reboot

you can see the GUI mode.