Lembrando desta época ... :)

 Vários compartilhamentos que salvaram o dia !!

reparar problema com lingering objects no AD - Event ID:1988

Comando para reparar problema com  lingering objects no AD.


repadmin /removelingeringobjects servidor.empresa.com 25844c3a-2992-4594-9361-126862365e5e DC=empresa,DC=com /advisory_mode


servidor.empresa.com -> Source, DC onde estão os lingering objects
25844c3a-2... -> Target, DC onde apresentou erros no event viewer
/advisory_mode - > Não efetiva o comando, apenas testa.


Referencias:
http://support.microsoft.com/?id=314282
http://support.microsoft.com/kb/870695

Import Oracle - Error SYS.DBMS_REPCAT_MIG.PRE_IMPORT

Export executado com a opção FULL=Y, exporta também os objetos dos usuários SYS, SYSTEM e demais. Quando na importação usa-se o usuário SYSTEM, este tem como Synonym alguns itens que conflitam com o objeto original ... gerando os erros a seguir:

imp system@manager file=export.dmp ignore=y grants=n indexes=n log=imp.log full=n fromuser=prod touser=lab tables=(tb_he,tb_de) constraints=n compile=n
Import: Release 9.2.0.8.0 - Production on Wed Mar 3 10:08:49 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via direct pathimport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setIMP-00046: using FILESIZE value from export file of 8585740288IMP-00017: following statement failed with ORACLE error 6550: "BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"IMP-00003: ORACLE error 6550 encounteredORA-06550: line 1, column 8:PLS-00201: identifier 'SYS.DBMS_REPCAT_MIG' must be declaredORA-06550: line 1, column 8:PL/SQL: Statement ignoredIMP-00000: Import terminated unsuccessfully

Solução após 1 semana de sofrimento: importar usando SYS as SYSDBA

imp 'sys@tns as sysdba' ignore=y .....

Boa Sorte

Quotas no Windows

Gerenciamento de Quotas no Windows

RAID 6

Uma melhoria do RAID 5 - dual parity, já que temos discos maiores e mais acessíveis.
link para detalhes de funcionamento. aqui

Controlando Jobs no Oracle

Link

Free space in Tablespaces

SELECT dts.tablespace_name,NVL(ddf.bytes / 1024 / 1024, 0) avail,
NVL(ddf.bytes - NVL(dfs.bytes, 0), 0)/1024/1024 used,
NVL(dfs.bytes / 1024 / 1024, 0) free,
TO_CHAR(NVL((ddf.bytes - NVL(dfs.bytes, 0)) / ddf.bytes * 100, 0), '990.00') "Used %",
dts.contents,dts.extent_management,dts.status FROM sys.dba_tablespaces dts,
(select tablespace_name, sum(bytes) bytes
from dba_data_files group by tablespace_name) ddf,
(select tablespace_name, sum(bytes) bytes
from dba_free_space group by tablespace_name) dfs
WHERE dts.tablespace_name = ddf.tablespace_name(+)
AND dts.tablespace_name = dfs.tablespace_name(+)
AND NOT (dts.extent_management like 'LOCAL'
AND dts.contents like 'TEMPORARY')
UNION ALL
SELECT dts.tablespace_name,NVL(dtf.bytes / 1024 / 1024, 0) avail,
NVL(t.bytes, 0)/1024/1024 used,NVL(dtf.bytes - NVL(t.bytes, 0), 0)/1024/1024 free,
TO_CHAR(NVL(t.bytes / dtf.bytes * 100, 0), '990.00') "Used %",dts.contents,
dts.extent_management,dts.status
FROM sys.dba_tablespaces dts,
(select tablespace_name, sum(bytes) bytes
from dba_temp_files group by tablespace_name) dtf,
(select tablespace_name, sum(bytes_used) bytes
from v$temp_space_header group by tablespace_name) t
WHERE dts.tablespace_name = dtf.tablespace_name(+)
AND dts.tablespace_name = t.tablespace_name(+)
AND dts.extent_management like 'LOCAL'
AND dts.contents like 'TEMPORARY';