Error Eml.omshandshake Process Failure
log in tour help Tour Start 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 Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How can I change the connection descriptor used by Oracle Enterprise Manager? up vote 2 down vote favorite I've recently changed the SERVICE_NAME of my 11g database and Enterprise Manager can no longer connect to it: 2014-01-08 10:36:06,047 [HTTPThreadGroup-3] ERROR eml.OMSHandshake processFailure.806 - OMSHandshake failed.(AGENT URL = https://Test9.lab.nyc-14.knoa.com:3938/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Test9.lab.nyc-14.knoa.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test9.lab.nyc-14.knoa.com))) ) The SERVICE_NAME in there is indeed the old one. I've updated NETWORK\ADMIN\tnsnames.ora but that didn't fix it. Where does Enterprise Manager read the connection descriptor from? oracle oracle-11g-r2 share|improve this question asked Jan 8 '14 at 15:41 Bogdan Calmac 11115 Have you changed the listener.ora on the DB server? –Philᵀᴹ Jan 8 '14
#412653] Fri, 10 July 2009 06:01 dbcop Messages: 37Registered: September 2006 Location: india Member Hi, I have recently upgrade a 9.2.0.7 database to 10.2.4. OEM was never configured on the DB . Now I am trying to configure OEM on the 10g DB . Below are the steps . sapm30:oram30 23> emca -repos create Jun 12, 2009 9:57:39 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jun http://dba.stackexchange.com/questions/56372/how-can-i-change-the-connection-descriptor-used-by-oracle-enterprise-manager 12, 2009 10:02:31 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Enterprise Manager configuration completed successfully FINISHED EMCA at Jun 12, 2009 10:02:31 AM After creating the repository I issued emca -config dbcontrol db Do you wish to continue? [yes(Y)/no(N)]: Y Jun 12, 2009 10:08:05 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at http://www.orafaq.com/forum/t/147572/ /oracle/M30/102_64/cfgtoollogs/emca/M30/emca_2009-06-12_10-07-34-AM.log. Jun 12, 2009 10:08:18 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Jun 12, 2009 10:09:25 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Jun 12, 2009 10:09:25 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Jun 12, 2009 10:11:11 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Jun 12, 2009 10:11:11 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://sapm30:1158/em <<<<<<<<<<< Enterprise Manager configuration completed successfully FINISHED EMCA at Jun 12, 2009 10:11:11 AM After the configuration was successfully done. I tried to start up the dbconsole as emctl start dbconsole But it failed The log files shows the following 2009-06-12 13:38:54 Thread-1 WARN http: snmehl_connect: connect failed to (sapm30:1158): A remote host refused an attempted connect operation. (error = 79) 2009-06-12 13:39:02 Thread-1 WARN http: snmehl_connect: connect failed to (sapm30:1158): A remote host refused an attempted connect operation. (error = 79) 2009-06-12 1
it has been changed and we http://www.pafumi.net/OEM%20Reinstalling%20Procedure.html now have to use the emctl command. After changing http://kishantha.blogspot.com/2010/03/oracle-enterprise-manager-console.html the hostname or IP address, EM dbconsole port, instance SID, or even TZ settings, EM is going to fail. Example to Re-Configure to another port: Using "emca" you can reconfigure eg. the port number to error eml.omshandshake 1150: Code: emca -reconfig ports -DBCONTROL_HTTP_PORT 1150 To change the listener port or the hostname of the Repository Database we now have to use the emctl config oms command as shown below. emctl config oms -store_repos_details -repos_port 1528 -repos_sid emrep -repos_host wintest01 -repos_user SYSMAN -repos_pwd error eml.omshandshake process oracle11g To check what are the OMS Repository details we can use the emctl config oms -list_repos_details command. For example - D:\Oracle\Product\Middleware\oms11g\BIN>emctl config oms -list_repos_details Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=wintest01)(PORT=1528)))(CONNECT_DATA=(SID=emrep))) Repository Host : wintest01 Repository Port : 1528 Repository SID : emrep Repository User : SYSMAN The emoms.properties file actually has these lines …. ########################################################################################################### ##################################### README ########################################### ########################################################################################################### #NOTE #1. EMOMS(LOGGING).PROPERTIES FILE HAS BEEN REMOVED #2. OMS PROPERTIES / LOGGING PROPERTIES SHOULD BE MODIFIED USING EMCTL GET/SET/DELETE/LIST PROPERTY COMMANDS #3. The USAGE OF EMCTL GET/SET/DELETE/LIST PROPERTY IS PROVIDED BELOW, BUT # FOR LATEST UPDATED COMMANDS PLEASE CHECK EMCTL HELP MESSAGE In more serious cases there's only one solution - reinstallation Check the status: emca
enterprise console. Failed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin). The log was draining the following errors. [ApplicationServerThread-5] ERROR eml.OMSHandshake processFailure.806 - OMSHandshake failed. java.sql.SQLException: ORA-28001: the password has expired at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:792) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:365) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:519) To fix the issue ================ * Stop enterprise manager -> emctl stop dbconsole * login to sqlplus as sysdba -> sqlplus "/as sysdba" * reset sysman password -> alter user sysman identified by