一、lsnrctl status
用于查看Oracle监听程序的状态信息
常用的方式：
1:ps -ef | grep tnslsnr
[root@server1 ~]# ps -ef | grep tnslsnr
orauser 12450 1 0 14:07 ? 00:00:00 /home/oracle/product/12c/dbhome_1/bin/tnslsnr LISTENER -inherit
root 13900 8861 0 14:50 pts/1 00:00:00 grep --color=auto tnslsnr
2:重新加载监听程序
su - oracle
lsnrctl reload当修改了监听程序的配置文件（如listener.ora）后，使用此命令使新配置生效。
3:lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-JAN-2024 12:00:00
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 01-JAN-2024 10:00:00
Uptime 2 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/your_hostname/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully各部分信息含义：
基本信息
版本信息：显示 lsnrctl 和监听程序的版本，如 TNSLSNR for Linux: Version 19.0.0.0.0 - Production。
启动日期和运行时间：Start Date 表明监听程序的启动时间，Uptime 显示监听程序已经运行的时长。
配置信息
监听别名：Alias 为监听程序的别名，通常为 LISTENER。
跟踪级别：Trace Level 表示监听程序的跟踪日志级别，off 表示关闭跟踪日志。
安全设置：Security 显示监听程序的安全认证方式，这里是 ON: Local OS Authentication，表示使用本地操作系统认证。
SNMP 设置：SNMP 显示是否启用了简单网络管理协议，OFF 表示未启用。
参数文件和日志文件路径：Listener Parameter File 指出监听程序的配置文件路径，Listener Log File 显示监听程序的日志文件路径。
监听端点信息
Listening Endpoints Summary 列出了监听程序正在监听的网络地址和端口，例如 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) 表示监听本地主机的 1521 端口。
服务信息
Services Summary 显示已经注册到监听程序的数据库服务及其状态。对于每个服务，会列出关联的实例名称、实例状态（如 READY 表示实例已准备好接受连接）以及处理程序的数量。
常见结果及含义
正常运行：如果命令输出包含监听程序的详细信息，且服务状态正常（如 READY），则表示监听程序正在正常运行，并且数据库实例已经成功注册到监听程序，可以接受客户端的连接请求。
监听程序未运行：如果输出提示 TNS-12541: TNS:no listener，则表示监听程序没有启动，需要使用 lsnrctl start 命令启动监听程序。
服务未注册：如果 Services Summary 部分没有显示预期的数据库服务，可能是数据库实例没有正确注册到监听程序，需要检查数据库实例的配置和监听程序的配置是否正确。
二、管理Oracle实例
1.启动实例
su - oracle
sqlplus / as sysdba
STARTUP;这里STARTUP命令有多种模式，例如STARTUP NOMOUNT只启动实例但不加载数据库；STARTUP MOUNT加载数据库但不打开；STARTUP则是完整启动数据库，使其可以正常使用。
2.停止实例
su - oracle
sqlplus / as sysdba
SHUTDOWN [选项];SHUTDOWN的选项有NORMAL（正常关闭，等待所有用户断开连接后关闭）、IMMEDIATE（立即关闭，不等待用户完成当前操作）、TRANSACTIONAL（等待当前事务完成后关闭）、ABORT（强制关闭，不做任何保存操作）
3.检查实例状态
su - oracle
sqlplus / as sysdba
SELECT status FROM v$instance;此命令可查看实例当前状态，如STARTED（已启动）、OPEN（已打开可使用）、MOUNTED（已装载未打开）等。
三、监控相关命令
1.使用v$视图监控实例
监控会话信息
SELECT username, sid, serial#, program FROM v$session;- 监控系统资源使用情况
SELECT name, value FROM v$sysstat WHERE name IN ('redo size','sorts (memory)','sorts (disk)');能获取系统资源的使用统计信息
2.性能指标相关
- 响应时间
含义：指从客户端发送请求到接收到完整响应所花费的时间。它反映了数据库处理单个事务或查询的效率。
监控方式：可以通过应用程序层面的日志记录，或者使用 Oracle 自带的 AWR（Automatic Workload Repository）报告中的 SQL 响应时间数据进行监控。
吞吐量
含义：表示单位时间内数据库处理的事务或查询数量。高吞吐量意味着数据库能够高效地处理大量请求。
监控方式：可以通过查询V$SYSMETRIC_HISTORY视图获取每秒事务数（TPS）或每秒查询数（QPS）等数据来衡量吞吐量。例如：
SELECT metric_name, value
FROM V$SYSMETRIC_HISTORY
WHERE metric_name IN ('Transactions Per Second', 'Queries Per Second');- 并发连接数
含义：指同一时刻连接到数据库的客户端数量。过高的并发连接数可能导致资源竞争，影响数据库性能。
监控方式：可以通过查询V$SESSION视图统计当前活动会话的数量。例如：
SELECT COUNT(*) FROM V$SESSION WHERE status = 'ACTIVE';3.资源使用指标
- CPU 使用率
含义：反映了数据库服务器 CPU 资源的利用情况。过高的 CPU 使用率可能导致数据库响应变慢。
监控方式：可以使用操作系统层面的工具（如top、vmstat）或者查询 Oracle 的V$SYS_TIME_MODEL视图获取 CPU 使用相关信息。例如：
SELECT stat_name, value
FROM V$SYS_TIME_MODEL
WHERE stat_name LIKE '%CPU time%';- 内存使用率
含义：包括 SGA（System Global Area）和 PGA（Program Global Area）的使用情况。SGA 是多个进程共享的内存区域，PGA 是每个服务器进程私有的内存区域。
监控方式：通过查询V$SGASTAT和V$PGA_TARGET_ADVICE等视图来监控 SGA 和 PGA 的使用情况。例如，查看 SGA 各组件的使用情况：
SELECT name, bytes
FROM V$SGASTAT;- 磁盘 I/O
含义：指数据库与磁盘之间的数据读写操作。频繁的磁盘 I/O 可能成为数据库性能的瓶颈。
监控方式：可以使用操作系统工具（如iostat）监控磁盘的读写速率、IOPS（Input/Output Operations Per Second）等指标，也可以通过查询 Oracle 的V$FILESTAT视图获取数据库文件的 I/O 统计信息。例如：
SELECT file_name, phyblkrd, phyblkwrt
FROM V$FILESTAT a
JOIN DBA_DATA_FILES b ON a.file# = b.file_id;4.事务和锁相关指标
- 事务吞吐量
含义：表示单位时间内数据库处理的事务数量，反映了数据库处理业务逻辑的能力。
监控方式：通过查询V$SYSMETRIC_HISTORY视图获取每秒事务数。例如：
SELECT value
FROM V$SYSMETRIC_HISTORY
WHERE metric_name = 'Transactions Per Second';- 锁等待时间
含义：当一个事务需要访问被其他事务锁定的资源时，就会发生锁等待。锁等待时间过长会影响事务的执行效率。
监控方式：可以通过查询V$LOCK和V$SESSION_WAIT等视图来监控锁等待情况。例如，查看当前正在等待锁的会话：
SELECT s.sid, s.username, l.type, l.id1, l.id2
FROM V$LOCK l
JOIN V$SESSION s ON l.sid = s.sid
WHERE l.block = 0 AND s.wait_class = 'Concurrency';5.数据库对象相关指标
- 表空间使用率
含义：表空间是 Oracle 数据库中逻辑存储结构的一部分，表空间使用率反映了其存储数据的占用情况。
监控方式：通过查询DBA_TABLESPACES和DBA_FREE_SPACE等视图来计算表空间的使用情况。例如：
SELECT tablespace_name,
SUM(bytes) / 1024 / 1024 AS total_mb,
SUM(bytes - NVL(free_bytes, 0)) / 1024 / 1024 AS used_mb,
(SUM(bytes - NVL(free_bytes, 0)) / SUM(bytes)) * 100 AS used_percent
FROM (
SELECT tablespace_name, bytes, NULL AS free_bytes
FROM DBA_DATA_FILES
UNION ALL
SELECT tablespace_name, 0, bytes
FROM DBA_FREE_SPACE
)
GROUP BY tablespace_name;- 索引使用情况
含义：索引可以提高数据库查询的效率，但不合理的索引可能会增加数据库的维护成本。监控索引使用情况有助于优化索引。
监控方式：可以通过查询V$OBJECT_USAGE视图来了解索引的使用频率。例如：
SELECT index_name, monitored, used
FROM V$OBJECT_USAGE
WHERE table_name = 'YOUR_TABLE_NAME';四、关于Oracle数据库安装的配置文件
####################################################################
## Copyright(c) Oracle Corporation 1998,2014. 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=/home/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
#-------------------------------------------------------------------------------
# Specify the installation option.设置安装选项
# It can be one of the following:
# - INSTALL_DB_SWONLY：仅安装数据库软件
# - INSTALL_DB_AND_CONFIG：安装数据库软件并进行配置
# - UPGRADE_DB：用于升级现有数据库
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_AND_CONFIG
#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces) 指定安装的oracle的主机名
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=oracleserver
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#设置存放oracle库存目录的Unix组名
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#指定库存文件的存放位置，记录安装的组件、版本等信息，Windows 系统下此参数可选。
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/home/oracleInventory
#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.
#
# en : English ja : Japanese
# fr : French ko : Korean
# ar : Arabic es : Latin American Spanish
# bn : Bengali lv : Latvian
# pt_BR: Brazilian Portuguese lt : Lithuanian
# bg : Bulgarian ms : Malay
# fr_CA: Canadian French es_MX: Mexican Spanish
# ca : Catalan no : Norwegian
# hr : Croatian pl : Polish
# cs : Czech pt : Portuguese
# da : Danish ro : Romanian
# nl : Dutch ru : Russian
# ar_EG: Egyptian zh_CN: Simplified Chinese
# en_GB: English (Great Britain) sk : Slovak
# et : Estonian sl : Slovenian
# fi : Finnish es_ES: Spanish
# de : German sv : Swedish
# el : Greek th : Thai
# iw : Hebrew zh_TW: Traditional Chinese
# hu : Hungarian tr : Turkish
# is : Icelandic uk : Ukrainian
# in : Indonesian vi : Vietnamese
# it : Italian
#
# all_langs : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs
#选择安装组件时使用的语言，如zh_CN,en表示安装简体中文和英文版本。
#-------------------------------------------------------------------------------
SELECTED_LANGUAGES=zh_CN,en
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#指定 Oracle 主目录的完整路径，存放数据库软件相关的二进制文件、库文件等。
#-------------------------------------------------------------------------------
ORACLE_HOME=/home/oracle/product/12c/dbhome_1
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#指定 Oracle 基目录的完整路径，是 Oracle 相关文件和目录结构的根目录，ORACLE_HOME通常是其子目录。
#-------------------------------------------------------------------------------
ORACLE_BASE=/home/oracle
#-------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# - EE : Enterprise Edition
#指定安装的数据库版本，EE代表企业版，还有其他版本可能在不同场景下可选。
#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
###############################################################################
# #
# PRIVILEGED OPERATING SYSTEM GROUPS #
# ------------------------------------------ #
# Provide values for the OS groups to which OSDBA and OSOPER 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 DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#设置授予OSDBA特权的操作系统组，OSDBA用户可执行管理数据库的特殊操作。
#-------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#设置授予OSOPER特权的操作系统组，OSOPER用户有部分管理权限，如启动和关闭数据库等，此参数可选。
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=dba
#------------------------------------------------------------------------------
# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.
#授予OSBACKUPDBA特权的操作系统组，用于数据库备份相关操作。
#------------------------------------------------------------------------------
oracle.install.db.BACKUPDBA_GROUP=dba
#------------------------------------------------------------------------------
# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.
#授予OSDGDBA特权的操作系统组，用于 Data Guard 相关管理操作。
#------------------------------------------------------------------------------
oracle.install.db.DGDBA_GROUP=dba
#------------------------------------------------------------------------------
# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.
#授予OSKMDBA特权的操作系统组，涉及数据库安全和加密相关操作。
#------------------------------------------------------------------------------
oracle.install.db.KMDBA_GROUP=dba
###############################################################################
# #
# Grid Options #
# #
###############################################################################
#------------------------------------------------------------------------------
# Specify the type of Real Application Cluster Database
#
# - ADMIN_MANAGED: Admin-Managed
# - POLICY_MANAGED: Policy-Managed
#指定实时应用集群（RAC）数据库的类型，ADMIN_MANAGED为管理员管理模式，POLICY_MANAGED为策略管理模式，不设置默认为ADMIN_MANAGED。
#
# If left unspecified, default will be ADMIN_MANAGED
#------------------------------------------------------------------------------
oracle.install.db.rac.configurationType=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is ADMIN_MANAGED
#
# Specify the cluster node names selected during the installation.
# Leaving it blank will result in install on local server only (Single Instance)
# 在ADMIN_MANAGED模式下，指定集群节点名称，留空则安装为单实例数据库。
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=
#------------------------------------------------------------------------------
# This variable is used to enable or disable RAC One Node install.
#
# - true : Value of RAC One Node service name is used.
# - false : Value of RAC One Node service name is not used.
#
# If left blank, it will be assumed to be false.
#设置是否启用 RAC One Node 安装，true启用，false不启用，留空默认为false。
#------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=false
#------------------------------------------------------------------------------
# Value is required only if oracle.install.db.isRACOneInstall is true.
#
# Specify the name for RAC One Node Service
当启用 RAC One Node 安装时，指定 RAC One Node 服务名称。
#------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a name for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolName=pool1
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a number as cardinality for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolCardinality=2
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolCardinality=0
###############################################################################
# #
# 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.
指定创建数据库的类型，GENERAL_PURPOSE适用于通用或事务繁重的应用；DATA_WAREHOUSE针对数据仓库应用优化。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
#-------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
指定起始数据库的全局数据库名称，在网络中唯一标识数据库。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=orcl
#-------------------------------------------------------------------------------
# Specify the Starter Database SID.
指定起始数据库的系统标识符，是数据库实例的唯一标识，与globalDBName相互关联。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=orcl
#-------------------------------------------------------------------------------
# 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".
设置是否将数据库配置为容器数据库，true为是，false为否，留空默认为false。
#-------------------------------------------------------------------------------
oracle.install.db.ConfigureAsContainerDB=false
#-------------------------------------------------------------------------------
# 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=ZHS16GBK
#------------------------------------------------------------------------------
# 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.
设置是否启用数据库自动内存管理，true启用，由数据库自动分配内存；false则手动分配内存。
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=true
#-------------------------------------------------------------------------------
# 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
指定数据库的总内存分配量（单位为 MB），需在 256MB 到系统可用物理内存之间。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=10240
#-------------------------------------------------------------------------------
# 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".
设置是否在起始数据库中加载示例模式，true加载，false不加载，留空默认为false。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=false
###############################################################################
# #
# 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.
为起始数据库中的所有模式（如SYS、SYSTEM、DBSNMP等）设置相同密码，不推荐此方式。
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=Orcl_88888888
#-------------------------------------------------------------------------------
# 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.
#-------------------------------------------------------------------------------
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=DEFAULT
#-------------------------------------------------------------------------------
# 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=0
#-------------------------------------------------------------------------------
# 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=false
#-------------------------------------------------------------------------------
# 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=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
# 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=/home/oracle/oradata
#-------------------------------------------------------------------------------
# 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=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example : MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=
#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example : PROXY_HOST=proxy.domain.com
#------------------------------------------------------------------------------
PROXY_HOST=
#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and at least 2 chars.
#
# Example : PROXY_PORT=25
#------------------------------------------------------------------------------
PROXY_PORT=
#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_USER=username
#------------------------------------------------------------------------------
PROXY_USER=
#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_PWD=password
#------------------------------------------------------------------------------
PROXY_PWD=
#------------------------------------------------------------------------------
# Specify the Oracle Support Hub URL.
#
# Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/
#------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用。你还可以使用@来通知其他用户。