一、前期环境准备工作
1.1检查gcc组件版本
[root@kylindb1 ~]# gcc -v
Using built-in specs.
COLLECT_GCC=gcc
COLLECT_LTO_WRAPPER=/usr/libexec/gcc/x86_64-linux-gnu/7.3.0/lto-wrapper
Target: x86_64-linux-gnu
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-linker-build-id --with-linker-hash-style=gnu --enable-languages=c,c++,objc,obj-c++,fortran,lto --enable-plugin --enable-initfini-array --disable-libgcj --without-isl --without-cloog --enable-gnu-indirect-function --build=x86_64-linux-gnu --with-stage1-ldflags=' -Wl,-z,relro,-z,now' --with-boot-ldflags=' -Wl,-z,relro,-z,now' --with-tune=generic --with-arch_32=x86-64 --disable-multilib
Thread model: posix
gcc version 7.3.0 (GCC)
1.2检查jdk版本
即使有了jdk还是建议用oracle官网下载的jdk
[root@kylindb1 ~]# java -version
openjdk version "1.8.0_272"
OpenJDK Runtime Environment Bisheng (build 1.8.0_272-b10)
OpenJDK 64-Bit Server VM Bisheng (build 25.272-b10, mixed mode)
1.3卸载jdk
[root@kylindb1 soft]# cd jdk/
[root@kylindb1 jdk]# ls
jdk-8u371-linux-x64.rpm
[root@kylindb1 jdk]# which java
/usr/bin/java
[root@kylindb1 jdk]# rm -rf /usr/bin/java
[root@kylindb1 jdk]# rpm -qa |grep java
java-1.8.0-openjdk-1.8.0.272.b10-7.ky10.x86_64
javapackages-filesystem-5.3.0-2.ky10.noarch
tzdata-java-2020a-8.p01.ky10.noarch
java-11-openjdk-11.0.9.11-4.ky10.x86_64
java-11-openjdk-headless-11.0.9.11-4.ky10.x86_64
javapackages-tools-5.3.0-2.ky10.noarch
java-1.8.0-openjdk-headless-1.8.0.272.b10-7.ky10.x86_64
[root@kylindb1 jdk]# rpm -qa | grep java | xargs rpm -e --nodeps
/sbin/ldconfig: /usr/lib64/libLLVM-7.so is not a symbolic link
##重新查询
[root@kylindb1 jdk]# rpm -qa |grep java
1.4安装jdk
[root@kylindb1 jdk]# rpm -ivh jdk-8u371-linux-x64.rpm
warning: jdk-8u371-linux-x64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:jdk-1.8-2000:1.8.0_371-11 ################################# [100%]
/sbin/ldconfig: /usr/lib64/libLLVM-7.so is not a symbolic link
[root@kylindb1 jdk]# cd /usr/lib64
[root@kylindb1 lib64]# ln -sf libLLVM-7.0.0.so libLLVM-7.so
##查看jdk版本
[root@kylindb1 lib64]# java -version
java version "1.8.0_371"
Java(TM) SE Runtime Environment (build 1.8.0_371-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.371-b11, mixed mode)
[root@kylindb1 lib64]# which java
/usr/bin/java
##jdk安装完成
[root@kylindb1 lib64]# find / -name java
/etc/pki/ca-trust/extracted/java
/etc/pki/java
/etc/alternatives/java
/var/lib/alternatives/java
/usr/bin/java
/usr/lib/java
/usr/lib/jvm/jdk-1.8-oracle-x64/bin/java
/usr/lib/jvm/jdk-1.8-oracle-x64/jre/bin/java
/usr/lib/jvm/jdk-1.8-oracle-x64/sample/jnlp/servlet/apps/app1/src/java
/usr/lib/jvm/jdk-1.8-oracle-x64/sample/jnlp/servlet/apps/app2/src/java
/usr/lib/jvm/jdk-1.8-oracle-x64/sample/jnlp/servlet/apps/app3/src/java
/usr/share/java
/usr/share/bash-completion/completions/java
/usr/java
1.5coredump 文件管理设置
将默认 /var/lib/systemd/coredump 改为 /corefile
[root@kylindb1 lib64]# mkdir /corefile
[root@kylindb1 lib64]# chmod 777 /corefile/
[root@kylindb1 lib64]# sysctl -w kernel.core_pattern=/corefile/core_%e_%p_%t_%s
kernel.core_pattern = /corefile/core_%e_%p_%t_%s
二、操作系统配置
2.1主机名、域名解析检查与配置
[root@localhost ~]# vi /etc/hostname
[root@localhost ~]# vi /etc/hosts
[root@localhost ~]# vi /etc/selinux/config
[root@localhost ~]# cat /etc/hostname
kylin11g
[root@localhost ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.213.60 kylin11g
2.2selinux禁用
[root@localhost ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# ukmls - Multi Level Security protection.
# ukmcs -ukmcs variants of the SELinux policy.
SELINUXTYPE=ukmcs
# SETLOCALDEFS= Check local definition changes
SETLOCALDEFS=0
2.3关闭防火墙
[root@localhost ~]# systemctl stop firewalld.service
[root@localhost ~]# systemctl disable firewalld.service
Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
2.4配置yum源
[root@kylindb1 ~]# mkdir /mnt/cdrom
[root@kylindb1 ~]# mount /dev/cdrom /mnt/cdrom
mount: /mnt/cdrom: WARNING: source write-protected, mounted read-only.
[root@kylindb1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.2G 0 7.2G 0% /dev
tmpfs 7.2G 0 7.2G 0% /dev/shm
tmpfs 7.2G 9.6M 7.2G 1% /run
tmpfs 7.2G 0 7.2G 0% /sys/fs/cgroup
/dev/mapper/klas-root 75G 11G 65G 14% /
tmpfs 7.2G 4.0K 7.2G 1% /tmp
/dev/sda1 1014M 211M 804M 21% /boot
tmpfs 1.5G 0 1.5G 0% /run/user/0
tmpfs 1.5G 0 1.5G 0% /run/user/993
/dev/sr0 4.1G 4.1G 0 100% /mnt/cdrom
cd /etc/yum.repos.d/
ls
kylin_x86_64.repo
mv kylin_x86_64.repo kylin_x86_64.repo.bak
vi kylin.repo
[root@kylindb1 yum.repos.d]# mv kylin_x86_64.repo kylin_x86_64.repo.bak
[root@kylindb1 yum.repos.d]# vi kylin_local.repo
[root@kylindb1 yum.repos.d]# cat kylin_local.repo
[base-local]
name=kylin-source
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0
yum clean all
yum makecache
yum list
2.5操作系统相关配置文件
[root@kylindb1 ~]# vi /etc/security/limits.conf
[root@kylindb1 ~]# cat /etc/security/limits.conf
oracle soft nproc 10240
oracle hard nproc 16384
oracle soft nofile 10240
oracle hard nofile 65536
Oracle soft stack 10240
[root@kylin11g ~]# cd /etc/sysctl.d/
[root@kylin11g sysctl.d]# ls
50-libreswan.conf 99-sysctl.conf
[root@kylindb1 ~]# vi /etc/sysctl.conf
[root@kylindb1 ~]# cat /etc/sysctl.conf
# use for oracle11gR2
kernel.shmmax = 2147483648
kernel.shmall = 268435456
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
# 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
# 262144
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#tuxedo
kernel.msgmni = 4096
kernel.msgmax = 65536
kernel.msgmnb = 84000
sysctl --system
三、安装依赖包
依赖包有些需要单独下可以到rpm网站下载
yum install ksh
yum install libaio-devel*
yum install elfutils*
yum install gcc*
##创建目录用于存准备好的rpm包
[root@kylindb1 bin]# mkdir -p /soft/rpm
[root@kylindb1 bin]# cd /soft
[root@kylindb1 soft]# mkdir jdk
[root@kylindb1 soft]#
[root@kylindb1 soft]# cd rpm/
[root@kylindb1 rpm]# ls -ll
=======一下是提前下好的rpm包=========
-rw-r--r-- 1 root root 19112 Oct 18 03:50 compat-libcap1-1.10-7.el7.x86_64.rpm
-rw-r--r-- 1 root root 195388 Oct 18 03:50 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
-rw-r--r-- 1 root root 765172 Oct 18 03:49 elfutils-0.180-1.ky10.x86_64.rpm
-rw-r--r-- 1 root root 379324 Oct 18 03:49 elfutils-devel-0.180-1.ky10.x86_64.rpm
-rw-r--r-- 1 root root 34656 Oct 18 03:49 elfutils-help-0.180-1.ky10.x86_64.rpm
-rw-r--r-- 1 root root 199352 Oct 18 03:50 elfutils-libelf-0.176-5.el7.x86_64.rpm
-rw-r--r-- 1 root root 40716 Oct 18 03:50 elfutils-libelf-devel-0.176-5.el7.x86_64.rpm
-rw-r--r-- 1 root root 77944 Oct 18 03:50 elfutils-libelf-devel-static-0.176-5.el7.x86_64.rpm
-rw-r--r-- 1 root root 706340 Oct 18 03:50 glibc-headers-2.17-317.el7.x86_64.rpm
-rw-r--r-- 1 root root 1631912 Oct 18 03:50 glibc-static-2.17-317.el7.x86_64.rpm
-rw-r--r-- 1 root root 746432 Oct 18 03:49 ksh-2020.0.0-4.ky10.x86_64.rpm
-rw-r--r-- 1 root root 24744 Oct 18 03:50 libaio-0.3.109-13.el7.x86_64.rpm
-rw-r--r-- 1 root root 13176 Oct 18 03:50 libaio-devel-0.3.109-13.el7.x86_64.rpm
-rw-r--r-- 1 root root 56928 Oct 18 03:49 libnsl2-1.3.0-1.ky10.x86_64.rpm
-rw-r--r-- 1 root root 45828 Oct 18 03:50 libnsl-2.28-36.1.ky10.x86_64.rpm
-rw-r--r-- 1 root root 48260 Oct 18 03:49 libnsl-2.28-49.p02.ky10.x86_64.rpm
-rw-r--r-- 1 root root 34496 Oct 18 03:49 libnsl2-devel-1.3.0-1.ky10.x86_64.rpm
##批量安装
rpm -ivh *.rpm --nodeps --force
##检查
[root@kylindb1 rpm]# rpm -qa|grep compat
authselect-compat-1.2.1-1.ky10.x86_64
polkit-pkla-compat-0.1-17.ky10.x86_64
compat-libstdc++-33-3.2.3-72.el7.x86_64
compat-libcap1-1.10-7.el7.x86_64
[root@kylindb1 rpm]# rpm -qa|grep glibc
glibc-2.28-49.p02.ky10.x86_64
glibc-headers-2.17-317.el7.x86_64
glibc-devel-2.28-49.p02.ky10.x86_64
glibc-static-2.17-317.el7.x86_64
glibc-common-2.28-49.p02.ky10.x86_64
[root@kylindb1 rpm]# rpm -qa|grep libnsl
libnsl-2.28-36.1.ky10.x86_64
libnsl2-1.3.0-1.ky10.x86_64
libnsl2-devel-1.3.0-1.ky10.x86_64
libnsl-2.28-49.p02.ky10.x86_64
四、创建用户组及安装目录
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle
id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper)
mkdir -p /u01/app/oracle/product/11.2.0.4/db_home1
chown -R oracle:oinstall /u01/
chmod 775 /u01/
五、安装数据库
5.1上传数据库安装包并解压
[root@kylindb1 soft]# ls -ll
total 2487204
drwxr-xr-x 7 root root 136 Aug 27 2013 database
drwxr-xr-x 2 root root 37 Oct 18 03:49 jdk
-rw-r--r-- 1 root root 1395582860 Oct 18 04:35 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Oct 18 04:35 p13390677_112040_Linux-x86-64_2of7.zip
drwxr-xr-x 2 root root 4096 Oct 18 03:50 rpm
[root@kylindb1 soft]# chown -R oracle:oinstall database/
[root@kylindb1 soft]# chmod -R 775 database/
5.2配置环境变量
[root@kylindb1 ~]# ls -ld /home/oracle
drwx------ 3 oracle oinstall 92 Oct 18 04:32 /home/oracle
[root@kylindb1 ~]# chmod -R 775 /home/oracle/
[root@kylindb1 ~]# ls -ld /home/oracle
drwxrwxr-x 3 oracle oinstall 92 Oct 18 04:32 /home/oracle
vi .bash_profile
export ORACLE_SID=kylin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_home1
export PATH=$ORACLE_HOME/bin:$PATH
[oracle@kylin11g ~]$ . .bash_profile
5.3准备响应文件
响应文件模板在response目录下建议将所有相应文件拷贝到其他目录如:/home/oracle
oracle@kylindb1 ~]$ cat db_install.rsp
####################################################################
## 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=kylindb1
#-------------------------------------------------------------------------------
# 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=/u01/app/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=en,zh_CN
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_home1/
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/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=oper
#------------------------------------------------------------------------------
# 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=false
#------------------------------------------------------------------------------
# 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=kylin
#------------------------------------------------------------------------------
# Specify the Starter Database SID.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=kylin
#------------------------------------------------------------------------------
# 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=
#------------------------------------------------------------------------------
# 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=“oracle_4U"
#-------------------------------------------------------------------------------
# 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=
#-------------------------------------------------------------------------------
# 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=
#-------------------------------------------------------------------------------
# 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=false
#------------------------------------------------------------------------------
# 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=
5.4静默安装数据库软件
[oracle@kylindb1 database]$ ./runInstaller -silent -responseFile /home/oracle/db_install.rsp -ignorePrereq
此时执行root脚本
[root@kylindb1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@kylindb1 ~]# /u01/app/oracle/product/11.2.0.4/db_home1/root.sh
Check /u01/app/oracle/product/11.2.0.4/db_home1/install/root_kylindb1_2023-10-18_05-13-11.log for the output of root script
[root@kylindb1 ~]# tail -f /u01/app/oracle/product/11.2.0.4/db_home1/install/root_kylindb1_2023-10-18_05-13-11.log
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Finished product-specific root actions.
主窗口回车完成安装
六、安装完数据库软件需要重新编译oracle
如果操作系统没有该库需要准备
[root@kylindb1 ~]# cd /home/oracle/
[root@kylindb1 oracle]# ls
dbca.rsp db_install.rsp libpthread_nonshared.a netca.rsp
[root@kylindb1 oracle]# cp libpthread_nonshared.a /usr/lib64/
[root@kylindb1 oracle]# chmod 755 /usr/lib64/libpthread_nonshared.a
[root@kylindb1 etc]# cd /etc/alternatives/
[root@kylindb1 alternatives]# ln -sf /usr/bin/ld.gold ld
[root@kylindb1 alternatives]# su - oracle
Last login: Wed Oct 18 05:01:22 CST 2023 on pts/1
[oracle@kylindb1 ~]$ cd $ORACLE_HOME/bin
[oracle@kylindb1 bin]$ ./relink all
writing relink log to: /u01/app/oracle/product/11.2.0.4/db_home1/install/relink.log
##编译完成
六、创建监听程序
[oracle@kylindb1 ~]$ netca -silent -responsefile /home/oracle/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0.4/db_home1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@kylindb1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-OCT-2023 05:25:53
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 18-OCT-2023 05:24:41
Uptime 0 days 0 hr. 1 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/db_home1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/kylindb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kylindb1)(PORT=1521)))
The listener supports no services
The command completed successfully
七、dbca建库
建库前需要改组否则无法创建成功麒麟的小bug
在oracle_home/rdbms/lib/config.c
改组
[oracle@kylindb1 db_home1]$ vi rdbms/lib/config.c
oper dba 都改成oinstall
relink all
[oracle@kylindb1 ~]$ dbca -silent -responseFile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/kylin/kylin0.log" for further details.
[oracle@kylindb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 18 16:41:25 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string kylin
db_unique_name string kylin
global_names boolean FALSE
instance_name string kylin
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string kylin
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
KYLIN READ WRITE
八、重新配置监听文件
[oracle@kylindb1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/db_home1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME = kylin)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/db_home1/)
(SID_NAME = kylin)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.213.60)(PORT = 1521))
)
)
tnsnames也建议把主机名改为ip地址
lsnrctl stop
lsnrctl start
1301
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
