Prometey Lab Blog

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

SELECT s.sql_handle,s.* FROM dba_sql_plan_baselines s; SELECT * FROM TABLE (dbms_xplan.display_sql_plan_baseline(‘SQL_0c408547ef15f69d’));

test upgrade to 12c on RedHat 7.2 faced with WA is to set RemoveIPC=no in /etc/systemd/logind.conf ps ( MOS Doc ID 438205.1)