Linux静默安装Oracle

准备安装文件

1. JDK

安装jdk rpm -hvi jdk-XXX.rpm

修改java环境变量 vim /etc/profile

2. Oracle

下载Oracle安装文件，并解压

准备环境

1. 安装依赖

gcc、glibc

1
2
3
4
yum install gcc*
yum install glibc*
yum install make
yum install libaio

2. 创建oracle用户/用户组

1
2
3
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba -d /u01 oracle

3. 修改内核参数

1
2
3
4
5
6
7
8
9
10
11
12
vi /etc/security/limits.conf

oracle           soft    nproc           2047
oracle           hard    nproc           16384
oracle           soft    nofile          1024
oracle           hard    nofile          65536
oracle           soft    stack           10240

vi /etc/pam.d/login

session    required     /lib64/security/pam_limits.so
session    required     pam_limits.so

4. 创建安装目录

1
2
3
4
mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome_1
mkdir -p /u01/app/oracle/oradata
mkdir -p /u01/app/oracle/recovery_data
mkdir -p /u01/app/oracle/oraInventory

5. 修改权限

1
2
chown -R oracle:oinstall /u01/app
chmod 775 /u01/app/oracle

6. 修改用户环境变量

1
2
3
4
5
6
7
vi .bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

7. 设置生效

1
source .bash_profile

安装

1. 修改db_install.rsp 安装应答配置文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oinstall
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.password.ALL=system
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u01/app/oracle/recovery_data
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

2. 执行安装

1
./runInstaller -silent -force -waitforcompletion -ignoresysprereqs -ignoreprereq -responsefile /opt/database/response/db_install.rsp

3. 以root身份执行以下脚本

1
2
/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0/db_1/root.sh

4. 配置监听文件

1
netca -silent -responsefile /opt/database/response/netca.rsp

5. 修改配置文件response/dbca.rsp，静默建立新库

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
dbca -silent -createdatabase -responsefile /opt/database/response/dbca.rsp
gdbName=orcl
sid=orcl
databaseConfigType=SI
policyManaged=false
createServerPool=false
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=orclpdb
useLocalUndoForPDBs=true
templateName=/u01/app/oracle/product/12.2.0.1/dbhome_1/assistants/dbca/templates/General_Purpose.dbc
dvConfiguration=false
datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/
datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/
recoveryAreaDestination={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}
storageType=FS
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
listeners=LISTENER
variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1,SID=orcl
initParams=undo_tablespace=UNDOTBS1,memory_target=796MB,processes=300,db_recovery_file_dest_size=2780MB,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_recovery_file_dest={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME},db_block_size=8192BYTES,diagnostic_dest={ORACLE_BASE},audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,nls_territory=AMERICA,local_listener=LISTENER_CDB1,compatible=12.2.0,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl"),db_name=cdb1,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,open_cursors=300
sampleSchema=false
memoryPercentage=40
databaseType=MULTIPURPOSE
automaticMemoryManagement=true
totalMemory=0
开发 > 数据库 > Oracle
#Oracle
Linux静默安装Oracle
https://touchhanyu.cn/2022/10/26/code/db/oracle/oracle-install/
作者
皮蛋瘦肉粥
发布于
2022年10月26日
许可协议