SGA Hit Ratio’s

Buffer Hit Ratio BUFFER HIT RATIO NOTES: Consistent Gets – The number of accesses made to the block buffer to retrieve data in a consistent mode. DB Blk Gets – The number of blocks accessed via single block gets (i.e. not through the consistent get mechanism). Physical Reads – The cumulative number of blocks read…

Finding and Updating the GUID of a User in Oracle Application Server

1) Finding the GUID of a User a. Using SQL SQL> select guid from portal.wwsec_person$ where user_name = ‘<user_name>’; b. Using ldapsearch: ldapsearch -h myhost -p 3060 -D cn=orcladmin -w <GUI_password_for_orcladmin_user> -b “” -s sub “cn=<cn_for_problem_user>” “*” orclguid 2) Manually updating a users GUID SQL> update portal.wwsec_person$ set guid = <OID_user_GUID> where user_name =’user_name’; SQL>…

Installation and configuration of Oracle BI Applications 7.9.6 with Oracle EBS R12 and Informatica 8.6

I had a recent activity which involved configuring Oracle BI Applications to utilize the preconfigured reports that come with it. I was able to do the entire setup on my Dell Vostro with 4GB RAM and 2.2 GHz processer, but for better performance I would recommend better hardware. When I initially started I had difficulty…

Concurrent Manager FAQs

Concurrent Manager FAQs Q: Which Concurrent Managers (CCMs) are supported by the Sysadmin team? * Internal Concurrent Manager (ICM) * Standard Manager * Conflict Resolution Manager (CRM) The setup of product-specific managers related issues should be directed to the associated product group, i.e. the Inventory manager Q: Where do the concurrent request output and log…

How To License A New Product in Oracle Applications

How To License A New Product in Oracle Applications 1. After purchasing a license for an Application Product/Module, the first thing is to use license manager to record that the product/module is now licensed. License manager can be run 2 ways: a. log in through Oracle Application Manager (OAM) and select Site Map -> Administration…