We value your privacy

We use cookies to enhance your browsing experience, serve personalised content, and analyse our traffic. By clicking "Accept All", you consent to our use of cookies.

Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

  Master in Data Analyst | Join 2 Days Live Webinar From 31 March 2025 at 7.30 PM IST| Register for Free Demo

Know More

Create Oracle 19c Database Manually

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.                                                    
1
2
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.
1
2
Export ORACLE_SID=devdb
Env|grep ORA

6. Issue Create Database statement.  
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;

7. Run post database create scripts

  1. @?/rdbms/admin/catalog.sql
  2. @?/rdbms/admin/catproc.sql
  3. @?/sqlplus/admin/pupbld.sql

8. Update /etc/oratab file with new database.


9. Connect to database :


RAC Administration
Duplicate Database Using RMAN Backup Set | Clone Database using RMAN