[LUGOS] SQL client za Oracle

Gregor GORJANC gregor.gorjanc at bfro.uni-lj.si
Wed Jan 5 16:08:25 CET 2005


Hvala obema za odgovore. Iztok zadeva, ki si mi jo posredoval je super. 
Majhna tako kot sem želel. Zadevo sem lepo namestil. Kako oz kje jo pa 
sedaj skonfiguriram, da se lahko povežem z bazo. Vsebina deb paketov, ki 
sem jih naredil je pripisana spodaj in nikjer mi nič ne diši po 
nastavitvah. Tudi v RPM paketih (glej še nižje) ni bilo nič (samo check, če 
bi alien kaz zamočil)

Any suggestions?

#--------------------------------------------------------------------
# rpm2deb
root at pc303 15:51:55 /home/packages !501
alien oracle-instantclient-*
oracle-instantclient-basic_10.1.0.3-2_i386.deb generated
oracle-instantclient-jdbc_10.1.0.3-2_i386.deb generated
oracle-instantclient-sqlplus_10.1.0.3-2_i386.deb generated

# Install
dpkg -i oracle-instantclient-*deb

# Configuration
# add the following line in /etc/bashrc and make sure you source it!
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/usr/lib/oracle/10.1.0.3/client/lib"

#-----------------------------------------------------------------------

dpkg -L oracle-instantclient-basic oracle-instantclient-jdbc 
oracle-instantclient-sqlplus
/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/oracle-instantclient-basic
/usr/share/doc/oracle-instantclient-basic/copyright
/usr/share/doc/oracle-instantclient-basic/changelog.Debian.gz
/usr/lib
/usr/lib/oracle
/usr/lib/oracle/10.1.0.3
/usr/lib/oracle/10.1.0.3/client
/usr/lib/oracle/10.1.0.3/client/lib
/usr/lib/oracle/10.1.0.3/client/lib/classes12.jar
/usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1
/usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
/usr/lib/oracle/10.1.0.3/client/lib/libocci.so.10.1
/usr/lib/oracle/10.1.0.3/client/lib/libociei.so
/usr/lib/oracle/10.1.0.3/client/lib/libocijdbc10.so
/usr/lib/oracle/10.1.0.3/client/lib/ojdbc14.jar

/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/oracle-instantclient-jdbc
/usr/share/doc/oracle-instantclient-jdbc/copyright
/usr/share/doc/oracle-instantclient-jdbc/changelog.Debian.gz
/usr/lib
/usr/lib/oracle
/usr/lib/oracle/10.1.0.3
/usr/lib/oracle/10.1.0.3/client
/usr/lib/oracle/10.1.0.3/client/lib
/usr/lib/oracle/10.1.0.3/client/lib/libheteroxa10.so
/usr/lib/oracle/10.1.0.3/client/lib/ocrs12.jar
/usr/lib/oracle/10.1.0.3/client/lib/orai18n.jar

/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/oracle-instantclient-sqlplus
/usr/share/doc/oracle-instantclient-sqlplus/copyright
/usr/share/doc/oracle-instantclient-sqlplus/changelog.Debian.gz
/usr/bin
/usr/lib
/usr/lib/oracle
/usr/lib/oracle/10.1.0.3
/usr/lib/oracle/10.1.0.3/client
/usr/lib/oracle/10.1.0.3/client/bin
/usr/lib/oracle/10.1.0.3/client/bin/sqlplus
/usr/lib/oracle/10.1.0.3/client/lib
/usr/lib/oracle/10.1.0.3/client/lib/glogin.sql
/usr/lib/oracle/10.1.0.3/client/lib/libsqlplus.so
/usr/bin/sqlplus

# rpm -qil -p oracle-instantclient-*rpm
Name        : oracle-instantclient-basic   Relocations: (not relocateable)
Version     : 10.1.0.3                          Vendor: Oracle Corporation
Release     : 1                             Build Date: Thu Dec  2 21:04:20 
2004
Install date: (not installed)               Build Host: ca-build1.us.oracle.com
Group       : Applications/File             Source RPM: 
oracle-instantclient-10.1.0.3-1.src.rpm
Size        : 85645640                         License: Oracle
Packager    : Nobody <nobody at oracle.com>
URL         : http://www.oracle.com/
Summary     : Instant Client for Oracle Database 10g.
Description :
Base files for Instant Client.  Support for OCI, OCCI, and JDBC-OCI 
applications.
/usr/lib/oracle/10.1.0.3/client/lib/classes12.jar
/usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1
/usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
/usr/lib/oracle/10.1.0.3/client/lib/libocci.so.10.1
/usr/lib/oracle/10.1.0.3/client/lib/libociei.so
/usr/lib/oracle/10.1.0.3/client/lib/libocijdbc10.so
/usr/lib/oracle/10.1.0.3/client/lib/ojdbc14.jar

Name        : oracle-instantclient-jdbc    Relocations: (not relocateable)
Version     : 10.1.0.3                          Vendor: Oracle Corporation
Release     : 1                             Build Date: Thu Dec  2 21:04:20 
2004
Install date: (not installed)               Build Host: ca-build1.us.oracle.com
Group       : Applications/File             Source RPM: 
oracle-instantclient-10.1.0.3-1.src.rpm
Size        : 5100751                          License: Oracle
Packager    : Nobody <nobody at oracle.com>
URL         : http://www.oracle.com/
Summary     : Supplemental JDBC features under Instant Client.
Description :
Additional support for XA, Internationalization, and RowSet operations 
under JDBC.
/usr/lib/oracle/10.1.0.3/client/lib/libheteroxa10.so
/usr/lib/oracle/10.1.0.3/client/lib/ocrs12.jar
/usr/lib/oracle/10.1.0.3/client/lib/orai18n.jar

Name        : oracle-instantclient-sqlplus  Relocations: (not relocateable)
Version     : 10.1.0.3                          Vendor: Oracle Corporation
Release     : 1                             Build Date: Thu Dec  2 21:04:20 
2004
Install date: (not installed)               Build Host: ca-build1.us.oracle.com
Group       : Applications/File             Source RPM: 
oracle-instantclient-10.1.0.3-1.src.rpm
Size        : 767675                           License: Oracle
Packager    : Nobody <nobody at oracle.com>
URL         : http://www.oracle.com/
Summary     : SQL*Plus for Instant Client.
Description :
Additional libraries and executable for running SQL*Plus with Instant Client.
/usr/bin/sqlplus
/usr/lib/oracle/10.1.0.3/client/bin/sqlplus
/usr/lib/oracle/10.1.0.3/client/lib/glogin.sql
/usr/lib/oracle/10.1.0.3/client/lib/libsqlplus.so

Iztok Umek wrote:
> 
> ----- Original Message ----- From: "Gregor GORJANC" 
> <gregor.gorjanc at bfro.uni-lj.si>
> To: <lugos-list at lugos.si>
> Sent: Wednesday, January 05, 2005 12:07 PM
> Subject: [LUGOS] SQL client za Oracle
> 
> 
>> Zdravo!
>>
>> Ali mi lahko kdo pove kaj za eno aplikacijo moram sneti z oraclovih 
>> strani, da bi dobil SQL client za Linux, za dostop do oracle baze pod 
>> windowsi. Spodaj je izpis iz SQL clienta po windowsi. Sem že malo 
>> gledal po spletnih straneh oracla, pa je vse tako glomazno veliko in 
>> nič kaj jasno. Ali je možno sploh dobiti samo clienta? Ima mogoče kdo 
>> kaj izkušenj z ODBC?
> 
> 
> http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
> 
> 
> 
> 
> 
> _______________________________________________
> lugos-list mailing list
> lugos-list at lugos.si
> http://liste2.lugos.si/cgi-bin/mailman/listinfo/lugos-list
> 

-- 
Lep pozdrav / With regards,
     Gregor GORJANC

---------------------------------------------------------------
University of Ljubljana
Biotechnical Faculty       URI: http://www.bfro.uni-lj.si
Zootechnical Department    mail: gregor.gorjanc <at> bfro.uni-lj.si
Groblje 3                  tel: +386 (0)1 72 17 861
SI-1230 Domzale            fax: +386 (0)1 72 17 888
Slovenia
---------------------------------------------------------------


More information about the lugos-list mailing list