3,491
社区成员
发帖
与我相关
我的任务
分享oracle视图查询权限问题，求解决办法！！！
总行给的视图让我查询、但查询权限不是管理员，在使用这个视图查询的时候、偶尔会提示查询失败，失败原因：0ra-12154和ora-02063,我现在做的查询程序是直连数据库的，而且每次执行完查询我都立马断开连接，有木有大虾知道具体原因和解决办法。
...全文
请发表友善的回复…
发表回复
shenlele088 2014-06-27
- 打赏
- 举报
总行的连接数过大了吧
善若止水 2014-06-26
- 打赏
- 举报
“而且每次执行完查询我都立马断开连接”，是一个什么情况？
依据楼主的描述，我有两点想法： 1 网络不稳定，造成了dblink断了 2 数据量太大了
leiy21003 2014-06-10
- 打赏
- 举报
不断开的话不是一直占着连接么
youngman123456 2014-06-10
- 打赏
- 举报
建立dblink时最好指定SID，否则可能造成链接漂移，曾经遇到过这样的问题，查询不稳定
c_sdn_shang_bu_qi 2014-06-10
- 打赏
- 举报
忘记说了，也有可能是数据库负载过高，有时候连接不上。。。这个也可能查询下
c_sdn_shang_bu_qi 2014-06-10
- 打赏
- 举报
很明显是网络问题可以ping看看
oracle怎么可能一会给你权限查询视图，一会又不给权限。
除非是人为给的权限
ruihuahan 2014-06-09
- 打赏
- 举报
而且每次执行完查询我都立马断开连接，
================================
why？不断开试试
leiy21003 2014-06-09
- 打赏
- 举报
不是网络问题、因为有的网点是可以正常使用的，所以就觉得奇怪了，现在急需解决办法啊！！！
huangdh12 2014-06-06
- 打赏
- 举报
我们的服务器alert.log也经常会报。 因为用了数据链
ora-03135 连接数去联系
ora-02063 紧接着line （起自 link_xxx）
应该是网络原因，有的时候数据链很久都无法返回结果，有的时候又很快。
小灰狼W 2014-06-06
- 打赏
- 举报
检查用到的dblink的连接串
如果只是偶尔会失败，检查看看网络是否稳定
小灰狼W 2014-06-06
- 打赏
- 举报
ORA-12154: TNS:could not resolve the connect identifier specified
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.
Action:
- If you are using local naming (TNSNAMES.ORA file):
- Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.
- Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.
- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.
9-2 Oracle Database Error Messages
- If you are using directory naming:
- Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Verify that the LDAP directory server is up and that it is accessible.
- Verify that the net service name or database name used as the connect identifier is configured in the directory.
- Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier
- If you are using easy connect naming:
- Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Make sure the host, port and service name specified are correct.
- Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.
ORA-02063: preceding stringstring from stringstring
Cause: an Oracle error was received from a remote database link.
Action: refer to the preceding error message(s)
