單實例手工建庫

[oracle@sgdSSD-32 response]$ vi /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.2.196.75 sgdSSD-32
-------這一段新紅旗操作系統不用加了
[root@effectiveness-db-05 ~]# vim /etc/profile
if [ $USER = "oracle" ]||[ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
-------
[root@effectiveness-db-05 ~]# vim /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
[root@effectiveness-db-05 ~]# vim /etc/pam.d/login
session required pam_limits.so

5、創建用戶和組
groupadd -g 1000 oinstall
groupadd -g 1001 dba
groupadd -g 1002 oper
groupadd -g 1003 asmadmin
groupadd -g 1004 asmdba
groupadd -g 1005 asmoper
useradd -u 2000 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid grid
useradd -u 2001 -g oinstall -G asmdba,asmadmin,dba,oper -d /home/oracle oracle

passwd grid
passwd oracle

6、創建目錄
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/11.2.0/grid
chown -R grid:oinstall /oracle
mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
mkdir -p /lsi/oracle/oradata/
chown -R oracle:oinstall /lsi/oracle/oradata/
chown -R oracle:oinstall /lsi
7、設置環境變數

Oracle用戶：添加如下內容
[root@effectiveness-db-05 ~]# vim /home/oracle/.bash_profile
export ORACLE_UNQNAME=tmsdb
export ORACLE_SID=tmsdb
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export NLS_LANG='American_America.AL32UTF8'
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
unset USERNAME
umask 022
[root@effectiveness-db-05 ~]# source /home/grid/.bash_profile
[root@effectiveness-db-05 ~]# source /home/oracle/.bash_profile

大頁記憶體
vi /etc/sysctl.conf

net.core.rmem_max=4194304
net.core.wmem_max=1048576
net.core.rmem_default=262144
net.core.wmem_default=262144
net.ipv4.ip_local_port_range =9000 65500
fs.file-max = 6815744
#fs.aio-max-nr =1048576
fs.aio-max-nr=4194304
kernel.shmmni =4096

####add by Roger(hugepage)
vm.nr_hugepages = 100000

sysctl -p

vi /etc/security/limits.conf
oracle soft memlock 204800000
oracle hard memlock 204800000
=============================================================
一安裝資料庫軟體
vi database/response/db_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=kanbanh11
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oracle/
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=tmsdb
oracle.install.db.config.starterdb.SID=tmsdb
oracle.install.db.config.starterdb.password.ALL=sys
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
DECLINE_SECURITY_UPDATES=true
======================================================================
./runInstaller -responseFile /lsi/database/response/wty_db_install.rsp -silent -ignoreSysPrereqs

=========================================================
二、建庫
dbca -silent -responseFile /lsi/database/response/gyc.rsp

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "tmsdb"
SID = "tmsdb"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "sys"
SYSTEMPASSWORD = "sys"
DATAFILEDESTINATION = /lsi/oracle/oradata
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK"
NATIONALCHARACTERSET= "AL16UTF16"