My Oracle Support Banner

Why is the NMS_INDEX_TABLESPACE not Created? (Doc ID 2743891.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


 What happened to the creation of the INDEX tablespace?

In releases prior to 2.5.0, the template to create tablespaces and users, nms.sql.template, created three tablespaces:



The section to create the index tablespace is no longer listed, but the nms-env-config  prompts for the name of the NMS_INDEX_TABLESPACE:

Database Environment Variables

The RDBMS_ADMIN and RDBMS_HOST variables must be different values with
entries in tnsnames.ora pointing to the same database instance

RDBMS_ADMIN The tnsname of the admin database.
RDBMS_HOST The tnsname of the read-write database. Must be different from RDBMS_ADMIN
NMS_DATA_TABLESPACE The default data tablespace name.
NMS_INDEX_TABLESPACE The default index tablespace name.
NMS_CLOB_SZLIMIT The size limit (MB) for fetching CLOB columns.


Why is the index tablespace not created by the nms.sql.template? 

Is this required?


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.