Install CentOS in VMware and install Oracle Database (Personal learning)

Open VMware

Select Install Later

Custom Installation

The niche is a 64-bit CentOS installation.

Set the name and installation location for the virtual machine

Set up the virtual machine to hit the processor and allocate memory (ORACLE12G I recommend more than 2G of memory)

Network type select host mode only

Create a new virtual disk as recommended

The disk size is set to 40G, not too small, and there will be errors. Specify Disk File path

Select your custom hardware to mount the CentOS ISO image file on

Start the virtual machine and go to the CentOS installation interface

Skip Detection

Select English

Keyboard format for English

Select Yes to clear the data

Click Configure Network

Set the system eth0 to refer to your own host (ipconfig)

Shanghai time

Set Root password

Will review. Choose the

Delete Rebuild

Add/Boot

Add a Swap partition

Remaining space to root/

Default

Choose some of the packages you want to install!

Development tools Category

A long wait

After installation, restart

Press Guide to

Do not set user

Remove the kdump. Set VMnet1 under Network settings (take a closer look)

Uploading an Oracle installation package

IP is set to static

[Email protected] ~]# Vi/etc/sysconfig/network-scripts/ifcfg-eth0

Device=eth0

Type=ethernet

Uuid=a479bd38-0b09-4afb-9cb5-2932caf4a5ac

Onboot=yes

Nm_controlled=yes

Bootproto=static

hwaddr=00:0c:29:f9:14:8a

ipaddr=192.168.10.88

Prefix=24

gateway=192.168.10.1

Defroute=yes

Ipv4_failure_fatal=yes

Ipv6init=no

Name= "System eth0"

Stop IPv6 service, disable IPv6 boot

[[Email protected]t ~]# Service Ip6tables stop

[Email protected] ~]# Chkconfig ip6tables off

[Email protected] ~]# service network restart

Set the host name to OracleDB

[Email protected] ~]# vi/etc/sysconfig/network

Networking=yes

Hostname=oracledb

gateway=192.168.10.1

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

127.0.0.1 localhost oracledb localhost4 localhost4.localdomain4

:: 1 localhost oracledb localhost6 localhost6.localdomain6

192.168.10.88 OracleDB

[email protected] ~]# reboot

Check for dependent packages

Binutils-2.20.51.0.2-5.11.el6 (x86_64)

Compat-libcap1-1.10-1 (x86_64)

Compat-libstdc++-33-3.2.3-69.el6 (x86_64)

Gcc-4.4.4-13.el6 (x86_64)

Gcc-c++-4.4.4-13.el6 (x86_64)

Glibc-2.12-1.7.el6 (x86_64)

Glibc-devel-2.12-1.7.el6 (x86_64)

Ksh

Libgcc-4.4.4-13.el6 (x86_64)

Libstdc++-4.4.4-13.el6 (x86_64)

Libstdc++-devel-4.4.4-13.el6 (x86_64)

Libaio-0.3.107-10.el6 (x86_64)

Libaio-devel-0.3.107-10.el6 (x86_64)

Make-3.81-19.el6

Sysstat-9.0.4-11.el6 (x86_64)

Check for Presence

[Email protected] ~]# Rpm-qa binutils*

Installation

Mount CentOS Image

[email protected] ~]# mount

/dev/sda3 on/type ext4 (rw)

Proc On/proc type proc (rw)

Sysfs On/sys type SYSFS (rw)

Devpts on/dev/pts type devpts (rw,gid=5,mode=620)

Tmpfs on/dev/shm type Tmpfs (rw,rootcontext= "System_u:object_r:tmpfs_t:s0")

/DEV/SDA1 on/boot type EXT4 (rw)

None On/proc/sys/fs/binfmt_misc type Binfmt_misc (rw)

Gvfs-fuse-daemon ON/ROOT/.GVFS type Fuse.gvfs-fuse-daemon (Rw,nosuid,nodev)

/dev/sr0 on/media/centos_6.5_final

[Email protected] ~]# cd/media/centos_6.5_final/packages/

[[email protected] packages]# ls compat-lib*

compat-libcap1-1.10-1.i686.rpm compat-libgfortran-41-4.1.2-39.el6.i686.rpm compat-libstdc++-33-3.2.3-69.el6.x86_ 64.rpm

compat-libcap1-1.10-1.x86_64.rpm compat-libgfortran-41-4.1.2-39.el6.x86_64.rpm compat-libtermcap-2.0.8-49.el6.i686.rpm

compat-libf2c-34-3.4.6-19.el6.i686.rpm compat-libstdc++-296-2.96-144.el6.i686.rpm compat-libtermcap-2.0.8-49.el6.x86_64.rpm

compat-libf2c-34-3.4.6-19.el6.x86_64.rpm compat-libstdc++-33-3.2.3-69.el6.i686.rpm

[Email protected] packages]# RPM-IVH compat-libcap1-1.10-1.x86_64.rpm

Create users and Groups

[Email protected] ~]# Groupadd Oinstall

[[email protected] ~]# Groupadd DBA

[Email protected] ~]# useradd-g oinstall-g dba Oracle

[Email protected] ~]# passwd Oracle

Create a Directory

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

You have mail in/var/spool/mail/root

[Email protected] ~]# chown-r oracle:oinstall/u01

[Email protected] ~]# chmod-r 775/u01

modifying kernel parameters

[Email protected] ~]# vi/etc/sysctl.conf

# Controls The maximum shared segment size, in bytes

#kernel. Shmmax = 68719476736

# Controls The maximum number of shared memory segments, in pages

#kernel. Shmall = 4294967296

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 536870912

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Modify System Resource Limits

[Email protected] ~]# vi/etc/security/limits.conf

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

[Email protected] ~]# Vi/etc/pam.d/login

Session Required Pam_limits.so

[Email protected] ~]# Vi/etc/profile

if [$USER = "Oracle"]; Then

if [$SHELL = "/bin/ksh"]; Then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

Shutting down the firewall

[[Email protected] ~]# service iptables stop

Iptables:setting chains to Policy Accept:filter [OK]

iptables:flushing firewall rules: [OK]

iptables:unloading modules: [OK]

[Email protected] ~]# chkconfig iptables off

Turn off SELinux

[Email protected] ~]#/usr/sbin/sestatus–v

[Email protected] ~]# Vi/etc/selinux/config

Selinux=disabled

Setting environment variables

[Email protected] ~]# su-oracle

[[Email protected] ~]$ CD

[Email protected] ~]$ Vi. bash_profile

Umask 022

Oracle_bash=/u01/app/oracle

Oracle_home= $ORACLE _bash/product/11.2.0/db_1

Oracle_sid=oracledb

Path= $PATH: $ORACLE _home/bin

Ld_library_path= $ORACLE _home/lib:/usr/lib

Export PATH oracle_bash oracle_home oracle_sid Ld_library_path

[[email protected] ~]$ source. bash_profile

[email protected] ~]# CP linux.x64_11gr2_database_*/home/oracle/

[Email protected] ~]# chown Oracle:oinstall/home/oracle/^cnux.x64_11gr2_database_2of2.zip

Switch to graphical interface installation!

[Email protected] ~]$ Unzip Linux.x64_11gR2_database_1of2.zip

[Email protected] ~]$ Unzip Linux.x64_11gR2_database_2of2.zip

[[email protected] ~]$ ls

[Email protected] ~]$ CD database/

[[email protected] database]$ ls

Doc Install response rpm Runinstaller Sshsetup stage welcome.html

[Email protected] database]$./Runinstaller

[Email protected] ~]# sh/u01/app/orainventory/orainstroot.sh

[Email protected] ~]# sh/u01/app/oracle/product/11.2.0/db_1/root.sh

Create a listening service (acting as an Oracle Server for other Oracle clients to connect to this Oracle server)

Start the database, and listen

1. #su-oracle Switch to an Oracle user and switch to its environment

2. $lsnrctl Status View monitoring and database state

3. Start monitoring $lsnrctl start

4. $sqlplus/as sysdba into the sqlplus as a DBA

5.sql>startup Start db

Configure the local Network service name (acting as an Oracle client, connecting to another Oracle server)

did not pass. Exit

Modify the/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora. Modify the hostname to oracledb.

Restart the entire virtual machine.

Go back. Start the monitoring and start the database. Go to the appropriate step and then execute sql> alter system register;

User Name System Password Oracle

Unlock scott User, password is Tigger

The database was successfully installed!

This database installed the weekend two genius installation success, during the encounter a variety of problems such as disk space, Kdump space, set permissions and other issues, but happily finally installed successfully. Finally, you can start learning Oracle!

Install CentOS in VMware and install Oracle Database (Personal learning)