How to identify to which mid-tier you are/will be connected to on a multi-node R12 environment?

Posted on May 16, 2008. Filed under: Apps Technology Stack, R12, RAC | Tags: , , , |

Imagine you have a multi-node Oracle Apps R12 setup with 2 node RAC. How would you identify to which server you are/will be connected to when you issue the url. Obviously when you have multi-node setup, you will be accessing the login page using a virtual URL.

1. Open Internet Explorer or Firefox
2. Type in the url eg: https://my.apps.com
3. This should bring the login page (AppsLogin)
4. Click on “About this page” — bottom left
5. Click on “Page Context” (3rd tab)

Here you will be able to see the following details:

1. Database HostName
2. DBC file being accessed
3. JDBC Port
4. SID being used to connect to the database

The DBC file being accessed proivdes the expanded full path of the dbc file (ie., $FND_SECURE or $INST_TOP/appl/fnd/12.0.0/.dbc). The expanded path will have the hostname. That is the mid-tier you are connected to.

You can also click on “Technology Components” & “Java System Properties” to gather more information.

cheers,
OraclePitStop

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: