oracle OBIEE 答案未显示结果
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15209397/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
OBIEE Answers not showing results
提问by P.Nichols
I recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now.
我最近安装了 OBIEE 11.1.1.6.0。我从 11.1.1.5 导入了我拥有的存储库，它一直运行良好。
In the administration tool, I can query my data and update the rows, I can connect with the same credentials as the connection pool without problems in SQLPLUS.
在管理工具中，我可以查询我的数据并更新行，我可以使用与连接池相同的凭据进行连接，而在 SQLPLUS 中没有问题。
Users have the RESOURCE and CONNECT privileges.
用户具有 RESOURCE 和 CONNECT 权限。
My weblogic user as all the privileges and has been granted read/write to my Subject area. I have set the environment variables, modified the instancesconfig.xml and tried all the things i could've found on the OTN but BI Answers continues to give me this ERROR
我的 weblogic 用户拥有所有权限，并已被授予对我的主题区域的读/写权限。我已经设置了环境变量，修改了instancesconfig.xml 并尝试了我可以在 OTN 上找到的所有东西，但 BI Answers 继续给我这个错误
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin.
[nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT 0 s_0, "SAP_AVIS"."Fait SAP AVIS"."Avis" s_1 FROM "SAP_AVIS" FETCH FIRST 65001 ROWS ONLY
Please help, I am desperate.
请帮忙，我很绝望。
回答by P.Nichols
I have been able to resolve my OCI ORA-01017 error.
我已经能够解决我的 OCI ORA-01017 错误。
The problem was caused by my connection pools.
问题是由我的连接池引起的。
I had a connection amed "A" to access tables in a certain schema in my DB and another connection named "B" this time to access tables in another schema but in the same DB.
我有一个名为“A”的连接来访问我的数据库中某个模式中的表，而这次另一个名为“B”的连接来访问另一个模式中但在同一个数据库中的表。
In Oracle BI Answers (presentation), I was trying to view data whitin the connection B but strangely OBIEE Answers was using the connection A.
在 Oracle BI Answers（演示）中，我试图查看连接 B 中的数据，但奇怪的是 OBIEE Answers 使用的是连接 A。
In the end I removed/renamed the connection A and everthing worked like nothing never happend.
最后，我删除/重命名了连接 A，一切都像什么都没发生过一样工作。
I am not saying that this is the best method. Maybe i skipped a config that assigns the default connection pool to use but it did the job.
我并不是说这是最好的方法。也许我跳过了一个分配默认连接池使用的配置，但它完成了这项工作。
回答by Vijay
Option 1: Copy your tnsnames.ora to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory
选项 1：将您的 tnsnames.ora 复制到 {Oracle_BI1}\network\admin 目录和 {oracle_common}\network\admin 目录
Option 2: Instead of using tnsnames.ora entry in the RPD, use the full expanded tnsnames.
选项 2：不要在 RPD 中使用 tnsnames.ora 条目，而是使用完整的扩展 tnsnames。
I have never faced this issue, so I'm not sure this'll work or not but you can try. Option 2 might just do the trick.
我从来没有遇到过这个问题，所以我不确定这是否有效，但你可以试试。选项 2 可能只是解决问题。
Vijay.
维杰。
回答by user3289405
For me oracle client was not installed, when I Installed the oracle client problem got solved
对我来说，oracle 客户端没有安装，当我安装时，oracle 客户端问题就解决了
