IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: May 2007

Upgrade database from 9i to 10g – Windows

Followings steps when performed, will upgrade the database from 9i to 10g.  Please note that you need to install ORACLE_HOME for 10g before going ahead. Step 1) Run the script utlu102i.sql from 10g OH in 9i database D:\oracle\ora92\bin>sqlplus “/as sysdba” SQL*Plus: Release 9.2.0.6.0 – Production on Tue Oct 31 17:26:25 2006 Copyright (c) 1982, 2002, Oracle Corporation.  [...]

Oracle Blocks – Details

we can get the information about which table is present in which datafile. For that you can seach for file_id in dba_extents using the segment name as your table name. using this file ID we can get the tablespace_name and file_name from dba_data_filesExample: select file_id, block_id, segment_name from dba_extents where segment_name = ‘IGI_MPP_AP_INVOICES_I1′ FILE_ID BLOCK_ID [...]

Concurrent Manager: Output Post-processor issue

The concurrent program the output of which is XML report is failing in warning and the log shows the below message: Beginning post-processing of request 5292785 on node AP6105RT at 02-AUG-2006 04:47:48. Post-processing of request 5292785 failed at 02-AUG-2006 04:49:48 with the error message: The Output Post-processor is running but has not picked up this [...]

MWA Service Management – Brief

MWA Service management – Brief MWA is mobile web application. Using this we can have our applicaiton on mobile. MWA service is used in E-Business suite is for running the applicaiton on mobile. There are very few parameters that needs to be configured for this and we can start MWA service to be used on [...]

Error while opening log files from CM form

Some times when we make a concurrent request and try to view the log file after complition of request (may be completed normal or some error) from the concurrent manager form we get following type of error An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_(Your env_name)_(Your_Server_name). There [...]

concurrent manager is not responding

If the concurrent manager is not responding and there are lot of pending request from long time then those request can be killed from the backend using the following query. UPDATE fnd_concurrent_requests SET phase_code = ‘C’, status_code = ‘D’ WHERE status_code =’Q’ OR phase_code = ‘P’ AND REQUEST_ID = ; You can kill all the [...]

ORA-20100:

Problem Statement Error Messages: CSTPACIN.COST_INV_TXN: (70): ORA-20100: File o0086078.tmp creation for FND_FILE failed. You will find more information on the cause of the error in request logSolution In this case we need to check following 3 things 1) Check the UTL file parameter in DB side. Compare it with the APPLPTMP parameter on application side. [...]

ORA-12547: TNS:lost contact

Some time we come across the issue when trying to connect with database from the application side using apps as a user. This basically requires the listener to be up to make connection with database. We get error similar to Cannot login to sqlplus using following userid/passwd. sqlplus apps/apps@dbname. Gives error ERROR: ORA-12547: TNS:lost contact [...]

Follow

Get every new post delivered to your Inbox.

Join 130 other followers