Error Creating Repository Oracle 10g
Contents |
console using below command, it fails with error as "oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists" #> ./emca -repos create STARTED how to create database in oracle 10g EMCA at Feb 23, 2012 10:15:00 PM EM Configuration Assistant, create database oracle 10g express Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:
Create Database Oracle 10g Linux
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,
Create Table Oracle 10g
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 create table select oracle 10g 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.executeScript(SQLPlusEngine.java:306) at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:389) at oracle.sysman.emcp.EMReposConfig.invoke(EMR
Social Links Printer Friendly About Search 8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux Home » Articles » Misc
Create Table Syntax Oracle 10g
» Here Basic Enterprise Manager Troubleshooting The web-based Enterprise Manager tool was introduced in create temp table oracle 10g Oracle 10g and has significant functionality improvements over previous versions. Even so, it seems there is not a day goes by how to create user in oracle 10g 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 http://oracledba-sharinganexperience.blogspot.com/2012/02/oracle-10g-em-dbconsole-configuration.html 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 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 https://oracle-base.com/articles/misc/basic-enterprise-manager-troubleshooting 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 -repos recreate STARTED EMCA at Mar 13, 2009 11:32:35 AM EM Configuration Assistant, Version 11.1.0.7.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: DB11G Database Control is already configured for the database DB11G You have chosen to configure Database Control for managing the
Data Control. emca -config all db -repos http://oracle-mssql-dba.blogspot.com/2012/05/oracle-10gr2reconfigure-data-control-by.html create Output May 22, 2012 12:07:44 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at F:\oracle\product\10.2.0\db_1\cfgtoollog s\emca\blogdb\emca_2012-05-22_12-06-05-PM.log. May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) oracle 10g ... May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at F:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\bl ogdb\emca_repos_create_