Error Creating Repository Oracle
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 turn JavaScript back
Severe Error Creating The Repository Emca
on and reload this page. Please enter a title. You can maven repository oracle not post a blank message. Please type your message and try again. More discussions in Enterprise Manager severe error dropping the repository 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
Ora 20001 Sysman Already Exists
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_repos_create_
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SEVERE: Error creating the repository Refer to the logfiles at D:app/hp/cfgtools/logs.. in oracle 11g up vote 0 down vote favorite SEVERE: Error creating the https://community.oracle.com/thread/455813 repository Refer to the logfiles at When I want to created a repository for start db console following error occured SEVERE: Error creating the repository Refer to the logfiles at D:app/hp/cfgtoolslogs/ecma/orcl... .Guide What I do I Used following steps emca -repos create Enter the following information: Database SID: prod9 Listener port number: 1522 Password for SYS user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: Y But its show error not created a repository http://stackoverflow.com/questions/23854931/severe-error-creating-the-repository-refer-to-the-logfiles-at-dapp-hp-cfgtools guide me what I do in oracle 11g? database oracle oracle11g share|improve this question asked May 25 '14 at 11:49 user3671390 1919 And have you looked at the logfiles in that directory as the message instructed you? –APC May 25 '14 at 14:03 how i looked in logfiles guide me? –user3671390 May 25 '14 at 14:55 May 25, 2014 10:50:31 AM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository May 25, 2014 10:50:31 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at D:\app\hp\cfgtoollogs\emca\orcl\emca_repos_create_
Откуда: Сообщений: 72 Имеем RedHat4U7, Oracle 10.2.0.4.Решил пересоздать http://forums.pentaho.com/archive/index.php/t-60566.html репозиторий.emca -deconfig dbcontrol db -repos dropВсе удачноЗатемemca -config dbcontrol db -repos createПолучаем в error creating логе:CONFIG: SQLEngine created successfully and connected Nov 30, 2011 4:33:35 AM oracle.sysman.emcp.EMReposConfig createRepository CONFIG: Spooling to /home/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/emca/test1/emca_repos_create_2011-11-30_04-33-35-AM.log Nov 30, 2011 4:33:35 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the error creating repository EM repository (this may take a while) ... Nov 30, 2011 4:33:35 AM 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:1474) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:848) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:267) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:308) at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:422) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:192) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419) Nov 30, 2011 4:33:35 AM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Nov 30, 2011 4:33:35 AM oracle.sysman.emcp.EMReposConfig invoke INFO: R
Oracle set up just fine and can run selects without any problem. However, when I try to set up a repository, also via ODBC to Oracle, I get the error below. Unfortunately, we can't use jdbc at the current time and I understand ODBC is not recommended. But is there anything I can try? Error........ java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: offending row : [ID_REPOSITORY_LOG Integer], [REP_VERSION String], [LOG_DATE Date], [LOG_USER String], [OPERATION_DESC String] Error setting value #1 [ID_REPOSITORY_LOG Integer] on prepared statement (Integer) java.sql.SQLException: General error General error at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:89) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:97) at org.pentaho.di.ui.repository.dialog.RepositoryDialog.create(RepositoryDialog.java:455) at org.pentaho.di.ui.repository.dialog.RepositoryDialog.access$600(RepositoryDialog.java:64) at org.pentaho.di.ui.repository.dialog.RepositoryDialog$5.handleEvent(RepositoryDialog.java:268) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:292) at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$4.widgetSelected(RepositoriesDialog.java:330) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:425) at org.pentaho.di.ui.spoon.Spoon.openRepositoryDialog(Spoon.java:5381) at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:5445) at org.pentaho.di.ui.spoo