11g init DB software and database
oadmin->administrator
2.169
set ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1
set ORACLE_SID=csmsdb
set TNS_ADMIN=C:\app\oracle\product\11.2.0\dbhome_1\network\admin
set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\OPatch;%PATH%
C:\app\software\RSP\db.rsp
修改主机名
mkdir -p C:\app\oracle\product\11.2.0\dbhome_1
mkdir -p C:\app\oracle\archivelog
cd C:\app\software\p13390677_112040_MSWIN-x86-64\database
setup.exe -silent -debug -force -waitforcompletion -responseFile "C:\app\software\RSP\db.rsp"
C:\app\oracle\product\11.2.0\dbhome_1\OPatch\ocm\bin\emocmrsp.bat
已成功创建 OCM 配置响应文件 (ocm.rsp)。
cd C:\app\software\p23530402_112040_MSWIN-x86-64
opatch apply -silent 23530402 -ocmrf C:\app\software\RSP\ocm.rsp
cd C:\app\software\p23515277_112040_MSWIN-x86-64\
opatch apply -silent 23515277 -ocmrf C:\app\software\RSP\ocm.rsp
--dbca
demo
check administrator 属于ora_dba组
dbca -silent -createDatabase -templateName New_Database.dbt -gdbname csmsdb -sid csmsdb -datafileDestination C:\app\oracle\oradata\csmsdb -responseFile NO_VALUE -characterset AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
C:\> dbca -silent -createDatabase -templateName New_Database.dbt -gdbname csmsdb
-sid csmsdb -datafileDestination C:\app\oracle\oradata\csmsdb -responseFile N
O_VALUE -characterset AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
输入 SYS 用户口令:oracle123
输入 SYSTEM 用户口令:
输入 DBSNMP 用户口令:
输入 SYSMAN 用户口令:
正在创建并启动 Oracle 实例
--
copy network file to uat to prod
----
关掉防火墙
1.copy env_csmsdb_uat.sql to prod
2.init tablespace and resize tablespace
3.init user
4.init archivelog
--5.exp and imp
---
mkdir -p d:\dba\utility
C:\dba\utility
----4.47
ngtest1:/home/dba/oracle [dtaruat] >crontab -l |grep dt
0,30 * * * * find /dtaruatdblog -user oracle -name '*.dbf' -ctime +2 -exec rm {} \; 1>/dev/null 2>&1
0,30 * * * * find /dtaruatdb/adump -user oracle -name '*.aud' -ctime +2 -exec rm {} \; 1>/dev/null 2>&1
0,30 * * * * find /dtaruatdb/diag/rdbms/dtaruat/dtaruat/trace -user oracle -name '*.tr*' -ctime +15 -exec rm {} \; 1>/dev/null 2>&1
---
手工包错：
[Worker 2] [ 2016-12-07 14:37:09.240 CST ] [RemoteExecCommand.execute:838] Nati
veException occured while setting up RemoteExecService. err msg:PRKN-1040 : 无法
删除节点 "vcsmsdb" 上的目录 "\\vcsmsdb\C$\Users\ADMINI~1\AppData\Local\Temp\3\\o
raremservice\"
图形包错：
原因 - 无法访问临时位置。
操作 - 请确保当前用户具有访问临时位置所需的权限。
附加信息:
所有节点上的框架设置检查都失败 失败节点概要 vcsmsdb - 无法从节点 "vcsmsdb" 检索 exectask 的版本
solution:
http://blog.csdn.net/qq_33562122/article/details/52137288
#########linux
$ORACLE_BASE=/u01/app/oracle11g
$ORACLE_HOME=/u01/app/oracle11g/product/11.2.0/dbhome_1
USER=ORACLE11G
$ORA_DATA=/u01/app/oracle11g/oradata
$ORACLE_INVENTORY=/u01/app/oracle11g/oraInventory
###
vi /etc/hosts
10.200.210.187 yumserver
userdel -r oracle
groupadd -g 700 oinstall
groupadd -g 701 dba
useradd -g oinstall -G dba -u 700 oracle11g
passwd oracle11g
echo "export TMP=/tmp">> /home/oracle11g/.bash_profile
echo 'export TMPDIR=$TMP'>>/home/oracle11g/.bash_profile
echo "export ORACLE_HOSTNAME=localhost.localdomain">> /home/oracle11g/.bash_profile
echo "export ORACLE_SID=orcl">> /home/oracle11g/.bash_profile
echo "export ORACLE_BASE=/u01/app/oracle11g">> /home/oracle11g/.bash_profile
echo 'export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1'>> /home/oracle11g/.bash_profile
echo 'export PATH=/usr/sbin:$PATH'>> /home/oracle11g/.bash_profile
echo 'export PATH=$ORACLE_HOME/bin:$PATH'>> /home/oracle11g/.bash_profiles
echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib'>> /home/oracle11g/.bash_profile
echo 'export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib'>> /home/oracle11g/.bash_profile
echo "export LANG=en_US" >> /home/oracle11g/.bash_profile
echo "export NLS_LANG=american_america.AL32UTF8" >> /home/oracle11g/.bash_profile
echo "export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'" >> /home/oracle11g/.bash_profile
echo "The Groups and users has been created"
mkdir -p /u01/app/oracle11g
mkdir -p /u01/app/oracle11g/product/11.2.0/dbhome_1
mkdir -p /u01/app/ora11gInventory
chown -R oracle11g:oinstall /u01
chown -R oracle11g:oinstall /u01/app/
chown -R oracle11g:oinstall /u01/app/oracle11g
cp /etc/security/limits.conf /etc/security/limits.conf.bak
echo "oracle11g soft nproc 2047" >>/etc/security/limits.conf
echo "oracle11g hard nproc 16384" >>/etc/security/limits.conf
echo "oracle11g soft nofile 1024" >>/etc/security/limits.conf
echo "oracle11g hard nofile 65536" >>/etc/security/limits.conf
echo "Modifing the /etc/security/limits.conf has been succeed."
cp /etc/pam.d/login /etc/pam.d/login.bak
echo "session required /lib/security/pam_limits.so" >>/etc/pam.d/login
echo "session required pam_limits.so" >>/etc/pam.d/login
echo "Modifing the /etc/pam.d/login has been succeed."
#5.config profile.
cp /etc/profile /etc/profile.bak
echo 'if [ $USER = "oracle11g" ]; then' >> /etc/profile
echo 'if [ $SHELL = "/bin/ksh" ]; then' >> /etc/profile
echo 'ulimit -p 16384' >> /etc/profile
echo 'ulimit -n 65536' >> /etc/profile
echo 'else' >> /etc/profile
echo 'ulimit -u 16384 -n 65536' >> /etc/profile
echo 'fi' >> /etc/profile
echo 'fi' >> /etc/profile
echo "Modifing the /etc/profile has been succeed."
#6.config sysctl.ctl
cp /etc/sysctl.conf /etc/sysctl.conf.bak
echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
echo "kernel.shmmax = 8046511104" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 1048586" >> /etc/sysctl.conf
echo "net.ipv4.tcp_wmem = 262144 262144 262144" >> /etc/sysctl.conf
echo "net.ipv4.tcp_rmem = 4194304 4194304 4194304" >> /etc/sysctl.conf
echo "Modifing the /etc/sysctl.conf has been succeed."
sysctl -p
chown -R oracle11g:oinstall /dbsoft/oracle11r2_linux
#####su - oracle11g
cd /dbsoft/oracle11r2_linux
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
cd database/response
mkdir rspbak
cp *.rsp ./rspbak
$ sed -i 's/^#.*$//g' *.rsp
$ sed -i '/^$/d' *.rsp
### vi db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=yumserver
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle11g/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle11g/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle11g
DECLINE_SECURITY_UPDATES=true
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
###for 12c ignoreall方式
./runInstaller -silent -debug -force -ignoreSysprereqs -responseFile /dbsoft/oracle11r2_linux/database/response/db_install.rsp
###for 11g ignoreall方式
./runInstaller -silent -force -ignoreprereq -responseFile /dbsoft/oracle11r2_linux/database/response/db_install.rsp
##issue 1;
INFO: ------------------List of failed Tasks------------------
INFO: *********************************************
INFO: Package: pdksh-5.2.14: This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
INFO: Severity:IGNORABLE
INFO: OverallStatus:VERIFICATION_FAILED
INFO: *********************************************
INFO: Users With Same UID: This test checks that multiple users do not exist with user id as "0".
INFO: Severity:CRITICAL
INFO: OverallStatus:VERIFICATION_FAILED
INFO: -----------------End of failed Tasks List----------------
cause:
admin is root
soluiton:
-ignoreprereq
