Error Creating Emca Repository
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please severe error dropping the repository turn JavaScript back on and reload this page. Please enter
Error Creating Repository
a title. You can not post a blank message. Please type your message and try again. ora 20001 sysman already exists More discussions in Enterprise Manager All PlacesEnterprise Manager This discussion is archived 7 Replies Latest reply on Feb 22, 2008 5:51 PM by 624738 Error creating the repository 537189 Dec 13, 2006 12:49 PM Hi i have created a database manually and trying to create Enterprise manager by using the following command, i cant work out why its not working as i can connect to the database fine, can y any one help, many thanks: [oracle@lh14hisa VNLA]$ emca -config dbcontrol db -repos create STARTED EMCA at 13-Dec-2006 10:15:50 EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: VNLA 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/oracle/product/10.2.0/10gr2db Database hostname ................ lh14hisa.scotland.gov.uk Listener port number ................ 1521 Database SID ................ VNLA Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y 13-Dec-2006 10:16:09 oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/oracle/product/10.2.0/10gr2db/cfgtoollogs/emca/VNLA/emca_2006-12-13_10-15-50-AM.log. 13-Dec-2006 10:16:10 oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... 13-Dec-2006 10:16:10 oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository 13-Dec-2006 10:16:10 oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /u01/oracle/product/10.2.0/10gr2db/cfgtoollogs/emca/VNLA/emca_repo
talipozturk 1 comment Hi Friends, A month ago, I wrote an article about OEM configuration when the database hostname or ip address changed. You can find that in this link https://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/ . We can get an error while re-creating (emca -config dbcontrol db -repos create) OEM repository as below: SEVERE: Error creating the repository Refer to the log file https://community.oracle.com/thread/455813 at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details. Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details. The error is also seen in the log file of errors is analyzed you can see following lines (/oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log). CONFIG: ORA-00955: name is already used https://taliphakanozturken.wordpress.com/tag/emca/ by an existing object CONFIG: ORA-01921: role name ‘MGMT_USER’ conflicts with another user or role name In this case we must do following operations in SQL*Plus. SQL> DROP USER SYSMAN CASCADE; SQL> DROP ROLE MGMT_USER; SQL> DROP USER MGMT_VIEW; SQL> spool synonym.sql SQL> select ‘drop public synonym ‘||object_name||';' from dba_objects where object_type='SYNONYM' and and object_name like ‘MGMT_%' and status='INVALID'; SQL> spool off SQL> @synonym.sql Now, please retry to create OEM respository. It will be success. emca -config dbcontrol db -repos create Talip Hakan Öztürk Share this:TwitterFacebookLike this:Like Loading... Categories: OEM & Grid Control Tags: CONFIG: ORA-00955: name is already used by an existing object, CONFIG: ORA-01921: role name ‘MGMT_USER’ conflicts with another user or role name, Creating OEM Repository, EMCA, ORA-00955, ORA-01921 OEM Configuration When the Database Host Name or IP AddressCha
Social Links Printer Friendly About Search 8i | 9i | 10g | 11g | 12c | https://oracle-base.com/articles/misc/basic-enterprise-manager-troubleshooting 13c | Misc | PL/SQL | SQL | RAC | http://oracledba-sharinganexperience.blogspot.com/2012/02/oracle-10g-em-dbconsole-configuration.html WebLogic | Linux Home » Articles » Misc » Here Basic Enterprise Manager Troubleshooting The web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over previous versions. Even so, it seems there is not a error creating day goes by without someone asking how to solve an Enterprise Manager configuration issue, so this article explains the first things 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 error creating emca 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 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
console using below command, it fails with error as "oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists" #> ./emca -repos create STARTED EMCA at Feb 23, 2012 10:15:00 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: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y Feb 23, 2012 10:20:45 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/ TESTDB/emca_2012-02-23_10-15-00-PM.log. Feb 23, 2012 10:20:48 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Feb 23, 2012 10:20:48 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Feb 23, 2012 10:20:48 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/ TESTDB/emca_repos_create_.log for more details. Feb 23, 2012 10:20:48 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/ TESTDB/emca_2012-02-23_10-15-00-PM.log for more details. Could not complete the configuration. Refer to the log file at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/ TESTDB/emca_2012-02-23_10-15-00-PM.log for more details. = TESTDB-SANGAM Shared DB server = oracle@testdb.sangam.com /orasw/app/oracle/product/10.2.0.3/bin When we checked in log/orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/ TESTDB/emca_2012-02-23_10-15-00-PM.log, it's found that Feb 23, 2012 10:20:48 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Feb 23, 2012 10:20:48 PM 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:1467) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScri