- 下载oracle xe oracle官网
- 安装oracle 下一步下一步~记住密码
- 修改环境变量或添加:TNS_ADMIN,到oraclehome目录的admin路径
oraclehome百度大概位置 - 按下win键,找到Oracle开头的文件夹,里面有oracle提供的工具,找到Net Configuration Assistant,选择添加监听或配置,下一步下一步下一步,然后在TNS_ADMIN路径下会生成listener.ora和tnsnames.ora
- 打开cmd,输入sqlplus / as sysdba,或使用system登录后再 conn / as sysdba;
- 首先输入show pdbs;查看存在的pdb;
- 切换pdb,输入 alter session set container=****;
- 创建用户 create user usename identified by pasword;如在默认cdb环境下username需要加c##
- 分配权限 grant connect,resource,dba to username;
- 创建表空间create tablesspace tname datafile=‘d:\a\b\c\tname .dbf’ size 50m autoextend on next 10m maxsize 400m;
- 给用户分配空间 alter user usename quota unlimited on tname ;commit;
- 查看数据库拥有的pdb select name from v$database
- 选择其中之一的pdb,(使用默认则跳过此步骤),使用步骤7切换后,对用户赋予权限,grant create session to username;
- 配置监听程序,在oracle 的admin目录下创建listener.ora,其中SID_NAME是数据库实例,可通过sqlplus查看 select name from v$database;
# listener.ora Network Configuration File: C:\app\JW21080146\product\18.0.0\dbhomeXE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
DEFAULT_SERVICE_LISTENER = XE
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = xe)
(ORACLE_HOME = C:\app\JW21080146\product\18.0.0\dbhomeXE)
# (PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\JW21080146\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
)
(SID_DESC = #为xepdb1配置监听
(GLOBAL_DBNAME = xepdb1)
(SID_NAME = xe)
(ORACLE_HOME = C:\app\JW21080146\product\18.0.0\dbhomeXE)
# (PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\JW21080146\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.182)(PORT = 1521))
)
)
- plsql连接 输入账户密码,选择数据库直接连接
- navicat连接,使用默认pdb则根据监听文件输入,比如代码中的xe,选则其他pdb则使用定义的CLOBAL_DBNAME。进入后,可使用该pdb内新建的表空间