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'

Oracle apps upgrade 11.5.10.2 to 12.2

Oracle® E-Business Suite Upgrade Guide Release 11i to 12.2 Part No. E48834-03

https://docs.oracle.com/cd/E51111_01/current/html/docset.html

Extensions - Log Warning(38,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead Warning(39,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead

Use "Headless" Instead (Doc ID 2030725.1)