oracle19c下载、静默安装、实例安装、监听配置详细过程oracle 19c下载
oracle 版本说明
手表referenceOracle12cR2=12.2.0.1
Oracle18C=12.2.0.2
Oracle19c=12.2.0.3
⼀、修改环境(安装依赖包,修改内核参数)。
a.安装依赖包
yum Install -y compat-libcap libstdc++-devel sysstat ksh glibc-devel libaio-devel smartmontools net-tools zip unzip
b.修改内核参数
vi /f
net.ipv4.ip_forward = 0
f.default.rp_filter = 1
f.default.accept_source_route = 0
kernel.sysrq = 0
<_uses_pid = 1
p_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max= 6815744
fs.aio-max-nr = 1048576
sysctl -p
vi /etc/f
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
password error是什么意思中文oracle soft stack 10240
⼆、创建⽤户,组
groupadd oper
java下载过程groupadd dba
groupadd asmdba
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd racdba
groupadd oinstall
useradd oracle
usermod -g oinstall -G oper,dba,asmdba,backupdba,dgdba,kmdba,racdba oracle
程序员培训下发通知mkdir -p /u19/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u19/app/oraInventory
chmod +755 -R /u19/app/
chown -R oracle:oinstall /u19
三、配置环境变量
su - oracle
vi .bash_profile
export ORACLE_SID=orcl
export ORACLE_BASE=/u19/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LANG=zh_CN.UTF-8
export NLS_LANG='AMERICAN_AMERICA.AL32UTF8'
#解决sqlplus 上下键,删除键乱码问题。需要安装rlwrap,依赖包readlines,libtermcap-devel
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'
sql语言是关系数据库的国际标准语言四、解压⽂件(直接解压到oracle_home下)
cd $ORACLE_HOME
unzip LINUX.X64_193000_db_home.zip
五、⽣成响应⽂件 $ORACLE_HOME/db_install.rsp (响应⽂件中不需要指定oracle_home)
sponseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u19/app/oraInventory
ORACLE_BASE=/u19/app/oracle
#db版本 EE企业版 SE标准版
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oper
oracle.install.db.OSBACKUPDBA_GROUP=backupdba
oracle.install.db.OSDGDBA_GROUP=dgdba
oracle.install.db.OSKMDBA_GROUP=kmdba
oracle.install.db.OSRACDBA_GROUP=racdba
#⾃动执⾏root脚本,false不⾃动执⾏,true ⾃动执⾏,true需要输⼊root密码
oracle.uteRootScript=false
oracle.figMethod=ROOT
六、安装数据库
sh $ORACLE_HOME/runInstaller -silent -noconfig -force -ignorePrereq -responseFile $ORACLE_HOME/db_install.rsp [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2019
12-06_01-06-54PM/installActions2019-12-06_01-06-54PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2019-12-
06_01-06-54PM/installActions2019-12-06_01-06-
54PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and
The response file for this session can be found at:
/u19/u19/app/oracle/product/19.3.0/dbhome_1/install/response/db_2019-12-06_01-06-54PM.rsp
You can find the log of this install session at:
/u19/app/oraInventory/logs/InstallActions2019-12-06_01-06-54PM/installActions2019-12-06_01-06-5
4PM.log
Successfully Setup Software with warning(s).
执⾏root脚本:
su - root
sh /u19/app/oraInventory/orainstRoot.sh
sh /u19/app/oracle/product/19.3.0/dbhome_1/root.sh
七、静默⽅式创建单实例
a.配置响应⽂件$ORACLE_HOME/dbca.rsp
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=orcl
sid=orcl
sysPassword=orcl
oracleHomeUserPassword=orcl
emExpressPort=5500
totalMemory=2048
b.安装实例orcl
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile
$ORACLE_HOME/dbca.rsp
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain a
t least 1 uppercase charac
9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase charac
9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase charac
9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/u19/app/oracle/cfgtoollogs/dbca/lhr19c.
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论