-1

currently I can access a database on a remote server using Oracle's instant client "sqlplus"

The connection is dependent on a couple of configuration files in: $ORACLE_HOME/network/admin which are called sqlnet.ora and ldap.ora

The ldap.ora file has contents of:

DEFAULT_ADMIN_CONTEXT="<an ldap path>"
DIRECTORY_SERVERS=(<host1>:<port1>,<host2>:<port2>)
DIRECTORY_SERVER_TYPE=OID

the sqlnet.ora file has entries of:

NAMES.DEFAULT_DOMAIN=<same path as ldap path above but as a url>
NAMES.DIRECTORY_PATH=(LDAP, TNSNAMES)

I would like to be able to connect with mariadb client instead of Oracle's client, but I don't know how to configure this.

Could someone help me please?

aghsmith
  • 99
  • 1

1 Answers1

0

You can use heterogeneous services to connect from Oracle to other RDBMS's. You can use this to replicate data between Oracle and other database engines. You can also connect to an Oracle database using ODBC. MariaDB should be able to connect to an Oracle database with an ODBC configuration. In that case you are not using the Oracle client.

However, if you want to just manage an Oracle database you should either go the SQL Developer, PL/SQL Developer, Toad route, or just use sqlplus.

Gandolf989
  • 1,540
  • 1
  • 13
  • 18