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

Platform		: Linuxx86_64
Server Name		: RAC1.DBA Learning Hub.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

[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  <----
              

[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.DBA Learning Hub.com" has 1 instance(s).
  Instance "NONCDB12C", status READY, has 1 handler(s) for this service...
Service "NONCDB12CXDB.DBA Learning Hub.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.DBA Learning Hub.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NONCDB12C.DBA Learning Hub.com)))
OK (0 msec) <----
[oracle@rac1 ~]$

NONCDB12C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.DBA Learning Hub.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NONCDB12C.DBA Learning Hub.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>