Today 1st September 2015 Oracle Corp. has released patchset 12.1.0.2 for Oracle Database 12c release 1 for Standard Edition 14 months after patchset 12.1.0.2 for Enterprise Edition (22-JUL-2014).
For this installation I have used a new Oracle Linux 6.7 64-bit VirtualBox virtual machine without any Oracle Database software.
First I have configured YUM repository with root account only to enable public_ol6_u7_base in
/etc/yum.repos.d/public-yum-ol6.repo:
[public_ol6_u7_base] name=Oracle Linux $releasever Update 7 installation media copy ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/7/base/$basearch/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle gpgcheck=1 enabled=1
I have added hostname to /etc/hosts:
$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.82 ol6tose1
I have disabled firewall to allow Oracle Net connections:
# chkconfig iptables off
I have also disabled SELINUX and rebooted Oracle Linux machine:
# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of these two values: # targeted - Targeted processes are protected, # mls - Multi Level Security protection. SELINUXTYPE=targeted # reboot
After reboot I have installed Oracle Database preinstallation RPM with:
# yum -y install oracle-rdbms-server-12cR1-preinstall
This RPM installation has also created the oracle account which I have used for following steps.
I have uploaded Oracle Database SE2 installation media to /home/oracle/stage directory:
$ ls -al linuxamd64_12102_database_se2_* -rw-r--r--. 1 oracle oinstall 1673591558 Sep 1 20:42 linuxamd64_12102_database_se2_1of2.zip -rw-r--r--. 1 oracle oinstall 1015358809 Sep 1 20:43 linuxamd64_12102_database_se2_2of2.zip
I have unzipped these 2 files:
$ unzip linuxamd64_12102_database_se2_1of2.zip $ unzip linuxamd64_12102_database_se2_2of2.zip
I have switched to root account to create first Oracle Home root directory /u01 and future database directories:
# mkdir /u01 # chown oracle:dba /u01 # mkdir /u01/oradata # chown oracle:dba /u01/oradata # mkdir -p /u02/fra # chown oracle:dba /u02/fra
I have created full Oracle Home directory with oracle account:
$ mkdir -p /u01/app/oracle/product/12.1.0.2/se2
I have created the silent installation script for Oracle Universal Installer (OUI):
$ cat di.ksh cd database export DISTRIB=`pwd` ./runInstaller -silent \ -responseFile $DISTRIB/response/db_install.rsp \ oracle.install.option=INSTALL_DB_SWONLY \ UNIX_GROUP_NAME=oinstall \ INVENTORY_LOCATION=/u01/app/oracle/oraInventory \ SELECTED_LANGUAGES=en \ ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/se2 \ ORACLE_BASE=/u01/app/oracle \ oracle.install.db.InstallEdition=SE2 \ oracle.install.db.isCustomInstall=false \ oracle.install.db.DBA_GROUP=dba \ oracle.install.db.OPER_GROUP=dba \ oracle.install.db.BACKUPDBA_GROUP=dba \ oracle.install.db.DGDBA_GROUP=dba \ oracle.install.db.KMDBA_GROUP=dba \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \ DECLINE_SECURITY_UPDATES=true
I have launched this script and waited for the message "Successfully Setup Software":
./di.ksh Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 22758 MB Passed Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-09-01_08-52-17PM. Please wait ... [WARNING] [INS-32055] The Central Inventory is located in the Oracle base. ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory. You can find the log of this install session at: /u01/app/oracle/oraInventory/logs/installActions2015-09-01_08-52-17PM.log The installation of Oracle Database 12c was successful. Please check '/u01/app/oracle/oraInventory/logs/silentInstall2015-09-01_08-52-17PM.log' for more details. As a root user, execute the following script(s): 1. /u01/app/oracle/oraInventory/orainstRoot.sh 2. /u01/app/oracle/product/12.1.0.2/se2/root.sh Successfully Setup Software.
I have switched to root account to run:
# /u01/app/oracle/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oracle/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oracle/oraInventory to oinstall. The execution of the script is complete. # # /u01/app/oracle/product/12.1.0.2/se2/root.sh Check /u01/app/oracle/product/12.1.0.2/se2/install/root_ol6tose1_2015-09-01_20-57-12.log for the output of root script # cat /u01/app/oracle/product/12.1.0.2/se2/install/root_ol6tose1_2015-09-01_20-57-12.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.1.0.2/se2 Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.
With oracle account I have setup .profile for ORACLE_HOME and SQL*Plus login.sql:
$ cat .profile export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/se2 PATH=$ORACLE_HOME/bin:$PATH # export EDITOR=vi export SQLPATH=/home/oracle/scripts $ . .profile $ cat $SQLPATH/login.sql set sqlprompt "&&_USER@&&_CONNECT_IDENTIFIER>" set linesize 120 column parameter format a30 column value format a20
At this step running opatch does not display any SE2 information:
$ $ORACLE_HOME/OPatch/opatch lsinv Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2015, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.0.2/se2 Central Inventory : /u01/app/oracle/oraInventory from : /u01/app/oracle/product/12.1.0.2/se2/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0.2/se2/cfgtoollogs/opatch/opatch2015-09-01_20-59-38PM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/se2/cfgtoollogs/opatch/lsinv/lsinventory2015-09-01_20-59-38PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. $ $ORACLE_HOME/OPatch/opatch lsinv -details Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2015, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.1.0.2/se2 Central Inventory : /u01/app/oracle/oraInventory from : /u01/app/oracle/product/12.1.0.2/se2/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location : /u01/app/oracle/product/12.1.0.2/se2/cfgtoollogs/opatch/opatch2015-09-01_21-02-43PM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/se2/cfgtoollogs/opatch/lsinv/lsinventory2015-09-01_21-02-43PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. Installed Products (126): Assistant Common Files 12.1.0.2.0 Buildtools Common Files 12.1.0.2.0 Cluster Verification Utility Common Files 12.1.0.2.0 Database Configuration and Upgrade Assistants 12.1.0.2.0 Database Migration Assistant for Unicode 12.1.0.2.0 Database SQL Scripts 12.1.0.2.0 Database Workspace Manager 12.1.0.2.0 DB TOOLS Listener 12.1.0.2.0 Deinstallation Tool 12.1.0.2.0 Enterprise Edition Options 12.1.0.2.0 Expat libraries 2.0.1.0.2 Generic Connectivity Common Files 12.1.0.2.0 Hadoopcore Component 12.1.0.2.0 HAS Common Files 12.1.0.2.0 HAS Files for DB 12.1.0.2.0 Installation Common Files 12.1.0.2.0 Installation Plugin Files 12.1.0.2.0 Installer SDK Component 12.1.0.2.0 JAccelerator (COMPANION) 12.1.0.2.0 Java Development Kit 1.6.0.75.0 LDAP Required Support Files 12.1.0.2.0 OLAP SQL Scripts 12.1.0.2.0 Oracle Advanced Security 12.1.0.2.0 Oracle Application Express 12.1.0.2.0 Oracle Bali Share 11.1.1.6.0 Oracle Call Interface (OCI) 12.1.0.2.0 Oracle Clusterware RDBMS Files 12.1.0.2.0 Oracle Configuration Manager 10.3.8.1.1 Oracle Configuration Manager Client 10.3.2.1.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Containers for Java 12.1.0.2.0 Oracle Context Companion 12.1.0.2.0 Oracle Core Required Support Files 12.1.0.2.0 Oracle Core Required Support Files for Core DB 12.1.0.2.0 Oracle Core XML Development Kit 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c Multimedia Files 12.1.0.2.0 Oracle Database Deconfiguration 12.1.0.2.0 Oracle Database Gateway for ODBC 12.1.0.2.0 Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0 Oracle Database User Interface 11.0.0.0.0 Oracle Database Utilities 12.1.0.2.0 Oracle Database Vault option 12.1.0.2.0 Oracle DBCA Deconfiguration 12.1.0.2.0 Oracle Extended Windowing Toolkit 11.1.1.6.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support For Core 12.1.0.2.0 Oracle Help for Java 11.1.1.7.0 Oracle Help Share Library 11.1.1.7.0 Oracle Ice Browser 11.1.1.7.0 Oracle Internet Directory Client 12.1.0.2.0 Oracle Java Client 12.1.0.2.0 Oracle Java Layout Engine 11.0.0.0.0 Oracle JDBC Server Support Package 12.1.0.2.0 Oracle JDBC/OCI Instant Client 12.1.0.2.0 Oracle JDBC/THIN Interfaces 12.1.0.2.0 Oracle JFC Extended Windowing Toolkit 11.1.1.6.0 Oracle JVM 12.1.0.2.0 Oracle JVM For Core 12.1.0.2.0 Oracle Label Security 12.1.0.2.0 Oracle LDAP administration 12.1.0.2.0 Oracle Locale Builder 12.1.0.2.0 Oracle Multimedia 12.1.0.2.0 Oracle Multimedia Client Option 12.1.0.2.0 Oracle Multimedia Java Advanced Imaging 12.1.0.2.0 Oracle Multimedia Locator 12.1.0.2.0 Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0 Oracle Multimedia Locator RDBMS Files 12.1.0.2.0 Oracle Net 12.1.0.2.0 Oracle Net Java Required Support Files 12.1.0.2.0 Oracle Net Listener 12.1.0.2.0 Oracle Net Required Support Files 12.1.0.2.0 Oracle Net Services 12.1.0.2.0 Oracle Netca Client 12.1.0.2.0 Oracle Notification Service 12.1.0.2.0 Oracle Notification Service (eONS) 12.1.0.2.0 Oracle Notification Service for Instant Client 12.1.0.2.0 Oracle ODBC Driver 12.1.0.2.0 Oracle ODBC Driverfor Instant Client 12.1.0.2.0 Oracle One-Off Patch Installer 12.1.0.1.2 Oracle Programmer 12.1.0.2.0 Oracle Quality of Service Management (Client) 12.1.0.2.0 Oracle RAC Deconfiguration 12.1.0.2.0 Oracle RAC Required Support Files-HAS 12.1.0.2.0 Oracle Recovery Manager 12.1.0.2.0 Oracle Security Developer Tools 12.1.0.2.0 Oracle SQL Developer 12.1.0.2.0 Oracle Starter Database 12.1.0.2.0 Oracle Text 12.1.0.2.0 Oracle Text ATG Language Support Files 12.1.0.2.0 Oracle Text for Core 12.1.0.2.0 Oracle Text Required Support Files 12.1.0.2.0 Oracle Universal Connection Pool 12.1.0.2.0 Oracle Universal Installer 12.1.0.2.0 Oracle USM Deconfiguration 12.1.0.2.0 Oracle Wallet Manager 12.1.0.2.0 Oracle XML Development Kit 12.1.0.2.0 Oracle XML Query 12.1.0.2.0 oracle.swd.oui.core.min 12.1.0.2.0 Parser Generator Required Support Files 12.1.0.2.0 Perl Interpreter 5.14.1.0.0 Perl Modules 5.14.1.0.0 PL/SQL 12.1.0.2.0 PL/SQL Embedded Gateway 12.1.0.2.0 Platform Required Support Files 12.1.0.2.0 Precompiler Common Files 12.1.0.2.0 Precompiler Common Files for Core 12.1.0.2.0 Precompiler Required Support Files 12.1.0.2.0 Precompilers 12.1.0.2.0 RDBMS Required Support Files 12.1.0.2.0 RDBMS Required Support Files for Instant Client 12.1.0.2.0 RDBMS Required Support Files Runtime 12.1.0.2.0 Required Support Files 12.1.0.2.0 Sample Schema Data 12.1.0.2.0 Secure Socket Layer 12.1.0.2.0 SQL*Plus 12.1.0.2.0 SQL*Plus Files for Instant Client 12.1.0.2.0 SQL*Plus Required Support Files 12.1.0.2.0 SQLJ Runtime 12.1.0.2.0 SSL Required Support Files for InstantClient 12.1.0.2.0 Tracle File Analyzer 12.1.0.2.0 XDK Required Support Files 12.1.0.2.0 XML Parser for Java 12.1.0.2.0 XML Parser for Oracle JVM 12.1.0.2.0 There are 126 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
I have created the DBCA script to create a non-container database:
$ cat crdb.ksh set -x dbca \ -silent \ -createDatabase \ -templateName General_Purpose.dbc \ -gdbName se2 \ -pdbadminPassword oracle12c \ -SysPassword oracle12c \ -SystemPassword oracle12c \ -emConfiguration NONE \ -datafileDestination /u01/oradata\ -asmSysPassword oracle12c \ -characterSet AL32UTF8 \ -totalMemory 1024 \ -recoveryAreaDestination /u02/fra
I have launched this script:
$ ./crdb.ksh ++ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName se2 -pdbadminPassword oracle12c -SysPassword oracle12c -SystemPassword oracle12c -emConfiguration NONE -datafileDestination /u01/oradata -asmSysPassword oracle12c -characterSet AL32UTF8 -totalMemory 1024 -recoveryAreaDestination /u02/fra Copying database files 1% complete 3% complete 11% complete 18% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/se2/se2.log" for further details.
I have checked the created database especially enabled options and default settings for In Memory option:
$ . oraenv ORACLE_SID = [oracle] ? se2 The Oracle base has been set to /u01/app/oracle $ sqlplus / as sysdba @c SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 1 21:48:16 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production SYS@se2>select name from v$database; NAME --------- SE2 SYS@se2>select cdb from v$database; CDB --- NO SYS@se2>-- SYS@se2>select * from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production 0 PL/SQL Release 12.1.0.2.0 - Production 0 CORE 12.1.0.2.0 Production 0 TNS for Linux: Version 12.1.0.2.0 - Production 0 NLSRTL Version 12.1.0.2.0 - Production 0 SYS@se2>show parameter inmemory NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ inmemory_clause_default string inmemory_force string DEFAULT inmemory_max_populate_servers integer 0 inmemory_query string ENABLE inmemory_size big integer 0 inmemory_trickle_repopulate_servers_ integer 1 percent optimizer_inmemory_aware boolean TRUE SYS@se2>select * from v$option where parameter like '%Mem%'; PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- In-Memory Column Store FALSE 0 In-Memory Aggregation FALSE 0 SYS@se2>-- SYS@se2>select * from v$option where value='TRUE'; PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Objects TRUE 0 Connection multiplexing TRUE 0 Connection pooling TRUE 0 Database queuing TRUE 0 Incremental backup and recovery TRUE 0 Instead-of triggers TRUE 0 Parallel load TRUE 0 Proxy authentication/authorization TRUE 0 Plan Stability TRUE 0 Coalesce Index TRUE 0 Transparent Application Failover TRUE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Sample Scan TRUE 0 Java TRUE 0 OLAP Window Functions TRUE 0 Flashback Data Archive TRUE 0 DICOM TRUE 0 XStream TRUE 0 17 rows selected. SYS@se2>-- SYS@se2>select * from v$option where value='FALSE'; PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Partitioning FALSE 0 Real Application Clusters FALSE 0 Advanced replication FALSE 0 Bit-mapped indexes FALSE 0 Parallel backup and recovery FALSE 0 Parallel execution FALSE 0 Point-in-time tablespace recovery FALSE 0 Fine-grained access control FALSE 0 Change Data Capture FALSE 0 Online Index Build FALSE 0 Managed Standby FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Materialized view rewrite FALSE 0 Database resource manager FALSE 0 Spatial FALSE 0 Automatic Storage Management FALSE 0 Export transportable tablespaces FALSE 0 Fast-Start Fault Recovery FALSE 0 Duplexed backups FALSE 0 Block Media Recovery FALSE 0 Fine-grained Auditing FALSE 0 Application Role FALSE 0 Enterprise User Security FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Oracle Data Guard FALSE 0 Oracle Label Security FALSE 0 OLAP FALSE 0 Basic Compression FALSE 0 Join index FALSE 0 Trial Recovery FALSE 0 Advanced Analytics FALSE 0 Online Redefinition FALSE 0 Streams Capture FALSE 0 File Mapping FALSE 0 Block Change Tracking FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Flashback Table FALSE 0 Flashback Database FALSE 0 Transparent Data Encryption FALSE 0 Backup Encryption FALSE 0 Unused Block Compression FALSE 0 Oracle Database Vault FALSE 0 Result Cache FALSE 0 SQL Plan Management FALSE 0 SecureFiles Encryption FALSE 0 Real Application Testing FALSE 0 Active Data Guard FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Server Flash Cache FALSE 0 Advanced Compression FALSE 0 Deferred Segment Creation FALSE 0 Unified Auditing FALSE 0 Management Database FALSE 0 I/O Server FALSE 0 ASM Proxy Instance FALSE 0 Exadata Discovery FALSE 0 Data Mining FALSE 0 Global Data Services FALSE 0 Adaptive Execution Plans FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Table Clustering FALSE 0 Zone Maps FALSE 0 Real Application Security FALSE 0 Privilege Analysis FALSE 0 Data Redaction FALSE 0 Cross Transportable Backups FALSE 0 Cache Fusion Lock Accelerator FALSE 0 Snapshot time recovery FALSE 0 Heat Map FALSE 0 Automatic Data Optimization FALSE 0 Transparent Sensitive Data Protection FALSE 0 PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- In-Memory Column Store FALSE 0 Advanced Index Compression FALSE 0 In-Memory Aggregation FALSE 0 69 rows selected. SYS@se2>-- SYS@se2>column comp_name format a35 SYS@se2>column version format a12 SYS@se2>column status format a10 SYS@se2>select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS ----------------------------------- ------------ ---------- Oracle Database Vault 12.1.0.2.0 VALID Oracle Application Express 4.2.5.00.08 VALID Oracle Label Security 12.1.0.2.0 VALID Spatial 12.1.0.2.0 OPTION OFF Oracle Multimedia 12.1.0.2.0 VALID Oracle Text 12.1.0.2.0 VALID Oracle Workspace Manager 12.1.0.2.0 VALID Oracle XML Database 12.1.0.2.0 VALID Oracle Database Catalog Views 12.1.0.2.0 VALID Oracle Database Packages and Types 12.1.0.2.0 VALID JServer JAVA Virtual Machine 12.1.0.2.0 VALID COMP_NAME VERSION STATUS ----------------------------------- ------------ ---------- Oracle XDK 12.1.0.2.0 VALID Oracle Database Java Packages 12.1.0.2.0 VALID OLAP Analytic Workspace 12.1.0.2.0 OPTION OFF Oracle OLAP API 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters 12.1.0.2.0 OPTION OFF 16 rows selected.
Note that SQL*Plus connection header and v$version clearly display "Standard Edition".