Dec 4, 2009

Apply patcheset Oracle 10.2.0.4 on AIX 6.1

--When apply 10.2.0.4 on AIX 6.1 , failed with "Java process exist" message and apply process stop.
--Workground
As root:
1) rename /usr/sbin/fuser
2) touch /usr/sbin/fuser
3) chmod +x /usr/sbin/fuser
As oracle software owner:
1) Try to install the patchset (or base release)
(fuser can now return nothing, hence the Installer should continue)
After successful install, as root:
1) rename renamed_fuser back to its original name

select view and function throufh db link

select view and function throufh db link.

get_entryvalue is a function in remote DB.

-----------
SELECT ip3.ID,
ip3.CLASS,
ip3.subclass,
ip3.item_number,
ip3.description,
ip3.list32,
ip3.list33,
A.get_entryvalue@A_DB_LINK (ip3.list32) type,
A.get_entryvalue@A_DB_LINK (ip3.list33) group
FROM A.item_p3@A_DB_LINK ip3
WHERE subclass = '123456'