DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: OCI driver fails to resolve service name

Threaded View

  1. #1
    Join Date
    May 2004
    Posts
    1

    OCI driver fails to resolve service name

    I am using Oracle 9i OCI drivers to connect a java app to an oracle DB. The app is running on Weblogic8.1

    The issue is this: When I deploy the application, the connections open just fine to Oracle 9i, using the oci drivers. But eventually they fail, and I get these TNS:could not resolve service name errors.
    Initially, in the WebLogic start scripts, I am setting three variables for oci to work: ORACLE_HOME, LD_LIBRARY_PATH, and PATH.
    I know these are all set correctly because I can connect through the app server to the database for the initial few days. Then for some reason out of the blue, I get the errors from WebLogic attached below:

    #### <> <> #### <> #### <> java.sql.SQLException: ORA-12154: TNS:could not resolve service name

    Has anyone else had this issue, or have any idea how to pursue this issue?
    Help appreciated.
    Last edited by ayanafridi; 05-04-2004 at 02:42 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width