1 Reply Latest reply: Oct 9, 2012 7:37 AM by 936666 RSS

    TNSNAMES.ora Error ORA-12154

      Hi i am getting this error

      ORA-12154: TNS:could not resolve the connect identifier specified Connnection Closed.

      Only TimesTen is installed TNSNAMES.ora is present in
      I added my database over there
      mydb =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = mydb)(SERVER = timesten_direct)))

      but still i am getting this error i have restarted my services of TimesTen but still the problem exists
      Whether i need to create separate TNSNAMES.ora and redirect it, if so how to redirect
      System : Windows 7
      TimesTen: TimesTesn11. 32 bit
        • 1. Re: TNSNAMES.ora Error ORA-12154
          I have added TNS_Admin in system variable under environment variable now i am able to run without error
          After i restarted my PC i am getting the below error
          ORA-12541: TNS:no listener
          Note:I have not installed Oracle only TimesTen is installed and installed ODP of ODTwithODAC112030