Oracle

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 […]

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 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 […]

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 […]

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 […]