S
S
sisharpacc2014-10-15 12:17:59
Oracle
sisharpacc, 2014-10-15 12:17:59

Oracle: how to connect with SQL developer or TOAD?

The oracle server is on a different machine. I am connecting via PL/SQL developer via LDAP. All this was set up without me.
Contents of sqlnet.ora file:
NAMES.DIRECTORY_PATH= (LDAP)
Contents of ldap.ora file:

DIRECTORY_SERVERS= (example.com:389:636)
DEFAULT_ADMIN_CONTEXT = "dc=ssnmp,dc=net"
DIRECTORY_SERVER_TYPE = OID

(If you change the address, then PL / SQL developer stops seeing the connection, which means it definitely works through LDAP)
I'm trying to create a connection in SQL developer: I
fill in the connection name, user and password -> select the type of connection LDAP -> in the drop-down list "LDAP Server" the server appears from the ldap.ora file -> the "Context" dropdown is empty -> I click Test Connection and I get an error:
Status: Failure - Test failed: required property 'hostname' is not set in the DataBase provider

Googling something useful did not work.
In TOAD:
Add Login Record -> LDAP Descriptor -> what should I enter here?
Tried example.com:389:636 || example.com:389:636?dc=ssnmp,dc=net || let to file.
When I press test, nothing happens.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dchernov, 2014-10-22
@dchernov

If there is no specific requirement for connecting via LDAP, then you can connect via Listener, you can briefly read here how this is done
www.fullautomatic.ru/index.php/oracle/267-42
www.sql.ru/forum/1102819/nastroyka- connectineniya-sb...
In more details, of course, it is better to read in documentation of Orakla.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question