ORA-31613 Master process DM00 failed during startup

最新推荐文章于 2021-04-10 12:42:13 发布

jadesuper6

最新推荐文章于 2021-04-10 12:42:13 发布

阅读量6.6k

点赞数

分类专栏： oracle 文章标签： table object 64bit integer oracle database

本文链接：https://blog.csdn.net/jadesuper6/article/details/8086128

版权

这篇博客主要讨论了Oracle数据库在启动过程中遇到的各种错误，如ORA-16038、ORA-00600、ORA-31613等，并提供了相应的解决方案，包括NFS文件系统选项调整、字符集问题解决、RMAN备份与恢复实验等。

摘要由CSDN通过智能技术生成

[oracle@scs_abz_ga_ora ~]$ expdp appd/appd parfile=dp.par

Export: Release 10.2.0.1.0 - 64bit Production on Monday, 15 August, 2011 20:31:26

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user appd
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1193
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.

SQL> show parameter stream

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0
SQL> alter system set streams_pool_size = 48M scope=spfile;

System altered.

SQL> show parameter stream

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size                  2032464 bytes
Variable Size            1275071664 bytes
Database Buffers         6224347136 bytes
Redo Buffers               14741504 bytes
Database mounted.
Database opened.
SQL> show parameter stream

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 48M
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options