sqtsqt 发表于 2018-9-22 09:42:30

Oracle BIEE在linux下的安装

配置sheduler  创建数据库用户:S_NQ_SCHED/S_NQ_SCHED,
  然后执行$ORACLEBI_HOME/server/Schema/SAJOBS.Oracle.sql和SAACCT.Oracle.sql脚本,代码如下:
  $sqlplus / as sysdba

  $create user S_NQ_SCHED>  $grant connect,resource to S_NQ_SCHED;
  $sqlplus / as sysdba
  SQL>@$ORACLEBI_HOME/server/Schema/SAJOBS.Oracle.sql
  SQL>@$ORACLEBI_HOME/server/Schema/SAACCT.Oracle.sql
  配置tnsname:
  在$ORACLE_HOME/product/10.2.0/db_1/network/admin(如果仅安装了客户端,为$ORACLE_HOME/10.2.0/lient_1/network/admin)目录下的tnsname.ora文件中配置charge,如下:
  CHARGE =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = charge)
  )
  )
  然后修改odbc.ini文件:
  $ORACLEBI_HOME/setup
  $vi odbc.ini
  修改如下部分
  
  AnalyticsWeb=Oracle BI Server
  Cluster=Oracle BI Server
  SSL_Sample=Oracle BI Server
  charge=libnqsdbgatewayoci10g.so

页: [1]
查看完整版本: Oracle BIEE在linux下的安装