Upgrading Application [ 11i CU1 to 11i CU2 ] and Database [ 9.2.0.6 to 11.2.0.1 ]

2011-01-12T09:49:00.000-08:00

Hello All, Recently I was involved in the upgrade [ application and database ] Here is the walkthrough of the project. ::::::::::::::::::::: Overview ::::::::::::::::::::: : Existing System : Application version : 11.5.10.1 [ 11i CU1 ] Database version : 9.2.0.6 [ 9iR2 ] : Target System : Application version : 11.5.10.2 [ 11i CU2 ] Database version : 11.2.0.1 [ 11gR2 ]

Metalink Note-IDs related to Concurrent Managers

2010-05-26T12:39:00.000-07:00

1) Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) [ID 104282.1] 2) Purge Concurrent Request FNDCPPUR Does Not Delete Files From File System or Slow performance [ID 822368.1] 3) Best Practices for Performance for Concurrent Managers in E-Business Suite [ID 1057802.1] 4) Using the Output Post Processor (OPP) in Oracle Applications Concurrent

Notification Mailer Issue - Unable to approve/reject leave/PO using Outlook

2010-04-24T00:16:00.000-07:00

Hello All, Few days back , HRMS Team enabled the functionality to Approve/Reject the Employee's Leave through Mail ; But the User started complaining that the functionality is not working for few employees. So after analysing the issue, we found out that the employees/managers who approve/reject the leave through "Webmail" were able to approve/reject the leave ; The employees/manager who use

Unable to login into ERP through SSO -- 500 Internal Server Error

2010-04-04T03:06:00.000-07:00

Hi All, Few days back , Users started complaining that they are unable to login into ERP. Our Current Setup : When the user enters the credentials , it is authenticated by IDM [with Sun LDAP ] and generates the token and once IDM authenticates , the request is forwarded to OID with the token , OID accepts the token and checks the user accounts in OID. Error : When the User enters the login

Forms runaway processes used to consume the CPU 100%

2010-01-02T05:35:00.000-08:00

Hi All, Here we have Two Application nodes and user requests are controlled by hardware load balancer. Few days back , the OS team complained us about the CPU 100% utilization by frmweb processes on both the servers. Issue : frmweb process are consuming 100%CPU utilization on the Server thereby increasing the load . viz: On Oracle Applications R12 when checking the top processes on the OS

[ Issue ] FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file

2009-09-23T02:26:00.000-07:00

Error : **Starts**14-SEP-2009 16:45:36 ORACLE error 20100 in FDPSTP FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, oklslagl.tmp in the directory, [/usr/tmp]. You will find more information in the request log. ORA-06512: at "APPS.FND_FILE", line 417 Cause : Unable to create the [filename].tmp in [/usr/tmp] directory. Solution : >> Login into the Database Node.

[ Read Me ] Concurrent Processing / System Administration Scripts

2009-09-22T05:01:00.000-07:00

213021.1 Concurrent Processing (CP) / APPS Reporting Scripts 1] CMCLEAN.sql >> Non Destructive Script to Clean Concurrent Manager Tables 2] How To Re-create Concurrent Manager Views 3] CCM.sql >> Concurrent Manager Check Script 4] FNDCCMDiagnostic115.sh >> Concurrent Manager Check Script 5] ICMLOG.sql >> Internal Manager Log Script 6] REQCHECK.sql >> Concurrent Request Check Script 7]

[Issue] ora-00600 : internal error code, arguments: [kkdogty01], [], []

2009-09-18T03:14:00.000-07:00

Hello All, During our daily health check , we found ora-00600 error in our alert.log Error: Errors in file /m02/oracle/db/tech_st/10.2.0/admin/PROD_server1/udump/prod_ora_8960.trc: ORA-00600: internal error code, arguments: [kkdogty01], [], [], [], [], [], [], [] Cause: The error means that the function kkdogty got a null pointer instead of a proper pointer to the object OID. If a Third

[ How To ] Change The Password For The SYSADMIN User -- 11.5.10.2

2009-09-14T03:23:00.000-07:00

1. Keep all services running. 2. Login via the OS level by way of the applmgr user. 3. Run your environment scripts a. cd $APPL_TOP b. run APPSORA.env c. the above should also run

[Read Me] What happens when we execute COMMIT statement

2009-09-14T00:44:00.000-07:00

1] When we say commit; all that happens physically is that LGWR flushes the log buffer to Disk. DBWR does absolutely nothing. 2] To make a transaction durable, all that is necessary the changes that make up the transaction be on disk; there is no need whatsoever for the actual data to be on the Disk. 3] LGWR writes in very nearly real time, virtually all the transactions changes are on disk

[Read Me] What happens when we execute ROLLBACK statement

2009-09-14T00:41:00.000-07:00

1] If the session that initiated the transaction fails {n/w down , user process reboots} – PMON will rollback. 2] If the Server reboots then on startup SMON will detect and rollback. 3] Mechanism: Update: The pre-update version is the columns are copied from the undo block to table blocks. 4] Insert: Oracle retrieves the rowid of the inserted row from the undo block and uses it as the key for a

[Read Me] What happens when we execute INSERT and DELETE statements

2009-09-14T00:38:00.000-07:00

1] Insert and Delete are managed in the same fashion as an Update. Redo generation is exactly the same: all the changes to be made to data and undo blocks are first written out to the log buffer. 2] The difference is in the amount of Undo generated. When a row is inserted, the only Undo generated consists of writing out of the new rowid to the undo block. This is because to rollback an Insert the

[Read Me] What happens when we execute UPDATE statement

2009-09-14T00:31:00.000-07:00

Hello All, I was just curious about what exactly happens when we execute "Update" statement.... I found the answer in one of the Oracle Fundamentals ... Here we go... 1] For any DML operation ; it is necessary to work on both data blocks and undo blocks and also regenerate redo A , C & I of the ACID test require generation of UNDO ; the UNDO segment is just another segment. 2] First step is same

[ How To ] Reset / Unlock the orcladmin password

2009-09-09T00:46:00.000-07:00

Recently while upgrading our Discoverer to 10.1.2.3 [ +CP4 ] , we encountered / or got stuck in one of the step. One of the step asks for orcladmin password which was not known to us. So , we need to reset that password : Here are the steps which we followed ; Error: orcladmin password lost or account locked Cause: orcladmin password not known to us. Solution : Step 1] Login as OAS user [ here

[ Issue ] Concurrent Manager startup errors out

2009-08-21T04:34:00.000-07:00

Hello All, Few days back , we encountered an error while starting Concurrent Managers ; Here is the log file [segment] Error : ========================================================= Check that your system has enough resources to start a concurrent manager process. Contact your system administ : 18-AUG-2009 13:44:33 Starting PASMGR Concurrent Manager : 18-AUG-2009 13:44:33 CONC-SM TNS FAIL

[ How To ] Validate DBC file in Oracle Applications

2009-08-21T03:08:00.000-07:00

This command will validate your DBC file , incase you encounter issues like " Database Connection Fails with Java Exception " Cmd : [appldev@appsdba install]$ $IAS_ORACLE_HOME/appsutil/jdk/jre/bin/java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=$FND_SECURE/DEV.dbc Database Server --------------- DATABASE_ID: DEV AUTHENTICATION: OFF Application Server ------------------

[ How To] Upgrade EBS from 12.0.4 to 12.1.1

2009-08-20T23:46:00.000-07:00

Hello All, Recently we upgraded our current system from 12.0.4 /10.2.0.3 to 12.1.1/10.2.0.4 . Below is the overview of what all steps we performed. Database Upgrade : 10.2.0.3 to 10.2.0.4 A] Applying 10204 patchset 3 on existing oracle home. 1] Set the inventory in /etc/oraInst.loc . 2] unzip 6810189 patch with owner of database. 3] cd Disk1 >> ./runInstaller 4] Source the oracle home path

[Issue] Concurrent Managers Not Starting With GSM Enabled

2009-06-28T22:37:00.000-07:00

We encountered an error on our Production Instance[12.0.4], though all the services were up and running .. we could see only single process of FNDLIBR running.When we checked the Concurrent:GSM Enabled profile option value ; it was set to "Y".Error ::All requests show a status as 'Inactive No Manager' .Cause ::The following is one possible cause for failure of concurrent managers to start:

[How To] Create FTP account on REDHAT 5(tikanga)?

2009-06-26T07:17:00.000-07:00

Step 1) check whether the server has ftp rpm installed..if no.. then install MySQL-shared-compat-6.0.9-0.rhel5.i386.rpm andvsftpd-2.0.5-12.el5.i386.rpmStep 2) create a user (say test) on the server ..note : the home of the user shud be other than /home/test (say /u01/test_ftp)Step 3) Give appropriate permissions to that directory.Step 4) vi /etc/sysconfig/selinuxchange the value of SELINUX=

[Issue] Web ADI Configuration Error

2009-06-26T00:44:00.000-07:00

After enabling the Web ADI responsibility in Oracle applications , user encountered an error while accessing the web-adi page: Error :: Web ADI Configuration Error. BNE_UIX_PHYSICAL_DIRECTORY is not configured. Cause :: WebADI is not properly setup. Solution :: - Perform the following steps to validate the webADI configuration. 1. Check the values of the following profile option . [with Full

[Issue] FRM 92101 Error while launching the forms in R12

2009-06-26T00:28:00.000-07:00

Hello All , Few days back , we installed RHEL5[tikanga] on one of the servers. After successfully cloning the R12 [12.0.4] , we encountered an error during launching the forms. Error :: FRM -92101 :There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details. Cause :: Mandatory RPMS were missing on

[Issue] Error while starting OPMN Services ,Discoverer

2009-06-14T22:02:00.000-07:00

We successfully upgraded the Infra Home to 10.1.0.5 But we faced an error while starting the opmn services : Error : [oraclebi@agi bin]$ ./opmnctl startall Internal error message 684 could not be found in the msb file opmnctl: starting opmn managed processes... Cause : With regard to applying a 10.1.0.5 patchset, the issue is caused due to a mismatch of the OPMN MSB filesThis error message

[Issue] Apache startup issue @12.0.4/RHEL5

2009-06-13T09:46:00.000-07:00

After installing the RHEL5 on the box ,we cloned an R12 [12.0.4] instance on the same box. Error: > After successful cloning of 12.0.4 on RHEL5 , we found out that all the services are up and running except the HTTP/Apache. Cause : > libdb.so.2 is missing in /usr/lib directory Solution : > Bring down all the application services. > Download the patch 6078836 :RH5.0 / OEL5.0 CERT : SPECIAL

[ How To ] Reset the oc4jadmin password in R12

2009-06-13T09:17:00.000-07:00

Step 1 : Login as Application User Step 2 : cd $IAS_ORACLE_HOME/j2ee/home/

[Read Me] Useful Metalink Note-ids

2009-06-12T21:54:00.000-07:00

1) Cloning : 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone. 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone. 458450.1 Steps to Manually Clone a Database. 603104.1 Troubleshooting RapidClone issues with Oracle Applications R12.

[Issue] Unable to Start OPMN Managed Process

2009-06-12T10:47:00.000-07:00

Our Linux Server rebooted due to some unknown reason... We encountered an error while bringing up the Infra[Middle Tier] and Discoverer OPMN services. Error :: Cause : On being restarted after a failure, OPMN uses information in the ${ORACLE_HOME}/opmn/logs/states directory to attempt recovery. From the various files in the "states" directory it determines if a process ID (PID) of a

[Read Me] Reset ias_admin password in Apps [R12]

2009-06-11T10:00:00.000-07:00

How to reset the ias_admin password , if you have forgotten it earlier .... step1: Login as application user ........say appltest step2: cd $ORACLE_HOME/sysman/j2ee/config (10.1.2 wala HOME) Step3: backup the jazn-data.xml and edit the following section; to look like :: save the file .. step4: $ORACLE_HOME/bin/emctl set password reset

[Issue] Too Many Open Files Error

2009-06-09T05:03:00.000-07:00

Hi All, We faced an issue during Request Set run of DBI Initial load . Current setup : Database :10.2.0.3 Application : 12.0.4 OS : Redhat Advanced server 5 (Tikanga) Error: APP-FND-01564: ORACLE error - 1116 in SUBMIT: others Cause: SUBMIT: others failed due to ORA-01116: error in opening database file 13 ORA-01110: data file 13: '.dbf' ' ORA-27041: unable to open file

[Read Me]Oracle Database Family...

2009-06-06T10:20:00.000-07:00

I came across an interesting article on the web ..so thought to share with you all.. This article has various versions of Oracle Database ; with release date and features added.. ** Oracle 10g Release 2 (10.2.0) – September 2005 ** Transparent Data Encryption Async commits CONNECT ROLE can not only connect Passwords for DB Links are encrypted New asmcmd utility for managing ASM storage **

[Read Me]Steps in Processing an SQL Statement

2009-06-06T10:02:00.000-07:00

Before going through this article.Plz refer to the oracle 9i architecture.. for better understanding. @> Assume a user issues an update stmt on the table such that more than 1 user is affected by the update .This stmt is passed to the USER process .Then the server(rather Query processor )will check whether the SQL stmt is already contained in the library cache such that corresponding info(parse

Xplore Apps