Category: Oracle DB
-
DBCP: database connection pooling (service)
https://en.wikipedia.org/wiki/Apache_Commons http://commons.apache.org/proper/commons-dbcp/ — this one lists (most of) the following links: http://commons.apache.org/proper/commons-dbcp/apidocs/ http://commons.apache.org/proper/commons-dbcp/apidocs/org/apache/commons/dbcp2/package-summary.html#package_description https://git-wip-us.apache.org/repos/asf?p=commons-dbcp.git https://git-wip-us.apache.org/repos/asf?p=commons-dbcp.git;a=tree;f=doc;hb=refs/heads/master — examples Tomcat: https://tomcat.apache.org/tomcat-8.0-doc/jndi-datasource-examples-howto.html http://commons.apache.org/proper/commons-dbcp/configuration.html
-
Oracle DB as VirtualBox appliance (2017-06-14 update)
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html If you already are VirtualBox-minded, this is a very nice approach to get Oracle DB running.
-
“Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?
Why is this: 10.2.0.5 (why not “.so.10.2“?): ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so -> libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so -> libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client/lib/libsqora.so.10.1 11.2.0.2.0 (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 11.2.0.4.0 (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 12.2.0.1.0 (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…
-
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 …:…
-
“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…
-
Oracle Instant Client: “free, light-weight, and easily installed Oracle Database tools, libraries and SDKs for building and connecting applications to an Oracle Database instance”
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/
-
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? …
-
Oracle SQL scripts: how to use a variable for the table name
https://stackoverflow.com/questions/1179652/how-to-use-a-variable-in-oracle-script-for-the-table-name There is a “test table” and there is a “serious table” – use a variable name for the table(s) in question!
-
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.