Create Database manually for File System Storage Mechanism

Step 1: Create a initSID.ora (Example: initRWDB.ora) file in $ORACLE_HOME/dbs/ directory.

Example: $ORACLE_HOME/dbs/initRWDB.ora

Put following entry in initTEST.ora file

*.audit_sys_operations=TRUE

*.audit_trail='db'

*.compatible='19.3.0.0.0'

*.control_files='/oracle/DATA/control01.ctl','/oracle/DATA/control02.ctl'

*.db_block_size=8192

*.db_name='RWDB'

*.diagnostic_dest='/home/oracle'

*.memory_max_target=754974720

*.memory_target=754974720

*.open_cursors=300

*.os_roles=FALSE

*.processes=300

*.recyclebin='OFF'

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

Step 2: Set ORACLE_HOME , PATH and ORACLE_SID enviroment

export ORACLE_HOME=/oracle/19c_home

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=RWDB

Step 3: Create a password file

cd $ORACLE_HOME/dbs
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwdtest password=manager entries=5

Step 4: Run the following sqlplus command to connect to the database and startup the instance.

$sqlplus '/ as sysdba'

SQL> startup nomount

Step 5: Create the Database. Use following scripts

CREATE DATABASE RWDB

USER SYS IDENTIFIED BY manager

USER SYSTEM IDENTIFIED BY manager

LOGFILE GROUP 1 ('/oracle/DATA/redo01.log') SIZE 50M,

GROUP 2 ('/oracle/DATA/redo02.log') SIZE 50M,

GROUP 3 ('/oracle/DATA/redo03.log') SIZE 50M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 50

MAXDATAFILES 100

MAXINSTANCES 1

DATAFILE '/oracle/DATA/system01.dbf' SIZE 100M autoextend on

SYSAUX DATAFILE '/oracle/DATA/sysaux01.dbf' SIZE 100M autoextend on

DEFAULT TABLESPACE users datafile '/oracle/DATA/users01.dbf' size 100m autoextend on

DEFAULT TEMPORARY TABLESPACE temp

TEMPFILE '/oracle/DATA/temp01.dbf' SIZE 50m

UNDO TABLESPACE undotbs1

DATAFILE '/oracle/DATA/undotbs01.dbf'

SIZE 200M;

Step 6: Run the scripts necessary to build views, synonyms, etc.:

@$ORACLE_HOME/rdbms/admin/catalog.sql -- creates the views of data dictionary tables and the dynamic performance views.

@$ORACLE_HOME/rdbms/admin/catproc.sql -- establishes the usage of PL/SQL functionality and creates many of the PL/SQL Oracle supplied packages.

conn system/manager

./sqlplus/admin/pupbld.sql

@$ORACLE_HOME/sqlplus/admin/pupbld.sql

Step 7: Create Listener file.

cd $ORACLE_HOME/network/admin

vi listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))
    )
  )

lsnrctl start

Step 8: Create tnsnames.ora file

LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))

RWDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AQA1VMSITORA01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = RWDB)
    )
  )

tnsping rwdb