ora-12170 与 Oracle lsnrctl
2024-09-28 23:36:46
在startup 启动数据库后,使用plsql去连接数据库时,
出现ora-12170 错误:
在启动、关闭或者重启oracle监听器之前确保使用lsnrctl status命令检查oracle监听器的状态:
1、$lsnrctl status:检查当前监听器的状态
2、$lsnrctl start [listener-name] 启动所有的监听器,可以指定名字来启动特定的监听器
3、$lsnrctl stop [listener-name] 关闭所有的监听器,可以指定名字来关闭特定的监听器
4、$lsnrctl reload 重启监听器,此命令可以代替lsnrctl stop,lsnrctl start
5、lsnrctl hep 可以显示所有可用的监听器命令
常用命令参数:
start - Start the Oracle listener
stop - Stop the Oracle listener
status - Display the current status of the Oracle listener
services - Retrieve the listener services information
version - Display the oracle listener version information
reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
save_config - This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER”
trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
change_password - Set the new password to the oracle listener (or) change the existing listener password.
show - Display log files and other relevant listener information
stop - Stop the Oracle listener
status - Display the current status of the Oracle listener
services - Retrieve the listener services information
version - Display the oracle listener version information
reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
save_config - This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER”
trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
change_password - Set the new password to the oracle listener (or) change the existing listener password.
show - Display log files and other relevant listener information
最新文章
- 探秘Tomcat(一)——Myeclipse中导入Tomcat源码
- ProgressBar.js – 漂亮的响应式 SVG 进度条
- RRD
- 大话数据结构–1.基础知识+2.算法
- Spring 4 官方文档学习(十一)Web MVC 框架之异常处理
- Hibernate-入门教程
- jquery validate自定义checkbox验证规则和样式
- 华东交通大学2016年ACM“双基”程序设计竞赛 1003
- poj 2485 Highways
- java-分页之页面分页
- 细谈Linux和windows差异之图形化用户接口、命令行接口
- C# 脚本代码自动登录淘宝获取用户信息
- web前端概念巩固(一)
- js判断空值
- 如何编写通用的 Helper Class
- 微信小程序基础之开源项目库汇总
- 【普及篇】通信能力API及其前景分析
- console.log()中的运算与打印事件
- shiro实战系列(十一)之Caching
- JAVA中的异常疑点解析
热门文章
- set up trace code tool
- Requery,Refresh,Adoquery.Close,Open 区别
- Codeforces Round #423 (Div. 2, rated, based on VK Cup Finals) E DNA Evolution
- android学习资源
- vue框架及其
- GO --微服务框架(一) goa
- 拦截recyclerview 的item 的点击事件
- hdu1827之强联通
- [C++设计模式] proxy 代理模式
- Android系统开发(6)——Linux底层输入输出