DBA Arena

Symptoms:

Concurrent request logfiles have the below error:

REP-0004: Warning: Unable to open user preference file

Cause:

The prefs.ora is either missing or non-accessible.

Solution:

1. No prefs.ora file in HOME directory:

Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file.  If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora file that came with the Oracle Tools.

Read more...

1. Check database and application availability
2. Check status of cluster services
3. Monitor space availability in all tablespaces
4. Check for errors in Database Alert log files and take appropriate action
5. Check Concurrent Managers
6. Check /tmp for space constraints
7. Check invalid objects and compile if required
8. ASM Grid Space Check
9. Database and Application Mount points check
10. Verify Backups
11. Verify Gather Schema Statistics and Purge Concurrent Request and/or Manager Data Concurrent Requests are scheduled and are completing successfully

Read more...

ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Check that the directory is a valid directory with wri06-APR-2016 14:48:29

The concurrent program was unable to write to the specified temporary file because the virtual path assigned to the APPLPTMP environment variable is not referenced in the UTL_FILE_DIR
Read more...

Symptoms:-

The following Concurrent Managers Do Not Start / Die After Restart:

Receiving Transaction Manager
FastFormula Transaction Manager
INV Remote Procedure Manager
PO Document Approval Manager

The following errors are reported in the Internal Concurrent Manager log file.

Routine AFPEIM encountered an error while starting concurrent manager FFTM.
The manager is not able to start properly.
The manager has been put on a SYSTEM HOLD to allow the system administrator to address the issue.
When addressed, the "Fixed" button on the Administer Managers screen can be pressed to restart the manager.
Read more...

Kill all processes of FNDLIBR.

ps -ef |grep FNDLIBR | grep -v grep | awk '{print $2}' | xargs kill -9


Similarly, we can kill other processes as well by replacing 'FNDLIBR' with other process names.

Kill all processes of java.

ps -ef |grep java | grep -v grep | awk '{print $2}' | xargs kill -9

Read more...