About

I am an Oracle DBA with over 13+ years of IT experience which also includes about 9 years of production Oracle DBA. An Oracle RAC Expert, Oracle 8i, 9i,10g, 11g and 12c  OCP DBA. Past four year or so, I have been mainly working with Oracle RAC, ASM & Data Guard. Prior to DBA experience, I was working as an PL/SQL developer & was mainly involved in application tuning aspects.

This blog is all about my experience on Oracle database. I mainly focus on the problem & their solutions in this blog. My main intention is to contribute to Oracle user community & save the efforts in debugging similar problems. Although I’ve tested all solutions I’ve described, one should validate them in their respective environments.

3 Responses to About

  1. Manjunath Ratakonda says:

    Hey Yogesh,

    Hope you doing great. Just have a quick question to you on retrieving the Corporate Directory information using Oracle. Is there any other way to achieve this apart from using DBMS_LDAP API?

    Thanks,
    Manjunath Ratakonda

    • I haven’t worked extensively on LDAP.. but I used following code few days back to test LDAP connectivity. You will need this as a starting point & I’m pretty much sure, DBMS_LDAP will have functionality to get further details

      create or replace procedure ldap_connect as
      l_ldap_host VARCHAR2(256) := ”;
      l_ldap_port VARCHAR2(256) := ”;
      l_ldap_user VARCHAR2(256) := ‘cn=Manager,dc=,dc=’;
      l_ldap_passwd VARCHAR2(256) := ”;
      l_retval PLS_INTEGER;
      l_session DBMS_LDAP.session;
      BEGIN
      DBMS_OUTPUT.PUT_LINE(‘Connecting’);

      — Connect to the LDAP server.
      l_session := DBMS_LDAP.init(l_ldap_host,l_ldap_port);
      DBMS_OUTPUT.PUT_LINE(‘Init done ..Session is ‘ || l_session);
      l_retval := DBMS_LDAP.simple_bind_s( ld => l_session,dn => l_ldap_user,passwd => l_ldap_passwd);
      DBMS_OUTPUT.PUT_LINE(‘Connected’);

      — Disconnect from the LDAP server.
      l_retval := DBMS_LDAP.unbind_s(l_session);
      DBMS_OUTPUT.PUT_LINE(‘L_RETVAL: ‘ || l_retval);

      EXCEPTION
      WHEN OTHERS THEN raise_application_error(-20001,’Error – ‘||SQLCODE||’ ‘||SQLERRM);
      END LDAP_CONNECT;

  2. Manjunath Ratakonda says:

    Yogesh,

    Thanks for the info.

    Thanks,
    Manjunath Ratakonda

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s