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 的版本

 

 

#########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

炊烟起了；夕阳下了；细雨来了 多调试,交互式编程体验 记录，独立思考，对比 感谢转载作者 修车 国产化 read and connect 匍匐前进, 讲故事