Blog
-
SQLite vs Oracle SQL Developer – nope?!?
- https://en.wikipedia.org/wiki/SQLite
- https://en.wikipedia.org/wiki/Oracle_SQL_Developer
- http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html
- http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html
- https://stackoverflow.com/questions/1525444/how-to-connect-sqlite-with-java
- https://bitbucket.org/xerial/sqlite-jdbc/downloads/
(Looks like) SQL Developer is no longer able to interface with as many RDBMSs as explained in its list.
-
Oracle DB as VirtualBox appliance (2017-06-14 update)
If you already are VirtualBox-minded, this is a very nice approach to get Oracle DB running.
-
in the middle of upgrading a WordPress plugin I exceeded my disk quota and I only saw “HTTP ERROR 500” from then on
Before I started upgrading that WordPress plugin I did not actually notice, that I exceeded my disk quota. Well, sh*t happens.
Once I was able to think clearly again, I wondered which files I could easily get rid of. WordPress backups. I saved my (recent) WordPress backups over to my NAS immediately (I do have a Rakefile entry for that), and I removed the WordPress backups on my WordPress host. Now there was enough space to “breathe” again sufficiently.
$ cd .../wp/wp-content/plugins $ mkdir tmp $ mv THE_CORRUPT_PLUGIN tmp/ # from here on your "HTTP ERROR 500" should be gone already # and your plugin appears as inactive on the plugins dashboard. $ cd tmp/ $ wget FRESH_VERSION_OF_THE_CORRUPT_PLUGIN.tar.gz $ tar xtf FRESH_VERSION_OF_THE_CORRUPT_PLUGIN.tar.gz $ cd .. $ mv tmp/FRESH_VERSION_OF_THE_CORRUPT_PLUGIN . # re-activate your plugin on the plugins dashboard!
…
-
“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
- ./usr/lib/oracle/12.2/client64/lib/libocci.so -> libocci.so.12.1
- ./usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1
The “.so.X.1” links even get described here:
-
Debian: network install from a minimal CD
- https://www.debian.org/CD/netinst/
- https://www.debian.org/doc/manuals/debian-faq/ch-choosing.en.html#s3.1.11 – “I am currently tracking stable. Can I change to testing or unstable? If so, how?“
-
Perl’s DBD::Oracle vs Debian
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):
You won’t find Oracle Instant Client for Debian (outside your organisation or company), but …:
I.e. before installing DBD::Oracle these components of Oracle Instant Client must already be installed:
- basic resp. basiclite
- devel
- sqlplus
How to install DBD::Oracle?
- the “CPAN way” using a C compiler (gcc) etc
- as a readymade OS (i.e. Debian) package
Of course there are organisational reasons, that enforce the installation as readymade OS package.
DBD::Oracle for Debian is named libdbd-oracle-perl, here you find for which Debian version it is available and a lot more details:
If you are using a version of Debian like Jessie, that is not listed there, i.e. your version of Debian is not supported, you may want to create your own libdbd-oracle-perl through backporting the Debian Sid “source package components”.
This certainly involves using a C compiler (gcc) etc, but it in the end it creates a Debian package, that you can distribute within your organisation (resp. company).
How to retrieve the source package?
Retrieving the source package, the “dget” approach (preferred): go to the versioned links section, choose the .dsc link for the latest version, use dget on it, as suggested by the hint popping up, while you hover over the .dsc link.
Retrieving the source package, the “if using dget failed” approach: go to the general / source link:
Choose the sid link:
Download the 3 files listed there:
*.dsc*.orig.tar.**.debian.tar.*
Run this command line on the .dsc file downloaded right before:
$ dpkg-source --extract libdbd-oracle-perl_VERSION.dscThis created a source tree.
You will now adapt the source tree to your needs (if necessary). Maybe
dpkg-buildpackagewill make you return to this phase.Quite possibly you can now just run the next step within that source tree:
$ dpkg-buildpackage --build=any,all --unsigned-source --unsigned-changesresp.:
$ dpkg-buildpackage -b -us -ucCongratulations, you created your own
libdbd-oracle-perl_*.deb.- a Debianized Perl CPAN package: backporting from Debian Sid (a related article of mine)
-
“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 packages.
If you still need “Oracle Instant Client” components as Debian packages, converting RPM to “.deb” using “alien” together with “fakeroot” (instead of sudo) works quite straight forward — you may want to have a look here:
- https://salsa.debian.org/perl-team/modules/packages/libdbd-oracle-perl/blob/master/debian/README (using alien and fakeroot)
- https://en.wikipedia.org/wiki/Alien_(software)
- https://www.howtoforge.com/converting_rpm_to_deb_with_alien
- …/?title=Debian_package_management#rpm2deb — my wiki article somewhere …
- (obsolete: http://Jochen.Hayek.name/wp/blog-en/2018/04/13/rpm2deb — superseded by my wiki article)
- https://dba.stackexchange.com/questions/36609/how-to-install-configure-oracle-instant-client-on-ubuntu#36610
- https://github.com/eikonomega/oracle_instant_client_for_ubuntu_64bit – encapsulates the “alien” calls for you — I personally prefer to see how “alien” gets called exactly on the command line
- https://help.ubuntu.com/community/Oracle%20Instant%20Client
fakeroot vs sudo: