oracle 断电 ora 00132,oracle ORA-00119 ORA-00132 错误的解决方法

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

在另一个终端进入

[root@huang14 ~]# su - oracle

[oracle@huang14 ~]$ cd /opt/oracle/10g/dbs/

[oracle@huang14 dbs]$ strings spfileorcl.ora >initorcl.ora

把下面这行改成下面这样就可以了，注意大小写哦。

[oracle@huang14 dbs]$ grep local_liste initorcl.ora

*.local_listener='(ADDRESS_LIST=(Address=(Protocol=TCP)(Host=192.168.19.11)(Port=1521)))'

SQL> startup nomount pfile='/opt/oracle/10g/dbs/initorcl.ora'

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size              62916852 bytes

Database Buffers          100663296 bytes

Redo Buffers                2973696 bytes

SQL> create spfile from pfile;

File created.

因为在nomount阶段所以我们可以force

SQL> startup force

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size              62916852 bytes

Database Buffers          100663296 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

SQL>