Problem: While running patch 6241631, the following error occurs:

FAILED: file icxwtab.odf  on worker  1.

Attempted to run ICXDLTMP.SQL, but it gave an error:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1;

TRANSACTION_ID   COUNT(*)
-------------- ----------
    2119244000          2

select rowid, creation_date, transaction_id, session_id
from icx_transactions
where transaction_id='2119244000';

delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';

Solution: There is a duplicate transaction_id in the icx.icx_transactions.

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1;

TRANSACTION_ID   COUNT(*)
-------------- ----------
    2119244000          2

select rowid, creation_date, transaction_id, session_id
from icx_transactions
where transaction_id='2119244000';

delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';

Problem:

When cleaning up an R12.1 instance on Windows 2008, unable to delete C:oracleTEST1appstech_st10.1.2BINoraclient10.dll

Possible solution:

Use rm -rf

Or reboot the machine and try deleting once more.

Read more »

Problem:

How do I view the default settings, parameters or properties of the Oracle database?

Solution:

As sys or system user:

select * from database_properties;

Problem:

After sourcing APPSORA.env on the application tier of an 11.5.10.2 instance, most Linux (non-shell) commands return the following error:

$ . APPSORA.env
$ which which
/usr/bin/which: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory

Solution:

Unset LD_ASSUME_KERNEL

Read more »