今天在启动数据库人时候报下面的错误。
- 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>
数据库正常启动。
转载于:https://blog.51cto.com/luoping/273241