Why EVERYONE gets ORA-12154 when using 21c

[@TheTimHall]

I messed this up so many times when I was updating my build scripts. It's like muscle memory. Even though you know it's a read-only home, you automatically go there...

[@DatabaseDude]

I stuck a file in $ORACLE_HOME/network/admin.... "touch HEY_THIS_AINT_THE_PLACE"

[@luckygamer9433]

How to solve in windows 10

[@DatabaseDude]

no different. In windows 10, there will be a "Homes" directory as well under Oracle Base (eg c:\oracle)

[@animelover-2529]

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
this is my error in SQL PLUS after entering my password, how to fix this ?
btw i installed oracle 21c in my non-OS drive, do i have to reinstall it in my OS drive??

[@DatabaseDude]

Go to where you installed oracle and for the "homes" directory. Under there you'll find network/admin/tnsnames.ora - that is where you need to add your tns entries if you are not using ezconnect.

[@Tomasz200010]

Hello, I was hoping for solution to my problem.
I also get this error message and I am using Windows 10.
My tns file looks like this.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-9T747SDV)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = 'here is my laptop name')(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 'here is my laptop name')(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)
What might be wrong?

[@DatabaseDude]

connect to XEPDB1 - what happens?

[@b_o_d_h_i_s_a_t_t_v_a]

the whole thing is stupid

[@DatabaseDude]

thank you were your well reasoned feedback :-)