1

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?

Improve this question
2
  • Did you configure the database to use Active Directory? How? (Just give the URL to the document you followed)
    – Michael Kutz
    Feb 3, 2020 at 13:56
  • No I didn't configure it. It's a customers database.
    – PSQLNutzer
    Feb 3, 2020 at 14:26

1 Answer 1

Reset to default
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>
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.