ERROR DB error (/scratch/demlin/dem_engine/llg00ekt/HEAD/engine2k/Source6.3DLL/Common/DB/DB_Oracle.cpp:1284, 14:47:13) Case (7): Database error: OCCI interface raised Oracle OCCI exception. Description: ORA-00959: tablespace 'DEMANTRA_SALES_IDX' does not exist

 ERROR : 

15:12:05:948 ERROR DB error (/scratch/demlin/dem_engine/llg00ekt/HEAD/engine2k/Source6.3DLL/Common/DB/DB_Oracle.cpp:1284, 14:47:13)

Case (7): Database error: OCCI interface raised Oracle OCCI exception.

Description: ORA-00959: tablespace 'DEMANTRA_SALES_IDX' does not exist

Solution : 

Navigate to $ENGINE_ROOT folder and execute setup.sh again 

Using a secure Oracle wallet (creating a new wallet repository):

1. Run “Setup.sh” script

2. When prompted provide the following details:

o DB Hostname – The DB machine host name

o Port – The DB server listener port

o Service Name – The DB service/sid name

 o Username – The user name for your Demantra schema

o Password – The Schema password that should be used for Engine run.

o Oracle wallet password – Provide a password to protect the newly created wallet repository, you will be asked to retype this password again for verification and a third time to add the actual credentials into the wallet. Password should at least be of 8 characters long, please memorize it in case you want to manually change the existing wallet credentials.

 

3. After setup process completes successfully a default wallet connection name “DEM_CONN” pointing to the specified DB schema user will be created and stored in a new directory “TNS_ADMIN” that will also contain the required “tnsnames.ora” and “sqlnet.ora” files.

 4. Setup will create and automatically run the sql script UpdatEngPath.sql which updates the new SYS_PARAMS parameter “EngineBasePath” which is used by workflow to identify where Engine is deployed. This path will be accessible in workflow via a new token “#EngineBasePath#” that can then be used to call any of the Engine scripts. 5. System admin/DBA is responsible to modify the security privileges for the newly created wallet files so only the intended user/s can have access to them. For example: allow only read access to the user running the engine but read/write access to admin.

Example of setup process:

Setup.sh

Enter Hostname: <db hostname or scan host name>

Enter Port: 1521

Enter Service Name: <service name>

Enter Username: <Demantra schema name>

Preparing DEM_CONN Credential. You will be asked to choose a password to protect the newly created wallet(8 symbols)

Oracle Secret Store Tool : Version 12.1.0.2

Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.

Enter password: mywalletpass1

Enter password again: mywalletpass1

d:\Eng_Matlab_Test_64bit\engine2k\Source6.3DLL\install\TNS_ADMIN Preparing DEM_CONN Credential. You will be asked to supply wallet password(8 symbols) Oracle Secret Store Tool : Version 11.2.0.1.0 - Production Copyright (c) 2004, 2009, Oracle and/or its affiliates. All rights reserved.

Enter password: mywalletpass1

Enter password again: mywalletpass1 Oracle Secret Store Tool : Version 11.2.0.1.0 - Production Copyright (c) 2004, 2009, Oracle and/or its affiliates. All rights reserved.

Enter wallet password: mywalletpass1 Create credential oracle.security.client.connect_string1 Wallet Created DEM_CONN for my_schema_name

Step 4 : After completing the setup , Start the Engine 

./EngineStarter.sh &