Re: Upgrade EM from 12.1.0.3 to 12.1.0.5 - emkey issues

  • From: Jeff Chirco <backseatdba@xxxxxxxxx>
  • To: Beckstrom Jeffrey <JBECKSTROM@xxxxxxxxx>
  • Date: Fri, 4 Mar 2016 10:38:12 -0800

Yes this is what I did. And I opened a SR and that is what the engineer
told me to do. It worked.

emctl config emkey -copy_to_repos


But boy did the upgrade take a while.  Part of the reason was to get the
Storage Provisioning option but the button is not there by default, must be
more I had to do there.
Thanks all.

On Fri, Mar 4, 2016 at 6:58 AM, Beckstrom Jeffrey <JBECKSTROM@xxxxxxxxx>
wrote:

We had the same problem. From a SR we did:


emctl config emkey -copy_to_repos
Had to set java_home=f:\oracle\mw\jdk16\jdk

P.S. If you get it all to work, let us know, right now we are erroring
during OMS configuration.

P.S.S. The software has to be on a local drive or web logic install will
fail.
"Le, Binh T." <Binh.Le@xxxxxxx> 3/4/16 9:06 AM >>>
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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jeff Chirco
*Sent:* Thursday, March 03, 2016 3:03 PM
*To:* oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxx>
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.**


.


Other related posts: