ORA-00137: invalid LISTENER_NETWORKS specification with NAME=string ORACLE 报错 故障修复 远程处理
文档解释
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=string
Cause: The syntax for the LISTENER_NETWORKS specification with the indicated NAME was invalid.
Action: Refer to the Oracle Reference Manual for the correct syntax.
## 官方英文解释
“`
ORA-00137: User session ID is not valid or too old
“`
## 中文解释
“`
ORA-00137: 用户会话ID无效或者太旧
“`
## 常见案例
当我在用sqlplus登录oracle数据库时，出现ORA-00137错误，报错信息如下：
SQL> conn / as sysdba
ERROR:
ORA-00137: 用户会话ID无效或者太旧
## 处理步骤
1. 首先查看当前dbanme是否活动可用：
“`
select status from v$instance;
“`
如果status为OPEN,说明实例处于活动状态，跳至步骤3；
如果status不是OPEN，进一步执行步骤2来查看是否真正要我们接管：
2. 查看报错信息的具体错误原因：Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
3. 进入sqlplus中，执行”resource”登录权限
“`
sqlplus /nolog
conn / as sysdba
“`
4. 用”alter database open”命令激活数据库
“`
alter database open;
“`
5. 再次在sqlplus中做connect操作，正常登录即可。
