1在安装oracle前,我添加固定IP和主机名时不小心删除了127.0.0.1 localhost.localdomain localhost,不过装完oracle软件和数据库instance还是能起来,但是当我需要用到tnsping的时候就出现问题,监听错误,然后我去查看监听发现如下问题:
[oracle@yao]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 31-MAY-2010 11:19:38
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.4.181)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
打开监听时出现如下错误:
[oracle@yao]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-MAR-2009 05:33:19
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oracle/product/10.2.0/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
网上搜索下,是我在/etc/hosts里删除了localhost的原因
解决方法:
vi /etc/hosts
添加如下:
127.0.0.1 localhost.localdomain localhost
就可以了
2 使用xmanger 3.0通过ssh协议远程访问主机时产生如下错误
[9:35:12] Sent password.
[9:35:12] Access granted.
[9:35:12] Sent X11 forwarding request...
[9:35:12] Succeeded.
[9:35:12] Sent the command line.
[9:35:12] /usr/X11R6/bin/xterm -ls -display $DISPLAY
[9:35:12] Start timer (TIMER_SHUTDOWN, 180).
_X11TransSocketINETConnect() can't get address for localhost:6010: Name or service not known
/usr/X11R6/bin/xterm Xt error: Can't open display: localhost:10.0
添加127.0.0.1 localhost.localdomain localhost
就可以通过xmanger 来ssh登录
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22608279/viewspace-663583/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22608279/viewspace-663583/