How to handle ORA-27037 problems when creating pfile

When starting the database today, the following problems occur: [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,200 7, Oracle. all Rights Reserved. connected to an idle instance. SQL> startupORA-01078: failure in processing system parameters ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'listeners _ FSYYK1 'Check tnsnames. the ora file finds that the LISTENERS_FSYYK1 configuration is missing, and this configuration does not need to be added because it is changed from dual-host to single-host,

You must manually remove the LOCAL_LISTENER parameter from the parameter file. Because the asm database is used, the parameter is stored in the asm storage. When you create pfile from spfile, the following error is reported: SQL> create pfile from spfile; create pfile from spfileERROR at line 1: www.2cto.com ORA-27037: unable to obtain file status ibm aix risc System/6000 Error: 2: No such file or directoryAdditional information: 3 because the database cannot be opened at this time, I don't know whether to start with spfile or pfile. So I can only try to create pfile from pfile to spfile and then create pfile from asm, then modify [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,200 7, 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 'listeners _ FSYYK1 'SQL> create pfile =/tmp/pfile20090105.ora from spfile = + DGDATA/fsyyk/spfilefsyyk. ora; create pfile =/tmp/pfile20090105.ora from spfileERROR at line 1: www.2cto.com ORA-02236: invalid file name the above problem is that the pfile path should be enclosed in single quotes SQL> create pfile = '/tmp/pfile20090105.ora' from spfile = '+ DGDATA/fsyyk/spfilefsyyk. ora '; File created. SQL> then the vi/tmp/pfile20090105.ora parameter file is removed, the local_listener parameter is removed, and the spfile SQL> create spfile = '+ DGDATA/fsyyk/spfilefsyyk stored in asm is created. ora 'from pfile = '/tmp/pfile20090105.ora'; File created. SQL> startup start database success Summary: If you see the following error when the database is started, you can know that it is spfile start SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENER www.2cto.com ORA-00132: syntax error or unresolved network name 'listeners _ FSYYK1 'if you see the following error when the database is started, you can know that it was started by pfile, that is, an additional ORA-01078 error SQL> startup ORA-01078: failure in processing system parametersORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'listeners _ FSYYK1 'author on8219