I dont have GUI for my database. 8. thanks, Marcos Report message to a moderator Re: dbconsole after restore on new host [message #339833 is a reply to message #336652] Fri, 08 August 2008 15:33 marcossantos emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create The deconfig will look something like this. $ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Mar 13, share|improve this answer edited Sep 30 '12 at 12:49 answered Sep 30 '12 at 12:35 Ould Abba 5251317 add a comment| up vote 0 down vote I had the same problem
Locate the OracleDBConsolesid entry and delete it. Existing pool information maybe inaccurate. 2014-02-07 10:39:33,698 [EMUI_10_39_33_/console/rac/racSitemap] ERROR db.rac setDatabaseType.2682 - Could not retrieve Database Type information. cd $ORACLE_HOME/sysman/admin/emdrep/bin4. Enter the following information: Database SID: DB11G Listener port number: 1521 Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Password for SYSMAN user: Email address for notifications https://community.hpe.com/t5/Databases/emca-cannot-drop-dbconsole-repos-db/td-p/5116011
Drop any dbconsole related public synonyms . For more information about Quiesce Mode, refer to My Oracle Support Note 375946.1, "Running EMCA Results in Database Quiesce" and "No New Connections or Operations Can Be Performed During the DB Option 2: Deleting Database Control Configuration Files and Repository Objects Using An EMCA Script You can delete Database Control configuration files and repository objects using an EMCA script. Mar 13, 2009 12:43:07 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Provisioning archives deployed successfully.
In 11g, I notice the quiesce has gone. enter sid 4. C:\app\Administrator\product\11.1.0\db_1 LOCAL hostname ................ Emca -config Dbcontrol Db -repos Recreate e.g.
Delete dbconsole 2. I was thining your trying to connect oracle enterprise manager using sys user; but u don't know sys password. Mar 13, 2009 12:10:31 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... http://www.oracle-wiki.net/premium:startdocshowtoinstalldeinstalldbconsole Click Next.
All rights reserved. Configure Dbconsole 11gr2 See pages that link to and include this page. oraenv ORACLE_SID = [SID] ? All rights reserved.
Enter the following information: Database SID: DB11G Listener port number: 1521 Password for SYS user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: Y Mar 13, 2009 12:10:07 PM this Enter a Description for the notification rule. How To Configure Emctl Dbconsole In Oracle 11g Click Next Review the Notification Rule and click Finish At this point, whenever a metric threshold is triggered, the notification rule will capture the alert and send the alert to the Emca -config Dbcontrol Db -repos Drop when i reconfigure the database emca -deconfig dbcontrol db -repos drop SET ORACLE_HOSTNAME = testlaptop SET ORACLE_UNQNAME=testdb emca -config dbcontrol db -repos recreate the service starts but when i restart the
maclochlainn 2 Apr 13 at 9:40 am Thanks. oraenv ORACLE_SID = [SID] ? I enter my user = SYS and password so I get error in highlight: username/password invalid. Not sure if it has something to do with listener… 2014-02-07 10:38:32,247 [EMUI_10_38_32_/console/rac/racSitemap] ERROR rac.services updateServerPoolsInfo.210 - Server pool information could not be upda ted. Manually Drop Em Repository 11g
I get error: ORA: 01031 - insufficient privileges. 3. Any ideas? Refer to the log file at F:\Oracle\app\Mohib\cfgtoollogs\emca\oracle\emca_2013_04_07_14_39_55.log for more details. #################hosts file############# localhost name resolution is handled within DNS itself. # 127.0.0.1 localhost # 172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com ###################listener.ora########### LISTENER = (DESCRIPTION_LIST Log onto any node in the cluster. 3.
I give up. Emca Deconfig Dbcontrol Db Repos Drop asked 4 years ago viewed 17786 times active 8 months ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title? How to select a good sleeping bag liner Is getting IN or OUT of orbit easier?
If you are using emca the command to delete the configuration files is: ORACLE_HOME/bin/emca – deconfig dbcontrol db (10gR2 and higher) ORACLE_HOME/bin/emca –x
I enter my user = SYS and password so I get error in highlight: username/password invalid. Report message to a moderator Re: dbconsole after restore on new host [message #339457 is a reply to message #339385] Thu, 07 August 2008 09:43 S.Rajaram Messages: 1027Registered: enter sid DROP ROLE MGMT_USER; 3. Find the entry OracleDBConsole and delete it.Deleting the Database Control Repository Next the repository needs to be removed.
For more information see: EMCA Troubleshooting Tips (10gR2) Deleting and Creating Database Control Objects (11gR2) Hope this helps. Something does not work as expected? Change hostname and IP (I cheated and used YAST in SUSE Linux, rather than manually editing the files) 3. Could you explain me; why your getting the above error message?
The restore and recover is ok. Apr 7, 2013 2:40:22 PM oracle.sysman.emcp.util.FileUtil backupFile WARNING: Could not backup file F:\Oracle\app\Mohib\product\11.1.0\db_1\sysman\config\emd.properties Apr 7, 2013 2:40:22 PM oracle.sysman.emcp.util.FileUtil backupFile WARNING: Could not backup file F:\Oracle\app\Mohib\product\11.1.0\db_1\sysman\config\emoms.properties Apr 7, 2013 2:40:22 PM Via SQL*Plus i can to connect. dbconsole not exist for this instance. 5.
The effect of this quiesce is to stall the database whilst it takes place. But after restarting the virtual machine the service cant start and when i start it using emctl start dbconsole i get error the service cant start. These are the steps: 1. A few useful tools to manage this Site.
ORACLE_HOME/bin/emca –r (10gR1) ORACLE_HOME/bin/emca –config dbcontrol db You can use the following commands to recreate both the configuration files and the repository ORACLE_HOME/bin/emca (10gR1) ORACLE_HOME/bin/emca –config dbcontrol –repos create Be aware Apr 8, 2010 9:50:17 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration WARNING: EM is not configured for this database. View wiki source for this page without editing. This is typically an agent process not an Oracle listener.
Apr 7, 2013 2:40:23 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... I enter my user = SYS and password so I get error in highlight: username/password invalid.