StoreReposDetails Fails with Error : Failed to get connection to repos : NL Exception was generated

(Doc ID 1926151.1)

Last updated on JANUARY 13, 2015

Applies to:

Enterprise Manager Base Platform - Version 11.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Trying to perform the "emctl config oms -store_repos_details" operation fails with following error:

emctl config oms -store_repos_details -repos_conndesc '"(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(LOAD_BALANCE=ON)ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxxxx.xxx.xx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oemprod)))"' -repos_user sysman
Oracle Enterprise Manager 11g Release 1 Grid Control  
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Enter Repository User's Password :
Error occured. Check the logs.


secure log had the following error stack:

2014-09-13 16:52:16,317 [main] INFO  oms.StoreReposDetails logp.251 - Repos ConnDesc: (DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(LOAD_BALANCE=ON)ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxxxx.xxx.xx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oemprod)))
2014-09-13 16:52:16,318 [main] INFO  oms.StoreReposDetails logp.251 - Repos User: sysman
2014-09-13 16:52:16,318 [main] INFO  oms.StoreReposDetails logp.251 - Don't validate repos creds? false
2014-09-13 16:52:16,768 [main] ERROR oms.StoreReposDetails logp.251 - Failed to get connection to repos : NL Exception was generated
java.sql.SQLException: NL Exception was generated
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)

Or it gives:

[main] ERROR oms.StoreReposDetails logp.251 - Failed to get connection to repos : IO Error: SO Exception was generated
java.sql.SQLRecoverableException: IO Error: SO Exception was generated

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms