What is an SPFILE? A server parameter file (SPFILE) is a new feature introduced in Oracle9i. Initialization parameters stored in a server parameter file are persistent, in that any changes made to the parameters while an instance is running can persist across instance shutdown and startup. This eliminates the need to manually update initialization parameters […]
oracle
How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command
In this post, we will discuss about how to convert IMG Files to VDI, VMDK, VHD format for Oracle VirtualBox, Vmware and XenCenter. First We have to take Image from Linux System and It will take some time. 1. Open the windows cmd. Click Run -> cmd -> Enter 2. Notice that Windows open a […]
Oracle Interview Questions – oratab file
Oracle provides a mechanism for automatically setting the required OS variables. This approach relies on two files: oratab and oraenv. You can think of the entries in the oratab file as a registry of what databases are installed on a box and their corresponding Oracle home directories. The oratab file is automatically created for you […]
Oracle GoldenGate: GLOBALS Sample Parameter File
This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup in line with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. The GLOBALS file stores parameters that relate to the GoldenGate […]
Oracle GoldenGate: Replicat Sample Parameter File
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. Replicat Process The replicate process is the apply process within an Oracle […]
Oracle GoldenGate: Pump (Extract) Sample Parameter File
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. Pump (Extract) Process The data pump group is a secondary extract group […]
Oracle GoldenGate: Extract Sample Parameter File
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 […]
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 […]