ECE Installation Tablespace Does Not Exists (Doc ID 2901597.1)

Last updated on OCTOBER 10, 2022

Applies to:

Goal

Qn1:On : 12.0.0.4.0 version, OUI Installer

Installing Elastic Charging Engine (ECE) 12.0.0.4.0 with persistence enabled,  one user got the error as below:
Tablespace PIN04 does not exists.
Temp Table Space TEMP2 does not exists.

For this installation, the user was using the same Billing and Revenue Management (BRM) database.
In the ECE Persistence Database Details, the user was using the sys credentials.
For ECE Persistence Schema Details, the user was using the new user ece04 with the pin04 (BRM) tablespace.

In this case, the user is using existing Schema User and the grant was executed:

grant select on v_$database to ece04

[user@hostname ~]$ sqlplus ece04/<password>@pindb
...
SQL> select tablespace_name from user_tablespaces;
TABLESPACE_NAME
------------------------------
PIN04

[user@hostname ~]$ sqlplus sys/<password>@pindb as SYSDBA
...
SQL> select tablespace_name from user_tablespaces;
TABLESPACE_NAME
------------------------------
TEMP2
PIN04
 

 

Solution

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