Connecting to The Portable Database (Container DB/ PDBs) in 12c,18c

Connecting to Container Database:

As with introduction of Portable databases, during installation you are given option with simple installation of the version  or you can opt for Container Database, once you opt for container DB option, it will ask for portable database name:

Once installation/creation of database is completed, login to root container is as simple we login to normal database. i.e

[oracle@18ctestdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Tue Mar 13 00:55:06 2018

Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.1.0.0.0

SQL>

SQL> sho user

USER is "SYS"

SQL> sho con_name

CON_NAME

------------------------------

CDB$ROOT

SQL>

But Logging in to PDBS is not that simple,  as PDBs will be accessible through some create net service:

Let have a look at tnsnames.ora file:

No Service is created against Portable container database, so we should create the service through netca:

Since service is created now. lets check the tnsnames.ora file :

As now we have services configured for PDB let access the PDB through that service:

If you don't have service configured we can access the container by set container clause:

Oracle 18c Installation (binaries and Database) on Linux (not an official release, only for Testing purpose)

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:

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: