OFSA安装

纵横四海

---
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
<tomcat-users>
  <role rolename="manager"/>
  <user username="admin"  password="admin" roles="manager"/>
</tomcat-users>

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     
    <resource-ref>
        <description>DB Connection ORDEMO</description>
        <res-ref-name>jdbc/ORDEMO</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
    to
   <resource-ref>
        <description>DB Connection OFSA51INFODOM</description>
        <res-ref-name>jdbc/OFSA51INFODOM</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

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:
<Context path="/ofsa51" docBase="/home/Oracle/tomcat6020/webapps/ofsa51" crossContext="tru
e" reloadable="true" debug="1">
<Resource name="jdbc/OFSA51INFODOM" auth="Container" type="javax.sql.DataSource" driverCla
ssName="Oracle.jdbc.OracleDriver" url="jdbc:Oracle:thin:@ofsa51:1521:ofsa" username="ofsad
om" password="ofsadom"  maxActive="20" maxIdle="10" maxWait="-1"/>
</Context>
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
       <servlet>
           <servlet-name>pftxmlfilepath</servlet-name>
           <servlet-class>com.ofs.fsapps.pft.util.ContextxmlPathLoader</servlet-class>
           <load-on-startup>1</load-on-startup>
       </servlet>
      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
   <CatalogPath>/home/Oracle/obiee/obidata/web/catalog/FusionAdmin</CatalogPath>
   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
<Listener>
<Firewall>
<Allow address="127.0.0.1"/>
<Allow address="10.182.112.209"/>
</Firewall>
</Listener>
<Auth>
<SSO enabled="true">
<LogoffUrl>http://10.182.112.209:9704/analy ... f</LogoffUrl>
<LogonUrl>http://10.182.112.209:9704/analy ... sp</LogonUrl>
<ParamList>
<Param name="IMPERSONATE" source="httpHeader" nameInSource="REMOTE_USER" />
</ParamList>
</SSO>
</Auth>
<CredentialStore>
<CredentialStorage type="file" path="/home/Oracle/obiee/obidata/web/config/credentialstore.xml" passphrase=""/>
</CredentialStore>
8, edit file: /home/Oracle/obiee/obidata/web/config/credentialstore.xml
   add following lines
<sawcs:credential type="usernamePassword" alias="impersonation">
<sawcs:username>Administrator</sawcs:username>
<sawcs:password>Administrator</sawcs:password>
</sawcs:credential>

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





该贴已经同步到 纵横四海的微博

distantlily

不好意思，链接打不开{:soso_e121:}