Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Linux下Oracle 10g偶然性卡住登陆

Linux下Oracle 10g偶然性卡住登陆

WBOY
Release： 2016-06-07 17:11:38
Original
1168 people have browsed it

在Linux下Oracle中如下方式登录数据库：sqlplus /nolog conn /as sysdba但在conn /as sysdba这一步就卡住，无法登录，且查看监听

在Linux下Oracle中如下方式登录数据库：sqlplus /nolog conn /as sysdba但在conn /as sysdba这一步就卡住，无法登录，，且查看监听状态没有反应

这是oracle 10.2.0.1的一个bug到一定的天数之后sqplus和lsnrctl都不好用。一般的方法重启服务器。要么就是按照网上的做法，打补丁或者在监听文件加一句话。

在listener.ora 文件里加入：SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF其中， 是数据库的监听器的名称。如：默认情况下，监听器名为：LISTENER 。则语句就是：SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

linux

Related labels：
oracle数据库教程 Linux下Oracle 10g偶然
source：php.cn
Previous article：Oracle基础教程：RHEL5U5安装Oracle 10g Next article：Oracle基础教程：单行函数—类型转换函数
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Efficient way to fill missing values ​​in unordered map from SQL table (SQL/C++) Question Currently there is a system that reads unique identifiers (ids) and their attache...
From 2024-04-04 11:47:44
0
1
345
React - JS Api: Resolving undefined return I'm new to React and js and I'm having a bit of trouble understanding how Promise and reso...
From 2024-04-03 17:51:57
0
1
282
Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
From 2024-04-03 14:46:04
0
1
298
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template