World's 1st autonomous Database. The 18c
18c database eliminates the complexity, human error and manual efforts. Still official release to come for DBs on Linux server, they have released version for exadata oracle public cloud (on trial version as well).
I've tried to installed it on linux with some parameter changes on Linux:
18c database eliminates the complexity, human error and manual efforts. Still official release to come for DBs on Linux server, they have released version for exadata oracle public cloud (on trial version as well).
I've tried to installed it on linux with some parameter changes on Linux:
Setting environment for Oracle software and Databases (RPMS)
Installing RPMS and setting IPs:
Making host file entry, specifying ip in host file:
vi /etc/hosts
127.0.0.1 localhost localhost.localdomain
192.168.1.12 18ctestdb 18ctestdb
[root@18cTestdb ~]#
Add the following lines to the "/etc/sysctl.conf" file, or in a file called
"/etc/sysctl.d/98-oracle.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
than in order to be activate/to take effects now run below command
/sbin/systcl -p
Add the following lines to a file called "/etc/security/limits.d/oracle-database-server-
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
Installing the RPM available at Package directory of ISO image:
cd /media/rhel5/package
rpm -Uvh --force --nodeps gcc-4.4.7-3.el6.x86_64.rpm
rpm -Uvh --force --nodeps gcc-c++-4.4.7-3.el6.x86_64.rpm
rpm -Uvh --force --nodeps binutils*
rpm -Uvh --force --nodeps compat-libcap1*
rpm -Uvh --force --nodeps compat-libstdc++-33*
rpm -Uvh --force --nodeps compat-libstdc++-33.i686*
rpm -Uvh --force --nodeps glibc*
rpm -Uvh --force --nodeps glibc.i686*
rpm -Uvh --force --nodeps glibc-devel*
rpm -Uvh --force --nodeps glibc-devel.i686*
rpm -Uvh --force --nodeps ksh*
rpm -Uvh --force --nodeps libaio*
rpm -Uvh --force --nodeps libaio.i686*
rpm -Uvh --force --nodeps libaio-devel*
rpm -Uvh --force --nodeps libaio-devel.i686*
rpm -Uvh --force --nodeps libX11*
rpm -Uvh --force --nodeps libX11.i686*
rpm -Uvh --force --nodeps libXau*
rpm -Uvh --force --nodeps libXau.i686*
rpm -Uvh --force --nodeps libXi*
rpm -Uvh --force --nodeps libXi.i686*
rpm -Uvh --force --nodeps libXtst*
rpm -Uvh --force --nodeps libXtst.i686*
rpm -Uvh --force --nodeps libgcc*
rpm -Uvh --force --nodeps libgcc.i686*
rpm -Uvh --force --nodeps libstdc++*
rpm -Uvh --force --nodeps libstdc++.i686*
rpm -Uvh --force --nodeps libstdc++-devel*
rpm -Uvh --force --nodeps libstdc++-devel.i686*
rpm -Uvh --force --nodeps libxcb*
rpm -Uvh --force --nodeps libxcb.i686*
rpm -Uvh --force --nodeps make*
rpm -Uvh --force --nodeps nfs-utils*
rpm -Uvh --force --nodeps net-tools*
rpm -Uvh --force --nodeps smartmontools*
rpm -Uvh --force --nodeps sysstat*
rpm -Uvh --force --nodeps unixODBC*
rpm -Uvh --force --nodeps unixODBC-devel*
Creating the groups:
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
Creating the Oracle User and setting password for it:
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
Setting up directory structure:
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle/product/18.0.0/db1
chown -R oracle:oinstall /u01/app/oraInventory
chown -R oracle:oinstall /u01/app/oracle/product/18.0.0/db1
Setting environment variable for CDB:
export ORACLE_HOME=/u01/app/oracle/product/18.0.0/db1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:.
Now we are set for installation login through Oracle user and install software:
https://18ctestdb:5500/em
Configuring Listener:
We have successfully configured listener and its up and running, now create the database, using DBCA:
