E B S Default Port

Table of Ports Used by Oracle E-Business Suite

Variable Name	Description	Default Value	Technology	Component
s_dbport	Port on the database server used by the database listener	1521	RDBMS	TNS listener
s_rpcport	RPC port on the concurrent processing server that receives incoming Report Review Agent requests	1626	Applications	Application tier TNS listener
s_formsport(a)	Port on the Forms server used by the Forms Listener	9000	Forms 10	Forms
s_mwaPortNo	MSCA Server Port Number	10200	Applications	Mobile
s_mwaDispatcherPort	MSCA Dispatcher Port Number	10300	Applications	Mobile
s_webport	Port on the webserver where http server listens for non-SSL requests	8000	Oracle Fusion Middleware	Oracle HTTP Server
s_webssl_port	Port on the webserver where http server listens for SSL requests	4443	Oracle Fusion Middleware	Oracle HTTP Server
s_active_webport	Value 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 configured	8000/4443	Oracle Fusion Middleware	Oracle HTTP Server
s_jtfuf_port	JTF fulfilment server port	11000	Applications	JTF
s_ons_localport	Oracle Notification Service	6100	Oracle Fusion Middleware	OPMN (manages OHS & oc4j)
s_ons_remoteport	Oracle Notification Service	6200	Oracle Fusion Middleware	OPMN
s_ons_requestport	Oracle Notification Service	6500	Oracle Fusion Middleware	OPMN
s_ohs_adminport	OHS Administration Proxy Port	9999		Oracle HTTP Server
s_java_object_cache_port	Java Object Cache Port	12345	Oracle Fusion Middleware	Java 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 Name	Description	Default Value	Firewall Configuration	Technology	Component
s_nm_port	WLS Node Manager Port	5556		Oracle Fusion Middleware	WLS
s_wls_adminport	WLS Admin Server Port	7001	Internal application tiers assumed to be on same subnet	Oracle Fusion Middleware	WLS
s_wls_oacoreport	WLS OACORE Application Port	7201		Oracle Fusion Middleware	WLS
s_wls_formsport	WLS FORMS Application Port	7401		Oracle Fusion Middleware	WLS
s_wls_oafmport	WLS OAFM Application Port	7601		Oracle Fusion Middleware	WLS
s_wls_forms-c4wsport	WLS FORMS-C4WS Application Port	7801		Oracle Fusion Middleware	WLS
s_wls_wcportletport	WLS Portlet Application Port	8889		Oracle Fusion Middleware	WLS
s_wls_oaeaport	WLS OAEA Application Port	6801		Oracle Fusion Middleware	WLS

Oracle E-Business Suite Processes

 Processes Used by Oracle E-Business Suite

Process Name	Description	Script
tnslsnr	Applications RPC listener process	adalnctl.sh
opmn	Process manager (starts httpd)	adopmnctl.sh
httpd	Apache Web Server Listener	adapcctl.sh
java -Dweblogic.Name=AdminServer	WebLogic Administration Server	adadminsrvctl.sh
java weblogic.NodeManager	Node manager	adnodemgrctl.sh
java -Dweblogic.Name=oacore_server1	oacore managed server	admanagedsrvctl.sh start oacore_server1
java -Dweblogic.Name=forms_server1	Forms managed server	admanagedsrvctl.sh start forms_server1
java -Dweblogic.Name=oafm_server1	oafm managed server	admanagedsrvctl.sh start oafm_serverS1
FNDSM FFTM RCVOLTM POXCON INTCM FNDCRM PALIBR MRCLIB FNDLIBR INVLIBR	Concurrent Manager	adcmctl.sh
java oracle.apps.jtf.fm.engine.processor.Processor java oracle.apps.jtf.fm.engine.remote.RemoteCommand	Fulfillment Server process	jtffmctl.sh
	Forms Server (a)	adformsrvctl.sh

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

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.

Oracle support TLS 1.2 Only

Oracle removing support for legacy Transport Layer Security (TLS) protocols in order to ensure improved security and performance. Beginning on July 31, 2018, Object Storage Classic will no longer support TLS 1.0/1.1 and will support only TLS 1.2 or higher.

we need to update all client-server combinations to use TLS version 1.2. Additionally, we recommend that you update any tooling which connects to Object Storage Classic (e.g., cloudberry, rman backups, etc.) to use TLS 1.2. To help ensure a smooth transition, we recommend using Java Runtime Environment release 7 or higher. Additionally, for those who use File Transfer Manager command-line interface (FTM CLI), we recommend using version 2.4 or higher to address unrelated feature enhancements and fixes; however, updating FTM CLI is not required to accommodate the transition from TLS 1.0/1.1.

How to determine Java version

Java (Unix/Linux) 

Run the following from the command line: 

 java -version

FTM CLI

Run the following from the command line:

 java -jar ftmcli.jar -v
 
 
 

Cipher Options for Oracle Fusion Middleware's

New SSL Protocol and Cipher Options for Oracle Fusion Middleware's OPMN/ONS Component ( Doc ID 1905314.1 )

X11 forwarding

xclock and local forwarding

Make sure xclock is installed.
.profile

MAIL=/usr/mail/${LOGNAME:?}
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/NX/bin:/sbin:/usr/sbin:/usr/local/sbin:.
export EDITOR=vi
HOSTNAME=`hostname|cut -f 1 -d .`

if [[ ! "$SUDO_USER" = "" ]]
then
  export OS_HOME=`dirname $HOME`
  export XAUTHORITY=$OS_HOME/$SUDO_USER/.Xauthority
  echo "XAUTHORITY = $XAUTHORITY"
fi

WHOAMI=`whoami`
export PS1='$WHOAMI@$HOSTNAME$'
set -o vi
umask 027
alias lsf='ls -F'
alias lsa='ls -aF'
alias bdf='df -k'
alias psa='ps -afe|grep $1'
alias cdp='cd /apps/oracle/local/profiles; ls -a'
alias cdo='cd $ORACLE_HOME'