ORA-12154:TNS:could not resolve the connect identifier inPL/SQL developer

Question

I instaled Oracle and pl/sql developer to manage my databases. but when i want to connect to pl/sql i got the error : ORA-12154:TNS:could not resolve the connect identifier

this is my tns.ora :

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = yegane-laptop)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

eğer allround automations 'ın ürünü olan ise help'in altındaki support info'nun TNS sekmesinde XE'nin karşılığının bulunması gerekiyor. — Barbaros Özhan, Jul 10 '17 at 17:38
@OldProgrammer its return : Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yegane-laptop)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (20 msec) — Yeganeh Salami, Jul 10 '17 at 17:44
Then your db link works. can you connect from the command line: Run sqlpus username/password@XE (with your username and password) — OldProgrammer, Jul 10 '17 at 17:55
@OldProgrammer i had run Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production — Yeganeh Salami, Jul 10 '17 at 18:06
Can you see the path that PL/SQL Developer is using to look for the tnsnames.ora file? ([This might help?](https://stackoverflow.com/a/34687897/266304)) — Alex Poole, Jul 10 '17 at 18:06
then your problem is with plsql_developer. Create a system environment variable, TNS_ADMIN= — OldProgrammer, Jul 10 '17 at 18:25

score 1 · Answer 1 · answered Jul 10 '17 at 18:42

Sometimes, the notepad which you edit your tnsnames.ora file puts '....'(dots) front of each newline. For example:

XE =

..(DESCRIPTION =

....(ADDRESS = (PROTOCOL = TCP)(HOST = yegane-laptop)(PORT = 1521))

....(CONNECT_DATA =

.....(SERVER = DEDICATED)

......(SERVICE_NAME = XE)

...)

..)

you can check this case with notepad++ selecting 'Show All Charecters'.

ORA-12154:TNS:could not resolve the connect identifier inPL/SQL developer

1 Answers1