Wicked picture of the Canadian flag and the Pacific Ocean with some islands.
News Flash     1 2 3 Next

2010-10-22 15:00:20   -- I am now officially a member of a band! My band is called Multiple Partners and you can listen to the best music you have ever heard here --> http://radio3.cbc.ca/bands/Multiple-Partners

I sing and play guitar mostly.

2010-04-14 15:21:14   -- For anyone interested in guitar and computers this could be the Holy Grail...MISA Digital Guitar (Link to their YouTube channel). Here is a link to their website as well...http://www.misadigital.com/. That thing looks and sounds pretty sick. Plus, imagine being able to SSH into your guitar! That could be the wave of the future.

2009-06-06 14:05:22   -- Oracle Enterprise Manager. A great addition to the Oracle database software suite and full of some great tools. But like any new piece of software there are always little problems. Two common ones for EM that I have recently found answers to are:

1. After changing the port for the database listener from the standard 1521 to another port, the Enterprise Manager console will no longer be able to connect to the database past the initial login / status screen. This problem is fixed using the "emca" tool. This tool is the command line version of the Enterprise Manager Configuration Assistant. The easiest way to get around the problem with the port is to drop and recreate the repository for EM. This is done by first issuing the "emca -deconfig dbcontrol db -repos drop" command. The next thing is to recreate the repository with the "emca dbcontrol db -repos create" command. You can use the "emca dbcontrol db -PORT " command to change the port, but I have had limited success with this method and it seems to choke sometimes.
2. The next problem is minor but still a pain in the ass. It deals with securing the EM console so that it is only accessible over SSL. This is done by using the "emctl secure dbconsole" command. The thing to watch for here is that you do not issue this command while the EM console is already running. If you do, you will continually receive an error message after logging into EM saying that the connection to the database has been reset. Be sure to stop the dbconsole with "emctl stop dbconsole" first.

One of my favorite tools in the EM console is the performance graphing and Top SQL statements listing. This gives you the ability to see real-time graphs of the most executed SQL statements as well as the top user sessions and other useful metrics. This can be helpful in diagnosing performance problems that can arise from queries that have not been tuned such as queries that require full table scans etc.

Another thing I have been playing with in Oracle is watching the SQL statements by selecting from the v$sql view. This view allows you to watch currently running SQL statements and filter by time, user, etc. Pretty handy for watching SQL statements that are generated from objects such as from Hibernate.

2009-05-31 13:15:43   -- Here's a link to a nice article on Circular Replication in MySQL on the O'Reilly website.

2007-05-07 14:10:31   -- Just got mod_security up and running on my new box. Couple of little issues along the way but nothing too bad. While compiling I was getting an error that the Makefile could not find special.mk. This was fixed by installing httpd-devel.x86_64. Then I was getting an error that I didn't have the pcre libraries installed. Fixed that by installing pcre.x86_64 and pcre-devel.x86_64. Then I getting an unknown symbol error (xmlFree) as the server was loading the module. That was fixed by installing the latest version of libxml2-devel.x86_64.


Blogidy News Blog     1 2 3 Next

More ...stuff, here soon.   All in good time.

 

 

 

Campfire sing along.

Copyright 2005 Kevin O'Brien


54.224.214.93->-> Visitor Addresses Are Recorded

JS Menu

Tech_Notes