OCP Blog
Super DBA
Master process DM00 violated startup protocol. Master error: ORA-6533: Subscript beyond count
by Vazha Mantua Wednesday, January 11, 2012 10:49 AM

Today we will resolve problem which we had during export data from 10.2.04 database with expdp utility

We was trying epxort data with this command :

expdp scott/scott  DIRECTORY=scott  DUMPFILE=scott.dmp LOGFILE=scott.log SHEMAS=SCOTT

But unfortunately we got a message like this

drop ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SCOTT
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPV$FT", line 1201
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-6533: Subscript beyond count

Resolve of problem

Cause of problem is public synonym with the same name as the user schema name performing the export

Find problematic synonym with command and drop it if it’s possible

select s.synonym_name
from dba_synonyms s
where s.owner = 'PUBLIC'
and s.synonym_name = SCOTT

 

Tags: , , , , , , , , , ,

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox