Connect as root and switch to <locked_user_account> and execute the below steps:
me@mordor:~> sudo /sbin/pam_tally --user frodo
User frodo (500) has 32
me@mordor:~> sudo /sbin/pam_tally --user frodo --reset
User frodo (500) had 32
me@mordor:~> sudo /sbin/pam_tally --user frodo
User frodo (500) has 0linuxamd64_12102_database_1of2.zip linuxamd64_12102_database_2of2.zip
su - root
<IP-address> <fully-qualified-machine-name> <machine-name>
127.0.0.1 oel7 oel7.dbaora.com localhost.localdomain localhost
hostnamectl set-hostname oel7.dbaora.com --static
#groups for database management 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
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
passwd oracle
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \
compat-libcap1 \
compat-libstdc++-33 \
gcc \
gcc-c++ \
glibc \
glibc-devel \
ksh \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
libXi \
libXtst \
make \
sysstat
binutils-2.23.52.0.1-55.el7(x86_64) compat-libcap1-1.10-7.el7(x86_64) compat-libstdc++-33-3.2.3-72.el7(x86_64) gcc-4.8.5-4.el7(x86_64) gcc-c++-4.8.5-4.el7(x86_64) glibc-2.17-106.0.1.el7_2.8(x86_64) glibc-devel-2.17-106.0.1.el7_2.8(x86_64) package ksh is not installed libaio-0.3.109-13.el7(x86_64) libaio-devel-0.3.109-13.el7(x86_64) is not installed libgcc-4.8.5-4.el7(x86_64) libstdc++-4.8.5-4.el7(x86_64) libstdc++-devel-4.8.5-4.el7(x86_64) libXi-1.7.4-2.el7(x86_64) libXtst-1.2.2-2.1.el7(x86_64) make-3.82-21.el7(x86_64) sysstat-10.1.5-7.el7(x86_64)
rpm -Uvh libaio-devel*.x86_64.rpm rpm -Uvh ksh*.x86_64.rpm
yum install libaio-devel*.x86_64 yum install ksh*.x86_64
# kernel parameters for 12gR1 installation
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
kernel.panic_on_oops=1
/sbin/sysctl -p
# shell limits for users oracle 12gR1 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768
SELINUX=enforcing
setenforce 1
service iptables stop chkconfig iptables off
# Oracle Settings
export TMP=/tmp
export ORACLE_HOSTNAME=oel7.dbaora.com
export ORACLE_UNQNAME=ORA12C
export ORACLE_BASE=/ora01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_SID=ORA12C
PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
alias cdob='cd $ORACLE_BASE'
alias cdoh='cd $ORACLE_HOME'
alias tns='cd $ORACLE_HOME/network/admin'
alias envo='env | grep ORACLE'
umask 022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -u 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
envo
mkdir -p /ora01/app/oracle/product/12.1.0/db_1 chown oracle:oinstall -R /ora01
systemctl mask tmp.mount
su - oracle --unizp software it will create directory "database" --where you can find installation software unzip linuxamd64_12102_database_1of2.zip unzip linuxamd64_12102_database_2of2.zip --I defined 4 aliases in .bash_profile of user oracle to make --administration easier :) [oracle@oel7 ~]$ alias envo cdob cdoh tns alias envo='env | grep ORACLE' alias cdob='cd $ORACLE_BASE' alias cdoh='cd $ORACLE_HOME' alias tns='cd $ORACLE_HOME/network/admin' --run alias command envo to display environment settings envo ORACLE_UNQNAME=ORA12C ORACLE_SID=ORA12C ORACLE_BASE=/ora01/app/oracle ORACLE_HOSTNAME=oel7.dbaora.com ORACLE_HOME=/ora01/app/oracle/product/12.1.0/db_1 --run alias command cdob and cdoh --to check ORACLE_BASE, ORACLE_HOME [oracle@oel7 ~]$ cdob [oracle@oel7 oracle]$ pwd /ora01/app/oracle [oracle@oel7 db_1]$ cdoh [oracle@oel7 db_1]$ pwd /ora01/app/oracle/product/12.1.0/db_1
cd /home/oracle/database/response [oracle@oel7 response]$ ls dbca.rsp db_install.rsp netca.rsp
[oracle@oel7 response]$ cp db_install.rsp db_install.rsp.bck
-------------------------------------------- -- force to install only database software -------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY -------------------------------------------- -- set your hostname -------------------------------------------- ORACLE_HOSTNAME=oel7.dbaora.com -------------------------------------------- -- set unix group for oracle inventory -------------------------------------------- UNIX_GROUP_NAME=oinstall -------------------------------------------- -- set directory for oracle inventory -------------------------------------------- INVENTORY_LOCATION=/ora01/app/oraInventory -------------------------------------------- -- set oracle home for binaries -------------------------------------------- ORACLE_HOME=/ora01/app/oracle/product/12.1.0/db_1 -------------------------------------------- -- set oracle home for binaries -------------------------------------------- ORACLE_BASE=/ora01/app/oracle -------------------------------------------- -- set version of binaries to install -- EE - enterprise edition -------------------------------------------- oracle.install.db.InstallEdition=EE -------------------------------------------- -- specify extra groups for database management -------------------------------------------- oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper oracle.install.db.BACKUPDBA_GROUP=backupdba oracle.install.db.DGDBA_GROUP=dgdba oracle.install.db.KMDBA_GROUP=kmdba
cd /home/oracle/database ./runInstaller -silent \ -responseFile /home/oracle/database/response/db_install.rsp \ DECLINE_SECURITY_UPDATES=true \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
[oracle@oel7 database]$ ./runInstaller -silent \ > -responseFile /home/oracle/database/response/db_install.rsp \ > DECLINE_SECURITY_UPDATES=true \ > SECURITY_UPDATES_VIA_MYORACLESUPPORT=false Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 47410 MB Passed Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-07_04-14-20PM. Please wait ... [oracle@oel7 database]$ You can find the log of this install session at: /ora01/app/oraInventory/logs/installActions2016-10-07_04-14-20PM.log The installation of Oracle Database 12c was successful. Please check '/ora01/app/oraInventory/logs/silentInstall2016-10-07_04-14-20PM.log' for more details. As a root user, execute the following script(s): 1. /ora01/app/oraInventory/orainstRoot.sh 2. /ora01/app/oracle/product/12.1.0/db_1/root.sh Successfully Setup Software.
[root@oel7 /]# /ora01/app/oraInventory/orainstRoot.sh /ora01/app/oracle/product/12.1.0/db_1/root.sh
[oracle@oel7 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 16:21:13 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL>
cd /home/oracle/database/response cp netca.rsp netca.rsp.bck
netca -silent -responseFile /home/oracle/database/response/netca.rsp
[oracle@oel7 response]$ netca -silent \
-responseFile /home/oracle/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/ora01/app/oracle/product/12.1.0/db_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@oel7 response]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 16:40:41 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=oel7.dbaora.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 07-OCT-2016 16:35:22 Uptime 0 days 0 hr. 5 min. 18 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /ora01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora Listener Log File /ora01/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully
mkdir /ora01/app/oracle/oradata mkdir /ora01/app/oracle/flash_recovery_area
cd /home/oracle/database/response cp dbca.rsp dbca.rsp.bck vi dbca.rsp
-------------------------------------------- -- global database name -------------------------------------------- GDBNAME = "ORA12C.dbaora.com" -------------------------------------------- -- instance database name -------------------------------------------- SID = "ORA12C" CREATEASCONTAINERDATABASE = true NUMBEROFPDBS = 1 PDBNAME = PORA12C1 PDBADMINPASSWORD = "oracle" -------------------------------------------- -- template name used to create database -------------------------------------------- TEMPLATENAME = "General_Purpose.dbc" -------------------------------------------- -- password for user sys -------------------------------------------- SYSPASSWORD = "oracle" -------------------------------------------- -- password for user system -------------------------------------------- SYSTEMPASSWORD = "oracle" -------------------------------------------- -- configure dbexpress with port 5500 -------------------------------------------- EMCONFIGURATION = "DBEXPRESS" EMEXPRESSPORT = "5500" -------------------------------------------- -- password for dbsnmp user -------------------------------------------- DBSNMPPASSWORD = "oracle" -------------------------------------------- -- default directory for oracle database datafiles -------------------------------------------- DATAFILEDESTINATION = /ora01/app/oracle/oradata -------------------------------------------- -- default directory for flashback data -------------------------------------------- RECOVERYAREADESTINATION = /ora01/app/oracle/flash_recovery_area -------------------------------------------- -- storage used for database installation -- FS - OS filesystem -------------------------------------------- STORAGETYPE = FS -------------------------------------------- -- database character set -------------------------------------------- CHARACTERSET = "AL32UTF8" -------------------------------------------- -- national database character set -------------------------------------------- NATIONALCHARACTERSET = "AL16UTF16" -------------------------------------------- -- listener name to register database to -------------------------------------------- LISTENERS = "LISTENER" -------------------------------------------- -- force to install sample schemas on the database -------------------------------------------- SAMPLESCHEMA=TRUE -------------------------------------------- --specify database type --has influence on some instance parameters -------------------------------------------- DATABASETYPE = "OLTP" -------------------------------------------- -- force to use autmatic mamory management -------------------------------------------- AUTOMATICMEMORYMANAGEMENT = "TRUE" -------------------------------------------- -- defines size of memory used by the database -------------------------------------------- TOTALMEMORY = "1024"
dbca -silent -responseFile /home/oracle/database/response/dbca.rsp
[oracle@oel7 ~]$ dbca -silent -responseFile /home/oracle/install/database/response/dbca.rsp Copying database files 1% complete 2% complete 27% complete Creating and starting Oracle instance 29% complete 32% complete 33% complete 34% complete 38% complete 42% complete 43% complete 45% complete Completing Database Creation 48% complete 51% complete 53% complete 62% complete 64% complete 72% complete Creating Pluggable Databases 78% complete 100% complete Look at the log file "/ora01/app/oracle/cfgtoollogs/dbca/ORA12C/ORA12C.log" for further details.
[oracle@oel7 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 17:41:35 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show parameter db_name NAME TYPE VALUE --------- ----------- ---------- db_name string ORA12C SQL> alter session set container=PORA12C1; Session altered. SQL> show con_id CON_ID ------------------------------ 3 SQL> show con_name CON_NAME ------------------------------ PORA12C1
SQL> select DBMS_XDB_CONFIG.GETHTTPSPORT
from dual;
GETHTTPSPORT
------------
5500
ORA12C:/ora01/app/oracle/product/12.1.0/db_1:Y
1
2
| username=MyAdminUserNamepassword=MyAdminPassword |