I will describe the installation process of Oracle 19c (19.3) Database on Oracle Linux 7.1 on VM.
- 1. Create VM.
- 2. Software Download.
- 3. Install Oracle Linux 7.1 on VM.
- 4. Oracle Database Installation Prerequisites.
- 5. Oracle Database Software Installation.
- 6. Create a Container Database Using DBCA.
- 7. Create a Non-container Database Using DBCA.
- 8. Create Database using SQL Command.
- 9. Post Installation.
1. Create VM:
2. Software Download:
3. Install Oracle Linux 7.1 on VM:
How to Install Oracle Linux 7.1 on VM: Instillation Steps
4. Oracle Database Installation Prerequisites:
There are two ways can configure prerequisties –
- Auto Setup: Using Oracle provided package.
- Manual Setup: Install recommended packages and create user and groups manually.
4.1 Auto Setup:
4.1.1 Using Oracle provided package:
If You have Internet connection on your VM, You may install this package – oracle-database-preinstall-19c which will install all required prerequisites of Oracle Database 19c.
[root@ol71orcl193 ~]# yum install -y oracle-database-preinstall-19c Loaded plugins: langpacks ol7_UEKR3 | 2.5 kB 00:00:00 ol7_latest | 2.7 kB 00:00:00 (1/5): ol7_UEKR3/x86_64/updateinfo | 116 kB 00:00:00 (2/5): ol7_latest/x86_64/group | 660 kB 00:00:01 (3/5): ol7_latest/x86_64/updateinfo | 2.9 MB 00:00:03 (4/5): ol7_UEKR3/x86_64/primary_db | 66 MB 00:00:28 (5/5): ol7_latest/x86_64/primary_db | 36 MB 00:00:29 Resolving Dependencies --> Running transaction check ---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed --> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64 --> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64 --> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64 --> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64 --> Running transaction check ---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed ---> Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed --> Processing Dependency: libaio(x86-64) = 0.3.109-13.el7 for package: libaio-devel-0.3.109-13.el7.x86_64 ---> Package libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7 will be installed --> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.5.el7 for package: libstdc++-devel-4.8.5-39.0.5.el7.x86_64 --> Running transaction check ---> Package libaio.x86_64 0:0.3.109-12.el7 will be updated ---> Package libaio.x86_64 0:0.3.109-13.el7 will be an update ---> Package libstdc++.x86_64 0:4.8.3-9.el7 will be updated ---> Package libstdc++.x86_64 0:4.8.5-39.0.5.el7 will be an update --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================ Package Arch Version Repository Size ============================================================================================================================================ Installing: oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 k Installing for dependencies: compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k ksh x86_64 20120801-142.0.1.el7 ol7_latest 882 k libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k libstdc++-devel x86_64 4.8.5-39.0.5.el7 ol7_latest 1.5 M Updating for dependencies: libaio x86_64 0.3.109-13.el7 ol7_latest 24 k libstdc++ x86_64 4.8.5-39.0.5.el7 ol7_latest 306 k Transaction Summary ============================================================================================================================================ Install 1 Package (+4 Dependent packages) Upgrade ( 2 Dependent packages) Total download size: 2.7 M Downloading packages: No Presto metadata available for ol7_latest warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/compat-libcap1-1.10-7.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Public key for compat-libcap1-1.10-7.el7.x86_64.rpm is not installed (1/7): compat-libcap1-1.10-7.el7.x86_64.rpm | 17 kB 00:00:00 (2/7): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:01 (3/7): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00 (4/7): libstdc++-4.8.5-39.0.5.el7.x86_64.rpm | 306 kB 00:00:00 (5/7): libstdc++-devel-4.8.5-39.0.5.el7.x86_64.rpm | 1.5 MB 00:00:00 (6/7): ksh-20120801-142.0.1.el7.x86_64.rpm | 882 kB 00:00:03 (7/7): oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm | 19 kB 00:00:01 -------------------------------------------------------------------------------------------------------------------------------------------- Total 672 kB/s | 2.7 MB 00:00:04 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Importing GPG key 0xEC551F03: Userid : "Oracle OSS group (Open Source Software group) <[email protected]>" Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03 Package : 7:oraclelinux-release-7.1-1.0.5.el7.x86_64 (@anaconda/7.1) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : libstdc++-4.8.5-39.0.5.el7.x86_64 1/9 Updating : libaio-0.3.109-13.el7.x86_64 2/9 Installing : libaio-devel-0.3.109-13.el7.x86_64 3/9 Installing : libstdc++-devel-4.8.5-39.0.5.el7.x86_64 4/9 Installing : compat-libcap1-1.10-7.el7.x86_64 5/9 Installing : ksh-20120801-142.0.1.el7.x86_64 6/9 Installing : oracle-database-preinstall-19c-1.0-2.el7.x86_64 7/9 Cleanup : libstdc++-4.8.3-9.el7.x86_64 8/9 Cleanup : libaio-0.3.109-12.el7.x86_64 9/9 Verifying : libaio-0.3.109-13.el7.x86_64 1/9 Verifying : libstdc++-devel-4.8.5-39.0.5.el7.x86_64 2/9 Verifying : ksh-20120801-142.0.1.el7.x86_64 3/9 Verifying : compat-libcap1-1.10-7.el7.x86_64 4/9 Verifying : libaio-devel-0.3.109-13.el7.x86_64 5/9 Verifying : libstdc++-4.8.5-39.0.5.el7.x86_64 6/9 Verifying : oracle-database-preinstall-19c-1.0-2.el7.x86_64 7/9 Verifying : libaio-0.3.109-12.el7.x86_64 8/9 Verifying : libstdc++-4.8.3-9.el7.x86_64 9/9 Installed: oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 Dependency Installed: compat-libcap1.x86_64 0:1.10-7.el7 ksh.x86_64 0:20120801-142.0.1.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7 Dependency Updated: libaio.x86_64 0:0.3.109-13.el7 libstdc++.x86_64 0:4.8.5-39.0.5.el7 Complete!
Note::: If installed this package – “oracle-database-preinstall-19c” then you don’t need to perform any other activity including User and Groups. Good to install Oracle Software now.
4.1.2. User Validation:
Created below groups and oracle user by above package.
[root@ol71ora193 ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) e [root@ol71ora193 ~]# passwd oracle Changing password for user oracle. New password: BAD PASSWORD: The password is shorter than 8 characters Retype new password: passwd: all authentication tokens updated successfully. [root@ol71ora193 ~]# su - oracle
4.1.3 Verify the Kernel parameters
[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 [root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576
[root@ol71ora193 ~]# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf | grep oracle oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 or 3GB on x86 OR 90 % of RAM oracle hard memlock 134217728 3GB on x86 OR 90% of RAM oracle soft memlock 134217728 oracle soft data unlimited oracle hard data unlimited
[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 [root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576
4.2 Manual Setup:
4.2.1 Add following parameters on /etc/sysctl.conf
fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500
4.2.2 Validate all parameters on /etc/sysctl.conf.
[root@ol71orcl193 ~]# /sbin/sysctl -p fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500
4.2.3 Add following lines to /etc/security/limits.conf.
oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728
4.2.4 Create Users and Groups: For separation of duties, Oracle recommend to create necessary groups. But most of the cases, below highlighted group will be fine.
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba
useradd -u 54321 -g oinstall -G dba,oper oracle
For details of these groups, you may visit oracle site : Groups
4.2.5. The following packages are recommended to install as prerequisites.
yum install bc yum install binutils yum install compat-libcap1 yum install compat-libstdc++33 yum install elfutils-libelf yum install elfutils-libelf-devel yum install fontconfig-devel yum install glibc yum install glibc-devel yum install ksh yum install libaio yum install libaio-devel yum install libXrender yum install libXrender-devel yum install libX11 yum install libXau yum install libXi yum install libXtst yum install libgcc yum install libstdc++ yum install libstdc++-devel yum install libxcb yum install make yum install smartmontools yum install sysstat
Optional Packages for Oracle Linux 7:
Based on your requirement, install the latest released versions of the following packages:
For Intelligent Platform Management Interface: yum install ipmiutil For Oracl RAC and Oracle Clusterware: yum install net-tools For Oracle ACFS: yum install nfs-utils For Oracle ACFS Remote: yum install python yum install python-configshell yum install python-rtslib yum install python-six yum install targetcli
For details about required Packages check Oracle Site: Packages
4.3 Create required directories for Oracle Software Installation:
[root@ol71orcl193 ~]# mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1 [root@ol71orcl193 ~]# mkdir -p /u01/oradata [root@ol71orcl193 ~]# chown -R oracle:oinstall /u01 [root@ol71orcl193 ~]# chmod -R 775 /u01
4.4 Move software (downloaded binary) to Oracle Home Location.
[oracle@ol71orcl193 dbhome_1]$ pwd /u01/app/oracle/product/19.3.0/dbhome_1 [oracle@ol71orcl193 dbhome_1]$ ls V982063-01.zip [oracle@ol71orcl193 dbhome_1]$ unzip V982063-01.zip [oracle@ol71orcl193 dbhome_1]$ pwd /u01/app/oracle/product/19.3.0/dbhome_1 [oracle@ol71orcl193 dbhome_1]$ ls addnode css deinstall env.ora javavm md OPatch oui R root.sh.old.1 sqlj usm apex ctx demo has jdbc mgw opmn owm racg runInstaller sqlpatch utl assistants cv diagnostics hs jdk network oracore perl rdbms schagent.conf sqlplus V982063-01.zip bin data dmu install jlib nls ord plsql relnotes sdk srvm wwg clone dbjava drdaas instantclient ldap odbc ords precomp root.sh slax suptools xdk crs dbs dv inventory lib olap oss QOpatch root.sh.old sqldeveloper ucp
4.5 Add hostname with IP to /etc/hosts file:
[root@ol71ora193 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 #::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.150 ol71ora193.localdomain ol71ora193
5. Oracle Database Software Installation:
Trigger runInstaller using GUI.
[oracle@ol71ora193 ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 [oracle@ol71ora193 ~]$ cd /u01/app/oracle/product/19.3.0/dbhome_1 [oracle@ol71ora193 dbhome_1]$ ls -l runInstaller -rwxr-x---. 1 oracle oinstall 1783 Mar 8 2017 runInstaller
Select ‘Set Up Software Only‘ option as I will use DBCA for Database Configuration and Click Next.
Choose ‘Single Instance Database Installation‘ Option and click Next.
Choose Database Edition and Click Next…
Provide Oracle Base Location and Click Next…
Leave Default and Click Next…
Select groups for each option. If you have only dba group then select dba group for all. Click Next…
You can provide root password now to run scripts by root user without user Intervation. Don’t Select ‘Automatically run configuration scripts‘ if you want to run manually or need to run by Unix Admin team. Click Next..
Prerequisite Summary. Install below mentioned packages.
Installation recommended packages – kmod-20-21 and kmod-libs-20-21 .
[root@ol71ora193 ~]# yum install kmod-20-21 Loaded plugins: langpacks No package kmod-20-21 available. Error: Nothing to do [root@ol71ora193 ~]# yum install kmod-20-21* Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package kmod.x86_64 0:14-10.el7 will be updated ---> Package kmod.x86_64 0:20-21.0.1.el7 will be an update --> Finished Dependency Resolution Dependencies Resolved ========================================================================================================================== Package Arch Version Repository Size ========================================================================================================================== Updating: kmod x86_64 20-21.0.1.el7 ol7_latest 120 k Transaction Summary ========================================================================================================================== Upgrade 1 Package Total download size: 120 k Is this ok [y/d/N]: y Downloading packages: No Presto metadata available for ol7_latest kmod-20-21.0.1.el7.x86_64.rpm | 120 kB 00:00:01 Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : kmod-20-21.0.1.el7.x86_64 1/2 Cleanup : kmod-14-10.el7.x86_64 2/2 Verifying : kmod-20-21.0.1.el7.x86_64 1/2 Verifying : kmod-14-10.el7.x86_64 2/2 Updated: kmod.x86_64 0:20-21.0.1.el7 Complete! [root@ol71ora193 ~]# yum install kmod-libs-20-21* Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package kmod-libs.x86_64 0:14-10.el7 will be updated ---> Package kmod-libs.x86_64 0:20-21.0.1.el7 will be an update --> Finished Dependency Resolution Dependencies Resolved ========================================================================================================================== Package Arch Version Repository Size ========================================================================================================================== Updating: kmod-libs x86_64 20-21.0.1.el7 ol7_latest 50 k Transaction Summary ========================================================================================================================== Upgrade 1 Package Total download size: 50 k Is this ok [y/d/N]: y Downloading packages: No Presto metadata available for ol7_latest kmod-libs-20-21.0.1.el7.x86_64.rpm | 50 kB 00:00:01 Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : kmod-libs-20-21.0.1.el7.x86_64 1/2 Cleanup : kmod-libs-14-10.el7.x86_64 2/2 Verifying : kmod-libs-20-21.0.1.el7.x86_64 1/2 Verifying : kmod-libs-14-10.el7.x86_64 2/2 Updated: kmod-libs.x86_64 0:20-21.0.1.el7 Complete!
Checked on ‘Ignore All’ Option and click Next…
Click Yes to confirm for prerequisites ignorance.
Summary of selected options. Click Install…
Installation is progressing…
Run below scripts from root user. After Execution of scripts, Click OK.
Scripts Execution from root user and Click OK on above window.
[root@ol71ora193 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@ol71ora193 ~]# /u01/app/ora
oracle/ oraInventory/
[root@ol71ora193 ~]# /u01/app/oracle/
checkpoints/ diag/ product/
[root@ol71ora193 ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.3.0/dbhome_1
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.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
/u01/app/oracle/product/19.3.0/dbhome_1/bin/tfactl
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only
Installation Completed Successfully… Click Close.
6. Create Database Using DBCA:
Create a container and pluggable database using DBCA.
[oracle@ol71ora193 dbhome_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 [oracle@ol71ora193 dbhome_1]$ dbca
Choose ‘Create a Database‘ option. Click Next…
Choose ‘Advanced configuration‘ option and Click Next..
Select Database Type -> Oracle Single Instance Database
Select template -> General Purpose or Transaction Processing.
Click Next…
Provide Global Database Name and SID.
Select ‘Create as Container Database‘ and provide PDB Name.
Click Next..
For Storage Option -> you can select either -> template or OMF. Click Next…
Choose Fast Recovery Option. Re commanded to use default Size but you may use smaller size and can change the size later. Click Next…
If set less values then default then need to confirm. Click Yes..
As this is first database and using DBCA, so Click on Create a new listener option and provide the
Listener Name and Port. Click Next…
Click Next…
Choose the option -> ‘Use Automatic Memory Management’ and Click on ‘Character Sets’ Tab
Choose the ‘Character Sets‘ (if database for migrate from existing then this should be same) option. Click Next…
If you have OEM then better to install OEM agent later. Don’t select any option for Management Options and click Next.
Provide Database User’s (sys, system and pdbadmin) password and Click Next…
Select ‘Create Database‘ and Click Next…
Summary of all selected options. If selected options are OK then Click Finish. Otherwise Click Back and change the option.
Database Creation is progressing.
Database Created Successfully… Click Close.
Post Installation:
[oracle@ol71ora193 dbhome_1]$ . oraenv
ORACLE_SID = [oracle] ? mycdb19
The Oracle base has been set to /u01/app/oracle
[oracle@ol71ora193 dbhome_1]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 30 19:20:38 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 MYPDB READ WRITE NO
Create a Non-container Database Using DBCA:
Set environment variable for ORACLE_HOME & Run dbca command.
Select “Create a Database” Option and Click on Next..
If you choose Creation Mode – “Typical configuration” (then you will get limited option to select) and Click on Next.
Note::: For Advanced Configuration – Check below.
Summary of Select and If you have happy then Click on Finish. It will start installation.
Select “Advanced configuration” and Click Next…
Select Data type and template. Click Next…
Provide the Global database name & SID. Unselect the check box if you want to create Non-Container Database. Click Next…
Select Storage Option and Checked if you want to user OMF. Click Next…
Provide FRA Path and Size. You may enable archive option by Selecting Enable Archiving. Click on Next…
If you have already listener for this Oracle Home, then make sure listener is up. You may create different Lister for this database. Click Next…
Click on Next…
Configuration Options – Memory -> Choose “Use AMM” and Select “Character sets”
Choose Character Sets for you database which is more appropriate based on your application requirement. Click Next..
Click Next…
Provide password for sys and system. Click Next…
You have an option to generate database creation scripts if want to create multiple database with same options. Click Next..
Selected parameters summary for Database Creation. Click Finish if don’t want to change anything.
Database creation is progressing. Click Next…
Database Created Successfully. Click Close.
Oracle 19c Installation Details: Oracle 19c Installation
Create Database using SQL Command:
Post Installation:
1 ping
[…] Please follow this article to install Oracle 19c software only: Oracle 19c s/w only installation […]