My Oracle Support Banner

Tablespace Error While Installing ECE Patch (Doc ID 2931603.1)

Last updated on MARCH 16, 2023

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

Goal


Qn1:User tried installing (Elastic Charging Engine) ECE 12PS5 IP2 but encountered tablespace error as below:

create temporary tablespace ecetable tempfile '+DATA' size 500M reuse autoextend on next 1M ;
Tablespace ECETABLE created.

create temporary tablespace ecetemp tempfile '+DATA' size 500M reuse autoextend on next 1M ;
Tablespace ECETEMP created.


Error starting at line : 13 in command -
create user <USER> identified by <PASSWORD> default tablespace ecetable temporary tablespace ecetemp
Error report -
ORA-12910: cannot specify temporary tablespace as default tablespace
12910. 00000 - "cannot specify temporary tablespace as default tablespace"
*Cause: attempt to assign a temporary tablespace to be a user's
  default tablespace
*Action: assign a permanent tablespace to be the default tablespace

So, create user <USER> identified by <PASSWORD>;
User <USER> created.

now,
Error starting at line : 17 in command -
alter user <USER> default tablespace ECETABLE
Error report -
ORA-12910: cannot specify temporary tablespace as default tablespace
12910. 00000 - "cannot specify temporary tablespace as default tablespace"
*Cause: attempt to assign a temporary tablespace to be a user's
  default tablespace
*Action: assign a permanent tablespace to be the default tablespace

Did we miss any steps before installation?
 
Qn2: User applied ECE 12PS3IP3 and looks like successful now as ecs1-2 pod is not crashing which used to crash when attempted installing ECE 12PS5 IP2

Query :
when extracted the new 12.0.0.5.3 helm chart in a separate staging area, then merge the old values.yaml from the previous helm chart and the new values.yaml manually in this staging area.
Make sure running ecs and ecs1 replicas must be at least 3 each before upgrade. After upgrade can user make replica to previous count?

Is reverting changes possible as below ?
ecs:
  jmxport: ""
  replicas: 2
 ecs1:
  jmxport: ""
  replicas: 1

Also, for latest patch 12PS3IP3 user is setting replicas to 3 ? If so then can user skip to reduce the replica?
 

Solution

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
Goal
Solution
References


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