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/system123
ERROR:
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.