BLOG

Jordan Amman Oracle User Group

Posted on by Osama Mustafa in News
It’s almost here, 09/04/2015 I published before about first event for JAOUG, I am so excited, organizing the event not easy needs a lot of work , commitment and dedication. finally we are here.

Since this is the first event before the biggest one, it’s only introduction for the group and to introduce the local people and let them know about the group.

We prepare the poster today and seems perfect.

Thanks for the amazing Volunteer and PSUT to make this dream come true.
Osama Mustafa

Jordan Amman Oracle User Group First Event

Posted on by Osama Mustafa in News
as most of you know that i created new oracle group in Jordan to allow people involve in oracle community and teach them more about oracle, this step was huge for me and the group established in 2014

Now it’s Officially, the first event will be organized 09/April/2015 as introduction to this group, the volunteers working so hard, the second event will be surprise since it will be the biggest one in Jordan i will be announce about it soon. we still working on the logo but this is the initial one.

Thank you 
Osama Mustafa

Configure RMAN Backup On Windows

Posted on by Osama Mustafa in Database
Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-

  • Create first text file called backup and change the format to “bat”, inside the file add the following lines :-

C:
cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman

  • Create 3 folders in E for example :-
    • backup
    • Archivelog
    • Controlfile
  • Create second file name it Backup.rman and add the Rman Script like below 

connect target /
run
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format ‘E:\RMAN\backup\db_%t_%s_p%p.bkp’ database;
backup AS COMPRESSED BACKUPSET archivelog all format ‘E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch’ delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format ‘E:\RMAN\backup\cf_%t_%s_p%p.bkp’;
backup tag ORCL_CONTROL current controlfile format ‘E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL’;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

  • Follow the screen now :-

      • Add Task Name and Description :-
      • Add The Time for this Task in this tab 
      • Another Screen :-
      • In This Screen Add Bat File in our case backup.bat
       

      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 

      Enterprise Manager : Performance Across Enterprise Databases

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

      [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

      ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD Siebel

      Posted on by Osama Mustafa in Application

      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