oracle 用户含有特殊字符,使用 sqlplus时这样登录。
tnsnames.ora
LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
sqlplus
$ sqlplus 'u_abc/"123oa!*()AS"@local'
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 22 19:01:11 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
SQL>
SQL>
SQL> exit;
alter user
alter user u_abc identified by "123as!*()AS" ;