一个DBCA错误的解决

lxsfrac04%oracle>dbca

Exception in thread "main" java.lang.NullPointerException

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2656)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2600)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2754)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2600)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2746)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2600)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2545)

        at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:2515)

        at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddressForPort(NetworkUtils.java:877)

        at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddress(NetworkUtils.java:860)

        at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddresses(NetworkUtils.java:914)

        at oracle.sysman.assistants.util.NetworkUtils.needLocalListener(NetworkUtils.java:836)

        at oracle.sysman.assistants.util.step.StepContext.setListenersToUpdate(StepContext.java:679)

        at oracle.sysman.assistants.util.step.StepContext.(StepContext.java:258)

        at oracle.sysman.assistants.dbca.backend.Host.(Host.java:684)

        at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:205)

        at oracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)

        at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)

        at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)

        at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

 

 

之前查过文档，说可能是$oracle_home/network/admin/listener.ora错误，我察看一下我的listener.ora. 好像没什么问题。

 

 

 

 

 

 

 

lxsfrac04%oracle>more listener0812223PM1900.bak

# listener.ora Network Configuration File: /oracle/10g/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER_LXSFRAC04 =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /oracle/10g)

      (PROGRAM = extproc)

    )

  )

 

SID_LIST_LISTENER_LXSFRAC03 =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /oracle/10g)

      (PROGRAM = extproc)

    )

  )

 

LISTENER_LXSFRAC04 =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(IP = FIRST))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.198.90.137)(PORT = 1521)(IP = FIRST))

    )

  )

 

LISTENER_LXSFRAC03 =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(IP = FIRST))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.198.90.138)(PORT = 1521)(IP = FIRST))

    )

  )

 

 

想想，反正dbca时还可以再创建一次listener.ora.不如将其注释掉。

mv $ORACLE_HOME/network/admin/listener.ora     $ORACLE_HOME/network/admin/___listener.ora

 

lxsfrac04%oracle>dbca

Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-1" to type FontStruct

 

SUCCESS