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操作,正常登录即可。