ORACLE APPS: How to add Remote database using CC JOB

I need to add a remote server in Database using CC JOB

First check what are already define as Remote Server

CC JOB Program NAME View Servers under Configurator Application Name.

Now add your new remote Server with following CC JOB

CC JOB Program NAME Define Remote Server under Configurator Application Name.

Server Name=

Host Name=

Port=<Database Listener Port>

Instance Name=

Server Db Version=

FND Name= 

Global Name= 

Notes=

      <> 

FND Link Name=_LINK

Import Enabled=N  

NOTE : Before enable the Remote server please make sure from the CC server you are able to login to remote server using apps username and password combination while your TNSNAME.ora file have right entry for remote server.

Failure to perform above test put me in following situation:

CC job fail with following

**Starts**10-OCT-2006 14:04:21

**Ends**10-OCT-2006 14:04:21

Remote server database version not found: ORA-12537: TNS:connection closed.

Solution : Update sqlnet.ora on remote server to comment out the tcp.validanode_checking=yes and tcp.invited_nodes=(LIST OF NODE NAMES)

Reload the listener

% lsnrctl reload

If try again the same CC JOB again to enable the remote server, It will Fail as during first run Database link is created but post activity such as updating Server Db version was not finished. In second run it again try to create the database link with same database link which will fail.

Solution: Connect to Database as apps account, Find out all Database links and drop the database link created for new Remote server you are working on.

Now enable the new Remote Database using CC job

CC JOB Program NAME Enable Remote Server under Configurator Application Name.

This CC will require you to pass passwd for apps account as your argument.

File : Remote_database_add_using_CC_problem_and_solution.doc