Category Archives: Uncategorized

CSV format native support in 12.2.0.1 Oracle Sqlplus!! Finally

Long awaited!!!! SQL> set markup csv on delim ‘|’ quote on SQL>select object_name,object_id,object_id from dba_objects where rownum<5 “OBJECT_NAME”|”OBJECT_ID”|”OBJECT_ID” “/1000323d_DelegateInvocationHa”|35562|35562 “/10016a97_ZipArchiveZipFileObj”|124771|124771 “/100277f0_XMLErrorResources_ko”|130343|130343 “/100361c3_MotifOptionPaneUI1″|126065|126065 — SQL> alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; Session altered. SQL> set hist on SQL> hist .. .. 8 … Continue reading

Posted in Uncategorized | Leave a comment

ntpd -L – ORACLE RAC 11gR2 (may be 12c) – eviction &/or cpu spike

Please check if you are noticing “Delet” interface by ntpd in /var/log/messages* when node is evicted and or you notice some strange “spike” if crs process CPU utilization   Add option -L to /etc/sysconfig/ntpd – to tell ntpd to skip … Continue reading

Posted in Uncategorized | Leave a comment

12cR1 – GRID install fails with error INS-06006

from shell where OUI is launched – run following – $ ssh-add Now try again ssh connectivity test option on OUI (where you have added all relevant RAC nodes) Worked for me – It was frankly nightmare. MOS has no … Continue reading

Posted in Uncategorized | Leave a comment

ORA-01775: looping chain of synonyms

Deadly for database – I mean you may end up totally down for all you folks out there – including active data guards and all brothers & sisters of them! SQL> select * from dual; select * from dual * … Continue reading

Posted in 11gr1, 11gr2, Uncategorized | Leave a comment