How to Change Lost SYSMAN Password On OEM Cloud Control 13c?

September 16, 2017 Leave a comment

Hi,

To change lost SYSMAN password on Oracle Enterprise Manager 13c, follow the below steps:

1- Change the password from SQL*Plus

alter user sysman identified by “oracle_test”;

2-Go to middleware home directory

cd /u01/app/oracle/middleware/bin/
./emctl config oms -list_repos_details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oem13c)(PORT=1521)))(CONNECT_DATA=(SID=emrep)))
Repository User : SYSMAN

3- Change the password as the following command

./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle_test -new_pwd oracle_test
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.

Changing passwords in backend …
Passwords changed in backend successfully.
Updating repository password in Credential Store…
Successfully updated Repository password in Credential Store.
Restart all the OMSs using ’emctl stop oms -all’ and ’emctl start oms’.
Successfully changed repository password.

4- Restart the OMS

./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Stopping Oracle Management Server…
WebTier Successfully Stopped
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
Stopping BI Publisher Server…
BI Publisher Server Successfully Stopped
AdminServer Successfully Stopped
BI Publisher Server is Down

./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server …
BI Publisher Server Successfully Started
BI Publisher Server is Up

Advertisements

How to Resolve ‘Null Pointer Exception’ Error On Top Activity Page In Oracle Enterprise Manager 13c

September 9, 2017 Leave a comment

Hi,

When you login  Oracle Enterprise Manager 13c, the top activity page shows ‘Null Pointer Exception’ errors.   This is due to bug number 25455462. You can do following steps to resolve this issue.

oem13c_error

1-Set the following property on OEM 13c machine

emctl set property -name use_pooled_target_connections -value false

2-Restart the oms

cd <OMS_HOME>/bin

(cd /u01/app/oracle/middleware/bin/)

./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Stopping Oracle Management Server…
WebTier Successfully Stopped
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
Stopping BI Publisher Server…
BI Publisher Server Successfully Stopped
AdminServer Successfully Stopped
BI Publisher Server is Down

./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server …
BI Publisher Server Successfully Started
BI Publisher Server is Up

TROUG Database Administration SIG 2017

February 5, 2017 Leave a comment

Hi,

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
4.Levent/İstanbul
(Sanayi Mahallesi Metro İstasyonu Çıkışı)

For more information and registration:

http://www.troug.org/haberler/database-administration-sig-2017/

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 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

%d bloggers like this: