Linkedin Osama Mustafa – Technology Geek

[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

Posted on March 11, 2015December 23, 2018 by Osama Mustafa in Application

This blog post will show you how to apply Patch on Jdeveloper :-

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.

If you faced any error with opatch commad try the below :-

opatch apply -jdk /u01/app/oracle/JDK/160_24

Cheers
Osama Mustafa

Oracle DBA Scripts

Posted on December 10, 2014December 23, 2018 by Osama Mustafa in Scripts

I Published Some Scripts that every DBA Needs, these Scripts available for everyone, I used GitHub to Upload the scripts, this Blog post will be updated and will contains new scripts.

The Scripts Here.

Cheers
Osama ….

Attempt to connect to a data store that has been manually unloaded from R AM

Posted on November 26, 2014December 23, 2018 by Osama Mustafa in Database

Timesten in-memory Database :-

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

Posted on October 26, 2014December 23, 2018 by Osama Mustafa in Fusion Middleware

When Creating Domain for Oracle SOA it’s Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.

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