OSB Not Communicating With Database Using Scan-listener (Doc ID 2799424.1)

Last updated on MAY 15, 2023

Applies to:

Goal

On : 12.2.1.3.0 version, OSB Core Functionality

OSB not communicating with database using scan-listener

After recently updated datasources to connect to Database using scan-listener instead of service conncetion.

from:
jdbc:oracle:thin:@//<origialAdress>:1521/<INSTANCENAME>

to:
jdbc:oracle:thin:@//<newAdress>:1521/<INSTANCENAME>


Checking database's listener log we can still see some connections coming from osb managed servers.
Not as often as before, but we would like all connection to go through scan-listener

For example we can see following record in listener.log:

/u01/app/oracle/diag/tnslsnr/<origialAdress>/listener/trace/listener.log
---
05-AUG-2021 20:32:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=<USR>))(SERVICE_NAME=<INSTANCENAME>)(SERVER=dedicated)(INSTANCE_NAME=<INSTANCENAME>2)) * (ADDRESS=(PROTOCOL=tcp)(HOST=<IPADDRESS>)(PORT=42569)) * establish * <INSTANCENAME> * 0

Host <IPADDRESS> is an application server <SERVER> where osb_server1 is running.
Using netstat on <IPADDRESS> we can see a connection corresponds to pid '6788' which is osb_server1
----------------------------
<SERVER>.42569
<origialAdress>-vip.u6.ru.1521  256296 00000000 00000000  257744 00000000 00000000   202  1448 ESTABLISHED <USR>    6788 /u01/app/oracle/java/jdk1.8.0_191/bin/java -server -d64 -Xms1024m -Xmx2560m -XX
----------------------------

----------------------------
<INSTANCENAME>> <USR>@<SERVER> ~]$ ps -ef|grep 6788
 <USR> 14706 24764   0 20:40:40 pts/41      0:00 grep 6788
 <USR>  6788  6746   0   Jul 19 ?        11290:44 /u01/app/oracle/java/jdk1.8.0_191/bin/java -server -d64 -Xms1024m -Xmx2560m -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=85 -cp /path/to/oracle/product/osb/wlserver/server/lib/weblogic-launcher.jar -Dlaunch.use.env.classpath=true -Dweblogic.Name=osb_server1
----------------------------

Can you please help us find what else needs to be updated on OSB side, so that all connections are going through scan-listener and not database-listener?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.