I had to provide access to an Oracle database but the standard port at 1521 was hindered by company firewall and company proxy rules.
In previous times there was iSQL*Plus, but this product no longer seems to be available. I found Adminer as an alternative. It is written by Jakub Vrána. It is very easy to install: it is just one single PHP file consisting of less than 2000 lines. Originally made for MySQL/MariaDB, but it works for Oracle quite well. It provides access to tables and views, although it has problems editing PL/SQL procedures and triggers. It is termed as beta software for Oracle. Nevertheless, I found it to be very useful for Oracle.
To use one must add one file
Additional .ini files parsed => /etc/php/conf.d/oci8.ini oci8 OCI8 Support => enabled OCI8 DTrace Support => disabled OCI8 Version => 2.1.8 Revision => $Id: 8a26cf66ca0f9556b6376408c8f71ead69bdbcbf $ Oracle Run-time Client Library Version => 184.108.40.206.0 Oracle Compile-time Instant Client Version => 12.2 Directive => Local Value => Master Value oci8.connection_class => no value => no value oci8.default_prefetch => 100 => 100 oci8.events => Off => Off oci8.max_persistent => -1 => -1 oci8.old_oci_close_semantics => Off => Off oci8.persistent_timeout => -1 => -1 oci8.ping_interval => 60 => 60 oci8.privileged_connect => Off => Off oci8.statement_cache_size => 20 => 20
If you encounter “URI too long” error messages, then downgrade to version 4.6.3, see Adminer releases. Latest version 4.7.0 still seems to be unstable, while 4.6.3 is fine.