Home » RDBMS Server » Server Utilities » LDAP how to get all listed entries (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0)
LDAP how to get all listed entries [message #672306] Wed, 10 October 2018 14:12 Go to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member
before if I want to get info about the database service name, or connect descriptors I would normally opened the tnsnames.ora file. now that we are using LDAP, how do I get all the entries that are in the LDAP?

all that the ldap.ora file has are:
DEFAULT_ADMIN_CONTEXT = ...
DIRECTORY_SERVERS = ...
DIRECTORY_SERVER_TYPE = ...

note: i replaced the actual values for each parameters with ...

thanks


Re: LDAP how to get all listed entries [message #672307 is a reply to message #672306] Wed, 10 October 2018 14:21 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
Show us how all these entries got into your LDAP originally.

Here is a free hint, LDAP was not automagically populated from content of ldap.ora file.
Re: LDAP how to get all listed entries [message #672311 is a reply to message #672307] Wed, 10 October 2018 15:05 Go to previous messageGo to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member

actually the LDAP.ora file was only provided to me. so I was looking for how do I get the info those that I used to see on the tnsnames.ora before. thanks.
Re: LDAP how to get all listed entries [message #672312 is a reply to message #672311] Wed, 10 October 2018 15:11 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
wtolentino wrote on Wed, 10 October 2018 13:05

actually the LDAP.ora file was only provided to me. so I was looking for how do I get the info those that I used to see on the tnsnames.ora before. thanks.
unwilling or incapable to use GOOGLE yourself.

Allow me to assist.

click on URL below

http://lmgtfy.com/?q=oracle+ldap+replace+tnsnames.ora
Re: LDAP how to get all listed entries [message #672313 is a reply to message #672306] Wed, 10 October 2018 15:50 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
tnsping should show you what the net service name resolves to.
Re: LDAP how to get all listed entries [message #672318 is a reply to message #672313] Thu, 11 October 2018 07:08 Go to previous messageGo to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member

thanks yes I use tnsping when I know what is the database name or service name. but to get all the entries just like when I open the tnsnames.ora file how do I do that for LDAP.
Re: LDAP how to get all listed entries [message #672319 is a reply to message #672318] Thu, 11 October 2018 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

lsnrctl services
Re: LDAP how to get all listed entries [message #672320 is a reply to message #672312] Thu, 11 October 2018 07:33 Go to previous messageGo to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member
before I post my inquires here I always google and if I can't find the answer that I am looking for that's when I post in this forum for help/advise.

i tried but could not find it in google or maybe it's the keywords that i typed in.

after reading some online docs about LDAP my best guess was that the info that i am looking for was on this parameter in the LDAP.ora
DIRECTORY_SERVERS = (...)

and in that server i might find it.

Re: LDAP how to get all listed entries [message #672321 is a reply to message #672318] Thu, 11 October 2018 07:40 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
wtolentino wrote on Thu, 11 October 2018 13:08

thanks yes I use tnsping when I know what is the database name or service name. but to get all the entries just like when I open the tnsnames.ora file how do I do that for LDAP.
You can use the supplied ldap utilities to bind to and search the directory,
C:\Users\john>
C:\Users\john>dir %ORACLE_HOME%\bin\ldap*
 Volume in drive C is OS
 Volume Serial Number is 4454-E531

 Directory of C:\app\oracle\product\12.2.0\dbhome_1\bin

23/11/2016  22:54           560,128 ldapadd.exe
23/11/2016  22:54           568,832 ldapaddmt.exe
23/11/2016  22:54           523,264 ldapbind.exe
23/11/2016  22:54           523,776 ldapcompare.exe
23/11/2016  22:54           523,776 ldapdelete.exe
23/11/2016  22:54           523,776 ldapmoddn.exe
23/11/2016  22:54           560,128 ldapmodify.exe
23/11/2016  22:54           568,832 ldapmodifymt.exe
23/11/2016  22:54           549,376 ldapsearch.exe
               9 File(s)      4,901,888 bytes
               0 Dir(s)  63,582,928,896 bytes free

C:\Users\john>
Re: LDAP how to get all listed entries [message #672322 is a reply to message #672319] Thu, 11 October 2018 07:40 Go to previous messageGo to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member
Michel Cadot wrote on Thu, 11 October 2018 08:19

lsnrctl services

thanks so much. I think that's a unix command

lsnrctl services

for windows command is there an equivalent command?

[Updated on: Thu, 11 October 2018 07:42]

Report message to a moderator

Re: LDAP how to get all listed entries [message #672323 is a reply to message #672322] Thu, 11 October 2018 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is the same command in Windows.

Re: LDAP how to get all listed entries [message #672327 is a reply to message #672323] Thu, 11 October 2018 08:31 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
https://docs.oracle.com/cd/E53394_01/html/E54912/gmrkv.html
Re: LDAP how to get all listed entries [message #672338 is a reply to message #672327] Thu, 11 October 2018 12:10 Go to previous messageGo to next message
wtolentino
Messages: 235
Registered: March 2005
Senior Member
thanks all.


i think maybe it is not on the client.

Microsoft Windows [Version 10.0.16299.666]
(c) 2017 Microsoft Corporation. All rights reserved.

O:\>ldaplist
'ldaplist' is not recognized as an internal or external command,
operable program or batch file.

O:\>lsnrctl services
'lsnrctl' is not recognized as an internal or external command,
operable program or batch file.

O:\>lsnrctl
'lsnrctl' is not recognized as an internal or external command,
operable program or batch file.

O:\>
Re: LDAP how to get all listed entries [message #672339 is a reply to message #672338] Thu, 11 October 2018 12:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use McTns, it even does not require any Oracle client.

[Updated on: Thu, 11 October 2018 12:25]

Report message to a moderator

Re: LDAP how to get all listed entries [message #672340 is a reply to message #672338] Thu, 11 October 2018 12:23 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Why don't you ask your directory administrator? Or your DBA?
Re: LDAP how to get all listed entries [message #672368 is a reply to message #672339] Fri, 12 October 2018 08:05 Go to previous message
wtolentino
Messages: 235
Registered: March 2005
Senior Member
Michel Cadot wrote on Thu, 11 October 2018 13:18

You can use McTns, it even does not require any Oracle client.

thanks.
Previous Topic: Rows not loaded because all WHEN clauses were failed.
Next Topic: service name how to get the database name
Goto Forum:
  


Current Time: Fri Oct 19 23:08:38 CDT 2018