what is LDOM and CDOM

https://blogs.oracle.com/cmt/entry/what_s_up_with_ldoms What is Hypervisor??? Hypervisor is a thin firmware layer that provides a stable virtualized machine architecture to which an operating system can be written. It resides in the flash PROM of the motherboard and act as interface between operating system and the hardware. It provides a set of support fuctions to the operating system, so that the OS does not need to know intimate details of how to perform fuctions with the hardware. What is Logical Domain??? Logical domain is a discrete logical grouping with its own operating system, resources and identity within a single computer system. Each logical domain can be created, destroyed, reconfigured, and rebooted independently, without requiring a power cycle of the server. We can run a variety of applications software in different logical domains and keep them independent of performance and security purposes. What is Logical Domains Manager??? The Logical Domains Manager is used to create and manage logical domains. There can be only one Logical Domains Manager per serer. The Logical Domains Manager maps logical domains to physical resources. What is Control Domain??? Domain in which the Logical Domain Manager runs allowing you to create and manage other logical domains and allocate virtual resources to other domains. There can be only one control domain per server. The initial domain created when installing Logical Domains software is a control domain and is named primary. What is Service Domain??? Domain that provides virtual device services to other domains, such as a virtual switch, a virtual console concentrator, and a virtual disk server. What is I/O Domain??? Domain that has direct ownership of and direct access to physical I/O devices, such as a network card in a PCI express controller. Shares the devices with other domains in the form of virtual devices when the I/O domain is also the control domain. What is Guest Domain??? Domain that is managed by the control domain and uses services from the I/O and service domains. Patch Installation Refer the Logical Domains 1.0.2 Release notes for the required patches/softwares for your OS release http://mysolarisworld.blogspot.com/p/how-to-install-and-configure-ldom.html

Difference between RAT and OATS

Difference between RAT and OATS RAT is targeted for DB testing only OATS is a test suite you can test pretty much anything. ATS is supported in both, You will be able to use RAT to record on 10g and 11g but only playback on 11g. Are these 2 ''options'' that come with the DB? or Do we have to purchase them separately and install separately?_ Both need to be licensed separately Both RAT and OATS run from a browser, OATS also hasa component called OpenScript that only runs on windows 32Bit RAT : Real Application Testing OATS : Oracle Application Testing Suite

The Internal Workflow of an E-Business Suite Concurrent Manager Process

Please refer this link for more clarity http://www.pythian.com/blog/the-internal-workflow-of-e-business-suite-concurrent-manager-process/ The Internal Workflow of an E-Business Suite Concurrent Manager Process Tags: 11i, concurrent, e-business suite, EBS, Oracle, Oracle Applications, Oracle E-Business Suite, performance, Pythian Europe, R12, Technical Blog, tuning Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing functionality for background jobs, and it’s used by most of the application modules. As many things depend on concurrent processing, it’s important to make sure that the configuration is tuned for your requirements and hardware specification. This is the first article in a series about the performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance, and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading! There are few things that need to be clear before we start: This is only about how the concurrent processing framework (the concurrent managers) works and not about the concurrent requests executed in the framework. There are multiple types of concurrent managers in EBS – internal manager, conflict resolution manager, workflow agent listener service, standard manager, etc. Their roles are different, and in this post, I’ll discuss only managers that pick up scheduled concurrent requests from the “queue” and execute them – or specifically all managers that have a type of “Concurrent Manager” set in Concurrent managers’ definition form. Typical examples of these managers are “Standard Manager”, “Inventory Manager”, and probably your own custom concurrent managers created for processing specific types of concurrent requests. "Concurrent Managers" Form “Concurrent Managers” Form It is important to understand the internal workflow of a concurrent manager because otherwise, it’s hard to realize how a configuration change actually affects the system. Several years ago, I had to implement an online change of a specialization rule, and it triggered a bounce of all Standard Manager processes – that’s when I realized I had to understand how it worked and since then I have spent lots of hours looking into internals of concurrent managers. I’m not saying that everything is 100% clear for me now – there are too many little things that matter in certain situations. This series of posts will be more about concepts. I hope you’ll find it useful. So how does a concurrent manager process work? Here is a diagram I created to explain it: Internal workflow of a concurrent manager process Internal workflow of a concurrent manager process I’ve numbered each step of the diagram to provide more details about them: This is where the story begins. There is no EXIT state in the diagram as the managers normally process requests in an infinite loop. Obviously, there is a way for a concurrent manager process to receive the command to quit when the managers need to be shut down, but that’s not included here for simplicity. Internal Concurrent Manager (ICM) requests the Service Manager (FNDSM) to start up the Concurrent Manager process. For the Standard Manager processes, the binary executable FNDLIBR is started. For the Inventory Manager, it’s INVLIBR. There are others too. The manager process connects to the database and reads the settings (e.g profile options, sleep seconds, cache size). The process saves information about itself in FND_CONCURRENT_PROCESSES table (os process id, database name, instance name, DB session identifiers, logfile path and name, and others). It also updates FND_CONCURRENT_QUEUES by increasing the value of RUNNING_PROCESSES. The concurrent manager process collects information from the database to build the SQL for querying the FND_CONCURRENT_REQUESTS table. The query will be used every time the manager process looks for scheduled concurrent requests. This is the only time the manager process reads the Specialization Rules (which programs it is allowed to execute) from the database. Keep in mind that if the specialization rules are changed while the managers are running, they are bounced without warning as that is the only way to update the specialization rules cached by the manager process. The SQL (from step 4) is executed to collect information about pending concurrent requests from FND_CONCURRENT_REQUESTS table. The results are checked to verify if any requests are pending for execution. If no requests are pending for execution, the manager process sleeps and then goes to step 5. The “Sleep Seconds” parameter of the “Work Shifts” settings of the concurrent manager determines how long the process sleeps before FND_CONCURRENT_REQUESTS table is queried again. This is the only time the “sleep seconds” setting is used. If there is at least one concurrent request pending for execution, the concurrent manager process caches rowids for the FND_CONCURRENT_REQUESTS rows of pending concurrent requests. The “Cache Size” setting of the concurrent manager specifies how many rowids to cache. The cached list of rowids is checked to verify if there are any unprocessed concurrent requests (rows in FND_CONCURRENT_REQUESTS table) left. If none are left – the processing returns to step 5 and the FND_CONCURRENT_REQUESTS table is queried again. The next unprocessed rowid is picked from the process cache, and the processing starts. Concurrent manager process executes a SELECT-for-UPDATE statement to lock the STATUS_CODE in FND_CONCURRENT_PROCESSES for the request it’s about to process. This is the mechanism to ensure that each concurrent request is executed only once and only by one manager process even if many processes are running simultaneously. The SELECT-for-UPDATE statement can complete with “ORA-00054: resource busy and acquire with NOWAIT specified” or “0 rows updated” if another manager process has started processing the request already. If the STATUS_CODE of the request was locked successfully, the concurrent manager executes the concurrent request. The processing moves to step 9 where the cached list of concurrent requests (rowids) is being checked again. The workflow is not very complex, but it’s important to remember that there are normally multiple concurrent manager processes running at the same time, and they are competing for the requests to run. This competition introduces another dimension of tuning for settings, like number of concurrent manager processes, sleep seconds, or cache

Important FND Tables in EBS

Important FND Tables in EBS Posted by Pratik on 22nd July 2013 in Database with 0 comments FND stands for foundation tables which is combination of AOL, SYSTEM, ADMINISTRATOR, MODULES tables and is placed under FND_TOP. Below i have listed few key FND tables that along with the little description of what is it used for : FND_APP_SERVERS : This table will track the servers used by the E-Business Suite system. FND_DATABASES : It tracks the databases employed by the eBusiness suite. This table stores information about the database that is not instance specific. FND_DATABASE_INSTANCES : Stores instance specific information. Every database has one or more instance. FND_ATTACHED_DOCUMENTS : Stores information relating a document to an application entity. FND_DOCUMENTS : Stores language-independent information about a document. FND_CURRENCIES : Stores information about currencies. FND_LANGUAGES : Stores information regarding languages and dialects. FND_TERRITORIES : Stores information for countries, alternatively known as territories. FND_CONCURRENT_PROCESSES : Stores information about concurrent managers. FND_CONCURRENT_PROCESSORS : Stores information about immediate (subroutine) concurrent program libraries. FND_CONCURRENT_PROGRAMS(_TL) : Stores information about concurrent programs. Each row includes a name and description of the concurrent program. FND_CONCURRENT_QUEUES : Stores information about concurrent managers. FND_CONCURRENT_QUEUE_SIZE : Stores information about the number of requests a concurrent manager can process at once, according to its work shift. FND_CONCURRENT_REQUESTS : Stores information about individual concurrent requests. FND_CONCURRENT_REQUEST_CLASS : Stores information about concurrent request types. FND_CONC_REQ_OUTPUTS : This table stores output files created by Concurrent Request. FND_EXECUTABLES : Stores information about concurrent program executables. FND_DESCRIPTIVE_FLEXS(_TL) : Stores setup information about descriptive flexfields. FND_FLEX_VALUES : Stores valid values for key and descriptive flexfield segments. FND_FLEX_VALUE_SETS : Stores information about the value sets used by both key and descriptive flexfields. FND_LOOKUPS : Stores information about lookup types. FND_LOOKUP_VALUES : Stores meaning values and codes for lookup types. FND_MENUS(_TL) : It lists the menus that appear in the Navigate Window, as determined by the System Administrator when defining responsibilities for function security. FND_MENU_ENTRIES : Stores information about individual entries in the menus in FND_MENUS. FND_REQUEST_GROUPS : Stores information about report security groups. FND_REQUEST_SETS : Stores information about report sets. FND_RESPONSIBILITY(_TL) : Stores information about responsibilities. FND_RESP_FUNCTIONS : Stores security exclusion rules for function security menus. Security exclusion rules are lists of functions and menus inaccessible to a particular responsibility. FND_PROFILE_OPTIONS : Stores information about profile options. FND_SECURITY_GROUPS : Stores information about security groups used to partition data in a Service Bureau architecture. FND_USER : Stores information about application users. FND_APPLICATION(_TL) : Stores applications registered with Oracle Application Object Library. FND_SEQUENCES : Stores information about the registered sequences in your applications. FND_VIEWS : Stores information about the registered views in your applications. FND_TABLES : Stores information about the registered tables in your applications. http://oracleappsebs.com/important-fnd-tables-in-ebs/

After changing the Admin Server to run in Node 2 from Node 1 ..getting 500 internal server error in EM console

Issue Changed the Admin server to run in Node2 instead of Node 1 . Though /em application is in Active state .not able to access EM console . Cause: sysman folder is not present in Node2 .(in the location /u01da/MW_Home/user_projects/domains/SOA_Domain/) Solution Copied the sysman folder from Node 1 to Node 2 . Chagned the server name to node2server instead of node1server in targets.xml restart the application em and click on update for the application em .. it started working !!!

StartWebLogic.cmd Shuts Down after Entering Username with the Error: "Server is running in Production Mode and Native Library (terminalio) to read the password securely from commandline is not found." (Doc ID 1354736.1

YMPTOMS After creating the WebLogic Domain for Contract Management, installing Contract Management and modifying the StartWebLogic.cmd and SetDomainENV.cmd file, the StartWebLogic.cmd file shuts down or closes after typing a username and pressing the ENTER key. The following error is listed in the StartWebLogic command prompt window prior to the shutdown completing: Server is running in Production Mode and Native Library (terminalio) to read the password securely from commandline is not found. CAUSE There are two possible causes: The terminalio.dll file is missing from the default location: C:\bea\middleware\wlserver_10.3\server\native\win\32 The terminalio.dll filing is being renamed to terminalio.dll.bak when the StartWeblogic.cmd file is started. This is a known issue that has been reported to Oracle in Bug 8002166. SOLUTION To resolve this issue, open the StartWebLogic.cmd file with Notepad and do the following: Located towards the bottom of the file are the following lines: if "%WLS_REDIRECT_LOG%"=="" ( echo Starting WLS with line: echo %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% ) else ( echo Redirecting output from WLS window to %WLS_REDIRECT_LOG% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% >"%WLS_REDIRECT_LOG%" 2>&1 ) Change them by including the following line directly before %JAVA_OPTIONS%: -Dweblogic.management.allowPasswordEcho=true The changed information should now appear as: if "%WLS_REDIRECT_LOG%"=="" ( echo Starting WLS with line: echo %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% ) else ( echo Redirecting output from WLS window to %WLS_REDIRECT_LOG% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% >"%WLS_REDIRECT_LOG%" 2>&1 ) Be sure to leave a space before and after the line that was just added. Save the changes and then restart StartWebLogic.cmd.

Refresh GUID’s after moving new RPD & Catalog

Refresh GUID’s after moving new RPD & Catalog Posted on September 6, 2012 by pradeep28186@gmail.com In OBIEE 11g , when we load new RPD and Catalog we need to refresh the user GUID’s else we get error at analytics log in. To resolve this error we have to manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to refresh the GUIDs on restart. Follow below steps, 1. Open the NQSconfig.ini file 2.Locate the parameter FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO ; change it toYES. 3.Open the instance config.xml file for editing, find out false then comment the and add like below example false UpdateAndExit save the changes in instance config.xml 4.Then using omnctl command restart the services ex. C:\middleware\instances\instance1\bin>opmnctl stopall C:\middleware\instances\instance1\bin>opmnctl startall 5.After restarting of services, revert the changes. i.e. in NQSconfig.ini resetFMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO ; & in instance config.xml comment & uncomment like false UpdateAndExit 6.Restart the services again using opmnctl command. http://pradeep28186.blog.com/2012/09/06/refresh-guids-after-moving-new-rpd-catalog/