pdb_lockdown会造成很多奇怪的问题

最新推荐文章于 2023-05-12 02:25:56 发布

wgz7747147820

最新推荐文章于 2023-05-12 02:25:56 发布

阅读量178

点赞数

分类专栏： orale 文章标签： oracle

本文链接：https://blog.csdn.net/wgz7747147820/article/details/98206864

版权

orale 专栏收录该内容

204 篇文章 0 订阅

订阅专栏

pdb_lockdown导致的sys用户无法连接pdb
[oracle@scaqad02adm01 bin]$ ./sqlplus "/as sysdba"

SQL*Plus: Release 20.0.0.0.0 - Development on Fri Aug 2 00:18:36 2019
Version 20.1.0.0.0

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


Connected to:
Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development
Version 20.1.0.0.0

SQL> show parameter pdb_lockdown

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
pdb_lockdown			     string
SQL> alter system set pdb_lockdown='PAAS' scope=both;

System altered.

SQL> quit
Disconnected from Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development
Version 20.1.0.0.0
[oracle@scaqad02adm01 bin]$ ./sqlplus "sys/wgz01@wgz01pdb10001 as sysdba"

SQL*Plus: Release 20.0.0.0.0 - Development on Fri Aug 2 00:19:04 2019
Version 20.1.0.0.0

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@scaqad02adm01 bin]$ ./sqlplus "/as sysdba"

SQL*Plus: Release 20.0.0.0.0 - Development on Fri Aug 2 00:19:14 2019
Version 20.1.0.0.0

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


Connected to:
Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development
Version 20.1.0.0.0

SQL> alter system set pdb_lockdown='' scope=both;

System altered.

SQL> exit
Disconnected from Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development
Version 20.1.0.0.0
[oracle@scaqad02adm01 bin]$ ./sqlplus "sys/wgz01@wgz01pdb10001 as sysdba"

SQL*Plus: Release 20.0.0.0.0 - Development on Fri Aug 2 00:19:34 2019
Version 20.1.0.0.0

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


Connected to:
Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development
Version 20.1.0.0.0

SQL>