win10系统设置
找到 tnsnames.ora文件,然后写入:
ORCL_DOCKER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 本机IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = helowin)
)
)
创建数据库角色
Oracle /创建用户和角色/
SELECT * FROM ALL_USERS;/查看登录用户/
/创建用户/
create user longxi identified by longxi123
default tablespace users /默认表空间/
temporary tablespace temp /临时表空间/
quota unlimited on users; /* 默认角色*/
权限分配
GRANT DBA TO longxi;/给DBA的权限/