---

URL: http://szapps2.cn.oracle.com:9080/ofsa51

Apps user: scsadmin/scs123

appadm/scs123

ftpadm/scs123

almadmin

pftadmin/scs123

Sys user:

sysauth/scs123

sysadmn/scs123

-----

0, IP: 10.182.114.182

oracle/oracle

root/oracle

1, Install Oracle database 112gR2

Media:

Install folder:

/home/oracle/Oracle11g/oracle/product/11.2.0/dbhome_1

SID: ofsa

character set: AL16UTF16

NLS_LENGTH_SEMANTICS: BYTE

setup environment variable

ORACLE_HOME=/home/oracle/Oracle11g/oracle/product/11.2.0/dbhome_1

ORACLE_SID=ofsa

PATH=$PATH:$ORACLE_HOME/bin

database password SYS/SYSTEM, haofei99

OFSA configure user:

create user ofsain identified by ofsain;

2, Install JDK 6u20

/home/oracle/jdk620/jdk620

3, Install Apach Tomcat

/home/oracle/tomcat6020

set:

CATALINA_HOME: /home/oracle/tomcat6020

4, Install OFSA infarstruture

Media: /home/oracle/software/ofsa/OFSII

./Setup.sh

813776-796739-858330-303336-422436-468766-751913-788009-958913-734233

EDELIVERY

Single Tier

Folder: /home/oracle/ofsaa

Webserver: Tomcat

Configure OFSAAI Web service

No

Java executables: /home/oracle/jdk620/jdk620/bin

Server detail

IP address/hostname of server: ofsa51

IP address/hostname of database engine: ofsa51

context name for deployment: ofsa51

Tomcat installation path: /home/oracle/tomcat6020/webapps

DB components:

User: ofsain

password: ofsain

port: 1521

Oracle Driver path:

/home/oracle/Oracle11g/oracle/product/11.2.0/dbhome_1/jdbc/lib

Java Port/Native Port

Java Port: 9999

Native Port: 6666

Agent Port: 6510

ICC server port: 6507

ICC Native Port: 6509

Servlet Port: 9080

Message server port: 6501

Router Port: 6500

AM port: 6505

Locale: en_US.iso88591

User Type: SMS Users

--

INSTALLATION SUMMARY:

--------------------

#FATAL ERRORS-----: 0

#ERRORS-----------: 0

#DEBUG STATEMENTS: 0

#INFORMATIONS-----: 88

#WARNINGS---------: 0

-------------------

Notice:

Please see the installation log under /home/oracle/ofsaa/configReveleus.log and /home/oracle/ofsaa/OFSAAInfrastructure_Install.log, for more details.

Click on Next to continue.

---

5, Edit Tomcat user administration

file: /home/oracle/tomcat6020/conf/tomcat-users.xml

add manager role to user

6, Setup tomcat java bin

file: /home/oracle/tomcat6020/bin/setclasspath.sh

_RUNJAVA="$JAVA_BIN"/java

_RUNJDB="$JAVA_BIN"/jdb

_RUNJAVAC="$JAVA_BIN"/javac

7, Change the Tomcat port

file: /home/oracle/tomcat6020/conf/server.xml

8, Create war of web server, a war file(Context name) will be created

folder: $FIC_WEB_HOME

command: ./ant.sh

A war file create: /home/oracle/ofsaa/ficweb/ofsa51.war

9, Deploy war file

a, start tomcat

folder: /home/oracle/tomcat6020/bin

command: startup.sh

b, deploy WAR file on server

Context Path: /ofsa51

WAR of Directory URL: /home/oracle/ofsaa/ficweb/ofsa51.war

10, Start INfrastructure

su - oracle

. .profile

a, start Infrastructure Server

cd $FIC_APP_HOME/common/FICServer/bin

./reveleussstartup.sh

key in Oracle config schema password: ofsain/oracle

b, start Tomcat

cd $TOMCAT/bin

./catalina.sh run

c, start ICC server

cd $FIC_HOME/ficapp/icc/bin

./iccserver.sh

d, start Infrastructure database components

cd $FIC_DB_HOME/bin

./agentstartup.sh

f, start Infrastructure Admin console

cd $FIC_HOME/ficapp/common/FICServer/bin

./AdminConsole.sh

New password: scs123

question: hello

answer: hello

11, Log in application

Default user: SYSADMN/scs123

SYSAUTH

URL: http://10.182.114.182:9080/

http://10.182.114.182:9080/ofsa51

12, Configure Infrastructure

create ftp share folder: /home/oracle/ftpshare

a, Server detail: database server

drive: /home/oracle/ftpshare/

port: 21

user/passwd: oracle/oracle

security user/passwd: oracle/oracle

security share name: ftpshare

b, Server detail: application server

drive: /home/oracle/ftpshare/

port: 21

user/passwd: oracle/oracle

c, server detail: web server

servlet port: 9080

Is Primary: Y

Local path: /home/oracle/ftpshare/weblocal

ftp enabled: Y

ftp details

drive: /home/oracle/ftpshare

port number: 21

user/passwd: oracle/oracle

13, Configur database details

IP address: ofsa51

Type: ORACLE

Name: ofsa

user id/passwd: ofsadom/ofsadom (This is a infodom user)

----

create user ofsadom identified by ofsadom;

grant connect, resource, dba to ofsadom;

---assign view to ofsadom from ofsain---

grant select on CSSMS_USR_PROFILE to ofsadom;

grant select on CSSMS_ROLE_MAST to ofsadom;

grant select on CSSMS_GROUP_MAST to ofsadom;

grant select on CSSMS_FUNCTION_MAST to ofsadom;

grant select on CSSMS_USR_GROUP_MAP to ofsadom;

grant select on CSSMS_USR_GROUP_DSN_SEG_MAP to ofsadom;

grant select on CSSMS_ROLE_FUNCTION_MAP to ofsadom;

grant select on CSSMS_GROUP_ROLE_MAP to ofsadom;

grant select on CSSMS_SEGMENT_MAST to ofsadom;

----

JDBC Driver Name: oracle.jdbc.driver.OracleDriver

JDBC Connection String: jdbc:oracle:thin:@ofsa51:1521:ofsa

Date Format: mm-dd-yyyy

Block Size: 8192

14, Configure a Information Domain

Name: OFSA51INFODOM

desc: OFSA51INFODOM

database server: ofsa51

database name: ofsa

OLAP server: 127.0.0.1

OLAP Type: ESSBASE

Paths on the App Server

ERWIN File Path:

15, Configure Resource reference in Infrastructure app

cd $FIC_WEB_HOME/webroot/WEB-INF/web.xml

change

DB Connection ORDEMO

jdbc/ORDEMO

javax.sql.DataSource

Container

to

DB Connection OFSA51INFODOM

jdbc/OFSA51INFODOM

javax.sql.DataSource

Container

16, Configure Resource Reference in Tomcat

a, copy odjbc6.jar

from /home/oracle/Oracle11g/oracle/product/11.2.0/dbhome_1/jdbc/lib

to /home/oracle/tomcat6020/lib/

17, Create data source in Tomcat

cd $TOMCAT_HOME/conf/server.xml

add following lines:

ssName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@ofsa51:1521:ofsa" username="ofsad

om" password="ofsadom" maxActive="20" maxIdle="10" maxWait="-1"/>

18, recreate WAR and deploy

Context Path: /ofsa51

WAR of Directory URL: /home/oracle/ofsaa/ficweb/ofsa51.war

/home/oracle/ofsaa/ficweb/ofsa51.war_bak

========================================

19, Upload data model

Unified Metadata Manager -> Import Model

Choose Type of Upload: Complete

Pick file from the Server: Y

20, Install Application: FTP

Unified Metadata Manager -> Technical Data Management -> Data Integrator

Source Designer -> Define Sources

a. Create Applications:

FSAPP_T2T and FUSION_APPS

b, Define data source

aa.Source Name: FS_SOURCE

Source Type: RDBMS

UserID: ofsadom/ofsadom

database name: ofsa

table owner: ofsadom

Source date format: mm/dd/yyyy

Database: Oracle

TNSName: ofsa

Locale: en_US.UTF-8

bb. Source Name: STAGING_SOURCE_F2T

Source Date Format: mm/dd/yyyy

cc. Source Name: STAGING_SOURCE_T2T

Source Type: RDBMS

UserID: ofsadom/ofsadom

database name: ofsa

table owner: ofsadom

Source date format: mm/dd/yyyy

Database: Oracle

TNSName: ofsa

Locale: en_US.UTF-8

c, Map source to application

Map data source FS_SOURCE

to application FSAPP_T2T.

Map data sources STAGING_SOURCE_F2T and STAGING_SOURCE_T2T

to application FUSION_APPS.

d, Generate Source Model for the following.

FS_SOURCE

STAGING_SOURCE_T2T

Select the Erwin or Catalog option. When "Catalog" option is selected, the source model is generated by establishing a JDBC connection and reading the database metadata. When Erwin option is selected

e, shutdown all infra services

f, chmod +x Setup.sh Setup.bin libcpptripledes.so

Notes: please modified Setup.sh to remove hidden characters

Log model: Debug

9 digital CIS: EDELIVERY

OFSAAI Layers: App Layer, DB Layer, Web Layer

Confugre Admin BI: Admnistrative Reports

Information Domain Name: OFSA51INFODOM

local ftpshare area: /home/oracle/ftpshare

TNS name: ofsa

Oracle BI Host IP: ofsa51

Port: 9704

Contextname: analytics

OFSAAI user id: scsadmin

g, for the BI admin

please refer Readme_AdminBI_PostInstall_Steps.txt under $FIC_HOME/adminbi

h, recreate WAR and deploy

Context Path: /ofsa51

WAR of Directory URL: /home/oracle/ofsaa/ficweb/ofsa51.war

21, Install Application: PFT

All the pre-requisisted stepsa are the same as FTP, so we will ignore those steps

a, Log model: Debug

9 digital CIS: EDELIVERY

OFSAAI Layers: App Layer, DB Layer, Web Layer

Confugre Admin BI: Admnistrative Reports

Information Domain Name: OFSA51INFODOM

local ftpshare area: /home/oracle/ftpshare

TNS name: ofsa

Oracle BI Host IP: ofsa51

Port: 9704

Contextname: analytics

OFSAAI user id: scsadmin

b, for the BI admin

please refer Readme_AdminBI_PostInstall_Steps.txt under $FIC_HOME/adminbi

c, Check web.xml file at: /home/oracle/ofsaa/ficweb/webroot/WEB-INF

pftxmlfilepath

com.ofs.fsapps.pft.util.ContextxmlPathLoader

1

make sure above section is ready

d, recreate WAR and deploy

Context Path: /ofsa51

WAR of Directory URL: /home/oracle/ofsaa/ficweb/ofsa51.war

e, start infra and tomcate, map roles to user group: scsadmin

PFT admin privilege, Authorize the User and Map the user to PFT application groups

22, Install Application: ALM

a, Apply ALM patch:

aa, unzip file OFSAAI_Patch.zip

bb, chmod +x UpdateOFSAAI.sh

cc, ./UpdateOFSAAI.sh

Enter config user/password: ofsain/oracle

Enter SID of config: ofsa

b, Change ftp share folder property

chmod -R 777 ftpshare

c, Create a new tablespace:DATA_TS

create tablespace DATA_TS datafile '/home/oracle/Oracle11g/oracle/oradata/ofsa/datats.dbf' size 500M

d, Log model: Debug

9 digital CIS: EDELIVERY

OFSAAI Layers: App Layer, DB Layer, Web Layer

Confugre Admin BI: Admnistrative Reports

Information Domain Name: OFSA51INFODOM

local ftpshare area: /home/oracle/ftpshare

TNS name: ofsa

Oracle BI Host IP: ofsa51

Port: 9704

Contextname: analytics

OFSAAI user id: scsadmin

e, recreate and redeploy WAR

e, map user with follow group

ALM admin privilege, Authorize the User and Map the user to ALM application groups

==================

1, Install OBIEE 10.1.3.4.1

Install Type: All components

Basic: Minimum security

user: oc4jadmin

password: oracle1

Start OBIEE

/home/oracle/obiee/stetup/oc4j -start

2, cp /home/oracle/ofsaa/adminbi/bi/server/Repository/Fusion_Admin.rpd .

3, cd /home/oracle/obiee/obidata/web/catalog

cp -r /home/oracle/ofsaa/adminbi/bidata/web/catalog/* .

4, cd /home/oracle/obiee/server/Config

edit NQSConfig.INI

Star = Fusion_Admin.rpd, DEFAULT;

5, cd /home/oracle/obiee/obidata/web/config

edit file instanceconfig.xml

/home/oracle/obiee/obidata/web/catalog/FusionAdmin

cd /home/oracle/obiee/oc4j_bi/j2ee/home/applications/analytics/analytics

cp /home/oracle/ofsaa/adminbi/Page_adminbi.jsp .

6, Open Repository file: Fusion_Admin.rpd

User/password: Administrator/Administrator

Physical tier, data source: ofsa

Shared Logon, user/password: ofsadom/ofsadom

7, edit file: /home/oracle/obiee/obidata/web/config/instanceconfig.xml

add following lines

http://10.182.112.209:9704/analytics/saw.dll?Logoff

http://10.182.112.209:9704/analytics/Page_adminbi.jsp

8, edit file: /home/oracle/obiee/obidata/web/config/credentialstore.xml

add following lines

Administrator

9, Manage OBIEE

$export BI_HOME=/opt/oracle/product/OracleBI

#Start the BI sever

$$BI_HOME/setup/run-sa.sh start

#Start the presentation service

$$BI_HOME/setup/run-saw.sh-start

#Start the scheduler

$$BI_HOME/setup/run-sch.sh start

#Start the cluster controller – only required when BI servers clustered

$$BI_HOME/setup/run-ccs.sh start

Shutdown the BI services

Set the BI_HOME to the Oracle BI Home path e.g. /opt/oracle/product/OracleBI

$export BI_HOME=/opt/oracle/product/OracleBI

#Stop the cluster controller – only required when BI servers clustered

$$BI_HOME/setup/run-ccs.sh stop

#Stop the BI sever

$$BI_HOME/setup/run-sa.sh stop

#Stop the presentation service

$$BI_HOME/setup/run-saw.sh stop

#Stop the scheduler

$$BI_HOME/setup/run-sch.sh stop

If the above fail to shutdown the services, use forcestop instead

$$BI_HOME/setup/run-saw.sh forcestop

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22977/viewspace-715471/ ，如需转载，请注明出处，否则将追究法律责任。

ITPub博客

zz ofsa install log

最新文章