Oraclele 12c解锁HR模式
程序员文章站
2022-07-13 14:12:03
...
Oraclele 12c解锁HR模式
- Win键+R打开小窗口运行cmd,然后按照下面步骤进行:
-- 以管理员身份登录数据库 sqlplus / as sysdba -- show con_name; -- SELECT name, con_id FROM v$pdbs; -- SELECT name FROM v$active_services WHERE con_id = 3;
- 配置本地oracle连接文件
- 保存并关闭上面文件,以管理员运行控制台,详细如下图
- 运行下面命令:
-- lsnrctl reload -- sqlplus / as sysdba -- SHOW con_name; -- ALTER SESSION SET CONTAINER = pdborcl; -- SHOW con_name; -- SELECT name, open_mode FROM v$pdbs; -- ALTER USER hr IDENTIFIED By hr ACCOUNT UNLOCK; -- conn hr/hr@PDBORCL -- SHOW USER;
- 注意点
-- ALTER PLUGGABLE DATABASE open; -- SELECT name, open_mode FROM v$pdbs;
推荐阅读