Tag: Osama ACE

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

Posted on by Osama Mustafa in Database
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

ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07

Posted on by Osama Mustafa in Database
When trying to export any user using system the below error appeared

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
ORA-31626: job does not exist
ORA-31633: unable to create master table “SYSTEM.SYS_EXPORT_SCHEMA_07”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT”, line 1020
ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07

The above error related because the system user is not allow to access data Dictionary files.

Run the below command
SQL>
BEGIN
DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(
realm_name => ‘Oracle Data Dictionary’,
grantee => ‘SYSTEM’);
END;
/
PL/SQL procedure successfully completed.

Or you can use the GUI in Database vault and under Data Dictionray realms add the system user as participant.

Thank you  

Enable/Disable SSH For Root User

Posted on by Osama Mustafa in Operating system
Sometimes for any reason you want to enable root ssh using any SSH Client such as putty and only the administrator can login to do this follow the below steps :-

  • vi /etc/ssh/sshd_config
  • search for line as follow :-
    • PermitRootLogin yes and change it to –>  PermitRootLogin no
  • Search for the following lines as well :-
    • DenyUsers root user2 user3
  • Remove the root from Deny User
    • DenyUsers user2 user3
  • /etc/init.d/sshd restart

Stopping sshd: [ OK ]

Starting sshd: [ OK ]

If you want to disable the SSH login for root just keep everything like the above.

Cheers
Osama Mustafa

Oracle Streams ORA-44001: invalid schema

Posted on by Osama Mustafa in Database

SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 job finished
  DECLARE
*
ERROR at line 1:
ORA-23616: Failure in executing block 7 for script
13F5CD569383406C82E7F63EE3F927E0 with
ORA-44001: invalid schema
ORA-06512: at “SYS.DBMS_RECO_SCRIPT_INVOK”, line 139
ORA-06512: at “SYS.DBMS_STREAMS_RPC”, line 465
ORA-06512: at “SYS.DBMS_RECOVERABLE_SCRIPT”, line 659
ORA-06512: at “SYS.DBMS_RECOVERABLE_SCRIPT”, line 682
ORA-06512: at “SYS.DBMS_STREAMS_MT”, line 7972
ORA-06512: at “SYS.DBMS_STREAMS_ADM”, line 2674
ORA-06512: at line 5

The error related to apply_queue parameter in oracle stream is not set with valid value, therefore set the parameter correctly like the below

apply_queue_user => ‘STREAM_ADMIN’ 

Cheers
Osama Mustafa 

[INS-30131] Initial setup required for execution of installer validation failed.

Posted on by Osama Mustafa in Database
When trying to install Oracle client 12c the above error appeared , this issue can happened on windows Or linux.

The cause i really simple :-

On linux there is no enough space under /tmp.

On windows the solution like the following :-

  • Open Windows Services.
  • Stop Oracle Services –> OracleRemExec
  • Remove the OracleRemExecService
  • then try to install Oracle client again

Thank you 
Osama Mustafa

Apply Jdeveloper Patch

Posted on 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

OPATCH : Problems with the lock file

Posted on by Osama Mustafa in Database

Problems with the lock file
Lock file exists, details are:
Interim Patch is holding the lock from ……
probably due to previous unsuccessful operation

Seems the Opatch has been interrupted or hanged therefore the .opatch_storage still exists under Oracle Home

ls -ltr $ORACLE_HOME

Search for .patch_storage and delete it

Try Again..

Osama Mustafa