1、 增加虚拟内存
dd if=/dev/zero of=/swapadd bs=1024 count=2006424mkswap/swapadd
swapon/swapadd
2、 检查依赖包
rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc-2.5 glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel
3、 安装依赖包
yum install compat-libstdc++-33yum install elfutils-libelf-devel
yum install gcc-c++yum install glibc-2.5yum install ksh
yum install libaio
yum install libaio-devel
yum install libstdc++-devel
yum install unixODBC
yum install unixODBC-devel
4、 创建用户和组
groupadd oinstall
groupadd dba
groupadd asmadmin
groupadd asmdba
useradd-g oinstall -G dba,asmdba oracle -d /home/oracle
passwd oracle
5、 修改内核参数
vim /etc/sysctl.conf 增加或者修改
fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall= 2097152kernel.shmmax= 536870912kernel.shmmni= 4096kernel.sem= 250 32000 100 128net.ipv4.ip_local_port_range= 9000 65500net.core.rmem_default= 262144net.core.rmem_max= 4194304net.core.wmem_default= 262144net.core.wmem_max= 1048576
6、 修改用户限制
vim /etc/security/limits.conf
oracle soft nproc2047oracle hard nproc16384oracle soft nofile1024oracle hard nofile65536oracle soft stack10240vim/etc/pam.d/login
session required pam_limits.so
vim/etc/profileif [ $USER = "oracle"]; thenif [ $SHELL = "/bin/ksh"]; then
ulimit-p 16384ulimit-n 65536
elseulimit-u 16384 -n 65536fi
fi
source/etc/profile
7、 创建安装目录
mkdir -p /u01/app/chown-R oracle:oinstall /home/oracle
chmod-R 775 /home/oracle
chown-R oracle:oinstall /u01/app/chmod-R 775 /u01/app/创建vim/etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall
chown oracle:oinstall/etc/oraInst.loc
chmod664 /etc/oraInst.loc
8、 设置oracle环境变量
su – oracle
vim ~/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl
source/home/oracle/.bash_profile
env
9、 解压
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
10、复制响应文件模板
su – root
cd/home/oracle/mkdir etc
cp/home/oracle/database/response/* /home/oracle/etc/chmod777 /home/oracle/etc/*.rsp
11、静默安装Oracle软件
su – oracle
vim/home/oracle/etc/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=ruo
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN,zh_TW
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=trueoracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.memoryLimit=512oracle.install.db.config.starterdb.password.ALL=oracle
DECLINE_SECURITY_UPDATES=true
12、安装
cd database
./runInstaller -silent -force -responseFile /home/oracle/etc/db_install.rsp -ignorePrereq
cd$ORACLE_BASE/oraInventory/logs
tail-100f installActions*.log
su root/u01/app/oracle/product/11.2.0/db_1/root.sh
13、环境变量
su -oracle
vi ~/.bash_profile
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE/lib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export LIBPATH=${CLASSPATH}:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export ORACLE_OWNER=oracle
export SPFILE_PATH=$ORACLE_HOME/dbs
export ORA_NLS10=$ORACLE_HOME/nls/data
source/home/oracle/.bash_profile
14、配置网络
$ORACLE_HOME/bin/netca /silent /responseFile /home/oracle/etc/netca.rsp
15、安装数据库
vim /home/oracle/etc/dbca.rsp
GDBNAME="orcl.ruo"SID="orcl"SYSPASSWORD= "oracle"SYSTEMPASSWORD= "oracle"CHARACTERSET="AL32UTF8"NATIONALCHARACTERSET="UTF8"
$ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/etc/dbca.rsp
16、建库后实例检查
ps -ef | grep ora_ | grep -v grep | wc -l
ps-ef | grep ora_ | grep -v grep
17、建库后监听检查
lsnrctl status
18、.修改oracle启动配置文件
vi /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/db_1:Y
dbstart
dbshut
19、sqlplus / as sysdba
conn /as sysdba 连接到数据本地数据
alter user system identified by password; 修改System 密码 为password
已连接。
SQL>alter user system identified by password;
用户已更改。
SQL>alter user sys identified by password;
用户已更改。
SQL>alter user system identified by manger;
解锁方法
alter user system account unlock;