11g init DB software and database

oadmin->administrator


2.169

set ORACLE_HOME=C:apporacleproduct11.2.0dbhome_1
set ORACLE_SID=csmsdb
set TNS_ADMIN=C:apporacleproduct11.2.0dbhome_1 etworkadmin
set PATH=%ORACLE_HOME%in;%ORACLE_HOME%OPatch;%PATH%


C:appsoftwareRSPdb.rsp
修改主机名


mkdir -p C:apporacleproduct11.2.0dbhome_1
mkdir -p C:apporaclearchivelog

cd C:appsoftwarep13390677_112040_MSWIN-x86-64database
setup.exe -silent  -debug -force -waitforcompletion   -responseFile "C:appsoftwareRSPdb.rsp"



C:apporacleproduct11.2.0dbhome_1OPatchocminemocmrsp.bat
已成功创建 OCM 配置响应文件 (ocm.rsp)。

cd C:appsoftwarep23530402_112040_MSWIN-x86-64
opatch apply  -silent 23530402 -ocmrf C:appsoftwareRSPocm.rsp


cd C:appsoftwarep23515277_112040_MSWIN-x86-64
opatch apply   -silent  23515277 -ocmrf C:appsoftwareRSPocm.rsp





--dbca
demo
check administrator 属于ora_dba组



 dbca -silent -createDatabase -templateName New_Database.dbt -gdbname csmsdb  -sid csmsdb -datafileDestination C:apporacleoradatacsmsdb  -responseFile NO_VALUE -characterset AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
 
C:> dbca -silent -createDatabase -templateName New_Database.dbt -gdbname csmsdb
  -sid csmsdb -datafileDestination C:apporacleoradatacsmsdb  -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:dbautility

C:dbautility

----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" 上的目录 "\vcsmsdbC$UsersADMINI~1AppDataLocalTemp3\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