oracle 数据库用户的密码含有 @特殊字符sqlplus登录报错

oracle 数据库用户的密码含有 @特殊字符，sqlplus user/passwd@tnsname 方式登录报错 ORA-12514

环境:
用户: yqf1
密码: yqf1@123

sqlplus 登录失败:

[oracle@test admin]$ sqlplus yqf1/yqf1@123@test

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 20 16:25:43 2020

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

解决方法:
1.密码串 用双引号加单引号的方式

[oracle@test admin]$ sqlplus yqf1/'"yqf1@123"'@test

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 20 16:26:45 2020

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


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

2. 用双引号 括起密码，再用单引号括起用户/密码

[oracle@test admin]$ sqlplus 'yqf1/"yqf1@123"'@test

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 20 16:31:28 2020

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


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

pl/sql developer 客户端登录并不受密码串有特殊字符影响。