DBA Hub

📋Steps in this guide1/4

Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI)

Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI) Contents

oracle Oracle 12cclusteringintermediate
by OracleDba
12 views
1

Overview

Contents 1. Environment

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
Platform		: Linuxx86_64
Server Name		: RAC1.RAJASEKHAR.COM, IP: 192.168.2.101
DB Version		:
Oracle 12.2.0.1
, File system: Normal
NON-CDB Name
:
NONCDB12C
Oracle Home Path        : /u01/app/oracle/product/12.2.0.1
2

Section 2

2. Invoke dbca dbca <---- 3. Verify
Step 2

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1
[oracle@rac1 ~]$
export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac1 ~]$ which dbca
/u01/app/oracle/product/12.2.0.1/bin/dbca
[oracle@rac1 ~]$
dbca  <----
3

Section 3

NO <----- lsnrctl status LISTENER | grep -i NONCDB12C OK (0 msec) <---- select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "SYSDATE" FROM DUAL; 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.

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
[oracle@rac1 ~]$
cat /etc/oratab | grep -i NONCDB12C
NONCDB12C:/u01/app/oracle/product/12.2.0.1:N
[oracle@rac1 ~]$
[oracle@rac1 ~]$
ps -ef | grep pmon
oracle    9750     1  0 21:10 ?        00:00:00 ora_pmon_
NONCDB12C  <---
oracle   10228  3318  0 21:24 pts/0    00:00:00 grep pmon
[oracle@rac1 ~]$
[oracle@rac1 ~]$
. oraenv
ORACLE_SID = [oracle] ?
NONCDB12C
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1 ~]$
[oracle@rac1 ~]$
sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Jul 21 21:25:53 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
select name,open_mode,cdb from v$database;
NAME      OPEN_MODE            CDB
--------- -------------------- ---
NONCDB12
READ WRITE
NO  <-----
SQL>
SQL>
show con_name
CON_NAME
------------------------------
NONCDB12
SQL>
SQL>
archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination
/u02/archive/NONCDB12C
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1
SQL>
SQL>
select name from v$datafile
UNION
select name from v$tempfile;
2    3

NAME
--------------------------------------------------------------------------------
/u02/oradata/NONCDB12C/sysaux01.dbf
/u02/oradata/NONCDB12C/system01.dbf
/u02/oradata/NONCDB12C/temp01.dbf
/u02/oradata/NONCDB12C/undotbs01.dbf
/u02/oradata/NONCDB12C/users01.dbf

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@rac1 ~]$
[oracle@rac1 ~]$
ps -ef | grep tns
root        22     2  0 19:30 ?        00:00:00 [netns]
oracle    2978     1  0 19:31 ?        00:00:00 /u01/app/oracle/product/12.2.0.1/bin/tnslsnr
LISTENER
-inherit
oracle   10732  3318  0 21:27 pts/0    00:00:00 grep tns
[oracle@rac1 ~]$
[oracle@rac1 ~]$
lsnrctl status LISTENER | grep -i NONCDB12C
Service "
NONCDB12C.rajasekhar.com
" has 1 instance(s).
  Instance "NONCDB12C", status
READY
, has 1 handler(s) for this service...
Service "NONCDB12CXDB.rajasekhar.com" has 1 instance(s).
  Instance "
NONCDB12C
", status
READY
, has 1 handler(s) for this service...
[oracle@rac1 ~]$

[oracle@rac1 ~]$
tnsping NONCDB12C
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 21-JUL-2018 21:28:02

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

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

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NONCDB12C.rajasekhar.com)))
OK (0 msec) <----
[oracle@rac1 ~]$
NONCDB12C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NONCDB12C.rajasekhar.com)
    )
  )
[oracle@rac1 ~]$
sqlplus sys@NONCDB12C AS SYSDBA
SQL*Plus: Release 12.2.0.1.0 Production on Sat Jul 21 21:31:17 2018

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
SQL>
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "SYSDATE" FROM DUAL;
SYSDATE
-----------------------------
21-JUL-2018 21:31:37
SQL>
4

Section 4

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.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!