If you want to do update another column when execute an update on table, you can use before update trigger. If you use after update trigger, you can get some errors. if you use pragma autonomous_transaction parameter as declare in trigger you can get errors like that are “ORA-00060: deadlock detected while waiting for resource”, “ORA-06512:…
Change Hostname on OEL 7 CentOS 7
You can use hostnamectl command to list and change hostname of operating system on OEL 7 or CentOS 7 version. List Hostname Status [root@localhost ~]# hostnamectl Static hostname: localhost.localdomain Icon name: computer-vm Chassis: vm Machine ID: 6f021291e2384a219e1f23ca39eadc9a Boot ID: ec195c69cfde417b88b86f4d7419cf24 Virtualization: vmware Operating System: Oracle Linux Server 7.3 CPE OS Name: cpe:/o:oracle:linux:7:3:server Kernel: Linux 4.1.12-61.1.28.el7uek.x86_64…
PostgreSQL Upgrade From 9.5 Version To 9.6 Version With PG_UPGRADE
pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically required for major version upgrades, e.g. from 8.4.7 to the current major release of PostgreSQL. It is not required for minor version upgrades, e.g. from 9.0.1 to 9.0.4. Major PostgreSQL…
Change Hostname in RHEL 7
Changing hostname is different from RHEL 6 version in RHEL 7. You can use few method to change hostname. I will demonstrate useful and easy method that is hostnamectl command. Show Current Hostname [root@localhost ~]# hostname localhost.localdomain or [root@localhost ~]# hostnamectl status Static hostname: localhost.localdomain Icon name: computer-vm Chassis: vm Machine ID: 418f684e1a5c45c9a22f76065c732de3 Boot ID:…
Firewalld Add New Port, List All Ports, Remove Port with firewall-cmd command in Oracle Linux 7
What is firewalld Firewalld provides a dynamically managed firewall with support for network/firewall zones that define the trust level of network connections or interfaces. It has support for IPv4, IPv6 firewall settings, ethernet bridges and IP sets. There is a separation of runtime and permanent configuration options. It also provides an interface for services or…
MsSQL Server 2012 Availability Groups (AG) Manual Failover
If primary side of Availability Groups (AG) is down and can not be online, you can perform failover operation. When primary side is down, probably, you can see state of Availability Groups at the secondary side like below. Failover Steps If you get an error after click Failover button, probably your AG has a problem….
MsSQL Server 2012 Availability Groups (AG) Force Manual Failover
When you can not access primary side of AG and you can not run failover on second side (disaster side), you can perform force manual failover operation on second side. You have to know that force manual failover operation can cause loss data which is able to last some database operation. Failover State When primary…
Obtain Surname, Last Name and Mid Name From Full Name in Oracle
If you have a column with full name data and you want to split this data, you can use below function to split operation. Split Name ve Surname Table : test Data1 : Emin Fatih Acar Data2 : Fatih Acar SQL> select fullname, substr(fullname,0,instr(fullname,’ ‘,Instr(fullname,’ ‘,-1))-1) name, substr(fullname,Instr(fullname,’ ‘,-1)+1) surname from test; Result: Data1 name…
Turkey Stay Summer Time Zone and How to Implement TZDATA Package for Linux Systems
Turkey is breaking step with Europe and keeping summer time through the winter. Instead of turning clocks back an hour as they do in the European Union in the autumn, Turkey will keep the clocks as they are and effectively change the country’s time zone. You have to implement new tzdata-2016g package on your systems…
Oracle 11g Oracle Checkpoint Not Complete, Cannot Allocate New Log Warning
Error: Checkpoint not complete, Cannot Allocate New Log Warning Thread 1 cannot allocate new log, sequence 125487 Checkpoint not complete Solution: Checkpoint not complete messages are generated due to the logs are switching so fast that the checkpoint associated with the log switch isn’t complete. You should increase redo log file size and amount to…