Monday, May 18, 2015

Enable Database Vault Using chopt Command

I post before how to enable oracle database vault using make command, in this post i will talk about how to enable database vault but using chopt command which easier and faster.


Common Syntax :-
chopt [enable | disable] db_option

Value
Description
dm
Oracle Data Mining Database Files
dv
Oracle Database Vault
lbac
Oracle Label Security
olap
Oracle OLAP
partitioning
Oracle Partitioning
rat
Oracle Real Application Testing
ode_net
Oracle Database Extensions for .NET 1.x
ode_net_2
Oracle Database Extensions for .NET 2.0


Like the other way you need to shutdown database, listener and dbconsole

cd $ORACLE_HOME/bin
chopt enable lbac


and Start database, listener, and dbconsole , Enterprise should be configured to access database vault.


Cheers
osama 

ORA-29504: invalid or missing schema name

ORA-29504: invalid or missing schema name
ORA-06512: at line 8 :msg



This error appeard while trying to configure Enterprise manager and DBV for SAP 

Solution:

You can ignore this error the SAP looking for User called EXFSYS and the account is not used For SAP System.

Cheers
Osama 

Saturday, May 16, 2015

OTN MENA TOUR




Thank you 
Osama Mustafa

Officially Fusion Middleware 11.1.1.9 Is Available to download

"Oracle Fusion Middleware is the leading business innovation platform for the enterprise and the cloud. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures. Solutions and products include Exalogic Elastic Cloud, data integration, business process management, business intelligence, identity management, Cloud application foundation, service-oriented architecture, WebCenter, and development tools."

Oracle Fusion middleware 11.1.1.9 is now available to download :-


  • Oracle Business Intelligence Enterprise Edition
  • Oracle JDeveloper and Application Development Framework (ADF)
  • Oracle Business Process Management
  • Oracle SOA Suite
  • Oracle Data Integrator
  • Oracle User Messaging Service
  • Oracle Enterprise Scheduler
  • Oracle Event Processing
  • Oracle WebCenter Suite
  • Oracle Identity Management
  • Oracle Forms and Reports
  • Oracle WebTier
  • Oracle Application Architecture Foundation Pack
To download Documentation from here
To Install Products steps from here 
to Download products from here


Thank you 
Osama Mustafa

Thursday, May 14, 2015

ACFS-9459/ACFS-9201/ACFS-9459 Gird Infrastructure

Environment: -

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

Monday, May 11, 2015

Install Oracle Siebel On Windows 2008 R2

This post will provide steps how to install Oracle Siebel CRM On Windows 2008 R2 Step by step.

To check the document from here 

Thank you
Osama Mustafa 

Friday, May 8, 2015

Enable Database vault 11GR2

This Post will descirbe how to enable oracle database vault in database 11GR2.

Check the document from here.
Thanks
Osama Mustafa