腾讯云oracle数据库导入
1.切换oracle
[root@VM_0_10_centos ~]# su - oracle
Last login: Thu Jun 25 21:48:21 CST 2020 on pts/0
[oracle@VM_0_10_centos ~]$
2.登陆oracle数据库
[oracle@VM_0_10_centos ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 25 22:59:45 2020
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
3.切换用户
SQL> conn system/###
Connected.
SQL>
4.创建表空间和用户
create tablespace SH datafile '/data/oracle/admin/orcl/dpdump/SH.dbf' size 50m autoextend on next 50m maxsize 4000m extent management local;
create tablespace CHSHR datafile '/data/oracle/admin/orcl/dpdump/CHSHR.dbf' size 50m autoextend on next 50m maxsize 4000m extent management local;
create tablespace OA datafile '/data/oracle/admin/orcl/dpdump/OA.dbf' size 50m autoextend on next 50m maxsize 4000m extent management local;
create user cosem identified by "###" default tablespace SH;
grant dba to cosem;
create user COSEMGUEST identified by "###";
create user MWPMS identified by "###";
create user COSEMFORSQEMS identified by "###";
create user MDMUSER identified by "###";
create user CMESAPP identified by "###";
create user BVM identified by "###";
5.复制文件到/data/oracle/admin/orcl/dpdump
6.退出sqlplus,执行导入
impdp cosem/###@orcl dumpfile=43zsny200624_2.dmp full = y table_exists_action=replace
drop user COSEMGUEST;
drop user MWPMS;
drop user COSEMFORSQEMS;
drop user MDMUSER;
drop user CMESAPP;
drop user BVM;
问题
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.
解决方法:
show parameter processes
alter system set aq_tm_processes=1 scope=both;