All posts by Muhammad Rawish Siddiqui

Upgrade Merge Patch shows the Error loading seed data for FND_ATTACHMENT_FUNCTIONS

One of our trainee from previous batch was hitting issue during Upgrade from 12.1.3 to 12.2.0: Upgrade Merge Patch shows the Error loading seed data for FND_ATTACHMENT_FUNCTIONS ERROR/ISSUE During Upgrade from 12.1.3 to 12.2.0: Upgrade Merge Patch throws the Error loading seed data for FND_ATTACHMENT_FUNCTIONS: FUNCTION_NAME = CSF_CSFDCMAI, FUNCTION_TYPE = F, APPLICATION_SHORT_NAME = CSF, ORA-01422: […]

Read More

12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database

12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database CloneContext_***.log Shows the Message: Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol Environment: 12.1.3 Applications with 12c Database (12.1.0.2) Bug 14575666 In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC […]

Read More

Database Crash : ORA-27300: OS system dependent operation:semctl failed with status: 22 (RedHat 7)

Database Installation and Operation Fails if RemoveIPC=yes Is Configured for systemd If RemoveIPC=yes is configured for systemd, interprocess communication (IPC) is terminated for a non-system user’s processes when that user logs out. This setting, which is intended for laptops, can cause software problems on server systems. For example, if the user is a database software […]

Read More

Oracle Upgrade – from R12.2.3 to R12.2.4

Last week, I performed ERP Upgrade from 12.2.3 to 12.2.4. I would like to share the document, which contains the steps performed, according to environment. This is just to give an idea, user must review the following documents and take environment specific action: Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1) Applyng the Latest […]

Read More

Exception in thread “main” java.lang.UnsatisfiedLinkError: /dbupgrade/ stage/ StageR122/ startCD/ Disk1/ rapidwiz/ jre/ Linux_x64/ 1.6.0/ lib/ i386/ xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory

  R12.2.2 Installation in Linux 6 (64 bit) environment. Issue: Exception in thread “main” java.lang.UnsatisfiedLinkError: /dbupgrade/ stage/StageR122/ startCD/Disk1/ rapidwiz/jre/ Linux_x64/1.6.0/ lib/i386/xawt/ libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory Solution Primarily you need to install the following two RPMs in order to resolve the issue (1)  libXi-1.3-3.el6.i686.rpm   (2)  libXtst-1.0.99.2-3.el6.i686.rpm but […]

Read More

Oracle Database Upgrade – from 11.2.0.3 to 12c –

  Last Week I performed Oracle Database Upgrade from 11.2.0.3 to 12c and would like to share Upgrade document. This upgrade document does not include prerequisite and post requisite, which I would try to compile and upload soon. Document Link is as under: Oracle Database 12c Upgrade with screenshots  

Read More

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data (r12)

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data Yesterday, during RMAN (11g) backup the aforementioned issue was raised and resolved by following the enclosed Document. Error: ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/PROD/db/apps_st/data/system09.dbf Alert Log Entry: Reread of blocknum=165656, file=/oracle/PROD/db/apps_st/data/system09.dbf. found same corrupt data Dont forget to […]

Read More

Oracle eBusiness Export Function Stopped Working (11i export report to Excel)

Everything was okayed before and now the aforesaid issue occurs. Login to SQL*Plus as apps user and run the following: set serveroutput on declare db_file NUMBER; mime_type VARCHAR2(255) := ‘text/plain'; out_string VARCHAR2(32767) := ‘Just some plain text that is stored.'; web_server_prefix VARCHAR2(500); url VARCHAR2(500); begin db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’); fnd_gfm.file_write_line(db_file, out_string); db_file := fnd_gfm.file_close(db_file); […]

Read More

eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node

For daily checks ( Health Check on Admin/Concurrent Manager Node click on this link eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node . Related : For health check in 11i Click Here 

Read More

eBusiness NLS Patch u6678700.drv (12.1.1) Takes Too Much Time as compare to u6078836.drv (12.0.4) – Oracle Bug

Bug 8520057 – 12.1.1 NLS PATCHING HAS INCREASED IN TIME OVER 12.0.4  Follow the Note : 839978.1 (12.1.1 NLS Upgrade Patch 6678700 : Performance Installation Issues With XLIFFImporter Java Jobs)  The issue is caused by the time delay spent in connection time within each Java job.  Abort the session and apply the patch : 8576725 […]

Read More