I’ve installed oracle server in my windows 11. The installation was successful and able to connect to server using PL SQL Developer client. I was getting the error ‘ORA 12154 TNS could not resolve the connect identifier specified’
The TNS entries are perfect and oracle home is set properly, but I couldn’t login. I’ve googled it and couldn’t find a solution. Finally I found the solution and it has worked for me. Thanks a lot to them.
There are sometimes two program files folder in Windows 11. one is ‘Program files‘ and other one is ‘Program Files(x86)‘.
While installing oracle I’ve selected ‘Program Files(x86)‘ as destination. That’ the reason for the error.
I’ve copied the ‘PLSQL Developer’ folder to the ‘Program Files’ folder and it has worked for me.