Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using DBUA DB Environment: Hostname                     : testdb Database Name                : testdb.com           Source DB Version            : 11.2.0.4.0 Source DB home location      : /u01/app/oracle/product/11.2.0/dbhome_1/ Target… Read more..

How to Install the Oracle 12C software only on Oracle Linux 6.7 Download the Oracle Linux 12c software & extract it on Oracle 12c home directory (/u01/app/oracle/product/12.2.0.1/dbhome_1/) & Install the software only. Fallow the below step by step process to install the oracle 12c software only Transfer the software… Read more..

Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using MANUAL Server Environment Hostname                      : testdb Database Name                 : testdb.localdomain    Source DB Version             : 11.2.0.4.0 Source DB home location       : /u01/app/oracle/product/11.2.0/dbhome_1/ Target… Read more..

How to Recover Loss of data without a Backup in Oracle database 11gR2 (11.2.0.4) This scenario is considering as we don’t have any of database backup like RMAN, Restore point, Flashback, Recyclebin, Therefore we can recover only the DML Operation data loss In our case the user is accidentally deleted the records from table & Read More

Delete the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode Database status [oracle@testdb ~]$ sqlplus / as sysdba SQL> select instance_name,status,version from V$instance; INSTANCE_NAME        STATUS       VERSION ————- —————————————– testdb               OPEN        … Read more..

Create the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode Set the bash profile or you can run the environment variable [oracle@testdb ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export… Read more..