Re: Upgrade EM from 12.1.0.3 to 12.1.0.5 - emkey issues

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Thu, 3 Mar 2016 14:45:25 -0700
Message-ID: <CAN6wuX1iYb4q45O8qHqrzmBV7ZYJpZJ4aFAg3UNB2y3zx88OzA_at_mail.gmail.com>

Hi Jeff,
Please verify that you can connect to each the Repository and the Weblogic console with the passwords you believe are correct. The information for the weblogic console is included in the following command:
./emctl status oms -details

Ensure that you're able to connect to the OMR with the password via SQL Plus using a tns connection, (i.e. the listener must be up...) And make sure that all environment variables are set correctly for homes and sid.

Hope this helps!
Kellyn

[image: Kellyn Pot'Vin on about.me]

Kellyn Pot'Vin-Gorman
about.me/dbakevlar
  <http://about.me/dbakevlar>

On Thu, Mar 3, 2016 at 1:03 PM, Jeff Chirco <backseatdba_at_gmail.com> wrote:

> 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>
> 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
>>
>
>

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

Received on Thu Mar 03 2016 - 22:45:25 CET