系统登录连不上数据库,进服务器plsql登录oracle报ORA-01034 ORA-27101错误,重启oracle和监听服务后又可以登录,过一会又报错。跪求解决方案Oracle
解决方案 »
- 关于rownum的执行顺序问题,求解
- 求关于两行数据合并为一行数据的sql语句
- 请大家帮我看下以下sql为什么会报这样的错误??
- 请高手给我讲解1下存储过程实现分页的逻辑思想 最好有个例子 并帮我逐句分析1下 真的非常感谢
- 求助:基于远程网络远程数据库应用解决方案问题!!!
- 急:oracle 触发器调用C++Dll
- 求一个SQL语句
- 求标准“插入到插入”触发器写法,简单问题,忘大家不吝赐教
- 存储过程中能否使用connectas语句连接另一个数据库,将本数据库中的表中的内容导入到另一个数据库中的表里
- exp & imp问题---------今天结帖---大虾帮助
- 数据库启动报错
- oracle 11g配置求助
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl) (ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)listener.ora里面的内容是区分大小写的,然后看下oracle_home路径,最后还不行的话就备份一下listener.ora,然后把最后的host改成数据库所在服务器的IP试下
我在后台用sqlplus 能有连接数据库但是我用proc的代码编译后的程序连接数据可就报:
ORA-01034: ORACLE not available
ORA-27101: shared memory ed memory realm does not
求教各位这是怎么回事啊
sqlnet.ora有配置:
SQLNET.AUTHENTICATION_SERVICES = (BEQ,NONE)listener.ora配置:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = “oracle所在ip”)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORAC146)
(SID_NAME = ORAC146)
(ORACLE_HOME = /opt/oracle/app/oracle/product/11.1.0/db_1)
)
)proc关键代码:
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20];
VARCHAR passwd[20];
VARCHAR dbname[20];
char db_link_name[20];
EXEC SQL END DECLARE SECTION;
......
EXEC SQL CONNECT :username IDENTIFIED BY :passwd
AT :db_link_name USING :dbname;......