How to Retrieve Forgotten Apps Password in Oracle EBS R12

 Steps:

 1: log in to the database server with sys user

 sqlplus / as sysdba

 2: Create Function to decrypt the encrypted 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';
 /

 3 : Query for Encrypted password


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


 Output

 ENCRYPTED_FOUNDATION_PASSWORD
 --------------------------------------------------------------------------------
 ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A

 4: Past the Encrypted password from the above query output into the below query and execute

 SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A') from dual;


 Output

 APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A')
 --------------------------------------------------------------------------------
 India123

 5: Test apps password is working or not

Conn apps

Enter password 

sample tnsnames.ora file

The Oracle installer generally places a sample tnsnames.ora file in your
$ORACLE_HOME/network/admin directory, but you can create tnsnames.ora file by using below template.

Here is a sample tnanames.ora file for a oracle database:

TOTEST =-------------->tns name,it can be any name in my case it is connection from DEV to TEST
  (DESCRIPTION =
    (ADDRESS_LIST
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12cdb.techgig.com)(PORT = 1529))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DEV)
    )

Unable to access weblogic console from none of the browser's after fresh installation of Oracle EBS 12.2

Error:

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

              

                  

Cause:

In config.xml file <connection-filter-rule> was deny

cd $FMW_HOME/user_projects/domains/EBS_domain_TEST/config/

$vi config.xml file

<connection-filter-rule>ebsdev.oracle.com * * allow</connection-filter-rule>

   <connection-filter-rule>0.0.0.0/0 * * deny</connection-filter-rule>

Solution:

cd $FMW_HOME/user_projects/domains/EBS_domain_TEST/config/

Backup the config.xml file and change <connection-filter-rule> from deny to allow

Steps:

[applmgr@ebsdev config]$ cp config.xml config.xml_oirg

open config.xml file and search for deny and replace it by allow

[applmgr@ebsdev config]$ vi config..

<connection-filter-rule>ebsdev.oracle.com * * allow</connection-filter-rule>

   <connection-filter-rule>0.0.0.0/0 * * allow </connection-filter-rule>

Bounce the application services and try it

Oracle EBS 12.2 Online Patching Questions Answers

1.What is Online Patching?

Online patching is a new patching mechanism that allows the application of patches while the system is up and running, and the users are working as normal.

2.Which Oracle E-Business Suite releases can Online Patching be used with?

Online patching is used with Oracle E-Business Suite 12.2 and higher.

3.What types of patch are applied online?

All Oracle E-Business Suite Release 12.2 patches are applied online. This includes one-off patches, patch rollups, consolidated updates and security patches.

4.What is the Online Patching cycle?

The Online Patching cycle is a sequence of inter-related steps (phases) used to apply patches to an Oracle E-Business Suite system.

5.What tool is used to apply online patches?

The AD Online Patching (adop) command-line utility is used to manage the Online Patching cycle.

6.Is there any downtime in Online Patching?

There is a short period of downtime when the application tier services are shut down and restarted. The database remains open all the time.

7.Do I upgrade to Release 12.2 with Online Patching?

No. After you upgrade to Oracle E-Business Suite Release 12.2, you will enable Online Patching.

8.Once I upgrade to Release 12.2, can I still apply patches in the traditional way?

No. All patches for Release 12.2 will be online patches. The traditional, pre-12.2 method of applying patches will not work.

9.What are the phases that make up the Online Patching cycle?

The Online Patching cycle consists of the following phases:

Prepare a virtual copy (patch edition) of the running application (run edition).

Apply patches to the patch edition of the application.

Finalize the system in readiness for the cutover phase.

Cutover to the patch edition and make it the new run edition.

Cleanup obsolete definitions or data to recover space.

Toad Error - Cannot load OCI DLL: C:\Oracle\instantclient_11_1\oci.dll

Toad Error - Cannot load OCI DLL: C:\Oracle\instantclient_11_1\oci.dll

Or

Oracle Home is not Valid on TOAD
 Instant Client - 11.2.0.1.0
ORACLE_HOME_NAME: C:\Oracle\app\product\11.2.0\client_1\bin
ORACLE_HOME: C:\Oracle\app\product\11.2.0\client_1\bin
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
C:\Oracle\app\product\11.2.0\client_1\bin exists.
C:\Oracle\app\product\11.2.0\client_1\bin is in PATH.
Client DLL: C:\Oracle\app\product\11.2.0\client_1\bin\oci.dll
Client Version: 11.2.0.1.0
Home is NOT valid!


Solution:

Toad only works with Oracle11g client-32 bit on Windows 10- 64 bit or any version of windows,in my case it was windows 10-64bit.

firstly i was installed Oracle11g client 64bit on Windows 64 bit and was getting error as above mentioned then
de installed and installed 11gclient-32bit on Windows-64 bit,after that toad is working fine.

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?

1.How to find E-Business Suite Version: 
Connect to the database with sqlplus as user apps and run query:
SQL> select release_name from apps.fnd_product_groups;

2.How to find the Workflow Version: 
Connect to the database with sqlplus as user apps and run query:
SQL> select distinct TEXT Version from WF_RESOURCES where NAME = 'WF_VERSION';

3.How to find the Web Server or Application Server version: 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

4.How to find the Forms & Reports version in EBS 11i 
Logon the Applications Middle-tier as the Application owner(ex:applmgr), using a putty terminal.
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

5.How to find the Forms & Reports version in EBS R12 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/rwrun | grep Release

6.How to find the Jinitiator version: 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep jinit_ver_comma $CONTEXT_FILE

7.How to find the Oracle Java Plug-in version: 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep plugin $CONTEXT_FILE

8.How to find the OA Framework Version (11i only): 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

9.How to find the Database version: 
Connect to the database with sqlplus as sysdba and run query:
SQL> select * from v$version;

10.How to find the Weblogic server version in EBS R12.2: 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

11.How to find the Fusion Middleware (FMW) version in EBS R12.2 
Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables.
Set the correct ORACLE_HOME variable:
E.g. export ORACLE_HOME=/u001/oracle/R122/FMW_Home/Oracle_EBS-app1
Run next command:
$ORACLE_HOME/OPatch/opatch lsinventory

After cloning,FNDCPASS hangs when changing SYSADMIN password - log file says Working...

Note:This solution applied on clone environment


Error in log file:
############################################################################

devapp:UAT-APP:[/home/applmgr]$ cat L2355305.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 05-NOV-2018 23:18:24

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** USER SYSADMIN *****
+----------------------------------------------------------------------------+
Working...


Solution
###############################################################################
1.Shutdown application
2.Shutdown database
3.Start database
4.Run autoconfig on DbTier
5.Run autoconfig on AppsTier
6.Start Application
7.Changed sysadmin password successfully

Command:

FNDCPASS apps/<pwd> 0 Y system/<pwd> USER SYSADMIN <new pwd>

Log file:
################################################################################
devapp:UAT-APP:[/home/applmgr]$cat L2365260.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 06-NOV-2018 01:55:24

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** USER SYSADMIN *****
+----------------------------------------------------------------------------+
Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 06-NOV-2018 01:55:29

+---------------------------------------------------------------------------+