ITPub博客

首页 > Linux操作系统 > Linux操作系统 > zz ofsa install log

zz ofsa install log

原创 Linux操作系统 作者:FishPerfect 时间:2012-02-01 22:57:23 0 删除 编辑
---
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论