解决:Oracle the network adapter could not establish the connection
来源:互联网 发布:怎样手机网络理财投资 编辑:程序博客网 时间:2024/06/05 23:56
1、打开D:\app\user\product\12.1.0\dbhome_1\NETWORK\ADMIN下的两个文件,找到listener.ora和tnsnames.ora两个文件,用记事本打开,可以看到host名称:
(HOST = ********)(PORT = 1521))
2、启动Net Manager(如下图)
选择LISTENER可以看见监听的地址1,是否和host一致,否则修改。
3、确认oracle 监听是否启动(DOS下查看):打开Cmd
C:\Documents and Settings\Administrator>cd\
c:\>lsnrctl start
启动成功后可以看到:
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 06-11月-2010 10:10:18
正常运行时间 0 天 0 小时 21 分 15 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 D:\oracle\product\10.2.0\db_1\network\log\listener.log
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=********)(PORT=1521)))
查看host和上面两个中是否一致。
4、 新建数据库(其中口令为安装oracle是设置的SYS对应的口令;主机名为前面HOST)
5、创建成功
- 解决:Oracle the network adapter could not establish the connection
- 解决The Network Adapter could not establish the connection
- The Network Adapter could not establish the connection解决
- Oracle the network adapter could not establish the connection 异常
- Oracle the network adapter could not establish the connection
- oracle The Network Adapter could not establish the connection
- Oracle the network adapter could not establish the connection
- Oracle the network adapter could not establish the connection
- Oracle the network adapter could not establish the connection
- Oracle Io 异常: The Network Adapter could not establish the connection 解决
- 如何解决访问Oracle时报错:“The Network Adapter could not establish the connection”?
- 解决【oracle】 IO 异常:The Network Adapter could not establish the connection
- The Network Adapter could not establish the connection;The Network Adapter could not establish the c
- Io 异常: The Network Adapter could not establish the connection
- Io 异常: The Network Adapter could not establish the connection
- Io 异常: The Network Adapter could not establish the connection
- Io 异常: The Network Adapter could not establish the connection
- Io 异常: The Network Adapter could not establish the connection
- CAFFE源码学习笔记之五-internal_thread
- Ubuntu下Redis安装
- 关于用集合的remove方法删除list集合中满足条件的元素问题
- day03_从键盘输入3个数,进行排序并从大到小输出
- String,StringBuffer、StringBuilde 详细介绍
- 解决:Oracle the network adapter could not establish the connection
- 销毁Session
- Android中的windowSoftInputMode属性详解
- gradle:编译过程中修改第三方jar包
- java中final的使用小结
- -webkit-touch-callout 禁止长按链接与图片弹出菜单
- 关于数据精确计算,以及四舍五入中,你所不知道的坑
- Android开发资源
- Laravel 执行 Gulp 命令出错