Erro ao conectar no PL/SQL Developer após migração RMAN Solução Crie um PASSWORD FILE $ export ORACLE_SID=TESTE orapwd file=/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwTESTE password=Senha123
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[oracle@bdora]$ time impdp system/senha schemas=Nome directory=BKPDIR dumpfile=NOME_SCHEMA.dmp logfile=impNovo.log EXCLUDE=STATISTICS Import: Release 11.2.0.2.0 - Production on Tue Apr 24 10:12:49 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-31626: job does not exist ORA-31633: unable to create master table "SYSTEM.SYS_IMPORT_SCHEMA_06" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1020 ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM real 0m0.397s user 0m0.022s sys 0m0.022s |
Visualizando eventos ddl
|
1 2 |
SYS@XE > select owner, object_name, object_type, status from dba_objects where lower(object_name) like '%evs_monitoring_ddl'; no rows selected |
Verificando fila de execução datapump
|
1 2 3 4 5 6 |
column owner_name format a20; column job_name format a20; column operation format a10; column job_mode format a10; column state format a15; column attached_sessions format a10; |
|
1 2 3 4 5 6 |
SYS@XE > SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs; OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS -------------------- -------------------- ---------- ---------- --------------- ----------------- SYSTEM SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA NOT RUNNING ########## |
Dropando table system.SYS_IMPORT_SCHEMA_01
|
1 2 |
SYS@XE > drop table system.SYS_IMPORT_SCHEMA_01; Table dropped. |
Verificando Jobs
|
1 2 |
SYS@XE > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs; no rows selected |
Problema ao rodar impdp Oracle Release 12.2.0.1.0
|
1 |
impdp system/senha@orcl directory=BKP_DIR dumpfile=BKP.dmp logfile=imp_full.log EXCLUDE=statistics; |
Logs
|
1 2 3 4 5 6 7 8 9 10 11 12 |
Import: Release 12.2.0.1.0 - Production on Wed Mar 14 16:27:47 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3588 ORA-06512: at "SYS.KUPM$MCP", line 2628 ORA-39097: Data Pump job encountered unexpected error -1001 |
Causa: O dataPump não pode usar a API metadados. Isso ocorre devido as folhas de estilo XSL não estarem configuradas corretamente. Solução: Durante o dbms_metadata_util.load_stylesheets, le o diretório $ ORACLE_HOME /dbms /xml /xsl e carregamos os arquivos XSL usando o pacote DBMS_LOB. Se os arquivos…