zz ofsa install log

---

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

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博客 ” ，链接：http://blog.itpub.net/22977/viewspace-715471/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22977/viewspace-715471/