Friday, March 27, 2015

Install Oracle grid infrastructure On Linux 6.6

This Post will explain Step by step provide with Screenshot how to install Oracle grid infrastructure 11.2.0.4 On Linux 6.6

Link From here

Cheers
Osama 

Tuesday, March 24, 2015

Configure ASMLIB On Oracle Linux 6.6

In this post will show you how to configure Oracle ASMLIB On Linux 6.6

I uploaded the document on Slideshare , check it from here


Cheers
Osama Mustafa

Monday, March 23, 2015

Enable/Disable SSH For Root User

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

Sunday, March 22, 2015

Oracle Streams ORA-44001: invalid schema

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 

Friday, March 20, 2015

Enterprise Manager : Performance Across Enterprise Databases

The below link is very to understand the performance under #EM12c Provided by oracle, This demonstration shows you how to use AWR Warehouse a new feature of Oracle Enterprise Manager 12c Release 4.

https://www.youtube.com/watch?v=StydMitHtuI&feature=youtu.be

Cheers
Osama Mustafa

Thursday, March 19, 2015

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

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

Tuesday, March 17, 2015

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD Siebel

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD

The above error happened to Siebel CRM.

the solution is so simple :-

In my version Siebel configured as SSO because of this OID hold all the application user after check o i found that orcladmin have only one week for password expiration Siebel consider this as error so i increase password policy in OID.

Cheers
Osama