oracle启动失败ORA-01078/LRM-00109

oracle 启动失败报错ORA-01078/LRM-00109
1、故障现象：
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initmesdevdb.ora’

2、解决思路
a,数据库创建的时候指定的实例名为ORCL，但是报错说指定到了initmesdevdb.ora文件
b,查看$ORACLE_HOME/dbs文件没有initmesdevdb.ora，但是有spfileorcl.ora参数启动文件
c,于是启动的时候使用spfileorcl.ora做为pfile启动

3、根据pfile启动数据库，发现里面有字符
SQL> startup nomount pfile=‘/u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.ora’;
LRM-00123: invalid character 0 found in the input file
ORA-01078: failure in processing system parameters

查看spfileorcl.ora中有一堆的乱码
C"^@@^A@^@@^@@^@@^@@^AD<9d>^G@^@@^@@^@@@^@@^@@^@@^@@^@@^@@^@@^@AC^@@C"^@@^B@^@@^@@^@@^@@^ADBZ^@@orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=8321499136
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=0
orcl.__large_pool_size=67108864
orcl.__oracle_base=‘/u01/app/oracle’#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=3355443200
orcl.__sga_target=10032775168
orcl.__shared_io_pool_size=134217728
orcl.__shared_pool_size=1476395008
orcl.__streams_pool_size=0
orcl.unified_pga_pool_size=0
*.audit_file_dest=‘/u01/app/oracle/admi^AC@^@C"@^@C^@@^@@^@@^@@^@A^D]|^@@n/orcl/adump’
*.audit_trail=‘db’
*.compatible=‘19.0.0’
*.control_files='/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_mpbmqp6m.ctl’
*.db_block_size=8192
*.db_create_file_dest=‘/u01/app/oracle/oradata’
*.db_name=‘orcl’
*.diagnostic_dest=‘/u01/app/oracle’
*.dispatchers=‘(PROTOCOL=TCP) (SERVICE=orclXDB)’
*.nls_language=‘AMERICAN’
*.nls_territory=‘AMERICA’
*.open_cursors=300
*.pga_aggregate_target=3187m
*.processes=2000
*.remote_login_passwordfile=‘EXCLUSIVE’
*.sga_target=9561m
*.undo^AC@^@C"@^@D^@@^@@^@@^@@^@A^D+@@^@tablespace=‘UNDOTBS1’
^@@^@@^@@^@@^@@^@@^@^@@@
于是将乱码文件全部删掉，只保留参数重启启动；

4、数据库启动mount状态正常了，然后启动到open
SQL> startup nomount pfile=‘/u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.ora’;
ORACLE instance started.

Total System Global Area 1.0033E+10 bytes
Fixed Size 13682912 bytes
Variable Size 1644167168 bytes
Database Buffers 8355053568 bytes
Redo Buffers 19869696 bytes

5、记得通过pfile创建新的spfile，下次启动的时候自动根据spfile启动；
SQL> create spfile from pfile=‘/u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.ora’;
File created.

6、重启数据库，自动会找新的spfile，数据库启动成功
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.0033E+10 bytes
Fixed Size 13682912 bytes
Variable Size 1644167168 bytes
Database Buffers 8355053568 bytes
Redo Buffers 19869696 bytes
Database mounted.
Database opened.
SQL> show parameter spfile
spfile string
/u01/app/oracle/product/19.3.0
/dbhome_1/dbs/spfilemesdevdb.o
ra