dblink ORA00942 table or view does not exist
我用系统DBA认证方式，即“connect / as sysdba”创建了数据库和表还有procedure，然后又创建了一个有“select any table, create session”权限的用户，可是用此用户“connect userid/userpwd”登陆数据库后，检索不到任何表，任何检索已在“as sysdba”下建立起来的表，都会被返回“ora-00942: table or view does not exist”的错误。而用“connect userid/userpwd as sysdba”连接数据库，却可以检索到表。 我现在需要解决的问...
by zhangpu - Oracle - 2005-10-08 09:48:29 阅读（8898） 回复（3）
还有一个错误就是在安装的过成中出现如下的错误： ora_27101:shared memory realm does not exist. 请问我该如何来处理。 谢谢了
还有一个错误就是在安装的过成中出现如下的错误： ora_27101:shared memory realm does not exist. 请问我该如何来处理。 谢谢了
ora-27101: shared memory realm does not exist SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 13 18:49:01 2003 Copyright (c) 1982, 2002, oracle Corporation. All rights reserved. Enter user-name: system Enter password: ERROR: ora-01034: oraCLE not available ora-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 13 18:49:01 2003 Copyright (c) 1982, 2002, oracle Corporation. All rights reserved. Enter user-name: system Enter password: ERROR: ora-01034: oraCLE not available ora-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
[Thu Jul 26 12:54:56 2007] [error] [client 221.237.179.224] File does not exist: /usr/local/www/apache22/data/uri-res [Thu Jul 26 12:55:00 2007] [error] [client 221.237.179.224] File does not exist: /usr/local/www/apache22/data/uri-res [Thu Jul 26 12:55:12 2007] [error] [client 60.189.105.191] File does not exist: /usr/local/www/apache22/data/uri-res [Thu Jul 26 12:55:18 2007] [error] [client 58.2...
Hello! Can somebody please help? Maybe it's nothing that serious, but I have no idea what the problem can be. (ASE-12.5 on Redhat 9.0) After attempting to create an Adaptive Server, using the srvbuild utility, the following message comes out: Unable to boot Adaptive Server 'xxx' because the master device (/opt/sybase-12.5/dbdev/master/master.dat) does not exist. Server 'xxx' was not created. Th...
我的数据库ora10g for linux停机后，重启启动正常，但应用程序联入数据库时失败报以下错: Caused by: java.sql.SQLException: ora-01034: oraCLE not available ora-27101: shared memory realm does not exist Linux Error: 2: No such file or directory 查询数据库是正常的已启动: SQL> select status from v$instance; STATUS ------------ OPEN SQL> 通过仔细回想最近对数据库作了什么操作,仅修改过profile呀。原prof...
我需要做一个lv做dd 清空操作，我用到了: dd if=/dev/zero of=/dev/rdatalv_01 bs=1024k 提示： There is a request to a device or address that does not exist. 130+0 records in. 128+0 records out. 是全部清空吗？为什么两个不等呀？这个报错要紧吗？ 大家一般指定bs 为多大？bs 的大小一定要lv 除尽吗?不然是不是会出现这种问题？ 注这是big vg,没有偏移...
在log文件里面发现有 File does not exist: 那么就是说有人访问了不存在的文件，请问各位大哥怎么才可以让apache不接受这类请求呢？多谢赐教
I wish to know which one will be better in term of the performance by using summary table and view. If possible, pls share your opinion with me by using these 2 types of table and view. Thanks
