So I would like to connect to a remote Oracle database from my Linux system using the oraclient 19c on the command line, but whenever I try to connect it sees the realmpart of my username as the server.
For example I want to connect with my username "[email protected]" to the database identified by "DB" in my tnsnames.ora, i do
sqlplus [email protected]@DB and of course it complains with
ORA-12154: TNS:could not resolve the connect identifier specified, because it thinks "REALM.DOMAIN" is the database.
When I try it without the realmpart like
sqlplus USER@DB it returns
ORA-01017: invalid username/password; logon denied.
How can I pass my username to the client?