OID Debug

———–

1) set OID in trace mode
* make a file 
#—cut-here—debugon.ldif–
dn: cn=oid1,cn=osdldapd,cn=subconfigsubentry
changetype:modify
replace:orcldebugflag
orcldebugflag: 2147483647

changetype:modify
replace:orcldebugop
orcldebugop: 511
#—–cut-here–

* run : 
ldapmodify -h <oidHost> -p <port> -D “cn=orcladmin” -q -f debugon.ldif

2) Disable debug, for this: 
#—cut-here—debugoff.ldif–
dn: cn=oid1,cn=osdldapd,cn=subconfigsubentry
changetype:modify
replace:orcldebugflag
orcldebugflag: 0

changetype:modify
replace:orcldebugop
orcldebugop: 0
#—–cut-here–

ldapmodify -h <oidHost> -p <port> -D “cn=orcladmin” -q -f debugoff.ldif

Advertisements

OID – ODS Password Resets

# Issue : OID cannot restart, logs show the following messages :


[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 7 days
[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [oidmon]: Unable to connect to database,
will retry again after 10 sec

[2016-05-04T04:02:12-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2016-05-04T04:02:12-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 7 days

Solution :

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 4 04:08:34 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect ODS/Welcome1
ERROR:
ORA-28002: the password will expire within 7 days
Connected.
SQL> PASSWORD
Changing password for ODS
Old password:
New password:
Retype new password:
Password changed