2024年4月14日发(作者：)

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

SQL> alter session set container=pdb;

Session altered.

SQL> create user zkm identified by oracle;

User created.

SQL> select password_versions from dba_users where username='ZKM';

PASSWORD_VERSIONS

-----------------

11G 12C

将sec_case_sensitive_logon设置为false后，

SQL> grant resource,connect to zkm;

Grant succeeded.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oracle19c ~]$ sqlplus zkm/oracle@oracle19c/pdb ----此时可以正常登录

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 11 09:32:49 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> exit

[oracle@oracle19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 11 09:33:14 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> alter system set sec_case_sensitive_logon=false sid='*' scope=both;

System altered.

SQL> alter session set container=pdb;

Session altered.

SQL> show parameter case

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon boolean FALSE

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oracle19c ~]$ sqlplus zkm/oracle@oracle19c/pdb

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 11 09:34:07 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

ERROR: