RESOLUTION:
1. Go to STAT_HOME/app/server/default/deploy and locate the file called stat-ds.xml file. Open up this file with an editor and add the lines below:
<connection-property name="oracle.net.encryption_client">required</connection-property>
<connection-property name="oracle.net.encryption_types_client">(RC4_256)</connection-property>
<connection-property name="v$session.program">Stat-Agent</connection-property>
2. Stop the central agent. Go to STAT_HOME/app/server/default and delete tmp, work and data folder.
3. In the sqlnet.ora of the database server you have to add RC4_256 to end of the ENCRYPTION_TYPES_SERVER parameter. So,
SQLNET.ENCRYPTION_TYPES_SERVER= (AES256, AES192, 3DES168)
Should be changed to
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256, AES192, 3DES168, RC4_256)
and restart the DB listener, and that should allow the Oracle agent to come up.
4. In the stat.conf file configure the CONTEXT_NAME env variable with the result from the statement below:
# Required for R12
Dev1.env.CONTEXT_NAME:<The result from the query below>
Here is the query to find out the CONTEXT_NAME
select EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]') CONTEXT_NAME
from FND_OAM_CONTEXT_FILES
where NAME not in ('TEMPLATE','METADATA','config.txt')
and CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
