All posts tagged with 'Oracle DB'

Oracle XE environment variables on Linux


Just a quick reminder for myself: With the default installation of an Oracle Express (Oracle XE) comes two shell script with all the necessary environment variables to use sql*plus, exp, imp and the like on the command line: source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.shsource /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ respectively source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.cshsource /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.csh

Read the complete article »

JDBC: Autogenerated keys revisited.


Some months ago i wrote about retrieving auto generated values with JDBC from an Oracle Database: JDBC: Get autogenerated keys on a Oracle DB. The solution i presented in the previous article doesn’t run in a Oracle Java Stored Procedure. To accomplish this, use a callable statement like this: final String sql = "BEGIN INSERT […]

Read the complete article »

Feeling dizzy…


After staring at this for about a day in various rotations and flips just to get Oracle GeoRaster work together with a homebrew GIS like application made me feel somewhat dizzy. To be cartesian or not cartesian, that is the question 😉 Otherwise, Oracle GeoRaster works quite well, at least for that bunch of german […]

Read the complete article »

Oracle 11g: Default case-sensitive passwords


ORA-01017: invalid username/password; logon denied Yiipiee… Although i created my schema with the usually scripts we use, i got a logon denied… Switching context from Oracle Forms 6 to Reports 6… (Please, don’t say anything about legacy apps). I didn’t notify that passwords are now case-sensitive in a Oracle database (which is a good thing), […]

Read the complete article »

Installing Oracle 11g Database on OEL5


As a last post in the series (1, 2, 3, 4): Installing the latest and greatest incarnation of the Oracle Database named “Oracle 11g” on Oracle Enterprise Linux 5 running as a paravirtualized machine on Oracle VM Server. Honestly, i was afraid of installing Oracle the first time under a linux environment but i must […]

Read the complete article »