A] Manually database creation

1:Login as Oracle User a)Check environment variables.

b)If SID is not set:

2: Create Required Directories and checking it

3:Create Password File a)Create Password File

4:Verify the Password File

ls -l $ORACLE_HOME/dbs/orapwPROD

5: Check the SID > echo $ORACLE_SID

6: Create the Required Directories

mkdir -p /u01/app/oracle/oradata/PROD mkdir -p /u01/app/oracle/admin/PROD/adump mkdir -p /u01/app/oracle/admin/PROD/pfile mkdir -p /u01/app/oracle/fast_recovery_area

7: Create the PFILE a) Open the file: vi $ORACLE_HOME/dbs/initPROD.ora b) Press i to enter insert mode c) db_name='PROD' memory_target=600M processes=300 audit_file_dest='/u01/app/oracle/admin/PROD/adump' db_block_size=8192 compatible='19.0.0' control_files='/u01/app/oracle/oradata/PROD/control01.ctl','/u01/app/oracle/oradata/PROD/control02.ctl' undo_management=AUTO undo_tablespace='UNDOTBS1' db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' db_recovery_file_dest_size=2G diagnostic_dest='/u01/app/oracle' d)Press Esc e)Type- :wq and enter

8: Verify the PFILE