Oracle密码有@等特殊字符，连接报ORA-12532: TNS:invalid argument

jiawang

当oracle密码含有特殊字符时，在创建的时候，必须要用双引号把密码包起来才能创建成功
例子：
SQL> create user wj identified by oracle@123;
create user wj identified by oracle@123
                                   *
ERROR at line 1:
ORA-00922: missing or invalid option


必须把密码包起来：
SQL> create user wj identified by "oracle@123";
User created.

SQL>

SQL> grant connect,resource to wj;
Grant succeeded.

连接报错：
SQL> conn wj/oracle@123;
ERROR:
ORA-12532: TNS:invalid argument


Warning: You are no longer connected to ORACLE.

也需要双引号

SQL> conn wj/"oracle@123";
Connected.

使用sqlplus切换到指定的数据库，报错
[oracle@strong admin]$ sqlplus wj/"oracle@123" @ORCL

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 8 16:48:30 2023

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12532: TNS:invalid argument


正确连接方式：
[oracle@strong admin]$ sqlplus 'wj/"oracle@123"' @ORCL

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 8 16:48:44 2023

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SP2-0310: unable to open file "ORCL.sql"
SQL>      

通过单引号将用户密码包起来，用双引号把密码包起来，就可以正常连接数据库啦。

推荐的特殊字符：_ $ #

其他特殊字符密码必须加双引号