Check the document here
The link here
Application Release :-
Using Apps User.
SQL> select release_name from apps.fnd_product_groups;
Operating system : Oracle Linux 6.6
Oracle DB and Grid Version : 18.104.22.168.0
The Error that appeared Under Gird log :-
[client(1624)]CRS-10001:25-Mar-15 14:09 ACFS-9459: ADVM/ACFS is not supported on this OS version: ‘3.8.13-44.1.1.el6uek.x86_64’
[client(1626)]CRS-10001:25-Mar-15 14:09 ACFS-9201: Not Supported
[client(1748)]CRS-10001:25-Mar-15 14:09 ACFS-9459: ADVM/ACFS is not supported on this OS version: ‘3.8.13-44.1.1.el6uek.x86_64’
There is patch should be applied “Patch 16318126: UEK3 SUPPORT FOR ACFS”
Download the patch from https://support.oracle.com
and check the document
ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)
opatch apply -jdk /u01/app/oracle/JDK/160_24
The Scripts Here.
ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
707: Attempt to connect to a data store that has been manually unloaded from R
The command failed.
This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its ‘ramPolicy’ The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.
ttAdmin -ramload DSN_NAME
1- Oracle OTN Forum here
But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it’s strange case and not acceptable.
after investigation Table Called “REFERENCE_INSTANCE” include information about Running Composite in SOA ans instances. the size for this table 18GB.
Select * from Reference_instance;
Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.