重庆思庄Oracle、Redhat认证学习论坛

标题: ORACLE 19C 实现不管大小写 [打印本页]

作者: 郑全 时间: 2021-11-6 17:58
标题: 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 lijie identified by lijiE;

4.无关大小写
  SQL> conn lijie/lijiE@192.168.133.121:1521/pdb1;
  Connected.

  SQL> conn lijie/lijie@192.168.133.121:1521/pdb1;
  onnected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)