I created two oracle instances on a windows machine 19c.
And then I tried to connect remotely, or even locally using easy connect:
sqlplus system/mypassword@'servername.mydomain:1521/testo.mydomain'
I got an error :
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
I cannot figure out why. I have two database instances on the remote computer, one is called testO, the other devO on same port 1251. they are all up running.
I can connect on the local server itself when using sqlplus / as sysadmin
what could be wrong?
Thanks,