1. To Drop ACLexec DBMS_NETWORK_ACL_ADMIN.DROP_ACL(‘utlmailpkg.xml’); 2. Create and Assign ACL TO DBUSER and Assign it all host.BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => ‘NETWORK_SERVICES.xml’,description => ‘ACL Access’,principal => ‘DB’,is_grant => true,privilege => ‘connect’); DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl…
Read MoreDear All, Subject : Upgrade Oracle applications11i with 10g R2 . Steps as below: Complete the Installation of Oracle Apps EBS 11.5.10 ( with 9.2.0.6.0 ) with Production Source. Upgrade…
Read MoreSELECT po.profile_option_name “NAME”, po.USER_PROFILE_OPTION_NAME, decode(to_char(pov.level_id), ‘10001’, ‘SITE’, ‘10002’, ‘APP’, ‘10003’, ‘RESP’, ‘10005’, ‘SERVER’, ‘10006’, ‘ORG’, ‘10004’, ‘USER’, ‘???’) “LEV”, decode(to_char(pov.level_id), ‘10001’, ”, ‘10002’, app.application_short_name, ‘10003’, rsp.responsibility_key, ‘10005’, svr.node_name, ‘10006’, org.name,…
Read MoreThe below Query will give the value for the particular PROFILE OPTION what you give as input. For example if you give the profile name as “ICX_FORMS_LAUNCHER” Then it will…
Read MoreScenario : ========= While running opatch lsinventory we get the following error in db Tier Error : ====== $ opatch lsinventory Invoking OPatch 11.1.0.6.2 Oracle Interim Patch Installer version 11.1.0.6.2…
Read MorePlease review the Workflow data purge presentation using the below link: https://docs.google.com/file/d/0B9yQYdntOc42UXMwQUxKQk5qQnc/edit?usp=sharing
Read MoreProblem Description: Ø Few XML type concurrent programs taking long time and completed with warning OPP log file registered below error Caused by: java.lang.ThreadDeath Ø CPU utilization taking 100%…
Read MoreUTL_MAIL:UTL_MAIL is a wrapper, which internally uses UTL_TCP and UTL_SMTP UTL_MAIL package is much easier to use than the UTL_SMTP package. 1) The package is loaded by running the following…
Read More