ORA-31613 Master process DM00 failed during startup
来源:互联网 发布:爱苹果软件 编辑:程序博客网 时间:2024/06/15 23:48
[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
[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:34:55
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
Starting "appd"."SYS_EXPORT_TABLE_01": appd/******** parfile=dp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 30.75 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "appd"."ROBOTS_ARTICLE" 12.14 MB 1011 rows
Master table "appd"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for appd.SYS_EXPORT_TABLE_01 is:
/home/oracle/zangwen.dmp
catalog备份数据库
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
[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:34:55
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
Starting "appd"."SYS_EXPORT_TABLE_01": appd/******** parfile=dp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 30.75 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "appd"."ROBOTS_ARTICLE" 12.14 MB 1011 rows
Master table "appd"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for appd.SYS_EXPORT_TABLE_01 is:
/home/oracle/zangwen.dmp
Job "appd"."SYS_EXPORT_TABLE_01" successfully completed at 20:35:16
ORA-16038的解决
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
ORA-31613 Master process DM00 failed during startup
ORA-24324 ORA-01041 ORA-03113
ORA-27125: unable to create shared memory segment
ORA-00245: control file backup operation failed
ORA-00245: control file backup operation failed
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)
- ORA-31613 Master process DM00 failed during startup
- Master Startup
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (Doc ID 393984.1)
- FATAL: DTM initialization: failure during startup recovery, retry failed, check segment status (cdb
- ORA-31694: master table "BACKUP"."SYS_IMP_FULL_01" failed to load/unload
- 一次“ORA-00444: background process "MMAN" failed while starting”处理
- ORA-00444: background process DBRM failed while starting
- redboot startup process
- Linux startup process
- Linux startup process
- linux kernel startup process!
- Understanding the Startup Process
- 读书札记:The build process failed during preparation of the resulting assembly
- qt安装时“Error during installation process(qt.tools.perl):Execution failed”的解决办法
- STARTUP Database failed ORA-38760 to turn on Flashback Database (Doc ID 1554596.1)
- startup就ORA-03113:
- rsync详解二
- 如何在Oracle SQL Developer 中连接MS SQL Server、MySQL数据库(转)
- gdb breakpoint
- 如何从C# 桌面应用程序调用Windows 8的WinRT API- WinRT 图表
- 【总结】搜索的剪枝二分预处理和离散化等优化
- ORA-31613 Master process DM00 failed during startup
- java压缩文件夹包含所有子文件夹以及子文件
- 湖北干部3年上缴礼金3170万 多名厅官被问责-上缴礼金-官员违纪-庸懒散软问题
- 网页源文件代码隐藏的代码(转)
- How to Perfectly Uninstall Kaspersky Anti-Virus 2012/2013
- C#中的数据类型
- 成功并不像你想的那么难
- 了解OCX控件
- 【JSP】页面的异常处理