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]