-bash-3.1$ lsnrctl start ######启动监听器报错 LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-JUL-2010 02:03:46 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 113: No route to host #####注意这行 -bash-3.1$ more /etc/hosts ###查看对应文件
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.125.2 localhost.localdomain
-bash-3.1$ su - root ####切到root,修改以上文件
Password:
[root@localhost ~]# vi /etc/hosts # Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.125.3 localhost.localdomain
~ "/etc/hosts" 3L, 141C written
[root@localhost ~]# more /etc/sysconfig/network ###查看所有与主机名相关的文件
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=localhost.localdomain
[root@localhost ~]# exit
logout -bash-3.1$ lsnrctl start #######再次启动仍报错,看来问题不在这儿,但报错与上面不一样了,有点进步 LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-JUL-2010 02:04:31 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
[root@localhost ~]# vi /etc/hosts ###########查了点网上资料,改成这样,保留原来的127.0.0.1原有行(安装系统本身就有的记录,新添加一行:真实ip) # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.125.3 localhost.localdomain
~ "/etc/hosts" 4L, 184C written
[root@localhost ~]# exit
logout -bash-3.1$ lsnrctl start #####再次启动监听器好了 LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-JUL-2010 02:09:10 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 09-JUL-2010 02:09:10
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
小结:
oracle监听器启动与redhat的主机配置文件有密切关系
主机配置文件有影响关系,自己理解不到位,有空学习下
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 113: No route to host #####注意这行 -bash-3.1$ more /etc/hosts ###查看对应文件
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.125.2 localhost.localdomain
-bash-3.1$ su - root ####切到root,修改以上文件
Password:
[root@localhost ~]# vi /etc/hosts # Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.125.3 localhost.localdomain
~ "/etc/hosts" 3L, 141C written
[root@localhost ~]# more /etc/sysconfig/network ###查看所有与主机名相关的文件
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=localhost.localdomain
[root@localhost ~]# exit
logout -bash-3.1$ lsnrctl start #######再次启动仍报错,看来问题不在这儿,但报错与上面不一样了,有点进步 LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-JUL-2010 02:04:31 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
[root@localhost ~]# vi /etc/hosts ###########查了点网上资料,改成这样,保留原来的127.0.0.1原有行(安装系统本身就有的记录,新添加一行:真实ip) # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.125.3 localhost.localdomain
~ "/etc/hosts" 4L, 184C written
[root@localhost ~]# exit
logout -bash-3.1$ lsnrctl start #####再次启动监听器好了 LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-JUL-2010 02:09:10 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 09-JUL-2010 02:09:10
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
小结:
oracle监听器启动与redhat的主机配置文件有密切关系
主机配置文件有影响关系,自己理解不到位,有空学习下
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-667740/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-667740/