Unable to Connect to DB(Oracle) with weblogic 6.0 sp1

Discussions

EJB programming & troubleshooting: Unable to Connect to DB(Oracle) with weblogic 6.0 sp1

  1. Iam trying to connect to DB by setting the PATH variable as given in the doc of weblogic.

    PATH=orant\bin; d:\bea\wlserver6.0\bin\oci816_7;

    when using dbping Iam receiving and Exception,

    java.sql.SQLException: Fail to load jDriver/Oracle due to license
    checking failed!
            at
    weblogic.jdbcbase.oci.Driver.loadLibraryIfNeeded(Driver.java:158)
            at weblogic.jdbcbase.oci.Driver.connect(Driver.java:57)
            at java.sql.DriverManager.getConnection(DriverManager.java:517)
            at java.sql.DriverManager.getConnection(DriverManager.java:146)
            at utils.dbping.main(dbping.java:182)

    D:\bea\wlserver6.0\config\mydomain>

    Iam having the valid license file of Oracle and unable to resolve the same.
    Please help me to connect to DB.

    Thanks in advance.
    Ravi Sri Ramana
  2. Hi,

    It is better to use DBPing utility.

    what can be done is

    In command prompt go to the weblogic bin directory.

    type

    ping <
    eg:
    ping oracle ashok true ser

    servicename should be obtained from the admin. It is the servicename of our database.

    give in that fromat and check if it is sucessefully connected then u can easily connect using weblogic.



    Also in the environmental path include the license directory of weblogic "c:\weblogic\license;".
  3. Hi Ramana,

    If You are using oracle 8.x path has to set to d:\bea\wlserver6.0\bin\oci816_8;

    Check in your system for oracle any port has set. if not don't use it at the time of creating DataSource (Connection pool ) in config.xml or thru console.

    if it is set you have to use 1521 as port in the config file.

    try out following options

    to check it type this in at windows commandpromt

    java utils.dbping oracle user pass oracle@192.169.1.1:1521

    if get success ok else


    java utils.dbping oracle user password

    before this u should set the path and classpath.


    regards
    Reddy



  4. Were you able to verify if you have a valid weblogic license ??

    Look into license.bea under your installed directory.
  5. I am giving you a crude / bullshit sol . Hope it works.

    create a new directory , copy all the .dll files under your d:\bea ( and sub-directories ).

    Add the directory to PATH or start WLS from command prompt
    specifying -Djava.library.path