RE: Upgrade EM from 12.1.0.3 to 12.1.0.5 - emkey issues

From: Le, Binh T. <Binh.Le_at_lfg.com>
Date: Fri, 4 Mar 2016 14:06:59 +0000
Message-ID: <D22572E84CF68E4DB2E0E1171FB371944986AE6C_at_NC2PWEX503.us.ad.lfg.com>

Hi Jeff,

Try to use this:

/u01/software/oracle/middleware/oms/bin/emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.mydomain.com)(PORT=1521)))(CONNECT_DATA=(SID=emrepos12)))"' -repos_user sysman -emkey_file /u01/software/oracle/middleware/oms/sysman/config/emkey.ora

(http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/upgrading_12101_PS1_gtgstrtd.htm#EMUPG163)

Binh

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeff Chirco Sent: Thursday, March 03, 2016 3:03 PM
To: oracle-l_at_freelists.org
Subject: Re: Upgrade EM from 12.1.0.3 to 12.1.0.5 - emkey issues

Ok after I opend cmd as Administrator and ran the command it starting writing to the secure.log file. Here is the message after running the command

Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Enter Admin User's Password :
Error occurred. Check the log C:/Oracle/EM/gc_inst/em/EMGC_OMS1\sysman\log\secur e.log
And here is the contents of secure.log file. 2016-03-03 12:00:35,287 [main] ERROR oms.EMKeyCmds logp.251 - Failed to get connection to repos : IO Error: SO Exception was generated java.sql.SQLRecoverableException: IO Error: SO Exception was generated

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154)

at oracle.sysman.emctl.config.oms.EMKeyCmds.getReposConnection(EMKeyCmds.java:468)
at oracle.sysman.emctl.config.oms.EMKeyBRCmds.processEmKeyBRCmd(EMKeyBRCmds.java:239)
at oracle.sysman.emctl.config.oms.EMKeyBRCmds.main(EMKeyBRCmds.java:293)

Caused by: oracle.net.ns.NetException: SO Exception was generated

at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:629)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:423)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)

... 9 more
2016-03-03 12:00:35,287 [main] ERROR oms.EMKeyBRCmds logp.251 - Either Sysman password is invalid or there was a problem in connecting to the DB java.sql.SQLException: Either Sysman password is invalid or there was a problem in connecting to the DB

at oracle.sysman.emctl.config.oms.EMKeyCmds.getReposConnection(EMKeyCmds.java:479)
at oracle.sysman.emctl.config.oms.EMKeyBRCmds.processEmKeyBRCmd(EMKeyBRCmds.java:239)
at oracle.sysman.emctl.config.oms.EMKeyBRCmds.main(EMKeyBRCmds.java:293)

On Thu, Mar 3, 2016 at 10:43 AM, Jeff Chirco <backseatdba_at_gmail.com<mailto:backseatdba_at_gmail.com>> wrote: I am trying to upgrade my EM from 12.1.0.3 to 12.1.0.5 but during the upgrade processes a prerequisite comes up about emkey needs to be copied to the repository. I found related topic in the upgrade guide and it says to run this.

$<OMS_HOME>/bin/emctl config emkey -copy_to_repos_from_file -repos_conndesc '"<conndesc>"' -repos_user <username> [-repos_pwd <pwd>] -emkey_file <OMS_HOME>/sysman/config/emkey.ora

Which I do but it is asking for an Admin password in addition to the sysman password. I have the sysman password and I believe the Admin password it is refering to is the WebLogic admin account which I have as well. But errors out and tells me to check a log file which is not even updated. My EM is running on Windows Server 2008 R2 64bit I am stuck and don't know what to do. Any suggestions? Thanks,
Jeff

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 04 2016 - 15:06:59 CET