Question 1. What is Oracle RAC and its uses ? Answer Oracle RAC is a cluster database where multiple instances of Oracle runs multiple nodes sharing a single physical database and have common data & control files Each instance has its own log files and rollback segments (UNDO Tablespace) and can simultaneously execute transactions against […]
Oracle
How to change date format in oracle database
We often need to change the date format while checking. Here are some ways which you can use to change date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current value […]
How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud
How to Login to Oracle Cloud Database on port 1521 using SSH tunnel with Linux client $ ssh -i private-key-file -L local-port:target-ip-address:target-port opc@target-ip-address private-key-file is the path to the SSH private key file. local-port is the number of an available port on your Linux system. Specify a port number greater than 1023 and less than […]
How to give oracle kill own session privilege to Developers
Often developers ask how we can kill our own session as they dont want to wait for the DBA to respond and kill. They want the oracle kill own session privilege. We dont have any privilege like alter system kill session which can be given to the user. We can give alter system privilege but […]
How to download Patch from Oracle using Wget
Patches can be downloaded using command line download manager utility such as wget. 1.First we need to check if we have wget installed in the system You can use below command which wget or locate wget 2. Make sure it is compiled with SSL option $ wget –help (Below output shows that wget is compiled […]
10 Tricks You Must Know When Using Autoconfig In Oracle R12
Introduction to Autoconfig in oracle apps R12 -Autoconfig in oracle apps r12 is a tool that supports automated configuration of an Applications instance.-Autoconfig tool is a set of scripts to centralize and simplify E-Business Suite configuration management.-It does so by maintaining a central repository of E-Business Suite environment information in a context file(.xml) on each midtier.-Run […]