Oracle

This section provides details about the database objects, backup and recovery strategies, XML Schema Definition Pre-requisites, and sample database creation scripts for Oracle.

Database Objects

You need to create the following objects on the target database.

Object	Action
Table spaces	Create two tablespaces in each of the database, one each to store data and indexes, with auto-extend functionality.
User	Create user with sufficient privileges and grant unlimited quota to the user on both the tablespaces created.

Backup and Recovery Strategies

There are two standard backup types for Oracle—offline and online. You can choose the backup mode depending on whether the application can be shut down or not. If yes, offline mode is the best. If no, online mode needs to be used. Both these methods require the following.

Database must be in archive log mode to enable point-in-time recovery using Oracle online and archived redo logs.
Temenos Transact backup must be restored at the same time as the database backup, which means, the Temenos Transact backup and offline backup must start simultaneously, should both be restored.

XML Schema Definition Pre-requisites

The Oracle Structured Storage (XML DB) usage requires an Oracle Schema Directory (SCHEMA_DIR) configured for the database. This directory is used when registering the XML Schema Definitions.

create or replace directory SCHEMA_DIR as‘c:\t24\bnk\bnk.run\schema’ ;grant all on directory schema_dir to public;

In addition, you need to create an Oracle folder to serve as a repository for the XML schema definitions documents (.xsd) using the following script.

declare result boolean;
begin
result := dbms_xdb.createFolder(‘/public/t24’);
end;
/

You can execute the above commands from the options in config-XMLORACLE. To run the createResource and createFolder commands you must get access to be the XDBADMIN from the administrator.

grant xdbadmin to t24;
grant create any directory to t24;

The XML schema definitions are normally registered when creating the XML DB table using CREATE-FILE. However, you can also create and register the XML schema definitions manually suing the following scripts.

To create XML schema definition

declare result boolean;
begin result := dbms_xdb.createResource(
abspath => ‘public/t24/ACCOUNT.xsd',
data => BFILENAME('SCHEMA_DIR','ACCOUNT.xsd'));
end;
/

To register XML schema definition

begin
DBMS_XMLSCHEMA.REGISTERSCHEMA(
         schemaurl => 'http://localhost:8080//public/t24/ACCOUNT.xsd',
         schemadoc => sys.UriFactory.getUri('/public/t24/ACCOUNT.xsd')
);
end;
/

The DELETE-FILE command automatically de-registers the XML schema definitions if the table is the last table associated with the XML Schema. However, you can also delete the XML schema definitions manually suing the following scripts.

To de-register XML schema definition

begin
dbms_xmlschema.deleteSchema(
SCHEMAURL => '/public/t24/ACCOUNT.xsd',
DELETE_OPTION => dbms_xmlschema.DELETE_CASCADE_FORCE);
end;
/

To delete XML schema definition resource

sql> CALL DBMS_XDB.deleteresource('/public/t24/ACCOUNT.xsd');

To delete SCHEMA_DIR folder

sql> CALL dbms_xdb.deleteresource('/public/t24');

Sample Database Creation Scripts

This section provides example sql scripts to create a sample Oracle database named BENCHORA, data and index table spaces and schema owner.

Key Parameter File settings

The following table lists the key parameters and their adjusted settings to be used for a database installation for use with Temenos Transact.

NOTE: The sizes are based on Benchmarking settings and may need to be adjusted for smaller installations.

Parameter	Settings
db_block_size	8192
open_cursors	5000
db_file_multiblock_read_count	16
query_rewrite_enabled	TRUE
Query_rewrite_integrity	TRUSTED
compatible	10.2.0.1
star_transformation_enabled	FALSE
Fast_start_mttr_target	0
undo_management	AUTO
undo_tablespace	UNDOTBS1
open_cursors	5000
filesystemio_options	SETALL
cursor_sharing	EXACT
optimizer_index_cost_adj	1

The optimization of the following key parameter settings is the responsibility of the DBA depending on the size of the OLTP data.

asjava_pool_size
db_cache_size
sort_area_size
large_pool_size
shared_pool_size
log_buffer
pga_aggregate_target
sort_area_size

NOTE: For more details, refer http://docs.oracle.com/

Dark Mode

Expand/Collapse

In this topic