Monthly Archives: December 2017

Thank you 2017

2017 has been a very rewarding year with many new beginnings. To state a few top achievements, I’ve started blogging on Oracle and Big data technologies (https://pradeepvattem.wordpress.com). As a member of Organizing committee for AIOUG (All India Oracle Users Group) Hyderabad … Continue reading

Posted in Conferences/UserGroups | Leave a comment

ORA-03113: end-of-file on communication channel; Process ID: xxxx; Session ID: xxxx Serial number: x

Issue: SQL> startup ORACLE instance started. Total System Global Area 3.4217E+10 bytes Fixed Size 2198680 bytes Variable Size 1.7180E+10 bytes Database Buffers 1.6979E+10 bytes Redo Buffers 55943168 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 8149 Session ID: … Continue reading

Posted in Oracle Database | Leave a comment

ORA-16038: log 1 sequence# 12 cannot be archived ORA-19502: write error on file “”, block number (block size=)USER (ospid: 12282): terminating the instance due to error 16038

Issue: ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: ‘/u01/oracle//arch1/DB1/DB1_1_312_963731429.dbf’ (error 19502) (DB1) ARCH: I/O error 19502 archiving log 3 to ‘/u01/oracle/arch1/DB1/DB1_1_312_963731429.dbf’ Errors in file /u01/oracle//work/diag/rdbms/DB1/DB1/trace/DB1_ora_12282.trc: ORA-16038: log 1 sequence# 12 cannot be archived ORA-19502: write error on file “”, block number … Continue reading

Posted in Oracle Database | Leave a comment

FDPSTP failed due to ORA-20100: ORA-20100: File o1751579.tmp creation failed

Issue: **SQL error and free**22-DEC-2017 01:59:51 ORACLE error 20100 in FDPSTP Cause: FDPSTP failed due to ORA-20100: ORA-20100: File o1751579.tmp creation failed. File could not be opened or operated on as requested. Action: Make sure the directory – /u01/app/oracle/apps/apps_st/comn/te22-DEC-2017 01:59:51 … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator

Issue: ERROR at line 1: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator. Action: Check that the directory is a valid directory with write permissions on the database server node and is … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | 1 Comment

Nitty Gritties of WebLogic for Oracle Apps DBAs (#Sangam17, #AIOUG)

Very privileged and happy to share that I have been an active Volunteer of SANGAM17 which is the largest Oracle Independent User Group in India. I’ve also presented a topic titled “Nitty Gritties of WebLogic for Oracle Apps DBAs” covering … Continue reading

Posted in Conferences/UserGroups | Leave a comment

FNDCPASS in Oracle Applications failing with “supply a different password”

Issue: FNDCPASS in Oracle Applications fails with below error, Must not reuse a recently used password. Please supply a different password. Unable to change the password for fnd_user TESTUSER. Resolution: Change the profile option “Signon Password No Reuse” (at user … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment