Issue while upgrading 11gR2 to 11g R2 PS2

Issue:

Cause for the issue is because of difference in database details in different files. We need to make sure all files got same details.

During the process of upgrade when you run:


upgradeConfig('' ' ' ' '' ); as a process of system 

Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Error Code: 12514
Sep 12, 2014 12:08:57 PM oracle.security.jps.internal.credstore.ldap.LdapCredentialStore init
WARNING: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore <init>
WARNING: Failed to initialize keystoreJPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an

internal error in the policy store.
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore <init>
WARNING: Failed to get KeyStoreEntrynull
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore <init>
WARNING: Failed to initialize coherence keynull
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore <init>
WARNING: Failed to initialize OAM assertion keynull
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore getCoherenceKeyStorePassword
INFO: Cache value null for  coherenceKeyStorePwd, hence fetching from CSF
Sep 12, 2014 12:08:57 PM oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl configureGlobalProperties
INFO: Value for Well known address enable setting :true
Sep 12, 2014 12:08:57 PM oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl configureGlobalProperties
INFO: Value for encryption enable setting  :true
Sep 12, 2014 12:08:57 PM oracle.security.am.common.utilities.crypto.OAMKeyStore getCoherenceKeyStorePassword
INFO: Cache value null for  coherenceKeyStorePwd, hence fetching from CSF
Sep 12, 2014 12:08:57 PM oracle.security.am.upgrade.framework.psfe.PSFEFramework process
SEVERE: Exception has occurred while processing featureID: CoherenceAddLicenseMode. Stopping the process after calling rollback.
oracle.security.am.admin.config.exceptions.ObjectCreationException: Cannot get implementation for type Locks.
        at oracle.security.am.admin.config.util.GenericFactory.readObject(GenericFactory.java:256)
        at oracle.security.am.admin.config.util.GenericFactory.validateAndGetObjectForMap(GenericFactory.java:126)
        at oracle.security.am.admin.config.util.GenericFactory.getInstance(GenericFactory.java:176)
        at oracle.security.am.admin.config.util.locks.CohLockProvider.getMap(CohLockProvider.java:81)
        at oracle.security.am.admin.config.util.locks.CohLockProvider.lock(CohLockProvider.java:168)
        at oracle.security.am.admin.config.util.locks.ConfigLockManager.lock(ConfigLockManager.java:213)
        at oracle.security.am.admin.config.BasicFileConfigurationStore.applyUpdates(BasicFileConfigurationStore.java:397)
        at oracle.security.am.admin.config.BasicFileConfigurationStore.applyUpdates(BasicFileConfigurationStore.java:620)
        at oracle.security.am.lifecycle.config.upgrade.ConfigurationUpgradeTransformer.applyConfiguration(ConfigurationUpgradeTransformer.java:309)
        at oracle.security.am.lifecycle.config.upgrade.ConfigurationUpgradeTransformer.apply(ConfigurationUpgradeTransformer.java:441)
        at oracle.security.am.upgrade.framework.psfe.PSFEFramework.transformConfigXML(PSFEFramework.java:171)
        at oracle.security.am.upgrade.framework.psfe.PSFEFramework.process(PSFEFramework.java:323)
        at oracle.security.am.upgrade.framework.psfe.PSFEFramework.processOffline(PSFEFramework.java:195)
        at oracle.security.am.wlst.util.WLSTServerUtil.executeCommand(WLSTServerUtil.java:230)
        at oracle.security.am.wlst.WLSTWrapper.executeCommand(WLSTWrapper.java:152)
        at oracle.security.am.wlst.WLSTWrapper.execute(WLSTWrapper.java:107)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.python.core.PyReflectedFunction.__call__(Unknown Source)
        at org.python.core.PyReflectedFunction.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyObject.invoke(Unknown Source)
        at OamInternal_handler$py.patchUpgradeImpl$78(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py:1313)
        at OamInternal_handler$py.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.invoke(Unknown Source)
        at Oam_common$py.upgradeConfig$73(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/Oam_common.py:883)
        at Oam_common$py.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/Oam_common.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyObject.invoke(Unknown Source)
        at org.python.pycode._pyx55.upgradeConfig$74(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/wlst/Oam.py:553)
        at org.python.pycode._pyx55.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/wlst/Oam.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.pycode._pyx65.f$0(<console>:1)
        at org.python.pycode._pyx65.call_function(<console>)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyCode.call(Unknown Source)
        at org.python.core.Py.runCode(Unknown Source)
        at org.python.core.Py.exec(Unknown Source)
        at org.python.util.PythonInterpreter.exec(Unknown Source)
        at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
        at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
        at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
        at weblogic.management.scripting.WLST.main(WLST.java:188)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at weblogic.WLST.main(WLST.java:29)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.configureSystemProperties(CoherenceMapImpl.java:331)
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.init(CoherenceMapImpl.java:236)
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.<init>(CoherenceMapImpl.java:225)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at oracle.security.am.admin.config.util.GenericFactory.getManager(GenericFactory.java:352)
        at oracle.security.am.admin.config.util.GenericFactory.getManager(GenericFactory.java:336)
        at oracle.security.am.admin.config.util.GenericFactory.readObject(GenericFactory.java:246)
        ... 58 more
Caused by: java.lang.NullPointerException
        at oracle.security.am.common.utilities.crypto.OAMKeyStore$6.run(OAMKeyStore.java:513)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.security.am.common.utilities.crypto.OAMKeyStore.getCoherenceKeyStorePassword(OAMKeyStore.java:510)
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.setSSLProperties(CoherenceMapImpl.java:640)
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.configureGlobalProperties(CoherenceMapImpl.java:616)
        at oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl.configureSystemProperties(CoherenceMapImpl.java:326)
        ... 67 more
Sep 12, 2014 12:08:57 PM oracle.security.am.wlst.WLSTWrapper execute
SEVERE: Unable to execute the WLST Command
java.lang.Exception: upgradeConfig failed
        at oracle.security.am.wlst.util.WLSTServerUtil.executeCommand(WLSTServerUtil.java:232)
        at oracle.security.am.wlst.WLSTWrapper.executeCommand(WLSTWrapper.java:152)
        at oracle.security.am.wlst.WLSTWrapper.execute(WLSTWrapper.java:107)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at OamInternal_handler$py.patchUpgradeImpl$78(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py:1313)
        at OamInternal_handler$py.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.invoke(Unknown Source)
        at Oam_common$py.upgradeConfig$73(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/Oam_common.py:883)
        at Oam_common$py.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/script_handlers/Oam_common.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyObject.invoke(Unknown Source)
        at org.python.pycode._pyx55.upgradeConfig$74(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/wlst/Oam.py:553)
        at org.python.pycode._pyx55.call_function(/opt/oam/Oracle/11.1.2.0/Middleware/Oracle_IDM1/common/wlst/Oam.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.pycode._pyx65.f$0(<console>:1)
        at org.python.pycode._pyx65.call_function(<console>)
        at org.python.core.PyTableCode.call(Unknown Source)
        at weblogic.WLST.main(WLST.java:29)
Unable to execute the commandupgradeConfig failed
wls:/offline> Sep 12, 2014 12:09:21 PM oracle.security.am.foundation.mapimpl.coherence.CoherenceM

Solution:

Follow:

• Change jdbc configuration via WLS admin console
• There are two DataSource that need to be modified with new hostname-  oamDS and opss-DBDS
• WLS Admin console ->Services -> DataSources -> oamDS -> Connection Pool
• If WLS console is not not accessable then we can modify  oam-db-jdbc.xml and opss-jdbc.xml in  /config/jdbc

Example-

<Middleware>/user_projects/domains/base_domain/config/jdbc

Refer- Task 6 Change the System Data Source
http://docs.oracle.com/cd/E27559_01/core.1112/e28516/host.htm#CHDJBHJH


2. Make sure to  modify below config files too -
   

/config/fmwconfig/jps-config-jse.xml 

/config/fmwconfig/jps-config-migration.xml,

/config/fmwconfig/jps-config.xml

Reference: 
OAM 11gR2PS2 Admin and managed Servers Fail To Start After Database Hostname Change (Doc ID 1641424.1)