'My Works/COGNOS'에 해당되는 글 4건

  1. 2013.03.05 IBM Cognos BI 10.2 64-bit with Oracle 11gR2 64-bit on RHEL 6.1 64-bit 2
  2. 2012.05.25 Cognos 10.1.1 (64-bit) with Oracle 11g r2 (64-bit)
  3. 2012.04.04 [scrap]COGNOS 8 BI PROCESS ARCHITECTURE AND CAPACITY PLANNING
  4. 2010.03.29 [COGNOS81MR2] Run Script시 주의사항

IBM Cognos BI 10.2 64-bit with Oracle 11gR2 64-bit on RHEL 6.1 64-bit

|

메모


해당 환경의 경우 RHEL 6.1 64-bit에 추가 설치할 kernel은 무척 많아 귀찮기는 하지만 그 외의 부분에선 무척 깔끔하게 잘 설치됩니다.


기존 IBM Cognos BI 10.1.1 64-bit에 Oracle 11gR2 64-bit 사용시 32-bit Client를 별도로 설치해야하는 번거로움이 없어졌습니다.


다만 달라진 부분은 RHEL 6.1 64-bit에는 Oracle 11gR2 32-bit 설치가 불가한 것으로 보입니다.



참고


Required Patches for install IBM Cognos BI 10.2 on Red Hat Enterprise Linux 6.1


32-bit compatibility libraries


glibc-2.12-1.25.el6.i686

libstdc++-4.4.5-6.el6.i686

nspr-4.8.7-1.el6.i686

nss-3.12.9-9.el6.i686

openmotif-2.3.3-1.el6.i686


Required Patches include dependencies


rpm -ivh --nodeps glibc-2.12-1.47.el6.i686.rpm

rpm -ivh nss-softokn-freebl-3.12.9-11.el6.i686.rpm

rpm -ivh libgcc-4.4.6-3.el6.i686.rpm

rpm -ivh libstdc++-4.4.6-3.el6.i686.rpm

rpm -ivh nspr-4.8.8-3.el6.i686.rpm

rpm -ivh nss-util-3.12.10-2.el6.i686.rpm

rpm -ivh zlib-1.2.3-27.el6.i686.rpm

rpm -ivh ncurses-libs-5.7-3.20090208.el6.i686.rpm

rpm -ivh readline-6.0-3.el6.i686.rpm

rpm -ivh sqlite-3.6.20-1.el6.i686.rpm

rpm -ivh nss-softokn-3.12.9-11.el6.i686.rpm

rpm -ivh nss-3.12.10-16.el6.i686.rpm

rpm -ivh libICE-1.0.6-1.el6.i686.rpm

rpm -ivh libuuid-2.17.2-12.4.el6.i686.rpm

rpm -ivh libSM-1.1.0-7.1.el6.i686.rpm

rpm -ivh libXau-1.0.5-1.el6.i686.rpm

rpm -ivh libxcb-1.5-1.el6.i686.rpm

rpm -ivh libX11-1.3-2.el6.i686.rpm

rpm -ivh libXext-1.1-3.el6.i686.rpm

rpm -ivh expat-2.0.1-9.1.el6.i686.rpm

rpm -ivh freetype-2.3.11-6.el6_1.7.i686.rpm

rpm -ivh fontconfig-2.8.0-3.el6.i686.rpm

rpm -ivh libXrender-0.9.5-1.el6.i686.rpm

rpm -ivh libXt-1.0.7-1.el6.i686.rpm

rpm -ivh libXft-2.1.13-4.1.el6.i686.rpm

rpm -ivh libXmu-1.0.5-1.el6.i686.rpm

rpm -ivh libXp-1.0.0-15.1.el6.i686.rpm

rpm -ivh libjpeg-6b-46.el6.i686.rpm

rpm -ivh libpng-1.2.46-1.el6_1.i686.rpm

rpm -ivh openmotif-2.3.3-4.el6.i686.rpm


Set Apache HTTP Server


.bash_profile


# Add


LD_LIBRARY_PATH=/home/cognos/c10_64/cgi-bin

export LD_LIBRARY_PATH



httpd.conf


# Change


User cognos

Group cognos


# Add


LoadModule cognos_module "/home/cognos/c10_64/cgi-bin/mod2_2_cognos.so"


ScriptAlias /ibmcognos/cgi-bin "/home/cognos/c10_64/cgi-bin"

<Directory "/home/cognos/c10_64/cgi-bin">

AllowOverride None

Options None

Order allow,deny

Allow from all

</Directory>

Alias /ibmcognos "/home/cognos/c10_64/webcontent"

<Directory "/home/cognos/c10_64/webcontent">

Options Indexes MultiViews

AllowOverride None

Order allow,deny

Allow from all

</Directory>


And

Cognos 10.1.1 (64-bit) with Oracle 11g r2 (64-bit)

|

Cognos 10.1.1 (64-bit) with Oracle 11g r2 (64-bit)


-- Title : confiuration cognos 10.1.1 64-bit with oracle 11g on linux (unix)
-- Author : Kim, Jongbum

-- Tested on
-- rhel 5.3 64-bit (os)
-- cognos 10.1.1 64-bit (cognos)
-- jre 1.6.0_31-b04 64-bit (java)
-- oracle database 11g enterprise edition release 11.2.0.1.0 - 64-bit production (rdbms)
-- custom java provider (auth)

.profile

Oracle 11g r2 (64-bit)의 경우 Oracle instance client 11g r2 (32-bit) 설치 후 LD_LIBRARY_PATH를 $ORACLE_CLIENT_HOME/lib으로 설정해야합니다.

Oracle 11g r1 (64-bit)의 경우는 lib32가 존재한다고 합니다. ( test 해보지 못했습니다)
Cognos 10.1.1 이후 버전에서는 테스트가 필요합니다.

oracle env

Oracle Server 부터 설치하는 경우 listener와 tnsnames가 localhost 등으로 되어있는 경우 내부 접속만 가능하므로 ip나 domain으로 변경해주는 작업이 필요합니다.


listener.ora

# listener.ora Network Configuration File: /data/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl.localdomain)
      (SID_NAME = orcl)
      (ORACLE_HOME = /data/oracle/product/11.2.0/dbhome_1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.47.129)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /data/oracle


tnsnames.ora

# tnsnames.ora Network Configuration File: /data/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.47.129)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = orcl.localdomain)
      (SID = orcl)
    )
  )

oracle script
select * from global_name
;
select value
  from v$parameter
 where name = 'service_names'
;
shell command
lsnrctl status/start/stop


And

[scrap]COGNOS 8 BI PROCESS ARCHITECTURE AND CAPACITY PLANNING

|

COGNOS 8 BI PROCESS ARCHITECTURE AND CAPACITY PLANNING

Spent half an hour sketching up Cognos process architecture — what goes where and when. Will refer to this drawing in my future hardware planning assigments ;)

 

Comments:

  1. You can separate all components (Gateway, Application Server, Content Manager) into separate machines
  2. There can be only one Content Manager service active in cluster at a time
  3. There may be multiple gateway servers, as I was corrected. What I originally meant was close to something like ‘if you give user a cognos url, that url points to one specific gateway server’, so you have to do clustered web-server and application server installation for gateway fault-tolerance.
  4. There may be multiple active dispatchers in cluster
  5. Each dispatcher consists of multiple services, that may be turned off or on for a specific server in cluster.
  6. Most dispatcher services are processed in application server (Tomcat by default and almost any other of your choice), which can use either 32 or 64 bit java machine
  7. Reports (interactive and batch) are processed by a special process ‘BIBus’, which is a C++ 32 bit application (hence the 2Gb cap for each process and CCLOutOfMemory errors). Number of such processes depends on Dispatcher service settings, load on each process depends on affinity connection settings.
  8. BIBus processes generate temporary files if they require significant amount of local processing (hence UDA files problems)
  9. Each BIBus process can occupy up to 2Gb RAM and 1 CPU Core

Basic rules for capacity planning I use (your mileage may vary greatly, it depends on reports design, size and calculation complexity in first hand):

  1. Estimate number of concurrent users
  2. There should be a BIBus process for each couple concurrent users
  3. There should be at least 1 or 2 cores for all other dispatcher services
  4. There should be at least 1-2 Gb of RAM for Application Server
  5. There should be at least 2-3 Gb for Operation System (it depends on operation system greatly)
  6. There should be a separate database instance for Content Store and Audit database

For example, if we’re talking about 20 concurrent users (mind that it’s 2000 named users by basic IBM metrics), we’ll need:

  • 10 BIBus processes, each will take 1 Core and 2 GB Ram
  • 2 cores and 2 Gb ram for dispatcher and application server (for each dispatcher server, if there going to be a cluster environment)
  • 3 Gb for operating system (for each dispatcher server, if there going to be a cluster environment)

And it gives us 16 cores, 32 Gb RAM for a single server.

Suggested reading:

– Architecture and Deployment Guide )

– these threads on DeveloperWorks, where Phil W. describes all this way better than I’ll ever do:

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14233120

Update: That’s why I like the web — I was corrected by Dave even in the middle of weekend  ) Thanks again, Dave.

And

[COGNOS81MR2] Run Script시 주의사항

|
Run Metadata Wizard 부분은 대부분 에러나므로 Script내에서 Table Import는 제외하고 이용하는 것이 안전하고 속도가 빠르다.
And
prev | 1 | next