1、问题说明
[oracle@SimpleLinux ~]$ uname -r
2.6.32-431.el6.i686
Red Hat Enterprise Linux Server release 6.5 (Santiago)
使用dbca安装完成数据库后，没有明显报错痕迹。检查数据库实例启动正常，也可以支持操作系统验证登陆。
[oracle@SimpleLinux ~]$ ps -ef | grep pmon
oracle 5851 1 0 12:48 00:00:00 ora_pmon_ora11g
oracle 11778 11747 0 12:56 pts/0 00:00:00 grep pmon
监听程序状态查询失效，处在不能启动状态。
[oracle@SimpleLinux ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 01-APR-2014 12:56:53
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SimpleLinux)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
lsnrctl是监听器操纵平台工具，status会去尝试连接运行的监听程序检查状态。从结果看，监听器没有启动。注意：一般而言，Oracle创建数据库之后，就会自动启动一个监听器。最新的Oracle版本会用默认的方式运行监听器，TNS_ADMIN目录中通常没有tnsnames.ora、listener.ora和sqlnet.ora文件。
启动监听器，报错。
[oracle@SimpleLinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 01-APR-2014 12:57:06
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/network/admin/listener.ora
Log messages written to /u01/app/diag/tnslsnr/SimpleLinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SimpleLinux)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SimpleLinux)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
2、问题分析
使用netca重建监听程序，也没有解决问题。查看listener.ora文件如下：
[oracle@SimpleLinux admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SimpleLinux)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app
从host参数配置上，指定的名称SimpleLinux解析最直接手段是/etc/hosts文件。
[oracle@SimpleLinux admin]$ cat /etc/hosts
127.0.0.1 SimpleLinux SimpleLinux.localdomain localhost4 localhost4.localdomain4
::1 SimpleLinux SimpleLinux.localdomain localhost6 localhost6.localdomain6
192.168.0.100 SimpleLinux SimpleLinux.localdomain
[root@SimpleLinux ~]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 08:00:27:48:5C:18
inet addr:192.168.0.100 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe48:5c18/64 Scope:Link
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
直观看没有什么问题，两个监控地址都在文件中。修改下hosts文件更加清晰，路径IP解析也没有问题，网络连接也没有问题。
[root@SimpleLinux ~]# vi /etc/hosts
192.168.0.100 S