A free open-source Oracle administration tool. #Oracle administration #Database frontend #Database administration #DBA #Companion #Oracle
DBA Companion is a free open-source Oracle administration tool.
I am building this tool for my own needs. This means, it does not necessarily contain all the information you can extract from an Oracle database nor all the information that *you* may require.
Set LD_LIBRARY_PATH (SHLIB_PATH on HP) to point to $ORACLE_HOME/lib and the QT library directory. Also set DBACOMP_INI to the dbacomp.ini file (with the full path).
E.g.: DBACOMP_INI=/usr/local/dbacomp/dbacomp.ini.
Open dbacomp.ini and set the variables 'sql_cache_file', 'sql_generation' and 'user_sql'.
sql_cache_file_prefix: Tells DBAComp where to find the SQL statements files.
These files contain all the SQL that DBAComp uses (see later). The prefix comprises the full path plus the common beginning of the name of the file.
sql_generation: The directory where you want DBAComp to store the SQL
scripts that you may generate with it.
user_sql: Indicates the location of the file that contains the
user's *own* SQL statements (for more details see below).
'sql_cache_file_prefix' and 'user_sql' must be set to the fully qualified file name. By default the files are called user.sql and dbacomp.
Example: sql_cache_file_prefix=/opt/dbacomp/dbacomp
user_sql=/opt/dbacomp/user.sql
If you don't set any of these variables (DBACOMP_INI, sql_cache_file_prefix, user_sql), DBAComp will look for these files in the local directory (i.e. the directory where you have started DBAComp from) using the default names.
Now start the program by typing ./dbacomp.
Logon and ENJOY!
BTW: You can also start dbacomp with the username/password[@tnsalias] on the command line (i.e.: ./dbacomp scott/tiger@orcl). Also OPS$ (automatic) logons are supported (e.g. ./dbacomp / or ./dbacomp /@orcl).
What's new in DBA Companion 1.7:
- This version is based on Qt4 and Qwt 5.2.1.
- The main new features are Active Session History (ASH) and Automatic Storage Management (ASM).
- There are numerous small additions and improvements.
DBA Companion 1.7
add to watchlist add to download basket send us an update REPORT- runs on:
- Linux
- main category:
- Database
- developer:
- visit homepage
Zoom Client 6.0.3.37634
Bitdefender Antivirus Free 27.0.35.146
7-Zip 23.01 / 24.04 Beta
ShareX 16.0.1
4k Video Downloader 1.5.3.0080 Plus / 4.30.0.5655
Context Menu Manager 3.3.3.1
Microsoft Teams 24060.3102.2733.5911 Home / 1.7.00.7956 Work
IrfanView 4.67
Windows Sandbox Launcher 1.0.0
calibre 7.9.0
- IrfanView
- Windows Sandbox Launcher
- calibre
- Zoom Client
- Bitdefender Antivirus Free
- 7-Zip
- ShareX
- 4k Video Downloader
- Context Menu Manager
- Microsoft Teams