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?
asked Feb 3, 2020 at 13:00
-
Did you configure the database to use Active Directory? How? (Just give the URL to the document you followed)Michael Kutz– Michael Kutz2020年02月03日 13:56:47 +00:00Commented Feb 3, 2020 at 13:56
-
No I didn't configure it. It's a customers database.PSQLNutzer– PSQLNutzer2020年02月03日 14:26:46 +00:00Commented Feb 3, 2020 at 14:26
1 Answer 1
For special usernames, use double quotes.
SQL> create user "[email protected]" identified by 1;
User created.
SQL> grant create session to "[email protected]";
Grant succeeded.
SQL> connect [email protected]/1
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL> connect "[email protected]"/1
Connected.
SQL>
answered Feb 3, 2020 at 15:24
lang-sql