Friday, June 16, 2017

OID configuration issue

I was running config.sh from $MW_HOME/Oracle_IDM1/bin, Bootstrap complete 100% and configure oracle Identity management components was stuck @14%.

I look at the log oidctl.log. $MW_HOME/asinst_1/diagnostics/log/OID/oid1/oidctl.log


[2017-06-16T12:06:50.410657-04:00] [OID] [NOTIFICATION:16] [] [] [host:xxxxxxx [pid: 17936] [tid: 0] OIDCTL:: WARNING: Connected to incorrect OID base schema version, (version=OID 11.1.1.5.0
).

My oid version is 11.1.1.9.0.

solution is the below

SQL> select owner,version,status from schema_version_registry;

OWNER                          VERSION                        STATUS
------------------------------ ------------------------------ -----------
DEV_MDS                        11.1.1.7.0                     VALID
ODS                            11.1.1.7.0                     VALID
DEV_ORASDPM                    11.1.1.7.0                     VALID
DEV_SOAINFRA                   11.1.1.7.0                     VALID


SQL> select attrval from ods.ds_attrstore where entryid= 1 and attrname = 'orcldirectoryversion';

ATTRVAL
--------------------------------------------------------------------------------
OID 11.1.1.5.0

SQL> update ods.ds_attrstore set attrval='OID 11.1.1.9.0' where entryid= 1 and attrname = 'orcldirectoryversion';

1 row updated.

SQL> commit;

Commit complete.


 $rm -rf user_projects
$rm -rf asinst_1

I restarted my configuration, It completed 100%.


Thursday, June 15, 2017

String X.500 AttributeType

String  X.500 AttributeType
------------------------------
CN      commonName
L       localityName
ST      stateOrProvinceName
O       organizationName
OU      organizationalUnitName
C       countryName
STREET  streetAddress
DC      domainComponent
UID     userid

Friday, June 2, 2017

XATRANS views are not Installed. OIM RCU



  Error:  XATRANS Views are not installed on this Database. This is required by the OIM Schema
  Action: Install view XAVIEWS as SYS user on this Database.

          Refer to the Oracle Database Release Documentation for installation details.

Cd $ORACLE_HOME/javavm/install
Sqlplus ‘/as sysdba’

SQL> sta initxa.sql

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL


PL/SQL procedure successfully completed.


Package created.


Package body created.


Synonym created.


Grant succeeded.

SQL>exit
Cd $ORACLE_HOME/rdbms/admin/
Sqlplus ‘/as sysdba’

SQL> sta xaview.sql

SQL> sta xaview.sql
DROP VIEW v$xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW v$pending_xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


View created.

SQL>