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...

Underground Oracle FAQ's

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 Ellucian Live (formerly 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

Anything found here is provided in good faith on an as-is, use at your own risk basis, without warranty. And, of course, always test first on a non-production database. Duh!

Larry Holder
IT Administrator IV
Oracle8i Certified Professional Database Administrator (2002)
CompTIA A+ Certified Professional (2005)

My tool of choice for full-screen database access is PL/SQL Developer from Allround Automations.

Ellucian Banner

Community Source Initiative... I am currently the Co-chair (along with Kathryn Matuch of Drexel) of the Banner Technical Review Board for CSI. I was also a charter member of the Board of Directors. I submitted the "nosleep trigger" solution, baselined in General 8.3.x, as an early CSI project. CSI Initiative Award recipient in 2010 and 2012.

Ellician Live... I have served on the Program Committee, as a Banner Technical representative. I have been active in the Banner Technical track since 1998. I've also brought my guitar to help with the Sunday morning worship session since 1998.

Banner Advisory Board... I served as your member-at-large since being elected in 2005. Several years ago, the board was inactivated, around the time that SCT was acquired by SunGard.

Trigger Writing for Fun and Profit... My presentation 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.

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. It is available at in the 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". Alternatively, click here for zip file.

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.
Also note: On my system, I omit the file extension ".pl" so I only have to type the command "splitgur".

Banner upgrade step shortcuts... Click here for upgrade_shortcuts.zip, which includes several shortcut commands useful for Banner upgrades. Saves some typing time. I put ours in /usr/local/bin. For example, for the "loadmods" step, I just type the command "loadmods". (Note: one caveat, the loadmods expects just a single .dmp file to exist, with the exception of the "help" table dmp files for web products).