从前慢现在也慢

这个屌丝很懒，什么也没留下！

热门标签

麒麟V10 sp2 安装oracle 11g

作者：从前慢现在也慢 | 2024-03-02 22:21:56

踩

麒麟v10 sp2

一、前期环境准备工作

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/

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

####################################################################

## ##

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

主窗口回车完成安装

六、安装完数据库软件需要重新编译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

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

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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/从前慢现在也慢/article/detail/182729