This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Extract Process The extract process of Oracle GoldenGate is used to perform […]
Oracle GoldenGate: Manager Sample Parameter File
This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Manager Process The manager process is not the most talked about […]
Oracle LRM-00123: invalid character 0 found in the input file
Initialization parameters are configuration parameters that affect the operation of an instance. The instance reads these initialization parameters from either a text initialization parameter file(pfile/init.ora) or a server parameter file (spfile) at startup time. There are many different initialization parameters to optimize operation in various environments. Normally when you want to start your oracle database […]
How to Disable rpc.quotad Service in CentOS/RHEL
The protocol used by rpc.rquotad is an unsecured and obsolete protocol and should be disabled. This security vulnerability is discussed in CVE-1999-9625 and further details can be found in that document. This procedure can disrupt NFS clients relying on disk quotas. To avoid issues, schedule a maintenance outage and stop these NFS clients. For CentOS/RHEL […]
What is a FACTLESS FACT TABLE? Where we use Factless Fact
In a dimensional design, the fact table is the locus for process measurement. It is the place where measurements are stored. The measurements are called facts, which is where the fact table gets its name. Paradoxically, a fact table does not always require facts to measure a process. A fact table that contains no facts […]
Sample listener.ora file for Oracle
LISTENER.ORA is a configuration file used to control the operation of an Oracle listener on the server. You can have more than one listener configured in one LISTENER.ORA file if each has a unique name. The listerner.ora file contains server side network configuration parameters. It can be found in the “$ORACLE_HOME/network/admin” directory on the server. […]
Archiving Failures with ORA-16038, ORA-19504, ORA-00312
Problem 1 After the server was patched on OS level, the following database error messages are reported in the alert.log file: Unable to create archive log file ‘/path/name.arc’ ARC3: Error 19504 Creating archive log file to ‘/path/name.arc’ ARCH: Archival stopped, error occured. Will continue retrying. ORACLE instance “name” – Archival error ORA-16038: log 3 sequence […]
IN and EXISTS SQL Operator
EXISTS Operator Use EXISTS to test if a subquery returns results or not. Typically, the subquery references another table. The following query returns employees who also happen to be customers: SELECT e.id, e.name FROM employees e WHERE EXISTS (SELECT * FROM customers c WHERE c.email = e.email); IN Operator Use IN to test whether a […]
Oracle Interview Questions – Indexes on Partitioned Table
What is local and global index? Local index is where the index is equipartitioned with its table, the index is partitioned on the same columns, with the same number of partitions and the same partition bounds as its table. So each index partition is associated with exactly one partition of the underlying table, that is, […]
SQL Script to Monitor Usage of Indexes
You have an environment that is heavily indexed, and you want to monitor the usage of the indexes. For example, at the end of the week before the batch loads, you would like to check which indexes are being used in queries throughout the week. You can find the index usage from the explain plan. […]