oracle11.2安装手记
数据库安装：1、创建oracle用户及组
# groupadd -g 501 oinstall && groupadd -g 502 dba && groupadd -g 503 oper
# useradd -u 502 -g oinstall -G dba,oper oracle
2、安装依赖包
# yum install -y binutils compat-libcap1 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat elfutils-libelf-devel
# rpm -ivh compat-libstdc++-33-3.2.3-72.el7.i686.rpm compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm glibc-2.17-105.el7.i686.rpm glibc-devel-2.17-105.el7.i686.rpm glibc-static-2.17-105.el7.i686.rpm glibc-static-2.17-105.el7.x86_64.rpm libaio-0.3.109-13.el7.i686.rpm libaio-devel-0.3.109-13.el7.i686.rpm libgcc-4.8.5-4.el7.i686.rpm libstdc++-4.8.5-4.el7.i686.rpm libstdc++-devel-4.8.5-4.el7.i686.rpm libXi-1.7.4-2.el7.i686.rpm libXtst-1.2.2-2.1.el7.i686.rpm pdksh-5.2.14-37.el5_8.1.i386.rpm pdksh-5.2.14-37.el5_8.1.x86_64.rpm unixODBC-2.3.1-11.el7.i686.rpm unixODBC-devel-2.3.1-11.el7.i686.rpm --nodeps
3、配置安装环境
# vi /etc/sysctl.conf
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
# /sbin/sysctl -p //生效
# /sbin/sysctl -a //检查是否更改成功
# vi/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240
# mkdir -pv /u01/app/oracle/product/11.2.0.4.0/db_1
# chown -R oracle:oinstall /u01
# chmod -R 775 /u01
4、配置用户环境
# su - oracle
$ vi ~/.bash_profile
#####Oracle Settings######
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=oracle.localdomain; export ORACLE_HOSTNAME//修改主机名
ORACLE_UNQNAME=ddcos; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4.0/db_1; export ORACLE_HOME
ORACLE_SID=ddcos; export ORACLE_SID //修改实例名
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
$ source ~/.bash_profile
5、安装oracle
# su - oracle
$ export DISPLAY=“xshell客户端ip”:0.0
$ ./ runInstaller
# sh /u01/app/oraInventory/orainstRoot.sh //中途执行
# sh /u01/app/oracle/product/11.2.0.1.0/db_1/root.sh //中途执行
$ netca
$ dbca
$ lsnrctl start
$ sqlplus / as sysdba
在本地安装xshell enterprice版。在“运行”--Xmanager
在oracle服务器中运行
# export DISPLAY=“xshell客户端ip”:0.0此时即可使用图形界面。
error in invoking target 'agent nmhs'
# vi $ORACLE_HOME/sysman/lib/ins_emagent.mk
Search for the line
$(MK_EMAGENT_NMECTL)
Change it to:
$(MK_EMAGENT_NMECTL) -lnnz11
$ ps -ef |grep pmon
$ ps -ef |grep lsrn
$ sqlplus / as sysdba
$ select instance_name from v$instance;
$ show parameter name
页:
[1]