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
Icon for Advocate I rankAdvocate 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.

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)