With Oracle 18c and even better in Oracle 19c, you can manage your Oracle database users in Active Directory. This was supposed to be a very nice new feature as many of us struggle with many thousand users spread over many versions, environments, platforms and even cloud or exadata. Is this going to help you? […]
To have the same users in multiple databases and no single sign on is quite a nightmare for password expiration, synchronisation and validation. You probably were discouraged by the long long route to kerberos, where the 220.127.116.11 bugs are fixed in 18.104.22.168, the 12.1 bugs are fixed in 12.2. And lot’s of system changes that […]
It is highly probable you already have MS AD in your company. Probably you use a local tnsnames.ora. Apart from setting a Oracle Internet Directory or Oracle Virtual Directory, there is one more option that you may want to consider : AD. Ok, here is a bit of a road map : – Schema Extension […]
Download oracle-oid-10.1.4.2.0-1.0.i386.rpm Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm Install the rpm # rpm -i oracle-*.i386.rpm In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh # ln -s /usr/bin/cut /bin/cut Run the configure script as root # /etc/init.d/oracle-oid configure That’s all folks! It created an Oracle XE 10gR2 database, […]
First you need to install OID. Check the Installation Guide, the Doc and download the Software. If you do not need the dbconsole, stop it (emctl stop dbconsole) and remove the oracle_home/hostname_sid directory Once you have a running OID, test it with ldapsearch. For this workshop, I use two servers and two usernames. Having the […]
I had a question in my mailbox today about using TNS resolution with an unsupported LDAP Server like Sun Java System Directory Server. Supported in 9i and above are only Microsoft Active Directory and Oracle Internet Directory. In 8i also Novell. So I have done this once with OVID. 1) download Oracle Virtual Directory 2) […]
Yesterday I posted about tnsnames in Sun Java System Direcotry Server. I have to solve one problem : sqlnet requires anonymous search capability on the ldap server. Which I cannot offer in production. So I created an Oracle Virtual Directory, which matches my anonymous request to an authenticated request to the Sun Directory.
In this post, I did show how easy it is to use OID to resolve your network service names. Apart OID, AD (Microsoft Active Directory) is also supported. However, I do not want to use such products, as my customer already have a Sun Java System Directory Server running. It is quite easy. Here are […]
Tomorrow LC Systems is organizing an event about Identity Management in Zurich. The focus will be on Sun Java System Directory Server and Oracle Virtual Directory.
with netca, it is easy to configure your sqlnet.ora to use LDAP instead of tnsnames.ora. The ldap.ora and sqlnet.ora are updated… than it works, sqlplus user@db is correctly looking in the ldap oracle content
what can I do with LDAP? what is the difference between LDAP and Oracle Internet Directory? Well, there is quite a lot of interresting documents, pictures and faq on otn : OTN Directory homepage Directory Admin guide Identity Management ReferenceLDAP is a directory server, the info are stored in an Oracle 10.1.0.4.2 database. When you […]
My ldap server is up and running on my notebook with SLES9. Next, next, next, install. That is it. Oracle Application Server creates a 10.1.0.4.2 database and start the Oracle Internet Directory – understand LDAP server – automatically. It can then be configured with the web interface.