TROUG Database Administration SIG 2017

February 5, 2017 Leave a comment


TROUG Database Administration SIG 2017 will be the first event of TROUG in this year. The event will be performed at the Bilginç IT Academy on Friday, 10th February. We wait for you with very important presentations.


Event Agenda:

09.30-10.15 Exadata x6 New and Cloud Features – Zekeriya Beşiroğlu
10.30-11.15 Zero Downtime Database Upgrade Using Oracle Data Guard – Gökhan Atıl
11.30-12.15 Oracle Database Benchmark Testing Tools – Talip Hakan Öztürk
13.30-14.15 Oracle Database Performance Checklist – Orhan Eripek
14.30-15.15 Oracle Public Cloud Fundementals – Okcan Yasin Saygılı
15.30-16.15 Oracle 12c Compression and Archiving – Fethullah Çabuk

Event Location:

Bilginç IT Academy
Huzur Mahallesi. Fatih Caddesi.
No:67 Kat:4
(Sanayi Mahallesi Metro İstasyonu Çıkışı)

For more information and registration:

Categories: Education, Seminars

Registration for TROUG Days Istanbul 2016 is started!

March 29, 2016 Leave a comment

Hi Friends,

The TROUG Day 2016 will be running from April 28th  until April 29th in Istanbul Technical University, Technopark ARI-3 conference halls. The event will be perform in three parallel sessions.

If you are not already a member of TROUG, please visit to become a member of TROUG.

Below you can find the registration link and more information regarding the event.



Agenda :

Event Date: 28th-29th April 2016

Event Location: Istanbul Tehnical University ARI-3 Technopark, Maslak/Istanbul, Turkey

Categories: Seminars Tags: ,

TROUG High Availability SIG 2016

March 24, 2016 Leave a comment

Hi Friends,

“High Availability SIG 2016” was the first event of TROUG in this year.  The event was held at the Galatasayaray University’s Aydın Dogan conference hall.

The Event started with presentation of Gokhan Atıl about  “Oracle Maximum Availability Architecture”.

After a short break Zekeriya Beşiroğlu presented about “RAC Performance Tuning “. He talked about the tuning tips&tricks.

After our lunch break, we continued with the presentation of Erkan Ulgey  about “12c Dataguard New Features”. He did Far sync demo tests. These tests was catchy.

The another important component of High Availability is the RMAN Backup and Recovery. I talked about the importance of RMAN backup. I mentioned some examples from real life. And I did tests of RMAN 12c new features on virtual machine.

The summary of the day was the Fethullah Cabuk’s presentation about  “12c New High Availability Features”


It was quite a pleasant day. As TROUG, we are glad to see you again on our next big event 🙂

Talip Hakan Ozturk

ORA-28043: invalid bind credentials for DB-OID connection

In this article, I will write about resolving ORA-28043 error. Our databases integrated with Oracle Internet Directory and registered in OID under domain dc=tholdap,dc=local
Some users in my company reported that they can’t login to database using OID user accounts. They get ORA-28043 error when attempt to login database. In this situation, first thing to do is enable a trace for this error in database as below.

sqlplus / as sysdba

SQL> alter system set events ‘28033 trace name context forever, level 9’;

Try to reconnect with OID user account and get ORA-28043 error again.

Go trace file location under directory $ORACLE_BASE/diag/rdbms/$SID/$SID/trace

The sample trace file contains following lines.

vi /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_ora_9951.trc

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: SunOS
Node name: dbtest
Release: 5.10
Version: Generic_150400-09
Machine: sun4v
Instance name: TESTDB
Redo thread mounted by this instance: 1
Oracle process number: 2610
Unix process pid: 9951, image: oracle@dbtest

*** ACTION NAME:() 2016-02-24 09:04:40.463
*** MODULE NAME:(Toad.exe) 2016-02-24 09:04:40.463
*** SERVICE NAME:(TESTDB) 2016-02-24 09:04:40.463
*** SESSION ID:(1212.44043) 2016-02-24 09:04:40.463
kzld_discover received ldaptype: OID
kzld found pwd in wallet
KZLD_ERR: Failed to bind to LDAP server. Err=49
KZLD is doing LDAP unbind
KZLD_ERR: found err from kzldini.

According to trace file, the error message is related to binding to LDAP Server.

kzld_discover received ldaptype: OID
kzld found pwd in wallet
KZLD_ERR: Failed to bind to LDAP server. Err=49
KZLD is doing LDAP unbind
KZLD_ERR: found err from kzldini.

Let me check, if I can connect to ldap server using username and password stored in database wallet.

Now, there is a question: How can we find the username and password stored in our database wallet ?

$ mkstore -wrl $ORACLE_BASE/admin/TESTDB/wallet -viewEntry ORACLE.SECURITY.DN
Oracle Secret Store Tool : Version – Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Enter wallet password: abcd678xx_

ORACLE.SECURITY.DN = cn=TESTDB,cn=OracleContext,dc=tholdap,dc=local
$ mkstore -wrl $ORACLE_BASE/admin/TESTDB/wallet -viewEntry ORACLE.SECURITY.PASSWORD
Oracle Secret Store Tool : Version – Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Enter wallet password: abcd678xx_


mkstore will ask you for wallet password which you entered during database OID registration.

Now, we have the username and password as below.

ORACLE.SECURITY.DN = cn=TESTDB,cn=OracleContext,dc=tholdap,dc=local

Now it is needed to verify database connection to LDAP Server.

First let me get port number from ldap.ora file located in directory $ORACLE_HOME/network/admin.

$ cat /u01/app/oracle/product/11.2.0/db_1/network/admin/ldap.ora
# ldap.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/ldap.ora
# Generated by Oracle configuration tools.

DIRECTORY_SERVERS= (idmoid.vodafone.local:1389:1636)

DEFAULT_ADMIN_CONTEXT = “dc=tholdap,dc=local”


Run ldapbind command to check connection to LDAP Server.

$ ldapbind -h idmoid.vodafone.local -p 1389 -D cn=TESTDB,cn=OracleContext,dc=tholdap,dc=local -w kSlIt+n2
ldap_bind: Invalid credentials

So the problem was due to Invalid credentials. All right! How we can solve this issue?

There is two way:

1- Go to OID and update password for cn=TESTDB,cn=OracleContext,dc=tholdap,dc=local at attribute userPassword with value received from ORACLE.SECURITY.PASSWORD

2- Re-register the database using DBCA as below

dbca -silent -configureDatabase -sourceDB TESTDB -unregisterWithDirService true -dirServiceUserName cn=dirManager -dirServicePassword OracleTHO11 walletPassword abcd678xx_

dbca -silent -configureDatabase -sourceDB TESTDB -registerWithDirService true -dirServiceUserName cn=dirManager -dirServicePassword OracleTHO11 walletPassword abcd678xx_

After re-registering database, ldapbind will be successful

$ ldapbind -h idmoid.vodafone.local -p 1389 -D cn=TESTDB,cn=OracleContext,dc=tholdap,dc=local -w +HKRbmQ7
bind successful

Now, users can login database successfully.

I want to note that, if there is spaces in your CN (Directory Service username) then you must write \20 instead of spaces.

For example: Lets assume that our directory service username is “directory manager”. So we must write it as below in DBCA

dbca -silent -configureDatabase -sourceDB TESTDB -unregisterWithDirService true -dirServiceUserName cn=directory\20manager -dirServicePassword OracleTHO11 walletPassword abcd678xx_

You will get an error without “\20” as below

dbca -silent -configureDatabase -sourceDB TESTDB -unregisterWithDirService true -dirServiceUserName cn=directory manager -dirServicePassword OracleTHO11 walletPassword abcd678xx_
manager is an invalid command line argument.

let’s meet at TROUG High Availability SIG 2016 – Galatasaray University!

February 22, 2016 Leave a comment


For detailed information and registration;

High Availability SIG Meeting 2016

The New Edition of My “Oracle Database 11gR2” Book is Published

January 4, 2016 Leave a comment

oracle11gr2onThe new(updated) edition of My “Oracle Database 11gR2” book is published. In this book you can find chapters from installation of Oracle Database  11g R2 to configuration and from configuration to management.

Every day, the utilization rate of the ORACLE database is increasing . My goal in this book is to increase the number of Oracle books in Turkish. And contribute to my colleagues who want to educate yourself about ORACLE Database.

The best method of the learning is the practical learning. With this in mind I gave particular importance to the screen shots. Thus, you can do practics by following the book.

Comments and suggestions about the book is very valuable for me. You can send your comments and suggestions to my e-mail address

Hope to get the most from my book Oracle Database 11g R2 …

let’s meet at ANATEKDER (Anatolian Technical Staff Association) – Konya Mevlana University Oracle Seminar!


%d bloggers like this: