静默安装

1.首先检查防火墙是否关闭
[root@localhost ~]# service iptables off
Usage: iptables {start|stop|reload|restart|condrestart|status|panic|save}
[root@localhost ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
[root@localhost ~]#
[root@localhost ~]# chkconfig iptables off
2.软件包的检查
rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel
rpm -q glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl-devel sysstat
如果没有安装 yum -y install
3.查看memory和swap
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
df -h

查看机器型号
# dmidecode | grep "Product Name"

4.创建组和用户
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle


5.修改配置文件
vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 3010 12328960 3010 4096
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 = 1048586
kernel.shmmax = 61847529062
kernel.shmall=15099494


让其生效 /sbin/sysctl -p
6. 修改限制
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

mkdir -p /opt/oracle/
chown -R oracle:oinstall /opt/oracle/
7.修改oracle用户的环境变量
su - oracle

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# For Oracle
export DISPLAY=:0.0
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_BASE=/opt/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;
export ORACLE_SID=data2db;
export ORACLE_TERM=xterm;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/dbs:$JAVA_HOME/bin
export PS1="\\u@\\h \\w\\$"
df -h



8.开始静默安装（文件路径和实例名，根据实际情况进行修改）
./runInstaller -silent -debug -force \
FROM_LOCATION=/oracle/soft/database/stage/products.xml \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/oracle/oraInventory \
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1 \
ORACLE_HOME_NAME="OracleHome" \
ORACLE_BASE=/oracle/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
DECLINE_SECURITY_UPDATES=true \
-ignoreInternalDriverError


建库
vi dbca.rsp ---------创建一个文件，内容如下
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "gztarcdb"
SID = "gztarcdb"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "DISNEY"
SYSTEMPASSWORD = "DISNEY"
SYSMANPASSWORD = "DISNEY"
DBSNMPPASSWORD = "DISNEY"
DATAFILEDESTINATION ="/data/oradata/"
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "FALSE"
在oracle用户下调用这个开始建库
dbca -silent -responsefile /home/oracle/dbca.rsp

x修改参数
sqlplus / as sysdba
alter system set sga_max_size=16G scope=spfile;
alter system set sga_target=16G scope=spfile;
alter system set db_cache_size=8G scope=spfile;
alter system set shared_pool_size=2G scope=spfile;
alter system set large_pool_size=500m scope=spfile;
alter system set pga_aggregate_target=10G scope=spfile;
alter system set open_cursors=500 scope=spfile;
alter system set processes=3000 scope=spfile;
alter system set db_files=1024 scope=spfile;


修改用户的限制
COL PROFILE FOR A10;
COL RESOURCE_NAME FOR A20;
COL LIMIT FOR A10;
SELECT * FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME='PASSWORD_LIFE_TIME';


alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS unlimited;
alter profile default limit PASSWORD_LIFE_TIME unlimited;

添加日志组
alter database add logfile group 4 '/data/oradata/gztarcdb/redo04.log' size 1024m;
alter database add logfile group 5 '/data/oradata/gztarcdb/redo05.log' size 1024m;
alter database add logfile group 6 '/data/oradata/gztarcdb/redo06.log' size 1024m;
alter database add logfile group 7 '/data/oradata/gztarcdb/redo07.log' size 1024m;
alter database add logfile group 8 '/data/oradata/gztarcdb/redo08.log' size 1024m;
切换日志
alter system switch logfile; ------多切换几次
查看日志组成员是否在current或者active 状态
select * from v$log;

删除日志组（只有在unactive，才能进行删除）
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

添加日志组，重新用redo01的文件
alter database add logfile group 1 '/data/oradata/gztarcdb/redo01.log' size 1024m reuse;
alter database add logfile group 2 '/data/oradata/gztarcdb/redo02.log' size 1024m reuse;
alter database add logfile group 3 '/data/oradata/gztarcdb/redo03.log' size 1024m reuse;

修改users表空间为自动扩展
--users
alter database datafile 4 autoextend off;
设置归档
mkdir /home/oracle/arch1
alter database archivelog;
alter system set log_archive_dest_1='location=/home/oracle/arch1';

打开监听
lsnrctl start

注册监听
alter systerm register;