Unable To Run Emrepository.Sql Sp2-0310
Last updated on APRIL 18, 2012
Applies to:Oracle Server - Enterprise Edition - Version 10.1.0.3 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