OFSA Clinet Installing..

Install OFSA Clinet 4.5.2

1 . Download Oracle® Financial Services Client Release 4.5.2 for MS Windows .

2. Install OFSA Oracle Client 16 Bit ...

3. Install OFSA Oracle Client 32 Bit...

4. Edit OFS.ini file in Windows Directory and Change Database Source
(eg. Username,Database Name,Connection string)

5. Set Env.. in Oracle Clinet 16 Bit.

6.Change Tnsnames.ora in 16 bit ORACLE_HOME and 32 bit ORACLE_HOME

OFSA Installing Step 4.5.2

OFSA 4.5.2
OFSA Server Configuration 4.5.2.

1. Install Discoverer 3.1

2. Install Oracle Database 8.1.74
Oracle_Home_Name = OFSA_HOME
Oracle_HOME = c:\ofsademo
Oracle_sid = ofsademo

After database installed..Change password sys,system users
eg.
Alter user sys identified by oracle;
Alter user system identified by oracle;

3. Create Tablespaces
1.rollback_ts
2.rollback_ts01
3.temp_ts(TEMPORARY)
4.data_ts
5.index_ts

eg.
create tablespace rollback_ts datafile
'C:\OFSADEMO\ORADATA\OFSADEMO\ROLL_01.DBF' size 2048M;
create tablespace rollback_ts01 datafile
'C:\OFSADEMO\ORADATA\OFSADEMO\ROLLBACK_01.DBF' size 2048M;
create temporary tablespace temp_ts tempfile
'C:\OFSADEMO\ORADATA\OFSADEMO\TEMP_01.DBF' size 2048M;
create tablespace data_ts datafile
'C:\OFSADEMO\ORADATA\OFSADEMO\DATA_01.DBF' size 5128M;
create tablespace index_ts datafile
'C:\OFSADEMO\ORADATA\OFSADEMO\INDEX_01.DBF' size 3078M;

4. Alter System Tablespace
eg.
alter database datafile 'C:\OFSADEMO\ORADATA\OFSADEMO\SYSTEM01.DBF' resize 5128M;

5.Create Rollback Segment's
eg.
create rollback segment r01 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r02 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r03 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r04 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r05 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r06 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r07 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );
create rollback segment r08 tablespace rollback_ts
storage (initial 1M next 1M minextents 2 optimal 4M );

alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
alter rollback segment r05 online;
alter rollback segment r06 online;
alter rollback segment r07 online;
alter rollback segment r08 online;

6.Download Patch 4464191 (OFSA 4.5 RELEASE 2 DATABASE DCP) selecting a Platform of "Linux x86" (any os working script)

7.After download change folder
run dbs\452000001\master\cr_owner.sql
==>username = ofsademo
8.Download Patch 2178396 for Demo Database (Not Available for Reporting).

9.Change Parameter in init.ora values max_enabled_roles = 60 (if not change import fail)

10.After Download Demo Database to Import

eg,
IMP USERID=ofsademo/ofsademo FILE=c:\ofsademo_45.dmp SHOW=n IGNORE=Y GRANTS=Y INDEXES=Y ROWS=Y LOG=c:\imp_ofsa.log DESTROY=n FULL=Y COMMIT=Y

11. After Connect Sql

sqlplus ofsademo/ofsademo

select * from ofsa_version;
APP_NAME VERSION
-----------------------
Database 452000013
Server 452000001
Client 452000001