oracle.net.TNSAddress.SOException with Weblogic connection pool (HELP!)

From: Martin Quinn <mquinn_at_eircom.net>
Date: Wed, 20 Feb 2002 17:08:33 -0000
Message-ID: <uIQc8.2015$W8.15520_at_news.indigo.ie>

Hi,
I'm trying to get Weblogic to connect to my Oracle 8i database but am getting a SO exception when I boot the server. I'm using a thin client driver. I've found quite a few places on the net of people having the same problem but no one had a fix.
My weblogic properties file connection pool area looks like this:

<JDBCConnectionPool CapacityIncrement="1"

        DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="1"
        MaxCapacity="10" Name="ejbPool"
        Properties="user=user;password=pass;server=myserver;protocol=thin"
        Targets="myserver" URL="jdbc:oracle:thin:_at_127.0.0.1:1521:orcl"/>

I made a small test program that connects to this database and selects all rows in one of the tables using this connection criteria and everything works fine with it. When I start weblogic and it reads in the config.xml file, trying to connect to the database I get the following stack trace:

Starting WebLogic Server ....

<20-Feb-02 16:54:01 GMT> <Notice> <Management> <Loading configuration file
.\config\mydomain\config.xml ...>
<20-Feb-02 16:54:07 GMT> <Notice> <WebLogicServer> <Starting WebLogic Admin

Server "myserver" for domain "mydomain">

oracle.net.TNSAddress.SOException
        at oracle.net.TNSAddress.ServiceAlias.initFromNVPair(Unknown Source)
        at oracle.net.TNSAddress.ServiceAlias.initFromString(Unknown Source)
        at oracle.net.resolver.AddrResolution.resolveAddrTree(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.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1120)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:195)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
        at

weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection EnvFactory.java:192)

at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection EnvFactory.java:134)

at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j ava:698)

at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:282
)

at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:623
)

at
weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:107)

at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT arget.java:329)

at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment Target.java:279)

at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D eploymentTarget.java:233)

at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym entTarget.java:193)

        at java.lang.reflect.Method.invoke(Native Method)
        at

weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl .java:636)

at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:6 21)

at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea nImpl.java:359)

at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)

at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)

at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:209)

        at $Proxy36.updateDeployments(Unknown Source)
        at

weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments( ServerMBean_CachingStub.java:2761)

at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(Appl icationManager.java:370)

at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManage r.java:160)

        at java.lang.reflect.Method.invoke(Native Method)
        at