Oracle11.2.0.4单实例安装全过程(希望可以帮到大家)
实施环境
系统:Linux6.10
数据库版本:11.2.0.4
useradd -u 1000 -g oinstall -G dba,oper oracle
echo xxxx | passwd --stdin oracle
uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1100(dba),1200(oper)
chown -R oracle:oinstall /u01/
chown oracle:oinstall /home/software
使用 oracle 用户连接 编辑/home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
/u01/oracle/product/11.2.0/dbhome_1/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/home/oracle/bin
kernel.shmall = physical RAM size / pagesize (**) 内存化成k 除以4096 (页大小)内存/4b
kernel.shmmax = Half of the RAM or 4GB (*) 内存化成k 除以2 内存*1024*1024*1024-1
一般上面两个参数系统默认都比这两个大,所以一般都会使用系统默认的参数,而不去改动
https://msd.misuland.com/pd/3223833238703183490(推荐文章)
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
getconf PAGE_SIZE -----一般为4k,即4096
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
session required pam_limits.so
---------------------------------------------------------------------------------------------------------------
if [ $SHELL = "/bin/ksh" ]; then
---------------------------------------------------------------------------------------------------------------
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \
挂载光盘:关闭系统挂载Linux系统安装盘,(注意系统版本) ,启动系统后要登录桌面识别光盘。
/dev/sr0 iso9660 3.6G 3.6G 0 100% /media/RHEL_6.5 x86_64 Disc 1
mount /dev/sr0 /mnt 将光盘mount 到/mnt目录
[[email protected] yum.repos.d]# vi /etc/yum.repos.d/rhel5.repo
[[email protected] yum.repos.d]# mv /etc/yum.repos.d/CentOS-Base.repo CentOS-Base.repo.bak
yum repolist all ---------Linux6.10版本命令
yum -y install ---------安装yum,-y代表默认yes
yum install -y compat-libstdc++-33 cvuqdisk elfutils-libelf-devel gcc gcc-c++ glibc-devel glibc-headers ksh libaio-devel libstdc++-devel pdksh unixODBC unixODBC-devel
---------------------------------------------------------------------------------------------------------------
unzip p10404530_112030_Linux-x86-64_1of7.zip
unzip p10404530_112030_Linux-x86-64_2of7.zip
export DISPLAY=192.168.6.1:0.0(IP地址为本机虚拟机IPV4的IP地址)
无法启动xhost + 时可以安装 xstart用于启动图形化界面
Start timer (TIMER_SHUTDOWN, 180).
/usr/bin/xauth: file /home/oracle/.Xauthority does not exist
bash: /usr/bin/xterm: No such file or directory
---------------------------------------------------------------------------------------------------------------
以root用户编辑 /etc/hosts文件,localhost前添加主机名(hostname):
Single instance database installation(单安装数据库软件)
默认设置为English(可以选择Simplified Chinese)
这里检查package "pdksh-5.2.14" 包可以跳过不用安装。
rpm -ivh 安装包名称 --nodeps --force
此错误可以忽略,因为该包在RedHat上叫ksh,不是叫pdksh,所以直接忽略即可。
如果内核参数、资源限制等配置有问题,检查环节还会显示有其他错误,可先使用 Fix & Check Again
安装失败和重新安装时需检查/删除/u01/app/下的 oraInventory 目录 和 /u01/app/oracle 下的 product 目录
#vi /u01/oraInventory/logs/installActions2018-01-10_02-56-55PM.log
INFO: collect2: error: ld returned 1 exit status
INFO: make[1]: *[/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl] Error 1
INFO: make[1]: Leaving directory `/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'
INFO: make: *** [emdctl] Error 2
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'agent nmhs' of makefile '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk'. See '/u01/oraInventory/logs/installActions2018-01-10_02-56-55PM.log' for details.
vi $ORACLE_HOME/sysman/lib/ins_emagent.mk
$vi /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk
root 用户执行: /u01/app/oralnventory/11/2/dbhome_1/root.sh
/u01/app/oralnventory/orainstRoot.sh
lsnrctl start/stop/status 启动/关闭/查看 监听
startup (nomount/mount/) 启动数据库
alter database archivelog; 开启归档模式
select status from v$instance; 查看数据库状态
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initCes1.ora'
到该目录下 复制文件到 $ORACLE_HOME/dbs 下,并更改文件名为(init实例名.ora)
到这里就结束了,算是傻瓜文档。第一次上传,希望可以帮到大家。