Tag Archives: 11g

Oracle BBED：Install

By Adamhuan | 2017年4月7日

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[……]

Oracle 11g DATA Guard：RAC –> Standalone

By Adamhuan | 2017年3月23日

0 Comment

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

主库端：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-59c14c4[……]

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

By Adamhuan | 2017年2月22日

0 Comment

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

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

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

Oracle DataGuard11g，手动清理v$ARCHIVED_LOG

By Adamhuan | 2016年12月7日

0 Comment

有时候，你可能需要维护control file中的archivelog记录，比如，archivelog记录过多，会导致备份过程中【control file sequential read】的等待事件。

比较简单的做法是手动清理v$archived_log。

下面在我的环境中演示该过程。[……]

Oracle：ORA-00392: log 3 of thread 1 is being cleared, operation not allowed

By Adamhuan | 2016年7月1日

0 Comment

如题所示的问题发生在数据库的启动过程中，具体如下：

[oracle@oradg2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 18 08:15:57 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             MOUNTED

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1: '/oradata/orcl/redo03.log'


SQL>

[oracle@oradg2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 18 08:15:57 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

orcl MOUNTED

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-00392: log 3 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 3 thread 1: '/oradata/orcl/redo03.log'

SQL>

发生这个问题的时候，REDO日志的状态可能如下所示：

SQL> desc v$log;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BYTES                                              NUMBER
 BLOCKSIZE                                          NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE
 NEXT_CHANGE#                                       NUMBER
 NEXT_TIME                                          DATE

SQL> 
SQL> select group#,bytes/1024/1024 "MB",status from v$log;

    GROUP#         MB STATUS
---------- ---------- ----------------
         1         50 CLEARING
         3         50 CLEARING_CURRENT
         2         50 CLEARING

SQL>                   
SQL> desc v$logfile;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

SQL> 
SQL> col member for a40
SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------
         3 /oradata/orcl/redo03.log
         2 /oradata/orcl/redo02.log
         1 /oradata/orcl/redo01.log

SQL>

SQL> desc v$log;

Name Null? Type

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

GROUP# NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

BYTES NUMBER

BLOCKSIZE NUMBER

MEMBERS NUMBER

ARCHIVED VARCHAR2(3)

STATUS VARCHAR2(16)

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

NEXT_CHANGE# NUMBER

NEXT_TIME DATE

SQL>

SQL> select group#,bytes/1024/1024 "MB",status from v$log;

GROUP# MB STATUS

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

1 50 CLEARING

3 50 CLEARING_CURRENT

2 50 CLEARING

SQL>

SQL> desc v$logfile;

Name Null? Type

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

GROUP# NUMBER

STATUS VARCHAR2(7)

TYPE VARCHAR2(7)

MEMBER VARCHAR2(513)

IS_RECOVERY_DEST_FILE VARCHAR2(3)

SQL>

SQL> col member for a40

SQL> select group#,member from v$logfile;

GROUP# MEMBER

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

3 /oradata/orcl/redo03.log

2 /oradata/orcl/redo02.log

1 /oradata/orcl/redo01.log

SQL>

修复该问题：
[crayon-59c14[……]