EBS/OID12c - How to Change DB Connection Details for EBS DIP Provisioning
(Doc ID 2985421.1)
Last updated on NOVEMBER 08, 2023
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.0 and laterOracle Internet Directory - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
Goal
How to change the EBS Database port and/or host that are used by DIP (Directory Integration Platform) to access EBS database?
This is needed when the EBS database is moved to another host/port and DIP will not be able to perform provisioning anymore. The managed server logs will throw errors like:
[2022-10-06T10:20:36.152+02:00] [wls_ods1] [ERROR] [DIP-20052] [oracle.dip.<provision_profile_name>_E] [tid: <provision_profile_name>_E] [userId: <anonymous>] [ecid: 38d2913d-.......0000000b,0:173] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception on connecting to DB.[[
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:855)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:924)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:58)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:760)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:575)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at oracle.ldap.odip.gsi.DBConnector.connect(DBConnector.java:188)
at oracle.ldap.odip.gsi.PLSQLWriter.initialise(PLSQLWriter.java:163)
at oracle.ldap.odip.prov.ProvPLSQLWriter_2_0.initialise(ProvPLSQLWriter_2_0.java:63)
at oracle.ldap.odip.prov.ProvOIDToAppSync_2_0.initialise(ProvOIDToAppSync_2_0.java:206)
at oracle.ldap.odip.web.DIPProvBean.runOldVersion(DIPProvBean.java:1068)
at oracle.ldap.odip.web.DIPProvBean.doOneIteration(DIPProvBean.java:636)
at oracle.ldap.odip.web.DIPProv_bbjivk_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21)
at oracle.ldap.odip.web.DIPProv_bbjivk_EOImpl.doOneIteration(Unknown Source)
at oracle.ldap.odip.web.ProvQuartzJobImpl.execute(ProvQuartzJobImpl.java:174)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:576)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:555)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:709)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:322)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1597)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:589)
... 19 more
Caused by: java.io.IOException: Connection refused, socket connect lapse 1 ms. <old_db_service>/<old_hostname> <old_port> 0 3 true
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:246)
at oracle.net.nt.ConnOption.connect(ConnOption.java:177)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:513)
... 24 more
Caused by: java.net.ConnectException: Connection refused
at sun.nio.ch.Net.connect0(Native Method)
at sun.nio.ch.Net.connect(Net.java:459)
at sun.nio.ch.Net.connect(Net.java:451)
at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:646)
at java.nio.channels.SocketChannel.open(SocketChannel.java:189)
at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:100)
at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:78)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:205)
... 26 more
]]
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |