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

[saran ram]

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]

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]

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]

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]

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]

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.