Hi All,
I m facing some problem in implementing the OCI Driver in Welogic .
Here i m giving a brief of what i m doing....
I hav my Weblogic Server and Oracle server installed on the same Solaris machine
but on different unix users. I downloaded the oci driver from bea site with a
file name as ocire510.zip . Extracted the same file in my in my weblogic home.
Then i made the appropriate path settings for the env variables in ".profile"
file of Weblogic unix user as....
PATH ..... : included the path for ORA_HOME/bin and
ORA_HOME/network/admin
CLASSPATH... : included the path for extracted OCI driver, ORA_HOME/lib .... and
other general path settings
LD_LIBRARY_PATH..:included the path for WL_HOME/lib/solaris/oci815_8:
WL_HOME/weblogic/oci/lib/solaris/oci815_8: ORA_HOME/lib:ORA_HOME/network/admin
TNS_ADMIN.... : /ORA_HOME/network/admin
I m using weblogic connection pooling, so setting my properties as...
weblogic.jdbc.connectionPool.dtPool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=2,\
maxCapacity=2,\
capacityIncrement=10,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=test;password=test;server=VIGNETTE
and my tnsnames.ora set as....
VIGNETTE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.24.80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BV1)
)
)
where BV1 is my Oracle SID
When i tried to startup my Weblogic server it gives the following exception at
connection pool creation.
It goes like this......
***************************************************************************
refreshMinutes=10 poolName=dtPool loginDelaySecs=1 testTable=dual
maxCapacity=2
props=user=test;server=VIGNETTEallowShrinking=true
driver=weblogic.jdbc.oci.Driver aclName=weblogic.jdbc.connectionPool.dtPool
capacityIncrement=10 initialCapacity=2 url=jdbc:weblogic:oracle
shrinkPeriodMins=15
Delaying 1 seconds before making a dtPool pool connection.
+++ WebLogic Native Layer for OCI 8.x (BETA-2)
---------- LOGIN ERROR CODE: 24327
Tue Jul 31 12:51:49 EST 2001:<I> <JDBC Pool> Sleeping in createResource()
Tue Jul 31 12:51:50 EST 2001:<E> <JDBC Pool> Failed to create connection
pool
"dtPool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: Error while trying to retrieve text for error
ORA-24327 -
(dets/********@VIGNETTE)
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:43)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:143)
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:157)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:146)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(Compiled
Code)
at weblogic.common.internal.ResourceAllocator.<init>(Compiled Code)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330
)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:255)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(Compiled Code)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at
weblogic.common.ResourceException.<init>(ResourceException.java:18)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:154)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(Compiled
Code)
at weblogic.common.internal.ResourceAllocator.<init>(Compiled Code)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330
)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:255)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(Compiled Code)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at
weblogic.common.ResourceException.<init>(ResourceException.java:18)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:124)
at weblogic.common.internal.ResourceAllocator.makeResources(Compiled
Code)
at weblogic.common.internal.ResourceAllocator.<init>(Compiled Code)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330
)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:255)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(Compiled Code)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
****************************************************************************
When i looked the details of the error in Oracle Docs it says...
- ORA-24327 need explicit attach before authenticating a user
Cause: A server context must be initialized before creating a session.
Action: Create and initialize a server handle.
I m not able to trace out where i m going wrong.......
Kindly please anybody like to put some light on it....
regards,
Abhishek !
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
