ORACLE笔记

ORACLE

---

数据库环境参数

ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1
SID=ORCL
SERVER_HOST=192.168.31.207
PORT=1521
USER=XCRM
TABLESPACE=XCRMSPACE

创建表空间

--DROP TABLESPACE xcrmspace INCLUDING CONTENTS AND DATAFILES;SQL> CREATE TABLESPACE xcrmspaceDATAFILE 'D:\app\administrator\oradata\orcl\xcrmspace.DBF'SIZE 50MAUTOEXTEND onNEXT 10MMAXSIZE unlimited;

---

创建用户

创建一个用户名为xcrm，密码为swt830905,默认表空间为xcrmspace的用户。

--DROP USER xcrm CASCADE;SQL> CREATE USER xcrm IDENTIFIED BY swt830905 DEFAULT TABLESPACE xcrmspace;

---

创建DIRECTORY

在操作系统中创建供dmp和log文件的存放目录对象dmp_dir=D:\ora_autobackup\dmp_dir。

--DROP DIRECTORY dmp_dir;SQL> CREATE DIRECTORY dmp_dir AS 'D:\ora_autobackup\dmp_dir';SQL> SELECT * FROM dba_directories;

注：D:\ora_autobackup\dmp_dir目录需要先手动创建。

---

创建DB_LINK

当用户要跨本地数据库，访问另外一个数据库表中的数据时，本地数据库中必须创建了远程数据库的DBLINK,通过DBLINK本地数据库可以像访问本地数据库一样访问远程数据库表中的数据。

首先在客户端tnsnames.ora文件中配置服务器端数据库连接串：

CC =    (DESCRIPTION =        (ADDRESS_LIST =            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13)(PORT = 1521))        )        (CONNECT_DATA =            (SERVICE_NAME = CC)        )    )

然后在客户端登陆数据库，给用户授权CREATE DATABASE LINK权限：

SQL> SELECT * FROM dba_sys_privs WHERE privilege LIKE upper('%LINK%');

查询发现数据库中DBLINK有三种权限:
CREATE DATABASE LINK(所创建的DBLINK只能是创建者能使用，别的用户使用不了)，
CREATE PUBLIC DATABASE LINK(PUBLIC表示所创建的DBLINK所有用户都可以使用)，
DROP PUBLIC DATABASE LINK(同上)。

给用户赋权：

SQL> GRANT CREATE PUBLIC DATABASE LINK, DROP PUBLIC DATABASE LINK TO pt;

删除DB_LINK：

SQL> DROP PUBLIC DATABASE LINK to_cc;

创建DB_LINK

SQL> CREATE PUBLIC DATABASE LINK to_cc CONNECT TO system IDENTIFIED BY manager USING 'CC';

to_cc表示DB_LINK的名称，‘CC’表示在第一步中添加的连接串名称。system是指CC这个实例中的用户。
检验是否成功创建，在客户端查询服务器端数据库中的表：

SQL> SELECT owner,object_name FROM dba_objects WHERE object_type='DATABASE LINK';SQL> SELECT * FROM pt.dept@to_cc;

---

备份

exp

该命令可以在客户端执行

cmd> exp system/cc830905@192.168.0.13:1521/ptswt ROWS=y INDEXES=n COMPRESS=n OWNER=pt BUFFER=102400 FILE=D:\ora_autobackup\dmp_dir\pt2015-01-01.dmp LOG=D:\ora_autobackup\dmp_dir\pt2015-01-01_exp.log

expdp

该命令只能在服务器端执行

cmd> expdp system/cc830905@ptswt DIRECTORY=dmp_dir DUMPFILE=pt2015-01-01.dmp LOGFILE=pt2015-01-01_exp.log SCHEMAS=pt COMPRESSION=all

---

恢复

imp

该命令可以在客户端执行

cmd> imp system/cc830905@ptswt FILE=D:\ora_autobackup\dmp_dir\pt2015-01-01.dmp LOG=D:\ora_autobackup\dmp_dir\pt2015-01-01_imp.log FROMUSER=pt TOUSER=ptback COMMIT=y FEEDBACK=10000 BUFFER=102400 IGNORE=y ROWS=y INDEXES=n

impdp

使用impdp之前，最好先删除用户，并创建好表空间。

SQL> DROP USER ptback CASCADE;SQL> CREATE TABLESPACE ptbackspaceDATAFILE 'D:\app\administrator\oradata\ptswt\ptbackspace.DBF'SIZE 50MAUTOEXTEND onNEXT 10MMAXSIZE unlimited;

—– 本地恢复 —–

cmd> impdp systemp/cc830905@ptswt DIRECTORY=dmp_dir DUMPFILE=dumpfile=pt2015-01-01.dmp LOGFILE=pt2015-01-01_imp.log SCHEMAS=pt REMAP_SCHEMA=pt:ptback REMAP_TABLESPACE=ptspace:ptbackspace TRANSFORM=oid:n

—– db_LINK恢复 —–

cmd> impdp systemp/cc830905@ptswt NETWORK_LINK=to_cc SCHEMAS=pt REMAP_SCHEMA=pt:ptback REMAP_TABLESPACE=ptspace:ptbackspace TRANSFORM=oid:n

---

常用DDL语句

建表

字段类型

类型 默认值 限制 说明 number(m,n) m=38,n=0 m=[1,38] n=[-84,127] 数字型,m是位数总长度,n是小数的长度,可存负数,不够位时会四舍五入 varchar2(n) 最大可存储4000字节 可变长度的字符串,必须规定长度。从空间上考虑，用varchar合适；从效率上考虑，用char合适，关键是根据实际情况找到权衡点 char(n) n=1 最大可存储2000byte 固定长度的字符串，CHAR存储定长数据很方便，CHAR字段上的索引效率级高，比如定义char(10)，那么不论你存储的数据是否达到了10个字节，都要占去10个字节的空间，不足的自动在后面用空格填充。 date 日期和时间类型，精确到秒 timestamp(n) n=6 n=[0,9] 日期和时间类型，精确到秒后小数点6位 clob 变长，最大可以存储4G的字符数据 blob 变长，最大可以存储4G的二进制数据，如图片，视频等

约束

约束类型 名称 简写 说明 非空约束 NOT NULL UN 指定的列值不允许为空 唯一约束 UNIQUE KEY UK 指定的列值唯一，可以为空，但只能出现一个空值 主键约束 PRIMARY KEY PK 指定的列唯一，且不允许为空 外键约束 FOREIGN KEY FK 将table_2中的主键列添加到table_1中，那么table_1中的该列就为table_1的外键 条件约束 CHECK CK 指定列可接受的数据格式 默认约束 DEFAULT 指定某列的默认值

强调内容

选择主键的原则：
1. 尽量选择单个键作为主键
2. 必须保证唯一
3. 尽量选择数值更新少的列
4. 一般选择无意义，用户不关心，但程序猿关心的列
5. 可以使用系统的sys_guid作为主键的值
6. 也可以使用INTEGER列自增长做为主键的值

CREATE TABLE t_object(id NUMBER,name VARCHAR2(32),sex CHAR(1),age NUMBER);

---

常用DML语句

增

删

改

查

---

DBA管理

查看SID

SQL> show parameter instance_name

查看数据库控制文件参数

SQL> SELECT name, value FROM v$spparameter;

修改对象所属表空间

ALTER TABLE x_user MOVE TABLESPACE xcrmspace;

查看表空间使用情况

select   a.tablespace_name,a.bytes/1024/1024 "Sum MB",(a.bytes-b.bytes)/1024/1024   "used MB",b.bytes/1024/1024 "free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"      from      (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name)   a,      (select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name)   b      where   a.tablespace_name=b.tablespace_name      order   by   ((a.bytes-b.bytes)/a.bytes)   desc  

“Sum MB”表示表空间所有的数据文件总共在操作系统占用磁盘空间的大小,比如：test表空间有2个数据文件，datafile1为300MB，datafile2为400MB，那么test表空间的“Sum MB”就是700MB；
“userd MB”表示表空间已经使用了多少；
“free MB”表示表空间剩余多少；
“percent_user”表示已经使用的百分比；

重建索引

--普通类型索引重建，或者说修改index的表空间。SQL> ALTER INDEX indexName REBUILD TABLESPACE tablespaceName;--lob类型的索引重建SQL> ALTER TABLE tableName MOVE LOB(col1,col2,...) STORE AS (TABLESPACE tablespaceName);

常用语句

--创建用户名为dimon 密码为xinai7431的用户create user dimon identified by xinai7431;--删除用户dimondrop user dimon;--如果用户拥有对象，则不能直接删除，否则将返回一个错误值。--指定关键字cascade，可删除用户所有的对象，然后再删除用户。下面的例子用来删除用户与其对象：drop user dimon cascade;--三种标准的角色(role)：connect（连接角色）、resource（资源角色）和dba（数据库管理员角色）--给用户dimon赋予connect和resource角色的权限grant connect,resource to dimon;grant select on v_$session to dimon;grant select on v_$sesstat to dimon;grant select on v_$statname to dimon;--撤销用户dimon的connect和resource权限revoke connect, resource from dimon;--创建自定义角色create role hgg;--给角色赋select权限grant select on class to hgg;--删除角色drop role hgg;--删除一个表中全部数据时，一定要使用truncate,--因为用drop table，delete * from 表名时，tablespace表空间该表的占用空间并未释放，--反复几次drop，delete操作后，该tablespace上百兆的空间就被耗光了。--如果要删除该表，可先truncate，再drop。truncate table table_name;--查询所有用户的表和视图select * from all_tab_comments;--查询当前用户的表和视图select * from user_tab_comments;--查询所有用户表的列名以及注释select * from all_col_comments;--查询当前用户表的列名以及注释select * from user_col_comments;--查看指定用户所有的表名,（注：用户名称必须大写）select TABLE_NAME from all_tables where owner = 'DIMON';--生成UUIDselect sys_guid() from dual;

---

同义词

定义：从字面上理解就是别名的意思，和视图的功能类似。就是一种映射关系。

创建同义词

CREATE [OR REPLACE] SYNONYM [schema.]synonym_name FOR [schema.]object_name;

删除同义词

DROP PUBLIC SYNONYM synonym_name;

查看同义词

SELECT * FROM dba_synonyms;SELECT * FROM user_synonyms;SELECT * FROM all_synonyms;

附件

• ORACLE安装信息db.rsp

###################################################################### Copyright(c) Oracle Corporation 1998,2011. 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_v11_2_0#-------------------------------------------------------------------------------# Specify the installation option.# It can be one of the following:# 1. INSTALL_DB_SWONLY# 2. INSTALL_DB_AND_CONFIG# 3. 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_HOSTNAME=WIN-1IIMO81D2JM#-------------------------------------------------------------------------------# 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=C:\Program Files\Oracle\Inventory#-------------------------------------------------------------------------------# 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  #-------------------------------------------------------------------------------SELECTED_LANGUAGES=zh_CN,en#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Home. #-------------------------------------------------------------------------------ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1#-------------------------------------------------------------------------------# Specify the complete path of the Oracle Base. #-------------------------------------------------------------------------------ORACLE_BASE=D:\app\Administrator#-------------------------------------------------------------------------------# Specify the installation edition of the component.                     #                                                             # The value should contain only one of these choices.        # EE     : Enterprise Edition                                # SE     : Standard Edition                                  # SEONE  : Standard Edition One# PE     : Personal Edition (WINDOWS ONLY)#-------------------------------------------------------------------------------oracle.install.db.InstallEdition=EE#-------------------------------------------------------------------------------# This variable is used to enable or disable custom install and is considered# only if InstallEdition is EE.## true  : Components mentioned as part of 'optionalComponents' property#         are considered for install.# false : Value for 'optionalComponents' is not considered.#-------------------------------------------------------------------------------oracle.install.db.EEOptionsSelection=false#-------------------------------------------------------------------------------# This property is considered only if 'EEOptionsSelection' is set to true ## Description: List of Enterprise Edition Options you would like to enable.##              The following choices are available. You may specify any#              combination of these choices.  The components you choose should#              be specified in the form "internal-component-name:version"#              Below is a list of components you may specify to enable.#        #              oracle.oraolap:11.2.0.3.0 - Oracle OLAP#              oracle.rdbms.dm:11.2.0.3.0 - Oracle Data Mining RDBMS Files#              oracle.rdbms.dv:11.2.0.3.0- Oracle Database Vault option#              oracle.rdbms.lbac:11.2.0.3.0 - Oracle Label Security#              oracle.rdbms.partitioning:11.2.0.3.0 - Oracle Partitioning#              oracle.rdbms.rat:11.2.0.3.0 - Oracle Real Application Testing#-------------------------------------------------------------------------------oracle.install.db.optionalComponents=################################################################################                                                                             ## 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.#-------------------------------------------------------------------------------oracle.install.db.DBA_GROUP=#------------------------------------------------------------------------------# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.# The value to be specified for OSOPER group is optional.#------------------------------------------------------------------------------oracle.install.db.OPER_GROUP=#-------------------------------------------------------------------------------# Specify the cluster node names selected during the installation.                                      # 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.#------------------------------------------------------------------------------oracle.install.db.isRACOneInstall=false#------------------------------------------------------------------------------# Specify the name for RAC One Node Service. #------------------------------------------------------------------------------oracle.install.db.racOneServiceName=#-------------------------------------------------------------------------------# Specify the type of database to create.# It can be one of the following:# - GENERAL_PURPOSE/TRANSACTION_PROCESSING                       # - 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.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.SID=orcl#-------------------------------------------------------------------------------# 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.#------------------------------------------------------------------------------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#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.memoryLimit=819#-------------------------------------------------------------------------------# This variable controls whether to load Example Schemas onto# the starter database or not.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.installExampleSchemas=true#-------------------------------------------------------------------------------# This variable includes enabling audit settings, configuring password profiles# and revoking some grants to public. These settings are provided by default. # These settings may also be disabled.     #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.enableSecuritySettings=true################################################################################                                                                             ## Passwords can be supplied for the following four schemas in the         ## starter database:                                   ##   SYS                                                                       ##   SYSTEM                                                                    ##   SYSMAN (used by Enterprise Manager)                                       ##   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 SYSMAN password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYSMAN=#-------------------------------------------------------------------------------# Specify the DBSNMP password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.DBSNMP=#-------------------------------------------------------------------------------# Specify the management option to be selected for the starter database. # It can be one of the following:# 1. GRID_CONTROL# 2. DB_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.control=DB_CONTROL#-------------------------------------------------------------------------------# Specify the Management Service to use if Grid Control is selected to manage # the database.      #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=################################################################################                                                                             ## SPECIFY BACKUP AND RECOVERY OPTIONS                                         ## ------------------------------------                                    ## Out-of-box backup and recovery options for the database can be mentioned    ## using the entries below.                            # #                                                                             #################################################################################------------------------------------------------------------------------------# This variable is to be set to false if automated backup is not required. Else # this can be set to true.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.enable=true#------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user that is # specified in this variable.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.osuid=Administrator#-------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user specified by the # above entry. The following entry stores the password for the above operating # system user.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.ospwd=#-------------------------------------------------------------------------------# 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=D:\app\Administrator\oradata#-------------------------------------------------------------------------------# Specify the backup and recovery location.## Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=D:\app\Administrator\recovery_area#-------------------------------------------------------------------------------# 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=[e-mail]#------------------------------------------------------------------------------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 atleast 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 proxy realm. ## Example    : PROXY_REALM=metalink#------------------------------------------------------------------------------PROXY_REALM=#------------------------------------------------------------------------------# Specify the Oracle Support Hub URL. # # Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/#------------------------------------------------------------------------------COLLECTOR_SUPPORTHUB_URL=#------------------------------------------------------------------------------# Specify the auto-updates option. It can be one of the following:# a.MYORACLESUPPORT_DOWNLOAD# b.OFFLINE_UPDATES# c.SKIP_UPDATES#------------------------------------------------------------------------------oracle.installer.autoupdates.option=SKIP_UPDATES#------------------------------------------------------------------------------# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where# the updates are to be downloaded.# In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present.oracle.installer.autoupdates.downloadUpdatesLoc=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username which has the patches download privileges  # to be used for software updates.#  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=[e-mail]#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_USERNAME=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username password which has the patches download privileges  # to be used for software updates.## Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_PASSWORD=