- 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;
7. Run post database create scripts
- @?/rdbms/admin/catalog.sql
- @?/rdbms/admin/catproc.sql
- @?/sqlplus/admin/pupbld.sql
8. Update /etc/oratab file with new database.
9. Connect to database :
