TNS-01153 : Failed to Process the String ...
ORA-12541: TNS: no listener ...
ORA-12514: TNS:listener does not currently know of service requested in connect ...
If you are cursed like me, have to do use Oracle database and Windows, suddenly those shits came out of nowhere and wasted you hours, the following instruction might save you some time:
It is not necessary to be connected to the internet, but it must be enabled.
like this:
Please make sure, you added both IP and HOSTNAME:
You may get: The listener supports no services
If you see something like this:
Then congrats! You are all set.
If not, please carry on.
NO! I never touched that shit, why should I edit it? My server just worked a moment ago, I changed nothing, now I have to change something!?
Yes, you are.
On my system it is located at:
C:\app\vito\product\21c\homes\OraDB21Home1\network\admin\tnsnames.ora
Find your own folder by observing the output of lsnrctl status
Let's see what the fuck it is inside this file:
See?
The IP address is hard coded! Change that shit to 127.0.0.1 (or anything else if you know what you are doing)
save the file
If you are still fucked up by Oracle and Windows till now, please leave comments below, I may not be able to help you, but it definitely comfort someone.