Database Blog

Reduce Patching Downtime in Oracle Applications

Following are the various ways to reduce Oracle Application patching downtime. 1. Consolidate Patches Using AD Merge Patch to merge multiple patches into a single patch that eliminates the time…

R12 Configurations in DMZ

DMZ … Easy to notify as External URL… [ I dont want to explain … what is DMZ ??? Lots of stuff available in MOS Doc : 380490.1 , below…

To debug oracle application web server issues after cloning

The AOL/J Setup Test suite consists of a collection of tests that you can run to determine if your web server is configured properly. The suite is made up of…

To display the details of available server CPU resources in UNIX

Display the number of CPUs in HP/UX In HP/UX the ioscan command is used to display the number of processors available on the server. root> ioscan -C processor | grep…

Finding files in Unix based on specific criteria

Purging Data in Oracle Applications

Gather Schema Statistics – Oracle Applications

Common port numbers used for various services of Oracle EBS components

Common port numbers used for various services of Oracle EBS components

Non ASM to ASM Conversion

Before Proceeding to process, please know what is ASM and how to use it. 1. Set the ASM environment and create diskgroup oracle@AIX01]. oraenv ORACLE_SID] +ASM1 sqlplus /as sysasm sql>…

ACL Creation and Access in 11g

1. To Drop ACL exec DBMS_NETWORK_ACL_ADMIN.DROP_ACL(‘utlmailpkg.xml’); 2. Create and Assign ACL TO DBUSER and Assign it all host. — BELOW CODE WILL CREATE NETWORK_SERVICES.xml ACL file and REQUESTS DBUSER AS…