企业级部署内网环境往往不能直接使用图形化安装界面，了解技术原理可以使用静默安装
本文会包含实际命令，易错点及输出log，免费干货，适合自学练手
以单机19c为例子，无PDB
仅安装软件
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.27/db1
mkdir -p /u01/app/oraInventory
chmod 755 /u01/app/oracle
chmod 755 /u01/app/oracle/product/19.27/db1
chmod 755 /u01/app/oraInventory
[oracle@dev01 tmp]$ cat /tmp/db_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oinstall
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.27/db1
INVENTORY_LOCATION=/u01/app/oraInventory
oracle.install.db.InstallEdition=EE
DECLINE_SECURITY_UPDATES=true
mv /tmp/LINUX.X64_193000_db_home.zip /u01/app/oracle/product/19.27/db1
unzip LINUX.X64_193000_db_home.zip
cd $ORACLE_HOME
./runInstaller -silent -responseFile /tmp/db_install.rsp
安装数据库
mkdir -p /u01/app/oracle/oradata
mkdir -p /u01/app/oracle/fast_recovery_area
chmod 775 /u01/app/oracle/oradata
chmod 775 /u01/app/oracle/fast_recovery_area
###注意这是一整行命令只有空格，无换行，<>里面内容替换
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName <dbname> -sid <sidname> -createAsContainerDatabase false -characterset AL32UTF8 -databaseType MULTIPURPOSE -sysPassword <sys密码> -systemPassword <system密码> -redoLogFileSize 2048 -storageType FS -datafileDestination /u01/app/oracle/oradata -recoveryAreaDestination /u01/app/oracle/fast_recovery_area -obfuscatedPasswords false -emConfiguration NONE -sampleSchema false -totalMemory 4096
###正常成功log
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/prod.
Database Information:
Global Database Name:prod
System Identifier(SID):prod
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/prod/prod.log" for further details.
常见报错
1.DBT-10317
安装数据库失败后需要删除配置文件后再重试
cd $ORACLE_HOME/dbs
rm -rf hc_<sid>.dat
ps -ef | grep pmon
杀掉对应的进程
kill -9 <id>
##报错log
[FATAL] [DBT-10317] Specified SID Name (watprod) already exists.
ACTION: Specify a different SID Name that does not already exist.
2.DBT-05509
oracle用户下的.bash_profile文件里面缺少NLS_LANG环境变量，加上去source一下就行
[FATAL] [DBT-05509] Failed to connect to the specified database (watprod).
CAUSE: OS Authentication might be disabled for this database (watprod).
ACTION: Specify a valid sysdba user name and password to connect to the database.
3.[FATAL] ORA-03114
$ORACLE_HOME/dbs/hc_<sid>.dat 文件没有删除
WARNING] ORA-01081: cannot start already-running ORACLE - shut it down first
[WARNING] ORA-03113: end-of-file on communication channel
[FATAL] ORA-03114: not connected to ORACLE
40% complete
100% complete
[FATAL] ORA-03114: not connected to ORACLE
静默删库的语句，需要数据库在open状态下执行
[oracle@dev01 admin]$ dbca -silent -deleteDatabase -sourceDB <dbname> -sysDBAUserName sys -sysDBAPassword <sys密码>
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
39% complete
42% complete
45% complete
48% complete
52% complete
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/prod/prod3.log" for further details.
转载自 CSDN-专业IT技术社区
原文链接：https://blog.csdn.net/qq_41474349/article/details/170136125
