18 Steps for Oracle 18c Installation and Database Creation for On Premise Environment
Hi DBAs,
Oracle 18c Rel3 On premise Database released as expected in Jul 2018. Since I work and Spend most of my time
working with On Premise Databases, Applications and Fusion Middleware components, so decided to write this post based on
My practical experience with Oracle 18c today to assist DBAs.
Below are my 18 steps for Oracle 18c Installation on Linux 64-bit Operating System:
Step 1: Copy and Unzip the Software on server.
Once you unzip the Oracle18c Rel3 Software you will notice while extracting lot of linking of binaries happen and it will
create ORACLE_HOME in same path, this is interesting and new feature of 18c Database.f
cd Oracle_18c_Rel3_Linux_64bit/
ls -ltr
unzip LINUX.X64_180000_db_home.zip
inflating: md/gdal/bin/gdalenhance
inflating: md/gdal/bin/gdallocationinfo
inflating: md/gdal/bin/ogrinfo
creating: md/lib/
inflating: md/lib/libsdogdal.so
linking: bin/lbuilder -> ../nls/lbuilder/lbuilder
linking: lib/libocci.so -> libocci.so.18.1
linking: lib/libodm18.so -> libodmd18.so
linking: lib/libagtsh.so -> libagtsh.so.1.0
linking: lib/libclntsh.so -> libclntsh.so.18.1
linking: lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
linking: javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
linking: javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
linking: lib/libclntshcore.so -> libclntshcore.so.18.1
linking: lib/libclntsh.so.11.1 -> libclntsh.so
linking: lib/libclntsh.so.10.1 -> libclntsh.so
linking: precomp/public/ORACA.H -> oraca.h
linking: precomp/public/SQLCA.H -> sqlca.h
linking: precomp/public/SQLDA.H -> sqlda.h
linking: precomp/public/ORACA.COB -> oraca.cob
linking: precomp/public/SQLCA.COB -> sqlca.cob
linking: javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
linking: javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
linking: javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
linking: javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
linking: javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
linking: javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
linking: javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
linking: javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
extracting: install/.img.bin
finishing deferred symbolic links:
bin/lbuilder -> ../nls/lbuilder/lbuilder
lib/libocci.so -> libocci.so.18.1
lib/libodm18.so -> libodmd18.so
lib/libagtsh.so -> libagtsh.so.1.0
lib/libclntsh.so -> libclntsh.so.18.1
lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
lib/libclntshcore.so -> libclntshcore.so.18.1
lib/libclntsh.so.11.1 -> libclntsh.so
lib/libclntsh.so.10.1 -> libclntsh.so
precomp/public/ORACA.H -> oraca.h
precomp/public/SQLCA.H -> sqlca.h
precomp/public/SQLDA.H -> sqlda.h
precomp/public/ORACA.COB -> oraca.cob
precomp/public/SQLCA.COB -> sqlca.cob
javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ ls -ltr
total 4457740
-rw-r--r--. 1 oracle oinstall 852 Aug 18 2015 env.ora
-rw-r--r--. 1 oracle oinstall 2927 Oct 14 2016 schagent.conf
-rwxr-x---. 1 oracle oinstall 1783 Mar 8 2017 runInstaller
drwxr-x---. 7 oracle oinstall 69 Feb 8 01:11 xdk
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 wwg
drwxr-xr-x. 4 oracle oinstall 31 Feb 8 01:11 usm
drwxr-xr-x. 5 oracle oinstall 45 Feb 8 01:11 suptools
drwxr-xr-x. 6 oracle oinstall 54 Feb 8 01:11 srvm
drwxr-xr-x. 3 oracle oinstall 17 Feb 8 01:11 sqlj
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 slax
-rw-r-----. 1 oracle oinstall 10 Feb 8 01:11 root.sh.old.1
drwxr-xr-x. 3 oracle oinstall 21 Feb 8 01:11 relnotes
drwxr-xr-x. 4 oracle oinstall 29 Feb 8 01:11 racg
drwxr-xr-x. 5 oracle oinstall 52 Feb 8 01:11 R
drwxr-xr-x. 4 oracle oinstall 33 Feb 8 01:11 owm
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 oss
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 ordim
drwxr-xr-x. 4 oracle oinstall 34 Feb 8 01:11 oracore
drwxr-xr-x. 5 oracle oinstall 42 Feb 8 01:11 olap
drwxr-xr-x. 4 oracle oinstall 31 Feb 8 01:11 mgw
drwxr-xr-x. 2 oracle oinstall 6 Feb 8 01:11 log
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 has
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 dv
drwxr-xr-x. 3 oracle oinstall 20 Feb 8 01:11 diagnostics
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 dbjava
drwxr-xr-x. 3 oracle oinstall 20 Feb 8 01:11 data
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 css
drwxr-xr-x. 6 oracle oinstall 78 Feb 8 01:12 plsql
drwxr-xr-x. 2 oracle oinstall 22 Feb 8 01:12 dbs
drwxr-xr-x. 2 oracle oinstall 33 Feb 8 01:12 utl
drwxr-xr-x. 2 oracle oinstall 29 Feb 8 01:12 instantclient
drwxr-xr-x. 13 oracle oinstall 198 Feb 8 01:12 dmu
drwxr-xr-x. 3 oracle oinstall 35 Feb 8 01:12 ucp
drwxr-xr-x. 3 oracle oinstall 35 Feb 8 01:12 jdbc
drwxr-xr-x. 2 oracle oinstall 26 Feb 8 01:12 QOpatch
drwxr-xr-x. 4 oracle oinstall 67 Feb 8 01:12 ords
drwxr-xr-x. 5 oracle oinstall 119 Feb 8 01:13 sdk
drwxr-xr-x. 6 oracle oinstall 4096 Feb 8 01:13 apex
drwxr-xr-x. 22 oracle oinstall 4096 Feb 8 01:13 sqldeveloper
drwxr-xr-x. 8 oracle oinstall 101 Feb 8 01:13 odbc
drwxr-xr-x. 11 oracle oinstall 119 Feb 8 01:14 ctx
-rwx------. 1 oracle oinstall 786 Feb 8 01:14 root.sh.old
drwxr-x---. 14 oracle oinstall 4096 Jun 4 04:20 OPatch
drwxr-xr-x. 6 oracle oinstall 53 Jul 18 20:17 sqlplus
-rwx------. 1 oracle oinstall 638 Jul 18 20:18 root.sh
drwxr-xr-x. 2 oracle oinstall 4096 Jul 18 20:39 jlib
drwxr-xr-x. 5 oracle oinstall 153 Jul 18 20:41 sqlpatch
drwxr-xr-x. 7 oracle oinstall 246 Jul 18 20:44 jdk
drwxr-xr-x. 13 oracle oinstall 140 Jul 18 20:44 rdbms
drwxr-xr-x. 6 oracle oinstall 56 Jul 18 20:44 precomp
drwxr-xr-x. 5 oracle oinstall 39 Jul 18 20:44 perl
drwxr-xr-x. 7 oracle oinstall 64 Jul 18 20:44 ord
drwxr-xr-x. 7 oracle oinstall 65 Jul 18 20:44 opmn
drwxr-xr-x. 5 oracle oinstall 46 Jul 18 20:44 nls
drwxr-xr-x. 10 oracle oinstall 106 Jul 18 20:44 network
drwxr-xr-x. 9 oracle oinstall 98 Jul 18 20:44 md
drwxr-xr-x. 10 oracle oinstall 112 Jul 18 20:44 ldap
drwxr-xr-x. 8 oracle oinstall 82 Jul 18 20:44 javavm
drwxr-xr-x. 5 oracle oinstall 41 Jul 18 20:44 hs
drwxr-xr-x. 4 oracle oinstall 30 Jul 18 20:44 drdaas
drwxr-xr-x. 3 oracle oinstall 20 Jul 18 20:44 demo
drwxr-xr-x. 7 oracle oinstall 71 Jul 18 20:44 cv
drwxr-xr-x. 6 oracle oinstall 55 Jul 18 20:44 crs
drwxr-xr-x. 9 oracle oinstall 93 Jul 18 20:44 assistants
drwxr-xr-x. 8 oracle oinstall 226 Jul 18 20:44 oui
drwxr-xr-x. 3 oracle oinstall 12288 Jul 18 20:44 lib
drwxr-x---. 13 oracle oinstall 219 Jul 18 20:44 inventory
drwxr-xr-x. 5 oracle oinstall 191 Jul 18 20:44 deinstall
drwxr-xr-x. 4 oracle oinstall 87 Jul 18 20:44 clone
drwxr-xr-x. 2 oracle oinstall 8192 Jul 18 20:44 bin
drwxr-xr-x. 2 oracle oinstall 102 Jul 18 20:44 addnode
drwxr-xr-x. 10 oracle oinstall 4096 Jul 18 20:53 install
-rw-r--r--. 1 oracle oinstall 4564649047 Jul 24 08:46 LINUX.X64_180000_db_home.zip
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$
Step 2:Verify and check the Shared Memory Operating System level
It is very important to resize kernel.shmmax and kernel.shmall parameter in /etc/sysctl.conf as below
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ free -m
total used free shared buff/cache available
Mem: 64172 2071 32258 3009 29842 58432
Swap: 20479 0 20479
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ exit
logout
[root@orasolsTest u02]# vi /etc/sysctl.conf
[root@orasolsTest u02]# cat /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
#Add kernel parameters
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
[root@orasolsTest u02]# sysctl -p
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Step 3: Create and Configure a Single Instance Database
Go to $ORACLE_HOME path and launch ./runInstaller
Step 4: Choose as Server Class if you are doing on Server or Desktop for your own System
Step 5: Choose Enterprise Edition
Standard Edition 2 seems new from Oracle 18c on premise DB
Step 6: Specify ORACLE_BASE location.
It should be under same path where you extracted the Oracle 18c Release 3 software. Details in my post in Step 1.
Step 8: Specify configuration options
Memory
Character Set
Sample schemas
Step 9: Specify Database Storage options
Step 9: Specify Management options if required(optional step)
Step 10: Specify RECOVERY options if required(optional step)
After executing 'root.sh' you will get Oracle Trace File Analyzer (TFA) location if you want you can setup it as well. This is new feature from Oracle 18c Release 3 Database.
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# pwd
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# sh root.sh
[root@orasolsTest soft]# ls
Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest soft]# cd Oracle_18c_Rel3_Linux_64bit/
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# pwd
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# sh root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
Enter the full pathname of the local bin directory: [/usr/local/bin]:
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.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
no
Oracle Trace File Analyzer (TFA - Non Daemon Mode) is available at :
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/suptools/tfa/release/tfa_home/bin/tfactl
Note :
1. tfactl will use TFA Daemon Mode if TFA already running in Daemon Mode and user has access to TFA
2. tfactl will configure TFA Non Daemon Mode only if user has no access to TFA Daemon mode or TFA Daemon mode is not
installed
OR
Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script :
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/suptools/tfa/release/tfa_home/install/roottfa.sh
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]#
Step 15: After executing 'root.sh' continue with the Installation of the product
Step 16: Post installation Steps:
=> Create the Environment file for Oracle 18c
=> Source the Environment
[oracle@orasolsTest ~]$ cat ora18c.env
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
#PATH=$PATH:$HOME/.local/bin:$HOME/bin
PATH=$PATH:$HOME/bin:/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/bin
export PATH
export ORACLE_SID=ora18c
export ORACLE_HOME=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
export TNS_ADMIN=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/network/admin
export TEMP=/tmp
export TMPDIR=/tmp
#export ALERT_LOG=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/diag/rdbms/crimsdb/crimsdb/trace/
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ echo $ORACLE_SID
ora18c
[oracle@orasolsTest ~]$ echo $ORACLE_HOME
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[oracle@orasolsTest ~]$
Step 17: Connect to the Oracle 18c Database and validate it.
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ echo $ORACLE_SID
ora18c
[oracle@orasolsTest ~]$ echo $ORACLE_HOME
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[oracle@orasolsTest ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 24 13:15:04 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
[oracle@orasolsTest ~]$ exit
logout
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# clear
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# su - oracle
Last login: Tue Jul 24 13:07:10 +03 2018 on pts/0
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jul 24 13:38:06 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA18C (DBID=604293408)
RMAN> exit
Recovery Manager complete.
[oracle@orasolsTest ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Jul 24 13:38:19 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> select name from v$database;
NAME
---------
ORA18C
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select *from v$version;
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
0
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Step 18: Validate the New Components added in Oracle 18c
We have Oracle Database Vault and Oracle Label security( Security components ) new from Oracle 18c Database.
SQL>
SQL> set linesize 12000
SQL> set pages 12000
SQL> col COMP_NAME for a35
SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
------------------------------ ----------------------------------- ------------------------------
--------------------------------------------
CATALOG Oracle Database Catalog Views 18.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 18.0.0.0.0 VALID
RAC Oracle Real Application Clusters 18.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 18.0.0.0.0 VALID
XML Oracle XDK 18.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 18.0.0.0.0 VALID
APS OLAP Analytic Workspace 18.0.0.0.0 VALID
XDB Oracle XML Database 18.0.0.0.0 VALID
OWM Oracle Workspace Manager 18.0.0.0.0 VALID
CONTEXT Oracle Text 18.0.0.0.0 VALID
ORDIM Oracle Multimedia 18.0.0.0.0 VALID
SDO Spatial 18.0.0.0.0 VALID
XOQ Oracle OLAP API 18.0.0.0.0 VALID
OLS Oracle Label Security 18.0.0.0.0 VALID
DV Oracle Database Vault 18.0.0.0.0 VALID
15 rows selected.
Enjoy have a nice time with Oracle 18c Database. Enjoy DBA Tasks.
In my upcoming posts I will focus on Administration Tasks for Oracle 18c... Stay Tune..
Thanks,
Rafi.
Hi DBAs,
Oracle 18c Rel3 On premise Database released as expected in Jul 2018. Since I work and Spend most of my time
working with On Premise Databases, Applications and Fusion Middleware components, so decided to write this post based on
My practical experience with Oracle 18c today to assist DBAs.
Below are my 18 steps for Oracle 18c Installation on Linux 64-bit Operating System:
Step 1: Copy and Unzip the Software on server.
Once you unzip the Oracle18c Rel3 Software you will notice while extracting lot of linking of binaries happen and it will
create ORACLE_HOME in same path, this is interesting and new feature of 18c Database.f
cd Oracle_18c_Rel3_Linux_64bit/
ls -ltr
unzip LINUX.X64_180000_db_home.zip
inflating: md/gdal/bin/gdalenhance
inflating: md/gdal/bin/gdallocationinfo
inflating: md/gdal/bin/ogrinfo
creating: md/lib/
inflating: md/lib/libsdogdal.so
linking: bin/lbuilder -> ../nls/lbuilder/lbuilder
linking: lib/libocci.so -> libocci.so.18.1
linking: lib/libodm18.so -> libodmd18.so
linking: lib/libagtsh.so -> libagtsh.so.1.0
linking: lib/libclntsh.so -> libclntsh.so.18.1
linking: lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
linking: javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
linking: javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
linking: lib/libclntshcore.so -> libclntshcore.so.18.1
linking: lib/libclntsh.so.11.1 -> libclntsh.so
linking: lib/libclntsh.so.10.1 -> libclntsh.so
linking: precomp/public/ORACA.H -> oraca.h
linking: precomp/public/SQLCA.H -> sqlca.h
linking: precomp/public/SQLDA.H -> sqlda.h
linking: precomp/public/ORACA.COB -> oraca.cob
linking: precomp/public/SQLCA.COB -> sqlca.cob
linking: javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
linking: javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
linking: javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
linking: javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
linking: javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
linking: javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
linking: javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
linking: javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
extracting: install/.img.bin
finishing deferred symbolic links:
bin/lbuilder -> ../nls/lbuilder/lbuilder
lib/libocci.so -> libocci.so.18.1
lib/libodm18.so -> libodmd18.so
lib/libagtsh.so -> libagtsh.so.1.0
lib/libclntsh.so -> libclntsh.so.18.1
lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
lib/libclntshcore.so -> libclntshcore.so.18.1
lib/libclntsh.so.11.1 -> libclntsh.so
lib/libclntsh.so.10.1 -> libclntsh.so
precomp/public/ORACA.H -> oraca.h
precomp/public/SQLCA.H -> sqlca.h
precomp/public/SQLDA.H -> sqlda.h
precomp/public/ORACA.COB -> oraca.cob
precomp/public/SQLCA.COB -> sqlca.cob
javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ ls -ltr
total 4457740
-rw-r--r--. 1 oracle oinstall 852 Aug 18 2015 env.ora
-rw-r--r--. 1 oracle oinstall 2927 Oct 14 2016 schagent.conf
-rwxr-x---. 1 oracle oinstall 1783 Mar 8 2017 runInstaller
drwxr-x---. 7 oracle oinstall 69 Feb 8 01:11 xdk
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 wwg
drwxr-xr-x. 4 oracle oinstall 31 Feb 8 01:11 usm
drwxr-xr-x. 5 oracle oinstall 45 Feb 8 01:11 suptools
drwxr-xr-x. 6 oracle oinstall 54 Feb 8 01:11 srvm
drwxr-xr-x. 3 oracle oinstall 17 Feb 8 01:11 sqlj
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 slax
-rw-r-----. 1 oracle oinstall 10 Feb 8 01:11 root.sh.old.1
drwxr-xr-x. 3 oracle oinstall 21 Feb 8 01:11 relnotes
drwxr-xr-x. 4 oracle oinstall 29 Feb 8 01:11 racg
drwxr-xr-x. 5 oracle oinstall 52 Feb 8 01:11 R
drwxr-xr-x. 4 oracle oinstall 33 Feb 8 01:11 owm
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 oss
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 ordim
drwxr-xr-x. 4 oracle oinstall 34 Feb 8 01:11 oracore
drwxr-xr-x. 5 oracle oinstall 42 Feb 8 01:11 olap
drwxr-xr-x. 4 oracle oinstall 31 Feb 8 01:11 mgw
drwxr-xr-x. 2 oracle oinstall 6 Feb 8 01:11 log
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 has
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 dv
drwxr-xr-x. 3 oracle oinstall 20 Feb 8 01:11 diagnostics
drwxr-xr-x. 3 oracle oinstall 19 Feb 8 01:11 dbjava
drwxr-xr-x. 3 oracle oinstall 20 Feb 8 01:11 data
drwxr-xr-x. 3 oracle oinstall 18 Feb 8 01:11 css
drwxr-xr-x. 6 oracle oinstall 78 Feb 8 01:12 plsql
drwxr-xr-x. 2 oracle oinstall 22 Feb 8 01:12 dbs
drwxr-xr-x. 2 oracle oinstall 33 Feb 8 01:12 utl
drwxr-xr-x. 2 oracle oinstall 29 Feb 8 01:12 instantclient
drwxr-xr-x. 13 oracle oinstall 198 Feb 8 01:12 dmu
drwxr-xr-x. 3 oracle oinstall 35 Feb 8 01:12 ucp
drwxr-xr-x. 3 oracle oinstall 35 Feb 8 01:12 jdbc
drwxr-xr-x. 2 oracle oinstall 26 Feb 8 01:12 QOpatch
drwxr-xr-x. 4 oracle oinstall 67 Feb 8 01:12 ords
drwxr-xr-x. 5 oracle oinstall 119 Feb 8 01:13 sdk
drwxr-xr-x. 6 oracle oinstall 4096 Feb 8 01:13 apex
drwxr-xr-x. 22 oracle oinstall 4096 Feb 8 01:13 sqldeveloper
drwxr-xr-x. 8 oracle oinstall 101 Feb 8 01:13 odbc
drwxr-xr-x. 11 oracle oinstall 119 Feb 8 01:14 ctx
-rwx------. 1 oracle oinstall 786 Feb 8 01:14 root.sh.old
drwxr-x---. 14 oracle oinstall 4096 Jun 4 04:20 OPatch
drwxr-xr-x. 6 oracle oinstall 53 Jul 18 20:17 sqlplus
-rwx------. 1 oracle oinstall 638 Jul 18 20:18 root.sh
drwxr-xr-x. 2 oracle oinstall 4096 Jul 18 20:39 jlib
drwxr-xr-x. 5 oracle oinstall 153 Jul 18 20:41 sqlpatch
drwxr-xr-x. 7 oracle oinstall 246 Jul 18 20:44 jdk
drwxr-xr-x. 13 oracle oinstall 140 Jul 18 20:44 rdbms
drwxr-xr-x. 6 oracle oinstall 56 Jul 18 20:44 precomp
drwxr-xr-x. 5 oracle oinstall 39 Jul 18 20:44 perl
drwxr-xr-x. 7 oracle oinstall 64 Jul 18 20:44 ord
drwxr-xr-x. 7 oracle oinstall 65 Jul 18 20:44 opmn
drwxr-xr-x. 5 oracle oinstall 46 Jul 18 20:44 nls
drwxr-xr-x. 10 oracle oinstall 106 Jul 18 20:44 network
drwxr-xr-x. 9 oracle oinstall 98 Jul 18 20:44 md
drwxr-xr-x. 10 oracle oinstall 112 Jul 18 20:44 ldap
drwxr-xr-x. 8 oracle oinstall 82 Jul 18 20:44 javavm
drwxr-xr-x. 5 oracle oinstall 41 Jul 18 20:44 hs
drwxr-xr-x. 4 oracle oinstall 30 Jul 18 20:44 drdaas
drwxr-xr-x. 3 oracle oinstall 20 Jul 18 20:44 demo
drwxr-xr-x. 7 oracle oinstall 71 Jul 18 20:44 cv
drwxr-xr-x. 6 oracle oinstall 55 Jul 18 20:44 crs
drwxr-xr-x. 9 oracle oinstall 93 Jul 18 20:44 assistants
drwxr-xr-x. 8 oracle oinstall 226 Jul 18 20:44 oui
drwxr-xr-x. 3 oracle oinstall 12288 Jul 18 20:44 lib
drwxr-x---. 13 oracle oinstall 219 Jul 18 20:44 inventory
drwxr-xr-x. 5 oracle oinstall 191 Jul 18 20:44 deinstall
drwxr-xr-x. 4 oracle oinstall 87 Jul 18 20:44 clone
drwxr-xr-x. 2 oracle oinstall 8192 Jul 18 20:44 bin
drwxr-xr-x. 2 oracle oinstall 102 Jul 18 20:44 addnode
drwxr-xr-x. 10 oracle oinstall 4096 Jul 18 20:53 install
-rw-r--r--. 1 oracle oinstall 4564649047 Jul 24 08:46 LINUX.X64_180000_db_home.zip
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$
Step 2:Verify and check the Shared Memory Operating System level
It is very important to resize kernel.shmmax and kernel.shmall parameter in /etc/sysctl.conf as below
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ free -m
total used free shared buff/cache available
Mem: 64172 2071 32258 3009 29842 58432
Swap: 20479 0 20479
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1
[oracle@orasolsTest Oracle_18c_Rel3_Linux_64bit]$ exit
logout
[root@orasolsTest u02]# vi /etc/sysctl.conf
[root@orasolsTest u02]# cat /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
#Add kernel parameters
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
[root@orasolsTest u02]# sysctl -p
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Step 3: Create and Configure a Single Instance Database
Go to $ORACLE_HOME path and launch ./runInstaller
Step 4: Choose as Server Class if you are doing on Server or Desktop for your own System
Step 5: Choose Enterprise Edition
Standard Edition 2 seems new from Oracle 18c on premise DB
It should be under same path where you extracted the Oracle 18c Release 3 software. Details in my post in Step 1.
Step 7: Choose General Purpose and Specify the Database Identifiers in the next screen.
Step 8: Specify configuration options
Memory
Character Set
Sample schemas
Step 9: Specify Database Storage options
Step 9: Specify Management options if required(optional step)
Step 10: Specify SAMPLE options if required(optional step)
Step 11:Specify Privilege OS groups
Step 12: Installer does series of prerequisite checks
Step 13:Verify Summary and Click Install for installation and Database creation of Oracle 18c
Step 14:Execute root.sh script to perform series of actions :
After executing 'root.sh' you will get Oracle Trace File Analyzer (TFA) location if you want you can setup it as well. This is new feature from Oracle 18c Release 3 Database.
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# pwd
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# sh root.sh
[root@orasolsTest soft]# ls
Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest soft]# cd Oracle_18c_Rel3_Linux_64bit/
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# pwd
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# sh root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
Enter the full pathname of the local bin directory: [/usr/local/bin]:
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.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
no
Oracle Trace File Analyzer (TFA - Non Daemon Mode) is available at :
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/suptools/tfa/release/tfa_home/bin/tfactl
Note :
1. tfactl will use TFA Daemon Mode if TFA already running in Daemon Mode and user has access to TFA
2. tfactl will configure TFA Non Daemon Mode only if user has no access to TFA Daemon mode or TFA Daemon mode is not
installed
OR
Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script :
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/suptools/tfa/release/tfa_home/install/roottfa.sh
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]#
Step 15: After executing 'root.sh' continue with the Installation of the product
Click Close. This completes Oracle 18c Software Installation and
Step 16: Post installation Steps:
=> Create the Environment file for Oracle 18c
=> Source the Environment
[oracle@orasolsTest ~]$ cat ora18c.env
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
#PATH=$PATH:$HOME/.local/bin:$HOME/bin
PATH=$PATH:$HOME/bin:/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/bin
export PATH
export ORACLE_SID=ora18c
export ORACLE_HOME=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
export TNS_ADMIN=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/network/admin
export TEMP=/tmp
export TMPDIR=/tmp
#export ALERT_LOG=/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit/diag/rdbms/crimsdb/crimsdb/trace/
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ echo $ORACLE_SID
ora18c
[oracle@orasolsTest ~]$ echo $ORACLE_HOME
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[oracle@orasolsTest ~]$
Step 17: Connect to the Oracle 18c Database and validate it.
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ echo $ORACLE_SID
ora18c
[oracle@orasolsTest ~]$ echo $ORACLE_HOME
/u02/ora18c/soft/Oracle_18c_Rel3_Linux_64bit
[oracle@orasolsTest ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 24 13:15:04 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
[oracle@orasolsTest ~]$ exit
logout
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# clear
[root@orasolsTest Oracle_18c_Rel3_Linux_64bit]# su - oracle
Last login: Tue Jul 24 13:07:10 +03 2018 on pts/0
[oracle@orasolsTest ~]$ . ora18c.env
[oracle@orasolsTest ~]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jul 24 13:38:06 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA18C (DBID=604293408)
RMAN> exit
Recovery Manager complete.
[oracle@orasolsTest ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Jul 24 13:38:19 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> select name from v$database;
NAME
---------
ORA18C
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select *from v$version;
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
0
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Step 18: Validate the New Components added in Oracle 18c
We have Oracle Database Vault and Oracle Label security( Security components ) new from Oracle 18c Database.
SQL>
SQL> set linesize 12000
SQL> set pages 12000
SQL> col COMP_NAME for a35
SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
------------------------------ ----------------------------------- ------------------------------
--------------------------------------------
CATALOG Oracle Database Catalog Views 18.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 18.0.0.0.0 VALID
RAC Oracle Real Application Clusters 18.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 18.0.0.0.0 VALID
XML Oracle XDK 18.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 18.0.0.0.0 VALID
APS OLAP Analytic Workspace 18.0.0.0.0 VALID
XDB Oracle XML Database 18.0.0.0.0 VALID
OWM Oracle Workspace Manager 18.0.0.0.0 VALID
CONTEXT Oracle Text 18.0.0.0.0 VALID
ORDIM Oracle Multimedia 18.0.0.0.0 VALID
SDO Spatial 18.0.0.0.0 VALID
XOQ Oracle OLAP API 18.0.0.0.0 VALID
OLS Oracle Label Security 18.0.0.0.0 VALID
DV Oracle Database Vault 18.0.0.0.0 VALID
15 rows selected.
Enjoy have a nice time with Oracle 18c Database. Enjoy DBA Tasks.
In my upcoming posts I will focus on Administration Tasks for Oracle 18c... Stay Tune..
Thanks,
Rafi.
I was looking for that really in depth post
ReplyDeleteSbi International Debit Cards
This is really too useful and has more ideas from your blog. Keep sharing more blog like this, thank you. We are waiting for your new blog and for useful information....Please contact us for Oracle Fusion Cloud Financials Training details in our Erptree Training Institute
ReplyDelete