Installing the Oracle database silently on Linux

Installing the Oracle database silently on Linux

[Email protected] ~]# cat/etc/oracle-release

Oracle Linux Server Release 7.0

[Email protected] ~]# cat/etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

192.168.1.7 THDLDB01

[[Email protected] ~] #yum Install oracle-rdbms-server-12cr1*-y

[[Email protected] ~] #yum Install readline*devel*-y

[Email protected] ~]# cd/opt && wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.42.tar.gz && Tar zxvf rlwrap-0.42.tar.gz && cd rlwrap-0.42 &&./configure && make && make install

[Email protected] rlwrap-0.42]# rlwrap-v

Rlwrap 0.42

Cat/etc/sysctl.conf

# Oracle-rdbms-server-12cr1-preinstall setting for Fs.file-max are 6815744

Fs.file-max = 6815744

# Oracle-rdbms-server-12cr1-preinstall setting for Kernel.sem is ' 250 32000 100 128 '

Kernel.sem = 250 32000 100 128

# Oracle-rdbms-server-12cr1-preinstall setting for Kernel.shmmni are 4096

Kernel.shmmni = 4096

# Oracle-rdbms-server-12cr1-preinstall setting for Kernel.shmall are 1073741824 on x86_64

Kernel.shmall = 1073741824

# Oracle-rdbms-server-12cr1-preinstall setting for Kernel.shmmax are 4398046511104 on x86_64

Kernel.shmmax = 4398046511104

# Oracle-rdbms-server-12cr1-preinstall setting for Kernel.panic_on_oops is 1 per orabug 19642132

Kernel.panic_on_oops = 1

# Oracle-rdbms-server-12cr1-preinstall setting for Net.core.rmem_default are 262144

Net.core.rmem_default = 262144

# Oracle-rdbms-server-12cr1-preinstall setting for Net.core.rmem_max are 4194304

Net.core.rmem_max = 4194304

# Oracle-rdbms-server-12cr1-preinstall setting for Net.core.wmem_default are 262144

Net.core.wmem_default = 262144

# Oracle-rdbms-server-12cr1-preinstall setting for Net.core.wmem_max are 1048576

Net.core.wmem_max = 1048576

# Oracle-rdbms-server-12cr1-preinstall setting for FS.AIO-MAX-NR are 1048576

FS.AIO-MAX-NR = 1048576

# Oracle-rdbms-server-12cr1-preinstall setting for Net.ipv4.ip_local_port_range are 9000 65500

Net.ipv4.ip_local_port_range = 9000 65500

[[Email protected] ~] #groupadd-G 54323 oper

[[Email protected] ~] #groupadd-G 54324 backupdba

[[Email protected] ~] #groupadd-G 54325 dgdba

[[Email protected] ~] #groupadd-G 54326 kmdba

[[Email protected] ~] #usermod-G oinstall-g dba,oper,backupdba,dgdba,kmdba Oracle

[[Email protected] ~] #mkdir-P/u01/app/oracle

[[Email protected] ~] #chown-R oracle.oinstall/u01

[Email protected] opt]# Cat/etc/orainst.loc

Inventory_loc=/u01/app/orainventory

Inst_group=oinstall

[[Email protected] ~] #chown oracle:oinstall/etc/orainst.loc

[[Email protected] ~] #chmod 664/etc/orainst.loc

[Email protected] ~]# su-oracle

ORACLE_SID=THDLDB; Export Oracle_sid

Oracle_base=/u01/app/oracle;export Oracle_base

Oracle_home= $ORACLE _base/product/12.1.0.2/dbhome_1; Export Oracle_home

Path= $ORACLE _home/bin: $PATH; Export PATH

Ld_library_path= $ORACLE _home/lib;export Ld_library_path

Stty Erase ^h

Alias sqlplus= "Rlwrap Sqlplus"

Alias rman= "Rlwrap Rman"

Nls_lang=american_america. UTF8; Export Nls_lang

#DISPLAY =192.168.0.4:0.0; Export DISPLAY

[email protected] ~]$ LL

-rw-r--r--1 Oracle oinstall 1673544724 Feb 03:55 linuxamd64_12102_database_1of2.zip

-rw-r--r--1 Oracle oinstall 1014530602 Feb 03:54 linuxamd64_12102_database_2of2.zip

[Email protected] ~]$ Unzip Linuxamd64_12102_database_1of2.zip

[Email protected] ~]$ Unzip Linuxamd64_12102_database_2of2.zip

[Email protected] ~]$ CD database/

[[email protected] database]$ ls

Install response rpm Runinstaller Sshsetup stage welcome.html

Configuring and installing Oracle Software

Modify the configuration template (DB_INSTALL.RSP) with the following changes:

Oracle.install.option=install_db_swonly

Oracle_hostname=thdldb01

Unix_group_name=oinstall

Inventory_location=/home/oracle/database/stage/products.xml

Oracle_home=/u01/app/oracle/product/12.1.0.2/dbhome_1

Oracle_base=/u01/app/oracle

Oracle.install.db.installedition=ee

Oracle.install.db.dba_group=dba

Oracle.install.db.oper_group=oper

Oracle.install.db.backupdba_group=backupdba

Oracle.install.db.dgdba_group=dgdba

Decline_security_updates=true

The other options are default.

[Email protected] database]$./runinstaller-ignoresysprereqs-force-silent-responsefile/home/oracle/db_ Install.rsp

Starting Oracle Universal Installer ...

Checking Temp space:must be greater than MB. Actual 7948 MB Passed

Checking swap space:must be greater than MB. Actual 7999 MB Passed

Preparing to launch Oracle Universal Installer from/tmp/orainstall2015-02-26_04-13-23am. Please wait ... [[Email protected] database]$ You can find the log of this install session at:

/u01/app/orainventory/logs/installactions2015-02-26_04-13-23am.log

The installation of Oracle Database 12c was successful.

Please check the '/u01/app/orainventory/logs/silentinstall2015-02-26_04-13-23am.log ' for more details.

As a root user, execute the following script (s):

1./u01/app/oracle/product/12.1.0.2/dbhome_1/root.sh

Successfully Setup software.

@ Configure and CREATE DATABASE Thdldb

Modify the default template (DBCA.RSP) and change the following:

Gdbname = "Thdldb"

SID = "Thdldb"

Syspassword = "JIESHI11GR2"

Systempassword = "JIESHI11GR2"

Dbsnmppassword = "JIESHI11GR2"

CHARACTERSET = "Al32utf8"

nationalcharacterset= "UTF8"

The other options are default.

[Email protected] ~]$ DBCA-SILENT-RESPONSEFILE/HOME/ORACLE/DBCA.RSP

Cleaning up failed steps

5% Complete

Copying Database files

7% Complete

9% Complete

16% Complete

23% Complete

30% Complete

41% Complete

Creating and Starting Oracle instance

43% Complete

48% Complete

53% Complete

57% Complete

58% Complete

59% Complete

62% Complete

64% Complete

Completing Database Creation

68% Complete

71% Complete

75% Complete

85% Complete

96% Complete

100% Complete

Look at the log file '/u01/app/oracle/cfgtoollogs/dbca/thdldb/thdldb0.log ' for further details.

[Email protected] ~]$ Ps-ef |grep Ora_

Oracle 35108 1 0 05:05? 00:00:00 Ora_pmon_thdldb

Oracle 35110 1 0 05:05? 00:00:00 Ora_psp0_thdldb

Oracle 35112 1 1 05:05? 00:00:00 Ora_vktm_thdldb

Oracle 35116 1 0 05:05? 00:00:00 Ora_gen0_thdldb

Oracle 35118 1 0 05:05? 00:00:00 Ora_mman_thdldb

Oracle 35122 1 0 05:05? 00:00:00 Ora_diag_thdldb

Oracle 35124 1 0 05:05? 00:00:00 Ora_dbrm_thdldb

Oracle 35126 1 0 05:05? 00:00:00 Ora_vkrm_thdldb

Oracle 35128 1 0 05:05? 00:00:00 Ora_dia0_thdldb

Oracle 35130 1 0 05:05? 00:00:00 Ora_dbw0_thdldb

Oracle 35132 1 0 05:05? 00:00:00 Ora_lgwr_thdldb

Oracle 35134 1 0 05:05? 00:00:00 Ora_ckpt_thdldb

Oracle 35136 1 0 05:05? 00:00:00 Ora_lg00_thdldb

Oracle 35138 1 0 05:05? 00:00:00 Ora_smon_thdldb

Oracle 35140 1 0 05:05? 00:00:00 Ora_lg01_thdldb

Oracle 35142 1 0 05:05? 00:00:00 Ora_reco_thdldb

Oracle 35144 1 0 05:05? 00:00:00 Ora_lreg_thdldb

Oracle 35146 1 0 05:05? 00:00:00 Ora_pxmn_thdldb

Oracle 35148 1 1 05:05? 00:00:01 Ora_mmon_thdldb

Oracle 35150 1 0 05:05? 00:00:00 Ora_mmnl_thdldb

Oracle 35152 1 0 05:05? 00:00:00 Ora_d000_thdldb

Oracle 35154 1 0 05:05? 00:00:00 Ora_s000_thdldb

Oracle 35166 1 0 05:05? 00:00:00 Ora_tmon_thdldb

Oracle 35168 1 0 05:05? 00:00:00 Ora_tt00_thdldb

Oracle 35170 1 0 05:05? 00:00:00 Ora_smco_thdldb

Oracle 35172 1 0 05:05? 00:00:00 Ora_w000_thdldb

Oracle 35174 1 0 05:05? 00:00:00 Ora_w001_thdldb

Oracle 35176 1 0 05:05? 00:00:00 Ora_aqpc_thdldb

Oracle 35178 1 0 05:05? 00:00:00 Ora_cjq0_thdldb

Oracle 35182 1 0 05:05? 00:00:00 Ora_p000_thdldb

Oracle 35184 1 0 05:05? 00:00:00 Ora_p001_thdldb

Oracle 35186 1 0 05:05? 00:00:00 Ora_p002_thdldb

Oracle 35188 1 0 05:05? 00:00:00 Ora_p003_thdldb

Oracle 35190 1 0 05:05? 00:00:00 Ora_p004_thdldb

Oracle 35192 1 0 05:05? 00:00:00 Ora_p005_thdldb

Oracle 35194 1 0 05:05? 00:00:00 Ora_p006_thdldb

Oracle 35196 1 0 05:05? 00:00:00 Ora_p007_thdldb

Oracle 35200 1 0 05:05? 00:00:00 Ora_p008_thdldb

Oracle 35202 1 0 05:05? 00:00:00 Ora_p009_thdldb

Oracle 35204 1 0 05:05? 00:00:00 Ora_p00a_thdldb

Oracle 35206 1 0 05:05? 00:00:00 Ora_p00b_thdldb

Oracle 35208 1 0 05:05? 00:00:00 Ora_p00c_thdldb

Oracle 35210 1 0 05:05? 00:00:00 Ora_p00d_thdldb

Oracle 35212 1 0 05:05? 00:00:00 Ora_p00e_thdldb

Oracle 35214 1 0 05:05? 00:00:00 Ora_p00f_thdldb

Oracle 35356 1 0 05:06? 00:00:00 Ora_qm02_thdldb

Oracle 35358 1 0 05:06? 00:00:00 Ora_qm03_thdldb

Oracle 35360 1 0 05:06? 00:00:00 Ora_q002_thdldb

Oracle 35362 1 0 05:06? 00:00:00 Ora_q003_thdldb

Oracle 35369 30417 0 05:07 pts/4 00:00:00 grep--color=auto Ora_

Create and configure listeners (use default modulo to NETCA.RSP)

[Email protected] ~]$ NETCA-SILENT-RESPONSEFILE/HOME/ORACLE/NETCA.RSP

Parsing command line arguments:

Parameter "Silent" = True

Parameter "Responsefile" =/HOME/ORACLE/NETCA.RSP

Done parsing command line arguments.

Oracle Net Services Configuration:

Profile configuration complete.

Oracle Net Listener Startup:

Running Listener Control:

/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/lsnrctl Start LISTENER

Listener Control complete.

Listener started successfully.

Listener configuration complete.

Oracle Net Services Configuration successful. The exit code is 0

[Email protected] ~]$ Ps-ef |grep LIS

Oracle 35409 1 0 05:09? 00:00:00/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr Listener-inherit

Oracle 35418 30417 0 05:09 pts/4 00:00:00 grep--color=auto LIS

[Email protected] ~]$ Netstat-an |grep 1521

TCP 0 0 192.168.1.7:61248 192.168.1.7:1521 established

TCP6 0 0::: 1521:::* LISTEN

TCP6 0 0 192.168.1.7:1521 192.168.1.7:61195 time_wait

TCP6 0 0 192.168.1.7:1521 192.168.1.7:61248 established

UNIX 2 [ACC] STREAM LISTENING 134954/var/tmp/.oracle/sextproc1521

Installing the Oracle database silently on Linux