Install UIM failed with Oracle 12.1

book

Article ID: 130086

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

The process of installing UIM fails when the installer starts to run script nis_base_create.sql to create table 'tbnLogging'. Check the installer log and find below error:

2019-03-26 12:35:51,993 ERROR impl.UIMServerDBSchemaController:run:163 [Thread-39]  - NimException caught
(503) , java.sql.SQLException: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
ORA-06512: at line 14
: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
ORA-06512: at line 14

    at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:77)
    at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScript(NimDBProviderBase.java:260)
    at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScriptFile(NimDBProviderBase.java:193)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.runScriptCommon(UIMServerDBSchemaController.java:374)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.configureNisBaseCreate(UIMServerDBSchemaController.java:289)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
    at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure_dbScript(UIMServerDBSchemaController.java:260)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure(UIMServerDBSchemaController.java:174)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.run(UIMServerDBSchemaController.java:161)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
ORA-06512: at line 14

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1792)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334)
    at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.executeSQLCommand(NimDBScriptRunner.java:104)
    at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:59)
    ... 14 more

Cause

This error ORA-60019 is related to Oracle DB parameter DB_SECUREFILE:


DB_SECUREFILE


The default value of this parameter in Oracle 12c is 'PREFERRED', which causes this issue.


Uniform size of 64k for extent was used when creating the UIM tablespace before running UIM installer according to the error message:


Creating initial extent of size 14 in tablespace of extent size 8

Environment

UIM 9.02 to be freshly installed 

Oracle 12c ver 12.1

Resolution

Quit the installer and uninstall UIM (when the script fails, the UIM is partially installed)


Drop the user and its schema objects, since while the installing script fails when creating table tbnLogging, some of the other objects have already been created:


SQL> drop user uim cascade;


Drop the tablespace:


SQL>drop tablespace uim including contents and datafiles;



Option 1


As 64k is used as the uniformed extent size when creating the UIM tablespace. Before running the installer again, dropping the current tablespace and recreating it to use uniform extent size 128k or any multiples of 8k (or the default block size if not specified) that is larger than 128k or use the 'AUTOALLOCATE' clause.


Use a larger extent size:


SQL> create tablespace uim datafile '/u01/oradata/uim01.dbf' size 20480m autoextend on maxsize 30720m extent management local uniform size 128k;


For larger DB setup, use size 1M instead which leads to a requirement for excessively large free disk space when DB grows.


In  Oracle 12c and 11g, extent size is managed by DB by default, use the default extent size option:


SQL> create tablespace uim datafile '/u01/oradata/uim01.dbf' size 20480m autoextend on maxsize 30720m extent management local autoallocate;



Option 2


Restore the default behavior of Oracle 11g R2 on 'db_securefile'.


Log in as sys user and alter this parameter to the 11g R2 default:


SQL>alter system set db_securefile=PERMITTED scope=both;


or  disable it:


SQL>alter system set db_securefile=NEVER scope=both;



After adopting any of the options, recreate the tablespace and user, grant user permissions to the new user, according to install and configure your database software


Run the installer again.