Error Creating The Repository Emca
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM severe error dropping the repository Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < error creating repository Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries
Ora 20001 Sysman Already Exists
MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca AbhaiTripathi Nikki Klein knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. EMCA Error Creating the Repository mohib3088 asked Mar 31, 2013 | Replies (6) Hi All, I am facing problems to configure emca, kindly help me. I am working on 11.1.0.6.0 windows 64 bit, listener is running also services are running of "oracle" database, i issued "C:\Users\Mohib>emca -config dbcontrol db -repos create" which gives me "SEVERE: Error creating the repository" & "CONFIG: ORA-00955: name is already used by an existing object oracle.sysman.assistants.util.sqlEngine.SQLFatalEr rorException: ORA-00955: name is already used by an existing object" errors I was checking other threads in same forum (https://forums.oracle.com/forums/thread.jspa?messa
#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 db -repos create http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/emca-error-creating-the-repository-5150732 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 createRepository INFO: Creating the http://www.orafaq.com/forum/t/124913/ 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.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:208) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:11
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 https://taliphakanozturken.wordpress.com/tag/emca/ 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 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 error creating 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 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 error creating the 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 AddressChanges December 31, 2011 talipozturk Leave a comment The Enterprise Manager console will not work when database host name and / or IP address changes. We must run EMCA tool for reconfiguring the OEM database console. To do this, use the following commands. emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create or emca -deconfig dbcontrol db emca -config dbcontrol db -repos recreate TNS konfigürasyonumuz değişir ise (Örneğin dinleyici(listener) portumuz değişirse), bu durumda yine EMCA aracı ile aşağıdaki gibi tekrar konfigürasyonumuzu yapabiliriz. If our TNS