Some fun from the Angry DBA site – http://web.archive.org/web/20050206023801/http://www.angrydba.com/ Contents: Why are DBA’s angry? Angry DBA stories Is your DBA angry? Angry DBA Gallery How to make your DBA angry DBA Jokes Are you an angry DBA? The website disappeared a long time ago, but is still available thanks to the Wayback Machine. H/t APC.
Read More Angry DBAFound this error on upgrade to 11gR2 trying to call Oracle Reports from within database: ERROR at line 1: ORA-20001: Error for submit_report. Report: ab_batch. Error -29273 ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1722 ORA-24247: network access denied by access control list (ACL) ORA-06512: at “MYUSER.MYPROC”, line 60 ORA-06512: at line 1 Fix […]
Read More Fix for ORA-24247 ACL calling Oracle ReportsI found I had to disable the virbr0 network interface to get Oracle RAC 11gR2 11.2.0.2 to install correctly (on RHEL 5.8 64 bit 2.6.18-308.el5 with ocfs2). Problem was that root.sh failed on the second node. The error recorded in ocssd.log, “has a disk HB, but no network HB”, appeared to point to the multicast […]
Read More RAC 11.2.0.2 Grid install fails on second node until disable virbr0 virtual networkProblem today where one hourly cron MV refresh hung (waiting on “SQL*Net message from dblink”), causing the other refreshes to queue up waiting on locks, eventually using up all the session so users got “ORA-00018: maximum number of sessions exceeded” To prevent this happening in the future, it is possible to timeout the MV refresh […]
Read More Timeout SQL materialized view refreshhttp://createqrcode.appspot.com/ is good for creating QR Codes. Don’t use www.qrtag.net, because they redirect the URL to point at their own website.
Read More QR Code Tag createList out users by last activity in Atira’s Pure Research Information System with: SELECT a.username , u.name_first_name forename , u.name_last_name surname , TRUNC ( MAX ( a.entry_date ) ) last_audit_entry FROM audit_entry a , users u WHERE a.username = u.username(+) GROUP BY a.username , u.name_first_name , u.name_last_name ORDER BY 4 , 3 , 2 , […]
Read More Atira Pure Research – List Users by last activityThis SQL works for all years from AD 9 onwards: SELECT ‘2011’ , ‘2011’ || ‘/’ || SUBSTR ( 1 + TO_NUMBER ( ‘2011’ ) , -2 ) formatted FROM DUAL ; Results: ‘201 Formatted —- ——— 2011 2011/12
Read More Display four digit year as tax financial academic yearMy notes from the 2012 Oracle User Group Scotland Conference:
Read More Oracle User Group Scotland Conference 2012Steve Feuerstein here: There are two forms of code documentation: external and internal. External documentation is descriptive information about a program which is written and stored separately from the program itself. Internal documentation, also known as inline documentation or comments, is placed within the program itself, either at the program level or the statement level.
Read More Documentation and CommentsThis is the extreme limit for oracle dates: alter session set nls_date_format = ‘Dy DD-Mon-YYYY AD’ ; select sysdate, to_date(’01-JAN-4712 BC’,’DD-MON-YYYY AD’), to_date(’30-DEC-9999 AD’,’DD-MON-YYYY AD’) from dual ; Without encountering this error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 01841. 00000 – “(full) year must be between -4713 and […]
Read More Oracle range limit AD BC dates