While trying to install Ruby on Rails in Fedora Core 19, I ran into some errors with the ‘gem install rails’ command. [mark@localhost ~]$ gem install rails Fetching: i18n-0.6.9.gem (100%) Successfully installed i18n-0.6.9 Fetching: multi_json-1.8.2.gem (100%) Successfully installed multi_json-1.8.2 Fetching: tzinfo-0.3.38.gem (100%) Successfully installed tzinfo-0.3.38 Fetching: minitest-4.7.5.gem (100%) Successfully installed minitest-4.7.5 Fetching: atomic-1.1.14.gem (100%) Building native extensions. This could take a while… ERROR: Error installing rails: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb […]
Selective Oracle Logon Trigger for Auditing
The Oracle logon trigger can be a very powerful tool for recording who or what is accessing your database. However, you may not need to know when every user or every host or even a specific application logs into Oracle. The following trigger shows one possibility for selectively auditing user logons.
ORA-28221: REPLACE not specified
I came across a problem today in which a user could not reset her password without getting the “ORA-28221: REPLACE not specified” error. The correct “alter user” syntax to resolve this error is: alter user USERNAME identified by NewPassword replace OldPassword;
Learning to Love Railo
I have used the official ColdFusion since 1997 when it was owned by the Allaire brothers. I used it when Macromedia owned it. I used it when Adobe owned it. I have also used Open Blue Dragon and now I have used Railo. Given the price comparison, Railo is so far my favorite flavor of ColdFusion. Here’s a few reasons why and a small datasource IsItUp script.
Create Table DDL from Oracle to MS-SQL
So you want to create some tables in Microsoft SQL based on tables that exist in Oracle? The Microsoft SQL Migration Assistant (MSSMA) can help, but it’s a bit tedious and if you have triggers on your tables, MSSMA will create rowid columns in SQL that don’t really exist in Oracle except as pseudo-columns used to indicate where data is stored in a file on disk which is subject to change. I will cover a […]