Error Eml.omshandshake Processfailure.806 - Omshandshake Failed.agent Url
#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 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 /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 13:37:02 Thread-1 ERROR ssl: nzos_Handshake failed, ret=28862 2009-06-12 13:37:02 Thread-1 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt 2009-06-12 13:37:11 Thread-1 WARN http: snmehl_connect: connect failed to (sapm30:3938): A remote host refused an attempted connect
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 http://www.orafaq.com/forum/t/147572/ * login to sqlplus as sysdba -> sqlplus "/as sysdba" * reset sysman password -> alter user sysman identified by
it has been changed and we now have to http://www.pafumi.net/OEM%20Reinstalling%20Procedure.html use the emctl command. After changing the hostname or http://www.progtown.com/topic526423-enterprise-manager-console-does-not-see-basis-oracle-11.html 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 1150: Code: emca -reconfig ports -DBCONTROL_HTTP_PORT error eml.omshandshake 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 oracle11g To check what are the OMS Repository details error eml.omshandshake processfailure.806 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 -deconfig dbcontrol 1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name. 2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora fil
»Databases »Enterprise manager console does not see basis (Oracle 11) Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 4 ] 1 Topic by eml78 2012-05-03 08:30:33 eml78 Member Offline Registered: 2012-04-23 Posts: 583 Topic: Enterprise manager console does not see basis (Oracle 11) OEL 5.2Oracle 11.1.0.6The console works through httpsAfter start https://server:1158/em shows a page with the status (the Basis - down, Listner - works, Agent - down). At button click startup - requests names/passwords - then says that basis Open and suggests to make to it shutdown.The basis on a computer one, it works (there is an access through sqlplus and from other computers through client API). Restarting of a DB and the console give nothing.How to force EMC to be connected to a DB? 2 Reply by C Strelok 2012-05-03 09:11:33 C Strelok Member Offline Registered: 2012-05-02 Posts: 624 Re: Enterprise manager console does not see basis (Oracle 11) I can only advise to look at enterprise broad gulls... Most likely there and the answerps: and the enterprise http is a piece which without preliminary does not work 3 Reply by eml78 2012-05-03 10:13:34 eml78 Member Offline Registered: 2012-04-23 Posts: 583 Re: Enterprise manager console does not see basis (Oracle 11) C-Strelok wrote: I Can only advise to look at enterprise broad gulls... Most likely there and the answerHere a broad gull piece 2009-06-30 14:09:36,596 [ApplicationServerThread-1] ERROR conn. ConnectionService verifyRepositoryEx.818 - Invalid Connection Pool. ERROR = ORA-28001: date of action of the password effused 2009-06-30 14:09:36,705 [ApplicationServerThread-1] ERROR eml. OMSHandshake processFailure.806 - OMSHandshake failed. (AGENT URL = https://borov:3938/emd/main) (ERROR = INTERNAL_ERROR) (CAUSE =java.sql. SQLException: ORA-28001: date of action of the password effused ) 2009-06-30 14:09:36,728 [ApplicationServerThread-8] ERROR app. SessionObjectManager sessionDestroyed.128 - java.sql. SQLException: ORA-28001: date of action of the password effused java.sql. SQLException: ORA-28001: date of action of the password effused Problem in that that this... EMC nothing it requests whence takes login - , button Login - for the forced instructions is not present. At att