EPM Configurator Fails: Error "ORA-01658: unable to create INITIAL extent for segment in tablespace." (Doc ID 1993798.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Hyperion Planning - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.500 version, Configuration/Administration

EPM Configurator fails creating the registry with an ORA-01658 error running the create_oracle.sql

Attempting to install and configre Hyperion Planning 11.1.2.3 in a Windows 2008 R2 environment.

The configurator fails with the error: com.hyperion.hit.registry.exceptions.RegistryException Registry Exception Occured - Unable to create registry.

RootCause : error occurred during batching: ORA-01658: unable to create INITIAL extent for segment in tablespace.






ERROR
-----------------------
ORA-01658

Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-01658: unable to create INITIAL extent for segment in tablespace TSEPMREP

at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:6390)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
at com.hyperion.hit.registry.RegistryConnection.createRegistry(RegistryConnection.java:348)

Changes

Temp space is full and there is not enough space in the temp tablespace to configure the schema.

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
--------------- --------------- --------------- ----------
TEMP                   73400320        73400320          0


TABLESPACE_NAME SEGMEN ALLOCATIO INITIAL_EXTENT NEXT_EXTENT
--------------- ------ --------- -------------- -----------

TEMP            MANUAL UNIFORM          1048576     1048576 

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