描述

新安装的系统，在装完11.2.0.1.0数据库后。关机再重启，数据库进不去。报如下错误。

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
p;mF3Av,|@0ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=bogon)(PORT=1521))'

解决办法修改LOCAL_LISTENER参数值,bogon换成能解析的主机名.如localhost.或修改系统配置能够解析bogon,此解决方法见参考资料第二个url地址。
f~T3R'T$O`"p6Us0ITPUB个人空间0|7}dD"M

环境

OS

[oracle@bogon ~]$ cat /etc/redhat-release
T*rA3ix H0Red Hat Enterprise Linux Server release 5.4 (Tikanga)ITPUB个人空间%k8As)W3z
[oracle@bogon ~]$ uname -aITPUB个人空间3_Tp N y{
Linux bogon 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/LinuxITPUB个人空间^9NURzvfg"{y
[oracle@bogon ~]$ITPUB个人空间'[M8r$@C

DB

11.2.0.1.0
Z&SfErwL0
n9N5[K$M
V\;_d!B0

结构

ORACLE_SID=odiITPUB个人空间7P9F YNv8xN-yKB:L
ORACLE_BASE=/u01/app/oracleITPUB个人空间0JYZ?Tw!a
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
Rx.v2_F(Xmg0alert日志位置 /u01/app/oracle/diag/rdbms/odi/odi/trace/alert_odi.log
._6CSn(rb0

步骤

新安装的系统，未做任何设置，直接安装数据库。安装好数据库后，将系统重启，再启动数据库时报 ORA-00119 ORA-00130错误。 结果如下：ITPUB个人空间C D~'V*m

[oracle@bogon dbs]$ sqlplus  / as sysdba CU)ZK$GK3a&H0 ||4N'xJ$O0SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 31 14:54:36 2012 5V2m/o-LyC+|0ITPUB个人空间u.B[.f.z/lhZ Copyright (c) 1982, 2009, Oracle.  All rights reserved.ITPUB个人空间0Y~?c&?a:Bv8{ ITPUB个人空间vz9FIHX(f8d Connected to an idle instance. c&^6hn&N3aRh0ITPUB个人空间zZ(A!_FZj SQL> startup %`-y0b U/b;?N0ORA-00119: invalid specification for system parameter LOCAL_LISTENERITPUB个人空间6Z ^5Yg$K(]^;| Cf0b ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=bogon)(PORT=1521))' p'RZgs1Q0SQL>

ITPUB个人空间V'H:_.cha
i
查看alert日志内容ITPUB个人空间#tAvbq8~ T j

Tue Jan 31 14:55:22 2012ITPUB个人空间 Ys(lC$a+v Starting ORACLE instance (normal)ITPUB个人空间kaq+Lzr LICENSE_MAX_SESSION = 0ITPUB个人空间"e0d v&H]8Qg_V+w LICENSE_SESSIONS_WARNING = 0ITPUB个人空间5y$P,MSowzI)l;I Picked latch-free SCN scheme 2ITPUB个人空间$D#HpK[fYsO Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch #?cD|EL3P9T(J^0Autotune of undo retention is turned on.ITPUB个人空间F d5Qop}7v IMODE=BR 4}$_6W!Dr k!K0ILAT =84ITPUB个人空间.?7e%\KTj LICENSE_MAX_USERS = 0ITPUB个人空间t#mY R:D SYS auditing is disabled UIZ.`O}A0Starting up: 2cX*k+IX2_0Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production ~ oI4a5}k#s;]w)E0With the Partitioning, OLAP, Data Mining and Real Application Testing options.ITPUB个人空间8ej9u1]F8t0u Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initodi.ora 0a m.fk+N&UE(C9kt0System parameters with non-default values:ITPUB个人空间)AH q(E)u)W#{/R   processes                = 500ITPUB个人空间nGO*r7u J   memory_target            = 812MITPUB个人空间,E#y`z;H"c:SG   control_files            = "/u01/app/oracle/oradata/odi/control01.ctl"ITPUB个人空间 A,R0^'i$_6[   control_files            = "/u01/app/oracle/oradata/odi/control02.ctl"ITPUB个人空间)e Z"XQ7QO'C4Qo   db_block_size            = 8192 B"l@*ZYM&R0  compatible               = "11.2.0.0.0"ITPUB个人空间N(RJ4}O n   undo_tablespace          = "UNDOTBS1"ITPUB个人空间6ea+?8g,x~lq!V7Bh_.x   remote_login_passwordfile= "EXCLUSIVE" -Q\1|#t1gki0  db_domain                = ""ITPUB个人空间4^ U'j:e2~wB   audit_file_dest          = "/u01/app/oracle/admin/odi/adump" 7_ AQ7T_)XH4@0  audit_trail              = "DB"ITPUB个人空间joi8L@t$B   db_name                  = "odi" 7I r ]'ej\/?J[-k kG0  open_cursors             = 800ITPUB个人空间6{ys hc   query_rewrite_enabled    = "TRUE" ]VT%sr2[bk4Cv0  query_rewrite_integrity  = "TRUSTED" ,c9}t2gq7jh0  diagnostic_dest          = "/u01/app/oracle"ITPUB个人空间 } p:u~@2O-Wa Tue Jan 31 14:55:33 2012 .s0z&[Sw0USER (ospid: 6418): terminating the instance due to error 119 Y;@*j PY;D8G5DG%d*T0Instance terminated by USER, pid = 6418 zf`"CYB7Y#N0

ITPUB个人空间4r+W.Fq q,J
查看alert日志中说明的数据库启动时使用的pfileITPUB个人空间}2y\*si s"sI2G4{

[oracle@bogon ~]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initodi.oraITPUB个人空间\j!_"LS1z odi.__db_cache_size=150994944 FWY {2^#a7Fz0odi.__java_pool_size=58720256 "r*B$o V)tG{0odi.__large_pool_size=4194304 tIdp(z ~}0odi.__oracle_base='/u01/app/oracle'ITPUB个人空间#JA@C;aM H G;@ odi.__pga_aggregate_target=297795584 8L#T9z:s_LZ7H U,X0odi.__sga_target=553648128ITPUB个人空间$R3T&O:q PM odi.__shared_io_pool_size=0ITPUB个人空间-]3w F;G S odi.__shared_pool_size=331350016 &h5FH4z3u&m0odi.__streams_pool_size=0 @\'^E6{}0*.audit_file_dest='/u01/app/oracle/admin/odi/adump'ITPUB个人空间4qbr;J0C$a'd *.audit_trail='db'ITPUB个人空间@BhE&}AB *.compatible='11.2.0.0.0' :WE Xg'q?0*.control_files='/u01/app/oracle/oradata/odi/control01.ctl','/u01/app/oracle/oradata/odi/control02.ctl' q7o#oJEf E0*.db_block_size=8192ITPUB个人空间qI.X.^VU$kC *.db_domain='' u8d!Iwx?2~?0*.db_name='odi'ITPUB个人空间h'Q s/T:W0cZx *.diagnostic_dest='/u01/app/oracle' `@A:kt m.v0*.memory_target=848297984 dX2h)Eg"N o V/W0*.open_cursors=800 ~F J GK lUK0*.processes=500 ?_8Sms%Y?0*.query_rewrite_enabled='TRUE' .it2Fxl$d%a0Wr0*.query_rewrite_integrity='TRUSTED' O[p:qG-{x4_s0*.remote_login_passwordfile='EXCLUSIVE' o!W yr7q1Nd)T-A0*.undo_tablespace='UNDOTBS1' V'S8j!T.yR0 #V(V1uyK0[oracle@bogon ~]$ h6N/PZ(N:e0

可见pfile中并未对LOCAL_LISTENER这一参数进行设置，但数据库启动是这个参数是在哪里定义的不得而知。折腾了一会儿，寻找数据库启动时的参数，没有结果。翻过头仔细查看错误说明
EU1sn#Zl]0ORA-00119: invalid specification for system parameter LOCAL_LISTENER
$q:jzzK3Hyh0ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=bogon)(PORT=1521))'ITPUB个人空间U$[}_G
ora 00130中提示说 LOCAL_LISTENER的参数值设置不正确。对着此值发呆半天，意识到很可能是HOST=bogon这里出了问题。虽然bash的提示符显示的[oracle@bogon ~]$  中似乎bogon是主机名，但是真正去解析bogon这个主机时却找不到。ITPUB个人空间e+x_)x_a

[oracle@bogon ~]$ ping bogonITPUB个人空间H4wL_1rk ping: unknown host bogonITPUB个人空间"BR bP6BA,B [oracle@bogon ~]$ 4a3n_!["z m;G+?0

4j3v Wj%]R
t0于是向数据库pfile参数文件中添加一行 LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' 明确告诉数据库启动时LOCAL_LISTENER参数使用'(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))'此值。 数据库正常启动。
0XfV*n.R.T1[P0

[oracle@bogon ~]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initodi.ora j[(IMM3A%xyUH0odi.__db_cache_size=150994944 7GqK5^(S H-A0odi.__java_pool_size=58720256ITPUB个人空间_n"x9CI&FEXM odi.__large_pool_size=4194304ITPUB个人空间2F f } rk fB/iS0Rm/_ odi.__oracle_base='/u01/app/oracle' b2a)d4y;V I^0odi.__pga_aggregate_target=297795584ITPUB个人空间x$V~"L-GO4` odi.__sga_target=553648128 g;?B\;^;?.@Gg0odi.__shared_io_pool_size=0 M [GX[ A KqYy0odi.__shared_pool_size=331350016ITPUB个人空间 KuPF7gUxv%^qt6k6z odi.__streams_pool_size=0 .e7w YAO&l/Y:K3j0*.audit_file_dest='/u01/app/oracle/admin/odi/adump' q Q?p$`F"m0*.audit_trail='db'ITPUB个人空间&rYkH mS *.compatible='11.2.0.0.0'ITPUB个人空间.SY;ge ^Rbo *.control_files='/u01/app/oracle/oradata/odi/control01.ctl','/u01/app/oracle/oradata/odi/control02.ctl' *s%P_ i0B2O?0*.db_block_size=8192 *W/j]7hk_0*.db_domain=''ITPUB个人空间 Tmj2T"eJ3^&a *.db_name='odi'ITPUB个人空间H)@A4w4z:^@n *.diagnostic_dest='/u01/app/oracle' R7L6t\#F0*.memory_target=848297984 w)u3C#vz M Q.o0*.open_cursors=800 k-U NU-@:y&\0*.processes=500ITPUB个人空间 lWO6n6W [U *.query_rewrite_enabled='TRUE'ITPUB个人空间9aI4ZJ"H4Ug*Z *.query_rewrite_integrity='TRUSTED' [ @h,_lqrG"@)i;O0*.remote_login_passwordfile='EXCLUSIVE' f(X O-w3p$F%P0*.undo_tablespace='UNDOTBS1' 1eLvS P4s0 oxk|KX0LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))'ITPUB个人空间 E X$BV@ [oracle@bogon ~]$ sqlplus  / as sysdbaITPUB个人空间5D6a`Y)gm ITPUB个人空间j*?1~5HK q SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 31 15:33:19 2012ITPUB个人空间-K+cfd7e ITPUB个人空间1e hT D)HS,l oy Copyright (c) 1982, 2009, Oracle.  All rights reserved. &wAUem0n9CUm%{ qZ0ITPUB个人空间q5TNR_ Connected to an idle instance.ITPUB个人空间'Qsa1y4u#I'z ITPUB个人空间m C xL*@wa8K@'A SQL> startupITPUB个人空间5wK2u'h2H-aWo#J7z l ORACLE instance started.ITPUB个人空间gArH U k-n0a6HAmE X:l.\+~g k5v"b9b0Total System Global Area  849530880 bytesITPUB个人空间Z,CZ^HI4t8b.D Fixed Size            1339824 bytes g@Xn7G&y6K4Y d0Variable Size          692063824 bytesITPUB个人空间3a:pKcvysd MQ Database Buffers      150994944 bytes G*|&c$h g4|Oa0Redo Buffers            5132288 bytesITPUB个人空间3s,ney8cX Database mounted. []$AS e{U4M|0Database opened.ITPUB个人空间 z1v1J"B9buG+P M SQL>ITPUB个人空间%hTq0yRj+BY;V K

ITPUB个人空间/X
Q DG/[4\f

个人总结

[root@bogon ~]# cat /etc/hostsITPUB个人空间2f^(]0}"fn3xv8T;wf # Do not remove the following line, or various programs -EQP!D8rSN0# that require network functionality will fail.ITPUB个人空间V:R!{&raKTK 127.0.0.1        localhost.localdomain localhostITPUB个人空间C]mlLW ::1        localhost6.localdomain6 localhost6ITPUB个人空间bCAH rO7}k [root@bogon ~]# cat /etc/sysconfig/network {PX;Yo0~GVZ0NETWORKING=yesITPUB个人空间Tg*v8x7LJ NETWORKING_IPV6=noITPUB个人空间 \p,u8d!Ri$^ HOSTNAME=localhost.localdomainITPUB个人空间#K0I uHSB.@4a1k [root@localhost ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0ITPUB个人空间!\,_4l{O i.f # Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]ITPUB个人空间@!A[*Zn [9l(q DEVICE=eth0 CI]Ah0BOOTPROTO=dhcpITPUB个人空间E |q&a:L&s HWADDR=00:0C:29:96:f3:4aITPUB个人空间}2G3|n]i q ONBOOT=yes V Y&B1zj0[root@localhost ~]#ITPUB个人空间#BY:|P&B\

关于bogon曾经有过注意，但没太注意。这次补一下，从网络搜到的

网络技术中bogon是什么？

Derived from the slang term of bogus (non-existent or fake), 
in Internet terminology the the term bogon is often used to describe a bogus IP address;
or more specifically, the use of an address or a route object that is not properly authorized by the entity to which the address, or resource, was originally assigned.
Bogon filtering
A bogon is an informal name for an IP packet on the public Internet that claims to be from an area of the IPaddress space reserved, but not yet allocated or delegated by the Internet Assigned Numbers Authority (IANA) or a delegated Internet registry. The areas of unallocated address space are called "bogon space".

Many ISPs and end user firewalls filter bogons, because they have no legitimate use, and are therefore the result of accidental or malicious misconfiguration at the sender. Bogons can be filtered by using router ACLs, or byBGP blackholing.

However, as IANA and other registries continue to allocate more of the IP address space, bogon filter lists need to be kept up to date, as otherwise newly legitimate areas of address space will be filtered.

后面文档作者给了一个解释 ：I think that bogon is “DNS解析不出来的ip的主机名” 。

由于出问题环境中 /etc/hosts 跟/etc/resolv.conf 里面配置的内容都无法解析出本机除lo外的ip。所以就给分配了bogon这么一个主机名。看/etc/sysconfig/network中的hostname的值添写的是主机域名localhost.localdomain 网卡配置文件ifcfg-eth0中又为dhcp自动获取IP.所以机器的主机名是由上层ISP分配的.本机的IP地址没有办法在上DNS中解析到,所以就给分配了bogon这个主机名.
.HO@6C&}OA'q0

ITPUB个人空间$[[NFJV

参考文档

http://blog.chinaunix.net/space.php?uid=20565550&do=blog&id=303946\

http://blog.chinaunix.net/space.php?uid=25932176&do=blog&id=2977172

http://bbs.chinaunix.net/thread-2132477-2-1.htmlITPUB个人空间l].V.KbZf [