##Anolis OS 8.10 安装oracle19c
 
 
 
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
LINUX.X64_193000_db_home.zip
 
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm
oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm
 
 

vi /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 262144000 
oracle hard memlock 262144000 
 
 
yum clean all
yum makecache 

wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm
wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

rpm -ivh compat-lib* 

 
##关闭防火墙和SELinux 
systemctl stop firewalld 
 
yum localinstall -y oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm   

sysctl -p  /etc/sysctl.conf
 
 
vi /home/oracle/.bash_profile
 
 
 
export ORACLE_SID=syntong
export ORACLE_HOSTNAME=`hostname -s`
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$HOME/.local/bin:$HOME/bin:$PATH
export EDITOR=vi
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_PATH=.:$ORACLE_BASE/dba_scripts/sql:$ORACLE_HOME/rdbms/admin
export SQLPATH=$ORACLE_HOME/sqlplus/admin
 
 
source /home/oracle/.bash_profile
 
 
mkdir -p /data/oracle/product/19c/db_1
mkdir -p /data/oracle/oraInventory
chown -R oracle:oinstall /data/oracle
 
cd /root
unzip LINUX.X64_193000_db_home.zip -d /data/oracle/product/19c/db_1
chown -R oracle:oinstall /data/oracle

yum install libnsl -y  ##error while loading shared libraries: .1: cannot open shared object file: No such file or directory
 
#安装软件
su - oracle
export CV_ASSUME_DISTID=RHEL7.6    ##supportedoscheck问题 ，欺骗oracle让软件认为操作系统是红帽7.6

/data/oracle/product/19c/db_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=/data/oracle/oraInventory \
ORACLE_BASE=/data/oracle \
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
 
##不创建容器数据库 ，创建实例syntong
dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
-gdbname syntong -sid syntong \
-createAsContainerDatabase false \
-sysPassword Raspberry_009 -systemPassword Raspberry_009 \
-datafileDestination '/data/oracle/oradata' \
-recoveryAreaDestination '/data/oracle/flash_recovery_area' \
-redoLogFileSize 500 \
-storageType FS \
-characterset ZHS16GBK -nationalCharacterSet AL16UTF16 \
-sampleSchema true \
-memoryPercentage 50 \
-databaseType OLTP \
-emConfiguration NONE \
-archiveLogMode true 
 
 
 
vi  /data/oracle/product/19c/db_1/network/admin/listener.ora
 
 
 
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = syntong)
      (SID_NAME = syntong)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.3.1 )(PORT = 1521))
    )
  )
 
ADR_BASE_LISTENER = /data/oracle

vi /data/oracle/product/19c/db_1/network/admin/tnsnames.ora  

syntong =
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.3.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = syntong)
    )
  )
 
vi  /etc/systemd/system/oracle19c.service
[Unit]
Description=Oracle Database 19c Service
After=network.target

[Service]
Type=forking
User=oracle
Group=oinstall

ExecStart=/data/oracle/product/19c/db_1/bin/dbstart /data/oracle/product/19c/db_1
ExecStop=/data/oracle/product/19c/db_1/bin/dbshut /data/oracle/product/19c/db_1

Restart=on-failure
 
[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable oracle19c
systemctl start oracle19c

vi /etc/systemd/system/listener.service

[Unit]
Description=Oracle Listener
After=network.target  

[Service]
Type=forking
User=oracle
Group=oinstall

Environment="ORACLE_BASE=/data/oracle"
Environment="ORACLE_HOME=/data/oracle/product/19c/db_1"
Environment="ORACLE_SID=syntong"
Environment="TNS_ADMIN=/data/oracle/product/19c/db_1/network/admin"
Environment="LD_LIBRARY_PATH=/data/oracle/product/19c/db_1/lib"
Environment="PATH=/data/oracle/product/19c/db_1/bin:/usr/sbin:/usr/bin:/sbin:/bin"

ExecStart=/data/oracle/product/19c/db_1/bin/lsnrctl start
ExecStop=/data/oracle/product/19c/db_1/bin/lsnrctl stop
Restart=on-failure
WorkingDirectory=/data/oracle/product/19c/db_1  

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable listener
systemctl start listener
 

###支持低版本客户端连接
more /data/oracle/product/19c/db_1/network/admin/sqlnet.ora 
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
##遇到低版本客户端连接用户名密码错误，需要执行更改密码