oracle11g仅主机安装（自定义建库后自动配置监听）-详细笔记总结资源-CSDN文库

oracle11g

运维

需积分: 5 195 浏览量 2023-06-30 22:09:08 上传评论收藏 3.95MB DOCX 举报

资源推荐

资源详情

资源评论

安装 oracle11g，自定义建库后自动配置监听

配置本地 yum 源：

[root@oracledb ~]# cat /etc/yum.repos.d/rhel-debuginfo.repo

[rhel-debuginfo]

name=Red Hat Enterprise Linux $releasever - $basearch - Debug

baseurl=file:///mnt/Server

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

[root@oracledb ~]# yum repolist

…………

repolist: 3,285

[root@oracledb ~]# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

192.168.1.6 oracledb

[root@oracledb ~]# /etc/init.d/sendmail stop

[root@oracledb ~]# chkconfig sendmail off

[root@oracledb ~]# free //检查内存、交换分区、存储

total used free shared buffers cached

Mem: 2058780 696884 1361896 0 38944 416740

-/+ buffers/cache: 241200 1817580

Swap: 5116660 0 5116660

[root@oracledb ~]# vim /etc/fstab

……………………//最下面添加，修改启动项

shmfs /dev/shm tmpfs size=10g 0

[root@oracledb ~]# df -h //检查 shm 磁盘、/tmp 磁盘空间、/u01 磁盘空间

Filesystem Size Used Avail Use% Mounted on

/dev/sda2 76G 4.4G 68G 7% /

/dev/sda6 203G 188M 192G 1% /u01

/dev/sda3 7.6G 147M 7.1G 2% /tmp

/dev/sda1 190M 12M 169M 7% /boot

tmpfs 1006M 0 1006M 0% /dev/shm

/dev/sr0 3.9G 3.9G 0 100% /mnt

[root@oracledb ~]# uname -m //检查版本

x86_64

检查各种安装包：

[root@oracledb ~]# rpm -qa |grep ssh

openssh-4.3p2-82.el5

openssh-askpass-4.3p2-82.el5

openssh-clients-4.3p2-82.el5

openssh-server-4.3p2-82.el5

[root@oracledb ~]# rpm -qa |grep binutils

binutils220-2.20.51.0.2-5.29.el5

binutils-2.17.50.0.6-20.el5

[root@oracledb ~]# rpm -qa |grep compat-libstdc

compat-libstdc++-33-3.2.3-61

compat-libstdc++-296-2.96-138

compat-libstdc++-33-3.2.3-61

[root@oracledb ~]# rpm -qa |grep elfutils

elfutils-libelf-0.137-3.el5

elfutils-0.137-3.el5

elfutils-libs-0.137-3.el5

elfutils-libelf-devel-0.137-3.el5

elfutils-libelf-devel-static-0.137-3.el5

[root@oracledb ~]# rpm -qa |grep gcc

gcc-4.1.2-52.el5

gcc-java-4.1.2-52.el5

gcc44-gfortran-4.4.6-3.el5.1

compat-gcc-34-c++-3.4.6-4.1

gcc44-4.4.6-3.el5.1

gcc44-c++-4.4.6-3.el5.1

gcc-gfortran-4.1.2-52.el5

libgcc-4.1.2-52.el5

compat-gcc-34-3.4.6-4.1

compat-libgcc-296-2.96-138

libgcc-4.1.2-52.el5

gcc-objc-4.1.2-52.el5

compat-gcc-34-g77-3.4.6-4.1

gcc-gnat-4.1.2-52.el5

gcc-c++-4.1.2-52.el5

[root@oracledb ~]# rpm -qa |grep gcc-c++

gcc-c++-4.1.2-52.el5

[root@oracledb ~]# rpm -qa |grep glibc

compat-glibc-headers-2.3.4-2.26

glibc-2.5-81

compat-glibc-2.3.4-2.26

glibc-devel-2.5-81

compat-glibc-2.3.4-2.26

glibc-2.5-81

glibc-common-2.5-81

glibc-headers-2.5-81

[root@oracledb ~]# rpm -qa |grep ksh

ksh-20100621-5.el5

[root@oracledb ~]# rpm -qa |grep libaio

libaio-0.3.106-5

[root@oracledb ~]# rpm -qa |grep libaio-devel

空 //默认没有

[root@oracledb ~]# mkdir /disk

[root@oracledb ~]# chmod -R 777 /disk/

[root@oracledb ~]# cd /disk/

[root@oracledb disk]# ls /mnt/Server/ |grep libaio-devel

libaio-devel-0.3.106-5.i386.rpm

libaio-devel-0.3.106-5.x86_64.rpm

[root@oracledb disk]# cp -a /mnt/Server/libaio-devel-0.3.106-5.i386.rpm .

[root@oracledb disk]# cp -a /mnt/Server/libaio-devel-0.3.106-5.x86_64.rpm .

[root@oracledb disk]# ls

libaio-devel-0.3.106-5.i386.rpm libaio-devel-0.3.106-5.x86_64.rpm

[root@oracledb disk]# rpm -ivh *.rpm

warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:libaio-devel ########################################### [ 50%]

2:libaio-devel ########################################### [100%]

[root@oracledb disk]# rpm -qa |grep libaio-devel

libaio-devel-0.3.106-5

[root@oracledb disk]# cd -

/root

[root@oracledb ~]# rpm -qa |grep unixODBC

空 //默认没有，有依赖关系，建议 Yum

[root@oracledb ~]# yum -y install unixODBC //yum 装完只有 4 个,还差两个

[root@oracledb ~]# yum -y install unixODBC-devel

[root@oracledb ~]# rpm -qa |grep unixODBC

unixODBC-devel-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

unixODBC-devel-2.2.11-10.el5

unixODBC-2.2.11-10.el5

unixODBC-libs-2.2.11-10.el5

[root@oracledb ~]# rpm -qa |grep sysstat

sysstat-7.0.2-11.el5

创建用户和组：

[root@oracledb ~]# groupadd oinstall

[root@oracledb ~]# groupadd -g 502 dba

[root@oracledb ~]# groupadd -g 503 oper

[root@oracledb ~]# groupadd -g 504 asmadmin

[root@oracledb ~]# groupadd -g 506 asmdba

[root@oracledb ~]# groupadd -g 505 asmoper

[root@oracledb ~]# useradd -u 502 -g oinstall -G dba,oper,asmdba oracle

[root@oracledb ~]# echo "oracle" |passwd --stdin oracle

[root@oracledb ~]# useradd -u 503 -g oinstall -G asmadmin,asmdba,asmoper,dba grid

[root@oracledb ~]# echo "oracle" |passwd --stdin grid

配置内核等各个文件参数：

[root@oracledb ~]# vim /etc/sysctl.conf //oracle 工程师调节最优的参数值,官方过来

……………………//最下面添加参数

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmin = 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

[root@oracledb ~]# sysctl -p

[root@oracledb ~]# vim /etc/security/limits.conf

………………//最下面添加参数

#for oracle

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

#for grid

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

[root@oracledb ~]# more /etc/oratab

/etc/oratab: No such file or directory //检查服务器有没有安装 oracle 软件，默认没有的

[root@oracledb ~]# mkdir /u01/app/oracle -p

[root@oracledb ~]# mkdir /u01/app/grid -p

[root@oracledb ~]# chown -R grid:oinstall /u01

[root@oracledb ~]# chown -R oracle:oinstall /u01/app/oracle/

[root@oracledb ~]# chmod -R 775 /u01/

[root@oracledb ~]# ls /u01/app/

grid oracle //grid 管理实例，实例是用来管理数据库的

配置用户的环境变量：

[root@oracledb ~]# su - oracle

[oracle@oracledb ~]$ ls -a

. .. .bash_logout .bash_profile .bashrc .emacs .kde .mozilla .zshrc

[oracle@oracledb ~]$ vim .bash_profile

………………//最下面添加

export ORACLE_BASE=/u01/app/oracle

export ORACLE_SID=orcl

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

[oracle@oracledb ~]$ source .bash_profile

[oracle@oracledb ~]$ echo $ORACLE_BASE

/u01/app/oracle

[oracle@oracledb ~]$ echo $ORACLE_SID

orcl

[oracle@oracledb ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/dbhome_1

[oracle@oracledb ~]$ exit

logout

[root@oracledb ~]# su - grid

[grid@oracledb ~]$ ls -a

. .. .bash_logout .bash_profile .bashrc .emacs .kde .mozilla .zshrc

[grid@oracledb ~]$ vim .bash_profile

………………//最下面添加

export ORACLE_BASE=/u01/app/grid

export ORACLE_SID=+ASM

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid

[grid@oracledb ~]$ source .bash_profile

[grid@oracledb ~]$ echo $ORACLE_BASE

/u01/app/grid

[grid@oracledb ~]$ echo $ORACLE_SID

+ASM

[grid@oracledb ~]$ echo $ORACLE_HOME

/u01/app/grid/product/11.2.0/grid

[grid@oracledb ~]$ exit

logout

[root@oracledb ~]# uname -rm

2.6.18-308.el5 x86_64

上传驱动包：

[root@oracledb ~]# ls /root/Desktop/

oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm oracleasm-support-2.1.8-1.el5.x86_64.rpm

oracleasmlib-2.0.4-1.el5.x86_64.rpm

[root@oracledb ~]# cd /root/Desktop/

[root@oracledb Desktop]# rpm -ivh *.rpm

warning: oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY,

key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-support ########################################### [ 33%]

2:oracleasm-2.6.18-308.el########################################### [ 67%]

3:oracleasmlib ########################################### [100%]

[root@oracledb Desktop]# rpm -qa |grep oracleasm //检查驱动包

oracleasm-2.6.18-308.el5-2.0.5-1.el5

oracleasm-support-2.1.8-1.el5

oracleasmlib-2.0.4-1.el5

配置驱动、磁盘准备：

[root@oracledb Desktop]# cd

[root@oracledb ~]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets ('[]'). Hitting <ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLib disks: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm status //检查驱动和 asm 磁盘是否 ok

Checking if ASM is loaded: yes

Checking if /dev/oracleasm is mounted: yes

[root@oracledb ~]# mount

/dev/sda2 on / type ext3 (rw)

proc on /proc type proc (rw)

sysfs on /sys type sysfs (rw)

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

/dev/sda6 on /u01 type ext3 (rw)

/dev/sda3 on /tmp type ext3 (rw)

/dev/sda1 on /boot type ext3 (rw)

tmpfs on /dev/shm type tmpfs (rw)

none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)

none on /proc/fs/vmblock/mountPoint type vmblock (rw)

sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

/dev/sr0 on /mnt type iso9660 (ro)

oracleasmfs on /dev/oracleasm type oracleasmfs (rw) //检查是否 ok

[root@oracledb ~]# init 0 //关机，添加磁盘，做 raid

添加 5 块 50G 的磁盘，其中 3 块装数据库，2 块做恢复使用：

添加磁盘后然后开机

[root@oracledb ~]# ls /dev/sd*

/dev/sda /dev/sda2 /dev/sda4 /dev/sda6 /dev/sdc /dev/sde

/dev/sda1 /dev/sda3 /dev/sda5 /dev/sdb /dev/sdd /dev/sdf

[root@oracledb ~]# fdisk -l //检查新加的 5 块磁盘

[root@oracledb ~]# fdisk /dev/sdb

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel. Changes will remain in memory only,

until you decide to write them. After that, of course, the previous

content won't be recoverable.

The number of cylinders for this disk is set to 6527.

There is nothing wrong with that, but this is larger than 1024,

and could in certain setups cause problems with:

1) software that runs at boot time (e.g., old versions of LILO)

2) booting and partitioning software from other OSs

(e.g., DOS FDISK, OS/2 FDISK)

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n

Command action

e extended

p primary partition (1-4)

Partition number (1-4): 1

First cylinder (1-6527, default 1):

Using default value 1

Last cylinder or +size or +sizeM or +sizeK (1-6527, default 6527):

Using default value 6527

Command (m for help): w

[root@oracledb ~]# fdisk /dev/sdc //依次……………

[root@oracledb ~]# fdisk /dev/sdd

[root@oracledb ~]# fdisk /dev/sde

[root@oracledb ~]# fdisk /dev/sdf

生效：

[root@oracledb ~]# partprobe /dev/sdb

[root@oracledb ~]# partprobe /dev/sdc

[root@oracledb ~]# partprobe /dev/sdd

[root@oracledb ~]# partprobe /dev/sde

[root@oracledb ~]# partprobe /dev/sdf

把刚刚分好的每个区的磁盘变成 asm 磁盘：（类似于 raid 的磁盘）

[root@oracledb ~]# /etc/init.d/oracleasm createdisk DISK1 /dev/sdb1

Marking disk "DISK1" as an ASM disk: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm createdisk DISK2 /dev/sdc1

Marking disk "DISK2" as an ASM disk: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm createdisk DISK3 /dev/sdd1

Marking disk "DISK3" as an ASM disk: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm createdisk DISK4 /dev/sde1

Marking disk "DISK4" as an ASM disk: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm createdisk DISK5 /dev/sdf1

Marking disk "DISK5" as an ASM disk: [ OK ]

[root@oracledb ~]# /etc/init.d/oracleasm listdisks //检查 asm 磁盘是否配置好

DISK1

DISK2

DISK3

DISK4

DISK5

其中前 3 块装数据库，后 2 块做备份用,asm 磁盘准备完毕，开始安装 grid 软件：

安装 grid 软件：上传 grid 包

[root@oracledb ~]# ls /root/Desktop/ |grep linux

linux.x64_11gR2_grid.zip

[root@oracledb ~]# mkdir /grid

[root@oracledb ~]# chmod -R 777 /grid/

[root@oracledb ~]# mv /root/Desktop/linux.x64_11gR2_grid.zip /grid/

[root@oracledb ~]# su - grid

[grid@oracledb ~]$ cd /grid/

[grid@oracledb grid]$ ls

linux.x64_11gR2_grid.zip

[grid@oracledb grid]$ unzip linux.x64_11gR2_grid.zip

[grid@oracledb grid]$ echo $?

[grid@oracledb grid]$ ls

grid linux.x64_11gR2_grid.zip

在 windows 下下载安装 Xmanager-passive Enterprise5，解压后安装并运行（安装后双击打开

Xmanager-passive 图标），为了能在 window 下调用 linux 的图形界面（xshell 连接时候可以调用 linux

图形界面），然后再用 xshell 远程连接：

[grid@oracledb grid]$export DISPLAY=192.168.1.2:0.0 //windows 下的 IP，允许桌面连接

[grid@oracledb grid]$ xhost +

剩余40页未读，继续阅读

评论收藏

内容反馈

运维实战帮

粉丝: 78
资源: 420

oracle11g仅主机安装（自定义建库后自动配置监听）-详细笔记总结

oracle11g仅主机安装（标准建库后自动配置监听）-详细笔记总结

oracle11g自动建库

windows server2008安装oracle11g-详细笔记总结

Oracle排错 DBCA建库诡异问题处理--rac环境不能创建rac库

在RedHat6.2环境下安装ORACLE11G全过程（安装系统--安装数据库软件--建库--启动实例--启动EM--连接数据库）

oracle11g手工建库

Oracle11g静默安装以及手工建库文档

centos6.6安装oraclg11g-详细笔记总结

oracle11g监听文件

create database - Oracle11gr2 on rhel 手动建库

Oracle 10g的ASM裸设备建库 For Linux

oracle安装（网络yum redhat5.8和centos6.4）-详细笔记总结

Windows Server 2019下Oracle 11g,19c安装部署-图文

oracle 11g linux7 安装缺少compat-libstd++-33

【Oracle-RAC】Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂)

Oracle 11g R2 手动建库脚本

Oracle 11g RAC+DG安装配置

oracle11g常用语句总结-笔记文档详细总结

Oracle-11g-OCP-051培训笔记

max30102实战资料，全部免费开源，包含硬件设计，下位机程序，上位机程序，结构设计

VMware Workstation 16虚拟机安装包

FinalShell安装包，让用户通过SSH、Telnet或者RDP等协议连接到远程服务器或设备，实现远程控制和管理

Ubuntu微信Linux版（非Wine版）

iStoreOS-PassWall

vdhcoapp 2.0.19 linux版本，配合video downloadhelper使用

黑白群晖 DSM7.X 监控套件 SurveillanceStation-x86-64-9.1.1-10728 学习版

Kylin-Server-V10-SP3-General-Release-2212-X86-64.7z.001

openssh-server离线安装包

麒麟Linux升级openssh-9.7p1脚本

最新资源