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)

Vitaliy Mogilevskiy - Solving ORACLE problems since 1996.

View Vitaliy Mogilevskiy's profile on LinkedIn

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

  • Lokesh: Thanks for your suggestion Ashok. But the problem is I don’t have access permission to the oracle...
  • Ashok: Hi Lokesh, U need to copy the oci.dll file from the server and need to replace in the instant client folder. I...
  • Lokesh: Adding to my above post, I am using Windows 7 64-bit OS.
  • Lokesh: Hi, I have done the below steps but still getting the error “ORA-12154: TNS:could not resolve the connect...
  • Fik: Nice, thx a lot m8. You helped me a lot. BTW I wonder how can some1 publish installation like this, without some...

Categories

Blogroll


Archives