DanBrother的部落格

Problem:
Encountered EXP-00056 & ORA-31600 invalid input value EMIT_SCHEMA
in Oracle 9.2.0.8

Solution:
@?/rdbms/admin/catexp.sql

shut immediate
startup migrate

** When  a database is started in MIGRATE mode, the following ALTER SYSTEM commands will be set automatically:
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE=MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE=MEMORY;
ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
**************************************************************************************

@?/rdbms/admin/catpatch.sql
@?/rdbms/admin/utlrp.sql

-- Re-start the datababse
startup force