[cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug

Marshall McLuhan marshall.mcluhan at gmx.net
Tue Dec 14 22:49:06 UTC 2010


hello


No more bugs. Right now I'm rewriting the application around simple sql statements, that's why I guess.
As for the oracle setup, you did not ask and it's pretty late but maybe the following helps.

I used the instructions that can be found here: http://blog.cachemiss.com/articles/Installing%20Oracle%20XE%20on%20Debian%20AMD64.pod
Make sure you download the right files (no large files required) and don't forget to link to the server's tnsnames.ora file.

On my system, things look this way. Good luck and once more thank you.

Regards,
chris

~$ uname -a
Linux catch22 2.6.32-3-amd64 #1 SMP Wed Feb 24 18:07:42 UTC 2010 x86_64 GNU/Linux (debian)

~$ cat ~/.bashrc

..

export ORACLE_HOME=~/usr/instantclient_10_2
export XE=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
export LD_LIBRARY_PATH=~/lib:/lib:/usr/lib:/usr/local/lib:~/usr/instantclient_10_2:$XE/lib
export PATH=~/bin:~/usr/instantclient_10_2:$XE/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/bin/X11:/usr/games  
export ORACLE_USERID='chris/woirgend'
export ORACLE_DSN='dbi:Oracle:XE'
export TNS_ADMIN=~/usr/instantclient_10_2/network/admin

..

chris at catch22:~/usr/instantclient_10_2$ pwd
/home/chris/usr/instantclient_10_2


chris at catch22:~/usr/instantclient_10_2$ ls -alsh
insgesamt 109M
4,0K drwxr-xr-x  4 chris chris 4,0K  1. Nov 17:27 .
4,0K drwxr-xr-x 25 chris chris 4,0K  1. Nov 18:38 ..
4,0K -rw-r--r--  1 chris chris  228 26. Okt 20:55 BASIC_README
1,6M -r--r--r--  1 chris chris 1,6M 26. Okt 20:55 classes12.jar
   0 lrwxrwxrwx  1 chris chris   56  1. Nov 17:27 ctx -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/
 76K -rwxr-xr-x  1 chris chris  70K 26. Okt 20:55 genezi
4,0K -r--r--r--  1 chris chris 1,5K 26. Okt 20:55 glogin.sql
   0 lrwxrwxrwx  1 chris chris   57  1. Nov 17:27 ldap -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ldap/
 25M -rwxr-xr-x  1 chris chris  25M 26. Okt 20:55 libclntsh.so.10.1
7,6M -r-xr-xr-x  1 chris chris 7,5M 26. Okt 20:55 libnnz10.so
1,6M -rwxr-xr-x  1 chris chris 1,6M 26. Okt 20:55 libocci.so.10.1
 70M -rwxr-xr-x  1 chris chris  70M 26. Okt 20:55 libociei.so
152K -r-xr-xr-x  1 chris chris 147K 26. Okt 20:55 libocijdbc10.so
1,4M -r-xr-xr-x  1 chris chris 1,4M 26. Okt 20:55 libsqlplusic.so
1,3M -r-xr-xr-x  1 chris chris 1,3M 26. Okt 20:55 libsqlplus.so
4,0K -rw-r--r--  1 chris chris  140 26. Okt 20:55 linkora.sh
4,0K lrwxrwxrwx  1 chris chris   78  1. Nov 16:23 listener.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
4,0K drwxr-xr-x  3 chris chris 4,0K  1. Nov 17:27 network
1,6M -r--r--r--  1 chris chris 1,5M 26. Okt 20:55 ojdbc14.jar
4,0K drwxr-xr-x  4 chris chris 4,0K 26. Okt 20:55 sdk
4,0K -rw-r-----  1 chris chris 2,2K  1. Nov 16:21 sqlnet.log
 12K -r-xr-xr-x  1 chris chris 9,1K 26. Okt 20:55 sqlplus
4,0K -rw-r--r--  1 chris chris  232 26. Okt 20:55 SQLPLUS_README
4,0K lrwxrwxrwx  1 chris chris   78  1. Nov 16:03 tnsnames.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora


chris at catch22:~$ cat ~/code/lisp-tp/hu-dwim/hu.dwim.rdbms/source/oracle/backend.lisp
;;; -*- mode: Lisp; Syntax: Common-Lisp; -*-
;;;
;;; Copyright (c) 2006 by the authors.
;;;
;;; See LICENCE for details.

(in-package :hu.dwim.rdbms.oracle)

(cffi:define-foreign-library
    (oracle-oci :search-path
;               #P"/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/"
                #P"/home/chris/usr/instantclient_10_2/"
                )
  (:unix "libocci.so.10.1")
  (:windows "libocixe.dll")
  (t (:default "libocci"))
  )

;;;;;;
;;; Backend API

..
-----Ursprüngliche Nachricht-----
Von: Attila Lendvai <attila.lendvai at gmail.com>
Gesendet: Fr 26.11.2010 09:55
An: Marshall McLuhan <marshall.mcluhan at gmx.net>; 
CC: cl-rdbms-devel at common-lisp.net; 
Betreff: Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug

hi!

> How do I handle such thing most efficiently? Should I report them at all?

definitely, all bug reports are very welcome!

for the record, i've starred your mail, but i've failed to install
oracle in the 2 hours i'm willing to invest into oracle for now.

hopefully others could come up with suggestions, or oracle makes sure
that their monster can be installed on a 64bit ubuntu with reasonable
effort.

-- 
 attila






!DSPAM:4d07f46448583216624486!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/cl-rdbms-devel/attachments/20101214/9cde0801/attachment.html>


More information about the cl-rdbms-devel mailing list