How to Check Oracle EBS Clone Configuration

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.

 

OAM Configuration

Use SQL

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.

dbCheck

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements

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