Create Oracle 19c Database Manually

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 04 May, 2022
  • 0 Comments
  • 1 Min Read

Create Oracle 19c Database Manually

Create Oracle 19c Database Manually

Following are the steps to create a database manually :

  1. Oracle Database must be installed.
  2. Create pfile & start the instance. Copy pfile from another database & edit it.                                                    
cd $ORACLE_HOME/dbs
cp initprim.ora initdevdb.ora

   3. Edit pfile with “ :%s/prim/devdb/g ” it will replace prim with devdb

              

               

 

    4. Create respective directories as per file. 


5. Set environmental variables to connect to new SID.
Export ORACLE_SID=devdb
Env|grep ORA

6. Issue Create Database statement.  
CREATE DATABASE DEVDB

USER sys IDENTIFIED BY sys

USER system IDENTIFIED BY system

MAXLOGFILES 5

MAXLOGMEMBERS 3

MAXDATAFILES 200

MAXINSTANCES 1

MAXLOGHISTORY 500

LOGFILE GROUP 1 ('/data/app/oracle/oradata/devdb/redo01a.rdo',

'/data/app/oracle/oradata/devdb/redo01b.rdo') SIZE 50M,

GROUP 2 ('/data/app/oracle/oradata/devdb/redo02a.rdo',

'/data/app/oracle/oradata/devdb/redo02b.rdo') SIZE 50M,

GROUP 3 ('/data/app/oracle/oradata/devdb/redo03a.rdo',

'/data/app/oracle/oradata/devdb/redo03b.rdo') SIZE 50M

DATAFILE '/data/app/oracle/oradata/devdb/system01.dbf' SIZE 300M EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/data/app/oracle/oradata/devdb/sysaux01.dbf' SIZE 200M UNDO TABLESPACE UNDOTBS1

DATAFILE '/data/app/oracle/oradata/devdb/undotbs01.dbf'

SIZE 300M AUTOEXTEND OFF

DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/app/oracle/oradata/devdb/TEMP01.dbf' SIZE 200M

REUSE AUTOEXTEND OFF

CHARACTER SET WE8ISO8859P1

NATIONAL CHARACTER SET UTF8

ENABLE PLUGGABLE DATABASE

SEED

FILE_NAME_CONVERT = ('/data/app/oracle/oradata/devdb',

'/data/app/oracle/oradata/devdb/pdbseed')

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

SYSAUX DATAFILES SIZE 100M

USER_DATA TABLESPACE usertbs

DATAFILE '/data/app/oracle/oradata/devdb/usertbs01.dbf'

SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;