Linux 环境初始化Oracle数据库

1，登录系统用户（sys）

2,创建表空间

create tablespace KEYRISK logging datafile '/data/dbfile/KEYRISK.dbf' size 10240m 
autoextend on next 100m 
maxsize 30720m 
extent management local;

3，创建用户

CREATE USER keyrisk identified by keyrisk
  DEFAULT TABLESPACE KEYRISK
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT;

4，赋权

GRANT SELECT ON SYS.DBA_TABLES TO KEYRISK;
GRANT EXECUTE ON SYS.DBMS_CRYPTO TO KEYRISK;
GRANT EXECUTE ON SYS.DBMS_LOB TO KEYRISK;
GRANT EXECUTE ON SYS.DBMS_LOCK TO KEYRISK;
GRANT EXECUTE ON SYS.DBMS_METADATA TO KEYRISK;
GRANT EXECUTE ON SYS.DBMS_PARALLEL_EXECUTE TO KEYRISK;
GRANT EXECUTE, READ, WRITE ON DIRECTORY SYS.RPM TO KEYRISK WITH GRANT OPTION;
GRANT EXECUTE ON SYS.UTL_I18N TO KEYRISK;
GRANT EXECUTE ON SYS.UTL_RAW TO KEYRISK;
GRANT CONNECT TO KEYRISK;
GRANT DBA TO KEYRISK;
GRANT RESOURCE TO KEYRISK;
GRANT ALTER ANY SEQUENCE TO KEYRISK;
GRANT CREATE SESSION TO KEYRISK;
GRANT UNLIMITED TABLESPACE TO KEYRISK;