银河麒麟v10SP3安装Oracle10G指南

有图有真相

内容仅用于学习与测试

---

root账号登入

上传ky10_ora10g_deps.zip

unzip ky10_ora10g_deps.zip

cat > /etc/yum.repos.d/kylin_x86_64.repo << EOF

[gui_deps]

name = gui_deps

baseurl = file:///root/ky10_ora10g_deps/gui_deps

gpgcheck = 1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-kylin

enabled = 1

EOF

yum install "Server with UKUI GUI" -y

rpm -iUvh ky10_ora10g_deps/oracle_deps/*/*.rpm ky10_ora10g_deps/gui_deps/glibc-2.28-88.p09.ky10.x86_64.rpm --force

cat > /etc/sysctl.conf << EOF

# sysctl settings are defined through files in

# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.

#

# Vendors settings live in /usr/lib/sysctl.d/.

# To override a whole file, create a new file with the same in

# /etc/sysctl.d/ and put new settings there. To override

# only specific settings, add a file with a lexically later

# name in /etc/sysctl.d/ and put new settings there.

#

# For more information, see sysctl.conf(5) and sysctl.d(5).

kernel.sysrq=0

net.ipv4.ip_forward=0

net.ipv4.conf.all.send_redirects=0

net.ipv4.conf.default.send_redirects=0

net.ipv4.conf.all.accept_source_route=0

net.ipv4.conf.default.accept_source_route=0

net.ipv4.conf.all.accept_redirects=0

net.ipv4.conf.default.accept_redirects=0

net.ipv4.conf.all.secure_redirects=0

net.ipv4.conf.default.secure_redirects=0

net.ipv4.icmp_echo_ignore_broadcasts=1

net.ipv4.icmp_ignore_bogus_error_responses=1

net.ipv4.conf.all.rp_filter=1

net.ipv4.conf.default.rp_filter=1

net.ipv4.tcp_syncookies=1

kernel.dmesg_restrict=1

net.ipv6.conf.all.accept_redirects=0

net.ipv6.conf.default.accept_redirects=0

kernel.shmall = 4294967296

kernel.shmmax = 68719476736

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max=262144

vm.hugetlb_shm_group=1003

EOF

cat >>  /etc/security/limits.conf << EOF

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

EOF

#cat >> /etc/pam.d/login <<EOF

#session    required     /lib64/secuirity/pam_limits.so

#session    required     pam_limits.so

#EOF

cat > /etc/locale.conf  <<EOF

LANG="en_US.UTF-8"

EOF

groupadd -g 500 oinstall

groupadd -g 501 dba

useradd -d /home/oracle -u 500 -g oinstall -G dba oracle

chown -R oracle:oinstall /home/oracle

echo 'Huawei12#$' |passwd oracle --stdin

mkdir -p /opt/oracle

chown oracle:oinstall -R /opt/oracle

systemctl enable xrdp

systemctl disable firewalld.service

systemctl set-default multi-user.target

systemctl disable kylin-kms-activation.service

systemctl mask tmp.mount

reboot

Oracle账号登入

上传jdk-7u80-linux-x64.tar.gz、10201_database_linux_x86_64.cpio.gz 、p8202632_10205_Linux-x86-64.zip

tar -zxvf   jdk-7u80-linux-x64.tar.gz

cat >> ~/.bashrc << EOF

alias gcc=gcc34

alias g++=g++34

alias ld='ld --copy-dt-needed-entries'

export JAVA_HOME=/home/oracle/jdk1.7.0_80

export JRE_HOME=\${JAVA_HOME}/jre

export CLASSPATH=.:\${JAVA_HOME}/lib:\${JRE_HOME}/lib

export PATH=\${JAVA_HOME}/bin:\${JRE_HOME}/bin:\$PATH

export LD_LIBRARY_PATH=\${JAVA_HOME}/lib:\${JRE_HOME}/lib:\${LD_LIBRARY_PATH}

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=\${ORACLE_BASE}/product/10.2.0.5.0/db_1

export ORACLE_SID=orcl

export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${LD_LIBRARY_PATH}

export PATH=\${ORACLE_HOME}/bin:\$PATH

set sqlprompt "_user'@'_connect_identifier"

export ORACLE_HOSTNAME=localhost4

ulimit -p 16384

ulimit -n 65536

EOF

oracle账号

gzip -d 10201_database_linux_x86_64.cpio.gz

cpio -ivd < 10201_database_linux_x86_64.cpio

cd ~/database

cp /usr/bin/unzip install/

./runInstaller -ignoreSysPrereqs

vi ${ORACLE_HOME}/rdbms/lib/ins_rdbms.mk

    804 liborasdkbase: $(LIBORASDKBASE_DEPS)

    805         $(SILENT)$(ECHO)

    806         $(SILENT)$(ECHO) " - Linking liborasdkbase"

    807         -DBUILD_SHARED_LIBS=ON $(GENORASDKBASE)

    808

    809 liborasdksh: $(LIBORASDKSH_DEPS)

    810         $(SILENT)$(ECHO)

    811         $(SILENT)$(ECHO) " - Linking liborasdk"

    812         -DBUILD_SHARED_LIBS=ON $(GENORASDKSH)

   

vi ${ORACLE_HOME}/db_1/sysman/lib/ins_emdb.mk

     64 $(SYSMANBIN)nmccollector:

     65         -DBUILD_SHARED_LIBS=ON $(MK_EMDB_COLLECTOR)

unzip  p8202632_10205_Linux-x86-64.zip

cd ~/Disk1

cp /usr/bin/unzip install/

./runInstaller -ignoreSysPrereqs

vi ${ORACLE_HOME}/sysman/lib/ins_emdb.mk

     74 $(SYSMANBIN)nmccollector:

     75         -DBUILD_SHARED_LIBS=ON $(MK_EMDB_COLLECTOR)

vi ${ORACLE_HOME}/rdbms/lib/ins_rdbms.mk

    875 liborasdkbase: $(LIBORASDKBASE_DEPS)

    876         $(SILENT)$(ECHO)

    877         $(SILENT)$(ECHO) " - Linking liborasdkbase"

    878         -DBUILD_SHARED_LIBS=ON $(GENORASDKBASE)

    879

    880 liborasdksh: $(LIBORASDKSH_DEPS)

    881         $(SILENT)$(ECHO)

    882         $(SILENT)$(ECHO) " - Linking liborasdk"

    883         -DBUILD_SHARED_LIBS=ON $(GENORASDKSH)

root账号

bash ${ORACLE_HOME}/root.sh

Oracle账号操作：

dbca

 

echo '/bin/ksh' >> ~/.bashrc

备注：

ISO下载地址

网站：https://distro-images.kylinos.cn:8802/web_pungi/download/share/Dq5r12WhYyFwAcnZP4JeGXkbsEHOBM0N/Kylin-Server-V10-SP3-General-Release-2303-X86_64.iso

md5: dc6714c6b29c7a05a1f167918e95273e

网盘：https://pan.baidu.com/s/1NQfLSydWr0W5fjpZCibDqg?pwd=1234

repo源地址

https://update.cs2c.com.cn/NS/V10/V10SP3/os/adv/lic/

文中描述软件连接

链接：https://pan.baidu.com/s/1hb8vTwvZeDW-V5dKe1CGTw?pwd=

压缩包内文件

ky10_ora10g_deps.zip目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d-----         2024/3/17      0:23                gui_deps
d-----         2024/3/17      0:27                oracle_deps

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\gui_deps

同Index of /NS/V10/V10SP3/os/adv/lic/base/x86_64/

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\oracle_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d-----         2024/3/16     23:07                downgrade_deps
d-----         2024/3/16     23:10                i686_deps
d-----         2024/3/17      1:11                other_deps
d-----         2024/3/16     23:14                tools_deps

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\oracle_deps\downgrade_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
------         2024/3/16     17:49        5659368 binutils-2.27-44.base.0.3.ky10.1.x86_64.rpm
------         2024/3/16     17:49         921684 binutils-devel-2.27-44.base.0.3.ky10.1.x86_64.rpm
------         2022/8/23     15:23        3753252 compat-gcc-34-3.4.6-4.1.ky10.x86_64.rpm
------         2022/8/23     18:26       10200764 compat-gcc-34-c++-3.4.6-4.1.ky10.x86_64.rpm
------         2022/8/23     19:38         232774 compat-libstdc++-33-3.2.3-61.x86_64.rpm
------         2024/3/15     17:35        7772600 cpp-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     17:35       14540828 gcc-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18        8461984 gcc-c++-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18         377720 libasan-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18          19944 libatomic-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18          73532 libgcc-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     17:35         118504 libgomp-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18          60556 libitm-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18         375252 libstdc++-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18        1174520 libstdc++-devel-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm
------         2024/3/15     21:18         612840 libstdc++-static-7.3.0-20190804.h30.pf01.ky10.x86_64.rpm

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\oracle_deps\i686_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
------         2024/3/15      8:07        3550016 glibc-2.28-36.1.pf01.ky10.i686.rpm
------         2024/3/15      8:07        1826064 glibc-devel-2.28-36.1.pf01.ky10.i686.rpm
------         2024/3/15     17:35          81284 libgcc-7.3.0-20190804.h30.pf01.ky10.i686.rpm
------         2024/3/14      2:47         123562 libICE-1.0.1-2.1.i686.rpm
------         2024/3/10     23:01          54492 libnsl-2.28-36.1.pf01.ky10.i686.rpm
------         2024/3/14      2:50          55822 libSM-1.0.1-3.1.i686.rpm
------         2024/3/16     17:55          86188 libuuid-2.23.2-65.0.4.1.i686.rpm
------         2024/3/14      5:43        3101939 libX11-1.0.3-11.1.i686.rpm
------         2024/3/14      4:37          25351 libXau-1.0.1-3.1.i686.rpm
------         2024/3/16     17:55         233824 libxcb-1.13-1.i686.rpm
------         2024/3/13     23:22         118712 libxcrypt-4.4.8-4.pf01.ky10.i686.rpm
------         2024/3/13     23:22         119740 libxcrypt-devel-4.4.8-4.pf01.ky10.i686.rpm
------         2024/3/14      5:35          29761 libXdmcp-1.0.1-2.1.i686.rpm
------         2024/3/14      4:39         187147 libXext-1.0.1-2.1.i686.rpm
------         2024/3/15     16:19         220529 libXi-1.0.1-4.i686.rpm
------         2024/3/14      5:28         102448 libXp-1.0.0-8.1.i686.rpm
------         2024/3/14      5:30         625394 libXt-1.0.2-3.2.i686.rpm
------         2024/3/14      5:47          51230 libXtst-1.0.1-3.1.i686.rpm

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\oracle_deps\other_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
------         2024/3/16     22:40         606132 elfutils-0.180-13.ky10.x86_64.rpm
------         2024/3/16     22:40         379088 elfutils-devel-0.180-13.ky10.x86_64.rpm
------         2024/3/16     22:40         230824 elfutils-extra-0.180-13.ky10.x86_64.rpm
------         2024/3/16     22:40          34276 elfutils-help-0.180-13.ky10.x86_64.rpm
-a----         2024/3/17      0:54        2975196 glibc-devel-2.28-88.p09.ky10.x86_64.rpm
------         2024/3/16     22:47         746432 ksh-2020.0.0-4.ky10.x86_64.rpm
------         2024/3/16     22:50          10364 libaio-devel-0.3.112-1.p01.ky10.x86_64.rpm
------         2024/3/16     22:40          68624 libmicrohttpd-0.9.59-8.ky10.x86_64.rpm
------         2024/3/16     22:40        7673356 libmicrohttpd-help-0.9.59-8.ky10.noarch.rpm
-a----          2023/8/2     13:51          44676 libnsl-2.28-88.p09.ky10.x86_64.rpm
-a----         2024/3/17      0:54         106760 libxcrypt-devel-4.4.16-2.ky10.x86_64.rpm
------        2022/12/20     14:36          29108 libXp-1.0.3-6.ky10.x86_64.rpm
------         2024/3/16     22:49          16424 libXp-devel-1.0.3-6.ky10.x86_64.rpm
------         2024/3/16     22:54         639128 nss-3.54.0-9.p04.ky10.x86_64.rpm
------         2024/3/16     22:54         674152 nss-softokn-3.54.0-9.p04.ky10.x86_64.rpm
------         2024/3/16     22:54         452008 nss-util-3.54.0-9.p04.ky10.x86_64.rpm
------         2024/3/14      5:33           5438 xorg-x11-filesystem-7.1-2.noarch.rpm

    目录: ky10_ora10g_deps.zip\oracle10g_x86_64\ky10_ora10g_deps\oracle_deps\tools_deps

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
------         2024/3/10     21:46         437296 xrdp-0.9.24-1.ky10.x86_64.rpm