Recovering the root password in Linux

There are multiple ways to reset a root password on a Linux machine. In this scenario, we are going to assume that the best way to reset the password is to interrupt the boot process, move into the “emergency mode” and force a reset of the root password. 1. Start or reboot a system to…

Read More

Creating a linked server to Oracle in 64bit SQL Server

First, Oracle driver should be installed on SQL Server machine. It is quite easy to download and install the latest version of 64-bit Oracle Data Access Components (ODAC) (xCopy) from Oracle web site. After install, “ORAOLEDB.Oracle” should appear under Linked Server–> Providers. Then, create a linked server like below. Using EZConnect method instead of TNS…

Read More

Running Linux command in MySQL command-line client

In Linux systems, MySQL client program generally run as below : # mysql -uuser -p [database] Then, interactive mysql client program starts and waits your MySQL commands. At some point, you may need to enter a Linux shell command without ending the MySQL client program. A solution for this is, putting “\” to the beginning…

Read More

Using PASSTHRU/NOPASSTHRU

In GoldenGate replication, if source and target table structures are same and no filtering or column mapping applied, PASSTHRU can be used in data pump process parameters. In order to make GoldenGate to interpret two tables as “same”, column names, column orders, data types and size must be same. Using PASSTHRU parameter will increase performance…

Read More

Defgen in MS-SQL Server to Oracle replication

As we know, when performing GoldenGate replication in a heterogeneous environment, table definitions need to be generated by using defgen and must be shared between source and target databases. If replication is from a MS SQL Server to an Oracle database, using “NOEXTATTR” parameter while generating table definitions will prevent some potential problems. Example: defgen.exe…

Read More