Changing Apps Password

Using FNDCPASS or AFPASSWD utility:-

FNDCPASS was introduced from 11.5.10


how to create the same user like apps:

CREATE USER PWCAPPS
  IDENTIFIED BY pwcapps
  DEFAULT TABLESPACE APPS_TS_TX_DATA
  TEMPORARY TABLESPACE TEMP1
  PROFILE DEFAULT
  ACCOUNT UNLOCK;

  GRANT CONNECT TO PWCAPPS;

  grant dba to pwcapps

  ALTER USER PWCAPPS DEFAULT ROLE ALL;



How to grep apps password in R12?

Recover apps password:

SQL> create FUNCTION apps.decrypt_pin_func(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';
  2  /

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13C3CC924FC0FA754C06691EDE3D58EEE5A03B10
713E6637AEB89167F9A8


SQL> select apps.decrypt_pin_func('GUEST/ORACLE','ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13C3CC924FC0FA754C06691EDE3D58EEE5A03B10713E6637AEB89167F9A8') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13
--------------------------------------------------------------------------------
APPDEV

AD Utilities

ADSPLICE :-

Application Cloning

Types of Cloning:

1.      Clone by using ADCLONE utility (adclone.pl)

2.      Clone by using Rapid Clone.

3.      Custom cloning methods.

4.      Automated Tools.

ADCLONE utility:- [upto 11.5.5]

Ø  This utility is used Autoconfig not Enabled applications.

Ø  adclone.pl is required to run Rapid Install and apply RDBMS and Technology Stack Patches to target system.

Rapid Clone:[ in11i migrate to Autoconfig ]

Ø  This utility is used Autoconfig Enabled applications.

	adclone.pl	Rapid Clone
Single to Single	Yes	Yes
Multi to Multi	Yes	Yes
Single to Multi	No	Yes
Multi to Single	No	Yes

Note:  In database version 8i adclone.pl and Rapid clone both are used, but in 9i onwards only use Rapid clone.

Features of Rapid Clone:

1.      Cloning single-node to multi-node vice versa.

2.      Adding a new node to an existing system.

3.      Cloning “Shared APPL_TOP”.

4.      Use Rapid clone from OAM also.

5.      Cloning RAC System.

6.      Adding node to an existing RAC cluster.

Steps for cloning:

There are 3 stage to clone.
1. prepare for cloning source and target
2. copy from source to Target
3. configuration for Target.

DB Tier

APPS Tier

Installation of Oracle Apps Stage11i

Installation of Oracle Apps Stage11i

Install Stage 11i in RHEL 6

Pre-Require RPM packages:

libXp-1.0.0-8.1.el5.i386.rpm

xorg-x11-deprecated-libs-6.8.2-1.EL.13.36.i386.rpm

 higher of Red Hat Enterprise Linux (RHEL) 6 is required

The following packages (or versions of packages) are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for both Oracle Linux 6 and RHEL 6 and installed manually on the application tier:

• openmotif21-2.1.30-11.EL6.i686 (32-bit)¹
• xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)

The following packages must be installed from the Oracle Linux 6 or RHEL 6 distribution media on both the application and database tiers:

• binutils-2.20.51.0.2-5.11
• compat-db43-4.3.29-15.el6.i686
• gcc-4.4.4-13.el16.x86_64
• gcc-c++-4.4.4-13.el16.x86_64
• glibc-2.12-1.7.el6.i686 (32-bit)
• glibc-2.12-1.7.el6.x86_64
• glibc-common-2.12-1.7.el6.x86_64
• glibc-devel-2.12-1.7.el6.i686 (32-bit)
• glibc-devel-2.12-1.7.el6.x86_64
• libgcc-4.4.4-13.el6.i686
• libgcc-4.4.4-13.el6.x86_64
• libstdc++-devel-4.4.4-13.el6.i686
• libstdc++-devel-4.4.4-13.el6.x86_64
• libstdc++-4.4.4-13.el6.i686
• libstdc++-4.4.4-13.el6.x86_64
• libXi-1.3-3.el6.i686
• libXp-1.0.0-15.1.el6.i686
• libXp-1.0.0-15.1.el6.x86_64
• libaio-0.3.107-10.el6.i686
• libaio-0.3.107-10.el6.x86_64
• libgomp-4.4.4-13.el6.x86_64
• make-3.81-19.el6.x86_64
• gdbm-1.8.0-36.el6.i686
• gdbm-1.8.0-36.el6.x86_64
• sysstat-9.0.4-11.el6.x86_64
• util-linux-ng-2.17.2-6.el6.x86_64
• unzip-5.52-3.0.1.el5.x86_64²
• compat-libstdc++-296-2.96-144.el6.i686
• compat-libstdc++-33-3.2.3-69.el6.i686

Additionally, the following RPMs are required for the database tier running 11gR2 (users must upgrade the bundled 11gR1 DB to 11gR2 either before or after installing 12.1) on the database tier:

• compat-libcap1-1.10-1.x86_64
• compat-libstdc++-33-3.2.3-69.el6.x86_64
• elfutils-libelf-devel-0.148.1-el6.x86_64
• kernel-headers-2.6.32-71, kernel-uek-headers-2.6.32-100.28.5.el6.x86_64
• libaio-devel-0.3.107-10.el6.x86_64
• unixODBC-2.2.14-11.el6.i686
• unixODBC-devel-2.2.14-11.el6.i686
• unixODBC-2.2.14-11.el6.x86_64
• unixODBC-devel-2.2.14-11.el6.x86_64
• xorg-x11-utils-7.4-8

Note:

¹: The openmotif package version must be 2.1.30 (for example, openmotif-2.3.3-1 is not supported).
²: This unzip package (available from EL 5 distribution) is only required for purposes of running Rapid Install to unzip the required EBS files as part of the installation and should be reverted after the install of EBS. Alternatively, users can backup the existing unzip 6.0 in /usr/bin, copy the unzip 5.5 from the EBS staging directory to /usr/bin for purposes of installing EBS, and then restore the unzip 6.0 when done.

**********************************************************

Errors & Solutions:

Error:-

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

RW-50010: Error: - script has returned an error:   1

RW-50004: Error code received when running external process.  Check log file for details.

Solution:

In a seperate login session as root rename /usr/bin/unzip (version 6) to a temporary filename and then rename it back after your installation is complete.

# mv /usr/bin/unzip /usr/bin/unzip-ver6

Error:

Cause: Invalid C++ and/or gcc compiler.

Solution:

Error:- System Utility Check Failed

Unable to find PD KSH version

Unable to find in user PATH

Solution:- export following parameter before running rapidwiz,

export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'


Error:

While Installing Oracle Applications 12.1.1 in Linux 5 update 7

We encountered with an issue:

adapcctl.sh exiting with status 204

Solution:
1. Shut down all Oracle Application Services
2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Start up all Oracle Application Services