微軟雲azure部署oracle報錯：PMON (ospid: 7504): terminating the instance due to error 822

標籤：

oracle11g啟動報錯，startup nomount失敗，後台alert報錯日誌如下：

[[email protected] dbs]$ more /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.logWed Feb 03 20:56:28 2016Starting ORACLE instance (normal)....  dispatchers              = "(PROTOCOL=TCP) (SERVICE=powerdesXDB)"  audit_file_dest          = "/oracle/app/oracle/admin/powerdes/adump"  audit_trail              = "DB"  db_name                  = "powerdes"  db_unique_name           = "pdunq"  open_cursors             = 300  diagnostic_dest          = "/oracle/app/oracle"Wed Feb 03 20:57:07 2016PMON started with pid=2, OS id=7504 Wed Feb 03 20:57:07 2016VKTM started with pid=3, OS id=7506 VKTM running at (100ms) precision Wed Feb 03 20:57:07 2016GEN0 started with pid=4, OS id=7510 Wed Feb 03 20:57:07 2016DIAG started with pid=5, OS id=7512 Wed Feb 03 20:57:07 2016DBRM started with pid=6, OS id=7514 Wed Feb 03 20:57:07 2016PSP0 started with pid=7, OS id=7516 Wed Feb 03 20:57:07 2016DIA0 started with pid=8, OS id=7518 Wed Feb 03 20:57:07 2016MMAN started with pid=9, OS id=7520 Wed Feb 03 20:57:07 2016DBW0 started with pid=10, OS id=7522 Wed Feb 03 20:57:07 2016LGWR started with pid=11, OS id=7524 Wed Feb 03 20:57:07 2016CKPT started with pid=12, OS id=7526 Wed Feb 03 20:57:07 2016SMON started with pid=13, OS id=7528 Wed Feb 03 20:57:07 2016RECO started with pid=14, OS id=7530 Wed Feb 03 20:57:07 2016MMON started with pid=15, OS id=7532 starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))‘...Wed Feb 03 20:57:07 2016MMNL started with pid=16, OS id=7534 starting up 1 shared server(s) ...ORACLE_BASE from environment = /oracle/app/oraclePMON (ospid: 7504): terminating the instance due to error 822Instance terminated by PMON, pid = 7504[[email protected] dbs]$ 

這個極大可能是參數檔案出故障了，直接找到原來備份的參數檔案，然後啟動：

SQL> startup pfile=‘/oracle/pfile.01‘ nomountORACLE instance started.Total System Global Area 1453092864 bytesFixed Size    2213416 bytesVariable Size  855640536 bytesDatabase Buffers  587202560 bytesRedo Buffers    8036352 bytesSQL> SQL>  show parameter spfileNAME     TYPE VALUE------------------------------------ ----------- ------------------------------spfile     stringSQL> create spfile from pfile=‘/oracle/pfile.01‘;File created.SQL> SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startup nomountORACLE instance started.Total System Global Area 1453092864 bytesFixed Size    2213416 bytesVariable Size  855640536 bytesDatabase Buffers  587202560 bytesRedo Buffers    8036352 bytesSQL> SQL> SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[[email protected] dbs]$ 

微軟雲azure部署oracle報錯：PMON (ospid: 7504): terminating the instance due to error 822