目录
- 安装前准备工作
- 安装Oracle 11g
- 配置Oracle 11g
- 基本操作
安装前准备工作
在前面章节,我们统一进行了环境变量的设置,并完成了集群的安装,所以我们直接切换成oracle用户进行数据库的安装。
我们选择的版本是Oracle Database 11g Release 2 (11.2.0.3.0) for Linux x86-64
下载解压完毕,通过VMWare的共享实现对安装文件的访问。
安装Oracle 11g
- 第一步:启动安装程序:
- 第二部:选择安装软件,我们选择只安装数据库软件本身:
- 第三步:集群安装节点添加:
- 第四步:语言选择:
- 第五步:目录配置,保持默认就好:
- 第六步:管理用户配置:
- 第七步:开始安装软件:
这个链接过程中提示出现错误。
查看下日志中错误信息:
INFO: make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk relink_exe EXENAME=emdctl
INFO: make[1]: Entering directory `/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'
gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/dbhome_1/lib /u01/app/oracle/p
INFO: roduct/11.2.0/dbhome_1/sysman/lib//s0nmectl.o -lnmectl -lclntsh -L/u01/app/oracle/product/11.2.0/dbhome_1/lib -L/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ -lnmemso -lcore11 -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib/:/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/amd64/server:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/amd64 -L/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/amd64/server -L/u01/app/oracle/product/11.2.
INFO: 0/dbhome_1/jdk/jre/lib/amd64 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib/:/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/amd64/server:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/amd64 -Wl,--allow-shlib-undefined `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm
INFO: /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
INFO: /usr/bin/ld: warning: -z lazyload ignored.
/usr/bin/ld: warning: -z nolazyload ignored.
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib//libnmectl.a(nmectlt.o): In function `nmectlt_genSudoProps':
nmectlt.c:(.text+0x76): undefined reference to `B_DestroyKeyObject'
nmectlt.c:(.text+0x7f): undefined reference to `B_DestroyKeyObject'
nmectlt.c:(.text+0x88): undefined reference to `B_DestroyKeyObject'
nmectlt.c:(.text+0x91): undefined reference to `B_DestroyKeyObject'
collect2: error: ld returned 1 exit stat
INFO: us
INFO: make[1]: Leaving directory `/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'
INFO: make[1]: *** [/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl] Error 1
make: *** [emdctl] Error 2
编译emdctl出错,没有找到函数的引用,找到对应的make文件,添加nnz11库的引用。
[oracle@racnode1 lib]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib
[oracle@racnode1 lib]$ vim ins_emagent.mk
#===========================
# emdctl
#===========================
$(SYSMANBIN)emdctl:
$(MK_EMAGENT_NMECTL) -lnnz11
在点击Retry,通过了。
- 第八步:安装成功
配置Oracle 11g
- 第一步:启动dbca程序,选择集群安装:
- 第二部:选择安装数据库:
- 第三步:定制化数据库:
- 第四步:选择节点,管理模式,以及数据库名称和实例名称前缀:
- 第五步:选择企业版安装:
- 第六步:为简化管理,统一管理密码:
- 第七步:ASM安装位置选择:
- 第八步:FRA区域设定,我们这里附带设置了归档模式:
- 第九步:组件安装,我们默认全选:
- 第十步:内存选择,我们指定AMM管理方式:
- 第十步:准备安装:
- 第十一步:选择安装,我们也选择产生脚本,事后可以学习参考:
- 第十二步:漫长安装开始:
结束安装:
登录试试:
[oracle@racnode1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 10 11:06:07 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string racdb
db_unique_name string racdb
global_names boolean FALSE
instance_name string racdb1
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string racdb.cluster.org
SQL>
基本操作
- 集群资源查询
[grid@racnode1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.DB_DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.FRA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racnode2
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode2
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE racnode1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE racnode2
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE racnode1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE racnode2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE racnode1
ora.racdb.db ora....se.type 0/2 0/1 ONLINE ONLINE racnode1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racnode1
ora....E1.lsnr application 0/5 0/0 ONLINE OFFLINE
ora....de1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de1.ons application 0/3 0/0 ONLINE ONLINE racnode1
ora....de1.vip ora....t1.type 0/0 1/0 ONLINE ONLINE racnode2
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE racnode2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE racnode2
ora....de2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de2.ons application 0/3 0/0 ONLINE ONLINE racnode2
ora....de2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE racnode2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode2
[grid@racnode1 ~]$
- 停止数据库服务
[grid@racnode1 ~]$ srvctl stop database -d racdb
[grid@racnode1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.DB_DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora.FRA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racnode2
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode2
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE racnode1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE racnode2
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE racnode1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE racnode2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE racnode1
ora.racdb.db ora....se.type 0/2 0/1 OFFLINE OFFLINE
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racnode1
ora....E1.lsnr application 0/5 0/0 ONLINE OFFLINE
ora....de1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de1.ons application 0/3 0/0 ONLINE ONLINE racnode1
ora....de1.vip ora....t1.type 0/0 1/0 ONLINE ONLINE racnode2
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE racnode2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE racnode2
ora....de2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora....de2.ons application 0/3 0/0 ONLINE ONLINE racnode2
ora....de2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE racnode2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode2
[grid@racnode1 ~]$
自此,11g RAC集群安装完毕。
chimpansee(2019-6)