Oracle 11g R2 Installation and configuration

--=========== 0:xserver Preparation

Install Xserver, configure Xshell
--xming,xmanager,vcxsrv

--=========== 1: Disk Partitioning and mounting

cd/etc/yum.repos.d/
# # SCP Ol6.repo root:10.198.15.105:/etc/yum.repos.d/
RM Public-yum-ol6.repo
Df-lh
Lsblk
Lvm
Pv
Pvcreate/dev/sdb
Pvdisplay
Vgcreate Vg_oracle/dev/sdb
Vgdisplay
Lvdisplay
#vgdispaly的Total PE
Lvcreate-l 127999-n Oracle Vg_oracle
Lvdisplay
Mkfs.ext4/dev/vg_oracle/oracle
Mkdir/oracle

# # Get UUID
Ls-l/dev/disk/by-uuid/
# # or
Blkid/dev/vg_oracle/oracle

# # Mount UUID
Vi/etc/fstab

# # Add a row
Uuid=a75d1657-2609-494b-91e6-8d908a5218fa/oracle EXT4 Defaults 1 2

# # Check under
Mount-a
Df-lh

--=========== 2: Pre-installation

Yum List Oracle
Yum Search Oracle
Yum List oracle-rdbms-server-11gr2-preinstall.x86_64
Yum Install oracle-rdbms-server-11gr2-preinstall.x86_64

--=========== 3: Configuration

passwd Oracle
Chown-r oracle:oinstall/oracle

# # Modify Host Name
Vi/etc/sysconfig/network
Reboot

# # Add all ADG servers to parse
Vi/etc/hosts

--=========== 4: Installation

# # Install with Oracle User login
SSH [email protected]

cd/oracle/
Unzip P13390677_112040_linux-x86-64_1of7.zip
Unzip P13390677_112040_linux-x86-64_2of7.zip
CD database/
./runinstaller

# # Switch to ROOT to execute the script
Su-
cd/oracle/orainventory/
./orainstroot.sh
cd/oracle/product/11.2.0/
./root.sh

# # Switch back to Oracle execution
Exit
CD ~

# # Modify. bash_profile file
VI. bash_profile
# Oracle Settings
Oracle_base=/oracle; Export Oracle_base
Oracle_home= $ORACLE _base/product/11.2.0; Export Oracle_home
oracle_sid=db11g; Export Oracle_sid
Path= $ORACLE _home/bin: $PATH; Export PATH

source. bash_profile

# # Close SELinux
Getenforce
Setenforce 0
# # Set SELinux to Disabled
Vi/etc/selinux/config

--=========== 5: Building a library

Mkdir/oracle/archive
Dbca

--=========== 6: Configuration

1) NETCA Add monitoring

2) Configuring the archive directory Log_archive_dest_1

View Archive file path location
Show Parameter log_archive_dest_1
Two shut down the database
ALTER DATABASE chenkpoint;
Shutdown immediate
Three-mount Database
Start mount
Four Modify the archive path
Alter system set log_archive_dest_1= ' location=/oracle/archive ';
Five startup databases
ALTER DATABASE open;
Six check to see if it takes effect
Select Archiver from V$instance;
alter system switch logfile;
Ls/oracle/archive

3) Configure delay segment creation off
alter system set DEFERRED_SEGMENT_CREATION=FALSE;

4) Change Password default policy
Alter profile default limit Password_life_time Unlimited

--=========== 7: Test port

# # Test 1521 and 22 ports available
Yum-y Install Telnet
Telnet 10.1.1.74 1521
SSH [email protected]

--=========== 8: Other configurations

1) Modify/etc/oratab, this file is used by Oracle utilities, such as Dbstart, Dbshut
$ORACLE _sid: $ORACLE _home:<n| Y>
Sicilybak:/oracle/product/11.2.0:y

2) The Oracle EM agent relies on/etc/oratab, as well as the listener created by NETCA.

Oracle 11g R2 installation and configuration