1、在线对数据库版本进行升级后，Oracle启动失败。

升级之前好好的，正常都能启动，从11.2.0.1升级到11.2.0.4后，启动报错。

SQL> startup;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=ht_121_90)(PORT=1521))'

SQL>

诡异了，啥都没有变动过，db半年以来都没有变动了，难道listener.ora、sqlnet.ora里面有写？

2、检查oracle配置文件

（1）检查sqlnet.ora，没有ht_121_90的配置

[oracle@ht_121_90 admin]$ more sqlnet.ora

# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /oracle/app/oracle

[oracle@ht_121_90 admin]$

（2）检查listenor.ora，也没有ht_121_90的配置

[oracle@ht_121_90 admin]$ more listener.ora

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SID_NAME = powerdes)

      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.90)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

ADR_BASE_LISTENER = /home/oracle/app/oracle

[oracle@ht_121_90 admin]$

看了下，oracle的基本配置里面都正常，指向ip地址，没有配置ht_121_90。

3、检查服务器网络配置

（1）查看hosts配置，没有ht_121_90的标识

[oracle@ht_121_90 admin]$ more /etc/hosts

127.0.0.1 hch_test_121_90 hch_test_121_90.

192.168.121.90  hch_test_121_90

[oracle@ht_121_90 admin]$

（2）查看ifconfig配置，也没有ht_121_90的标识

[oracle@ht_121_90 admin]$ ifconfig

eth0      Link encap:Ethernet  HWaddr 00:0C:29:30:AF:9F 

          inet addr:192.168.121.90  Bcast:192.168.121.255  Mask:255.255.254.0

          inet6 addr: fe80::20c:29ff:fe30:af9f/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:35786 errors:0 dropped:0 overruns:0 frame:0

          TX packets:4150 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000

          RX bytes:3853621 (3.6 MiB)  TX bytes:671203 (655.4 KiB)

lo        Link encap:Local Loopback 

          inet addr:127.0.0.1  Mask:255.0.0.0

          inet6 addr: ::1/128 Scope:Host

          UP LOOPBACK RUNNING  MTU:16436  Metric:1

          RX packets:37 errors:0 dropped:0 overruns:0 frame:0

          TX packets:37 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:0

          RX bytes:2806 (2.7 KiB)  TX bytes:2806 (2.7 KiB)

[oracle@ht_121_90 admin]$

（3）查看主机名

[root@ht_121_90 ~]# more /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=ht_121_90

[root@ht_121_90 ~]#

[root@ht_121_90 ~]# hostname

ht_121_90

[root@ht_121_90 ~]#