Без рубрики

generate logminer list: build catalog find out transaction content: commit\rollback: if archivelogs are on tape:

NOTE: RUN ON STANDBY IF POSSIBLE =)

Hello, how to add custom metric to EM with «bad» sql and how-to diagnose results: usefull links first: Creating an Information Publisher Report based on a Custom Metric Extension whats_changed.sql based on this material add custom metric with query from query with performance degradation running more than 5 sec after all Enjoy the message like … Читать далее

find query with performance degradation running more than 5 sec : original by Kerry Osborne

while trying to commit distibuted transaction faced with «free global transaction table entry» solution foud at mos 549307.1 define local_tran_id: use mos note to force commit transaction: transaction state changed to forced commit ( or commit forced =) ), after that purge transcation entry

*copy passwd file from primary scp $ORACLE_HOME/dbs/passwd$ORACLE_SID{instance_number} cp [pwd file from primary] orapw$ORACLE_SID *create static listener create audit directory: create asm directory: *startup dummy instance: *connect auxiliary instance +connect target instance

ORA-15025, KFSG-00312, ORA-15081 Database Creation on 11.2 Grid Infrastructure with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) (Doc ID 1084186.1) su — grid $ORACLE_HOME/bin/setasmgidwrap o=/oracle/app/base/db/12.1.0.2/bin/oracle

for check i use nmap and Nmap script to test Oracle DB for «TNS poison vulnerability» check : solution is described by MOS: Valid Node Checking For Registration (VNCR) (Doc ID 1600630.1) How to Enable VNCR on RAC Database to Register only Local Instances (Doc ID 1914282.1) fixup: add to grid listener.ora REGISTRATION_INVITED_NODES_LISTENER_SCAN*=( list of … Читать далее

we can update whole column of big table with no downtime with dbms_redefinition and col_mapping there is an example: find table with lots of rows for test and make a copy: create interim table for redefinition and add column to remap data need to be updated, also set default value for column we need to … Читать далее

found at community.oracle.com