Error Creating Repository Emca
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it
Severe Error Dropping The Repository
will not work correctly without it enabled. Please turn ora 20001 sysman already exists JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. 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)/
#348078] Mon, 15 September 2008 10:03 rolex.mp Messages: 161Registered: February 2007 Senior Member I am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 on Oracle Enterprise Linux I am tring to create EM repository using emca -config dbcontrol https://community.oracle.com/thread/455813 db -repos create but I faced this error. The sysman account doesn't exist and I think so this account gets created when the repository is created. INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log. 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig http://www.orafaq.com/forum/t/124913/ createRepository INFO: Creating the EM repository (this may take a while) ... 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig updateReposVars SEVERE: File/directory /u01/app/oracle/product/10.2.0/db_1/sysman/emdrep/config/repository.variables does not exist 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke SEVERE: Failed to unlock all EM-related accounts 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMConfig perform SEVERE: Failed to unlock all EM-related accounts Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log for more details. Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log for more details. These are the contents of the log file 15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig grantPrivsToDbsnmp CONFIG: Exception while granting priviliges. oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00942: table or view does not exist at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1708) at oracle.sysman.emcp.EMReposConfig.grantPrivsToDbsnmp(EMReposConfig.java:503) at oracle.sysm
console using below command, it fails with error as "oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN http://oracledba-sharinganexperience.blogspot.com/2012/02/oracle-10g-em-dbconsole-configuration.html already exists" #> ./emca -repos create STARTED EMCA http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/ 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 error creating 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 error creating repository 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-20
Hostname without reinstalling Oracle Enterprise Manager. If you're trying to resolve an ORACLE_UNQNAME problem, check another post of mine for that answer. These are the steps: 1. Change 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 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 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 the SYSMAN account in step #5, you should drop the SYSMAN user manually. If you don't drop the SYSMAN schema, you'll raise an error when you try to recreate it: 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 The Java stack trace will look like this, more or less based on version and release: at oracle.sysman.assistants.uti