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 OCTOBER 17, 2019
Applies to:
Oracle Internet Directory - Version 11.1.1.2.0 and laterInformation 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 <OID_HOSTNAME> <OID_PORT>"dc=<NEW_REALM2>,dc=com"
oidrealm <OID_HOSTNAME> <OID_PORT>"dc=<NEW_REALM3>,dc=com"
...<etc, etc>...
Most work, but the last couple, plus any subsequent attempts, all fail with the same error:
Enter OID Admin Password:
Error Updating OID Realm oracle.ldap.util.UtilException: NamingException encountered in ldapAdd [LDAP: error code 1 - Operations Error]
$ oidrealm <OID_HOSTNAME> <OID_PORT>"dc=<NEW_REALM6>,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:30:04-04:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <OID_HOSTNAME>] [pid: <PID>] [tid: <TID>] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:0 mesgID:4 OpID:3 OpName:add ConnIP:<IP ADDRESS> ConnDN:cn=orcladmin
[gsldad_AddChgLog] While adding Entry dc=<NEW_REALM5>,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: <OID_HOSTNAME>] [pid: <PID>] [tid: <TID>] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:1 mesgID:4 OpID:3 OpName:add ConnIP:<IP address> ConnDN:cn=orcladmin
[gsldad_AddChgLog] While adding Entry dc=<NEW_REALM6>,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:
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:
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |