新增用户
查询PDB信息
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ZEPDB1 READ WRITE NO
SQL> alter session set container=zepdb1;
Session altered.
- 1、新建用户的默认数据表空间、临时表空间
明确表空间数据文件路径
SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files;
SQL> select TABLESPACE_NAME,FILE_NAME from dba_temp_files;
新增用户默认表空间
create tablespace data_ze datafile '/data/oradata/MRISCDB1/mrispdb1/data_ze01.dbf' size 2G autoextend on; create temporary tablespace temp_ze tempfile '/data/oradata/MRISCDB1/mrispdb1/temp_ze01.dbf' size 2G autoextend on; create user ze identified by "52ze" account unlock; alter user ze default tablespace data_ze temporary tablespace temp_ze;
- 2、创建默认的profile
CREATE PROFILE "PASSWD_UNLIMIT" LIMIT SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED CONNECT_TIME UNLIMITED IDLE_TIME UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL UNLIMITED COMPOSITE_LIMIT UNLIMITED PRIVATE_SGA UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED PASSWORD_VERIFY_FUNCTION NULL;
alter user ze profile PASSWD_UNLIMIT;
- 3、权限赋权
grant connect,resource,create session,unlimited tablespace to ze;
GRANT EXPORT FULL DATABASE TO ze;
GRANT IMPORT FULL DATABASE TO ze;
GRANT DATAPUMP_EXP_FULL_DATABASE TO ze;
GRANT DATAPUMP_IMP_FULL_DATABASE TO ze;
grant select any table to ze ;
GRANT READ,WRITE ON DIRECTORY DATA_PUMP_DIR to ze;
- 4、配置SQLNET.ORA配置兼容Oracle低版本
$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8