This discussion is archived
1 Reply Latest reply: Oct 9, 2012 5:37 AM by 936666 RSS

TNSNAMES.ora Error ORA-12154

936666 Newbie
Currently Being Moderated
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
D:\TimesTen\tt1122_32\network\admin\samples
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.2.2.2.0 32 bit
Thanks
  • 1. Re: TNSNAMES.ora Error ORA-12154
    936666 Newbie
    Currently Being Moderated
    Hi,
    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

    Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points