× 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
More
8 years 5 months ago - 8 years 5 months ago #18263 by inputter.t24
R15 Model Bank Installation was created by inputter.t24
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
Last edit: 8 years 5 months ago by inputter.t24.

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

More
8 years 5 months ago #18270 by mathew
Replied by mathew on 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
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
More
8 years 5 months ago #18283 by inputter.t24
Replied by inputter.t24 on topic R15 Model Bank Installation
Thanks Mathew for the detailed steps. Much appreciated.

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

More
8 years 4 months ago #18452 by vijaygubbi
Replied by vijaygubbi on 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

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

More
8 years 4 months ago #18454 by mathew
Replied by mathew on 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

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

More
7 years 6 months ago #20132 by KT100
Replied by KT100 on 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

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

More
4 years 6 months ago #22339 by srivatsav4111
Replied by srivatsav4111 on topic R15 Model Bank Installation
CAN SOMEONE HELP ME HOW TO DOWNLOAD A MODEL BANK OF T24

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

More
4 years 6 months ago #22359 by Venkat2311
Replied by Venkat2311 on 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.

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
4 years 5 months ago #22361 by VK
Replied by VK on 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
The following user(s) said Thank You: Venkat2311

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

  • freddy.sebastian@fds.co.id
  • Offline
  • New Member
  • New Member
More
3 years 9 months ago #22775 by freddy.sebastian@fds.co.id
Replied by freddy.sebastian@fds.co.id on topic R19 Model Bank Installation
Please information and solution this problem ==> TAFJ Java Functions Version in DB : NOT FOUND ,R19 model bank instalation
Attachments:

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

More
3 years 7 months ago #22869 by vishnumenon
Replied by vishnumenon on topic R19 Model Bank Installation
Hello Freddy,
Have you found the solution for this issue as i am also having the same issue as yours.

regards

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

Time to create page: 0.154 seconds