My Oracle Support Banner

OID 10g Fails To Start / OIDCTL.log Error "Database insert error" / oidmon.log Shows: Internal OCI error. (Doc ID 801803.1)

Last updated on APRIL 26, 2021

Applies to:

Oracle Internet Directory - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.


Oracle Internet Directory (OID) 10g fails to start.

Output of opmnctl status shows OID 10g status of NONE.

The $ORACLE_HOME/opmn/logs/OIDCTL.log shows error:

08/05/21 14:08:37 Start process
Database insert error.

The $ORACLE_HOME/ldap/log/oidmon.log shows error:

2007/05/21:14:08:37 * Connecting to database, connect string is infradb
2007/05/21:14:08:37 * Internal OCI error.


2014/06/08:18:24:29 * oidmon_<HOSTNAME>.<DOMAIN_NAME>.COM:0 *
Could not connect to database, retry again after 10 sec
2014/06/08:18:24:38 * [gsdsiConnect] ORA-0,
2014/06/08:18:24:39 * oidmon_<HOSTNAME>.<DOMAIN_NAME>.COM:0 *
[gsdsiConnect] ORA-0,
2014/06/08:18:24:39 * oidmon_<HOSTNAME>.<DOMAIN_NAME>.COM:0 *
oidmon shutting down
2014/06/08:18:37:31 * Connecting to database, connect string is <CONNECT_STRING>
2014/06/08:18:37:31 * sgslupsCheckProcess: open process for pid <PID> failed
2014/06/08:18:37:31 * oidmon_<HOSTNAME>.<DOMAIN_NAME>.COM:0 *
Internal OCI error.

Sqlplus connections via sqlnet/listener as user "ods" are possible and successful.

However, for OID 10g for example, while using <Note 329808.1> troubleshooting steps and trying to truncate the ods.ods_process table, it fails with:

SQL> create table ods.ods_process_backup as select * from ods.ods_process;
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'OLTS_DEFAULT'




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.