oracle运维——安装11gR2

LANG=C;rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel |egrep “is not installed” |awk ‘{print $2}’ |xargs yum -y install

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd dba

/usr/sbin/useradd -g oinstall -G dba oracle

echo “aqW28~fUQALJ57ZE” |passwd –stdin oracle

oracle 账户密码：aqW28~fUQALJ57ZE

/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

sysctl -p

/etc/security/limits.d/20-nproc.conf配置：

#nproc

*         soft   nproc    1000000

root      soft   nproc    unlimited

*         hard   nproc    1000000

root      hard   nproc    unlimited

oracle    soft   nproc    16384

oracle    hard   nproc    16384

#nofile

*         soft   nofile   1000000

*         hard   nofile   1000000

oracle    soft   nofile   65536

oracle    hard   nofile   65536

#stack

*         soft   stack    10240

oracle    soft   stack    32768

oracle    hard   stack    32768

mkdir /data/app/oracle/product/11.2.0 -pv

mkdir /data/app/oracle/{oradata,oraInventory,fast_recovery_area}

chown -R oracle:oinstall /data/app/oracle

chmod -R 755 /data/app/oracle

/etc/oraInst.loc的配置：

inventory_loc=/data/app/oracle/oraInventory

inst_group=oinstall

su – oracle

.bash_profile的配置：

#oracle

export ORACLE_HOSTNAME=jsnj-linux-server-01

export ORACLE_BASE=/data/app/oracle

export ORACLE_SID=ORCL

export LC_ALL=”en_US”

export LANG=”en_US”

export NLS_LANG=”SIMPLIFIED CHINESE_CHINA”.ZHS16GBK

export NLS_DATE_FORMAT=”YYYY-MM-DD HH24:MI:SS”

cd /data

mkdir 11gr2

unzip linux.x64_11gR2_database_1of2.zip -d 11gr2/

unzip linux.x64_11gR2_database_2of2.zip -d 11gr2/

mkdir /home/oracle/etc

cp 11gr2/database/response/* /home/oracle/etc/

chmod 777 /home/oracle/etc/*.rsp

su – oracle

etc/db_install.rsp配置信息：

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=oracle

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/data/app/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/data/app/oracle/product/11.2.0/db_1

ORACLE_BASE=/data/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=true

oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.CLUSTER_NODES=

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.characterSet=ZHS16GBK

oracle.install.db.config.starterdb.memoryOption=true

oracle.install.db.config.starterdb.memoryLimit=1024

oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.enableSecuritySettings=true

oracle.install.db.config.starterdb.password.ALL=oracle

oracle.install.db.config.starterdb.password.SYS=

oracle.install.db.config.starterdb.password.SYSTEM=

oracle.install.db.config.starterdb.password.SYSMAN=

oracle.install.db.config.starterdb.password.DBSNMP=

oracle.install.db.config.starterdb.control=DB_CONTROL

oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

oracle.install.db.config.starterdb.dbcontrol.emailAddress=

oracle.install.db.config.starterdb.dbcontrol.SMTPServer=

oracle.install.db.config.starterdb.automatedBackup.enable=false

oracle.install.db.config.starterdb.automatedBackup.osuid=

oracle.install.db.config.starterdb.automatedBackup.ospwd=

oracle.install.db.config.starterdb.storageType=

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

oracle.install.db.config.asm.diskGroup=

oracle.install.db.config.asm.ASMSNMPPassword=

MYORACLESUPPORT_USERNAME=

MYORACLESUPPORT_PASSWORD=

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

DECLINE_SECURITY_UPDATES=true

PROXY_HOST=

PROXY_PORT=

PROXY_USER=

PROXY_PWD=

cd /data/11gr2/database

./runInstaller -silent -force -responseFile /home/oracle/etc/db_install.rsp -ignorePrereq

回到root身份执行：/data/app/oracle/product/11.2.0/db_1/root.sh

su – oracle

.bash_profile增加配置：

export ORACLE_HOME=/data/app/oracle/product/11.2.0/db_1

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/or

acm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$O

RACLE_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 ~/.bash_profile

cd /data/app/oracle/product/11.2.0/db_1/bin

./netca /silent /responseFile /home/oracle/etc/netca.rsp

cd /data/app/oracle/product/11.2.0/db_1/bin

lsnrctl start

静默dbca建库

etc/dbca.rsp配置信息：

[GENERAL]

RESPONSEFILE_VERSION = “11.2.0”

OPERATION_TYPE = “createDatabase”

[CREATEDATABASE]

GDBNAME = “oraclehzs”

SID = “oraclehzs”

TEMPLATENAME = “General_Purpose.dbc”

CHARACTERSET = “ZHS16GBK”

NATIONALCHARACTERSET= “UTF8”

SYSPASSWORD = “oracle”

SYSTEMPASSWORD = “oracle”

cd /data/app/oracle/product/11.2.0/db_1/bin

./dbca -silent -responseFile /home/oracle/etc/dbca.rsp

ORA-00130: invalid listener address问题解决方法：

echo “10.40.0.3 $HOSTNAME” >>/etc/hosts

删除数据库实例orcl:

dbca -silent -deleteDatabase -sourcedb orcl

开机启动：

/etc/oratab：

orcl:/data/app/oracle/product/11.2.0/db_1:Y （N改成Y）

启动实例：

 ./dbstart $ORACLE_HOME

启动监听：

./lsnrctl start

LRM-00109: could not open parameter file ‘/data/app/oracle/product/11.2.0/db_1/dbs/initORCL.ora’问题解决方法：

cp /data/app/oracle/admin/oraclehzs/pfile/init.ora.32202211514 /data/app/oracle/product/11.2.0/db_1/dbs/initORCL.ora

chmod 777 /data/app/oracle/product/11.2.0/db_1/dbs/initORCL.ora

ORA-00845: MEMORY_TARGET not supported on this system问题解决方法：

原因：initORCL.ora文件里memory_target=设置的内存大小超过了可用内存，改小即可。

sqlplus “/ as sysdba”

startup;

ORA-00205: error in identifying control file, check alert log for more info问题解决方法：

查看日志：

/data/app/oracle/diag/rdbms/orcl/ORCL/alert/log.xml

修改密码：

alter user sys identified by FN6smiDWmvz4nwOC;

alter user system identified by FN6smiDWmvz4nwOC;

———————————————————————————————————————–

export PS1=”`/usr/bin/hostname`-o> “

export ORACLE_BASE=/app/oracle/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export ORA_GRID_HOME=/app/oracle/crs

export ORACLE_OWNER=oracle

export ORACLE_SID=ivrpro1

export PATH=$PATH:$ORACLE_HOME/bin:$ORA_GRID_HOME/bin:$ORACLE_HOME/jdk/bin:$ORACLE_HOME/jdk/jre:/sbin:/usr/sbin:/bin:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export NLS_LANG=”SIMPLIFIED CHINESE_CHINA”.ZHS16GBK

export ORACLE_PATH=/home/oracle

export ORACLE_USER_HOME=/home/oracle

export INSTALL_PATH=/app/oracle/oracle/product/11.2.0/db_1