WLS 7.0 sp2 with Oracle 8.1.7 on solaris 8

[pascal auderset]

Hello
Can some tell my what I have to include in the LD_LIBRARY_PATH, CLASSPATH and PATH that I can use the oci8 Driver from Oracle.
I have put the $ORACLE_HOME/lib in the LD_LIBRARY_PATH and the classes12.zip in the $CLASSPATH varibable.
When I deploy a Connection Pool the server displays a message that he can not load the driver.
Thanks
Pascal

[Sai Prasad]

Assuming that you have installed Oracle in C:\Oracle and wl in C:\bea7.0, add the string below to your PATH:
"\bea7.0\weblogic700\server\bin\oci817_8;
\Oracle\ora81\bin"
You need to change the values according to Solaris and your installation directories
[ May 27, 2003: Message edited by: Sai Prasad ]

[pascal auderset]

Hello
Here the error I get:

. startManagedWebLogic.sh
LD_LIBRARY_PATH=/opt/bea/weblogic700/server/lib/solaris:/opt/bea/weblogic700/server/lib/solaris/oci817_8:/export/home/oracle/product
/8.1.7/lib:/opt/bea/weblogic700/server/lib/solaris:/opt/bea/weblogic700/server/lib/solaris/oci817_8:/opt/bea/weblogic700/server/lib/
solaris:/opt/bea/weblogic700/server/lib/solaris/oci817_8
CLASSPATH=/opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/weblogic700/server/lib/weblogic_sp.jar:/opt/bea/webl
ogic700/server/lib/weblogic.jar:/opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/weblogic700/server/lib/weblogi
c_sp.jar:/opt/bea/weblogic700/server/lib/weblogic.jar:/opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/weblogic
700/server/lib/weblogic_sp.jar:/opt/bea/weblogic700/server/lib/weblogic.jar::/export/home/oracle/product/8.1.7/jdbc/lib/classes12.zi
p:/export/home/oracle/product/8.1.7/jdbc/lib/classes12.zip:/export/home/oracle/product/8.1.7/jdbc/lib/classes12.zip
PATH=.:/opt/bea/weblogic700/server/bin:/opt/bea/jdk131_06/jre/bin:/opt/bea/jdk131_06/bin:/opt/bea/weblogic700/server/lib/solaris:.:/
opt/bea/weblogic700/server/bin:/opt/bea/jdk131_06/jre/bin:/opt/bea/jdk131_06/bin:/opt/bea/weblogic700/server/lib/solaris:.:/opt/bea/
weblogic700/server/bin:/opt/bea/jdk131_06/jre/bin:/opt/bea/jdk131_06/bin:/opt/bea/weblogic700/server/lib/solaris:/usr/bin::/usr/sbin
:/usr/openwin/bin:/usr/dt/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb
***************************************************
* To start WebLogic Server, use a username and *
* password assigned to an admin-level user. For *
* server administration, use the WebLogic Server *
* console at http://<hostname>:<port>/console *
***************************************************
+++ /opt/bea/jdk131_06/bin/java -server -Xms32m -Xmx200m -Dweblogic.security.SSL.trustedCAKeyStore=/opt/bea/weblogic700/server/lib/c
acerts -classpath /opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/weblogic700/server/lib/weblogic_sp.jar:/opt/
bea/weblogic700/server/lib/weblogic.jar:/opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/weblogic700/server/lib
/weblogic_sp.jar:/opt/bea/weblogic700/server/lib/weblogic.jar:/opt/bea/jdk131_06/lib/tools.jar:/opt/bea/weblogic700/server:/opt/bea/
weblogic700/server/lib/weblogic_sp.jar:/opt/bea/weblogic700/server/lib/weblogic.jar::/export/home/oracle/product/8.1.7/jdbc/lib/clas
ses12.zip:/export/home/oracle/product/8.1.7/jdbc/lib/classes12.zip:/export/home/oracle/product/8.1.7/jdbc/lib/classes12.zip -Dweblog
ic.Name=usv0170 -Dbea.home=/opt/bea -Dweblogic.management.username= -Dweblogic.management.password= -Dweblogic.mana
gement.server= -Dweblogic.ProductionModeEnabled= -Djava.security.policy=/opt/bea/weblogic700/server/lib/weblogic.
policy weblogic.Server
Starting WebLogic Server...
Connecting to http://...
<May 28, 2003 7:52:55 AM CEST> <Notice> <Security> <090082> <Security initializing using realm myrealm.>
<May 28, 2003 7:52:56 AM CEST> <Notice> <WebLogicServer> <000328> <Starting WebLogic Managed Server "usv0170" for domain "U.KUBA.BLK
B">
<May 28, 2003 7:53:24 AM CEST> <Error> <JDBC> <001060> <Cannot startup connection pool "jabasPool" weblogic.common.ResourceException
: weblogic.common.ResourceException:
Could not load 'oracle.jdbc.driver.OracleDriver
If this is a type-4 JDBC driver, it could occur if the JDBC
driver is not in the system CLASSPATH.
If this is a type-2 JDBC driver, it may also indicate that
the Driver native layers(DBMS client lib or driver DLL)
have not been installed properly on your system
or in your PATH environment variable.
This is most likely caused by one of the following:
1. The native layer SO, SL, or DLL could not be found.
2. The file permissions on the native layer SO, SL, or DLL
have not been set properly.
3. The native layer SO, SL, or DLL exists, but is either
invalid or corrupted.
For more information, read the installation documentation
for your JDBC Driver, available from:
http://e-docs.bea.com
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:220)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:140)
at weblogic.jdbc.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:931)
at weblogic.jdbc.common.internal.ResourceAllocator.finishInit(ResourceAllocator.java:457)
at weblogic.jdbc.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:316)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:292)
at weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.java:282)
at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:270)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:303)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:256)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:207)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:732)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:714)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:952)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy7.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:4114)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:2257)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:235)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:65)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:832)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:300)
at weblogic.Server.main(Server.java:32)
>
<May 28, 2003 7:53:31 AM CEST> <Notice> <WebLogicServer> <000332> <Started WebLogic Managed Server "usv0170" for domain "U.KUBA.BLKB
" running in Development Mode>
<May 28, 2003 7:53:31 AM CEST> <Notice> <WebLogicServer> <000365> <Server state changed to RUNNING>
<May 28, 2003 7:53:31 AM CEST> <Notice> <WebLogicServer> <000360> <Server started in RUNNING mode>
<May 28, 2003 7:53:31 AM CEST> <Notice> <WebLogicServer> <000355> <Thread "ListenThread.Default" listening on port 8082, ip address
159.29.20.84>

[Sai Prasad]

Try the lines below in your startup shell script:

LD_LIBRARY_PATH=/swpkg/shared/bea/wlserver6.1/lib/solaris:
/swpkg/shared/bea/wlserver6.1/lib/solaris/oci817_8:/home/oracle/OraHome1/lib
export LD_LIBRARY_PATH
ORACLE_HOME=/home/oracle/OraHome1
export ORACLE_HOME
  

Note: You need to modify depending your folder name and bea 7.0 dir
[ May 28, 2003: Message edited by: Sai Prasad ]
[ May 28, 2003: Message edited by: Sai Prasad ]

[pascal auderset]

Hello
Thank you it works. It's important to export the variables otherwise it doesn't work.
Pascal