作者：无名有名我无名_593 | 来源：互联网 | 2014-07-13 17:52
今天启动数据库的时候，出现以下问题：[root@p570a2:/crs/app/oracle/product/crs_1/bin]#su-oracle[oracle@p570a2:/oracle/app/oracle]$sqlplus"/assysdba"SQL*Plus:Release10.2.0
[root@p570a2:/crs/app/oracle/product/crs_1/bin]#su - oracle
[oracle@p570a2:/oracle/app/oracle]$sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 5 11:53:42 2010
www.2cto.com
Copyright (c) 1982, 2007,
Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name &＃39;LISTENERS_FSYYK1&＃39;
检查tnsnames.ora文件发现少了LISTENERS_FSYYK1 配置,而这个配置因为由双机改为单机不需要添加,
必须从参数文件中手工去掉LOCAL_LISTENER参数
由于这个用的asm数据库,参数也放在asm存储中,create pfile from spfile时,报以下错误
SQL> create pfile from spfile;
create pfile from spfile
ERROR at line 1:
www.2cto.com
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
由于这个时候数据库无法打开,不知道是用spfile启动还是pfile启动
所以只能试先从pfile创建成spfile,再从asm位置创建成pfile,然后进行修改
[oracle@p570a2:/oracle/app/oracle]$sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 5 11:57:38 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name &＃39;LISTENERS_FSYYK1&＃39;
SQL> create pfile=/tmp/pfile20090105.ora from spfile=+DGDATA/fsyyk/spfilefsyyk.ora;
create pfile=/tmp/pfile20090105.ora from spfile
ERROR at line 1:
www.2cto.com
ORA-02236: invalid file name
上面这个问题是pfile路径要加单引号
SQL> create pfile=&＃39;/tmp/pfile20090105.ora&＃39; from spfile=&＃39;+DGDATA/fsyyk/spfilefsyyk.ora&＃39;;
File created.
SQL>
然后vi /tmp/pfile20090105.ora 参数文件,去掉local_listener参数
再创建asm存储的spfile
SQL> create spfile=&＃39;+DGDATA/fsyyk/spfilefsyyk.ora&＃39; from pfile=&＃39;/tmp/pfile20090105.ora&＃39; ;
File created.
SQL> startup
启动数据库成功
总结:
如果看到数据库启动时报以下错误,则可以知道是spfile启动的
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
www.2cto.com
ORA-00132: syntax error or unresolved network name &＃39;LISTENERS_FSYYK1&＃39;
如果看到数据库启动时报以下错误,则可以知道是pfile启动的,即多了ORA-01078错误
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name &＃39;LISTENERS_FSYYK1&＃39;
作者 aaron8219
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 
