Use the command line method to log on to SqlPlus. The password contains special characters and special characters of sqlplus.

Use the command line method to log on to SqlPlus. The password contains special characters and special characters of sqlplus.

All hits!
It's really hard to wait! Oracle 12c. If you want to log on to SQL plus, there is no graphical interface. a command line is provided directly. Now, I have multiple instances in this database, which means that you need to specify the instance for Logon. The password contains the special character "@", wow! Because I have tried to log on with the sauce purple before:

Sqlplus username/password @ Instance name as sysdba

What's the problem now?

Sqlplus sys /! Q @ W3e4r @ sso as sysdba, failed! Here! Q @ W3e4r is the password.

Finally, after hard online searching and self-searching, the process is divided into two steps:

C: \ Users \ Administrator> sqlplus "as sysdba"

C: \ Users \ Administrator> Enter user-name: sys /"! Q @ W3e4r "@ sso

Done!

Copyright Disclaimer: This article is the original author's article. If you like it, you can take it away.