Archive for May 2014

R12.2 Changing APPS or APPLSYS Password on R12.2 Instance   13 comments

Last Night one of my friend called me and asked how to change the apps or applsys password on R12.2

Here are steps:

Presently Application is working normal

1

Now lets change APPLSYS password

Important: These steps must be carried out on the run file system.

1. Shut down the application tier services using the

$INST_TOP/admin/scripts/adstpall.sh

2

2. Change the APPLSYS password.

FNDCPASS apps/<existing apps passwd>  0 Y system/<system password> SYSTEM APPLSYS <new apps passwd>

3

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS testpwd

 

3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh

script. Do not start any other application tier services.

4

4. Change the “apps” password in WLS Datasource as follows:

  • Log in to WLS Administration Console.

http:/r122.localdomain:7002/console

5

  • Click Lock & Edit in Change Center.
  • 6
  • In the Domain Structure tree, expand Services, then select Data Sources.
  • 7
  • On the “Summary of JDBC Data Sources” page, select EBSDataSource
  • On the “Settings for EBSDataSource” page, select the Connection Pool tab.
  • 8
  • Enter the new password in the “Password” field.
  • Enter the new password in the “Confirm Password” field.
  • Click Save.
  • 9
  • Click Activate Changes in Change Center.
  • 10

Check whether you are able to connect to db using apps

sqlplus apps/<newpassword> from application tier.

Before Starting all the services. Run Autoconfig.

cd $ADMIN_SCRIPTS_HOME

sh adautocfg.sh

Now start the services.

  • Start all the application tier services using the
  • $INST_TOP/admin/scripts/adstrtal.sh script.

11

6. Verify the WLS Datastore changes as follows:

  • Log in to WLS Administration Console.
  • In the Domain Structure tree, expand Services, then select Data Sources.
  • On the “Summary of JDBC Data Sources” page, select EBSDataSource.
  • On the “Settings for EBSDataSource” page, select Monitoring > Testing.
  • Select “oacore_server1”.
  • Click Test DataSource
  • Look for the message “Test of EBSDataSource on server oacore_server1 was successful”.
  • 12

Posted May 15, 2014 by balaoracledba.com in R12.2

R12.1.1 to R12.1.3 Upgrade.   Leave a comment

In this post i am going to list out the steps to upgrade R12.1.1 to R12.1.3

NOTE: Please make a note that i have not included pre and post patch steps while applying patches. Please go-through the patch README’s carefully while applying patches…….

Step1: 

Upgrade Database from 11.1.0.7 to 11gr2. I have upgraded from 11.1.0.7 to 11.2.0.2. 

Please follow below URL for Database upgrade for R12.1.1 EBS
https://balaoracledba.com/2013/11/13/upgrade-11-1-0-7-to-11-2-0-2-on-r12-1-1/
Step2:

Put the application under maintainence using adadmin 

Step3. 

Apply below patch
8919491.B                  Oracle Applications Technology 12.1.3 Product Family Release Update Pack

Step4

Apply Below Patch
17884289 R12.AD.B.Delta.4

Step5:

Apply Below Patch

9239090              R12                    ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK


Step6:

Apply Below Patch
9239095.                      R12Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack


Step7:

Apply Below Patch

9817770.BPOST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH

Step8: 

Apply Below patch

9966055.B1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED

Step9:  

Run AutoConfig on the APPL_TOP.

Step10:

Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.Step9:

Run AutoConfig on the APPL_TOP.
perl <AD_TOP>/bin/admkappsutil.pl

Step11:

Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>.

Step12:

Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.

Step13:

unzip the appsutil.zip  as below

unzip -o appsutil.zip

Step14: 

Run AutoConfig on the <RDBMS ORACLE_HOME>.

Step15:

Re-run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business 
Suite Release 12.1.3 were applied to the system, adpreclone must be run again to apply the updates 
to the clone directory structures that were used during cloning.

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier
This finishes the Application upgrade.
Start the Application Tier Services.
NOTE:After finishing the application upgrade. we need to apply product family patches.
(IN THIS UPGRADE I DIDNT APPLIED BELOW PRODUCT SPECIFIC PATCHES)
Patch Product Family Product Family Readme Documents
Oracle Applications Technology Release 12.1.3 (R12.ATG_PF.B.DELTA.3) Patch 8919491 Applications Technology (ATG_PF) Document 1066312.1
Oracle Customer Releationship Management Release 12.1.3 (R12.CC_PF.B.DELTA.3) Patch 9249345 Customer Relationship Management (CC_PF) Document 1081433.1
Oracle Financials Release 12.1.3 (R12.FIN_PF.B.DELTA.3) Patch 9147733 Financials (FIN_PF) Document 1081425.1
Oracle Human Resource Management System Release 12.1.3 (R12.HR_PF.B.DELTA.3) Patch 9114911 Human Resources (HR_PF) Document 1081427.1
Oracle E-Business Suite Diagnostics Release 12.1.3 (R12.IZU.B.DELTA.3) Patch 9239092 E-Business Suite Diagnostics (IZU) Document 1081428.1
Oracle Procurement Release 12.1.3  (R12.PRC_PF.B.DELTA.3) Patch 9249354 Procurement (PRC_PF) Document 1081431.1
Oracle Projects Release12.1.3 (R12.PJ_PF.B.DELTA.3) Patch 9147711 Projects (PJ_PF) Document 1081434.1
Oracle Supply Chain Management Release 12.1.3 (R12.SCM_PF.B.DELTA.3) Patch 9245674 Supply Chain Management (SCM_PF) Document 1081459.1
Oracle Value Chain Planning Release 12.1.3 (R12.SCP_PF.B.DELTA.3) Patch 9245525 Oracle Value Chain Planning (SCP_PF) Document 1081461.1

	

Posted May 7, 2014 by balaoracledba.com in 11i/R12, OracleAppsR12, Upgrade