联系：手机/微信(+86 17813235971) QQ(107644445)
标题：linux中不能ping通hostname可能存在问题
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
不能ping通hostname
[oracle@xifenfei ~]$ hostname xifenfei [oracle@xifenfei ~]$ ping xifenfei ping: unknown host xifenfei [oracle@xifenfei ~]$ nslookup > xifenfei ;; connection timed out; no servers could be reached > exit [oracle@xifenfei ~]$ more /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 xifenfei1 localhost.localdomain localhost
10G中存在问题
[oracle@xifenfei ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 3 01:54:22 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. --sqlplus连接非常慢 SQL> startup ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] --ORA-00600[keltnfy-ldmInit]错误
11G中存在问题
[oracle@xifenfei ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 3 02:02:29 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected. SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=xifenfei)(PORT=1521))' --因为不能ping通xifenfei，提示LOCAL_LISTENER错误 --修改pfile文件 local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))' --启动数据库 SQL> startup pfile='/tmp/pfile' ORACLE instance started. Total System Global Area 368263168 bytes Fixed Size 1345016 bytes Variable Size 306186760 bytes Database Buffers 54525952 bytes Redo Buffers 6205440 bytes Database mounted. Database opened. [oracle@xifenfei ~]$ ps -ef|grep ora_ oracle 5960 1 0 02:09 ? 00:00:00 ora_pmon_ora11g oracle 5964 1 0 02:09 ? 00:00:00 ora_psp0_ora11g oracle 5970 1 1 02:09 ? 00:00:00 ora_vktm_ora11g oracle 5976 1 0 02:09 ? 00:00:00 ora_gen0_ora11g oracle 5980 1 0 02:09 ? 00:00:00 ora_diag_ora11g oracle 5984 1 0 02:09 ? 00:00:00 ora_dbrm_ora11g oracle 5988 1 0 02:09 ? 00:00:00 ora_dia0_ora11g oracle 5992 1 0 02:09 ? 00:00:00 ora_mman_ora11g oracle 5996 1 0 02:09 ? 00:00:00 ora_dbw0_ora11g oracle 6000 1 0 02:09 ? 00:00:00 ora_lgwr_ora11g oracle 6004 1 0 02:09 ? 00:00:00 ora_ckpt_ora11g oracle 6008 1 0 02:09 ? 00:00:00 ora_smon_ora11g oracle 6012 1 0 02:09 ? 00:00:00 ora_reco_ora11g oracle 6016 1 0 02:09 ? 00:00:00 ora_mmon_ora11g oracle 6020 1 0 02:09 ? 00:00:00 ora_mmnl_ora11g oracle 6028 1 0 02:09 ? 00:00:00 ora_s000_ora11g oracle 6055 1 0 02:10 ? 00:00:00 ora_p000_ora11g oracle 6059 1 0 02:10 ? 00:00:00 ora_p001_ora11g oracle 6063 1 0 02:10 ? 00:00:00 ora_arc0_ora11g oracle 6069 1 0 02:10 ? 00:00:00 ora_arc1_ora11g oracle 6073 1 0 02:10 ? 00:00:00 ora_arc2_ora11g oracle 6077 1 0 02:10 ? 00:00:00 ora_arc3_ora11g oracle 6081 1 0 02:10 ? 00:00:00 ora_qmnc_ora11g oracle 6089 1 0 02:10 ? 00:00:00 ora_q000_ora11g oracle 6093 1 0 02:10 ? 00:00:00 ora_q001_ora11g oracle 6141 1 0 02:11 ? 00:00:00 ora_d000_ora11g oracle 6145 1 2 02:11 ? 00:00:00 ora_cjq0_ora11g --数据库启动正常 [oracle@xifenfei ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 3 02:10:37 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected. SQL> show parameter local_listener; ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 --sqlplus不能操作，而且sqlplus登录非常慢
监听异常
--监听配置文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora11g)
(ORACLE_HOME = /u01/oracle/oracle/product/11.2.0/db_1)
(SID_NAME = ora11g)
)
)
--启动监听
[oracle@xifenfei ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-APR-2012 02:19:52
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/oracle/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/oracle/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/xifenfei/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.10)(PORT=1522)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1522)))
--一直处于等待状态
--客户端登录
C:\Users\XIFENFEI>sqlplus sys/xifenfei@192.168.1.10:1522/ora11g
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 4月 3 12:48:15 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
--一直hang住
[root@xifenfei admin]# netstat -an|grep 1522
tcp 0 0 192.168.1.10:1522 0.0.0.0:* LISTEN
tcp 260 0 192.168.1.10:1522 192.168.1.1:51977 ESTABLISHED
tcp 0 0 192.168.1.10:24317 192.168.1.10:1522 ESTABLISHED
tcp 198 0 192.168.1.10:1522 192.168.1.10:24317 ESTABLISHED
--这里显示已经连接
建议:在修改主机名时要慎重，修改的时候要确保/etc/hosts和/etc/sysconfig/network文件都被正确修改