ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
bioubiou撰写

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 11月 29 11:49:57 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect system/123 as sysdba
已连接到空闲例程。
SQL> start
SP2-1506: START, @ 或 @@ 命令没有参数
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> create pfile from spfil='E:\app\Administrator\product\11.2.0\dbhome_1\datab
ase\SPFILEORCL.ORA';
create pfile from spfil='E:\app\Administrator\product\11.2.0\dbhome_1\database\S
PFILEORCL.ORA'
                  *
第 1 行出现错误:
ORA-00922: missing or invalid option


SQL> create pfile from spfil='E:\app\Administrator\product\11.2.0\dbhome_1\datab
ase\SPFILEORCL.ORA';
create pfile from spfil='E:\app\Administrator\product\11.2.0\dbhome_1\database\S
PFILEORCL.ORA'
                  *
第 1 行出现错误:
ORA-00922: missing or invalid option


SQL> create pfile from spfile='E:\app\Administrator\product\11.2.0\dbhome_1\data
base\SPFILEORCL.ORA';
文件已创建。

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL> create spfile from pfile='E:\app\Administrator\product\11.2.0\dbhome_1\data
base\INITORCL.ORA';

文件已创建。

SQL> stratup
SP2-0042: 未知命令 "stratup" - 其余行忽略。
SQL> strateup
SP2-0042: 未知命令 "strateup" - 其余行忽略。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             301991336 bytes
Database Buffers          469762048 bytes
Redo Buffers                5259264 bytes
数据库装载完毕。
数据库已经打开。
SQL>

以上是解决方法。