Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 210 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11g: IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_na
Hi Team,
I am facing an error while starting the Managed Server for OBIEE as below. Please suggest what needs to be done:
####<May 22, 2017 12:56:52 PM CDT> <Info> <JDBC> <ftizssdweb013.ftdc.cummins.com> <bi_server1> <[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3215b6ed484700fe:-3b602353:15c0b92851a:-8000-0000000000042d3a> <1495475812723> <BEA-001156> <Stack trace associated with message 001129 follows:
java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]"
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:390)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:242)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1319)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1236)
at weblogic.common.resourcepool.ResourcePoolImpl.recreateDeadResources(ResourcePoolImpl.java:2169)
at weblogic.common.resourcepool.ResourcePoolImpl.access$1700(ResourcePoolImpl.java:41)
at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2793)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:272)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: oracle.net.ns.NetException: Invalid connection string format, a valid format is: "//host[:port][/service_name]"
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:131)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:135)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:420)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:257)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:390)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:242)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1319)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1236)
at weblogic.common.resourcepool.ResourcePoolImpl.recreateDeadResources(ResourcePoolImpl.java:2169)
at weblogic.common.resourcepool.ResourcePoolImpl.access$1700(ResourcePoolImpl.java:41)
at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2793)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:272)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>
Thanks and Regards,
Pankul Gupta
Answers
-
The error points to a wrong connection format to a datasource. Was the server working fine before? Was there any changes made to the environment?
0 -
what does the current DB connection string look like? Are you trying it with a SID and not a Service Name?
0 -
Hi Sherry,
Yes it was working fine before. We have made a few changes, the recent one was we redeployed the oraclediagent in the console and after that we started facing this issue.
Regards,
Pankul Gupta
0 -
Hi Thomas,
I am not sure where we can see that in which format it is define, as I am facing this error while restarting the Managed Server for OBIEE.
0 -
Hi Pankul,
You can check the data sources from the weblogic console. Click on the data source of interest and go to the connection pool tab to verify the jdbc connect string.
Since the latest change as per your update was deploying ODI Java EE agent, I would double check the connect string specified for the agent.
0 -
Hi Sherry,
Sorry for little late response. But all thanks to you, your suggestions worked and it was the connection pool for all the datasources in the application, where the URL format was wrong.
I got them all corrected and able to bring the server up.
Thanks once again for your inputs.
Thanks and Regards,
Pankul Gupta
0 -
Please mark the helpful comments and the correct answer.
Glad you got it working!
0 -
Hi Pankul,
Thank you for updating us. Now could you please close this thread by marking it as answered
0