DBA Hub

📋Steps in this guide1/6

CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA

CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA Contents

oracle Oracle 19Cclusteringintermediate
by OracleDba
18 views
1

Overview

CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA Contents 1. Overview
2

Section 2

2. Set the Environment -- No need to create directory COKE, it will create automatically by dbca 3. Create Database using DBCA silent mode

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Usually to create database we will use DBCA graphical user interface.

Some times may not have access to a graphical user interface then we can use the DBCA silent mode to create a database.

We are going to create NON-CONTAINER database as COKE
Database Binary Version: 19.3.0.0.0
OS                     : Linux x86_64

[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac1 ~]$
export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac1 ~]$
which dbca
/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca
[oracle@rac1 ~]$ dbca
-- No need to create directory COKE, it will create automatically by dbca
3

Section 3

3. Create Database using DBCA silent mode dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName COKE.rajasekhar.com -sid COKE -sysPassword Coke123$ -systemPassword Coke@123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 Database creation complete. 4. Verify

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
[oracle@rac1 ~]$
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName COKE.rajasekhar.com -sid COKE -sysPassword Coke123$ -systemPassword Coke@123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete.
For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/COKE.
Database Information:
Global Database Name:COKE.rajasekhar.com
System Identifier(SID):COKE
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/COKE/COKE.log" for further details.
[oracle@rac1 ~]$
4

Section 4

cat /etc/oratab | grep -i COKE select name,open_mode,cdb from v$database; NO <---- show con_name No Archive Mode <----

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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
[oracle@rac1 ~]$
cat /etc/oratab | grep -i COKE
COKE:/u01/app/oracle/product/19.0.0/dbhome_1:N
[oracle@rac1 ~]$

[oracle@rac1 ~]$
ps -ef | grep pmon
oracle    4273     1  0 19:53 ?        00:00:00 ora_pmon
_COKE
oracle    5240  2552  0 19:56 pts/0    00:00:00 grep --color=auto pmon
[oracle@rac1 ~]$

[oracle@rac1 ~]$
. oraenv
ORACLE_SID = [dell] ? COKE
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1 ~]$
sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 26 19:57:31 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>
select name,open_mode,cdb from v$database;
NAME      OPEN_MODE            CDB
--------- -------------------- ---
COKE      READ WRITE
NO <----
SQL>

SQL>
show con_name
CON_NAME
------------------------------
COKE
SQL>
SQL> archive log list
Database log mode
No Archive Mode <----
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch
Oldest online log sequence     3
Current log sequence           5
SQL>
SQL>
select name from v$datafile
UNION
select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/COKE/sysaux01.dbf
/u01/app/oracle/oradata/COKE/system01.dbf
/u01/app/oracle/oradata/COKE/temp01.dbf
/u01/app/oracle/oradata/COKE/undotbs01.dbf
/u01/app/oracle/oradata/COKE/users01.dbf

SQL>
listener.ora
LISTENER_COKE =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1523))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
    )
  )
SID_LIST_LISTENER_COKE =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = COKE.rajasekhar.com)
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
      (SID_NAME = COKE)
    )
  )
tnsnames.ora
COKE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = COKE.rajasekhar.com)
    )
  )
[oracle@rac1 admin]$
tnsping COKE
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2020 20:07:59

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT =
1523
)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = COKE.rajasekhar.com)))
OK
(10 msec)
[oracle@rac1 admin]$

[oracle@rac1 admin]$
lsnrctl status LISTENER_COKE
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2020 20:09:54

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.rajasekhar.com)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias
LISTENER_COKE
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                26-JAN-2020 20:03:42
Uptime                    0 days 0 hr. 6 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rac1/listener_coke/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.rajasekhar.com)(PORT=
1523
)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
Services Summary...
Service "COKE.rajasekhar.com" has 1 instance(s).
  Instance "
COKE
", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 admin]$

[oracle@rac1 ~]$
sqlplus sys@coke as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 26 20:15:24 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version
19.3.0.0.0
SQL>
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "SYSDATE" FROM DUAL;
SYSDATE
-----------------------------
26-JAN-2020 20:15:45
SQL>
5

Section 5

listener.ora tnsnames.ora 19.3.0.0.0 26-JAN-2020 20:15:45 Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution:
6

Section 6

Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!