Upgrade Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 and Oracle Financial Services Applications(OFSA) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39 and Oracle

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39
1.Download Discoverer Administration Edition, Version 4.1.37

http://download.oracle.com/otn/nt/discoverer/10241_admin.zip

2. Install Discoverer Administration Edition, Version 4.1.37

3.Download Patch Discoverer Administration Edition, Version 4.1.48 (3201601)

4.Upgrade Discoverer Administration Edition Version 4.1.37 to 4.1.48

5.Download Patch 2902123 (OFSA 4.5.39 DATABASE DCP) Selecting a Platform of "Linux x86"

unzip p2902123_450_LINUX.zip

run dbs/patch_4538/patch_4538.sql

6.Download Patch Oracle Financial Services Applications (OFSA) 4.5.39 (2902123) Selecting a Platform of "MicroSoft Windows"

Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

7.Install 16 Bit and 32 Bit Oracle Financial Services Applications (OFSA) 4.5.39

General Protection Fault in Module SQL16W95.DLL Logging In to OFSA 4.5 From Windows 2000 or XP

General Protection Fault in Module SQL16W95.DLL Logging In to OFSA 4.5 From Windows 2000 or XP

Installing OFSA 4.5.39 ,After connect any application get error


Solutions

Remove or rename sql16w95.dll (it is not needed)

(or)

Start->Run box->Regedit

The script adds the following values to the key:
\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Windows NT\CurrentVersion\Compatibility

OFSPA:REG_SZ:0x00200000
OFSBC:REG_SZ:0x00200000
OFSPORTA:REG_SZ:0x00200000
OFSTP:REG_SZ:0x00200000
OFSRM:REG_SZ:0x00200000
PLUS33:REG_SZ:0x00200000
ORPING:REG_SZ:0x00200000

(or)

Create Regsitry file w2kofsa.reg and Add Bellow lines..

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Compatibility]
"OFSPA"="0x00200000"
"OFSBC"="0x00200000"
"OFSPORTA"="0x00200000"
"OFSTP"="0x00200000"
"OFSRM"="0x00200000"
"PLUS33"="0x00200000"
"ORPING"="0x00200000"

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