DBCA Exception in thread "main" java.lang.NullPointerExcepti

ccmoon

错误
$ dbca
Exception in thread "main" java.lang.NullPointerException
at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1897)
at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1962)
at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1954)
at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1946)
at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1863)
at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddress(NetworkUtils.java:736)
at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddresses(NetworkUtils.java:774)
at oracle.sysman.assistants.util.NetworkUtils.needLocalListener(NetworkUtils.java:712)
at oracle.sysman.assistants.util.step.StepContext.setListenersToUpdate(StepContext.java:485)
at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.java:139)
at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:454)
at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:185)
at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHost.java:54)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:141)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:85)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:161)

解决
#vi $ORACLE_HOME/network/admin/listener.ora
在上面错误的情况下
会丢失<HOST = 172.28.176.68>
就会报上面的NullPointerException

改正后的格式如下
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/adm
in/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.176.58)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = homecc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (SID_NAME = homecc)
    )
  )