Erro: ORA-31655: no data or metadata objects selected for jobORA-39154: Objects from foreign schemas have been removed from importOrigem: expdp system/senha directory=dump TABLES=SICOM_COMUM.MANUAL_SICOM dumpfile= manual_sicom_.dmp logfile=exp_manual.logDestino:usuario/senha directory=dump2 dumpfile=manual_sicom.dmp logfile=imp_manual.log -- certoNo momento de importar e gerado o seguinte erro:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-31655: no data or metadata objects selected for jobORA-39154: Objects from foreign schemas have been removed from importCorrecao: Conceder privilegio para usuario destinogrant imp_full_database to usuario;Importar novamente com sucesso.outra opcao seria importar da seguinte forma:impdp system/senha directory=dump2 dumpfile=manual_sicom.dmp logfile=imp_si_comum.log remap_schema=USUARIO_ANTIGO:USUARIO_NOVO remap_tablespace=USUARIO_ANTIGO_D:USUARIO_NOVO_D, USUARIO_ANTIGO_I:USUARIO_NOVO_I Neste caso nao necessita conceder privilegio algum por causa do usuario system.Obs: Foi usado remap porque o schema de exportacao e diferente do schema de importacao.Importado com sucesso:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsMaster table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloadedProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/TABLE_DATA. . imported "USUARIO_NOVO"."MANUAL_SICOM" 528.6 KB 2806 rowsProcessing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type TABLE_EXPORT/TABLE/INDEX/INDEXProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/COMMENTProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSJob "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 12:16:18 ERROR : ORA-12516: TNS:listener could not find available handler with matching protocol stackMotivo do erro: Limite de processo atingido. Nao e possivel criar mais sessoes no banco.Ocorreu o erro comigo em apenas uma instancia, ate achei que poderia ser o listener que caiu, porem a queda afetaria todas as instancias.Para verificar o valor maximo de sessao e processo do banco e necessario executar a sequinte consulta com o usuario system:select name, value from v$parameter where name in (processes,'sessions);select * from v$resource_limit;Para aumentar o processo e necessario logar com sys e executar os comandos abaixo:alter system set processes=300 scope=spfile;alter system set sessions=300 scope=spfile;Para realizar a alteracao e necessario realizar o shutdown e startup do banco. O post de hoje e referente ao problema que tive ao realizar um expdp:Ao executar o expdp:export ORACLE_SID=desenv[oracle@servidor dump]$ expdp system/senhadirectory=dump dumpfile=teste.dmp logfile=teste.log schemas=testeForam retornardos os seguintes erros:Export:Release 10.2.0.4.0 - 64bit Production on Thursday, 11 April, 2013 17:26:49 Copyright(c) 2003, 2007, Oracle. All rightsreserved. Connectedto: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bitProductionWith thePartitioning, OLAP, Data Mining and Real Application Testing optionsORA-39006:internal errorORA-39065:unexpected master process exception in DISPATCHORA-00607:Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [2024],[4279153], [4279158], [8192], [6], [2], [1893406378], [380241410]ORA-39097:Data Pump job encountered unexpected error -6072a Tentativa: Connectedto: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bitProductionWith thePartitioning, OLAP, Data Mining and Real Application Testing optionsEstimate inprogress using BLOCKS method...Processingobject type SCHEMA_EXPORT/TABLE/TABLE_DATAORA-39125:Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS whilecalling DBMS_METADATA.FETCH_XML_CLOB [] ORA-06512:at "SYS.DBMS_SYS_ERROR", line 95ORA-06512:at "SYS.KUPW$WORKER", line 6307 -----PL/SQL Call Stack ----- object line object handle number name0x65eb04e8 15032 package body SYS.KUPW$WORKER0x65eb04e8 6372 package body SYS.KUPW$WORKER0x65eb04e8 9206 package body SYS.KUPW$WORKER0x65eb04e8 1936 package body SYS.KUPW$WORKER0x65eb04e8 6944 package body SYS.KUPW$WORKER0x65eb04e8 1314 package body SYS.KUPW$WORKER0x68a69688 2 anonymous block O erro que mais me chamou atencao foi :ORA-04031: unable to allocate 4176 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","object queue "):O SGDB tenta alocar memoria, porem nao consegue impossiblitando de realizar qualquer