How to check Oracle EBS Configuration

An interesting question was raised during a recent discussion on Delphix 5.0 and it’s new Oracle EBS Multi-Node capability.

How can I check what my Oracle EBS Clone topology is?

The simplest way to check your R12 Clone configuration is to use Oracle Applications Manager (OAM).

OAM (Oracle Applications Manager)

Logon to your Oracle R12 clone environment with an account that has the ‘System Administrator Responsibility’

Navigate to ‘Oracle Application Manager’

Select ‘Dashboard’ from here you can easily see a list of Database and Application Servers as well as the status of the services on each server.

Alternatively logon as ‘APPS’ to SQLPlus and perform the following checks

select INSTANCE_NAME, HOST_NAME from V$INSTANCE;

After a successful running adcfgclone.pl dbTier or adcfgclone.pl database (if database already exists)

You should see your cloned database DB_NAME updated to it’s new value

select DB_NAME from FND_DATABASES;

Once you have completed the AppsTier cloning you can check the Database and Application servers using the following:

select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID

e.g.