DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    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.

  2. #2
    Join Date
    Jan 2001
    look at your tnsnames.ora file to see what is your tns alias you are trying to connect to.

    Also Try "tnsping servicename" your alias to see if it's getting there.
    You may need to provide the full alias name eg db.world or may be your host name doesn't get resolved .

    Eugene Roytman

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.