After Change GRC Admin User password Update PEA.PROPERTIES in ERP Database R12

   
To implement the solution, follow these steps:

If EBS had PEA installed earlier and working fine before installing/upgrading after which issue is showing up then do step 1 and 2 otherwise go directly to step 3.

1. Login to EBS database server and go to previous PEA stage location.

2. Run following to drop previous java files footprint, make sure to replace value of x with actual value:

Run this command from OS Prompt.

cd /home/oracle/grc2/grc866

dropjava -user apps/password -force -verbose -resolve lib/grc-encryption-8.6.6.1-SNAPSHOT.jar
dropjava -user apps/password -force -verbose -resolve lib/grc-peacommon-8.6.6.1-SNAPSHOT.jar
dropjava -user apps/password -force -verbose -resolve lib/grc-peaebs-8.6.6.1-SNAPSHOT.jar

3. Go to latest PEA stage location.

4. Run following to drop latest java files footprint, make sure to replace value of x with actual value:

dropjava -user apps/password -force -verbose -resolve grcc.properties
dropjava -user apps/password -force -verbose -resolve pea.properties

5. Run following to reinstall java part of latest PEA:

a. Update the install.properities file with correct values.

like apps user password and other required user password.

b. Run following:

Execute the following commands. These commands should not error out:

Run those command first for removing old password.

conn sqlplus / as sysdba - and run below command.


SQL> call dbms_java.dropjava('-verbose com/oracle/grcc/pea/common/PEAProperties.class');

Call completed.

SQL> call dbms_java.dropjava('-verbose pea.properties.class');

Call completed.

SQL> call dbms_java.dropjava('-verbose grcc.properties.class');

Call completed.

SQL>

c. Set the DB environment of APPS (the Oracle EBS database) and execute the installation program:

java -jar grc-peainstallation-8.6.6.1-SNAPSHOT.jar -ebs -manual

This parameter use for test server.
===========================================================
Take this information for providing run time parameter values
=============================================================
The installation program prompts for property values required by the PEA:

• Enter GRCC user name
If you created a wsclient user on your GRC instance, supply the value wsclient here. If not, supply the user name configured for admin user.

• Enter GRCC password
Enter the password for the user identified in the previous property.

• Enter GRCC server name
Supply the fully qualified server name of the server on which GRC is installed. To verify, ping the GRC server from the server where the PEA is being installed.

• Enter GRCC port number
Supply the port number at which the GRC server communicates with other applications.

• Enter GRCC web services URL
This property specifies the URL of the webservice where the GRC instance is installed. This URL should be /grc/services/GrcService/

• Enter GRCC web services timeout
Enter a timeout, in seconds, for communication with the Oracle EBS server. The default value is 60.

• Enter datasource ID
Supply the datasource ID assigned by GRC to the Oracle EBS instance in which you are installing the PEA. (This value is available in the GRC Manage Application Datasources page; see “Determining Datasource IDs,” page 4-7).

After you enter the datasource ID, the installation program presents the prompt, “Connect to GRC server using SSL? (Yes/No).”
• If you select No, PEA installation proceeds without support for SSL.

• If you select Yes, the installation program prompts for an SSL truststore name and an SSL truststore password. Enter the values you created as you ran the keytool command (see “PEAs and SSL” on page 6-1).

d. Run following:

loadjava -user apps/password -force -verbose -resolve lib/grc-encryption-8.6.6.1-SNAPSHOT.jar
loadjava -user apps/password -force -verbose -resolve lib/grc-peacommon-8.6.6.1-SNAPSHOT.jar
loadjava -user apps/password -force -verbose -resolve lib/grc-peaebs-8.6.6.1-SNAPSHOT.jar

e. Run following:

loadjava -user apps/password -force -verbose -resolve grcc.properties
loadjava -user apps/password -force -verbose -resolve pea.properties

6. Bounce the EBS and GRC Application server.

7. Retest the issue.

After Complete this steps. need compile invalied objects..

Bounce is not Required.