My Oracle Support Banner

Unable To Run Emrepository.Sql Sp2-0310 (Doc ID 332111.1)

Last updated on AUGUST 04, 2018

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.