Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI)
Contents
___________________________________________________________________________________________________
1. Environment
2. Invoke dbca
3. Verify
___________________________________________________________________________________________________
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
[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.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>
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.
Thank you,
Rajasekhar Amudala