ANKUSH 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 :
- Oracle Database must be installed.
- 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;