ora-0119与ora-00132 问题处理
<DIV>问题如下</DIV><DIV>SQL> startup;<BR>ORA-00119: invalid specification for system parameter LOCAL_LISTENER<BR>ORA-00132: syntax error or unresolved network name <FONT color=#0000f0>'LISTENER_ORCL'</FONT></DIV>
<DIV>导致数据不能正常startup;</DIV>
<DIV> </DIV>
<DIV>可以在tns.ora 的文件上加开始加上</DIV>
<DIV><FONT color=#0000f0>LISTENER_orcl</FONT> = <BR>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) <BR></DIV>
<DIV>注意加上的listtener的名字与报错的名字一样，保存</DIV>
<DIV>就可以启动数据库。</DIV>
<DIV>SQL> startup;<BR>ORACLE instance started.</DIV>
<DIV>Total System Global Area 313860096 bytes<BR>Fixed Size 1374304 bytes<BR>Variable Size 239077280 bytes<BR>Database Buffers 67108864 bytes<BR>Redo Buffers 6299648 bytes<BR>Database mounted.<BR>Database opened.<BR><BR></DIV>
<DIV>理论上这样也可以完了这个问题，如果要从根本解决此问题</DIV>
<DIV> </DIV>
<DIV>可以进行手动修改pfile的文件内容</DIV>
<DIV>如下操作</DIV>
<DIV> </DIV>
<DIV>SQL> create pfile='d:\1.ora' from spfile;</DIV>
<DIV>File created.</DIV>
<DIV> </DIV>
<DIV>ue 打开 1.ora </DIV>
<DIV>把listener修改成 *.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=localhost)(Port=1521)))'</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>此时把tns.ora 的刚才加上的那句话去掉</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>重新用pfile 打开数据库</DIV>
<DIV> </DIV>
<DIV>SQL> startup pfile='d:\1.ora';<BR>ORACLE instance started.</DIV>
<DIV>Total System Global Area 313860096 bytes<BR>Fixed Size 1374304 bytes<BR>Variable Size 239077280 bytes<BR>Database Buffers 67108864 bytes<BR>Redo Buffers 6299648 bytes<BR>Database mounted.<BR>Database opened.<BR>能正常启动</DIV>
<DIV> </DIV>
<DIV>SQL> create spfile from pfile='d:/1.ora';</DIV>
<DIV>File created.<BR></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>完成</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
页:
[1]