Posts

Showing posts with the label Oracle

Disabling Data Execution Prevention (DEP) for Windows 7 - Part I

This is a general research notes on the new way Date Execution Prevention (DEP) in Windows 7 systems prevents many of the old applications getting executed on the system (mostly memory address areas). There are various details that can be looked into for in-depth knowledge on this issue. Truly speaking this is tight and there is no such workaround except ROP gadgets (Return - Oriented Programming) that is more of ethical hacking than a workaround and is a subject in itself. The problem which usually comes up with is more technical and is related to diverse factors. Actual Exception from Visual Studio: This actual exception comes up while instantiating the new Java Axbridge ActiveX object. System.AccessViolationException was caught Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt. This followed up by NullReference exception as it failed to create the object. Standalone Executable may come up with the fo...

Debug Methods Oracle (Coarse Grained Auditing)

Scenario There are many times, where there was an issue in production and you did not have any idea how it happened. The following article will give you some direction. Please note there are many other ways too. Currently, I will just focus on a method I had used during a similar situation. This error information is from the latest logs from Production said: ORA-00001: unique constraint (TABLE_ABCD.SYS_C006189415) violated       Now the constraints to troubleshoot the above scenario are: You have limited access/privilege in production environment. The above was due to a duplicate record that came in and your process tried to insert that duplicate data. But what was that data that caused disruption? The answer could have been found out by using FlashBack Query feature from Oracle. This however is version specific. Let’s look into some other aspects of debugging. Observation There is no clue to the data that was being insert...

Oracle Version

Image
Requirement is simple; you want to retrieve/recover the Version Information of your currently installed Oracle Database. Let us discuss most of the ways of doing so in Oracle & SQL Server. Here are some of the ways to get it: 1)  DBA_REGISTRY (Table)       S ELECT * FROM DBA_REGISTRY ; SELECT comp_id, comp_name, version, status, namespace, control FROM DBA_REGISTRY WHERE comp_name LIKE '%Oracle%' ORDER BY comp_name; This will give you the db version along with all the other oracle components installed. Here is the result: COMP_ID COMP_NAME VERSION STATUS NAMESPACE CONTROL CATALOG Oracle Database Catalog Views 9.1.0.3.0 VALID SERVER SYS CATPROC Oracle Database Packages and Types 9.1.0.3.0 INVALID SERVER SYS 2 )       V$VERSION ( View ) SELECT * FROM V$VERSION This is the result: BANNER Oracle Database 9G Enterprise Edition Release 9.1.0.3.0 - 64b...