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 www.troug.org to become a member of TROUG.

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

Registration: http://www.troug.org/haberler/troug-days-istanbul-2016

featuredspeakers

Agenda : http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdf

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_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_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 11.2.0.3.0 – 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 11.2.0.3.0 – Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Enter wallet password: abcd678xx_

ORACLE.SECURITY.PASSWORD = +HKRbmQ7

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.PASSWORD = +HKRbmQ7
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”

DIRECTORY_SERVER_TYPE = OID

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

he16-1

For detailed information and registration;

High Availability SIG Meeting 2016

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

OracleV334

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

March 26, 2015 Leave a comment

oracle11gr2onThe new 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 sources 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 talip_hakan_ozturk@hotmail.com

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

http://www.abakuskitap.com/tr/m/veritabani/veritabani-yonetimine-giris-oracle-11g-r2.html

Oracle Gurus Tom Kyte, Andrew Holdsworth, and Graham Wood with us…

March 14, 2015 Leave a comment

A Day of Real World Performance 2015

For the second time, the great trio Tom Kyte, Andrew Holdsworth and Graham Wood will come to the Istanbul for their amazing performance show on Friday, 27 March. You will learn performance details from the Oracle gurus. A unique event, with simultaneous presentations on 3 screens. I want to thank to TROUG management that connects us with the this great team. Dear Oracle lovers, do not be late and do not miss this opportunity …

Event Topics:

  • Investigate the Performance Problems
  • Data Warehouses
  • Indexes
  • Data Warehouse General Concepts
  • Challenges in Data Loading
  • Gathering Statistics
  • Monitoring SQL Queries
  • Resource Management
  • OLTP System and Performance Strategies
  • Concurrent Query Processing
  • Sessions, Cursors, and SQL
  • Oracle Exadata Perfromance

Event date and location:

On Friday, 27 March  09:00-16:00 – Elite World İstanbul

For the registration and further information, please visit  http://www.troug.org/haberler/a-day-of-real-world-performance-2015

realworldperformans

Follow

Get every new post delivered to your Inbox.

Join 94 other followers

%d bloggers like this: