数据参数出错 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=172.0.0.1)(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.