[Oracle DataBase Server 12.2 Installation on Oracle Linux 7.4]: Changing Data File Location

!!! It is correct to place data files and indexes on different disks. (I was too lazy and did not describe this)

Create directories:

$ mkdir -p /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/data
$ mkdir -p /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/indexes
$ mkdir -p /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/undo
$ mkdir -p /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/temp



$ sqlplus / as sysdba



SQL> select name from v$datafile;



NAME
--------------------------------------------------------------------------------
/u02/oracle/oradata/12.2/orcl/system01.dbf
/u02/oracle/oradata/12.2/orcl/sysaux01.dbf
/u02/oracle/oradata/12.2/orcl/undotbs01.dbf
/u02/oracle/oradata/12.2/orcl/users01.dbf



SQL> shutdown immediate;



SQL> startup mount;



SQL> HOST mv /u02/oracle/oradata/12.2/orcl/system01.dbf /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/data/system01.dbf
SQL> HOST mv /u02/oracle/oradata/12.2/orcl/sysaux01.dbf /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/data/sysaux01.dbf
SQL> HOST mv /u02/oracle/oradata/12.2/orcl/users01.dbf /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/data/users01.dbf

SQL> HOST mv /u02/oracle/oradata/12.2/orcl/undotbs01.dbf /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/undo/undotbs01.dbf



SQL> select name from v$tempfile;



NAME
--------------------------------------------------------------------------------
/u02/oracle/oradata/12.2/orcl/temp01.dbf



SQL> HOST mv /u02/oracle/oradata/12.2/orcl/temp01.dbf /u02/oracle/oradata/12.2/${ORACLE_SID}/DATAFILE/temp/temp01.dbf



SQL> ALTER DATABASE RENAME FILE '/u02/oracle/oradata/12.2/orcl/system01.dbf' TO '/u02/oracle/oradata/12.2/orcl12/DATAFILE/data/system01.dbf';

SQL> ALTER DATABASE RENAME FILE '/u02/oracle/oradata/12.2/orcl/sysaux01.dbf' TO '/u02/oracle/oradata/12.2/orcl12/DATAFILE/data/sysaux01.dbf';

SQL> ALTER DATABASE RENAME FILE '/u02/oracle/oradata/12.2/orcl/users01.dbf'  TO '/u02/oracle/oradata/12.2/orcl12/DATAFILE/data/users01.dbf';



SQL> ALTER DATABASE RENAME FILE '/u02/oracle/oradata/12.2/orcl/undotbs01.dbf' TO '/u02/oracle/oradata/12.2/orcl12/DATAFILE/undo/undotbs01.dbf';

SQL> ALTER DATABASE RENAME FILE '/u02/oracle/oradata/12.2/orcl/temp01.dbf' TO '/u02/oracle/oradata/12.2/orcl12/DATAFILE/temptemp01.dbf';



SQL> alter database open;



SQL> quit