一次配置oracle em的经历
对oracle10grac配置em，原本是非常简单的事，却花费了很长时间，记录下来，备忘。 首先是报如下错误： [oracle@node1 admin]$ emca -config dbcontrol dbSTARTED EMCA at Aug 17, 2014 9:06:47 AMEM Configuration Assistant, Version 10.2.0.5.0 Production
对oracle10grac配置em，原本是非常简单的事，却花费了很长时间，记录下来，备忘。
首先是报如下错误：
[oracle@node1 admin]$ emca -config dbcontrol db STARTED EMCA at Aug 17, 2014 9:06:47 AM EM Configuration Assistant, Version 10.2.0.5.0 Production Copyright (c) 2003, 2009, Oracle. All rights reserved. Enter the following information: Database SID: racdb1 Listener port number: 1521 Password for SYS user: Password for DBSNMP user: Aug 17, 2014 9:06:57 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine WARNING: ORA-28000: the account is locked Password for SYSMAN user: Aug 17, 2014 9:07:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine WARNING: ORA-28000: the account is locked Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db ]: ASM SID [ +ASM ]: ASM port [ 1521 ]: ASM user role [ SYSDBA ]: ASM username [ SYS ]: ASM user password: ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db Local hostname ................ node1 Listener port number ................ 1521 Database SID ................ racdb1 Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db ASM SID ................ +ASM ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ SYS ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Aug 17, 2014 9:12:22 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log. Aug 17, 2014 9:12:34 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Aug 17, 2014 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Aug 17, 2014 9:13:01 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /u01/app/oracle/product/11.2.0/db/bin/emctl start dbconsole Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.EMConfig perform SEVERE: Error starting Database Control 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. 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.
[root@node1 ~]# cat /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_09-06-47-AM.log
Aug 17, 2014 9:17:40 AM oracle.sysman.emcp.EMConfig perform CONFIG: Stack Trace: oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control at 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)
Oracle对此的解释是：
In Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00. The certificate expiration will cause errors if you attempt to configure Database Control on or after 31-Dec-2010. Existing Database Control configurations are not affected by this issue.
If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply Patch 8350262 to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.
可以查看：Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on Oracle Database 10.2.0.4 or 10.2.0.5 [Video] [ID 1222603.1]
解决方法：
如果是在创建实例前就已经打了这个patch的话，那之后就不会报错了。如果是在创建实例之后才打的这个patch，那么需要执行以下：
对于单实例：
1.使用Opatch安装Patch 8350262
2.设置ORACLE_HOME and ORACLE_SID 环境变量，执行
3.Re-secure Database Control with the following command:
4.Re-start Database Control with the following command:
对于RAC：
1.使用Opatch安装Patch 8350262, 在一个节点安装就ok了。
2.在所有节点执行：设置ORACLE_HOME and ORACLE_SID 环境变量，执行
3.Re-secure Database Control on the first cluster node with the following command:
4.Re-secure Database Control on the remaining cluster nodes with the following command. Note that the -reset switch is not included with this command:
5.Re-start Database Control by executing the following command on each node in the cluster:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> 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 exist
SQL> DROP USER SYSMAN CASCADE;
User dropped.
SQL> exit
之后新建em成功，
[oracle@node1 ~]$ emca -config dbcontrol db -repos create STARTED EMCA at Aug 17, 2014 2:58:04 PM EM Configuration Assistant, Version 10.2.0.5.0 Production Copyright (c) 2003, 2009, Oracle. All rights reserved. Enter the following information: Database SID: racdb1 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): ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db ]: ASM SID [ +ASM ]: +ASM1 ASM port [ 1521 ]: ASM user role [ SYSDBA ]: ASM username [ SYS ]: ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db Local hostname ................ node1 Listener port number ................ 1521 Database SID ................ racdb1 Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db ASM SID ................ +ASM1 ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ SYS ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Aug 17, 2014 2:58:32 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db/cfgtoollogs/emca/racdb/emca_2014-08-17_02-58-04-PM.log. Aug 17, 2014 2:58:34 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Aug 17, 2014 3:02:14 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Aug 17, 2014 3:02:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Aug 17, 2014 3:02:50 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Aug 17, 2014 3:02:50 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Aug 17, 2014 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Aug 17, 2014 3:04:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://node1:1158/em <p><br> </p> 登陆之后，发现不是rac的em，重新配置 <p><br> </p><pre class="brush:php;toolbar:false">[oracle@node1 dbs]$ cd /u01/app/crs_home/bin [oracle@node1 bin]$ ./cemutlo -n crs [oracle@node1 bin]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Sun Aug 17 17:18:28 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> show parameter name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string racdb db_unique_name string racdb global_names boolean TRUE instance_name string racdb1 lock_name_space string log_file_name_convert string service_names string service1, SYS$ADMIN.TARGET_QUE UE.RACDB.EPOINT.COM, service2, racdb.epoint.com SQL>
[oracle@node1 dbs]$ emca -config dbcontrol db -repos create -cluster STARTED EMCA at Aug 17, 2014 5:02:15 PM EM Configuration Assistant, Version 10.2.0.5.0 Production Copyright (c) 2003, 2009, Oracle. All rights reserved. Enter the following information: Database unique name: racdb Database Control is already configured for the database racdb You have chosen to configure Database Control for managing the database racdb This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: y Listener port number: 1521 Cluster name: crs Password for SYS user: Password for DBSNMP user: Password for 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 settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db Database instance hostname ................ node1 Listener port number ................ 1521 Cluster name ................ crs Database unique name ................ racdb Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ SYS ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Aug 17, 2014 5:02:38 PM oracle.sysman.emcp.EMConfig perform INFO: 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 17, 2014 5:02:40 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Aug 17, 2014 5:02:44 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Aug 17, 2014 5:05:22 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Aug 17, 2014 5:05:27 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/OC4J_DBConsole_node1_racdb1 to remote nodes ... Aug 17, 2014 5:05:28 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/OC4J_DBConsole_node2_racdb2 to remote nodes ... Aug 17, 2014 5:05:28 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir INFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/isqlplus_node1 to remote nodes ... Aug 17, 2014 5:05:29 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir INFO: Propagating /u01/app/oracle/product/11.2.0/db/oc4j/j2ee/isqlplus_node2 to remote nodes ... Aug 17, 2014 5:05:34 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/db/node1_racdb1 to remote nodes ... Aug 17, 2014 5:05:37 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/db/node2_racdb2 to remote nodes ... Aug 17, 2014 5:05:38 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Aug 17, 2014 5:06:30 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Aug 17, 2014 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Aug 17, 2014 5:08:26 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://node1:1158/em <br> <br> <br> 其他问题： <p>如果drop repos特别慢，可以尝试如下语句：<span>alter system unquiesce;</span><br> <br> </p>
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Function to calculate the number of days between two dates in oracle
May 08, 2024 pm 07:45 PM
The function in Oracle to calculate the number of days between two dates is DATEDIFF(). The specific usage is as follows: Specify the time interval unit: interval (such as day, month, year) Specify two date values: date1 and date2DATEDIFF(interval, date1, date2) Return the difference in days
How long will Oracle database logs be kept?
May 10, 2024 am 03:27 AM
The retention period of Oracle database logs depends on the log type and configuration, including: Redo logs: determined by the maximum size configured with the "LOG_ARCHIVE_DEST" parameter. Archived redo logs: Determined by the maximum size configured by the "DB_RECOVERY_FILE_DEST_SIZE" parameter. Online redo logs: not archived, lost when the database is restarted, and the retention period is consistent with the instance running time. Audit log: Configured by the "AUDIT_TRAIL" parameter, retained for 30 days by default.
The order of the oracle database startup steps is
May 10, 2024 am 01:48 AM
The Oracle database startup sequence is: 1. Check the preconditions; 2. Start the listener; 3. Start the database instance; 4. Wait for the database to open; 5. Connect to the database; 6. Verify the database status; 7. Enable the service (if necessary ); 8. Test the connection.
How to use interval in oracle
May 08, 2024 pm 07:54 PM
The INTERVAL data type in Oracle is used to represent time intervals. The syntax is INTERVAL <precision> <unit>. You can use addition, subtraction, multiplication and division operations to operate INTERVAL, which is suitable for scenarios such as storing time data and calculating date differences.
How to see the number of occurrences of a certain character in Oracle
May 09, 2024 pm 09:33 PM
To find the number of occurrences of a character in Oracle, perform the following steps: Get the total length of a string; Get the length of the substring in which a character occurs; Count the number of occurrences of a character by subtracting the substring length from the total length.
Oracle database server hardware configuration requirements
May 10, 2024 am 04:00 AM
Oracle database server hardware configuration requirements: Processor: multi-core, with a main frequency of at least 2.5 GHz. For large databases, 32 cores or more are recommended. Memory: At least 8GB for small databases, 16-64GB for medium sizes, up to 512GB or more for large databases or heavy workloads. Storage: SSD or NVMe disks, RAID arrays for redundancy and performance. Network: High-speed network (10GbE or higher), dedicated network card, low-latency network. Others: Stable power supply, redundant components, compatible operating system and software, heat dissipation and cooling system.
How much memory does oracle require?
May 10, 2024 am 04:12 AM
The amount of memory required by Oracle depends on database size, activity level, and required performance level: for storing data buffers, index buffers, executing SQL statements, and managing the data dictionary cache. The exact amount is affected by database size, activity level, and required performance level. Best practices include setting the appropriate SGA size, sizing SGA components, using AMM, and monitoring memory usage.
How to replace string in oracle
May 08, 2024 pm 07:24 PM
The method of replacing strings in Oracle is to use the REPLACE function. The syntax of this function is: REPLACE(string, search_string, replace_string). Usage steps: 1. Identify the substring to be replaced; 2. Determine the new string to replace the substring; 3. Use the REPLACE function to replace. Advanced usage includes: multiple replacements, case sensitivity, special character replacement, etc.
