Oracle Demantra 12.2.9 Engine Deployment

 Oracle Demantra 12.2.9 Engine Deployment 

please follow Note 2069139.1 - 12.2.5.1 Engine Deployment Guide.

Prerequisites for Engine setup:

1. Selecting deployment type 64 bit or 32 bit.

Windows - By default the bin directory will contain 32 bit Engine binaries; in order to use the 64 bit Engine, user must run the RegEng64.bat once. In order to revert back to 32 bit Engine use: RegEng32.bat. The mentioned script files can be found under the Engine Root directory.

UNIX-Like OS – After performing a standard installation on a windows, the following Unix deliverables will be under the “LinuxDelivery\”directory:

• Oracle_Demantra_Linux_Engine.tar.gz

• Oracle_Demantra_Linux64_Engine.tar.gz

• Oracle_Demantra_Solaris_Engine.tar.gz

• Oracle_Demantra_Solaris64_Engine.tar.gz

Select the one appropriate for one’s system and deployment type and extract to the chosen folder.

 

 2. Oracle client – a FULL latest 64/32 bit Oracle 11g client (matching the chosen Engine type) must be installed on each machine where either Engine Manager or Engine is to be run and ORACLE_HOME set accordingly.

 

 

3. Oracle wallet - Oracle client deployment must include the tools (mkstore) to create an Oracle wallet repository. The alternative is to provide full connection details to Engine Manager, Engine Starter and Engine itself, including user and password in a clear text form. • Ds.ini or any other forms of storing connection credentials except for Oracle wallet are not supported

Step 1 : Copy Oracle_Demantra_Linux64_Engine.tar.gz To Linux

On Windows server go to Demantra Install Location 

Navigate to F:\Demantra\Linux Delivery

Oracle_Demantra_Linux64_Engine.tar.gz from windows server to linux server

Step 2 : Move Engine directory on Linux to a backup folder  if you have a previous install

Step 3: Untar Binaries which is copied from Windows server 

cd to demantra base install directory 

tar -xvf Oracle_Demantra_Linux64_Engine.tar.gz <-- This will create Engine directory and untar everything under that folder

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 &