Unable To Run Emrepository.Sql Sp2-0310

(Doc ID 332111.1)

Last updated on APRIL 18, 2012

Applies to:

Oracle Server - Enterprise Edition - Version and later
HP OpenVMS Alpha
Digital Alpha OpenVMS


Checked for currency on 18-Apr-2012.


Having generated scripts with the Database Configuration Assistant (DBCA). The emrepository.sql is failing as follows : -

Check if repos user already exists.

SP2-0310: unable to open file "disk:[oracle_disk.oracle10g]/sysman/admin/emdrep/sql/core/latest/admin/admin_check_repos_user.sql"

Create SYSMAN user.

SP2-0310: unable to open file "disk:[oracle_disk.oracle10g]/sysman/admin/emdrep/sql/core/latest/admin/admin_create_repos_user.sq"
BEGIN dbms_registry.loading('EM', 'Oracle Enterprise Manager', null, 'SYSMAN'); END;

ERROR at line 1:
ORA-39706: schema 'SYSMAN' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 88
ORA-06512: at "SYS.DBMS_REGISTRY", line 641
ORA-06512: at line 1

Verified from uploaded log


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms