oracle 11g EM 恢复重建方法

最新推荐文章于 2021-04-06 09:08:17 发布
最新推荐文章于 2021-04-06 09:08:17 发布
阅读量267 收藏
点赞数
文章标签： 数据库

问题一：SEVERE: Listener is not up or database service is not registered with it

问题表现如下：

[oracle@xbfye7l01 db_home]$ emca -config dbcontrol db

………………

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 15, 2012 9:45:48 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_15_09_45_23.log.

Aug 15, 2012 9:45:49 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_15_09_45_23.log for more details.

Could not complete the configuration. Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_15_09_45_23.log for more details.

[oracle@xbfye7l01 db_home]$

 

查看日志：

 

[oracle@xbfye7l01 db_home]$ tail -100 /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_15_09_45_23.log

g 15, 2012 9:45:49 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

CONFIG: SQLEngine created successfully and connected

Aug 15, 2012 9:45:49 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

CONFIG: ORA-12541: TNS:no listener

 

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

 

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1898)

        at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)

        at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1000)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:345)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

Aug 15, 2012 9:45:49 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_15_09_45_23.log for more details.

Aug 15, 2012 9:45:49 AM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

        at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)

        at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1000)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:345)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

Aug 15, 2012 9:45:49 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG: Restoring oracle.installer.oui_loc to /apps/product/11.2.0/db_home/oui

解决办法：

最后检查是因为修改Hostname，但hosts文件以及监听未及时修改所致，于是调整完各个参数，保持一至后，发现仍然报同样的错误，又检查发现数据库V$session中的机器名还是原来的hostname，所以重启数据库，机器后一样，但总的问题没有解决。于是重启了机器，该问题解决。但出现了第二个问题，在下面将进行解决。


[oracle@orcl11g lib]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1      localhost

192.168.10.10   orcl11g   orcl11g

问题二：SEVERE: Failed to unlock all EM-related accounts

      和

      SEVERE: Error creating the repository

问题表现1：

 

[oracle@xbfye7l01 ~]$ emca -config dbcontrol db

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:06:21 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_06_08.log.

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Failed to unlock all EM-related accounts

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Failed to unlock all EM-related accounts

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_06_08.log for more details.

Could not complete the configuration. Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_06_08.log for more details.

[oracle@xbfye7l01 ~]$

查看日志：

[root@xbfye7l01 ~]# tail -100 /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_06_08.log

………………

CONFIG: Couldn't execute statement: ORA-01403: no data found

ORA-06512: at "SYSMAN.MGMT_VIEW_PRIV", line 41

ORA-06512: at line 1 (DBD NO_DATA: OCIStmtExecute) at /apps/product/11.2.0/db_home/sysman/admin/scripts/emca/emcaDbUtil.pl line 129, line 2.

 

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.util.PlatformInterface executeCommand

CONFIG: Error executing /apps/product/11.2.0/db_home/sysman/admin/scripts/emca/emcaDbUtil /apps/product/11.2.0/db_home/perl/lib:/apps/product/11.2.0/db_home/perl/lib/site_perl:/apps/product/11.2.0/db_home/sysman/admin/scripts:/apps/product/11.2.0/db_home/bin: /apps/product/11.2.0/db_home/perl/bin/perl /apps/product/11.2.0/db_home/sysman/admin/scripts/emca/emcaDbUtil.pl /apps/product/11.2.0/db_home (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xbfye7l01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=E7DEV))) SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; E7DEV 1 SYSMAN_PWD

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount

CONFIG: Failed to unlock mgmt_view account

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Failed to unlock all EM-related accounts

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Failed to unlock all EM-related accounts

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_06_08.log for more details.

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:348)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

Aug 16, 2012 9:06:23 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG: Restoring oracle.installer.oui_loc to /apps/product/11.2.0/db_home/oui

[root@xbfye7l01 ~]#

问题表现2：

[oracle@xbfye7l01 ~]$ emca -config dbcontrol db -repos create

 

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_12_41.log.

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_repos_create_.log for more details.

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Error creating the repository

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_12_41.log for more details.

Could not complete the configuration. Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_12_41.log for more details.

[oracle@xbfye7l01 ~]$

查看日志：

[root@xbfye7l01 ~]# tail -50 /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_12_41.log

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

CONFIG: isLocalConnectionRequired: true

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

CONFIG: SQLEngine connecting with SID: E7DEV, oracleHome: /apps/product/11.2.0/db_home, and user: SYS

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

CONFIG: SQLEngine created successfully and connected

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig createRepository

CONFIG: Spooling to /apps/cfgtoollogs/emca/E7DEV/emca_repos_create_2012_08_16_09_12_57.log

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig createRepository

CONFIG: ORA-20001: SYSMAN already exists..

ORA-06512: at line 17

 

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..

ORA-06512: at line 17

 

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)

        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1000)

        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)

        at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)

        at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:510)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:228)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_repos_create_.log for more details.

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Error creating the repository

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_12_41.log for more details.

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: Error creating the repository

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:240)

        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)

        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

Aug 16, 2012 9:12:57 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG: Restoring oracle.installer.oui_loc to /apps/product/11.2.0/db_home/oui

[root@xbfye7l01 ~]#

再次尝试：

[oracle@xbfye7l01 ~]$ emca -repos create

 

STARTED EMCA at Aug 16, 2012 9:23:21 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Enter the following information:

Database SID: E7DEV

Listener port number: 1521

Password for SYS user: 

Password for SYSMAN user: 

 

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:23:36 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_23_21.log.

Aug 16, 2012 9:23:36 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Aug 16, 2012 9:23:36 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

Aug 16, 2012 9:23:36 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_repos_create_.log for more details.

Aug 16, 2012 9:23:36 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Error creating the repository

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_23_21.log for more details.

Could not complete the configuration. Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_23_21.log for more details.

[oracle@xbfye7l01 ~]$

解决过程：

1.执行下面的一系统删除命令：

由于之前操作过一次，所以部分报不存在，第一次删除时均正常

SQL> drop user sysman cascade;

         User dropped.

SQL> drop role MGMT_USER;

Role dropped.

SQL>  drop user MGMT_VIEW cascade;

 drop user MGMT_VIEW cascade

           *

ERROR at line 1:

ORA-01918: user 'MGMT_VIEW' does not exist

SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

Synonym dropped.

SQL> drop public synonym SETEMVIEWUSERCONTEXT;

drop public synonym SETEMVIEWUSERCONTEXT

                    *

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

2. 重建测试，问题依然存在。

[oracle@xbfye7l01 ~]$ emca -repos create

 

STARTED EMCA at Aug 16, 2012 9:30:15 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Enter the following information:

Database SID: E7DEV

Listener port number: 1521

Password for SYS user: 

Password for SYSMAN user: 

 

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:30:24 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_30_15.log.

Aug 16, 2012 9:30:24 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Aug 16, 2012 9:31:37 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

Aug 16, 2012 9:31:37 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_repos_create_.log for more details.

Aug 16, 2012 9:31:37 AM oracle.sysman.emcp.EMConfig perform

SEVERE: Error creating the repository

Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_30_15.log for more details.

Could not complete the configuration. Refer to the log file at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_30_15.log for more details.

[oracle@xbfye7l01 ~]$

3. 删除数据库的 Database Control配置

 

[oracle@xbfye7l01 ~]$ emca -deconfig dbcontrol db

STARTED EMCA at Aug 16, 2012 9:46:37 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Enter the following information:

Database SID: E7DEV

 

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:46:42 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_46_36.log.

Aug 16, 2012 9:46:42 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration

WARNING: EM is not configured for this database. No EM-specific actions can be performed.

Enterprise Manager configuration completed successfully

FINISHED EMCA at Aug 16, 2012 9:46:42 AM

[oracle@xbfye7l01 ~]$

 

4.  删除EM资料库

 

[oracle@xbfye7l01 ~]$ emca -repos drop

 

STARTED EMCA at Aug 16, 2012 9:47:09 AM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Enter the following information:

Database SID: E7DEV

Listener port number: 1521

Password for SYS user: 

Password for SYSMAN user: 

 

Do you wish to continue? [yes(Y)/no(N)]: Y

Aug 16, 2012 9:47:18 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /apps/cfgtoollogs/emca/E7DEV/emca_2012_08_16_09_47_09.log.

Aug 16, 2012 9:47:18 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...

Aug 16, 2012 9:47:56 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

FINISHED EMCA at Aug 16, 2012 9:47:56 AM

CONFIG: ORA-00955: name is already used by an existing object

5.查看日志得oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00955: name is already used by an existing object

如果在recreate 中遇到 CONFIG: ORA-00955: name is already used by an existing object
查看相关详细日志，drop相应对象即可。完整的DROP如下：
DROP PUBLIC SYNONYM MGMT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;
DROP PUBLIC SYNONYM MGMT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;
DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;
DROP PUBLIC SYNONYM MGMT_GUID_OBJ;
DROP PUBLIC SYNONYM MGMT_METRICS;
DROP PUBLIC SYNONYM MGMT_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS;
DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR;
DROP PUBLIC SYNONYM MGMT_METRICS_1DAY;
DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS;
DROP PUBLIC SYNONYM MGMT_TARGET;
DROP PUBLIC SYNONYM MGMT_TARGETS;
DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY;
DROP PUBLIC SYNONYM MGMT_LONG_TEXT;
DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_DELTA;
DROP PUBLIC SYNONYM MGMT_DELTA_IDS;
DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;
DROP PUBLIC SYNONYM MGMT_NAME_VALUE;
DROP PUBLIC SYNONYM MGMT_NAME_VALUES;
DROP PUBLIC SYNONYM MGMT_JOB;
DROP PUBLIC SYNONYM MGMT_JOBS;
DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;
DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;
DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY;
DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;
DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;
DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;
DROP PUBLIC SYNONYM MGMT_JOB_TARGET;
DROP PUBLIC SYNONYM MGMT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_ADMIN;
DROP PUBLIC SYNONYM MGMT_GLOBAL;
DROP PUBLIC SYNONYM MGMT_LOG;
DROP PUBLIC SYNONYM MGMT_CREDENTIAL;
DROP PUBLIC SYNONYM MGMT_PREFERENCES;
DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST;
DROP PUBLIC SYNONYM MGMT_PAF_JOBS;
DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES;
DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS;
DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES;
DROP PUBLIC SYNONYM MGMT_PAF$STATES;
DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY;
DROP PUBLIC SYNONYM EMD_MNTR;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY;
DROP PUBLIC SYNONYM ECM_UTIL;
DROP PUBLIC SYNONYM MGMT_USER;
DROP PUBLIC SYNONYM MGMT_VIEW_UTIL;
DROP PUBLIC synonym SETEMVIEWUSERCONTEXT;
DROP PUBLIC SYNONYM MGMT_MESSAGES;
DROP ROLE MGMT_USER;

DROP USER MGMT_VIEW CASCADE;

DROP USER SYSMAN CASCADE;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28751069/viewspace-758719/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28751069/viewspace-758719/

cuganxie1879
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle11g 重建EM
huchen0907的专栏
03-03 845
1、Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects: drop user SYSMAN cascade; drop role MGMT_USER;                              drop public synonym MGMT
Oracle EM控制台恢复
专栏
11-12 314
打开oracle目录可以看到一个ip_oracleSID的目录，如果机器的IP发生变化，那么此console em无法启动，重新配置建立： emca -config dbcontrol db 按照提示来就可以了...
oracle 11g EM Dbconsole重建
hzcyhujw的博客
12-27 870
概述：oracle数据库的日常管理可以使用命令行及图形化界面进行管理；命令行的命令工具有sqlplus 、srvctl 、 crsctl 等命令，图形化界面有10g版本的EM dbconsole、11g版本的EM dbconsole、grid control 集中管理、12c版本中的EM express、cloud control集中管理；本文将对11g中的EM dbconsole工具进行简单安装
14.2 使用EXPDP
毅无涯
01-04 2622
14.2.1 EXPDP 命令行选项 关键字               说明 (默认) ------------------------------------------------------------------------------ ATTACH                连接到现有作业, 例如 ATTACH [=作业名]。 COMPRESSION    
Linux Oralce EM企业管理器的安装
baichi1616的博客
01-11 1240
Oracle EM（Enterprise Manager） 是基于B/S的web界面oracle数据库管理工具 EM安装: 1`.root 用户登录服务器 2.切换到oracle用户 #su - oracle 3.删除旧的EM #emca -deconfig dbcontrol db -repos droporacle@linux-hxmo:~> emca -deconfig d
oracle 11g em重建报唯一约束错误解决方法
12-16
在尝试配置Oracle 11g Enterprise Manager (EM) 时，可能会遇到一个特定的错误，即“ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) violated”。这个错误表明在尝试插入或更新数据到SYSMAN....
oracle em重建
06-18
【Oracle EM重建】是指在Oracle 11g R2环境中，由于各种原因（如系统故障、硬件更换或软件升级）导致企业管理器（Enterprise Manager，简称EM）无法正常工作时，需要进行的一系列恢复操作。Oracle EM是Oracle数据库...
oracle 10G EM 配置总结
10-16
Oracle 10G Enterprise Manager (EM) 是一款强大的管理工具，用于监控、管理和优化Oracle数据库环境。在10G版本中，EM分为两个主要组件：Database Control（DBControl）和Grid Control。DBControl专注于单一数据库的...
Oracle数据库的冷备份及冷备份异地恢复方法
12-14
3. **重建企业管理器(EM)**：异地恢复后，数据库的主机连接字符串会是备份机器的主机名。因此，为了在新机器上正常使用EM，需要进行以下操作： - 删除EM：运行`emca -repos drop`，然后根据提示输入数据库信息。 -...
oracle重装EM档案库dbcon服务命令
11-05
在提供的压缩包文件"重建oracle11g的em命令.txt"中，可能会包含上述步骤的具体命令行示例，这对于实际操作非常有用。请仔细阅读并根据你的环境进行适当调整。在整个过程中，确保遵循最佳实践，如在进行重大操作前...
oracle 10.2.0.4 expdp全库导出 和分用户impdp导入的记录
cuanmo8775的博客
11-24 339
oracle 10.2.0.4 expdp全库导出 导出语句：D:oracleproduct10.2.0db_1BINexpdp system/aaaaaa dumpfile=all_1124.dmp DIRECTORY=dm...
配置EM遇到的两个问题
热门推荐
DATA
08-16 1万+
问题一：SEVERE: Listener is not up or database service is not registered with it 问题表现如下： [oracle@xbfye7l01 db_home]$ emca -config dbcontrol db ……………… ------------------------------------------------
oracle 中的OracleDBConsole(sid)无法启动
luohai859的专栏
08-24 699
G:\Documents and Settings\Administrator>emca -repos drop EMCA 开始于 2011-4-11 9:58:44 EM Configuration Assistant 10.2.0.1.0 正式版 版权所有 (c) 2003, 2005, Oracle。保留所有权利。 输入以下信息: 数据库 SID: orcl 监听
oracle创建资料档案库时出错,严重: 将配置数据下载到资料档案库时出错
weixin_29829343的博客
04-06 1156
严重: 将配置数据下载到资料档案库时出错严重: 将配置数据下载到资料档案库时出错日期：2014-05-16　 浏览次数：20524 次严重: 将配置数据上载到资料档案库时出错创建时前面正常省略。。。错误部分：信息:有关详细资料,请参阅D:\app\Administrator\cfgtoollogs\emca\cjtfsdb\emca_repos_config_.log中的日志文件。2011...
oracle手工重建EM步骤
白非马的博客
12-28 2904
手工重建EM
oracle_fdw使用,oracle_fdw
weixin_29736885的博客
04-05 531
请教一个oracle_fdw的问题：在oracle中有表SQL> desc pgtest1; Name Null? Type ----------------------------------------- -------- ---------------------------- ID ...
Oracle 11g数据库管理：修复与恢复策略
"Oracle Database 11g: Administration 1Z0-053 考试相关的学习资料，版本V10.02，涵盖了数据库管理的多个方面，包括闪回事务、恢复管理（RMAN）等核心知识点。" 在Oracle Database 11g的1Z0-053认证考试中，主要...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值