DBA tools

Free tools that run in your browser: error lookup, parameter reference, connection strings, capacity planning, RMAN, Data Pump and scheduler jobs.

Look up

• Oracle error lookupWhat an ORA- error means and what to run next
• Init parameter referenceWhat a parameter does and the right way to change it

Connect

• Connection string builderEZConnect, tnsnames.ora, JDBC, psql, sqlcmd and more

Plan capacity

• Tablespace runway and datafilesDays until full, and the statements to add space
• Redo log sizingSize online and standby redo logs from your peak redo rate

Back up & recover

• RMAN command builderBackup, validate, clean-up and restore scripts

Move data

• Data Pump command builderexpdp and impdp parameter files, with remaps

Schedule

• Scheduler job builderDBMS_SCHEDULER job and the matching crontab line

Test & verify

• Script test packRun every read-only script at once and find the failures