当前位置: 首页 > 工具软件 > osPID > 使用案例 >

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

萧萧迟
2023-12-01

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]$

 类似资料: