1. 首页
  2. IT资讯

带你部署单机oracle数据库,超详细带图解说

“u003Cpu003Eu003Cbru002Fu003Eu003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F1c66738cb56b4dd9b4922828eaefc3f5″ img_width=”669″ img_height=”717″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003Eu003Cbru002Fu003Eu003Cu002Fpu003Eu003Ch1 class=”pgc-h-arrow-right”u003E一、前言u003Cu002Fh1u003Eu003Cpu003E本次实施内容是,oracle单实例系统文件安装,操作系统为CentOS 6.9,数据库版本11.2.0.4。u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F3a6388ef6a024ff69fa65088da5d8a9c” img_width=”593″ img_height=”105″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E二、oracle软件安装u003Cu002Fh1u003Eu003Ch1 class=”pgc-h-arrow-right”u003E1、以下用root账号操作u003Cu002Fh1u003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.1 配置本地yum源u003Cu002Fh1u003Eu003Cpu003EYum(全称为 Yellow dog Updater, Modified)是一个在Fedora和RedHat以及SUSE、CentOS中的前端软件包管理器。基於包管理,能够从指定的服务器自动下载RPM包并且安装,可以自动处理依赖性关系,并且一次安装所有依赖的软体包,无须繁琐地一次次下载、安装。u003Cu002Fpu003Eu003Cpu003E· u003Cstrongu003E挂载镜像到本地空目录u003Cu002Fstrongu003Eu003Cu002Fpu003Eu003Cpreu003E[root@heima ~]# mkdir u002Fmntu002Fcdromu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# mount -o ro u002Fdevu002Fsr0 u002Fmntu002Fcdromu003Cu002Fpreu003Eu003Cpu003E· u003Cstrongu003E创建配置文件u003Cu002Fstrongu003Eu003Cu002Fpu003Eu003Cpreu003E[root@heima ~]# cat u002Fetcu002Fyum.repos.du002Flocal.repou003Cu002Fpreu003Eu003Cpreu003E[local]u003Cu002Fpreu003Eu003Cpreu003Ename=local yumu003Cu002Fpreu003Eu003Cpreu003Ebaseurl=file:u002Fu002Fu002Fmntu002Fcdromu003Cu002Fpreu003Eu003Cpreu003Eenabled=1u003Cu002Fpreu003Eu003Cpreu003Egpgcheck=0u003Cu002Fpreu003Eu003Cpreu003E说明:如果只配置本地yum源,那可以删除u002Fetcu002Fyum.repos.du002F目录下Centos自带的所有文件,然后自己创建以.repo结尾文件即可,内容如上。u003Cu002Fpreu003Eu003Cpu003E· u003Cstrongu003E创建yum缓存u003Cu002Fstrongu003Eu003Cu002Fpu003Eu003Cpreu003E[root@heima ~]# yum clean allu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# yum makecacheu003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.2 安装所需依赖包u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# yum -y install compat-libstdc++-33 libaio-devel elfutils-libelf-develu003Cu002Fpreu003Eu003Cpu003E注意:在后面安装软件的时候可以再看需要安装哪些包,然后装上就行u003Cu002Fpu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.3 创建用户组和用户(具体看要求决定ID号)u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# groupadd -g 1000 oinstallu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# groupadd -g 1001 dbau003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# useradd -u 1000 -g oinstall -G dba oracleu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# id oracleu003Cu002Fpreu003Eu003Cpreu003Euid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba)u003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# echo oracle|passwd –stdin oracleu003Cu002Fpreu003Eu003Cpreu003EChanging password for user oracle.u003Cu002Fpreu003Eu003Cpreu003Epasswd: all authentication tokens updated successfully.u003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.4 创建相应数据目录(安装和数据目录)u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# mkdir -p u002Fu01u002Fappu002F{oracle,oradata,oraInventory}u003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# chown -R oracle.oinstall u002Fu01u002Fappu002Fu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# chmod -R 775 u002Fu01u002Fappu002F*u003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.5 修改oracle用户资源限制u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# cat >> u002Fetcu002Fsecurityu002Flimits.conf <<EOFu003Cu002Fpreu003Eu003Cpreu003E> oracle soft nproc 2047u003Cu002Fpreu003Eu003Cpreu003E> oracle hard nproc 16384u003Cu002Fpreu003Eu003Cpreu003E> oracle soft nofile 1024u003Cu002Fpreu003Eu003Cpreu003E> oracle hard nofile 65536u003Cu002Fpreu003Eu003Cpreu003E> EOFu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# grep 'limit' u002Fetcu002Fpam.du002Fsystem-authu003Cu002Fpreu003Eu003Cpreu003Esession required pam_limits.sou003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.6 配置系统资源限制(内核参数)u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# cat >> u002Fetcu002Fsysctl.conf << EOFu003Cu002Fpreu003Eu003Cpreu003Efs.aio-max-nr = 1048576u003Cu002Fpreu003Eu003Cpreu003Efs.file-max = 6815744u003Cu002Fpreu003Eu003Cpreu003Ekernel.shmall = 2097152u003Cu002Fpreu003Eu003Cpreu003Ekernel.shmmax = 4294967295u003Cu002Fpreu003Eu003Cpreu003Ekernel.shmmni = 4096u003Cu002Fpreu003Eu003Cpreu003Ekernel.sem = 250 32000 100 128u003Cu002Fpreu003Eu003Cpreu003Enet.ipv4.ip_local_port_range = 9000 65500u003Cu002Fpreu003Eu003Cpreu003Enet.core.rmem_default = 262144u003Cu002Fpreu003Eu003Cpreu003Enet.core.rmem_max = 4194304u003Cu002Fpreu003Eu003Cpreu003Enet.core.wmem_default = 262144u003Cu002Fpreu003Eu003Cpreu003Enet.core.wmem_max = 1048586u003Cu002Fpreu003Eu003Cpreu003EEOFu003Cu002Fpreu003Eu003Cpreu003E说明:以上是参考值,具体值根据实际情况进行调整u003Cu002Fpreu003Eu003Cpreu003Ekernel.shmmax = 4294967295 (4G) (需要设置的比sga内存大,sga为物理内存内存的80%);如果物理内存是16G,则sga可以设置为12G,kernel.shmmax = 15032385536(14G)u003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# sysctl -p 让内核改变立即生效u003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.7 配置u002Fetcu002Fhosts文件u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# cat u002Fetcu002Fhostsu003Cu002Fpreu003Eu003Cpreu003E127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4u003Cu002Fpreu003Eu003Cpreu003E::1 localhost localhost.localdomain localhost6 localhost6.localdomain6u003Cu002Fpreu003Eu003Cpreu003E10.1.1.1 heima.itcast.cn heimau003Cu002Fpreu003Eu003Cpu003Eu003Cbru002Fu003Eu003Cu002Fpu003Eu003Ch1 class=”pgc-h-arrow-right”u003E1.8 关闭防火墙和selinuxu003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# service iptables stopu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# chkconfig iptables offu003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# sed -i 'u002FSELINUX=u002FcSELINUX=disabled' u002Fetcu002Fselinuxu002Fconfigu003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E2、以下用oracle账号操作u003Cu002Fh1u003Eu003Ch1 class=”pgc-h-arrow-right”u003E2.1 配置oracle用户shell环境u003Cu002Fh1u003Eu003Cpreu003E[root@heima ~]# su – oracleu003Cu002Fpreu003Eu003Cpreu003E[oracle@heima ~]$ vim .bash_profileu003Cu002Fpreu003Eu003Cpreu003E文件下面追加以下内容:u003Cu002Fpreu003Eu003Cpreu003Eexport ORACLE_BASE=u002Fu01u002Fappu002Foracleu003Cu002Fpreu003Eu003Cpreu003Eexport ORACLE_HOME=u002Fu01u002Fappu002Foracleu002Fproductu002F11.2.0u002Fdbhome_1u003Cu002Fpreu003Eu003Cpreu003Eexport ORACLE_SID=ora11gu003Cu002Fpreu003Eu003Cpreu003Eexport PATH=$PATH:$ORACLE_HOMEu002Fbinu003Cu002Fpreu003Eu003Cpreu003Eexport LD_LIBRARY_PATH=$ORACLE_HOMEu002Fdbhome_1u002Flib:u002Flib:u002Fusru002Flibu003Cu002Fpreu003Eu003Ch1 class=”pgc-h-arrow-right”u003E2.2 安装oracle软件u003Cu002Fh1u003Eu003Cpu003E· 下载oracle软件并解压u003Cu002Fpu003Eu003Cpreu003E[oracle@heima ~]$ lsu003Cu002Fpreu003Eu003Cpreu003Edatabaseu003Cu002Fpreu003Eu003Cpreu003Ep13390677_112040_Linux-x86-64_1of7.zipu003Cu002Fpreu003Eu003Cpreu003Ep13390677_112040_Linux-x86-64_2of7.zipu003Cu002Fpreu003Eu003Cpu003E· 进入到解压目录里进行安装u003Cu002Fpu003Eu003Cpreu003E[root@heima ~]# xhost +u003Cu002Fpreu003Eu003Cpreu003E[oracle@heima ~]$ cd databaseu003Cu002Fpreu003Eu003Cpreu003E[oracle@heima ~]$ .u002FrunInstalleru003Cu002Fpreu003Eu003Cpu003E错误提示:u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F7b87476f8ec44a6b93edaf99ce34899e” img_width=”1320″ img_height=”195″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E解决办法:u003Cu002Fpu003Eu003Cpu003E安装VNC服务,使用MobaXterm工具或其他客户端连接VNC服务端u003Cu002Fpu003Eu003Cpreu003E[root@heima ~]# yum -y install tigervnc-serveru003Cu002Fpreu003Eu003Cpreu003E启动服务:u003Cu002Fpreu003Eu003Cpreu003E[root@heima ~]# vncserver :1u003Cu002Fpreu003Eu003Cpreu003ENew 'heima.itcast.cn:2 (root)' desktop is heima.itcast.cn:2u003Cu002Fpreu003Eu003Cpreu003EStarting applications specified in u002Frootu002F.vncu002Fxstartupu003Cu002Fpreu003Eu003Cpreu003ELog file is u002Frootu002F.vncu002Fheima.itcast.cn:1.logu003Cu002Fpreu003Eu003Cpu003Eu003Cbru002Fu003Eu003Cu002Fpu003Eu003Cpu003E① 跳过更新提示u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fc6224d1ebdfc4b0b8b2361b34097a219″ img_width=”601″ img_height=”447″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F5308f8906a3a42248e2259750abdc11c” img_width=”601″ img_height=”448″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E② 选择只安装软件u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F492e19fbf70f432ebf22949ff7e0ff11″ img_width=”603″ img_height=”448″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E③ 安装类型选项,选择单实例安装u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F9dc481995d2647d0a20e048ab8c4d218″ img_width=”602″ img_height=”452″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E④ 选择安装软件的语言u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp9.pstatp.comu002Flargeu002Fpgc-imageu002F8dc1fce3574b419fa4f865d965efbc6f” img_width=”555″ img_height=”417″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑤ 选择安装版本u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002Fc62992dd1c624e099111a5140296c66c” img_width=”601″ img_height=”450″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑥ 选择软件安装路径u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fd20def21544e455b9ee89cb692345d18″ img_width=”598″ img_height=”449″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑦ 指定相关文件目录及组u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F2e3257753546451082662ae6c0f0ed71″ img_width=”598″ img_height=”450″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fe028bec97b7f426689d2cbdee57f8398″ img_width=”602″ img_height=”453″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑧ 环境检查,需要依赖包根据提示安装即可u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F46baefb80dda42d5841e2334059e36f4″ img_width=”554″ img_height=”416″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E以下包可以忽略,继续往下u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F0ab37c90b90843a582cb9be28f02949a” img_width=”552″ img_height=”417″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑨ 开始安装u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F7e8737ee1a3a40bca18ccff6b67807f2″ img_width=”554″ img_height=”420″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F9fa3a8e0dd394abb9f4f2ad8bcba80a3″ img_width=”552″ img_height=”415″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E⑩ 在root用户下执行两个脚本u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fc55572befa7a4f7095d6bc366a97d151″ img_width=”555″ img_height=”413″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E在root用户下运行两个脚本的结果:u003Cu002Fpu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F6998ce1f8e5647859f8d41f09decc354″ img_width=”772″ img_height=”600″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cpu003E执行完毕脚本后,点击OK,安装完毕!u003Cu002Fpu003Eu003Cpu003Eu003Cbru002Fu003Eu003Cu002Fpu003Eu003Ch1 class=”pgc-h-arrow-right”u003E三、oracle数据库安装u003Cu002Fh1u003Eu003Ch1 class=”pgc-h-arrow-right”u003E1、运行命令:dbca创建数据库u003Cu002Fh1u003Eu003Cpreu003E[oracle@heima ~]$ dbcau003Cu002Fpreu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp9.pstatp.comu002Flargeu002Fpgc-imageu002F28ad0c52acd74877b90573b7aa0ff323″ img_width=”565″ img_height=”399″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F457cd37de6ea4b9ba6e588c9b7993acd” img_width=”561″ img_height=”400″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E2、选择建库类型u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp9.pstatp.comu002Flargeu002Fpgc-imageu002F4bba99341a2d473a968337b52ec6a6b7″ img_width=”563″ img_height=”399″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E3、创建库名与实例名u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp9.pstatp.comu002Flargeu002Fpgc-imageu002Fa0463882d91a462480af81636a18de19″ img_width=”560″ img_height=”402″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E4、跳过安装OEMu003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002Fe7d6d32423294b79868a02fcdfea83be” img_width=”563″ img_height=”401″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E5、设置密码u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F0cea211765564ba5aff2b578652d7b3d” img_width=”565″ img_height=”398″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E6、指定数据库安装目录(数据文件等)u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002Fa18d3b1b7f0141ec8ef5aa5e596898c0″ img_width=”561″ img_height=”401″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E7、开启归档u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fc531a8fc3929456886f8e37cdc7aec64″ img_width=”670″ img_height=”405″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E8、默认选项u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fc4f03886c7b64275a47b7fed760f3a1e” img_width=”562″ img_height=”398″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E9、设置Oracle共享内存占物理内存的70%~80%u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F811b7e61657c448c9b9f95ab7f859aad” img_width=”562″ img_height=”402″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E10、设置Processes为800u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F8a1a422d504042d8ad5cda7fc9e71e9d” img_width=”562″ img_height=”402″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E11、选择字符集需注意u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002Fe0d83a8ac7de406c8379b607440bfaf0″ img_width=”558″ img_height=”398″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E12、选择连接模式u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F7e94cc60f00a4881b11fa3e1b8a0f464″ img_width=”560″ img_height=”403″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E13、日志大小分配512Mu003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002Fa1544b59987f400cb5d4507768bf70d7″ img_width=”563″ img_height=”404″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E14、记录建库脚本(目录自定义)u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F8fba377daac14b5e8d360ff55fcc2cca” img_width=”564″ img_height=”404″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E15、开始安装u003Cu002Fh1u003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp3.pstatp.comu002Flargeu002Fpgc-imageu002F8bddb839f203486eaeb788d08e177dff” img_width=”560″ img_height=”400″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E四、安装完毕配置监听u003Cu002Fh1u003Eu003Cpreu003E[oracle@ esxoradb ~]$ netmgru003Cu002Fpreu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp9.pstatp.comu002Flargeu002Fpgc-imageu002Fb1e638357d4348f09900b39258f97188″ img_width=”578″ img_height=”484″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Cdiv class=”pgc-img”u003Eu003Cimg src=”http:u002Fu002Fp1.pstatp.comu002Flargeu002Fpgc-imageu002F687a63cbed8545e3bfecffa84eeb77d1″ img_width=”577″ img_height=”483″ alt=”带你部署单机oracle数据库,超详细带图解说” inline=”0″u003Eu003Cp class=”pgc-img-caption”u003Eu003Cu002Fpu003Eu003Cu002Fdivu003Eu003Ch1 class=”pgc-h-arrow-right”u003E五、本地访问oracle数据库u003Cu002Fh1u003Eu003Cpreu003E[oracle@heima admin]$ sqlplus u002Fnologu003Cu002Fpreu003Eu003Cpreu003ESQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 6 07:03:44 2019u003Cu002Fpreu003Eu003Cpreu003ECopyright (c) 1982, 2013, Oracle. All rights reserved.u003Cu002Fpreu003Eu003Cpreu003ESQL> conn sys as sysdba 管理员身份连接数据库u003Cu002Fpreu003Eu003Cpreu003EEnter password: 输入密码,密码不显示u003Cu002Fpreu003Eu003Cpreu003EConnected.u003Cu002Fpreu003Eu003Cpreu003ESQL>u003Cu002Fpreu003Eu003Cpreu003ESQL> select INSTANCE_NAME,VERSION,DATABASE_STATUS from v$instance;u003Cu002Fpreu003Eu003Cpreu003EINSTANCE_NAME VERSION DATABASE_STATUSu003Cu002Fpreu003Eu003Cpreu003E—————- —————– —————–u003Cu002Fpreu003Eu003Cpreu003Eora11g 11.2.0.4.0 ACTIVEu003Cu002Fpreu003E”

原文始发于:带你部署单机oracle数据库,超详细带图解说

主题测试文章,只做测试使用。发布者:程序员,转转请注明出处:http://www.cxybcw.com/26694.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code