暂无图片
Oracle 中 用alter改sys用户密码时 报错:01109数据库未打开,数据库能用,system用户密码也修改了
我来答
分享
暂无图片 匿名用户
Oracle 中 用alter改sys用户密码时 报错:01109数据库未打开,数据库能用,system用户密码也修改了

QQ图片20211207102106.jpg

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
你好我是李白

当你切换到一个未open的pdb时,或跟你报错相同,但是切换到一个open的pdb,也是无法修改sys密码的,下面为19.13版本测试。
sys/system属于common user,为全局用户,需要在cdb中修改密码。

-- cdb中修改密码 11:00:23 SYS@orcl2 > show con_name; CON_NAME ------------------------------ CDB$ROOT 11:00:25 SYS@orcl2 > show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 CZHPDB2 MOUNTED 4 CZHPDB READ WRITE NO 5 TEST MOUNTED 11:00:27 SYS@orcl2 > alter user sys identified by "ABCD."; User altered. -- mount状态pdb中修改sys密码 11:00:53 SYS@orcl2 > alter session set container=test; Session altered. Elapsed: 00:00:00.05 11:01:11 SYS@orcl2 > alter user sys identified by "ABCD."; alter user sys identified by "ABCD." * ERROR at line 1: ORA-01109: database not open Elapsed: 00:00:00.08 11:01:14 SYS@orcl2 > alter user system identified by "ABCD."; alter user system identified by "ABCD." * ERROR at line 1: ORA-01109: database not open -- open状态pdb修改sys、system密码 11:05:22 SYS@orcl2 > alter session set container=czhpdb; Session altered. Elapsed: 00:00:00.29 11:05:29 SYS@orcl2 > alter user sys identified by 'Abcd.'; alter user sys identified by 'Abcd.' * ERROR at line 1: ORA-00988: missing or invalid password(s) 11:08:14 SYS@orcl2 > alter user system identified by 'ABCD.'; alter user system identified by 'ABCD.' * ERROR at line 1: ORA-00988: missing or invalid password(s)
暂无图片 评论
暂无图片 有用 0
暂无图片
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏