"ORA-01543: tablespace 'ECC_TS' already exists" Error installing ECC version 4 (Doc ID 2671500.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 12.2.x version, Installation

EBusiness 12.2.x Command Center V4 install error

I am trying to setup Command Center V4 on a EBusiness 12.2.9 environment for Oracle university , so we can conduct training using this environment in the future.

The issue occurs in Step 3 (Run the envSetup.sh script using the following command) of Section 4.3.1 (Set Up the Database) of Note 2495053.1.

Run the envSetup.sh script using the following command:
./envSetup.sh

Select which option you want to proceed with

1. Database Setup

2. Install Weblogic Server

3. Create ECC Domain

4. Create EBS JNDI

5. Integrate ECC with EBS

6. Exit:

<Selected option 1>

Selected ECC DB is jdbc:oracle:thin:@apps.example.com:1521:EBSDB

Is the user ECC existing in the ECC database [y/n]? n

Enter the database system user name: system

Enter the database system password:
Enter the password for ECC DB user ECC (Passwords must be at least 8 characters long) :
Confirm the password for user ECC :
Creating ECC...
DECLARE
*
ERROR at line 1:
ORA-01543: tablespace 'ECC_TS' already exists
ORA-06512: at line 19

The user creating script failed. Please refer to the $ECC_BASE/Oracle/quickInstall/logs/setup.log for more information
Error code 7

 
ERROR
-----------------------
Confirm the password for user ECC :
Creating ECC...
DECLARE
*
ERROR at line 1:
ORA-01543: tablespace 'ECC_TS' already exists
ORA-06512: at line 19


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Executing 'envSetup.sh' in Step 3 of Section 4.3.1 of Note 2495053.1.

Cause

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