[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