[nQSError: 37001]Could not connect to the Oracle BI Server Instance
使用本机的OBIEE Client 的Oracle BI管理工具,连接远程服务器上的OBIEE Server, 联机打开rpd时,报如下错误
原因:OBIEE Services端口9703被关闭了
The Oracle Business Intelligence Server is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services via ODBC. Metadata is maintained for the data model in a local proprietary file called the repository file(rpd). On the back-end, the BI Server connects to customer data stores via data source adaptors.The Port no is 9703
解决办法一:开启端口9703
开启端口9703:
[root@xqzt ~]# /sbin/iptables -I INPUT -p tcp --dport 9703 -j ACCEPT
[root@xqzt ~]# /etc/init.d/iptables save
iptables:将防火墙规则保存到 /etc/sysconfig/iptables: [确定]
[root@xqzt ~]# service iptables restart
iptables:将链设置为政策 ACCEPT:filter [确定]
iptables:清除防火墙规则: [确定]
iptables:正在卸载模块: [确定]
iptables:应用防火墙规则: [确定]
[root@xqzt ~]#
或者:
vi /etc/sysconfig/iptables 打开配置文件加入如下语句: -A INPUT -p tcp -m state --state NEW -m tcp --dport 9703 -j ACCEPT 重启防火墙,修改完成 service iptables restart
方法二:关闭OBIEE Server 所在服务器的防火墙
service iptables stop
重新登录即可
原文地址:
[nQSError:37001] Could not connect to BI Server Instance
Services in OBIEE and OBIEE Services Port number?
Port Numbers Used in an OBIEE 11g Installation and Configuration