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