error in context file
the database is a copy of the R11 instance
after going through several steps
Now I have found the following
The R12 instance is on a server with both the DB and the apps
the context file of the apps environment has an entry
<jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=
(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)
(HOST=test-db)(PORT=1529)))(CONNECT_DATA=(SID=DEV2)))</jdbc_url>
The Host name and the port number is incorrrect
I have examined the fnd_nodes table and it has