• 

 

Deu erro

 

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 1 with process name "DW00" prematurely terminated

ORA-31671: Worker process DW00 had an unhandled exception.

Then re-attempt the problematic export operation.

Does the export still encounter an ORA-00600 [7999] error ?

 

 

Tente :

 

STREAMS_POOL_SIZE is set to 0 at the CDB level. That should be set to minimum value of no less than 64M or 128M 

 

Funcionou faz o pix.

Não Funcionou :

 

Tente o RELINK ALL

 

 

==> Steps to Execute RELINK ALL:

(x) Verify that there is a recent backup of ORACLE_HOME and the database.

 

(x) Log in as the Oracle user on the OS. (Our environment already loads the environment variables.)

 

(x) Check the Oracle user's environment variables:

echo $ORACLE_HOME, echo $ORACLE_SID, echo $PATH, etc.

 

(x) Check available disk space (the relink process may require a considerable amount of temporary space).

 

(x) Shutdown the database:

sqlplus / as sysdba

shutdown immediate

 

(x) Stop the listeners:

    lsnrctl status

lsnrctl stop

 

(x) Navigate to the ORACLE_HOME/bin directory:

cd $ORACLE_HOME/bin

 

(x) Execute the relink all command:

    relink all << /u01/app/oracle/homes/OraDB21Home1/install/relinkActions2025-05-28_03-08-11PM.log >>

 

(x) Validate the recompiled binaries:

ldd oracle

 

(x) Start the database:

sqlplus / as sysdba

startup

 

(x) Start a Pluggable Database (PDB):

show pdbs;

alter pluggable database <<SEU PDB>> open;

alter pluggable database all open;

select name, open_mode from v$pdbs;

 

(x) Start the listeners:

    lsnrctl status

lsnrctl start

 

EXEC DBMS_STATS.GATHER_SCHEMA_STATS('<<SEU PDB>>');

 

<<INFORME SUA SENHA>>

 

@?/rdbms/admin/catproc.sql

@?/rdbms/admin/utlrp.sql

@?/rdbms/admin/catdp.sql

 

-- Reexecuta scripts do Data Pump

@?/rdbms/admin/catdp.sql

-- Reexecuta objetos de sistema

@?/rdbms/admin/catproc.sql

 

Funcionou faz o pix.

Não Funcionou :

 

Analise os arquvios :

<< MEU CDB>>_dw00_99999.trm

<< MEU CDB>>_dw00_99999.trc

no diretorio _dw00 

Este arquivos estão em :

/u01/app/oracle/diag/rdbms/<< MEU CDB>> /<< MEU CDB>> /trace 

 

==================

 

No meu caso funciou alterando a sequencia IDGEN1$;

 

SET LONG 1000000

SET PAGESIZE 0

SET TRIMSPOOL ON

SELECT SYS.DBMS_METADATA.GET_DDL('SEQUENCE','IDGEN1$','SYS') FROM DUAL;

SET LONG 80

SET PAGESIZE 14

 

  CREATE SEQUENCE  "SYS"."IDGEN1$"  MINVALUE 1 MAXVALUE 99999999999999999999999

99999 INCREMENT BY 1 START WITH 48358745 NOCACHE  NOORDER  NOCYCLE  NOKEEP  NOSC

ALE  GLOBAL 

 

 

 

ALTER SEQUENCE IDGEN1$ INCREMENT BY 50;

 

* O parâmetro ID GEN 1 ou semelhante é uma indicação de que o ID está sendo gerado automaticamente, geralmente em um contexto de banco de dados ou sistema de gestão de dados. 

Isso simplifica o processo de identificação e gerenciamento de registros, garantindo a unicidade dos IDs e evitando a necessidade de inseri-los manualmente.