DBAToolZ

Lightweight Oracle DBA Tools

 

SQLDIR

SQLDIR — One stop sqlplus script management utility for Oracle:

  • Sql scripts reside on OS file system (UNIX, WINDOWS)
  • They are organized into categories using special tags embedded into each script (very simple like html)
  • SQLDIR parser scans them into searchable repository
  • Access scripts right from sqlplus using user friendly menu (character based for hardcore telnet users)
  • True tool for hardcore Oracle DBA that relies on sqlplus rather then GUI tools because sqlplus is always there
  • Parser is written in C making it very fast
  • Organize just about any sqlplus script (adhoc reporting …)
  • New scripts are easily added to repository and automatically parsed for description tag and category tag (set up a cron job and all new scripts will be at the tip of your finger momentarily)
  • Repository is saved as sqlplus script which makes it portable take it anywhere and have it up and running in seconds perfect for all you road warriors out there … I should know – I was in consulting for years.

Download SQLDIR (C SOURCE Code is included)


My name is Vitaliy Mogilevskiy -- I started working with ORACLE Products in 1996 (Oracle v7, 7.3.4 was pretty good).

What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.

Do you have DBA questions? Head over to Ask DBA.

RSS DBA Forums


Recent Comments

  • Hans Forbrich: Douglas – your comment about ASM after Clusterware was true for 11gR1 and older. With 11g...
  • gurpreet: thanks…..
  • MVE: According to the 11gR2 documentation — “OCR and voting disk files can be placed either on ASM, or on...
  • Douglas: Dude, You can’t put the OCR and vote/quorum devices in ASM… Clusterware must be up before ASM,...
  • Craig: Easy to understand -as an Oracle newbie it was very usefull.Thx I followed your tutorial and I’m...

Categories

Blogroll


Archives