× Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…

R15 Model Bank Installation

  • inputter.t24
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thank you received: 0

inputter.t24 created the topic: R15 Model Bank Installation

Can someone share the steps (or the sequence) to be followed for the Installation of R15 Model Bank?

I am trying to install R15 Model Bank with TAFJ & Oracle on Windows.

Thanks in advance for the help.

regards,
Inputter.T24
#18263

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 3

mathew replied the topic: R15 Model Bank Installation

This is for Unix but you can follow the same steps

TAFJ INSTALLATION
=================

STEP 1: Extract the TAFJ file
STEP 2: Run the TAFJ.R15_GA.sh file

IMPORT Oracle Dump
==================

DATABASE CREATION:

Please take the assistance from your DBA for database, user and table space creation.

USER AND TABLE SPACE CREATION:

In the TAFJ installation <TAFJ_HOME> \dbscripts\oracle, you will find 2 SQL scripts:

• createtablespace_oracle.sql
• createuser_oracle.sql

You will need to edit this script to reflect the correct data. In the createtablespace_oracle.sql, you will need to change tablespace name and data file path:

1. The tablespace name
2. The full path to the file holding the data.

CREATE SMALLFILE TABLESPACE T24BD DATAFILE '/oracle/oradata/tafjdb/t24db.dbf' SIZE 7G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

In the createuser_oracle.sql, you will need to change the username, password & tablespace name.

CREATE USER tafj PROFILE "DEFAULT" IDENTIFIED BY tafj DEFAULT TABLESPACE T24BD TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO tafj;
GRANT "DBA" TO tafj;
GRANT "RESOURCE" TO tafj;

Once these values have been changed, launch a console and execute the queries as below:

>sqlplus / as sysdba

SQL> @createtablespace_oracle.sql

SQL> @createuser_oracle.sql

The database, user, password and table space details that we have used during the export process are

DB : orcl2
USER : tafj
PASSWORD : tafj
TABLESPACE : T24BD
Dump name : MB.R15.000.ORACLE11g.Training.20150430.dmp

If the schema name and tablespace names in the target database are same as the one created by us then,
impdp tafj/tafj directory=datadump_dir dumpfile= MB.R15.000.ORACLE11g.Training.20140430.dmp
logfile=datadump.log parallel=8
Eg: user: tafj
$ impdp tafj/tafj directory=datadump_dir dumpfile= MB.R15.000.ORACLE11g.Training.20150430.dmp
logfile= datadump.log parallel=8
Import: Release 11.2.0.3.0 - Production on Thu Jun 6 11:51:24 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "TAFJ"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TAFJ"."SYS_IMPORT_FULL_01": tafj/******** directory=datadump_dir dumpfile= MB.R15.000.ORACLE11g.Training.20150430.dmp logfile=datadump.log parallel=8
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"TAFJ" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

If the schema name and table space names are different then run the following (note the command must be on a single line):

$ impdp / directory=datadump_dir dumpfile= MB.R15.000.ORACLE11g.Training.20150430.dmp logfile=datadump.log REMAP_SCHEMA=tafj:schemaname REMAP_TABLESPACE=T24BD:Tablespacename parallel=8
Where:
schemaname = name of the schema owner
Tablespacename = name of the target tablespace

The value for parallel can be adjusted as required. Check the datadump.log for any errors.


DRIVER CONFIGURATION

The T24 ORACLE RDBMS Direct Connect driver is a middleware component between T24 and the ORACLE database. It enables T24 to send data to and retrieve data from ORACLE database storage.
Step 1: you need the specific database drivers you are targeting to go in $TAFJ_HOME/ext. Please find these drivers in $TAFJ_HOME/dbdrivers/oracle-11g and copy them to $TAFJ_HOME/ext

Step 2: LOADING JAVA STORED FUNCTIONS

• Check the path, the user and the password in the script files javaload / unload
• Launch the script javaload

Step 3: REFERENCING FUNCTIONS

• Start sqlplus
>sqlplus

• Connect with the user specified in the script files
Enter User-name: tafj
Enter password: tafj

• Execute javafunctions_oracle.sql [$TAFJ_HOME/dbscripts/oracle] as oracle user as below.

SQL> @javafunctions_oracle.sql


T24 MODEL BANK AREA
===================


• MB.R15.000.ORACLE11g.TAFJR15.Training.20150430.bnk.tar.gz

The following environment variables should be set in the tafj.properties [$TAFJ_HOME/conf]:

temn.tafj.directory.insert = Set the path of t24inserts directory

temn.tafj.directory.precompile = Set the path of t24lib directory & lib directory

temn.tafj.jdbc.url = jdbc:oracle:thin:@<IPADDRESS>:<PORT>:<DB>
eg., jdbc:oracle:thin:@10.92.4.104:1521:orcl

temn.tafj.jdbc.driver = oracle.jdbc.driver.OracleDriver

temn.tafj.jdbc.username = Set the user name eg., tafj

temn.tafj.jdbc.password = Set the user password eg., tafj


If all of the above steps are fine then the user should be able to Sign On to the T24 system in classic mode. If the users want to use Browser to connect to T24 then all the required components should be installed and configured.

Run the below command from $TAFJ_HOME/bin

>tRun EX

Note: All other TAFJ related documents are available in TAFJ_HOME\docs
#18270
The following user(s) said Thank You: sachinvanjara, inputter.t24

Please Log in or Create an account to join the conversation.

  • inputter.t24
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thank you received: 0

inputter.t24 replied the topic: R15 Model Bank Installation

Thanks Mathew for the detailed steps. Much appreciated.
#18283

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 0

vijaygubbi replied the topic: R15 Model Bank Installation

Hi Mathew,

Can we install TAFJ-R15 with out database like (SQL,MS-SQl etc) ?.

Thanks and Regards

Vijay Kumar
#18452

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 3

mathew replied the topic: R15 Model Bank Installation

As far as I heard, Temenos is not giving the modelbank with out an external DB anymore. For clients, the offered ones are Oracle,MSSQL or DB2 and for internal they are using H2. You may need to check with Temenos Distribution for the correct answer.

Cheers,
Mathew
#18454

Please Log in or Create an account to join the conversation.

  • Posts: 9
  • Thank you received: 0

KT100 replied the topic: R15 Model Bank Installation

Mathew .
Your threads and response, is great.
I am hoping you will assist me with my issue of helptext path.
I have R14, however , I Need to know how to attach the user path, so when I click on the Field , I will get the heptext.
I am business , so please advise, even if a detailed path and screen shot will be great.
K
#20132

Please Log in or Create an account to join the conversation.

  • Posts: 1
  • Thank you received: 0

srivatsav4111 replied the topic: R15 Model Bank Installation

CAN SOMEONE HELP ME HOW TO DOWNLOAD A MODEL BANK OF T24
#22339

Please Log in or Create an account to join the conversation.

  • Posts: 1
  • Thank you received: 0

Venkat2311 replied the topic: R15 Model Bank Installation

I am new to T24. I need to install in my home laptop. is it possible ? if so, can you help on how to get the necessary files.
Thanks in advance.
#22359

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 654
  • Thank you received: 93

VK replied the topic: R15 Model Bank Installation

Hi
T24 Model bank isn't something that anyone can download and install (could be great if it was). It's been supplied only to Temenos clients. If you work for one of them, contact This email address is being protected from spambots. You need JavaScript enabled to view it..

Cheers
VK
#22361
The following user(s) said Thank You: Venkat2311

Please Log in or Create an account to join the conversation.

Time to create page: 0.255 seconds