APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 39,236 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    February 2018
    M T W T F S S
    « Dec    
  • Archives

  • Authors

Posts Tagged ‘Oracle E-Business Suite’

Starting with Exadata

Posted by appsinfo on October 29, 2014

Starting with Exadata

It comes in a rack with the components that make up a database infrastructure: disks, servers, networking gear, and so on. Three configuration types are available: (1) full rack, (2) half rack, or (3) quarter rack. The architecture is identical across all three types but the number of components differs. Read the rest of this entry »


Posted in Engineered Systems, Infrastructure, Oracle EBS 12.2, Oracle ExaData & ExaLogic | Tagged: , , | Leave a Comment »

Implementing Row–LOV

Posted by appsinfo on September 18, 2014

Implementing Row–LOV

To implement a Row–LOV, create an LOV that selects the primary key of the row the user wants into a form parameter, and then copy that value into the primary key field in the results block right before executing a query. Read the rest of this entry »

Posted in System Administration | Tagged: | Leave a Comment »

Oracle Advanced Support Gateway Security – OASG

Posted by appsinfo on August 27, 2014

Oracle Advanced Support Gateway Security – OASG

As part of any implementation project and using oracle engineered systems as part of infrastructure, we should nail down the firewall ports as part of security. This requires extensive pre-planning, architecture, instance strategy based on scope of project.


The Oracle Advanced Support Gateway is an important part of the Oracle delivery architecture for Oracle Connected Services and its placement must be carefully considered in order for Oracle to deliver Oracle Connected Services.

More information can be found on:


Posted in Infrastructure, Oracle ExaData & ExaLogic | Tagged: , | Leave a Comment »

Web Cache for WebLogic Server

Posted by panthan on August 27, 2014

The WebLogic Server 11g comes with a built-in Web server which is adequate for displaying its own Web pages and could be used for applications hosted on the WebLogic servers. You could use a more industrial-strength Web server such as Oracle HTTP Server (OHS) from the Web Tier, but you don’t have to. In this tutorial you are going to use the built-in Web server and front-end it with the Web Tier Web Cache to speed up Web pages. The application that will be cached is the Administration console, normally found on port 7001. That port will continue to work uncached, but users of the application will be instructed to use a different URL (same host, but port 7785) for future traffic so that it will be cached. So to access the uncached Administration Console, you would use

http://yourhost:7001/console; and to access the cached Administration Console you would use http://yourhost:7785/console.

In this tutorial, you would learn how to:

  • Configure the Web Cache using the Enterprise Manager for caching some (and optionally all) of the traffic headed to the WLS application server
  • Report and monitor the actual benefits of this caching
  • Use the Web Caching independently of the Oracle HTTP Server (OHS)

For more information refer to below link to Oracle tutorial:


Posted in Oracle EBS 12.2, Uncategorized | Tagged: | Leave a Comment »

Oracle E-Business Suite Release 12.2

Posted by panthan on August 27, 2014

Just like the need of Multi Node architecture for high availability Oracle introduced a new file system called Edition Based File System in R12.2, which enables the high availability while the patches are being applied. For our imagination, basically it is divided into two. They are Run and Patch Edition. Conceptually there is a third one – Non Edition. Naming wise, they are referred as fs1,f2 and ne_fs. The file system fs1 and fs2 can switch their roles between patch and run based on the patching cycle. The file system ne_fs contains the data required by both, which will never be changed by run and patch file system life cycles.


Posted in Oracle EBS 12.2 | Tagged: | Leave a Comment »