wood burning stoves 2.0*
The moose likes BEA/Weblogic and the fly likes Error in connecting weblogic 6.1 and oracle..plz help me Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Error in connecting weblogic 6.1 and oracle..plz help me" Watch "Error in connecting weblogic 6.1 and oracle..plz help me" New topic
Author

Error in connecting weblogic 6.1 and oracle..plz help me

saran ram
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
Hi
i'm trying to connect oracle from weblogic 6.1.
The following are the path and classpath informations i have set.
%path%
c:\jdk1.2.1\bin;c:\bea\wlserver6.1\bin\oci816_8\weblogicoci37.dll;c:\Orant\bin;
%classpath%
c:\bea\wlserver6.1\lib\weblogic.jar;c:\bea;
But i'm getting the following error:
C:\>java utils.dbping ORACLE SCOTT TIGER ORXML
jDriver/Oracle: license has expired!
Error encountered:
java.sql.SQLException: Fail to load jDriver/Oracle due to license checking faile
d!
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:182)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:106)
at utils.dbping.main(dbping.java:167)
plz help me
thanks in advance
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
The error message says it all, your license for the JDriver has expired. Check the license.bea file in BEA_HOME and I am sure you will see a expiration date previous to today for the JDriver.
saran ram
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
hai,
Now i have reinstalled my WL6.1.
Now i am getting the following error:
A separate message window with the title:
Unable to locate DLL
and the following error in the command prompt:
Starting Loading jDriver/Oracle .....
Exception in thread "main" java.sql.SQLException: System.loadLibrary(weblogicoci
37) threw java.lang.UnsatisfiedLinkError: D:\bea\wlserver6.1\bin\oci817_8\weblog
icoci37.dll: Can't find dependent libraries
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:226)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at SequencerTest.main(SequencerTest.java:28)
What i have to do?
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Do you have the Oracle client installed on your machine and the ORACLE_HOME\bin on your Weblogic PATH? You also need the WebLogic Oracle executables on your PATH. These are found at WEBLOGIC_HOME\bin in the folders oci817_8, oci901_8, and oci920_8. The one you should use depends on the version of Oracle you are connecting to.
Notice these folder go on your PATH not your CLASSPATH.
saran ram
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
Thank you very much for ur kind guidance!
Now i'm almost there.
Just one more error as follows:
D:\>java utils.dbping ORACLE SCOTT TIGER ORXML
Starting Loading jDriver/Oracle .....

---------- LOGIN ERROR CODE: 24327
Error encountered:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating a u
ser - (SCOTT/********@ORXML)
at weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
at weblogic.jdbc.oci.Driver.connect(Driver.java:112)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at utils.dbping.main(dbping.java:167)
I'm also getting this Error Code information in sqlnet file:
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=Buddhan)(CID=(PROGRAM=c:\bea\jdk131\bin\java.exe)(HOST=BUDDHAN)(USER=Administrator)))(ADDRESS=(PROTOCOL=TCP)(HOST=Buddhan)(PORT=1521)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Time: 30-DEC-02 00:47:29
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
***********************************************************************
help me to rectify this too.
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
This error usually means your connection information is incorrect. Try to do a tnsping from command-line on the tnsname that you are trying. Most likely it will fail and you will need to update the information in your tnsnames.ora file or however you do your Oracle lookups.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in connecting weblogic 6.1 and oracle..plz help me
 
Similar Threads
error in connecting weblogic to oracle
ORA-24327
Hope Mr Parthasarathy madhira or other friend help me to solve this problem
Problem setting Oracle connection
connecting weblogic 6.1 and oracle thru thin driver