1、System info
cat /etc/redhat-release
Distributor ID: CentOS
#CentOS Linux release 7.9.2009 (Core)
redhat-7
2、Memery info
free
Mem
a、grep MemTotal /proc/meminfo
MemTotal: 263843204kB
SWAP
*the same with memery
b、grep SwapTotal /proc/meminfo
SwapTotal: 268435452kB
c、swap crete
dd if=/dev/zero of=/var/swapfile bs=1G count=256 （看清数字 会制作256G的swap文件）
swapoff -a
mkswap /var/swapfile
echo "/var/swapfile swap swap defaults 0 0" >> /etc/fstab (此步骤需注意先注释里面原本的swap)
chmod -R 0600 /var/swapfile
swapon /var/swapfile
Share memry
*the /dev/shm must more the oracle memery target(Max)
df -h | grep /dev/shm
计算法法为内存*0.8 已G为单位计算
修改方式：mount -o remount,size=210G /dev/shm
vi /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=XXXXPRODDB
vi /etc/hosts
127.0.0.1 XXXXPRODDB
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
System Config File
1、limits.conf
vi /etc/security/limits.conf
* hard nofile 102400
* soft nofile 102400
oracle hard nofile 65536
oracle soft nofile 10240
oracle hard nproc 65535
oracle soft nproc 20480
vi /etc/pam.d/login
session required pam_limits.so
3、Sysctl.conf (具体计算方法百度看)
vi /etc/sysctl.conf
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.ip_forward = 0
vm.dirty_background_ratio = 5
vm.dirty_ratio = 10
#Controls the default maxmimum size of a mesage queue
kernel.msgmnb=65536
#Controls the maximum size of a message, in bytes
kernel.msgmax=65536
#Controls the maximum shared segment size, in bytes
kernel.shmmax=161061273600
#Controls the maximum number of shared memory segments, in pages
kernel.shmall=39321600
fs.file-max=6815744
fs.aio-max-nr=1048576
kernel.shmmni=4096
kernel.sem=610 86620 100 142
net.ipv4.ip_local_port_range=9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
net.nf_conntrack_max=6553600
vm.swappiness=10
sysctl -p （改命令刷新参数）
vi /proc/sys/vm/swappiness
将查询的参数更改成10 ，然后保存
sysctl vm.swappiness=10 改命令是临时生效
也就是说，你的内存在使用到100-60=40%的时候，就开始出现有交换分区的使用。大家知道，内存的速度会比磁盘快很多，这样子会加大系统io，同时造的成大量页的换进换出，严重影响系统的性能，所以我们在操作系统层面，要尽可能使用内存，对该参数进行调整。
4、Selinux
vi /etc/selinux/config
SELINUX=disabled
SETLOCALDEFS=0
5、Dependent Libray
yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh ksh
6、User and Groups
groupadd dba
groupadd oinstall
useradd -g oinstall -G dba oracle
7、Fold
oracle 11.2.0.4
*安装软件目录：
mkdir /data/oracle/prod/product -p
*数据文件：
mkdir -p /data/oracle/prod/datafile -p
*备份：
mkdir /data/oracle/prod/bak -p
*软件：
mkdir /data/soft -p
*安装日志文件：
mkdir -p /data/oraInventory -p
*更改目录权限
chown -R oracle:oinstall /data
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
INSTALL ORACLE_for_11G_R2
1、su - oracle
2、Oracle Pfile
vi /home/oracle/.profileORA
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=/data/oracle/prod/product/11.2.0.4/db_1
export ORACLE_SID=XXXXPRODDB
export NLS_LANG="AMERICAN_AMERICA.UTF8"
export EDITOR=vi
export PATH=$PATH:/bin:/usr/sbin
export PATH=$PATH:$ORACLE_BASE:$ORACLE_HOME:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:ORACLE_HOME/lib
3、Install Oracle Software
cat /data/oracle/prod/bak/db_install1.rsp
```language
####################################################################
##Copyright(c) Oracle Corporation 1998,2013. All rights reserved.##
####
##Specify values for the variables listed below to customize ##
##your installation. ##
####
##Each variable is associated with a comment. The comment ##
##can help to populate the variables with the appropriate ##
##values. ##
####
##IMPORTANT NOTE: This file contains plain text passwords and ##
##should be secured to have read permission only by oracle user ##
##or db administrator who owns this installation. ##
####
####################################################################
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
#------------------------------------------------------------------------------
#Specify the installation option.
#It can be one of the following:
#- INSTALL_DB_SWONLY
#- INSTALL_DB_AND_CONFIG
#- UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
#-------------------------------------------------------------------------------
#Specify the hostname of the system as set during the install. It can be used
#to force the installation to use an alternative hostname rather than using the
#first hostname found on the system. (e.g., for systems with multiple hostnames
#and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=XXXXPRODDB
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
#Specify the location which holds the inventory files.
#This is an optional parameter if installing on
#Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/data/oraInventory
#-------------------------------------------------------------------------------
#Specify the languages in which the components will be installed.
#
#en : English ja : Japanese
#fr : French ko : Korean
#ar : Arabic es : Latin American Spanish
#bn : Bengali lv : Latvian
#pt_BR: Brazilian Portuguese lt : Lithuanian
#bg : Bulgarian ms : Malay
#fr_CA: Canadian French es_MX: Mexican Spanish
#ca : Catalan no : Norwegian
#hr : Croatian pl : Polish
#cs : Czech pt : Portuguese
#da : Danish ro : Romanian
#nl : Dutch ru : Russian
#ar_EG: Egyptian zh_CN: Simplified Chinese
#en_GB: English (Great Britain) sk : Slovak
#et : Estonian sl : Slovenian
#fi : Finnish es_ES: Spanish
#de : German sv : Swedish
#el : Greek th : Thai
#iw : Hebrew zh_TW: Traditional Chinese
#hu : Hungarian tr : Turkish
#is : Icelandic uk : Ukrainian
#in : Indonesian vi : Vietnamese
#it : Italian
#
#all_langs : All languages
#
#Specify value as the following to select any of the languages.
#Example : SELECTED_LANGUAGES=en,fr,ja
#
#Specify value as the following to select all the languages.
#Example : SELECTED_LANGUAGES=all_langs
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=zh_CN,en
#------------------------------------------------------------------------------
#Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/data/oracle/prod/product/11.2.0.4/db_1
#------------------------------------------------------------------------------
#Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE=/data/oracle
#------------------------------------------------------------------------------
#Specify the installation edition of the component.
#
#The value should contain only one of these choices.
#- EE : Enterprise Edition
#- SE : Standard Edition
#- SEONE : Standard Edition One
#- PE : Personal Edition (WINDOWS ONLY)
#------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
#------------------------------------------------------------------------------
# This variable is used to enable or disable custom install and is considered
# only if InstallEdition is EE.
#
# true : Components mentioned as part of 'optionalComponents' property
# are considered for install.
# false : Value for 'optionalComponents' is not considered.
#------------------------------------------------------------------------------
oracle.install.db.EEOptionsSelection=false
#------------------------------------------------------------------------------
# This variable is considered only if 'EEOptionsSelection' is set to true.
#
# Description: List of Enterprise Edition Options you would like to enable.
#
# The following choices are available. You may specify any
# combination of these choices. The components you choose should
# be specified in the form "internal-component-name:version"
# Below is a list of components you may specify to enable.
#
# oracle.oraolap:11.2.0.4.0 - Oracle OLAP
# oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining
# oracle.rdbms.dv:11.2.0.4.0 - Oracle Database Vault
# oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security
# oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning
# oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing
#------------------------------------------------------------------------------
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
###############################################################################
# #
# PRIVILEGED OPERATING SYSTEM GROUPS #
# ------------------------------------------ #
# Provide values for the OS groups to which OSDBA and OSOPER privileges #
# needs to be granted. If the install is being performed as a member of the #
# group "dba", then that will be used unless specified otherwise below. #
# #
# The value to be specified for OSDBA and OSOPER group is only for UNIX based #
# Operating System. #
# #
###############################################################################
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=oinstall
#------------------------------------------------------------------------------
# Specify the cluster node names selected during the installation.
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=
#------------------------------------------------------------------------------
# This variable is used to enable or disable RAC One Node install.
#
# - true : Value of RAC One Node service name is used.
# - false : Value of RAC One Node service name is not used.
#
# If left blank, it will be assumed to be false
#------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=
#------------------------------------------------------------------------------
# Specify the name for RAC One Node Service.
#------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=
#------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
# - GENERAL_PURPOSE/TRANSACTION_PROCESSING
# - DATA_WAREHOUSE
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
#------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=XXXXPRODDB
#------------------------------------------------------------------------------
# Specify the Starter Database SID.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=XXXXPRODDB
#------------------------------------------------------------------------------
# Specify the Starter Database character set.
#
# It can be one of the following:
# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=AL32UTF8
#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=true
#------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available
# on the system.
# Example: oracle.install.db.config.starterdb.memoryLimit=512
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=10240
#------------------------------------------------------------------------------
# This variable controls whether to load Example Schemas onto
# the starter database or not.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=false
#------------------------------------------------------------------------------
# This variable includes enabling audit settings, configuring password profiles
# and revoking some grants to public. These settings are provided by default.
# These settings may also be disabled.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableSecuritySettings=true
###############################################################################
# #
# Passwords can be supplied for the following four schemas in the #
# starter database: #
# SYS #
# SYSTEM #
# SYSMAN (used by Enterprise Manager) #
# DBSNMP (used by Enterprise Manager) #
# #
# Same password can be used for all accounts (not recommended) #
# or different passwords for each account can be provided (recommended) #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=1qaz@WSXcde3
#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=
#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=
#-------------------------------------------------------------------------------
# Specify the SYSMAN password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSMAN=
#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=
#-------------------------------------------------------------------------------
# Specify the management option to be selected for the starter database.
# It can be one of the following:
# - GRID_CONTROL
# - DB_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.control=DB_CONTROL
#-------------------------------------------------------------------------------
# Specify the Management Service to use if Grid Control is selected to manage
# the database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
###############################################################################
# #
# SPECIFY BACKUP AND RECOVERY OPTIONS #
# ------------------------------------ #
# Out-of-box backup and recovery options for the database can be mentioned #
# using the entries below. #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable is to be set to false if automated backup is not required. Else
# this can be set to true.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.enable=false
#------------------------------------------------------------------------------
# Regardless of the type of storage that is chosen for backup and recovery, if
# automated backups are enabled, a job will be scheduled to run daily to backup
# the database. This job will run as the operating system user that is
# specified in this variable.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.osuid=
#-------------------------------------------------------------------------------
# Regardless of the type of storage that is chosen for backup and recovery, if
# automated backups are enabled, a job will be scheduled to run daily to backup
# the database. This job will run as the operating system user specified by the
# above entry. The following entry stores the password for the above operating
# system user.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.automatedBackup.ospwd=
#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
# - FILE_SYSTEM_STORAGE
# - ASM_STORAGE
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/data/oracle/prod/datafile
#-------------------------------------------------------------------------------
# Specify the backup and recovery location.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/data/oracle/prod/flash_recovery_area
#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=
#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example : MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=
#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example : PROXY_HOST=proxy.domain.com
#------------------------------------------------------------------------------
PROXY_HOST=
#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and at least 2 chars.
#
# Example : PROXY_PORT=25
#------------------------------------------------------------------------------
PROXY_PORT=
#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_USER=username
#------------------------------------------------------------------------------
PROXY_USER=
#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_PWD=password
#------------------------------------------------------------------------------
PROXY_PWD=
#------------------------------------------------------------------------------
# Specify the proxy realm. This value is used if auto-updates option is selected.
#
# Example : PROXY_REALM=metalink
#------------------------------------------------------------------------------
PROXY_REALM=
#------------------------------------------------------------------------------
# Specify the Oracle Support Hub URL.
#
# Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/
#------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=
#------------------------------------------------------------------------------
# Specify the auto-updates option. It can be one of the following:
# - MYORACLESUPPORT_DOWNLOAD
# - OFFLINE_UPDATES
# - SKIP_UPDATES
#------------------------------------------------------------------------------
oracle.installer.autoupdates.option=
#------------------------------------------------------------------------------
# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where
# the updates are to be downloaded.
# In case OFFLINE_UPDATES option is chosen, specify the location where the updates
# are present.
#------------------------------------------------------------------------------
oracle.installer.autoupdates.downloadUpdatesLoc=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username which has the patches download privileges
# to be used for software updates.
# Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password which has the patches download privileges
# to be used for software updates.
#
# Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
#INSTALL_COMMAND
./runInstaller -silent -ignorePrereq -force -responseFile /data/oracle/prod/bak/db_install1.rsp
4、Install oracle database
a、source /home/oracle/.profileORA
b、vi /data/oracle/prod/bak/dbca1.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "XXXXPRODDB"
SID = "XXXXPRODDB"
STORAGETYPE=FS
TEMPLATENAME = "General_Purpose.dbc"
SYSTEMPASSWORD = "XXXXXXXX"
SYSPASSWORD = "XXXXXX"
DATAFILEDESTINATION = "/data/oracle/prod/datafile"
RECOVERYAREADESTINATION= "/data/oracle/prod/flash_recovery_area"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "UTF8"
TOTALMEMORY = "10240"
c、dbca -silent -responseFile /data/oracle/prod/bak/dbca1.rsp
5、Install oracle netca.rsp
vi /data/oracle/prod/bak/netca.rsp
###############################################################
## Copyright(c) Oracle Corporation 2002. All rights reserved.##
## ##
## Specify values for the variables listed below to customize##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## identifies the variable type. ##
## ##
## Please specify the values in the following format: ##
## ##
## Type Example ##
## String "Sample Value" ##
## Boolean True or False ##
## Number 1000 ##
## StringList {"String value 1","String Value 2"} ##
## ##
###############################################################
## ##
## This sample response file causes the Oracle Net ##
## Configuration Assistant (NetCA) to complete an Oracle Net ##
## configuration during a custom install of the Oracle11g ##
## server which is similar to what would be created by the ##
## NetCA during typical Oracle11g install. It also documents ##
## all of the NetCA response files variables so you can ##
## create your own response file to configure Oracle Net ##
## during an install the way you wish. ##
## ##
###############################################################
[GENERAL]
RESPONSEFILE_VERSION="11.2"
CREATE_TYPE="CUSTOM"
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#SHOW_GUI=false
#-------------------------------------------------------------------------------
# Name : LOG_FILE
# Datatype : String
# Description: If present, NetCA will log output to this file in addition to the
# standard out.
# Pre-req : N/A
# Default : NONE
# Note:
# This is a substitute of "/log" in the NetCA command line.
# The command line argument has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#LOG_FILE=""/oracle11gHome/network/tools/log/netca.log""
[oracle.net.ca]
#INSTALLED_COMPONENTS;StringList;list of installed components
# The possible values for installed components are:
# "net8","server","client","aso", "cman", "javavm"
INSTALLED_COMPONENTS={"server","net8","javavm"}
#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom"
INSTALL_TYPE=""typical""
#LISTENER_NUMBER;Number;Number of Listeners
# A typical install sets one listener
LISTENER_NUMBER=1
#LISTENER_NAMES;StringList;list of listener names
# The values for listener are:
# "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...
# A typical install sets only "LISTENER"
LISTENER_NAMES={"LISTENER"}
#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)
# The possible values for listener protocols are:
# "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
# A typical install sets only "TCP;1521"
LISTENER_PROTOCOLS={"TCP;1521"}
#LISTENER_START;String;name of the listener to start, in double quotes
LISTENER_START=""LISTENER""
#NAMING_METHODS;StringList;list of naming methods
# The possible values for naming methods are:
# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE
# A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"
# or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes
# A typical install does not use this variable.
#NOVELL_NAMECONTEXT = ""NAMCONTEXT""
#SUN_METAMAP;String; SUN meta map, in double quotes
# A typical install does not use this variable.
#SUN_METAMAP = ""MAP""
#DCE_CELLNAME;String;DCE cell name, in double quotes
# A typical install does not use this variable.
#DCE_CELLNAME = ""CELL""
#NSN_NUMBER;Number;Number of NetService Names
# A typical install sets one net service name
NSN_NUMBER=1
#NSN_NAMES;StringList;list of Net Service names
# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
#NSN_SERVICE;StringList;Oracle11g database's service name
# A typical install sets Oracle11g database's service name to "PLSExtProc"
NSN_SERVICE={"PLSExtProc"}
#NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters
# The possible values for net service name protocol parameters are:
# "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY"
# A typical install sets parameters to "IPC;EXTPROC"
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
#INSTALL_COMMAND
netca /silent /responsefile /data/oracle/prod/bak/netca.rsp
6、REDO LOG FILE
select group#,thread#,archived,status, bytes/1024/1024 from v$log;
select group#,type, member from v$logfile;
alter system checkpoint ;
alter database drop logfile group 1;
rm /data/oracle/prod/datafile/XXXXPRDB/redo01.log
ALTER DATABASE ADD LOGFILE GROUP 1 ('/data/oracle/prod/datafile/XXXXPRDB/redo01.log') size 1024M;
alter system switch logfile;
alter database drop logfile group 2;
rm /data/oracle/prod/datafile/XXXXPRDB/redo02.log
ALTER DATABASE ADD LOGFILE GROUP 2 ('/data/oracle/prod/datafile/XXXXPRDB/redo02.log') size 1024M;
alter system switch logfile;
alter database drop logfile group 3;
rm /data/oracle/prod/datafile/XXXXPRDB/redo03.log
ALTER DATABASE ADD LOGFILE GROUP 3 ('/data/oracle/prod/datafile/XXXXPRDB/redo03.log') size 1024M;
alter system switch logfile;
7、Monory
show parameter target
ALTER SYSTEM SET MEMORY_TARGET = 128G scope=spfile; （生产为总内存*0.8）
ALTER SYSTEM SET MEMORY_MAX_TARGET=128G SCOPE=SPFILE; （生产为总内存*0.8）
ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0 scope=spfile;
8、db tablespace （按需求增加表空间）
CREATE TABLESPACE XXPRODDB1 datafile '/data/oracle/prod/datafile/IU01PRDB/IUPRODDB.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL; （这是创建表空间，下面语句为增加表空，请按需求来增加）
alter TABLESPACE XXXXPRODDB add datafile '/data/oracle/prod/datafile/XXXXPRODDB/XXXXPRODDB2.dbf' SIZE 30G;
alter TABLESPACE XXXXPRODDB add datafile '/data/oracle/prod/datafile/XXXXPRODDB/XXXXPRODDB3.dbf' SIZE 30G;
9、UNDO
show parameter undo;
create undo tablespace undo1 datafile '/data/oracle/prod/datafile/XXXXPRODDB/undot01.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
alter tablespace undo1 add datafile '/data/oracle/prod/datafile/XXXXPRODDB/undot02.dbf' SIZE 30G;
alter system set undo_tablespace=undo1;
DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES; （改步骤忽略，不要执行，需要确认该表空间没在使用）
show parameter undo
10、Temp
create temporary tablespace temp2 tempfile '/data/oracle/prod/datafile/XXXXPRODDB/temp02.dbf' size 30G autoextend off;
alter tablespace temp2 add tempfile '/data/oracle/prod/datafile/XXXXPRODDB/temp03.dbf' size 30G autoextend off;
alter database default temporary tablespace temp2;
drop tablespace temp INCLUDING CONTENTS AND DATAFILES;
select username,temporary_tablespace from dba_users;
11、processes/ sessions
alter system set processes = 3000 scope =spfile;
alter system set sessions=4544scope = spfile;
alter system set open_cursors=1200 scope=both;
show parameter processes
show parameter sessions
show parameter open_cursors;
12、change the password to unlimint:
1、查看用户的proifle是那个，一般是default：
sql>SELECT username,PROFILE FROM dba_users;
2、查看指定概要文件（如default）的密码有效期设置：
sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3、将密码有效期由默认的180天修改成“无限制”：
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
13、导入导出使用方法：
导出前确认需要导出的用户需要哪些表空间，如下示例为SIT-CGDB的表空间所示，需在导入的那个数据库创建并授权（XXXXPRDB表示数据库的SID，XXXX_prodowner 表示用户）
CREATE TABLESPACE TS_LOG datafile '/data/oracle/prod/datafile/XXXXPRDB/TS_LOG.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE TS_ORDER datafile '/data/oracle/prod/datafile/XXXXPRDB/TS_ORDER.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE TS_ORDER_DETAIL datafile '/data/oracle/prod/datafile/XXXXPRDB/TS_ORDER_DETAIL.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE TS_TRANS datafile '/data/oracle/prod/datafile/XXXXPRDB/TS_TRANS.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE TS_WIN_REC datafile '/data/oracle/prod/datafile/XXXXPRDB/TS_WIN_REC.dbf' SIZE 30G EXTENT MANAGEMENT LOCAL;
ALTER USER XXXX_prodowner DEFAULT TABLESPACE TS_LOG;
ALTER USER XXXX_prodowner DEFAULT TABLESPACE TS_ORDER;
ALTER USER XXXX_prodowner DEFAULT TABLESPACE TS_ORDER_DETAIL;
ALTER USER XXXX_prodowner DEFAULT TABLESPACE TS_TRANS;
ALTER USER XXXX_prodowner DEFAULT TABLESPACE TS_WIN_REC;
1.1导出数据，DIRECTORY指定oracle内创建的目录，导出的数据会存放在指定的EXPDP_DIR目录里，schemas和用户名是一样的，userid后面是账号和密码，如下不能进入sqlplus 会识别不到命令 ， DIRECTORY路径可进入授权了plus用语句查看。select * from dba_directories;
expdp DIRECTORY=CG2DATA_EXP logfile=iu20201221.log dumpfile=iu20201221.dmp schemas=用户名userid=用户名/密码 ； （改步骤是导出数据）
1.2、创建表空间
CREATE TABLESPACE XXXX datafile '/data/oracle/sit/datafile/XXXX/XXXX.dbf' SIZE 3G EXTENT MANAGEMENT LOCAL; （改步骤如果是新的数据库上面会有创建，如果导入其他数据库在执行此步骤）
1.3、创建用户并赋予用户拥有XXXX表空间的权限
create user 用户名字 identified by "用户密码" default tablespace 表空间名字 temporary tablespace TEMP2 profile DEFAULT; （改步骤如果是新的数据库上面会有创建，如果导入其他数据库在执行此步骤）
1.4、给用户授权
grant connect, resource to 用户名字; （改步骤如果是新的数据库上面会有创建，如果导入其他数据库在执行此步骤）
1.5、创建DIRECTORY的目录
create or replace directory XXdata_exp as '/data/oracle/XXback'; （XXdata_exp 是导入数据库需要用的，导出的dmp文件需要放在这个目录下）
1.6、给创建的目录授权，让kf_devService有读写的权限
grant read,write on directory xxdata_exp to 用户名字
1.7、创建目录的真实路径
mkdir -p /data/oracle/XXback （创建完目录记得把导入的文件放进来，下个步骤统一授权）
1.8、给目录授权
chown -R oracle:oinstall /data/oracle/xxback
1.9、查看目录是否存在数据库里
select * from dba_directories; (sql里做)
1.10、导入dmp文件的时候，需要授导入的权限；
grant imp_full_database to 用户名字;
1.11、xxDATA_EXP目录是之前创建的并已经把导出的数据放在这个目录里,logfile是自己定义的、dumpfile是需要导入的数据文件，SCHEMAS需要填写以前的用户名，remap_SCHEMA和remap_tablespace的格式都是<旧:新>，最后的userid是用户名和密码
impdp DIRECTORY=xxdata_exp logfile=xx202012212.log dumpfile=xx20201221.dmp SCHEMAS=这个是导出的数据库用户名字 remap_SCHEMA=旧数据库用户名:新数据库用户名 remap_tablespace=旧用户使用表空间:新用户使用表空间 userid=新用户名字/新用户密码