Thursday, 9 August 2018

How to check linux operating system info?

›
-> show kernel version and other info # uname -a -> show machine info #  hostnamectl -> show specific release version # rpm -...

How to check available yum packages?

›
e.g. install/update ansible by yum -> Go to repo path # cd /etc/yum.repos.d/ -> Add source paths into repo file to be able to ins...

How to install/configure/run ansible?

›
-> Set hostname # hostnamectl set-hostname ansible_host -> Add remote hosts into /etc/hosts file # vi /etc/hosts 10.10.10.2 remo...
Tuesday, 7 August 2018

usage of "run_once: true" option

›
If you want to run only once a specific task during all playbook execution, you may add " run_once: true " option into your task t...
Monday, 30 July 2018

How to know last login info on the system?

›
-> show all records $ last -> show all records page by page $ last | more -> show first 10 records $ last | head -> sho...
Wednesday, 18 July 2018

How to change service name?

›
e.g. current service name: postgresql.service desired service name: postgresql-9.1.service Run following commands to change service name...
Friday, 13 July 2018

How to solve remote connection error cause of iptables/firewalld service?

›
Case Machine A (192.168.1.2) wants to connect on Machine B (192.168.1.5) by database port. Action In Machine A; # su - postgres $ psql...

How to solve database module error?

›
Action # ansible-playbook -i myhosts example.yml -v Error TASK [example role : example task] ******************* fatal: [local]: FAILED...
Friday, 6 July 2018

How to prevent sleep mode on laptop when lid closes?

›
Press Window Key then type "Power Options" and click on it -> Click  "Choose what closing the lid does" -> Set ...
Friday, 29 June 2018

How to run a SQL query/statement in a task?

›
You are able to run a SQL query/statement with "echo" command by  shell module for the ansible task. # an example task for sql ...

benefit of "gather_facts: no" setting

›
If you do not need any facts for your variables, you can run your playbook more fast via gather_facts setting. For this, just add followi...
Friday, 18 May 2018

"database "example" is being accessed by other users" solution

›
Action postgres=# drop database example ; Error ERROR:  database " example " is being accessed by other users DETAIL:  There ...
Sunday, 6 May 2018

How to backup database in XE?

›
It is very simple to backup your database in Oracle XE with already prepared .bat file quickly. Steps; Press Windows Key -> Type ...
Friday, 27 April 2018

e.g. truncate table cascade

›
Preparation of Test Data test=#  create table employees (id integer, name varchar, department_id integer); test=#  create table departm...
Thursday, 26 April 2018

e.g. fetching JSON data

›
Preparation of Test Data test=#  create table  T_JSON_DATA  (id INTEGER, body JSON); test=# insert into T_JSON_DATA values (1, '{ ...
Wednesday, 25 April 2018

ORA-02292 solution

›
Preparation -- Insert test data into DEPARTMENT and EMPLOYEES tables. SQL> INSERT INTO DEPARTMENTS VALUES ( 280 ,'New Department...
Thursday, 19 April 2018

e.g. count and distinct aggregate functions

›
examples; count (1) - count(*) - count(column_name) - count( distinct (column_name)) e.g. count aggregate function SQL> SELECT     ...
Wednesday, 11 April 2018

ORA-02449 solution

›
Preparation SQL> CREATE TABLESPACE EXAMPLE_TS DATAFILE   'C:\ORACLEXE_XE\APP\ORACLE\ORADATA\XE\example_01.dbf' SIZE 512K REUSE...

ORA-01549 solution

›
Preparation SQL> CREATE TABLESPACE EXAMPLE_TS DATAFILE   'C:\ORACLE_XE\APP\ORACLE\ORADATA\XE\example_01.dbf' SIZE 512K REUSE ...
Monday, 9 April 2018

e.g. pivot clause

›
Preparation  * Define column names for pivot table SQL> SELECT LISTAGG (           '''' || JOB_ID || '''...