http://www.hpfuchs.com Notes of a Junior on the Path to Oracle Mastery Sun, 23 Mar 2008 07:46:48 +0000 http://backend.userland.com/rss092 en 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 [-] ... http://www.hpfuchs.com/2008/03/18/perfstatperfstat-oscanner-reveals-them-all/ 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 ... http://www.hpfuchs.com/2008/03/11/oracle-remote-diagnostic-agent-rda/ Today is one of the first days at my new employer Abraxas. Everything is quite new to me. Servers and databases are not yet familiar. I must get an overview. At the previous site I was tracking all servers and databases in an Excel sheet. This list of databases proved ... http://www.hpfuchs.com/2008/02/10/list-of-databases/ This post is for my friend Gerry, who - as a newby to Oracle - has to support a replicated environment. Gerry is my successor at Kanton Luzern. Management didn't look for a new DBA because they said it's hopeless to find somebody. Instead they decided to give somebody inhouse ... http://www.hpfuchs.com/2008/02/06/materialized-view-replication/ On my current job I manage 111 databases on 28 servers. Some are mid size and clustered but most of them are quite tiny. My predecessor created databases for every customer and application, and test databases for all production databases. That means a good deal of those 111 databases aren't ... http://www.hpfuchs.com/2008/01/02/people-say-database-when-they-mean-schema/ The last six years I was working as an Oracle & SQL Server DBA for the public administration of canton Lucerne in the heart of Switzerland. Besides the DBA role I was also maintaining a few database centric .NET applications. The public administration of canton Luzern committed to Microsoft products ... http://www.hpfuchs.com/2008/01/01/new-job-at-abraxas/ Static Data Dictionary Views and Dynamic Performance Views are the core of database administration. They are of crucial importance. Whoever wants to learn Oracle database administration has to get familiar with these views. I began to compile a list of most important Static Data Dictionary Views here. There are hundreds ... http://www.hpfuchs.com/2007/12/21/static-data-dictionary-views/ On my Windows 2003 test server I install and remove a lot of Oracle and SQL Server software. I create and drop databases a lot. Usually I work in a rush on that server, so removing instances and software isn't always so clean. Sometimes a windows services sticks and cannot ... http://www.hpfuchs.com/2007/12/07/how-to-delete-windows-service/ Oracle 11g linux x86 is now available for download. Product documentation can be found here. And here's an overview of 11g new features. http://www.hpfuchs.com/2007/08/16/oracle-11g-available-for-download/ Today I downloaded and installed the latest SQL Server 2008 Community Technical Preview from connect.microsoft.com. Downloading the preview requires you to sign up for Microsoft Connect which is free of charge. SQL Server 2008 is scheduled for release by early 2008. We run 26 databases on a SQL Server 2000 machine for ... http://www.hpfuchs.com/2007/08/10/is-the-market-ready-for-sql-server-2008/