DBA Hub

📋Steps in this guide1/2

Create Oracle 19c Database Manually

Create Oracle 19c Database without Using DBCA

oracle configurationintermediate
by OracleDba
16 views
1

Overview

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. 3. Edit pfile with “ :%s/prim/devdb/g ” it will replace prim with devdb 4. Create respective directories as per file.

Code/Command (click line numbers to comment):

1
2
3
4
5
cd $ORACLE_HOME/dbs
cp initprim.ora initdevdb.ora

Export ORACLE_SID=devdb
Env|grep ORA
2

Section 2

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 :

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!