Win a copy of High Performance Python for Data Analytics this week in the Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

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

 
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 69
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 69
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 didn't like the taste of tongue and it didn't like the taste of me. I will now try this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic