先tsnames.ora修改配置
用cmd窗口登陆sys用户 ,用命令 show con_name;查询当前模式,然后用select NAME,OPEN_MODE from v$pdbs; 查pdb的名字
输入命令切换 alter session set container=ORCLPDB1;
1:给hr用户授权连接;
2:修改hr用户密码;
解锁
alter user hr account unlock;
修改密码:
alter user hr identified by 123456;
授权连接
grant connect,resource to hr;
以下是18c版本的配置,配置好之后可以用plsql快速连接到这个地址,或者输入完整的数据库地址 localhost:1521/XEPDB1
XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-031HMQ3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)