| root用户操作 | oracle用户操作 |
环境 | 阿里云ECS Centos7.3 4C 8G |
关闭防火墙 | systemctl stop firewalld systemctl disable firewalld | |
禁用Selinux | sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config | |
添加swap (有可以不加) | dd if=/dev/zero of=/swapfile1 bs=1024 count=524288 #512M mkswap /swapfile1 swapon /swapfile1 /swapfile1 swap swap defaults 0 0 | |
安装依赖 | cd /etc/yum.repos.d wget http://public-yum.oracle.com/public-yum-ol7.repo wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle yum install oracle-rdbms-server-11gR2-preinstall -y #oracle-rdbms-server-11gR2-preinstall所做事项 1.自动安装oracle所需的RPM包 2.自动创建oracle用户和group组 3.自动配置/etc/sysctl.conf内核参数 4.自动配置/etc/security/limits.conf参数 | |
创建目录 | mkdir -p /u01/oracle/product/11.2.0/db_1 chown oracle:oinstall -R /u01 chmod 755 -R /u01/oracle | |
切换用户 | su - oracle | |
上传安装包 | | cd /u01/ rz linux.x64_11gR2_database_1of2.zip rz linux.x64_11gR2_database_2of2.zip |
解压安装包 | | unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip |
修改环境变量 | | cd ~ 编辑文件: vi .bash_profile export TMP=/tmp export TMPDIR=$TMP export ORACLE_BASE=/u01/oracle export ORACLE_HOME=/u01/oracle/product/11.2.0/db_1 export ORACLE_SID=orcl #将要创建的数据库实例的名字 export ORACLE_TERM=xterm export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export EDITOR=vim export NLS_LANG=AMERICAN_AMERICA.UTF8 export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' #使变量生效 source .bash_profile |
配置安装应答 | | cd /u01/database/response cat db_install.rsp | grep -v "#"|grep -v "^$" oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=test-oracle #(不知道的可以通过hostname命令查询) UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/oracle/oraInventory SELECTED_LANGUAGES=en,zh_CN ORACLE_HOME=/u01/oracle/product/11.2.0/db_1 ORACLE_BASE=/u01/oracle oracle.install.db.InstallEdition=EE oracle.install.db.isCustomInstall=false oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0 oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oinstall oracle.install.db.CLUSTER_NODES= oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.globalDBName=ora11g 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=512 oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.password.ALL=oracle oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.SYSMAN= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false oracle.install.db.config.starterdb.dbcontrol.emailAddress= oracle.install.db.config.starterdb.dbcontrol.SMTPServer= oracle.install.db.config.starterdb.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid= oracle.install.db.config.starterdb.automatedBackup.ospwd= oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword= MYORACLESUPPORT_USERNAME= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT= DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= |
安装oracle软件 | | /u01/database/runInstaller -silent -force -ignorePrereq -responseFile /u01/database/response/db_install.rsp |
执行配置脚本 | /u01/oracle/oraInventory/orainstRoot.sh /u01/oracle/product/11.2.0/db_1/root.sh | |
安装监听 | | su - oracle cd /u01/database $ORACLE_HOME/bin/netca /silent /responseFile /u01/database/response/netca.rsp lsnrctl status lsnrctl start |
配置dbca | | vi /u01/database/response/dbca.rsp GDBNAME = "orcl.test-oracle" #78行,全局数据库名字 sid+hostname SID = "orcl" #149行 CHARACTERSET = "AL32UTF8" #415行,编码 NATIONALCHARACTERSET= "UTF8" #425行 |
创建数据库 | | $ORACLE_HOME/bin/dbca -silent -responseFile /u01/database/response/dbca.rsp 输入 SYS 用户口令: 输入 SYSTEM 用户口令: |
启动数据库 | | sqlplus / as sysdba SQL> startup #启动数据库 SQL> quit |
| | |
参考:https://blog.csdn.net/qq_24058757/article/details/88170905