Hello! I want recreate Repository. Version Oracle is 10.1.0.5.0
I do delete repository.
Command:
/opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.250)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBa se)))" -sys_password password -action drop
Log:
[05-06-2008 07:49:45] Checking SYS Credentials ...
[05-06-2008 07:49:45] OK.
[05-06-2008 07:49:45] Dropping the repository..
[05-06-2008 07:49:45] Quiescing DB ...
[05-06-2008 07:49:45] Failed.
[05-06-2008 07:49:45] Checking for Repos User ...
[05-06-2008 07:49:45] Does not Exist.
[05-06-2008 07:49:45] Repos User does not exist ... Continuing with cleanup ...
[05-06-2008 07:49:45] Dropping Roles/Synonymns/Tablespaces ...
[05-06-2008 07:49:46] Done.
[05-06-2008 07:49:46] Unquiescing DB ...
[05-06-2008 07:49:46] Done.
[05-06-2008 07:49:46] Dropped Repository Successfully.
Next I do create repository.
Command
/opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.250)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBa se)))" -sys_password password -action create
Log(general part):
[05-06-2008 07:49:59] Checking SYS Credentials ...
[05-06-2008 07:49:59] OK.
[05-06-2008 07:49:59] Checking DB Init Parameters ...
[05-06-2008 07:49:59] OK.
[05-06-2008 07:49:59] Checking for Repos User ...
[05-06-2008 07:49:59] Does not Exist.
[05-06-2008 07:49:59] Loading necessary DB objects ...
[05-06-2008 07:49:59] Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ...
[05-06-2008 07:49:59] Exists.
[05-06-2008 07:49:59] DBMS POOL package exists.
[05-06-2008 07:49:59] Done Loading necessary DB objects
[05-06-2008 07:49:59] Creating repos user ...
[05-06-2008 07:50:05] Done.
[05-06-2008 07:50:05] Creating EM Schema ...
SP2-0310: unable to open file "/opt/app/oracle/10.1.0/sysman/admin/emdrep/sql/ocs/latest/ovf/ovf_pkgdefs.sql"
declare
*
ERROR at line 1:
ORA-20204: User does not exist: SYSMAN
ORA-06512: at "SYSMAN.MGMT_USER", line 122
ORA-06512: at "SYSMAN.MGMT_JOBS", line 142
ORA-06512: at "SYSMAN.MGMT_JOBS", line 78
ORA-06512: at line 16
[05-06-2008 08:08:31] Failed.
[05-06-2008 08:08:31] Repository Creation failed. Failed to create repository schema.
Log other:
Enter repository user name : sysman
Enter repository user password :
Enter MetaLink user name :
Enter MetaLink user password :
Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Checking SYS Credentials ... OK.
Checking DB Init Parameters ... OK.
Checking for Repos User ... Does not Exist.
Loading necessary DB objects ...
Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists.
DBMS POOL package exists.
Done Loading necessary DB objects
Creating repos user ... Done.
Creating EM Schema ... Failed.
Repository Creation failed. Failed to create repository schema.
Next I do query:
select count(*) from all_users
where username = UPPER('sysman');
Result: 1
Where is problem?
