龙蜥anolis系统oracle11g安装包

#!/bin/bash :<<Liushui 时间：2021-08-31 作者：刘水 功能：用于在宿主机上安装oracle以及导入数据，支持阿里龙蜥系统 Liushui echo '停用docker' sudo systemctl stop docker sudo systemctl disable docker echo '删除docker虚拟网卡' sudo ip link delete docker0 #设置安装包所需要引用的文件 #:<<BLOCK echo '安装前准备' sudo rpm -Uvh ./pac/depend/*.rpm #sudo reboot echo '安装并启动oracle' echo '安装...' sudo rpm -Uvh ./pac/oracle-xe-11.2.0-1.0.x86_64.rpm echo 配置oracle sudo /etc/init.d/oracle-xe configure <<EOF 18080 1521 sysadmin sysadmin y EOF echo 配置环境变量 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe export ORACLE_SID=XE export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` export ORACLE_BASE=/u01/app/oracle export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH sudo echo -e '\nexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe\nexport ORACLE_SID=XE\nexport NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`\nexport ORACLE_BASE=/u01/app/oracle\nexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH\nexport PATH=$ORACLE_HOME/bin:$PATH'>>~/.bashrc #创建用户scott并设置权限 echo 将当前用户加入oracle dba组 sudo usermod -a -G dba sspss echo 启动服务 sudo systemctl start oracle-xe #BLOCK chmod +x ../tools/navicat15-premium-cs.AppImage echo 加载环境变量 source ~/.bashrc #结果为root #sudo ./install 执行的脚本 用户是root whoami echo 设置 sqlplus system/oracle as sysdba <<EOF ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; select LIMIT from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; alter system set audit_sys_operations=TRUE scope=spfile; alter system set audit_trail=db,extended scope=spfile; @?/rdbms/admin/utlpwdmg.sql alter system set resource_limit = true; alter profile default limit password_verify_function verify_function; create user scott identified by Ocl_1245; grant dba to scott; alter user scott identified by Ocl_1245 account unlock; commit; exit EOF #导入dmp文件至数据库 imp scott/Ocl_1245@xe file=../res/xe.dmp full=y