Creating New Realms in OID 11g With oidrealm Command Fails With: Error Updating OID Realm oracle.ldap.util.UtilException: NamingException encountered in ldapAdd [LDAP: error code 1 - Operations Error] (Doc ID 1131424.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Internet Directory (OID) 11g (11.1.1.2.0) with Metadata Repository (MR) Database (DB) 11.2.

Creating a few new realms in OID 11g, say six new realms, with oidrealm commands, for example:

oidrealm myoidhost 3060 "dc=newrealm1,dc=com"
oidrealm myoidhost 3060 "dc=newrealm2,dc=com"
...<etc, etc>...


Most work, but the last couple, plus any subsequent attempts, all fail with the same error:

$ oidrealm myoidhost 3060 "dc=newrealm5,dc=com"
Enter OID Admin Password:
Error Updating OID Realm oracle.ldap.util.UtilException: NamingException encountered in ldapAdd [LDAP: error code 1 - Operations Error]

$ oidrealm myoidhost 3060 "dc=newrealm6,dc=com"
Enter OID Admin Password:
Error Updating OID Realm oracle.ldap.util.UtilException: NamingException encountered in ldapAdd [LDAP: error code 1 - Operations Error]


The OID server log (oidldapd01s<pid>-0000.log) shows an ORA error as well:

[2010-05-14T15:29:19-04:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: myoidhost] [pid: 3306] [tid: 7] ServerDispatcher : Thread Started

[2010-05-14T15:30:04-04:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: myoidhost [pid: 3306] [tid: 9] [ecid: 004XdBat^Cx7i4Jbelbe650000ne000003,0] ServerWorker (REG):[[
BEGIN
ConnID:0 mesgID:4 OpID:3 OpName:add ConnIP:<IP address> ConnDN:cn=orcladmin
[gsldad_AddChgLog] While adding Entry dc=newrealm5,dc=com in change log table, ORA-1950: ORA-01950: no privileges on tablespace 'OLTS_DEFAULT'

END
]]
[2010-05-14T15:30:56-04:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: myoidhost [pid: 3306] [tid: 9] [ecid: 004XdBe1Lpg7i4Jbelbe650000ne000007,0] ServerWorker (REG):[[
BEGIN
ConnID:1 mesgID:4 OpID:3 OpName:add ConnIP:<IP address> ConnDN:cn=orcladmin
[gsldad_AddChgLog] While adding Entry dc=newrealm6,dc=com in change log table, ORA-1950: ORA-01950: no privileges on tablespace 'OLTS_DEFAULT'

END




As nothing had been changed since the first few realms were created, checked that the OID database schema user (ODS) is able to extend the tablespaces where OID data is present (olts_attrstore, olts_battrstore, olts_ct_store, olts_default, olts_svrmgstore):

Checked autoextend for all datafiles associated with those tablespaces were on:

SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DB_DATA 4945920 999432
DB_FLASH 921600 334976

And the following select also showed all with autoextensible set to YES:
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files;


Checked that the ODS user was able to create objects in all of those tablespaces:

SQL> show user;
USER is "ODS"

SQL> select tablespace_name from dba_tablespaces where tablespace_name like 'OLTS%';
TABLESPACE_NAME
------------------------------
OLTS_ATTRSTORE
OLTS_BATTRSTORE
OLTS_CT_STORE
OLTS_DEFAULT
OLTS_SVRMGSTORE

SQL> create table A tablespace OLTS_ATTRSTORE as select * from all_objects where 1=0;
Table created.

SQL> create table b tablespace OLTS_BATTRSTORE as select * from all_objects where 1=0;
Table created.

SQL> create table C tablespace OLTS_CT_STORE as select * from all_objects where 1=0;
Table created.

SQL> create table D tablespace OLTS_DEFAULT as select * from all_objects where 1=0;
Table created.

SQL> create table E tablespace OLTS_SVRMGSTORE as select * from all_objects where 1=0;
Table created.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms