ORA-00119 ORA-00132

SQL> startup;
　　ORA-00119: invalid specification for system parameter LOCAL_LISTENER
　　ORA-00132: syntax error or unresolved network name ’LSNR2’

 

1   create pfile from spfile=

 

vi pfile

修改之前可能是这样
　　*.local_listener='LISTENER_NMS'
　　修改后的值大概就是这个样子了
　　*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))'

 alter system set local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))' scope=both;

2   tnsname:

prod =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = prod)

    )

  )

 

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

 

dg =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dg)

    )

  )

 

EMREP =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = EMREP)

    )

  )

 

lsnr2=

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1526))

    )

  )

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-748441/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-748441/