-
Recent Posts
Recent Comments
sachin Terdale on Dreaded error – PRVF-400… kelloggsville on Dreaded error – PRVF-400… Din on Dreaded error – PRVF-400… Archives
Categories
Meta
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