Apps DBA Workshop

After successful completion of fresh installation of R12.1.1 on OEL(Oracle Eneterprise Linux 5.5), there was an error while accessing form server. All other services and application are working fine. When we are trying to access form Server its giving error as below: When we click on details: This error message is because of the missing rpm openmotif21-2.1.30-11.EL5.i386.rpm on Linux OS. You can download this rpm from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ After Installing this rpm bounce the middle tiers and access form server. Issue must be resolved. Happy reading :)

Hi, This post will illustrate steps for migrating datafiles from UFS (or any other file system) to ASM Disk groups. Step1: Perform Full Rman Database backup: Step2: Shut down and startup database in mount; SQL> startup mount ORACLE instance started. Total System Global Area 1720844288 bytes Fixed Size 2159024 bytes Variable Size 1241517648 bytes Database Buffers 469762048 bytes Redo Buffers 7405568 bytes Database mounted. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Step 3: Connect database target using rman utility and use command COPY database. bash-3.00$ rman Recovery Manager: Release 11.2.0.2.0 - Production on Wed Oct 27 13:01:51 2010 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN> connect target\ target database Password

After applying HRMS family pack K (11i.HR_PF.K and 11i.HR_PF.K.DELTA.5) HRMS functional consultant updated that he is not able to access Approvals Management Responsibility. There are certain changes with this family pack. To overcome this issue please follow below steps as described. Error message while accessing responsibility: Content-type: text/html; charset=WINDOWS-1256 Location: http://orasolerp.orasol.com:8011/oa_servlets/oracle.apps.fnd.sso.AppsLogin?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Forasolerp.orasol.com%3A8011%2Foa_servlets%2Foracle.apps.fnd.sso.AppsLogin&errText=Please%20contact%20the%20Web%20Master%20or%20System%20Administrator.%20ORA-01403%3A%20no%20data%20found%0AORA-06512%3A%20at%20%22APPS.AME_UI%22%2C%20line%20496%0AORA-06512%3A%20at%20%22APPS.AME_RULES_UI%22%2C%20line%206055%0AORA-01403%3A%20no%20data%20found%0A 1) AME responsibility cannot be accessed. Problem: This issue is described in Metalink Note 336901.1 Ext/Pub Oracle Approvals Management Im