All posts in 'Oracle'

Oracle XE environment variables on Linux

04-Jun-08

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/oracle_env.sh 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 »

Feeling dizzy…

26-Mar-08

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 »

Notes on RedHat / Oracle Enterprise Linux, ADS und Samba

17-Jan-08

Recently i needed windows clients to access a directory on the database server from which CLOBs where created. Since the server is an Oracle Enterprise Linux, i could follow the steps explained behind the following link to get Samba up and running with the Active Directory run by a Windows 2k3 server: Which steps must […]

Read the complete article »

Oracle 11g: Default case-sensitive passwords

08-Jan-08

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 »