Forum Discussion

Minoo28's avatar
Minoo28
New Member
9 years ago

Error - Oracle: ORA-12154: TNS

Am unable to connect to the Oracle Database.  The error is - "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified".  Can anybody offer a solution.  Thanks
bjerbe's avatar
bjerbe
Advocate I
7 years ago

I was getting this as well, the solution for me was in the Server field to enter <server name>:<port>/<service name>.  Then in the authentication window, select Database and enter the username and pasword.

  • agcData's avatar
    agcData
    New Member
    7 years ago

    This worked for me, thanks.

  • Feiiiry's avatar
    Feiiiry
    Frequent Visitor
    2 years ago

    it wroks!!! thx!

  • GauravKhare7's avatar
    GauravKhare7
    Regular Visitor
    2 years ago

    Super..This worked for me, Thx.. 

  • Kwesi's avatar
    Kwesi
    New Member
    2 years ago

    Hello

     

    Should i enter in the parenthesis 

     

    • bjerbe's avatar
      bjerbe
      Advocate I
      2 years ago

      The <> just means that it is a variable specific to your instance, do not use the <>.

  • Saiyash05's avatar
    Saiyash05
    Regular Visitor
    2 years ago

    Do you still need TNSnames file? or it will work without updating/adding connection to TNS file?
    I tried the same and still getting the same error (Without any TNS Name file)

    • bjerbe's avatar
      bjerbe
      Advocate I
      2 years ago

      I don't believe you should need the TNSNames files ans that would be redundant. In the parameter, you are alredy providing what TNSNames file provides. You can update the TNSNames file to make use is TNSping to ensure that the connection is open.