微软云azure部署oracle报错：PMON (ospid: 7504): terminating the instance due to error 822

最新推荐文章于 2021-08-12 18:44:18 发布

林震南

最新推荐文章于 2021-08-12 18:44:18 发布

阅读量1w

点赞数

分类专栏： linux

本文链接：https://blog.csdn.net/csdnhsh/article/details/95680176

版权

linux 专栏收录该内容

71 篇文章 1 订阅

订阅专栏

oracle11g启动报错，startup nomount失败，后台alert报错日志如下：

[oracle@pldb1 dbs]$ more /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.log
Wed Feb 03 20:56:28 2016
Starting 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 2016
PMON started with pid=2, OS id=7504 
Wed Feb 03 20:57:07 2016
VKTM started with pid=3, OS id=7506 
VKTM running at (100ms) precision 
Wed Feb 03 20:57:07 2016
GEN0 started with pid=4, OS id=7510 
Wed Feb 03 20:57:07 2016
DIAG started with pid=5, OS id=7512 
Wed Feb 03 20:57:07 2016
DBRM started with pid=6, OS id=7514 
Wed Feb 03 20:57:07 2016
PSP0 started with pid=7, OS id=7516 
Wed Feb 03 20:57:07 2016
DIA0 started with pid=8, OS id=7518 
Wed Feb 03 20:57:07 2016
MMAN started with pid=9, OS id=7520 
Wed Feb 03 20:57:07 2016
DBW0 started with pid=10, OS id=7522 
Wed Feb 03 20:57:07 2016
LGWR started with pid=11, OS id=7524 
Wed Feb 03 20:57:07 2016
CKPT started with pid=12, OS id=7526 
Wed Feb 03 20:57:07 2016
SMON started with pid=13, OS id=7528 
Wed Feb 03 20:57:07 2016
RECO started with pid=14, OS id=7530 
Wed Feb 03 20:57:07 2016
MMON 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 2016
MMNL started with pid=16, OS id=7534 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
PMON (ospid: 7504): terminating the instance due to error 822
Instance terminated by PMON, pid = 7504
[oracle@pldb1 dbs]$

这个极大可能是参数文件出故障了，直接找到原来备份的参数文件，然后启动：

SQL> startup pfile='/oracle/pfile.01' nomount
ORACLE instance started.


Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		  855640536 bytes
Database Buffers	  587202560 bytes
Redo Buffers		    8036352 bytes
SQL> 
SQL>  show parameter spfile


NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string
SQL> create spfile from pfile='/oracle/pfile.01';


File created.


SQL> 
SQL> shutdown immediate
ORA-01507: database not mounted




ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.


Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		  855640536 bytes
Database Buffers	  587202560 bytes
Redo Buffers		    8036352 bytes
SQL> 
SQL> 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@pldb1 dbs]$