Oracle 11g Emca Error
Contents |
Software Library With EMCA Using an Input File for EMCA Parameters Using EMCA With Oracle Real Application Clusters Specifying the Ports Used by EMCA emca configure dbconsole 11g EMCA Troubleshooting Tips See Also: Oracle Enterprise Manager Advanced Configuration emca oracle 12c for information about other advanced configuration topics. Configuring Database Control with EMCA When you use the configure enterprise manager oracle 11g windows Database Configuration Assistant (DBCA) to configure Oracle Database 11g, DBCA provides a graphical user interface to help you select Database Control options and to configure
Oracle Emca
other aspects of your database. However, if you want to use the operating system command line to configure Database Control, you can use the Enterprise Manager Configuration Assistant (EMCA). To configure Database Control with EMCA: Set the following environment variables to identify the Oracle home and the system identifier (SID) for the how to configure enterprise manager in oracle 10g database you want to manage: ORACLE_HOME ORACLE_SID Change directory to the ORACLE_HOME/bin directory. Start EMCA by entering the following command with any of the optional command-line arguments shown in Table 21-1: $PROMPT> ./emca Depending upon the arguments you include on the EMCA command line, EMCA prompts you for the information required to configure Database Control. For example, enter the following command to configure Database Control so it will perform automatic daily backups of your database: $PROMPT> ./emca -config dbcontrol db -backup EMCA commands are of the form: emca [operation] [mode] [flags] [parameters] Note: To configure Database Console for single instance database using ASM, no extra parameters need to be passed along with the EMCA command. Run the following command to configure the Database Console which will automatically detect the ASM instance: emca -config dbcontrol db -repos create Note: The Database Control repository is in secure mode, which means that Enterprise Manager data is
Social Links Printer Friendly About Search 8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | emca -repos recreate WebLogic | Linux Home » Articles » Misc » Here Basic Enterprise
How To Configure Enterprise Manager In Oracle 11g Rac
Manager Troubleshooting The web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over
Emca Invalid Syntax
previous versions. Even so, it seems there is not a day goes by without someone asking how to solve an Enterprise Manager configuration issue, so this article explains the first things https://docs.oracle.com/cd/B28359_01/server.111/b28319/emca.htm you should look at. It's not meant to be an all encompassing guide. Just a first shot. Make sure the "/etc/hosts" file contains at least the loopback address and preferably the machine definition also. 127.0.0.1 localhost.localdomain localhost 192.168.0.181 myserver.localdomain myserver If you are using 11g, make sure the ORACLE_HOSTNAME and ORACLE_UNQNAME environment variables are set correctly. ORACLE_HOSTNAME=myserver.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=DB11G; export https://oracle-base.com/articles/misc/basic-enterprise-manager-troubleshooting ORACLE_UNQNAME Check the listener is running correctly. lsnrctl status If you get something like the following, your listener is not running and you need to start it using the "lsnrctl start" command. $ lsnrctl status LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 13-MAR-2009 13:32:49 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11g.localdomain)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused $ Next, check the Enterprise Manager service is running. $ emctl start dbconsole Assuming the console is already running, or fails to start, the next thing to do is to reconfigure Enterprise Manager. This is done using the Enterprise Manager Configuration Assistant (EMCA). For a first attempt, run the following command. Remember to add the "-cluster" option to the end for RAC databases. $ emca -config dbcontrol db -repos recreate If it all goes well you would expect to see something like this. $ emca -config dbcontrol db -repo
Hostname without reinstalling Oracle Enterprise Manager. If you're trying to resolve an ORACLE_UNQNAME problem, check another post of http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/ mine for that answer. These are the steps: 1. Change http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_4.shtml the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name. 2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name. 3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding this line beneath the default localhost line (for the new Hostname value): 127.0.0.1 oracle 11g localhost 172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com 4. Change the Windows hostname by navigating: Start > Control Panel > System (classic view) from the random assignment of VMWare Fusion. 5. Reboot the machine to set the networking. Unlock the SYSMAN account because it ensures that emca can drop it and all dependencies. Then, drop the em configuration configure enterprise manager with the following commands. C:\Data> set ORACLE_SID=orcl C:\Data> emca -deconfig dbcontrol db -repos drop 6. You'll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g): Oracle Database 11gR1 STARTED EMCA at Jul 13, 2008 8:26:42 AM EM Configuration Assistant, Version 11.1.0.5.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 SYSMAN user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y Oracle Database 11gR2 STARTED EMCA at Sep 3, 2012 7:40:07 PM EM Configuration Assistant, Version 11.2.0.0.2 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 SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y 7. If you failed to unlock
EMCA with Real Application Clusters Database will not Quiesce when Dropping Database Control Troubleshooting EMCA Further Reading About the Author Introduction This article provides steps-by-step details on how to create, drop and recreate the Database Control Repository and configuration files in an Oracle 10g or Oracle 11g database. Create Database Console To create the configuration files and repository for Database Console, run: $ emca -config dbcontrol db -repos create STARTED EMCA at Jul 24, 2006 9:59:39 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: TESTDB Listener port number: 1521 Password for SYS user: change_on_install Password for DBSNMP user: manager Password for SYSMAN user: manager Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1 Database hostname ................ linux3 Listener port number ................ 1521 Database SID ................ TESTDB Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Jul 24, 2006 10:00:12 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/TESTDB/emca_2006-07-24_09-59-39-PM.log. Jul 24, 2006 10:00:15 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jul 24, 2006 10:05:51 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Jul 24, 2006 10:06:01 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Jul 24, 2006 10:07:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Jul 24, 2006 10:07:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<< Enterprise Manager configuration completed successfully FINISHED EMCA at Jul 24, 2006 10:07:49 PM Drop Database Console To drop (rem