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