Oracle 11.2.0.3.0 RAC Silent Install-3Nodes

最新推荐文章于 2024-01-09 19:49:30 发布
最新推荐文章于 2024-01-09 19:49:30 发布
阅读量2.1k 收藏
点赞数 1
分类专栏： Oracle RAC
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zbdba/article/details/20853277
版权

Environment:

OS:RedHat 6.3

Oracle Media:11.2.3.0

Theory:

 

 

haovw002

1.config host
192.168.1.165 zbdba1
192.168.1.167 zbdba2
192.168.1.178 zbdba3

192.168.1.166 zbdba1-vip
192.168.1.168 zbdba2-vip
192.168.1.179 zbdba3-vip

172.168.1.181 zbdba1-priv
172.168.1.182 zbdba2-priv
172.168.1.183 zbdba3-priv

192.168.1.169 node-cluster node-cluster-scan

2.firewall and selinux
service iptables stop
chkconfig iptables off
chkconfig --list iptables

3.kernel:
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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 = 1048586

 

4.create user and group:
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 asmadmin
groupadd -g 504 asmdba
useradd -u 501 -g oinstall -G dba,asmdba -d /home/oracle oracle
useradd -u 502 -g oinstall -G asmdba,asmadmin,dba -d /home/grid grid

 

5.create dictionary:
mkdir -p /opt/oracle/products/
mkdir -p /opt/oracle/products/11.2.0
mkdir -p /opt/oracle/diag
mkdir -p /opt/ogrid
mkdir -p /opt/grid/products/
mkdir -p /opt/grid/oraInventory/
mkdir -p /opt/grid/products/11.2.0
mkdir -p /opt/oraInventory

chown -Rf oracle:oinstall /opt/oracle
chown -Rf grid:oinstall /opt/grid
chown -Rf grid:oinstall /opt/ogrid
chown -Rf grid:oinstall /opt/oraInventory
6.OpenSSH:
first: unzip the install-package
/database/grid/sshsetup/sshUserSetup.sh -user grid -hosts "zbdba1 zbdba2 zbdba3" -noPromptPassphrase -confirm -advanced
/database/database/sshsetup/sshUserSetup.sh -user oracle -hosts "zbdba1 zbdba2 zbdba3" -noPromptPassphrase -confirm -advanced
7.limits:
oracle soft nproc 4096
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 4096
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768

 

8.package
oracle recomends:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

you should have configed yum local source
yum install -y binutils-* compat-libcap1* compat-libstdc++-* gcc-* glibc-* glibc-devel-* ksh* libgcc-* libstdc++-* libstdc++-devel-* libaio-* libaio-devel-* make-* sysstat-* elfutils-libelf-devel-*
9.asmdisk:
use iscsid
yum install -y iscsi-initiator-utils
iscsi:
iscsiadm --mode discoverydb --type sendtargets --portal 192.168.1.201 --discover
iscsiadm --mode node --targetname zhaojingbo.woqutech.com --portal 192.168.1.201:3260 –login

注意设置开机自动生效：chkconfig iscsid on service iscsid start
udev:
for i in b c d a;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
10.check:
./runcluvfy.sh stage -pre crsinst -n zbdba1,zbdba2,zbdba3 -verbose

 

11.config Oracle environment variable:
[oracle bash_profile]
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/products/11.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=book1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
umask 022

[grid bash_profile]
export ORACLE_HOME=/opt/grid/products/11.2.0
export ORACLE_BASE=/opt/ogrid
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=+ASM1
umask 022

 

12.install grid:
./runInstaller -silent -responseFile /home/grid/grid_install.rsp -showProgress -ignorePrereq
orainstRoot.sh root.sh需手动执行 ,root.sh执行错误，回退：
留一个节点，在其他节点运行
/opt/grid/products/11.2.0/crs/install/rootcrs.pl -verbose -deconfig -force

在最后一个节点，运行（这个会清除OCR,VOTING和他们的ASM DG）
/opt/grid/products/11.2.0/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode
VOTING盘大于等于2G
cd /opt/grid/oraInventory/ContentsXML/inventory.xml 添加属性CRS="TRUE"
<HOME_LIST>
<HOME NAME="Ora11g_gridinfrahome1" LOC="/opt/grid/products/11.2.0" TYPE="O" IDX="1" CRS="true">
<NODE_LIST>
<NODE NAME="rac1"/>
<NODE NAME="rac2"/>
</NODE_LIST>
</HOME>
isntall database:
./runInstaller -silent -responseFile /home/oracle/db_install.rsp -showProgress -ignorePrereq
root.sh手动执行
/opt/grid/products/11.2.0/crs/install/crsconfig_params

 

 

db_install.rsp
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

 

 
################################### Manually Edit ############################################

ORACLE_HOSTNAME=zbdba1
oracle.install.db.CLUSTER_NODES=zbdba1,zbdba2,zbdba3

###############################################################################################

 

 

 

 
oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/opt/grid/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/opt/oracle/products/11.2.0

ORACLE_BASE=/opt/oracle

oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false

oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=asmadmin

 

#------------------------------------------------------------------------------
# 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=

#------------------------------------------------------------------------------
# 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 the Starter Database character set.
#
# It can be 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=AL32UTF8

#------------------------------------------------------------------------------
# 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=

oracle.install.db.config.starterdb.installExampleSchemas=false

#------------------------------------------------------------------------------
# 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

#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=oracle

#-------------------------------------------------------------------------------
# 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=

#-------------------------------------------------------------------------------
# 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=false

#------------------------------------------------------------------------------
# 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=

#-------------------------------------------------------------------------------
# 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=ASM_STORAGE

#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=data

#-------------------------------------------------------------------------------
# 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=oracle

#------------------------------------------------------------------------------
# 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=

#------------------------------------------------------------------------------
# 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. This value is used if auto-updates option is selected.
#
# 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=

 

 

 

grid_install.rsp

 
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0

 
############################# Manually Edit #########################################################
ORACLE_HOSTNAME=zbdba1
oracle.install.crs.config.gpnp.scanName=node-cluster-scan
oracle.install.crs.config.clusterName=node-cluster

oracle.install.crs.config.clusterNodes=zbdba1:zbdba1-vip,zbdba2:zbdba2-vip,zbdba3:zbdba3-vip

##### (1 indicates public, 2 indicates private, and 3 indicates the interface is not used)
oracle.install.crs.config.networkInterfaceList=eth0:192.168.1.0:1,eth1:172.168.1.0:2

oracle.install.asm.diskGroup.disks=/dev/asm-diska,/dev/asm-diskb,/dev/asm-diskc
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*

######################################################################################################

 

 

 

 

 
INVENTORY_LOCATION=/opt/grid/oraInventory
SELECTED_LANGUAGES=en
oracle.install.option=CRS_CONFIG
ORACLE_BASE=/opt/ogrid
ORACLE_HOME=/opt/grid/products/11.2.0
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmadmin
oracle.install.asm.OSASM=asmadmin

oracle.install.crs.config.gpnp.scanPort=1521

oracle.install.crs.config.gpnp.configureGNS=false
oracle.install.crs.config.gpnp.gnsSubDomain=
oracle.install.crs.config.gpnp.gnsVIPAddress=
oracle.install.crs.config.autoConfigureClusterNodeVIP=

oracle.install.crs.config.storageOption=ASM_STORAGE

oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL

################################################################################
# #
# SECTION F - IPMI #
# #
################################################################################
oracle.install.crs.config.useIPMI=false
oracle.install.crs.config.ipmi.bmcUsername=
oracle.install.crs.config.ipmi.bmcPassword=

################################################################################
# #
# SECTION G - ASM #
# #
################################################################################
oracle.install.asm.SYSASMPassword=Welcome1
oracle.install.asm.diskGroup.name=OCRVOTE
oracle.install.asm.diskGroup.redundancy=EXTERNAL
oracle.install.asm.diskGroup.AUSize=1
oracle.install.asm.monitorPassword=Welcome1

################################################################################
# #
# SECTION H - UPGRADE #
# #
################################################################################

oracle.install.crs.upgrade.clusterNodes=
oracle.install.asm.upgradeASM=false
#------------------------------------------------------------------------------
# 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

oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=

 

zbdba
关注
专栏目录
abaqus学习笔记-abaqus与umat调用基本原理
weixin_34260991的博客
11-01 4339
参考： 1.http://ivt-abaqusdoc.ivt.ntnu.no:2080/v6.14/books/sub/default.htm 2.ABAQUS 用户材料子程序开发及应用-杨曼娟 3.费康老师abaqus书 4.论坛：http://www.mechbbs.com/forum.php?mod=viewthread&tid=104&highlight=abaq...
2021-06-24
hdmdjjn的博客
06-24 481
大数据学习中的错误 问题1 1.要先搭建zookeeper 在再搭建hbase 而且搭建hbase的时候 hbase_env.sh 里面的 HBASE_MANAGES_ZK=false 不能等于true ,因为hbase本身自带zookeeper，所以要把hbase里面的zookeeper关掉，，，才可以。 问题2 2、问题：start-all.sh 启动hadoop时看日志发现报错：org.apache.hadoop.hdfs.DFSClient: DataStreamer Exc
[WARNING] The assembly id assembly is used more than once.
qq 117791303
01-09 569
[WARNING] The assembly id assembly is used more than once.
SQL Server——从入门到放弃（10）– CHECK / CONSTRAINT / TRIGGER / PROCEDURE/ FUNCTION 练习
12-14
又是新的一章开始了，今天开始的是第五章的内容——数据库完整性 所谓数据库的完整性指的是 数据的正确性 * 数据是符合现实世界语义，反映了当前实际状况的 数据的相容性 * 同一对象在不同关系表中的数据是符合逻辑的 一、实体完整性 关系模型的实体完整性是通过在CREATE TABLE中使用PRIMARY KEY来定义的。具体使用方法有两种，一种是在列级定义主码，另一种是在表级定义主码。 【例5.1】将Student表中的Sno属性定义为码 列级定义主码 create table Student1 (Sno char(9) primary key, Sname char(20) not null,
mysql启动和关闭外键约束的方法(FOREIGN_KEY_CHECKS)
热门推荐
程序员囧辉
05-02 8万+
在MySQL中删除一张表或一条数据的时候，出现[Err] 1451 -Cannot deleteor update a parent row: a foreign key constraint fails (...)这是因为MySQL中设置了foreign key关联，造成无法更新或删除数据。可以通过设置FOREIGN_KEY_CHECKS变量来避免这种情况。我们可以使用 SET FORE...
oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.zip
07-22
这个压缩包"oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.zip"是针对64位Linux系统的一个特定版本，包含了Oracle Instant Client的开发组件。 1. Oracle Instant Client的核心功能： - 数据库连接：提供...
Oracle客户端-v11.2.0.3.0-x86
08-25
Oracle客户端-v11.2.0.3.0-x86
oracle64位客户端 Instant Client v11.2.0.3.0(64-bit)
02-19
Oracle 64位客户端Instant Client v11.2.0.3.0是Oracle数据库连接器的一个重要组件，专门设计用于64位操作系统环境。这个版本的客户端为开发者和系统管理员提供了一种轻量级的方式来连接到Oracle数据库服务器，而...
linux下oracle客户端oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm.rar
11-06
linux环境中的oracle客户端远程安装包 oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64....
oracle v-11.2.0.4.0 Oracle 11.2.0.4 For Windows 64bit+32bit 数据库
08-04
Oracle 11g Release 2 (11.2.0.4) 是Oracle数据库的一个重要版本，特别适合Windows 64位和32位操作系统。这个版本提供了多种组件和服务，以满足不同用户的需求，包括数据库服务器、Grid Infrastructure、客户端、...
Oracle Golden Gate 系列五 -- GG 使用配置 说明
David Dai -- Focus on Oracle
11-08 2万+
一. Preparing the database for Oracle GoldenGate1.1 Preparing constraints for Oracle GoldenGateThe followingtable attributes must be addressed in an Oracle GoldenGate environment.1.1.1 Disabling trigge
Oracle Check约束用法详解
yql791237384的博客
04-16 5114
Oracle Check约束用法详解 目标 实例讲解在Oracle中如何使用CHECK约束(创建、启用、禁用和删除) 什么是Check约束？ CHECK约束指在表的列中增加额外的限制条件。 注： CHECK约束不能在VIEW中定义。 CHECK约束只能定义的列必须包含在所指定的表中。 CHECK约束不能包含子查询。 创建表时定义CHECK约束 3.1 语法： [sql] view plain c...
abaqus单位怎么设置_Abaqus常见报错问题及解决方案
weixin_39861054的博客
11-22 4090
Hello~此篇文章为Abaqus爬坑指南系列的第四篇，我们来聊一聊Abaqus常见的报错原因和解决方案。写这一专题一开始我是拒绝的，毕竟要回忆起每天抓耳挠腮气急败坏的惨痛经历...But，俗话说，前人栽树后人乘凉，只能牺牲一下小我，希望能够让这个世界脱发的问题能够减缓一些些...此处引用《Abaqus有限元分析常见问题解答》书中的一句话：“学习Abaqus的过程，既有”山重水复疑无路“时的苦闷，...
定位详解(二) Overconstrained
jlin991的博客
01-21 1203
2.2 绝对定位前面一篇文章我们提到了 如果加入了right bottom width 的限制?也就是我们的绝对定位元素声明了尺寸，而且left top 是显式声明了的值，另外两个时auto，这时怎么处理？先看非替换元素非替换元素的放置和大小一般地，元素的大小和位置取决于其包含块。 各个属性的值都会有影响，不过最主要还是其包含块~！考虑一个定位元素的宽度和水平放置。 可以表示为一个等式： lef
oracle学习笔记(十八)：oracle 中的 检查约束（check 约束）
秋忆夏伤的博客
10-12 1719
创建一个表 users，包括 id,name,gender,salary 字段，使用 check 约束【性别只能是 男或女，薪水介于 6000 到 8000 之间】 SQL> create table users( 2 id number(5) primary key, 3 name varchar2(10) not null unique, 4 gende...
【变压器】基于matlab周期图法和多椎体法变压器噪声信号频谱分析【Matlab仿真 4203期】.zip
11-10
CSDN Matlab武动乾坤上传的资料均有对应的代码，代码均可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描博客文章底部QQ名片； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作
【信道估计】基于matlab OFDM系统LS和DFT和MMSE信道估计（含信噪比）【Matlab仿真 5069期】.zip
最新发布
11-10
【信道估计】基于matlab OFDM系统LS和DFT和MMSE信道估计（含信噪比）【Matlab仿真 5069期】.zip
【信息融合】基于matlab无迹卡尔曼滤波UKF无反馈最优分布式融合【含Matlab源码 9099期】.mp4
11-10
Matlab领域上传的视频均有对应的完整代码，皆可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值