11g – Adamhuan's Data Center – 【逻辑驱动数据】

时间线：Oracle

1970年6月：IBM 公司的研究员埃德加·考特（Edgar Frank Codd）在 Communications of ACM 上发表了那篇著名的《大型共享数据库数据的关系模型》（A Relational Model of Data for Large Shared Data Banks）的[……]

Posted on: 2021年8月6日 2021年8月6日
Author: Adamhuan
Categories: Oracle
Tags: -, ，, :, ", /, 1.3, 10, 10g, 11, 11g, 12, 16, 18, 2, 200, 2008, 2012, 2014, 2015, 2017, 2018, 2018年, 2021年8月6日, 21, 26, 3, 30, 3D, 4, 4.0, 5, 50, 6, 6.5, 7, 8, 80, 9, 96, 9i, ant, Apple, b, BE, cat, CD, CDB, CE, Cloud, Cluster, CM, Data, Data Guard, db, dd, df, extension, File, for, form, format, gem, history, http, IBM, if, Internet, iso, KB, Lab, Language, Life, Linux, man, Management, ML, MS, net, nic, OP, OpenWorld, Oracle, PC, PDB, PL/SQL, put, RAC, racle, rap, RDBMS, rm, s, sed, Server, Shared, Software, SQL, Tag, Tiger, timeline, tr, ui, VM, war, wiki, Windows, 不说, 中国, 中文, 主, 书, 事务, 云, 云计算, 互联网, 从, 代号, 代码, 优化, 传输, 位置, 使用, 信, 信息, 充分, 光, 全球, 共享, 内存, 冲突, 分析, 创建, 别, 力, 力量, 功能, 加载, 包含, 协议, 卡, 历史, 压缩, 参与, 发布, 可插拔, 可用, 命名, 商业, 图, 地区, 域, 境, 增, 增加, 增强, 处理, 备份, 大量, 失败, 女, 字典, 存储, 存储过程, 安全, 实例, 实验, 容器, 密码, 对象, 工具, 平台, 库, 应用, 建议, 开发, 引用, 得到, 微软, 心, 性能, 情, 成功, 执行, 扩展, 排名, 操作系统, 改, 改变, 数据, 数据库, 数据类型, 文件, 新, 新功能, 新增, 新特性, 方向, 早, 时间, 时间线, 明智, 智慧, 更新, 服务, 服务器, 未来, 本地, 极, 架构, 查, 查询, 标准, 比较, 测试, 浏览器, 源, 潜在的, 版本, 特性, 猫, 环境, 生活, 用户, 甲骨文, 电脑, 相关, 神, 程序, 空, 空间, 策略, 签, 管理, 系统, 组, 终, 统计, 编程, 编译, 缺少, 网络, 美, 美国, 群, 翻译, 自动, 自动化, 自己, 落, 表, 规则, 解救, 计划, 计算, 记录, 访问, 语, 语句, 语言, 说, 资源, 趋势, 软件, 过高, 连接, 选择, 道, 部署, 配置, 锁, 锁定, 错, 阅读, 阻止, 降低, 限制, 集群, 面对, 项目, 高可用
Leave a comment: 时间线：Oracle

RHEL7 – 通过udev的方式配置RAW设备：bash: start_udev: command not found..

在以前，部署Oracle RAC的时候，会涉及到RAW的共享存储的配置，具体可以查阅：
http://d-prototype.com/archives/513
检索【为raw配置udev策略】

可以从中看到，在过去写好了UDEV策略之后，为了让UDEV的策略生效，使用的方式是：start_udev[……]

Posted on: 2021年6月25日 2021年6月25日
Author: Adamhuan
Categories: RHEL
Tags: -, -p, ，, :, ", /, /dev/sd, 10, 1024, 11, 11g, 11g RAC, 12, 16, 18, 2, 200, 206, 22, 26, 3, 4, 46, 5, 5.3, 50, 6, 64, 7, 8, 9, active, add, admin, archive, asm, b, bash, bind, Block, bytes, cal, cat, change, command, command not found, Control, database, db, dd, device, disk, dm, exit, fdisk, for, grep, http, if, init, IO, kernel, Linux, load, log, man, module, modules, node, Oracle, OS, plug, pre, prototype, RAC, racle, rap, RAW, release, restart, RHEL, RHEL7, root, s, service, size, sock, socket, start_udev, systemd-udev-trigger, tr, udev, 从, 使用, 共享, 共享存储, 呢, 命令, 存储, 应用, 当前, 得到, 我, 执行, 操作系统, 服务, 查, 查看, 检索, 源, 版本, 状态, 相关, 磁盘, 策略, 系统, 系统服务, 解决, 设备, 说, 资源, 运行, 部署, 配置, 重启, 问题, 验证
Leave a comment: RHEL7 – 通过udev的方式配置RAW设备：bash: start_udev: command not found..

Oracle BBED：Install

BBED的编译需要一些依赖包，如果你没有提供这些依赖包，那么你会遇到错误，像下面这样：

[oracle@ora11gdg1 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@ora11gdg1 lib]$ ls -ltr | grep bbed
[oracle@ora11gdg1 lib]$ ls -ltr | grep ins_rdbms
-rw-r--r-- 1 oracle oinstall    40983 Aug 24  2013 ins_rdbms.mk
[oracle@ora11gdg1 lib]$ 
[oracle@ora11gdg1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed
gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/  /u01/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh  `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11   -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `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
gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o: No such file or directory
gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o: No such file or directory
make: *** [/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed] Error 1
[oracle@ora11gdg1 lib]$

[oracle@ora11gdg1 ~]$ cd $ORACLE_HOME/rdbms/lib

[oracle@ora11gdg1 lib]$ ls -ltr | grep bbed

[oracle@ora11gdg1 lib]$ ls -ltr | grep ins_rdbms

-rw-r--r-- 1 oracle oinstall 40983 Aug 24 2013 ins_rdbms.mk

[oracle@ora11gdg1 lib]$

[oracle@ora11gdg1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)

rm -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed

gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/ /u01/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `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

gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o: No such file or directory

gcc: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o: No such file or directory

make: *** [/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/bbed] Error 1

[oracle@ora11gdg1 lib]$

可以很明显的看到上面的报错【No such file or directory】。

BBED的成功编译需要这样的几个依赖包：
[cr[……]

Posted on: 2017年4月7日 2017年4月7日
Author: Adamhuan
Categories: BBED
Tags: 10g, 11g, 12c, BBED, Linux, Oracle
Leave a comment: Oracle BBED：Install

Oracle 11g DATA Guard：RAC –> Standalone

开始本文前，你需要准备好以下环境：

主库端：ORACLE RAC 11g
备库端：ORACLE database 11g【standalone】

在我的环境里：
主库端：

[root@oracle-cluster-1 ~]# su - grid
Last login: Wed Mar 22 14:23:30 CST 2017 on pts/3
[grid@oracle-cluster-1 ~]$ 
[grid@oracle-cluster-1 ~]$ cat /etc/hosts
#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

# Local
127.0.0.1       localhost

# Public

# eth0

10.158.1.45     ora12c-1

# for: oracle database 12c r2 rac
10.158.1.46     oracle-cluster-1
10.158.1.157    oracle-cluster-2
10.158.1.161    oracle-cluster-3
10.158.1.178    oracle-cluster-4

# vip
10.158.1.94     oracle-cluster-1-vip
10.158.1.95     oracle-cluster-2-vip

# Private
192.168.24.94   oracle-cluster-1-priv
192.168.24.95   oracle-cluster-2-priv

# SCAN
10.158.1.96     scan1

# Storage
10.158.1.47     openfiler
[grid@oracle-cluster-1 ~]$ 
[grid@oracle-cluster-1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.CRS.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    orac...er-1 
ora.DATA01.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    orac...er-1 
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    orac...er-1 
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    orac...er-1 
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    orac...er-1 
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    orac...er-1 
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora.lenka.db   ora....se.type 0/2    0/1    ONLINE    ONLINE    orac...er-1 
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    orac...er-1 
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    orac...er-1 
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    orac...er-1 
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    orac...er-1 
ora....-1.lsnr application    0/5    0/0    ONLINE    ONLINE    orac...er-1 
ora....r-1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....r-1.ons application    0/3    0/0    ONLINE    ONLINE    orac...er-1 
ora....r-1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    orac...er-1 
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    orac...er-2 
ora....-2.lsnr application    0/5    0/0    ONLINE    ONLINE    orac...er-2 
ora....r-2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....r-2.ons application    0/3    0/0    ONLINE    ONLINE    orac...er-2 
ora....r-2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    orac...er-2 
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    orac...er-1 
[grid@oracle-cluster-1 ~]$ 
[grid@oracle-cluster-1 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2017 19:45:17

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                22-MAR-2017 13:57:39
Uptime                    0 days 5 hr. 47 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/oracle-cluster-1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.158.1.96)(PORT=1521)))
Services Summary...
Service "lenka" has 2 instance(s).
  Instance "lenka1", status READY, has 1 handler(s) for this service...
  Instance "lenka2", status READY, has 1 handler(s) for this service...
Service "lenkaXDB" has 2 instance(s).
  Instance "lenka1", status READY, has 1 handler(s) for this service...
  Instance "lenka2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@oracle-cluster-1 ~]$

[root@oracle-cluster-1 ~]# su - grid

Last login: Wed Mar 22 14:23:30 CST 2017 on pts/3

[grid@oracle-cluster-1 ~]$

[grid@oracle-cluster-1 ~]$ cat /etc/hosts

#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

# Local

127.0.0.1 localhost

# Public

# eth0

10.158.1.45 ora12c-1

# for: oracle database 12c r2 rac

10.158.1.46 oracle-cluster-1

10.158.1.157 oracle-cluster-2

10.158.1.161 oracle-cluster-3

10.158.1.178 oracle-cluster-4

# vip

10.158.1.94 oracle-cluster-1-vip

10.158.1.95 oracle-cluster-2-vip

# Private

192.168.24.94 oracle-cluster-1-priv

192.168.24.95 oracle-cluster-2-priv

# SCAN

10.158.1.96 scan1

# Storage

10.158.1.47 openfiler

[grid@oracle-cluster-1 ~]$

[grid@oracle-cluster-1 ~]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE orac...er-1

ora.DATA01.dg ora....up.type 0/5 0/ ONLINE ONLINE orac...er-1

ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE orac...er-1

ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE orac...er-1

ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE orac...er-1

ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE orac...er-1

ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

ora.lenka.db ora....se.type 0/2 0/1 ONLINE ONLINE orac...er-1

ora....network ora....rk.type 0/5 0/ ONLINE ONLINE orac...er-1

ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE orac...er-1

ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE orac...er-1

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE orac...er-1

ora....-1.lsnr application 0/5 0/0 ONLINE ONLINE orac...er-1

ora....r-1.gsd application 0/5 0/0 OFFLINE OFFLINE

ora....r-1.ons application 0/3 0/0 ONLINE ONLINE orac...er-1

ora....r-1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE orac...er-1

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE orac...er-2

ora....-2.lsnr application 0/5 0/0 ONLINE ONLINE orac...er-2

ora....r-2.gsd application 0/5 0/0 OFFLINE OFFLINE

ora....r-2.ons application 0/3 0/0 ONLINE ONLINE orac...er-2

ora....r-2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE orac...er-2

ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE orac...er-1

[grid@oracle-cluster-1 ~]$

[grid@oracle-cluster-1 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2017 19:45:17

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN1

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 22-MAR-2017 13:57:39

Uptime 0 days 5 hr. 47 min. 41 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora

Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/oracle-cluster-1/listener_scan1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.158.1.96)(PORT=1521)))

Services Summary...

Service "lenka" has 2 instance(s).

Instance "lenka1", status READY, has 1 handler(s) for this service...

Instance "lenka2", status READY, has 1 handler(s) for this service...

Service "lenkaXDB" has 2 instance(s).

Instance "lenka1", status READY, has 1 handler(s) for this service...

Instance "lenka2", status READY, has 1 handler(s) for this service...

The command completed successfully

[grid@oracle-cluster-1 ~]$

备库端：
[crayon-63dd915[……]

Posted on: 2017年3月23日 2017年3月23日
Author: Adamhuan
Categories: Oracle Dataguard
Tags: 11g, Data Guard, DG, Linux, RAC, Standalone
Leave a comment: Oracle 11g DATA Guard：RAC –> Standalone

Install Oracle database 11g on SLES 11 （SUSE Enterprise Linux 11 64bit SP4）

关于安装Oracle数据库，可以参考官方的文档：
http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCGGJAB

本文为我在自己的环境中的搭建过程。

————————————————————————[……]

Posted on: 2017年2月22日 2017年2月22日
Author: Adamhuan
Categories: Oracle Database
Tags: /etc/hosts, 11g, database, error, Install, Listener start failed, listener.ora, Oracle, sles 11, SP4, SUSE, SUSE Enterprise Linux, The information provided for this listener is currently in use by other software on this computer
Leave a comment: Install Oracle database 11g on SLES 11 （SUSE Enterprise Linux 11 64bit SP4）