Home-made poster made from a composite of some magazine ads (sources long-forgotten),
and one of my Wal-Mart associate buttons (circa 1986).
Other great DBA sites...
Stephen Rea's Oracle Tips, Tricks, and Scripts Steve's website is king of the hill, compared to which my page is nothing more than a humble link to his!
April Sims' Banner/Oracle blog
When Larry's not doing DBA stuff, he's writing songs. Hear the tracks from his debut album at soundclick.com. Larry helps lead the praise songs, in cooperation with the sponsor, Taylor University, at the informal worship service held on Sunday morning at SunGard Summit.
Larry's Home Page at The University of Tennessee at Martin.
It's not just a job, it's an adventure :-)
Larry Holder's DBA Page
Larry Holder |
|
My tool of choice for full-screen database access is PL/SQL Developer from
Allround Automations.
My primary source of technical books at discount prices is
bookpool.com.
Banner from SunGard Higher Education
Community Source Initiative... As announced at Summit 2009, the Community Source initative intends to identify and incorporate some user-written stuff into baseline Banner. SunGard asked me to serve on the steering committee, as well as serve as lead on the technical review board (along with several other prominent Banner DBA's). (Yes, I've put the "nosleep triggers" into the hopper for consideration).Summit... As of Summit 2006 in Orlando, I completed 3 years of service as a Banner Technical program committee representative. I've been attending the Banner Technical track of Summit since 1998, and have been a presenter since 2002. I've also brought my guitar to help with the Sunday morning worship session since 1998.
Banner Advisory Board... I have served as your member-at-large since 2005. The present status of this board is undetermined.
Trigger Writing for Fun and Profit... My presentation from Summit 2007 (and SETA Southeast 2007), is an introduction to the very useful and interesting skill of trigger-writing. Click here for the PowerPoint. Originally presented at Summit 2006 (and SETA SE 2006), and recipient of a top presentation award for Summit 2006.
New DBA Survival Guide... My presentation, last updated for Summit 2005 (thru Banner 6.x), includes some helpful info gathered during my experiences of getting up to speed with Oracle and Banner. Click here for the PowerPoint. Received a top presentations award for Summit 2004.
Tired of Sleep/Wake? Get rid of 'em! Elegantly simple triggers can be implemented which replace the overhead and headache of many if not all of your sleep/wakes. We totally eliminated TSRSSUM, TGRMISC, and TGRRCPT sleep/wakes, and have been using this method for several years now (since 2000, Banner 4.x). The documentation and source code is freely available to SETA members, and has been added to the SETA repository at www.SETAsource.org (Product = Banner, Module = General, keyword search = triggers). The full title in the repository is "Triggers to replace Sleep/Wake".
Printing front-end simplifies Banner printing... A great printer command front-end developed by Morris Galloway Jr. of Presbyterian College. We use this as the basis for Banner printing to our HP and Lexmark laser printers. Simplifies the task of printing Banner reports in landscape, by automatically adding the proper printer control command string for orientation, print size, etc, to the beginning of the output. With a very small edit to gjajobs.shl, and minimal customization for our local setup, it has worked great for years. The original zip file has been added to the SETA repository at www.SETAsource.org (Product = Banner, Module = General, keyword search = printing). The full title in the repository is "Printing front-end for Banner on Unix server". Mentioned in my "New DBA Survival Guide", listed above, which is also included in the repository. Or click here (for original zip file plus additional examples).
Banner table reorganization made easy... splitgur (Perl) -- Reads the gurrddl1.sql file generated by gurrddl.sql and creates four files (2 scripts, 2 parm files) used in resizing Banner tables. A lot simpler and less error-prone that manually splitting the script and coming up with your own .par files for the export and import. NOTE: Banner removes the "gurrddl.sql" script in a recent release... if you need a copy of it, just send me an email. I put mine back into the Banner code tree after noticing its disappearance.
Lossy cleanup of application data after csscan... lossy_clean.zip For cleaning up lossy application (Banner) data after running a csscan, if you don't want to go from W...P1 to the Windows characterset prior to the AL32UTF8 characterset. Uses a simple function to convert any funky characters to a good character (such as the + sign). We are using this as part of our plan for doing the csalter method in preparation for Banner 8. Note that this is intended to clean up text primarily from free-format answers such as found in the online admissions tables. If you need more precise cleanup, you might decide to go ahead and do the intermediate Windows characterset conversion.