DBCP: database connection pooling (service)


“Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

Why is this: (why not “.so.10.2“?): ./usr/lib/oracle/ ./usr/lib/oracle/ ./usr/lib/oracle/ -> libclntsh.so.10.1 ./usr/lib/oracle/ -> libocci.so.10.1 ./usr/lib/oracle/ (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 (why not “.so.12.2“?): ./usr/lib/oracle/12.2/client64/lib/libocci.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so -> libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so -> libclntsh.so.12.1… Continue reading “Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

Perl’s DBD::Oracle vs Debian

https://metacpan.org/pod/DBD::Oracle https://metacpan.org/release/DBD-Oracle For accessing an Oracle DB server from a client computer (w/o its own Oracle DB server installation) you need “Oracle Instant Client” (a set of packages of installables for various computer architectures, supplied by Oracle for free): http://www.oracle.com/technetwork/database/database-technologies/instant-client/ You won’t find Oracle Instant Client for Debian (outside your organisation or company), but …:… Continue reading Perl’s DBD::Oracle vs Debian

“Oracle Instant Client” vs Debian (resp. Ubuntu)

http://www.oracle.com/technetwork/database/database-technologies/instant-client/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/ Of course “Oracle Instant Client” is closed source, does not comply with Debian rules, and cannot / may not be distributed through Debian channels. Oracle supplies RPM files for “Linux x86-64” but no “.deb” files. And presumably both Oracle and also the “Debian Project” disallow redistribution of “Oracle Instant Client” components as Debian… Continue reading “Oracle Instant Client” vs Debian (resp. Ubuntu)

how to create a Debian package from an RPM package? “rpm2deb”

I moved the content to a wiki article, so this article is a little obsolete. https://en.wikipedia.org/wiki/Rpm_(software) https://en.wikipedia.org/wiki/Alien_(software) https://www.howtoforge.com/converting_rpm_to_deb_with_alien : alien -k … https://salsa.debian.org/perl-team/modules/packages/libdbd-oracle-perl/blob/master/debian/README Open questions: how to deal with dependencies specified within the RPM package? …

how can I create a copy of an Oracle table without copying the data?

https://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data#233890 create table xyz_new as select * from xyz where rownum < 0; In Oracle SQL Developer use the menu-function (maybe right-click) on the table you want to operate on (i.e. that you want to copy), “Table“, “Copy…“, w/o checking “Include Data“.

Oracle SQL Developer – how to run it on Windows in English w/o admin rights?

https://stackoverflow.com/questions/7768313/how-can-i-change-the-language-to-english-in-oracle-sql-developer https://stackoverflow.com/a/24532448/3119172 I chose the approach “set language at runtime“: sqldeveloper.exe –AddVMOption=-Duser.language=en Works like a charm. On the Win7 PC at work I have no admin rights, therefore I cannot change the config file mentioned in the thread.