【Oracl】 Oracle 19c 安装流程

官网下载Oracle Database 19c

将 WINDOWS.X64_193000_db_home.zip 解压到oracle19c文件夹

管理员身份运行setup.exe

安装目录

参考：Oracle19c安装过程

启动oracle监听

lsnrctl start

查看监听状态

lsnrctl status

启动oracle服务
先右击我的电脑–>管理–>服务和应用程序–>服务
找到这两个服务(OracleServiceXE、OracleXETNSListener)这两个服务必须启动才能连接上数据库

PL/SQL

连接

system/123456
127.0.0.1:1521@ocrl

sql

-- 验证是否安装成功
select 1 from dual;
 
-- 创建表空间
CREATE TABLESPACE dbname_tbs_orclpdb
DATAFILE 'D:\Oracle19cEXE\oradata\ORCL\orclpdb\dbname_tbs_orclpdb.dbf' size 30720M
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 
     
-- 索引表空间
CREATE TABLESPACE dbname_tbs_orclpdb_Index
DATAFILE 'D:\Oracle19cEXE\oradata\ORCL\orclpdb\dbname_tbs_orclpdb_Index.dbf' size 2048M         
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;     
 
-- 建用户
create user dbname identified by 123456 default tablespace dbname_tbs_orclpdb;
 
-- 赋权
grant connect,resource to dbname;
grant create any sequence to dbname;
grant create any table to dbname;
grant delete any table to dbname;
grant insert any table to dbname;
grant select any table to dbname;
grant unlimited tablespace to dbname;
grant execute any procedure to dbname;
grant update any table to dbname;

完整

登录orcl实例的system 执行以下语句

create pluggable database dbnamepdb admin user dbname identified by 123456 
roles=(connect) 
file_name_convert=('D:\Oracle19cEXE\oradata\ORCL\pdbseed','D:\Oracle19cEXE\oradata\ORCL\dbnamepdb');

cmd窗口
sqlplus / as sysdba
sql> 执行以下语句

alter pluggable database  dbnamepdb open;

登录dbnamepdb实例的system 执行以下语句

grant connect,resource to dbname;
grant create any sequence to dbname;
grant create any table to dbname;
grant delete any table to dbname;
grant insert any table to dbname;
grant select any table to dbname;
grant unlimited tablespace to dbname;
grant execute any procedure to dbname;
grant update any table to dbname;
grant create any view to dbname;

system 对应实例 账号登录 给用户赋予创建dblink权限

grant create public database link,drop public database link to dbname;

后续执行数据库的建表等增删改查操作

拓展

-- 显示当前用户下的所有表
select * from user_tables;
select * from tab;
 
-- 会显示用户表及表空间
select TABLE_NAME from all_tables where owner = 'dbname';
 
-- 采用sys用户登陆 。(显示出来的TABLESPACE_NAME就是你当前操作的表空间的名字)
select tablespace_name from dba_tables where table_name = upper('你要操作的表名')