Mir Sayeed Hassan – Oracle Blog

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 & committed, but we...
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..