腾讯云oracle数据库导入

最新推荐文章于 2023-02-16 10:43:30 发布

原创最新推荐文章于 2023-02-16 10:43:30 发布 · 386 阅读

0 ·

CC 4.0 BY-SA版权

腾讯云专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在腾讯云环境中导入Oracle数据库的步骤，包括切换用户、登录数据库、创建表空间和用户、复制文件及执行导入操作。同时，针对导入过程中可能遇到的错误提供了具体的解决方法。

腾讯云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

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;