RAFW 7.1.1.4 oracle database connection error

Hi, I am facing issue when I tried to test the connection from RAFW server to oracle database using Installation Manager .
In the database connection step I am getting Unexpected Failure Array Index out of range:110 error.
It looks like something is wrong with oracle client or the buildforget oracle connection code . Please help!!!!!!!!.

Thanks,
Raj

Hi Raj,

A little more information may help. Which platform are you working with (operating system/architecture)? Are you using the 10.2 Oracle Instant Client Package - Basic (32 bit version)? Is there any chance that you could copy/paste the error.

bju

# ./launcher
WITHING Platform Specifier
JOB::InstallJob in buildforge.console; com.ibm.buildforge.console 7.1.140.0139 features: com.ibm.buildforge.console.webroot,com.ibm.buildforge.console.engine,com.ibm.buildforge.console.slayer,com.ibm.buildforge.console.install.configure
WITHING Platform Specifier
WITHING Platform Specifier
WITHING Platform set
WITHING Platform:Linux
WITHING JAVA HOME set
JAVA HOME:/web/Rational/InstallationManager/eclipse/jre_5.0.3.sr8a_20080811b/jre/bin/java
java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 110
at oracle.net.nl.NVTokens.parseTokens(Unknown Source)
at oracle.net.nl.NVFactory.createNVPair(Unknown Source)
at oracle.net.nl.NLParamParser.addNLPListElement(Unknown Source)
at oracle.net.nl.NLParamParser.initializeNlpa(Unknown Source)
at oracle.net.nl.NLParamParser.<init>(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.loadFile(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.checkAndReload(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.resolve(Unknown Source)
at oracle.net.resolver.NameResolver.resolveName(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
at oracle.net.ns.NSProtocol.connect(Unknown Source)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:858)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.ibm.buildforge.console.install.pages.OracleInterface.openConnection(OracleInterface.java:64)
at com.ibm.buildforge.console.install.pages.OracleInterface.jdbcTest(OracleInterface.java:175)
at com.ibm.buildforge.console.install.pages.OracleInterface.test(OracleInterface.java:76)
at com.ibm.buildforge.console.install.pages.DatabaseDisplay$22.widgetSelected(DatabaseDisplay.java:1082)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3552)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3171)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2629)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2593)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2427)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:670)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:663)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.ibm.cic.agent.internal.ui.AgentUIApplication.launch(AgentUIApplication.java:290)
at com.ibm.cic.agent.internal.ui.AgentUIApplication.start(AgentUIApplication.java:57)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
at org.eclipse.equinox.launcher.Main.main(Main.java:1383)


Here is the error

its Linux/64bit,yes i have oracle instant client(10.2) package installed along with complete oracle client( for refering tnsnames only)

its Linux/64bit,yes i have oracle instant client(10.2) package installed along with complete oracle client( for refering tnsnames only)

Hi Raj,

From looking at the stack trace, I think the oracle jdbc driver does not like something in the formatting of your tnsnames.ora file. This is an example of one that I have used. The spacing of the statements seems to be very important to the oracle jdbc driver. Hopefully, this forum software will preserve that spacing for my example.

TEST =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = host.my.company.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = test)

    )

  )

bju

wpqa2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xyzdb.brocade.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wpqa2)
)
)

here is the tns entry

Can you try with the lines indented like the one below:

wpqa2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = xyzdb.brocade.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = wpqa2)

    )

  )