Once the Oracle EM experience is configured

For Oracle10grac constructs em, originally very easy thing, but it takes a long time to record down. MEMO.

First, for example, the following error was reported:

[[email protected] admin]$ emca-config dbcontrol dbstarted emca at 9:06:47 amem Configuration Assistant  , Version 10.2.0.5.0 Productioncopyright (c) 2003, Oracle. All rights reserved. Enter the following information:database sid:racdb1listener Port Number:1521password for SYS User:password for DBSNMP User:aug, 9:06:57 AM oracle.sysman.emcp.util.GeneralUtil initsqlenginewarning:ora-28000:the account is LOCKEDP  Assword for Sysman User:aug, 9:07:02 AM oracle.sysman.emcp.util.GeneralUtil initsqlenginewarning:ora-28000:the Account was Lockedemail address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): AS M Oracle_home [/u01/app/oracle/product/11.2.0/db]: ASM SID [+ASM]: ASM Port [1521]: ASM user Role [SYSDBA]: ASM US Ername [SYS]: ASM user password:asm user password:-----------------------------------------------------------------Y OU have specified the following settingsdatabase oracle_home .... node1listener port number/u01/app/oracle/product/11.2.0/dblocal hostname ......????????????.. ................ 1521Database SID ..... racdb1email address for notifications .................. Outgoing Mail (SMTP) server for notifications ..... ..... ASM oracle_home ..../u01/app/oracle/product/11.2.0/dbasm SID .... +asmasm port, .....???????????. ................ 1521ASM user Role ....... ..... Sysdbaasm username ....... ..... SYS-----------------------------------------------------------------does wish to continue? [Yes (Y)/no (N)]: Yaug, 9:12:22 AM oracle.sysman.emcp.EMConfig performinfo:this operation is being logged at/u01/a Pp/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-am.log.aug, 9:12:34 AM Oracle.sysman.emcp.util.DBControlUtil securedbconsoleinfo:securing Database Control (This is a while) ... 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil securedbconsoleinfo:database controL secured successfully. 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil startomsinfo:starting Database Control (This could take a whi Le) ... 9:17:40 AM oracle.sysman.emcp.util.PlatformInterface executecommandwarning:error executing/u01/app/ Oracle/product/11.2.0/db/bin/emctl start Dbconsole, 9:17:40 AM oracle.sysman.emcp.EMConfig performsevere: Error starting Database Controlrefer to the log file At/u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_ 2014-08-17_09-06-47-am.log for more details. Could not complete the configuration. Refer to the log file At/u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-am.log for More details.

9:17:40 AM oracle.sysman.emcp.EMConfig performconfig:stack Trace: Oracle.sysman.emcp.exception.EMConfigException:Error starting Database Controlat Oracle.sysman.emcp.EMDBPostConfig.performConfiguration (emdbpostconfig.java:649) at Oracle.sysman.emcp.EMDBPostConfig.invoke (emdbpostconfig.java:227) at Oracle.sysman.emcp.EMDBPostConfig.invoke ( emdbpostconfig.java:196) at Oracle.sysman.emcp.EMConfig.perform (emconfig.java:184) at Oracle.sysman.emcp.EMConfigAssistant.invokeEMCA (emconfigassistant.java:494) at Oracle.sysman.emcp.EMConfigAssistant.performConfiguration (emconfigassistant.java:1161) at Oracle.sysman.emcp.EMConfigAssistant.statusMain (emconfigassistant.java:478) at Oracle.sysman.emcp.EMConfigAssistant.main (emconfigassistant.java:426)

Online data search is a bug for Oracle.

Oracle's explanation for this is:

In Enterprise Manager database Control with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to secure COM Munications via the Secure Socket Layer (SSL) protocol would expire on 31-dec-2010 00:00:00. The certificate expiration would cause errors if you attempt to configure Database Control on or after 31-dec-2010. Existing Database Control configurations is not affected by this issue.

IF you plan to configure database Control with either of these Oracle Database releases, Oracle strongly recommends that Y ou apply Patch 8350262 to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically do when you create or upgrade Oracle Database, or if you run Enterprise M Anager Configuration Assistant (EMCA) in standalone mode.

Ability to view: Enterprise Manager Database Control configuration-recovering from Errors Due to CAS expiry on Oracle Database 10.2.0 .4 or 10.2.0.5 [Video] [ID 1222603.1]

Workaround:

If you have already made this patch before creating an instance, you will not be able to make an error after that.

Suppose that this patch was hit after the instance was created. Then you need to run the following:

for single-instance:
1. Installing Patch 8350262 with Opatch
2. Set the Oracle_home and ORACLE_SID environment variables. Run <patch_home>/killdbconsole. (This step is omitted from the Windows platform)
3.re-secure Database Control with the following command:
<oracle_home>/bin/emctl Secure Dbconsole-reset
4.re-start Database Control with the following command:
<oracle_home>/bin/emctl Start Dbconsole


for RAC:
1. Install patch 8350262 with Opatch and install on one node is OK.
2. Run on all nodes: set Oracle_home and ORACLE_SID environment variables. Run <patch_home>/killdbconsole. (This step is omitted from the Windows platform)
3.re-secure Database Control on the first cluster node with the following command:
<oracle_home>/bin/emctl Secure Dbconsole-reset
4.re-secure Database Control on the remaining cluster nodes with the following command. Note that The-reset switch was not included with the This command:
<oracle_home>/bin/emctl Secure Dbconsole
5.re-start Database Control by executing the following command on each node in the cluster:
<oracle_home>/bin/emctl Start Dbconsole

After patching. Clear and new EM, a variety of error, helpless under the manual deletion of various data:

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith The partitioning, Real appli Cation Clusters, OLAP, Data miningand Real application testing optionssql> DROP public synonym Setemviewusercontext; Synonym dropped. sql> DROP public synonym mgmt_target_blackouts; Synonym 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 existsql> DROP USER Sysman CASCADE; User dropped. Sql> exit

After the new EM succeeds.

[[email protected] ~]$ emca-config dbcontrol db-repos createstarted emca at 2:58:04 Pmem Configuration  Assistant, Version 10.2.0.5.0 Productioncopyright (c) 2003, Oracle. All rights reserved. Enter the following information:database sid:racdb1listener Port Number:1521password for SYS User:password for DBSNMP User:password for Sysman User:email address for notifications (optional): Outgoing Mail (SMTP) Server for notification s (optional): ASM Oracle_home [/u01/app/oracle/product/11.2.0/db]: ASM SID [+asm]: +asm1asm port [1521]: ASM user ro Le [SYSDBA]: ASM username [SYS]: ASM user password:----------------------------------------------------------- ------You have specified the following Settingsdatabase oracle_home ...../u01/app/oracle/product/11.2.0/..... dblocal hostname ..... Node1listener port number ..... .......... .........---------------" 1521Database SID ..... racdb1email address for notifications .................. Outgoing Mail (SMTP) server for notifications ..... ..... ASM oracle_home ..../u01/app/oracle/product/11.2.0/dbasm SID .... +asm1asm port, .....???????????. ................ 1521ASM user Role ....... ..... Sysdbaasm username ....... ..... SYS-----------------------------------------------------------------does wish to continue? [Yes (Y)/no (N)]: Yaug, 2:58:32 PM oracle.sysman.emcp.EMConfig performinfo:this operation is being logged at/u01/a Pp/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_02-58-04-pm.log.aug, 2:58:34 PM Oracle.sysman.emcp.EMReposConfig createrepositoryinfo:creating the EM repository (this is a while) ... 3:02:14 PM oracle.sysman.emcp.EMReposConfig invokeinfo:repository successfully Createdaug, 3:02:24 P M oracle.sysman.emcp.util.DBControlUtil securedbconsoleinfo:securing Database Control (This is a while) ... 3:02:50 PM Oracle.sysman.emcp.util.DBControlUtil Securedbconsoleinfo:database Control secured successfully. 3:02:50 PM oracle.sysman.emcp.util.DBControlUtil startomsinfo:starting Database Control (This could take a whi Le) ... 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performconfigurationinfo:database Control started Successfullyaug, 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performconfigurationinfo: >>>>> >>>>>> the Database Control URL is https://node1:1158/em <<<<<<<<<< <enterprise Manager configuration completed successfullyfinished EMCA at 3:04:27 PM

After landing. Found not RAC em, once again configured

[[email protected] dbs]$ cd/u01/app/crs_home/bin[[email protected] bin]$ ./cemutlo-ncrs[[email  Protected] bin]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-production on Sun 17:18:28 2014Copyright (c) 198  2, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part     Itioning, real application Clusters, OLAP, Data miningand Real application Testing optionssql> show parameter NameName TYPE VALUE-----------------------------------------------------------------------------Db_file_name_convert stri Ngdb_name string Racdbdb_unique_name string Racdbglobal_names boolean trueinstance_name string Racdb1lock _name_space Stringlog_file_name_convert stringservice_names string Service1, Sys$admin. Target_que UE. Racdb.  Epoint.com, Service2, racdb.epoint.comsql>

[[email protected] dbs]$ emca-config dbcontrol db-repos create-clusterstarted emca at 5:02:15 PMEM Co  Nfiguration Assistant, Version 10.2.0.5.0 Productioncopyright (c) 2003, the Oracle. All rights reserved. Enter the following information:database unique Name:racdbdatabase Control is already configured for the Database RACDBYO  U has chosen to configure database Control for managing the database Racdbthis would remove the existing configuration and The default settings and perform a fresh configurationdo you wish to continue? [Yes (Y)/no (N)]: Ylistener port number:1521cluster Name:crspassword for SYS user:password for DBSNMP user:password fo R Sysman User:email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM Oracle_home [/u01/app/oracle/product/11.2.0/db]: ASM Port [1521]: ASM user Role [SYSDBA]: ASM username [SYS]: ASM User password:-----------------------------------------------------------------You have specified the following Settingsdatabase oracle_home ......./u01/app/oracle/product/11.2.0/. Dbdatabase instance hostname ..... Node1listener port number ..... .....??????????? .....----* * * * * * * * * * * * * * ..... 1521Cluster name .... crsdatabase unique name .... racdbemail address for notifications .... ..... .....?????????????. ...... Outgoing Mail (SMTP) server for notifications ..... ..... ASM oracle_home .... .../u01/app/oracle/product/11.2.0/dbasm port ............ ...................-----------" 1521ASM user Role ....... ..... Sysdbaasm username ....... ..... SYS-----------------------------------------------------------------does wish to continue?
 
 
 [Yes (Y)/no (N)]: Yaug, 5:02:38 PM oracle.sysman.emcp.EMConfig performinfo:this operation is being logged at/u01/ App/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_05-02-15-pm.log.aug, 5:02:40 PM Oracle.sysman.emcp.util.DBControlUtil stopomsinfo:stopping Database Control (This is a while) ...  5:02:44 PM oracle.sysman.emcp.EMReposConfig createrepositoryinfo:creating the EM repository (this could take a While) ... 5:05:22 PM oracle.sysman.emcp.EMReposConfig invokeinfo:repository successfully Createdaug, 5:05:27 P M Oracle.sysman.emcp.EMDBCConfig instantiateoc4jconfigfilesinfo:propagating/u01/app/oracle/product/11.2.0/db/ OC4J/J2EE/OC4J_DBCONSOLE_NODE1_RACDB1 to remote nodes ... 5:05:28 PM Oracle.sysman.emcp.EMDBCConfig instantiateoc4jconfigfilesinfo:propagating/u01/app/oracle/ PRODUCT/11.2.0/DB/OC4J/J2EE/OC4J_DBCONSOLE_NODE2_RACDB2 to remote nodes ... 5:05:28 PM Oracle.sysman.emcp.EMDBCConfiG Copyandpropagateoc4jdirinfo:propagating/u01/app/oracle/product/11.2.0/db/oc4j/j2ee/isqlplus_node1 to remote Nodes ... 5:05:29 PM Oracle.sysman.emcp.EMDBCConfig copyandpropagateoc4jdirinfo:propagating/u01/app/oracle/ Product/11.2.0/db/oc4j/j2ee/isqlplus_node2 to remote nodes ... 5:05:34 PM Oracle.sysman.emcp.EMAgentConfig deploystatedirsinfo:propagating/u01/app/oracle/product/ 11.2.0/DB/NODE1_RACDB1 to remote nodes ... 5:05:37 PM Oracle.sysman.emcp.EMAgentConfig deploystatedirsinfo:propagating/u01/app/oracle/product/ 11.2.0/DB/NODE2_RACDB2 to remote nodes ... 5:05:38 PM oracle.sysman.emcp.util.DBControlUtil securedbconsoleinfo:securing Database Control (This May tak e a while) ... 5:06:30 PM oracle.sysman.emcp.util.DBControlUtil startomsinfo:starting Database Control (This could take a whi Le) ... 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performconfigurationinfo:database Control started Successfullyaug 17, 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performconfigurationinfo: >>>>>>>>> >> the Database Control URL is https://node1:1158/em <<<<<<<<<<<aug 17, 2014 5:08 : Oracle.sysman.emcp.EMDBPostConfig showclusterdbcagentmessageinfo: **************** Current Configuration * * * * * * INSTANCE NODE dbcontrol_upload_host-------------------------------------- ---racdb1 node1 node1racdb2 node2 node1enterprise Manager Configuration Comp leted successfullyfinished EMCA at 5:08:41 PM

Other questions:

Assume that the drop repos is particularly slow. Can try for example the following statement:alter system UNQUIESCE;

Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.

Once the Oracle EM experience is configured