Par\u00e2metros de exemplo do export:<\/p>\n\n\n
\n[oracle@oel7 BSS]$ cat expdp.par\nUSERID=SYSTEM\/"*******"\nSCHEMAS=TESTE\nDIRECTORY=BSS\nDUMPFILE=DUMP.dmp\nLOGFILE=DUMP.log\nCOMPRESSION=ALL\nPARALLEL=2\n<\/pre><\/div>\n\n\nAp\u00f3s o disparo do EXPDP, o seguinte erro \u00e9 reportado:<\/p>\n\n\n
\n[oracle@oel7 BSS]$ cat DUMP.log.old\n;;;\nExport: Release 12.2.0.1.0 - Production on Mon Feb 15 10:09:28 2021\n \nCopyright (c) 1982, 2017, Oracle and\/or its affiliates. All rights reserved.\n;;;\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n;;; **************************************************************************\n;;; Parfile values:\n;;; parfile: parallel=2\n;;; parfile: compression=ALL\n;;; parfile: logfile=DUMP.log\n;;; parfile: dumpfile=DUMP.dmp\n;;; parfile: directory=BSS\n;;; parfile: schemas=TESTE\n;;; parfile: userid=SYSTEM\/********\n;;; **************************************************************************\nStarting "SYSTEM"."SYS_EXPORT_SCHEMA_01": SYSTEM\/******** parfile=expdp.par\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type SCHEMA_EXPORT\/USER\nProcessing object type SCHEMA_EXPORT\/STATISTICS\/MARKER\nORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [USER]\nUSER:"TESTE"\nORA-19505: failed to identify file "\/stage\/BSS\/DUMP.dmp"\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\nORA-06512: at "SYS.DBMS_SYS_ERROR", line 105\nORA-06512: at "SYS.KUPW$WORKER", line 12098\nORA-06512: at "SYS.DBMS_SYS_ERROR", line 105\nORA-06512: at "SYS.KUPF$FILE", line 9298\nORA-06512: at "SYS.KUPF$FILE_INT", line 1111\nORA-06512: at "SYS.KUPF$FILE", line 9241\nORA-06512: at "SYS.KUPW$WORKER", line 10727\n----- PL\/SQL Call Stack -----\n object line object\n handle number name\n0x229543850 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION\n0x229543850 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR\n0x229543850 11099 package body SYS.KUPW$WORKER.CREATE_OBJECT_ROWS\n0x229543850 14526 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS\n0x229543850 3689 package body SYS.KUPW$WORKER.UNLOAD_METADATA\n0x229543850 13063 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS\n0x229543850 2311 package body SYS.KUPW$WORKER.MAIN\n0x17fae75d8 2 anonymous block\nObject row index into parse items is: 1\nParse item count is: 4\nIn function CHECK_FOR_REMAP_NETWORK\nNothing to remap\nIn procedure BUILD_OBJECT_STRINGS - non-base info\nIn procedure BUILD_SUBNAME_LIST with USER:TESTE.TESTE\nIn function NEXT_PO_NUMBER\nPO number assigned: 16285\nKUPF$FILE.WRITE_LOB\nIn procedure DETERMINE_FATAL_ERROR with ORA-19505: failed to identify file "\/stage\/BSS\/DUMP.dmp"\nORA-06512: at "SYS.KUPF$FILE", line 9298\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\nORA-06512: at "SYS.KUPF$FILE_INT", line 1111\nORA-06512: at "SYS.KUPF$FILE", line 9241\nJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Mon Feb 15 10:11:39 2021 elapsed 0 00:02:07\n[oracle@oel7 BSS]$\n<\/pre><\/div>\n\n\nPercebi que meu ambiente de origem \u00e9 um Oracle RAC, e que devido isso, deveria adicionar o par\u00e2metro CLUSTER no momento do export:<\/p>\n\n\n
\n[oracle@oel7 BSS]$ cat expdp.par\nUSERID=SYSTEM\/"*******"\nSCHEMAS=TESTE\nDIRECTORY=BSS\nDUMPFILE=DUMP.dmp\nLOGFILE=DUMP.log\nCOMPRESSION=ALL\nPARALLEL=2\nCLUSTER=NO\n<\/pre><\/div>\n\n\nAp\u00f3s a altera\u00e7\u00e3o, o processo finalizou com \u00eaxito:<\/p>\n\n\n
\n[oracle@oel7 BSS]$ cat DUMP.log\n;;;\nExport: Release 12.2.0.1.0 - Production on Mon Feb 15 10:14:37 2021\n \nCopyright (c) 1982, 2017, Oracle and\/or its affiliates. All rights reserved.\n;;;\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n;;; **************************************************************************\n;;; Parfile values:\n;;; parfile: cluster=N\n;;; parfile: parallel=2\n;;; parfile: compression=ALL\n;;; parfile: logfile=DUMP.log\n;;; parfile: dumpfile=DUMP.dmp\n;;; parfile: directory=BSS\n;;; parfile: schemas=TESTE\n;;; parfile: userid=SYSTEM\/********\n;;; **************************************************************************\nStarting "SYSTEM"."SYS_EXPORT_SCHEMA_02": SYSTEM\/******** parfile=expdp.par\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type SCHEMA_EXPORT\/USER\nProcessing object type SCHEMA_EXPORT\/STATISTICS\/MARKER\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\nProcessing object type SCHEMA_EXPORT\/TABLESPACE_QUOTA\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\nProcessing object type SCHEMA_EXPORT\/SEQUENCE\/SEQUENCE\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\nProcessing object type SCHEMA_EXPORT\/FUNCTION\/FUNCTION\nProcessing object type SCHEMA_EXPORT\/PROCEDURE\/PROCEDURE\nProcessing object type SCHEMA_EXPORT\/FUNCTION\/ALTER_FUNCTION\nProcessing object type SCHEMA_EXPORT\/PROCEDURE\/ALTER_PROCEDURE\nProcessing object type SCHEMA_EXPORT\/VIEW\/VIEW\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\nProcessing object type SCHEMA_EXPORT\/TABLE\/TRIGGER\n \n...\n \nMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:\n \/stage\/BSS\/DUMP.dmp\nJob "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Mon Feb 15 10:29:01 2021 elapsed 0 00:14:22\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"Par\u00e2metros de exemplo do export: Ap\u00f3s o disparo do EXPDP, o seguinte erro \u00e9 reportado: Percebi que meu ambiente de origem \u00e9 um Oracle RAC, e que devido isso, deveria adicionar o par\u00e2metro CLUSTER no momento do export: Ap\u00f3s a altera\u00e7\u00e3o, o processo finalizou com \u00eaxito:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2174","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2174"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2174\/revisions"}],"predecessor-version":[{"id":9257,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2174\/revisions\/9257"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}