签到成功

知道了

CNDBA社区CNDBA社区

suse 12静默安装oracle 19c

2022-04-01 22:25 2412 1 原创 oracle
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/107904

1.使用zypper安装软件包

zypper in -y gcc bc binutils glibc glibc-devel insserv-compat libaio-devel libaio1 libX11-6 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz compat-libpthread-nonshared readline-devel

2.查看是否缺失软件包http://www.cndba.cn/hbhe0316/article/107904http://www.cndba.cn/hbhe0316/article/107904

rpm -q gcc bc binutils glibc glibc-devel insserv-compat libaio-devel libaio1 libX11-6 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz compat-libpthread-nonshared readline-devel --qf '%{name}.%{arch}/n' | grep "未安装软件包" | wc -l

3.修改内核文件http://www.cndba.cn/hbhe0316/article/107904

vim /etc/sysctl.conf 
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

linux-8c00:/mnt/sles # sysctl -p
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

4.修改limits.conf文件http://www.cndba.cn/hbhe0316/article/107904http://www.cndba.cn/hbhe0316/article/107904

vim /etc/security/limits.conf
oracle  soft  nproc  2047
oracle  hard  nproc  16384
oracle  soft  nofile  1024
oracle  hard  nofile  65536
oracle  soft  stack  10240
oracle  hard  stack  32768
oracle soft memlock 3145728
oracle hard memlock 3145728

5.修改/etc/pam.d/login

http://www.cndba.cn/hbhe0316/article/107904 

vim /etc/pam.d/login
添加以下内容
session required pam_limits.so

6.suse12关闭防火墙http://www.cndba.cn/hbhe0316/article/107904

systemctl stop SuSEfirewall2.service
systemctl disable SuSEfirewall2.service

7.添加用户

/usr/sbin/useradd -g oinstall -G oper,dba,asmdba,backupdba,dgdba,kmdba,racdba oracle

8.新建文件夹http://www.cndba.cn/hbhe0316/article/107904

linux-8c00:/mnt/sles # mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
linux-8c00:/mnt/sles # chown -R oracle:oinstall /u01
linux-8c00:/mnt/sles # chmod -R 775 /u01/

9.添加.profile文件

http://www.cndba.cn/hbhe0316/article/107904 

oracle@linux-8c00:~> cat .profile 
ORACLE_SID=orcl;export ORACLE_SID  
ORACLE_UNQNAME=orcl;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS"; export NLS_DATE_FORMAT
#NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
export NLS_LANG=AMERICAN_AMERICA.UTF8
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
oracle@linux-8c00:~> . .profile

10.解压文件http://www.cndba.cn/hbhe0316/article/107904

linux-8c00:/home # cd /tmp/
linux-8c00:/tmp # chown oracle:oinstall LINUX.X64_193000_db_home.zip
linux-8c00:/tmp # su - oracle
oracle@linux-8c00:~> unzip -d /u01/app/oracle/product/19.3.0/dbhome_1/ /tmp/LINUX.X64_193000_db_home.zip

11.安装软件

su - oracle
/u01/app/oracle/product/19.3.0/dbhome_1/runInstaller -silent  -force -noconfig  -ignorePrereq /
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 /
oracle.install.option=INSTALL_DB_SWONLY /
UNIX_GROUP_NAME=oinstall /
INVENTORY_LOCATION=/u01/app/oraInventory /
ORACLE_BASE=/u01/app/oracle /
ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 /
oracle.install.db.InstallEdition=EE /
oracle.install.db.OSDBA_GROUP=dba /
oracle.install.db.OSOPER_GROUP=oper /
oracle.install.db.OSBACKUPDBA_GROUP=backupdba /
oracle.install.db.OSDGDBA_GROUP=dgdba /
oracle.install.db.OSKMDBA_GROUP=kmdba /
oracle.install.db.OSRACDBA_GROUP=racdba /
oracle.install.db.rootconfig.executeRootScript=true /
oracle.install.db.rootconfig.configMethod=ROOT

12.安装实例

su - oracle
dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE /
-gdbname orcl  -sid orcl /
-createAsContainerDatabase TRUE /
-numberOfPDBs 1 /
-pdbName pdb01 /
-pdbAdminPassword wwwwww /
-sysPassword wwwwww -systemPassword wwwwww /
-datafileDestination '/u01/app/oracle/oradata' /
-recoveryAreaDestination '/u01/app/oracle/flash_recovery_area' /
-redoLogFileSize 50 /
-storageType FS /
-characterset AL32UTF8 -nationalCharacterSet AL16UTF16 /
-sampleSchema true /
-totalMemory 2048 /
-databaseType OLTP  /
-emConfiguration NONE

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：1151895次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ