DeveloperNote.com

Setting up Oracle Database for development

Posted by dmitriano | Oracle |

To set up an Oracle Database for development I install the database in a docker container and then modify password policies in the default user profile as follows:

ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED
  PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_VERIFY_FUNCTION NULL
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME UNLIMITED
  FAILED_LOGIN_ATTEMPTS UNLIMITED;

this prevents passwords from expiring and users from being locked.

(more…)

06
02
20
Leave a comment

A simple C++ serialization framework

Posted by dmitriano | C++ | Tagged cpp-serialization |

I implemented a simple C++ binary serialization framework that makes a structure or class serializable by adding a macro that usually takes one line of code as shown in the example below:

struct A
{
    bool x;
    int y;

    AWL_SERIALIZABLE(x, y)
};

There is also a macro that makes a structure or a class equatable:

AWL_MEMBERWISE_EQUATABLE(A)

(more…)

17
01
20
1 Comment

Oracle Database 19c auditing with Multitenant Architecture

Posted by dmitriano | Oracle |

First I installed Oracle 19c in Docker container , enabled unified auditing, and created multiple pluggable databases:

export ORACLE_SID=ORCLCDB
cd $ORACLE_HOME/bin
#connect to root container
./sqlplus / as sysdba

CREATE PLUGGABLE DATABASE testpdb1 ADMIN USER admin1 IDENTIFIED BY dbpasswd1
    FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/pdbseed', '/opt/oracle/oradata/ORCLCDB/testpdb1');

Pluggable database created.

CREATE PLUGGABLE DATABASE testpdb2 ADMIN USER admin2 IDENTIFIED BY dbpasswd2
    FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/pdbseed', '/opt/oracle/oradata/ORCLCDB/testpdb2');

Pluggable database created.

(more…)

10
01
20
Leave a comment

Installing Oracle Database 19.3 in a Docker container on Ubuntu Server 18.04

Posted by dmitriano | Oracle, Ubuntu |

First I installed Ubuntu Server 18.04 as a Hyper-V machine on Windows 10.

While creating the virtual machine I selected Generation 1, because Generation 2 resulted in some strange effects.

Then I created a separate user with sudo permission:

sudo useradd -d /home/singh -m --shell "/bin/bash" singh
sudo passwd singh
sudo usermod -aG sudo singh

(more…)

18
12
19
Leave a comment

How to prevent a Windows 10 machine from auto-locking

Posted by dmitriano | Windows |

Right-click the Start button.
Click Search.
Type gpedit and hit Enter on your keyboard.
Double-click Administrative Templates.
Double-click Control Panel.
Click Personalization.
Double-click Do not display the lock screen.
Click Enabled.

(more…)

16
12
19
Leave a comment

Inegrating Oracle Database 18 with MS Active Directory

Posted by dmitriano | Oracle |

I configured DNS on my Windows Server 2016 (takes some time, probably 15 minutes):

ipconfig /registerdns

(more…)

13
12
19
Leave a comment

Creating Android application icons

Posted by dmitriano | Android |

There are the key links to the docs:

At the moment of writing this post application icons were of the following sizes:

(more…)

08
12
19
Leave a comment

Mining Monero (XMR) with RandomX on Windows 10

Posted by dmitriano | XMR | Tagged mining |

Enable huge pages by running gpedit.msc and adding the current user to Local Computer Policy->Computer Configuration->Windows Settings->Security Settings->Local Policies->User Rights Assignment->Lock pages in memory: