06-OracleEV_Oracle01配置

1. 修改IP、主机名和hosts文件

vim /etc/sysconfig/network-scripts/ifcfg-ens33
systemctl restart network
hostnamectl status
hostnamectl set-hostname oracle01
vim /etc/hosts
192.168.39.15    oracle01
复制

2. 安装数据库软件

cd /opt/database/response
vim db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=oracle01
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=744
oracle.install.db.config.starterdb.password.ALL=Oracle12#$
DECLINE_SECURITY_UPDATES=true
cd /opt/database
./runInstaller -silent -force -responseFile /opt/database/response/db_install.rsp -ignorePrereq
复制

3. 执行脚本

su - root
cd /u01/app/oraInventory
./orainstRoot.sh
cd /u01/app/oracle/product/11.2.0/dbhome_1
./root.sh
复制

4. 创建监听

netca /silent /responseFile /opt/database/response/netca.rsp
复制

5. 安装数据库

cd /opt/database/response
vim dbca.rsp
GDBNAME = "orcl"
SID = "orcl"
SYSPASSWORD = "Oracle12#$"
SYSTEMPASSWORD = "Oracle12#$"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16"
dbca -silent -responseFile /opt/database/response/dbca.rsp
复制

6. 启停命令

# 查看监听状态
lsnrctl status
# 开启监听
lsnrctl start
sqlplus / as sysdba
# 启动数据库实例
startup
# 关闭数据库实例
shutdown immediate
# 关闭监听
lsnrctl stop
复制