ORACLE笔记

最新推荐文章于 2022-07-17 20:58:13 发布

DimonHo

最新推荐文章于 2022-07-17 20:58:13 发布

阅读量1.1k

点赞数 1

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.csdn.net/vampirehgg/article/details/48979367

版权

oracle 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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 xcrmspace
DATAFILE 'D:\app\administrator\oradata\orcl\xcrmspace.DBF'
SIZE 50M
AUTOEXTEND on
NEXT 10M
MAXSIZE 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 ptbackspace
DATAFILE 'D:\app\administrator\oradata\ptswt\ptbackspace.DBF'
SIZE 50M
AUTOEXTEND on
NEXT 10M
MAXSIZE 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;
--删除用户dimon
drop 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';

--生成UUID
select 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=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 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=abc@oracle.com
#------------------------------------------------------------------------------
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=

DimonHo

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ORACLE笔记

ORACLEORACLE创建表空间创建用户创建DIRECTORY创建DB_LINK备份expexpdp恢复impimpdp常用DDL语句建表字段类型约束常用DML语句增删查改DBA管理同义词创建同义词删除同义词查看同义词创建表空间--DROP TABLESPACE ptspace INCLUDING CONTENTS DATAFILES;SQL> C
复制链接

扫一扫