 Question about repository creation [message #356047] |
Wed, 29 October 2008 03:23  |
prepek2000
Messages: 5
Registered: October 2008
|
Junior Member |
|
|
Hi to all!
Im not sure does command emca -config dbcontrol db creates repository? I have done cloning of db manually and I've added it successfully to db console, but im not sure does this command creates repository also for this new database?
Regards!
|
|
|
|
|
|
| Re: Question about repository creation [message #356275 is a reply to message #356047] |
Thu, 30 October 2008 02:36  |
prepek2000
Messages: 5
Registered: October 2008
|
Junior Member |
|
|
Thank for reply!
SO just to be sure, i have this scenario now:
I have done cloning of database, but with 2 different names, so mine original database and other two are clones on one server....
So now when i do emca -config dbcontrol db -repos recreate for original db test it goes ok, but for other two db's i receive errors for creating repository, so only command emca -config dbcontrol db goes ok.... Where i make mistake?
|
|
|
|
|
|
| Re: Question about repository creation [message #356610 is a reply to message #356047] |
Fri, 31 October 2008 08:45 |
prepek2000
Messages: 5
Registered: October 2008
|
Junior Member |
|
|
Version of db is 10.2.0 and OS is Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
This is begining of output eror from /cfgtoolllogs/emca/name_of_db
Check if repos user already exists.
old 6: WHERE username=UPPER('&EM_REPOS_USER');
new 6: WHERE username=UPPER('SYSMAN');
old 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
new 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN
old 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
new 11: raise_application_error(-20000, 'SYSMAN does not exists..');
old 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
new 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
old 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..');
new 17: raise_application_error(-20001, 'SYSMAN already exists..');
old 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
.
.
.
.
.
.
.
Set repository version
BEGIN dbms_registry.loaded('EM'); END;
*
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13517
ORA-06512: at "SYS.DBMS_STATS", line 15859
ORA-06512: at "SYS.DBMS_STATS", line 15901
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_REGISTRY", line 560
ORA-06512: at "SYS.DBMS_REGISTRY", line 612
ORA-06512: at line 1
and this is end line....
In the middle of output are successfully commited procedures and etc...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
