Thank
Osama
Tag: Linkedin Osama Mustafa
Oracle EBS Installation R12.2
Check the document here
Thank you
Osama
Upgrade EBS DB from 11g to 12c
the application in my case version R12.2.4.
The link here
Enjoy
Osama
[INS-21003] Installer has detected that an invalid inventory pointer location file was specifies
Check EBS Version
Application Release :-
Using Apps User.
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.2.2
Done
Thanks
ACFS-9459/ACFS-9201/ACFS-9459 Gird Infrastructure
Operating system : Oracle Linux 6.6
Oracle DB and Grid Version : 11.2.0.4.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’
Solution: –
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)
Cheers
Osama mustafa
Apply Jdeveloper Patch
- Download the latest version of Opatch from http://support.oracle.com
- Unzip the Patch Folder.
- Set/export ORACLE_HOME to Jdeveloper hope depend on Operating system
- Finally Opatch Apply to Jdeveloper Home.
opatch apply -jdk /u01/app/oracle/JDK/160_24
Cheers
Osama Mustafa
Oracle DBA Scripts
The Scripts Here.
Cheers
Osama ….
Attempt to connect to a data store that has been manually unloaded from R AM
ttisql DSN_NAME
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.
connect “DSN=DSN_NAME”;
707: Attempt to connect to a data store that has been manually unloaded from R
AM
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.
Solution :
ttAdmin -ramload DSN_NAME
Reference :-
1- Oracle OTN Forum here
Cheers
Osama ….
Oracle SOA Tablespace Is full
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.
Thank you
Osama Mustafa