oracle java.sql.SQLException: ORA-00911: 无效字符和ORA-01017: invalid username/password； logon denied

1.执行sql报错

[Err] ORA-00911: 文字が無効です。

select 用户 from XXX.表名 t where 用户 is not null

将sql中出现汉字的表名和字段名，使用双引号包起来，可以执行成功

select "用户" from XXX."表名" t where "用户" is not null

2.连接oracle数据库system用户报错

ORA-01017: invalid username/password; logon denied

2.1登录使用sysdba用户

[oracle@localhost ~]$ sqlplus / as sysdba

2.2切换system用户

SQL> conn system/system123ERROR:ORA-01017: invalid username/password; logon denied

2.3重置修改system用户的密码即可

SQL> alter user system identified by system123;User altered.

2.4重新连接system用户即可

SQL> conn system/softroad;Connected.