Pages
Categories
Apex Audit Book review Bugs Character sets Database links Dataguard Email General musings Grid control Installs Linux Materialized views Old Oracle forms Performance tuning PL/SQL RAC Rman Scripts Security Sharepoint Space Spfile SQL*Net SQL Developer SQL server Stats Uncategorized Windows WordpressCategories
- Apex (1)
- Audit (1)
- Book review (2)
- Bugs (6)
- Character sets (6)
- Database links (2)
- Dataguard (1)
- Email (3)
- General musings (6)
- Grid control (2)
- Installs (11)
- Linux (18)
- Materialized views (3)
- Old (1)
- Oracle forms (4)
- Performance tuning (17)
- PL/SQL (4)
- RAC (7)
- Rman (11)
- Scripts (33)
- Security (3)
- Sharepoint (1)
- Space (6)
- Spfile (2)
- SQL Developer (1)
- SQL server (7)
- SQL*Net (4)
- Stats (4)
- Uncategorized (15)
- Windows (7)
- Wordpress (3)
Archives
- May 2013
- March 2013
- February 2013
- January 2013
- November 2012
- October 2012
- July 2012
- June 2012
- April 2012
- March 2012
- February 2012
- December 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- April 2009
- March 2009
- November 2008
- January 2008
- November 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
Recent Comments
- Stacia on Change WordPress colours for link visited hover
- balram on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- tory burch tote sale on Data block corruption cleared with alter system flush buffer_cache
- Bearer of Pain on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Andrew Fraser on Make indexes unusable before big insert
Category Archives: Uncategorized
Angry DBA
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 … Continue reading
Posted in Uncategorized
Leave a comment
Fix for ORA-24247 ACL calling Oracle Reports
Found 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 … Continue reading
Posted in Uncategorized
Leave a comment
RAC 11.2.0.2 Grid install fails on second node until disable virbr0 virtual network
I 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 … Continue reading
Posted in Uncategorized
Leave a comment
Timeout SQL materialized view refresh
Problem 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” … Continue reading
Posted in Uncategorized
Leave a comment
QR Code Tag create
http://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.
Posted in Uncategorized
Leave a comment
Atira Pure Research – List Users by last activity
List 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(+) … Continue reading
Posted in Uncategorized
Leave a comment
Display four digit year as tax financial academic year
This 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
Posted in Uncategorized
Leave a comment
Oracle User Group Scotland Conference 2012
My notes from the 2012 Oracle User Group Scotland Conference:
Posted in Uncategorized
Leave a comment
Documentation and Comments
Steve 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, … Continue reading
Posted in Uncategorized
Leave a comment
Oracle range limit AD BC dates
This 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 … Continue reading
Posted in Uncategorized
Leave a comment