Oracle19c,Oracle 19c 实现密码不区分大小写
1.修改参数
alter system set sec_case_sensitive_logon=false;
2.修改SQLNET.ORA
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
3.修改一下用户密码
alter user ttt identified by ttt123;
4.无关大小写
SQL> conn ttt/[email protected]:1521/orcl;
Connected.
SQL> conn ttt/[email protected]:1521/orcl;
Connected.
Tag: Oracle19c