Oracle Manual Database creation steps
Once the Oracle 11gR2 or lower is installed, Follow the below steps to manually create a database. Ps : Its not an industry standard, Its only for educational purpose. Database Name : demo_db 1. Create the necessary directories. [oracle@asmoracle database]$ cd [oracle@asmoracle ~]$ mkdir -p /u01/app/oracle/oradata/demo_db/control [oracle@asmoracle ~]$ mkdir -p /u01/app/oracle/oradata/demo_db/datafile [oracle@asmoracle ~]$ mkdir -p /u01/app/oracle/oradata/demo_db/redolog [oracle@asmoracle ~]$ ls -ld /u01/app/oracle/oradata/demo_db drwxr-xr-x. 5 oracle oinstall 4096 Jul 26 21:06 /u01/app/oracle/oradata/demo_db [oracle@asmoracle ~]$ ls -ld /u01/app/oracle/oradata/demo_db/control/ drwxr-xr-x. 2 oracle oinstall 4096 Jul 26 21:06 /u01/app/oracle/oradata/demo_db/control/ 2. Update the oratab -- $ORACLE_SID:$ORACLE_HOME:<N|Y>: [oracle@asmoracle ~]$ vi /etc/oratab # This file is used by ORACLE utilities....