بالنسبة للناس إللي إتصابت فعلا بفيروس الكومبيوتر اللي منتشر اليومين دول, يا تري هل هناك أى فرصة لإسترجاع ملفاتهم؟ الإجابة نعم قد تكون هناك فرصة للبعض (وليس للكل). عشان نفهم الإجابة لازم نفهم الأول هو الفيروس ده بيعمل إيه? الفيروس ده إسمه Ransomeware (WannaCry) ومعناه بالعربى دفع الفدية. الفيروس بيقوم بتشفيرملفاتك الشخصية وبيطلب منك دفع … Continue reading Ransomware in Arabic فيروس دفع الفدية بالعربي
Blog
sqlcl Multi-Line Paste Issue
What is the issue? I noticed that sometimes when I copy SQL statement from web and paste it on sqlcl , it is copied on many lines and generating errors. For example, when I copied the following statement: And pasted into sqlcl running on the windows command window, it was pasted as follows: So, it … Continue reading sqlcl Multi-Line Paste Issue
Oracle tnsnames.ora Distribution Management System!
What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!
Oracle Database 32-bit Funny Migration to 64-bit
Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit
Oracle Data Pump Import Log File Analysis
In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and som… Source: Oracle Data Pump Import Log File Analysis
Oracle Data Pump Import Log File Analysis
In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and some need close attention to investigate and fix. For big databases, the import log file may be … Continue reading Oracle Data Pump Import Log File Analysis
Oracle Enterprise Manager 13c (13.2) Installation on Linux
This is a step-by-step procedure to install the latest available release of the Oracle Enterprise Manager 13c (13.2) on Linux 64-bit. The main installation steps are: 1- Install Oracle Database 12c… Source: Oracle Enterprise Manager 13c (13.2) Installation on Linux ThanksAhmed
Cyber attack – it’s not ‘if’ it’s ‘when’ – Hiscox Business Blog
Stephane Flaquet shares his approach to cyber security and how Hiscox’s strategy is just as relevant to small businesses. Source: Cyber attack – it’s not ‘if’ it’s ‘when’ - Hiscox Business Blog ThanksAhmed
Oracle SQL: Normalize the UnNormalized
What is the problem? Sometimes you are faced with a bad (poorly normalized) schema design. For example: But, you may need the output to be in the following normalized form: The correct solution may be to fix the schema design, but in most cases this will not be feasible. Test Case 1: We need to … Continue reading Oracle SQL: Normalize the UnNormalized
Formatting a Wrapped Execution Plan
If you received or produced an execution plan like the following unreadable one: ---------------------------------------------------------------------------------------------------| Id | Operation | Name | E-Rows | OMem |1Mem | Used-Mem |---------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | | || || 1 | SORT AGGREGATE | | 1 | || ||* 2 | HASH JOIN | | 13 | 1102K|1102K| … Continue reading Formatting a Wrapped Execution Plan
Ahmed AbdelFattah Blog ! 