m6米乐安卓版下载-米乐app官网下载
暂无图片
3

基于oracle linux 8.8操作系统安装oracle 19c数据库-m6米乐安卓版下载

原创 it烧麦(博) 2023-07-06
1255

目录

开始尝试使用oracle linux 9.2 安装oracle 19c 没成功,
然后使用oracle linux 8.8安装oracle 19c吧,然后把题目改了
打算先安装个单机,但是把grid用户创建上了。

《oracle 19c数据库单机版打补丁》








image.png

1、table 1-1 server hardware checklist for oracle database installation

image.png

2、table 1-2 operating system general checklist for oracle database on linux

image.png

操作系统 hostname ip
oracle linux 9.2 master01 192.168.10.21

1、配置本地yum源

创建挂载目录

mkdir /mnt/iso

挂载iso

mount -o loop /dev/sr0 /mnt/iso

修改配置文件

cd /etc/yum.repo.d/
vi linux.repo
[ol9]
name=ol9-1
baseurl=file:///run/media/wlb/ol-9-2-0-baseos-x86_64/appstream
gpgcheck=0
enabled=1

image.png

  • 安装依赖包
dnf install -y bc
dnf install -y binutils
dnf install -y elfutils-libelf
dnf install -y elfutils-libelf-devel
dnf install -y fontconfig-devel
dnf install -y glibc
dnf install -y glibc-devel
dnf install -y ksh
dnf install -y libaio
dnf install -y libaio-devel
dnf install -y libxrender
dnf install -y libx11
dnf install -y libxau
dnf install -y libxi
dnf install -y libxtst
dnf install -y libgcc
dnf install -y libnsl
dnf install -y librdmacm
dnf install -y libstdc  
dnf install -y libstdc  -devel
dnf install -y libxcb
dnf install -y libibverbs
dnf install -y make
dnf install -y policycoreutils
dnf install -y policycoreutils-python-utils
dnf install -y smartmontools
dnf install -y sysstat

2、禁用 transparent hugepages

透明的 hugepages 可能会导致运行时内存分配延迟。为避免性能问题,oracle 建议您在所有 oracle 数据库服务器上禁用 transparent hugepages。oracle 建议您改用标准的 hugepages 来增强性能。
检查是否启用了透明 hugepages

# cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never

显示启用 [always] 标志时正在使用透明 hugepages

禁用过程
在/etc/default/grub中添加transparent_hugepage=never
未添加时
image.png

添加后
image.png

运行grub2–mkconfig命令以重新生成grub.cfg文件

# grub2-mkconfig -o /boot/grub2/grub.cfg
generating grub configuration file ...
adding boot menu entry for uefi firmware settings ...
done

重新启动系统以使更改永久生效。

reboot

重启后继续查询

[root@master01 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]

说明修改已经生效

3、配置hosts

[root@master01 iso]# echo '192.168.10.21 master01' >> /etc/hosts

查看
image.png

4、关闭防火墙和selinux

systemctl stop firewalld.service
systemctl disable firewalld.service
sed -i 's/selinux=enforcing/selinux=disabled/g' /etc/sysconfig/selinux

5、修改内核参数

commands to display kernel parameter values
image.png

vi /etc/sysctl.d/97-oracle-database-sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 16780044288
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

执行命令,使内核参数生效

# /sbin/sysctl --system

6、创建用户和组

  • 创建组

creating the oracle inventory group

create an oracle inventory group manually as part of a planned installation, particularly where more than one oracle software product is installed on servers.
by default, if an orainventory group does not exist, then the installer uses the primary group of the installation owner for the oracle software being installed as the orainventory group. ensure that this group is available as a primary group for all planned oracle software installation owners.

# /usr/sbin/groupadd -g 54321 oinstall

creating the osdba for asm group

you must designate a group as the osdba for asm (asmdba) group during installation. members of this group are granted access privileges to oracle automatic storage management.

# /usr/sbin/groupadd -g 54327 asmdba

creating the osoper for asm group

you can choose to designate a group as the osoper for asm group (asmoper) during installation. members of this group are granted startup and shutdown privileges to oracle automatic storage management.

# /usr/sbin/groupadd -g 54328 asmoper

creating the osdba group for database installations

each oracle database requires an operating system group to be designated as the osdba group. members of this group are granted the sysdba system privileges to administer the database.

you must create an osdba group in the following circumstances:

  • an osdba group does not exist, for example, if this is the first installation of oracle database software on the system

  • an osdba group exists, but you want to give a different group of operating system users database administrative privileges for a new oracle database installation

# /usr/sbin/groupadd -g 54322 dba

creating an osoper group for database installations

create an osoper group only if you want to identify a group of operating system users with a limited set of database administrative privileges (sysoper operator privileges).

for most installations, it is sufficient to create only the osdba group. however, to use an osoper group, create it in the following circumstances:

  • if an osoper group does not exist; for example, if this is the first installation of oracle database software on the system

  • if an osoper group exists, but you want to give a different group of operating system users database operator privileges in a new oracle installation

# groupadd -g 54323 oper

creating the osbackupdba group for database installations

you must designate a group as the osbackupdba group during installation. members of this group are granted the sysbackup privileges to perform backup and recovery operations using rman or sql*plus.

# /usr/sbin/groupadd -g 54324 backupdba

creating the osdgdba group for database installations

you must designate a group as the osdgdba group during installation. members of this group are granted the sysdg privileges to perform data guard operations.

# /usr/sbin/groupadd -g 54325 dgdba

creating the oskmdba group for database installations

you must designate a group as the oskmdba group during installation. members of this group are granted the syskm privileges to perform transparent data encryption keystore operations.

# /usr/sbin/groupadd -g 54326 kmdba

creating the osracdba group for database installations

you must designate a group as the osracdba group during database installation. members of this group are granted the sysrac privileges to perform day–to–day administration of oracle databases on an oracle rac cluster.

# /usr/sbin/groupadd -g 54330 racdba
  • 创建用户

创建oracle用户

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

创建grid用户

# /usr/sbin/useradd -u 54331 -g oinstall -g dba,asmdba,backupdba,dgdba,kmdba,racdba,oper grid

合到一块执行下面的命令即可

groupadd -g 54321 oinstall
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54330 racdba
useradd -u 54321 -g oinstall -g dba,asmdba,backupdba,dgdba,kmdba,racdba oracle
useradd -u 54331 -g oinstall -g dba,asmdba,backupdba,dgdba,kmdba,racdba grid
echo "123456" | passwd --stdin oracle
echo "123456" | passwd --stdin grid

7、设置oracle用户和grid用户的资源限制

  • oracle software installation owner resource limit recommended ranges for standard installations

image.png
在/etc/security/limits.conf最后面添加如下参数

oracle  soft  nofile   1024
oracle  hard  nofile  65536
oracle  soft  nproc    2047
oracle  hard  nproc   16384
oracle  soft  stack   10240
oracle  hard  stack   32768
oracle  soft  memlock   unlimited
oracle  hard  memlock   unlimited
  • oracle grid infrastructure software installation owner resource limit recommended ranges for job role separation

image.png

grid  soft  nofile   1024
grid  hard  nofile  65536
grid  soft  nproc    2047
grid  hard  nproc   16384
grid  soft  stack   10240
grid  hard  stack   32768

8、创建目录

mkdir -p /u01/app/oracle/product/19.3/dbhome_1
chown -r oracle:oinstall /u01/app
chmod -r 775 /u01/app

9、在oracle用户下配置用户变量

su - oracle
vi /home/oracle/.base_profile
export oracle_base=/u01/app/oracle        
export oracle_home=/u01/app/oracle/product/19.3/dbhome_1
export oracle_sid=master
export path=$path:$home/.local/bin:$home/bin:$oracle_home/bin
umask 022

10、解压安装包

把安装包解压到oracle_home目录下

chown oracle:oinstall oracle_database_19.3.0.0.0_x86-64.zip
su - oracle
unzip oracle_database_19.3.0.0.0_x86-64.zip -d /u01/app/oracle/product/19.3/dbhome_1/

1、切换到oracle用户

su - oracle
[oracle@master01 ~]$ export display=:0.0
[oracle@master01 ~]$ xhost  

开始执行安装命令

cd /u01/app/oracle/product/19.3/dbhome_1/
[oracle@master01 dbhome_1]$ ./runinstaller

image.png
出师不利,上来就是报错,这个报错使用下面参数,可以解决,后面不知道还有错误没。可能是8.8的版本太高,还没完全适配。

export cv_assume_distid=ol7 -- if software is installed on rhel 8/ol8

image.png

image.png

image.png
image.png
image.png
image.png

image.png
image.png

image.png

  • 报错

1、oracle 用户没有加到oper组中,这个按照文档创建的用户,也会有这个问题。
解决:usermod -a -g oper oracle

2、compat-libcap1-1.10 linux 8版本找不到这个包

下载个oracle linux 7的包安装上去
[root@master01 ~]# rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm
warning: compat-libcap1-1.10-7.el7.x86_64.rpm: header v3 rsa/sha256 signature, key id ec551f03: nokey
verifying… ################################# [100%]
preparing… ################################# [100%]
updating / installing…
1:compat-libcap1-1.10-7.el7 ################################# [100%]

3、make-3.82
dnf -y install make

image.png
image.png
image.png
image.png
image.png
使用root用户执行这2个脚本

  • 脚本1
[root@master01 app]# /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.
  • 脚本2
[root@master01 app]# /u01/app/oracle/product/19.3/dbhome_1/root.sh
performing root user operation.
the following environment variables are set as:
    oracle_owner= oracle
    oracle_home=  /u01/app/oracle/product/19.3/dbhome_1
enter the full pathname of the local bin directory: [/usr/local/bin]:
   copying dbhome to /usr/local/bin ...
   copying oraenv to /usr/local/bin ...
   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.
oracle trace file analyzer (tfa - standalone mode) is available at :
    /u01/app/oracle/product/19.3/dbhome_1/bin/tfactl
note :
1. tfactl will use tfa service if that service is running and user has been granted access
2. tfactl will configure tfa standalone mode only if user has no access to tfa service or tfa is not installed

执行完后点ok
此时oracle软件已经安装完成。

1、在oracle用户下执行dbca

[oracle@master01 ~]$dbca

image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
安装完成
image.png

2、问题:低版本客户端11.2.0.4连接高版本服务端 19c

报错:ora-28040

  • 解放方案:在sqlnet.ora中添加下面2个参数
vi sqlnet.ora
sqlnet.allowed_logon_version_client=8
sqlnet.allowed_logon_version_server=8
  • 修改下用户密码
alter user xxx identified by "";

下一篇写下打补丁

说明:此部分内容是后加入的,操作系统是:centos 7.8

5.1 仅安装oracle软件

  • 把参数文件复制到/tmp中
cp /u01/app/oracle/product/19.3/dbhome_1/install/response/db_install.rsp /tmp/db_install.rsp
  • 修改参数文件
  • 详细参数见附录1
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_home=/u01/app/oracle/product/19.3/dbhome_1
oracle_base=/u01/app/oracle
oracle.install.db.installedition=ee
oracle.install.db.osdba_group=dba
oracle.install.db.osoper_group=oper
oracle.install.db.osbackupdba_group=dba
oracle.install.db.osdgdba_group=dba
oracle.install.db.oskmdba_group=dba
oracle.install.db.osracdba_group=dba
oracle.install.db.config.starterdb.type=general_purpose
oracle.install.db.config.starterdb.sid=rac
-----
12.1.0.2
security_updates_via_myoraclesupport=false(手动写了false)
decline_security_updates=true //设置安全更新(貌似是有bug,这个一定要选true,否则会无限提醒邮件地址有问题,终止安装。ps:不管地址对不对)

具体参数见附录1

  • 执行安装
./runinstaller -silent  -responsefile /tmp/db_install.rsp
  • 安装结束后需要以root用户执行以下两个脚本
/u01/app/orainventory/orainstroot.sh
/u01/app/oracle/product/19.3/dbhome_1/root.sh
  • 添加swap 16g
dd if=/dev/zero of=/var/swapfile bs=1024 count=16384000
mkswap  /var/swapfile
swapon   /var/swapfile
vi /etc/fstab
/var/swapfile   swap  swap  defaults  0  0

5.2 配置监听

  • 执行配置
  • 具体参数详见附录2
    这个直接使用这个参数即可
netca -silent -responsefile /u01/app/oracle/product/19.3/dbhome_1/assistants/netca/netca.rsp

image.png

5.3 安装数据库

cp /u01/app/oracle/product/19.3/dbhome_1/assistants/dbca/dbca.rsp /tmp/dbca.rsp
  • 修改如下参数
  • 具体参数详见附录3
vi /tmp/dbca.rsp
gdbname=orcl
sid=orcl
databaseconfigtype=si
templatename=general_purpose.dbc
syspassword=123456
systempassword=123456
characterset=al32utf8
nationalcharacterset=utf8
listeners=listener
createascontainerdatabase=true
numberofpdbs=1
pdbname=pdb
pdbadminpassword=123456
  • 执行安装
dbca -silent -createdatabase -responsefile /tmp/dbca.rsp
enter pdbadmin user password:
[warning] [dbt-06208] the 'sys' password entered does not conform to the oracle recommended standards.
   cause:
a. oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.the password entered is a keyword that oracle does not recommend to be used as password
   action: specify a strong password. if required refer oracle documentation for guidelines.
[warning] [dbt-06208] the 'system' password entered does not conform to the oracle recommended standards.
   cause:
a. oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.the password entered is a keyword that oracle does not recommend to be used as password
   action: specify a strong password. if required refer oracle documentation for guidelines.
[warning] [dbt-06208] the 'pdbadmin' password entered does not conform to the oracle recommended standards.
   cause:
a. oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.the password entered is a keyword that oracle does not recommend to be used as password
   action: specify a strong password. if required refer oracle documentation for guidelines.
prepare for db operation
8% complete
copying database files
31% complete
creating and starting oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
completing database creation
51% complete
53% complete
54% complete
creating pluggable databases
58% complete
77% complete
executing post configuration actions
100% complete
database creation complete. for details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/rac.
database information:
global database name:rac
system identifier(sid):rac
look at the log file "/u01/app/oracle/cfgtoollogs/dbca/rac01/rac3.log" for further details.

image.png

  • 进入数据库查看

image.png

5.4 问题

1、问题表现

dbca -silent -createdatabase -responsefile /tmp/dbca.rsp
 node name, required value in mb, and actual value in mb for each node is displayed below.
 dapingzs01     15000   8192
[fatal] ora-01034: oracle not available
31% complete
100% complete
[fatal] ora-01034: oracle not available
8% complete
0% complete
look at the log file "/u01/app/oracle/cfgtoollogs/dbca/daping01/daping012.log" for further details.

image.png

  • 查看日志
more alert_daping01.log
2023-07-19t22:15:47.599519 08:00
current maximum shared memory configured 8192 mb.
2023-07-19t22:15:47.599731 08:00
increase the system shared memory size to atleast 15 gb.

image.png
2、原因

this issue is due to unpublished bug 14202016 : lnx64-12.1-bc:dbca failed to create policy db due to ora-27104

3、解决方法

to resolve this issue , please apply or ask for one-off patch for bug 14202016.
or
as a workaround, increase the value for kernel parameter shmall to 9272480
  • 修改 /etc/sysctl.d/97-oracle-database-sysctl.conf
vi /etc/sysctl.d/97-oracle-database-sysctl.conf
kernel.shmall = 9272480
  • 重新执行dbca

5.5 附录

5.5.1 附录1 db_install.rsp

位置:/u01/app/oracle/product/19.3/dbhome_1/install/response/db_install.rsp

cat db_install.rsp
####################################################################
## 米乐app官网下载 copyright(c) oracle corporation 1998,2019. all rights reserved.##
##                                                                ##
## 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_v19.0.0
#-------------------------------------------------------------------------------
# specify the installation option.
# it can be one of the following:
#   - install_db_swonly
#   - install_db_and_config
#-------------------------------------------------------------------------------
oracle.install.option=
#-------------------------------------------------------------------------------
# specify the unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
unix_group_name=
#-------------------------------------------------------------------------------
# specify the location which holds the inventory files.
# this is an optional parameter if installing on
# windows based operating system.
#-------------------------------------------------------------------------------
inventory_location=
#-------------------------------------------------------------------------------
# specify the complete path of the oracle home.
#-------------------------------------------------------------------------------
oracle_home=
#-------------------------------------------------------------------------------
# specify the complete path of the oracle base.
#-------------------------------------------------------------------------------
oracle_base=
#-------------------------------------------------------------------------------
# specify the installation edition of the component.
#
# the value should contain only one of these choices.
#   - ee     : enterprise edition
#   - se2     : standard edition 2
#-------------------------------------------------------------------------------
oracle.install.db.installedition=
###############################################################################
#                                                                             #
# privileged operating system groups                                          #
# ------------------------------------------                                  #
# provide values for the os groups to which sysdba and sysoper 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 osdba_group is the os group which is to be granted sysdba privileges.
#-------------------------------------------------------------------------------
oracle.install.db.osdba_group=
#------------------------------------------------------------------------------
# the osoper_group is the os group which is to be granted sysoper privileges.
# the value to be specified for osoper group is optional.
#------------------------------------------------------------------------------
oracle.install.db.osoper_group=
#------------------------------------------------------------------------------
# the osbackupdba_group is the os group which is to be granted sysbackup privileges.
#------------------------------------------------------------------------------
oracle.install.db.osbackupdba_group=
#------------------------------------------------------------------------------
# the osdgdba_group is the os group which is to be granted sysdg privileges.
#------------------------------------------------------------------------------
oracle.install.db.osdgdba_group=
#------------------------------------------------------------------------------
# the oskmdba_group is the os group which is to be granted syskm privileges.
#------------------------------------------------------------------------------
oracle.install.db.oskmdba_group=
#------------------------------------------------------------------------------
# the osracdba_group is the os group which is to be granted sysrac privileges.
#------------------------------------------------------------------------------
oracle.install.db.osracdba_group=
################################################################################
#                                                                              #
#                      root script execution configuration                     #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------------------------------
# specify the root script execution mode.
#
#   - true  : to execute the root script automatically by using the appropriate configuration methods.
#   - false : to execute the root script manually.
#
# if this option is selected, password should be specified on the console.
#-------------------------------------------------------------------------------------------------------
oracle.install.db.rootconfig.executerootscript=
#--------------------------------------------------------------------------------------
# specify the configuration method to be used for automatic root script execution.
#
# following are the possible choices:
#   - root
#   - sudo
#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.configmethod=
#--------------------------------------------------------------------------------------
# specify the absolute path of the sudo program.
#
# applicable only when sudo configuration method was chosen.
#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.sudopath=
#--------------------------------------------------------------------------------------
# specify the name of the user who is in the sudoers list.
# applicable only when sudo configuration method was chosen.
# note:for single instance database installations,the sudo user name must be the username of the user installing the database.
#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.sudousername=
###############################################################################
#                                                                             #
#                               grid options                                  #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# value is required only if the specified install option is install_db_swonly
#
# specify the cluster node names selected during the installation.
#
# example : oracle.install.db.cluster_nodes=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.cluster_nodes=
###############################################################################
#                                                                             #
#                        database configuration options                       #
#                                                                             #
###############################################################################
#-------------------------------------------------------------------------------
# specify the type of database to create.
# it can be one of the following:
#   - general_purpose
#   - data_warehouse
# general_purpose: a starter database designed for general purpose use or transaction-heavy applications.
# data_warehouse : a starter database optimized for data warehousing applications.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=
#-------------------------------------------------------------------------------
# specify the starter database global database name.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globaldbname=
#-------------------------------------------------------------------------------
# specify the starter database sid.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.sid=
#-------------------------------------------------------------------------------
# specify whether the database should be configured as a container database.
# the value can be either "true" or "false". if left blank it will be assumed
# to be "false".
#-------------------------------------------------------------------------------
oracle.install.db.configureascontainerdb=
#-------------------------------------------------------------------------------
# specify the  pluggable database name for the pluggable database in container database.
#-------------------------------------------------------------------------------
oracle.install.db.config.pdbname=
#-------------------------------------------------------------------------------
# specify the starter database character set.
#
#  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=
#------------------------------------------------------------------------------
# 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=
#-------------------------------------------------------------------------------
# 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.
# the value can be either "true" or "false". if left blank it will be assumed
# to be "false".
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installexampleschemas=
###############################################################################
#                                                                             #
# passwords can be supplied for the following four schemas in the             #
# starter database:                                                           #
#   sys                                                                       #
#   system                                                                    #
#   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=
#-------------------------------------------------------------------------------
# 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 dbsnmp password for the starter database.
# applicable only when oracle.install.db.config.starterdb.managementoption=cloud_control
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.dbsnmp=
#-------------------------------------------------------------------------------
# specify the pdbadmin password required for creation of pluggable database in the container database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.pdbadmin=
#-------------------------------------------------------------------------------
# specify the management option to use for managing the database.
# options are:
# 1. cloud_control - if you want to manage your database with enterprise manager cloud control along with database express.
# 2. default   -if you want to manage your database using the default database express option.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.managementoption=
#-------------------------------------------------------------------------------
# specify the oms host to connect to cloud control.
# applicable only when oracle.install.db.config.starterdb.managementoption=cloud_control
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omshost=
#-------------------------------------------------------------------------------
# specify the oms port to connect to cloud control.
# applicable only when oracle.install.db.config.starterdb.managementoption=cloud_control
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsport=
#-------------------------------------------------------------------------------
# specify the em admin user name to use to connect to cloud control.
# applicable only when oracle.install.db.config.starterdb.managementoption=cloud_control
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emadminuser=
#-------------------------------------------------------------------------------
# specify the em admin password to use to connect to cloud control.
# applicable only when oracle.install.db.config.starterdb.managementoption=cloud_control
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emadminpassword=
###############################################################################
#                                                                             #
# specify recovery options                                                    #
# ------------------------------------                                        #
# recovery options for the database can be mentioned using the entries below  #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# this variable is to be set to false if database recovery is not required. else
# this can be set to true.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enablerecovery=
#-------------------------------------------------------------------------------
# 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=
#-------------------------------------------------------------------------------
# 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 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.storagetype=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=

5.5.2 附录2 netca.rsp

位置:/u01/app/oracle/product/19.3/dbhome_1/assistants/dbca/netca.rsp

cat netca.rsp
######################################################################
## 米乐app官网下载 copyright(c) 1998, 2018 oracle corporation. all rights reserved. ##
##                                                                  ##
## specify values for the variables listed below to customize your  ##
## installation.                                                    ##
##                                                                  ##
## each variable is associated with a comment. the comment          ##
## identifies the variable type.                                    ##
##                                                                  ##
## please specify the values in the following format:               ##
##                                                                  ##
##         type         example                                     ##
##         string       "sample value"                              ##
##         boolean      true or false                               ##
##         number       1000                                        ##
##         stringlist   {"string value 1","string value 2"}         ##
##                                                                  ##
######################################################################
##                                                                  ##
## this sample response file causes the oracle net configuration    ##
## assistant (netca) to complete an oracle net configuration during ##
## a custom install of the oracle12c server which is similar to     ##
## what would be created by the netca during typical oracle12c      ##
## install. it also documents all of the netca response file        ##
## variables so you can create your own response file to configure  ##
## oracle net during an install the way you wish.                   ##
##                                                                  ##
######################################################################
[general]
responsefile_version="19.0"
create_type="custom"
#-------------------------------------------------------------------------------
# name       : show_gui
# datatype   : boolean
# description: this variable controls appearance/suppression of the netca gui,
# pre-req    : n/a
# default    : true
# note:
# this must be set to false in order to run netca in silent mode.
# this is a substitute of "/silent" flag in the netca command line.
# the command line flag has precedence over the one in this response file.
# this feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#show_gui=false
#-------------------------------------------------------------------------------
# name       : log_file
# datatype   : string
# description: if present, netca will log output to this file in addition to the
#              standard out.
# pre-req    : n/a
# default    : none
# note:
#       this is a substitute of "/log" in the netca command line.
# the command line argument has precedence over the one in this response file.
# this feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#log_file=""$oracle_base/cfgtoollogs/netca/netca.log""
[oracle.net.ca]
#installed_components;stringlist;list of installed components
# the possible values for installed components are:
# "net8","server","client","aso", "cman", "javavm"
installed_components={"server","net8","javavm"}
#install_type;string;type of install
# the possible values for install type are:
# "typical","minimal" or "custom"
install_type=""typical""
#listener_number;number;number of listeners
# a typical install sets one listener
listener_number=1
#listener_names;stringlist;list of listener names
# the values for listener are:
# "listener","listener1","listener2","listener3", ...
# a typical install sets only "listener"
listener_names={"listener"}
#listener_protocols;stringlist;list of listener addresses (protocols and parameters separated by semicolons)
# the possible values for listener protocols are:
# "tcp;1521","tcps;2484","nmp;orapipe","ipc;ipckey","vi;1521"
# for multiple listeners, separate them with commas ex "tcp;1521","tcps;2484"
# for multiple protocols in single listener, separate them with "&" ex  "tcp;1521&tcps;2484"
# a typical install sets only "tcp;1521"
listener_protocols={"tcp;1521"}
#listener_start;string;name of the listener to start, in double quotes
listener_start=""listener""
#naming_methods;stringlist;list of naming methods
# the possible values for naming methods are:
# ldap, tnsnames, onames, hostname, novell, nis, dce
# a typical install sets only: "tnsnames","onames","hostnames"
# or "ldap","tnsnames","onames","hostnames" for ldap
naming_methods={"tnsnames","onames","hostname"}
#novell_namecontext;string;novell directory service name context, in double quotes
# a typical install does not use this variable.
#novell_namecontext = ""namcontext""
#sun_metamap;string; sun meta map, in double quotes
# a typical install does not use this variable.
#sun_metamap = ""map""
#dce_cellname;string;dce cell name, in double quotes
# a typical install does not use this variable.
#dce_cellname = ""cell""
#nsn_number;number;number of netservice names
# a typical install sets one net service name
nsn_number=1
#nsn_names;stringlist;list of net service names
# a typical install sets net service name to "extproc_connection_data"
nsn_names={"extproc_connection_data"}
#nsn_service;stringlist;oracle12c database's service name
# a typical install sets oracle12c database's service name to "plsextproc"
nsn_service={"plsextproc"}
#nsn_protocols;stringlist;list of coma separated strings of net service name protocol parameters
# the possible values for net service name protocol parameters are:
# "tcp;hostname;1521","tcps;hostname;2484","nmp;computername;orapipe","vi;hostname;1521","ipc;ipckey"
# a typical install sets parameters to "ipc;extproc"
nsn_protocols={"tcp;hostname;1521"}
#serviceuserpassword;string;windows service user password
# if the oracle home is installed as secure user, supply the password
#serviceuserpassword=""svcpassword""

5.5.3 附录3 dbca.rsp

位置:/u01/app/oracle/product/19.3/dbhome_1/assistants/dbca/dbca.rsp

[root@dapingzs01 dbca]# cat dbca.rsp
##############################################################################
##                                                                          ##
##                            dbca response file                            ##
##                            ------------------                            ##
## 米乐app官网下载 copyright(c) oracle corporation 1998,2019. all rights reserved.         ##
##                                                                          ##
## 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.
#-------------------------------------------------------------------------------
responsefileversion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
#-----------------------------------------------------------------------------
# name          : gdbname
# datatype      : string
# description   : global database name of the database
# valid values  : . - when database domain isn't null
#                              - when database domain is null
# default value : none
# mandatory     : yes
#-----------------------------------------------------------------------------
gdbname=
#-----------------------------------------------------------------------------
# name          : sid
# datatype      : string
# description   : system identifier (sid) of the database
# valid values  : check oracle19c administrator's guide
# default value :  specified in gdbname
# mandatory     : no
#-----------------------------------------------------------------------------
sid=
#-----------------------------------------------------------------------------
# name          : databaseconfigtype
# datatype      : string
# description   : database conf type as single instance, real application cluster or real application cluster one nodes database
# valid values  : si\rac\raconenode
# default value : si
# mandatory     : no
#-----------------------------------------------------------------------------
databaseconfigtype=
#-----------------------------------------------------------------------------
# name          : raconenodeservicename
# datatype      : string
# description   : service is required by application to connect to rac one
#                 node database
# valid values  : service name
# default value : none
# mandatory     : no [required in case databaseconftype is set to raconenode ]
#-----------------------------------------------------------------------------
raconenodeservicename=
#-----------------------------------------------------------------------------
# name          : policymanaged
# datatype      : boolean
# description   : set to true if database is policy managed and
#                 set to false if  database is admin managed
# valid values  : true\false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
policymanaged=
#-----------------------------------------------------------------------------
# name          : createserverpool
# datatype      : boolean
# description   : set to true if new server pool need to be created for database
#                 if this option is specified then the newly created database
#                 will use this newly created serverpool.
#                 multiple serverpoolname can not be specified for database
# valid values  : true\false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
createserverpool=
#-----------------------------------------------------------------------------
# name          : serverpoolname
# datatype      : string
# description   : only one serverpool name need to be specified
#                  if create server pool option is specified.
#                  comma-separated list of serverpool names if db need to use
#                  multiple server pool
# valid values  : serverpool name
# default value : none
# mandatory     : no [required in case of rac service centric database]
#-----------------------------------------------------------------------------
serverpoolname=
#-----------------------------------------------------------------------------
# name          : cardinality
# datatype      : number
# description   : specify cardinality for create server pool operation
# valid values  : any positive integer value
# default value : number of qualified nodes on cluster
# mandatory     : no [required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
cardinality=
#-----------------------------------------------------------------------------
# name          : force
# datatype      : boolean
# description   : set to true if new server pool need to be created by force
#                 if this option is specified then the newly created serverpool
#                 will be assigned server even if no free servers are available.
#                 this may affect already running database.
#                 this flag can be specified for admin managed as well as policy managed db.
# valid values  : true\false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
force=
#-----------------------------------------------------------------------------
# name          : pqpoolname
# datatype      : string
# description   : only one serverpool name needs to be specified
#                  if create server pool option is specified.
#                  comma-separated list of serverpool names if use
#                  server pool. this is required to
#                  create parallel query (pq) database. applicable to big cluster
# valid values  :  parallel query (pq) pool name
# default value : none
# mandatory     : no [required in case of rac service centric database]
#-----------------------------------------------------------------------------
pqpoolname=
#-----------------------------------------------------------------------------
# name          : pqcardinality
# datatype      : number
# description   : specify cardinality for create server pool operation.
#                 applicable to big cluster
# valid values  : any positive integer value
# default value : number of qualified nodes on cluster
# mandatory     : no [required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
pqcardinality=
#-----------------------------------------------------------------------------
# name          : createascontainerdatabase
# datatype      : boolean
# description   : flag to create database as container database
# valid values  : check oracle19c administrator's guide
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
createascontainerdatabase=
#-----------------------------------------------------------------------------
# name          : numberofpdbs
# datatype      : number
# description   : specify the number of pdb to be created
# valid values  : 0 to 4094
# default value : 0
# mandatory     : no
#-----------------------------------------------------------------------------
numberofpdbs=
#-----------------------------------------------------------------------------
# name          : pdbname
# datatype      : string
# description   : specify the pdbname/pdbanme prefix if one or more pdb need to be created
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
pdbname=
#-----------------------------------------------------------------------------
# name          : uselocalundoforpdbs
# datatype      : boolean
# description   : flag to create local undo tablespace for all pdb's.
# valid values  : true\false
# default value : true
# mandatory     : no
#-----------------------------------------------------------------------------
uselocalundoforpdbs=
#-----------------------------------------------------------------------------
# name          : pdbadminpassword
# datatype      : string
# description   : pdb administrator user password
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
pdbadminpassword=
#-----------------------------------------------------------------------------
# name          : nodelist
# datatype      : string
# description   : comma-separated list of cluster nodes
# valid values  : cluster node names
# default value : none
# mandatory     : no (yes for rac database-centric database )
#-----------------------------------------------------------------------------
nodelist=
#-----------------------------------------------------------------------------
# name          : templatename
# datatype      : string
# description   : name of the template
# valid values  : template file name
# default value : none
# mandatory     : yes
#-----------------------------------------------------------------------------
templatename=
#-----------------------------------------------------------------------------
# name          : syspassword
# datatype      : string
# description   : password for sys user
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : yes
#-----------------------------------------------------------------------------
syspassword=
#-----------------------------------------------------------------------------
# name          : systempassword
# datatype      : string
# description   : password for system user
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : yes
#-----------------------------------------------------------------------------
systempassword=
#-----------------------------------------------------------------------------
# name          : oraclehomeuserpassword
# datatype      : string
# description   : password for windows service user
# default value : none
# mandatory     : if oracle home is installed with windows service user
#-----------------------------------------------------------------------------
oraclehomeuserpassword=
#-----------------------------------------------------------------------------
# name          : emconfiguration
# datatype      : string
# description   : enterprise manager configuration type
# valid values  : central|dbexpress|both|none
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
emconfiguration=
#-----------------------------------------------------------------------------
# name          : emexpressport
# datatype      : number
# description   : enterprise manager configuration type
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : no, will be picked up from dbexpress_https_port env variable
#                 or auto generates a free port between 5500 and 5599
#-----------------------------------------------------------------------------
emexpressport=5500
#-----------------------------------------------------------------------------
# name          : runcvuchecks
# datatype      : boolean
# description   : specify whether to run cluster verification utility checks
#                 periodically in cluster environment
# valid values  : true\false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
runcvuchecks=
#-----------------------------------------------------------------------------
# name          : dbsnmppassword
# datatype      : string
# description   : password for dbsnmp user
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : yes, if emconfiguration is specified or
#                 the value of runcvuchecks is true
#-----------------------------------------------------------------------------
dbsnmppassword=
#-----------------------------------------------------------------------------
# name          : omshost
# datatype      : string
# description   : em management server host name
# default value : none
# mandatory     : yes, if central is specified for emconfiguration
#-----------------------------------------------------------------------------
omshost=
#-----------------------------------------------------------------------------
# name          : omsport
# datatype      : number
# description   : em management server port number
# default value : none
# mandatory     : yes, if central is specified for emconfiguration
#-----------------------------------------------------------------------------
omsport=
#-----------------------------------------------------------------------------
# name          : emuser
# datatype      : string
# description   : em admin username to add or modify targets
# default value : none
# mandatory     : yes, if central is specified for emconfiguration
#-----------------------------------------------------------------------------
emuser=
#-----------------------------------------------------------------------------
# name          : empassword
# datatype      : string
# description   : em admin user password
# default value : none
# mandatory     : yes, if central is specified for emconfiguration
#-----------------------------------------------------------------------------
empassword=
#-----------------------------------------------------------------------------
# name          : dvconfiguration
# datatype      : boolean
# description   : specify "true" to configure and enable oracle database vault
# valid values  : true/false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
dvconfiguration=
#-----------------------------------------------------------------------------
# name          : dvusername
# datatype      : string
# description   : datavault owner
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : yes, if datavault option is chosen
#-----------------------------------------------------------------------------
dvusername=
#-----------------------------------------------------------------------------
# name          : dvuserpassword
# datatype      : string
# description   : password for datavault owner
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : yes, if datavault option is chosen
#-----------------------------------------------------------------------------
dvuserpassword=
#-----------------------------------------------------------------------------
# name          : dvaccountmanagername
# datatype      : string
# description   : datavault account manager
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
dvaccountmanagername=
#-----------------------------------------------------------------------------
# name          : dvaccountmanagerpassword
# datatype      : string
# description   : password for  datavault account manager
# valid values  : check oracle19c administrator's guide
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
dvaccountmanagerpassword=
#-----------------------------------------------------------------------------
# name          : olsconfiguration
# datatype      : boolean
# description   : specify "true" to configure and enable oracle label security
# valid values  : true/false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
olsconfiguration=
#-----------------------------------------------------------------------------
# name          : datafilejarlocation
# datatype      : string
# description   : location of the data file jar
# valid values  : directory containing compressed datafile jar
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
datafilejarlocation=
#-----------------------------------------------------------------------------
# name          : datafiledestination
# datatype      : string
# description   : location of the data file's
# valid values  : directory for all the database files
# default value : $oracle_base/oradata
# mandatory     : no
#-----------------------------------------------------------------------------
datafiledestination=
#-----------------------------------------------------------------------------
# name          : recoveryareadestination
# datatype      : string
# description   : location of the data file's
# valid values  : recovery area location
# default value : $oracle_base/flash_recovery_area
# mandatory     : no
#-----------------------------------------------------------------------------
recoveryareadestination=
#-----------------------------------------------------------------------------
# name          : storagetype
# datatype      : string
# description   : specifies the storage on which the database is to be created
# valid values  : fs (cfs for rac), asm
# default value : fs
# mandatory     : no
#-----------------------------------------------------------------------------
storagetype=
#-----------------------------------------------------------------------------
# name          : diskgroupname
# datatype      : string
# description   : specifies the disk group name for the storage
# default value : data
# mandatory     : no
#-----------------------------------------------------------------------------
diskgroupname=
#-----------------------------------------------------------------------------
# name          : asmsnmppassword
# datatype      : string
# description   : password for asm monitoring
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
asmsnmppassword=
#-----------------------------------------------------------------------------
# name          : recoverygroupname
# datatype      : string
# description   : specifies the disk group name for the recovery area
# default value : recovery
# mandatory     : no
#-----------------------------------------------------------------------------
recoverygroupname=
#-----------------------------------------------------------------------------
# name          : characterset
# datatype      : string
# description   : character set of the database
# valid values  : check oracle19c national language support guide
# default value : "us7ascii"
# mandatory     : no
#-----------------------------------------------------------------------------
characterset=
#-----------------------------------------------------------------------------
# name          : nationalcharacterset
# datatype      : string
# description   : national character set of the database
# valid values  : "utf8" or "al16utf16". for details, check oracle19c national language support guide
# default value : "al16utf16"
# mandatory     : no
#-----------------------------------------------------------------------------
nationalcharacterset=
#-----------------------------------------------------------------------------
# name          : registerwithdirservice
# datatype      : boolean
# description   : specifies whether to register with directory service.
# valid values  : true \ false
# default value : false
# mandatory     : no
#-----------------------------------------------------------------------------
registerwithdirservice=
#-----------------------------------------------------------------------------
# name          : dirserviceusername
# datatype      : string
# description   : specifies the name of the directory service user
# mandatory     : yes, if the value of registerwithdirservice is true
#-----------------------------------------------------------------------------
dirserviceusername=
#-----------------------------------------------------------------------------
# name          : dirservicepassword
# datatype      : string
# description   : the password of the directory service user.
#                 you can also specify the password at the command prompt instead of here.
# mandatory     : yes, if the value of registerwithdirservice is true
#-----------------------------------------------------------------------------
dirservicepassword=
#-----------------------------------------------------------------------------
# name          : walletpassword
# datatype      : string
# description   : the password for wallet to created or modified.
#                 you can also specify the password at the command prompt instead of here.
# mandatory     : yes, if the value of registerwithdirservice is true
#-----------------------------------------------------------------------------
walletpassword=
#-----------------------------------------------------------------------------
# name          : listeners
# datatype      : string
# description   : specifies list of listeners to register the database with.
#                 by default the database is configured for all the listeners specified in the
#                 $oracle_home/network/admin/listener.ora
# valid values  : the list should be comma separated like "listener1,listener2".
# mandatory     : no
#-----------------------------------------------------------------------------
listeners=
#-----------------------------------------------------------------------------
# name          : variablesfile
# datatype      : string
# description   : location of the file containing variable value pair
# valid values  : a valid file-system file. the variable value pair format in this file
#                 is =. each pair should be in a new line.
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
variablesfile=
#-----------------------------------------------------------------------------
# name          : variables
# datatype      : string
# description   : comma separated list of name=value pairs. overrides variables defined in variablefile and templates
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
variables=
#-----------------------------------------------------------------------------
# name          : initparams
# datatype      : string
# description   : comma separated list of name=value pairs. overrides initialization parameters defined in templates
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
initparams=
#-----------------------------------------------------------------------------
# name          : sampleschema
# datatype      : boolean
# description   : specifies whether or not to add the sample schemas to your database
# valid values  : true \ false
# default value : fasle
# mandatory     : no
#-----------------------------------------------------------------------------
sampleschema=
#-----------------------------------------------------------------------------
# name          : memorypercentage
# datatype      : string
# description   : percentage of physical memory for oracle
# default value : none
# mandatory     : no
#-----------------------------------------------------------------------------
memorypercentage=
#-----------------------------------------------------------------------------
# name          : databasetype
# datatype      : string
# description   : used for memory distribution when memorypercentage specified
# valid values  : multipurpose|data_warehousing|oltp
# default value : multipurpose
# mandatory     : no
#-----------------------------------------------------------------------------
databasetype=
#-----------------------------------------------------------------------------
# name          : automaticmemorymanagement
# datatype      : boolean
# description   : flag to indicate automatic memory management is used
# valid values  : true/false
# default value : true
# mandatory     : no
#-----------------------------------------------------------------------------
automaticmemorymanagement=
#-----------------------------------------------------------------------------
# name          : totalmemory
# datatype      : string
# description   : total memory in mb to allocate to oracle
# valid values  :
# default value :
# mandatory     : no
#-----------------------------------------------------------------------------
totalmemory=
最后修改时间:2024-01-04 15:13:26
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

网站地图