Etiketa: oracle

debian / python: sqlalchemy -gaz oracle -ra konekta

Paketiek instala: su aptitude install python-sqlalchemy alien libaio1 exit Jakitzeko ze bertsiño dakun python-ena: python -V erantzune: Python 2.7.2+ Jakitzeko oracle-n bertsiñue: select * from product_component_version; erantzune: NLSRTL                                  11.2.0.2.0 Production Oracle Database 11g Enterprise Edition  11.2.0.2.0 64bit Production PL/SQL                                  11.2.0.2.0 Production TNS for 64-bit Windows:                 11.2.0.2.0 Production Nire kasuen: python 2.7 eta oracle 11.2 Orduen […]

debian: php oracle-ntzako pdo modulue instala

Bueno ba goiz guztidxe ogon dast hau popatik emoten baie azkanien atara dot, guzan ba: 1.go gauzie okinbidena kontuten, non dakozuien oracle instalata, dana dala hau post-a elegante etorko datzuie: php + oci8 Oracle bezero (kliente) moduen imintzeko gnu/linux-en Neure kasuen: /opt/oracle-instantclient-11-2 karpetan dakot dana. ls -l /opt/oracle-instantclient-11-2 -rwxr-xr-x 1 zital zital 25588 abu 15 […]

Karaktere kodifikaziñue: apache2.2 + oracle + UTF8

1.- Jakin ze kodifikaziñotan dauen oracle: SELECT * FROM NLS_DATABASE_PARAMETERS; eta NLS_LANGUAGE, NLS_TERRITORY, NLS_CHARACTERSET balidxuek hartun, adibidez: AMERICAN, AMERICA, AL32UTF8 2.- apache-n dagokidxon karaktere kodifikaziñue imiñi: echo “export NLS_LANG=’AMERICAN_AMERICA.AL32UTF8′” >> /etc/apache2/envvars /etc/init.d/apache restart Eskerrak: http://www.errcode.net/blogs/?p=6

tora oracle-gaz konpile archlinux-en

Tora bajateko: wget http://downloads.sourceforge.net/project/tora/tora/2.1.3/tora-2.1.3.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Ftora%2Ffiles%2Ftora%2F2.1.3%2F&ts=1301064772&use_mirror=kent Izen raro bategaz bajaten batzuien neuri pasa daztelez: mv tora-2.1.3.tar.gz\?r\=http\:%2F%2Fsourceforge.net%2Fprojects%2Ftora%2Ffiles%2Ftora%2F2.1.3%2F tora-2.1.3.tar.gz tar -zxvf tora-2.1.3.tar.gz cd tora-2.1.3 ./configure –with-oracle=/opt/oracle-instantclient-11-2 \ –with-oracle-libraries=/opt/oracle-instantclient-11-2 \ –with-instant-client=/opt/oracle-instantclient-11-2 \ –with-oracle-libraries=/opt/oracle-instantclient-11-2 \ –with-oci-version=11G \ –with-qt-dir=/usr/share/qt \ –libdir=/usr/lib make clean make Nire kasuen “/opt/oracle-instantclient-11-2” karpetan dakot dana :) 1go errorie: /src/toawr.h:57: undefined reference to `toAWR::staticMetaObject’ Konponduteko: tora-2.1.3/src/Makefile.am topa: BUILT_SOURCES […]

CodeIgniter datu basiekaz konekta: oracle eta mysql

database.php … $active_group = “default”; $active_record = TRUE; $db[‘oracle’][‘hostname’] = ‘(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = DATUBASIEN_IZENA)))’; $db[‘oracle’][‘username’] = “ERABILTZAILEA”; $db[‘oracle’][‘password’] = “PASAHITZA”; $db[‘oracle’][‘database’] = “”; $db[‘oracle’][‘dbdriver’] = “oci8”; $db[‘oracle’][‘dbprefix’] = “”; $db[‘oracle’][‘pconnect’] = TRUE; $db[‘oracle’][‘db_debug’] = TRUE; $db[‘oracle’][‘cache_on’] = FALSE; $db[‘oracle’][‘cachedir’] = “”; //$db[‘oracle’][‘char_set’] = “utf8”; […]