perfstat/perfstat, OScanner reveals them all

Unfortunately, creating database accounts like “create user test identified by test” is common practice. Leaving default accounts with default passwords open is as common too. OScanner reveals those weak points mercilessly.

Oracle Scanner 1.0.6 by patrik@cqure.net
————————————————–
[-] Checking host 120.23.45.104
[-] Checking sid (t432) for common passwords
[x] Got IO Exception
[-] Checking sid (t433) for common [...]

Oracle Remote Diagnostic Agent (RDA)

Oracle Remote Diagnostic Agent is a great tool to collect detailed information about an oracle database and its environment. It’s not only a great tool for troubleshooting but also very helpful for documenting an Oracle environment, for example after installation, production start, etc.

Installing and configuring RDA takes a few easy steps. Installation and configuration is [...]

Creating an ERD of an Existing Oracle Database With DB Designer 4

Today I was asked to prepare an ERD of an existing Oracle Database for a meeting. Forces DB Designer 4 was the tool of my choice. Although it’s written for MySQL (and there weren’t any bugfixes or releases since long time), some features work fine with Oracle too.
To get an ERD do the following.
“Reverse Engineering”
Open [...]

PsExec - Run Programm on Remote Computer (Windows)

On 1st of April there will be elections in Lucerne. We are responsible for the application as well as for server infrastructure and redundancy of the whole solution. It’s a very important project for the public administration of Lucerne (which I work for). One important part of the project is to publish provisional election results [...]

DB Designer 4

DB Designer 4, an open source DB design tool developed by fabFORCE.net, compares according to their website with tools like Erwin, Rational Rose and Oracle Designer.

For MySQL databases this is true. In conjunction with Oracle, DB Designer 4 still has some shortcomings. For example it is not possible to select “Oracle” as the default database [...]