SQL> select * from dba_roles where role like 'MGMT%';
ROLE PASSWORD
------------------------------ --------
MGMT_USER NO
SQL> select username,default_tablespace from dba_users where account_status='OPEN';
USERNAME DEFAULT_TABLESPACE
------------------------------
------------------------------
SYSTEM SYSTEM
SYS SYSTEM
SYSMAN SYSAUX
DBSNMP SYSAUX
MGMT_VIEW SYSTEM
5 rows selected.
SQL> drop role MGMT_USER;
Role dropped.
SQL> drop user MGMT_VIEW cascade;
User dropped.
SQL> drop user SYSMAN cascade;
User dropped
SQL> drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
Synonym dropped.
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
Synonym dropped.SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
7 rows selected.
SQL> select tablespace_name,file_name from dba_temp_files;
no rows selectedSQL> alter tablespace temp add tempfile '/u01/app/oracle/oradata/ORCL/tempfile01.dbf' size 50M autoextend on;
Tablespace altered.
SQL> select tablespace_name,file_name from dba_temp_files;
TABLESPACE_NAME FILE_NAME
------------------------------ ------------------------------
TEMP /u01/app/oracle/oradata/ORCL/tempfile01.dbf
好了 ，现在可以重新创建了。注意，还是要执行清除操作。
[oracle@db-dest ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Apr 28, 2013 5:21:58 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/products/10.2.0.1/db_1
Database hostname ................ db-dest.ocmu.org
Listener port number ................ 1521
Database SID ................ ORCL
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 28, 2013 5:22:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/products/10.2.0.1/db_1/cfgtoollogs/emca/ORCL/emca_2013-04-28_05-21-58-PM.log.
Apr 28, 2013 5:22:18 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 28, 2013 5:29:03 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 28, 2013 5:29:23 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 28, 2013 5:31:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 28, 2013 5:31:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://db-dest.ocmu.org:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 28, 2013 5:31:14 PM
红色部分是需要设置的，还有sys，dbsnmp，sysman的密码，看到蓝色部分，说明重新创建成功了。
这时，可以进行访问了。http://db-dest.ocmu.org:1158/em
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26812308/viewspace-762396/ ，如需转载，请注明出处，否则将追究法律责任。
