问题

SQL> STARTUP

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name ‘LISTENER_ORCL’

解决

 修改 tnsnames.ora文件：

1、增加如下内容：

LISTENER_ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ROCL)

    )

  )

2、执行：

SQL> STARTUP

    如下显示表示成功！

    Total System Global Area 1912602624 bytes

    Fixed Size                  2005192 bytes

    Variable Size             369100600 bytes

    Database Buffers         1526726656 bytes

    Redo Buffers               14770176 bytes

    Database mounted.

    Database opened.