ora12541及tnsping很慢问题
来源:互联网 发布:数据备份软件下载 编辑:程序博客网 时间:2024/06/06 20:25
注意host文件
127.0.0.1 主机名
127.0.0.1 localhost
客户端配置目录D:\install\PLSQL\instantclient_11_2
ORCALE配置目录D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
lsnrctl stop
lsnrctl start
tnsping 192.168.1.2
tnsping 服务名
检查日志文件
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = YIPARTS) (ORACLE_HOME =D:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = YIPARTS) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) ) )ADR_BASE_LISTENER = D:\app\Administrator
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )YIPARTS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YIPARTS) ) )
D:\install\PLSQL\instantclient_11_2\listener.ora
# listener.ora Network Configuration File: D:\install\PLSQL\instantclient_11_2\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = YIPARTS) (ORACLE_HOME =D:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = YIPARTS) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )ADR_BASE_LISTENER = D:\app\Administrator
D:\install\PLSQL\instantclient_11_2\tnsnames.ora
# tnsnames.ora Network Configuration File: D:\install\PLSQL\instantclient_11_2\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )YIPARTS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YIPARTS) ) )
关于连接很慢的问题
在sqlnet.ora的SQLNET.AUTHENTICATION_SERVICES设置,如果设置NTS,则“优先”使用Windows验证,然后使用Oracle验证,而设置none,则“只”使用Oracle验证。而我在程序当然使用Oracle验证,而该配置文件默认NTS方式
把认证方式改为none,程序连接速度只需要500毫秒,问题解决
清理删除 D:\app\Administrator\diag\tnslsnr\ORA-YIPARTS\listener\trace\listener.log
阅读全文
0 0
- ora12541及tnsping很慢问题
- oracle tnsping 慢的问题
- TNSPING time out/响应慢
- tnsping 的问题
- 【问题记录】tnsping不通
- tnsping特别慢,连接数据库没反应
- tnsping
- tnsping延时高的问题
- 数据库的sqlplus连接慢,tnsping延时比较大
- tns名不被tnsping识别的问题
- tracert 很慢的问题
- Android studio导入工程很卡及下载网络jar很慢问题总结
- VC:利用Curl库实现文件上传及速度很慢问题
- Docker的网络配置,导致Docker使用网路很慢的问题及解决办法
- ora12541 tns 无监听程序
- popoverController消失的很慢问题-dismiss很慢
- tnsping通但无法连接的问题处理
- MySQL慢查询配置,及解决相关问题
- 74HC595驱动程序
- Kotlin基础语法
- Exception in thread "main" net.sf.json.JSONException: A JSONArray text must start with '[' at charac
- 关于ViewPager+Fragment中Fragment不销毁/生命周期
- pat甲级1044
- ora12541及tnsping很慢问题
- TCP/IP--划分子网和构造超网
- Db2: online backup和nonrecoverable load的兼容性
- nyoj 92 图像有用区域(dfs)
- IDEA无法加载到tomcat server
- python Web爬取工具总结 1 :Requests和BeautifulSoup
- [bzoj1968][数论]约数研究
- Jdk8 Optional 的正确姿势
- IntentService使用及源码解析