案例：解决ORACLE ORA-27211的错误。

在一个AIX 6.1， Oracle 10.2.0.4的环境，连接带库。需要备份到带库上。 TSM for Oracle Driver是IBM工程师安装的，DBA负责调试TSM,RMAN 备份。开始执行RMAN时，系统报错：

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========
RMAN-00571: =========================================================== 
RMAN-03009: failure of allocate command on t1 channel at 12/02/2009 13:45:33 
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27211: Failed to load Media Management Library

查看： /usr/tivoli/tsm/client/oracle/bin64/tdpoerror.log 文件，有如下信息：

11/25/09   16:18:59 TID<2211946> ==> ANU2512E Could not open license file: /usr/tivoli/tsm/client/oracle/bin64/agent.lic
11/25/09   16:18:59 ANS1025E Session rejected: Authentication failure
11/25/09   16:18:59 ANS1025E Session rejected: Authentication failure
11/25/09   16:18:59 TID<2211946> ==> ANS1025E (RC137)  Session rejected: Authentication failure

认证失败，估计是无法通过TSM的认证。查看/usr/tivoli/tsm/client/oracle/bin64/ 目录下的文件：

-rw-rw-rw-    1 root     system          742 Nov 25 16:19 dsm.opt
-rw-r--r--    1 root     system            0 Nov 25 16:34 dsmerror.log
drwxr-xr-x    2 root     system          256 Nov 25 15:11 en_US
-rwxr-xr-x    1 bin      bin          914416 Jun  3 2009  libobk64.a
-rw-rw-rw-    1 bin      bin             690 Dec  3 12:30 tdpo.opt
-rwxr-xr-x    1 bin      bin             691 Jun  3 2009  tdpo.opt.smp64
-rwxr-xr-x    1 bin      bin          802518 Jun  3 2009  tdpoconf
-rw-r--r--    1 root     system          525 Nov 25 16:18 tdpoerror.log

缺失agent.lic, tdposync 两个文件。通过IBM 安装上缺失的文件。安装完毕，再次执行RMAN 来验证：

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========
RMAN-00571: =========================================================== 
RMAN-03009: failure of allocate command on t1 channel at 12/02/2009 13:45:33 
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27211: Failed to load Media Management Library 

错误依然，但是具体的错误信息已经变化了：


12/07/09   12:00:24 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:00:24 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:00:24 ANS0282E Password file is not available.
12/07/09   12:00:24 TID<671750> ==> ANS0282E (RC168)  Password file is not available.
12/07/09   12:01:08 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:01:08 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:01:08 ANS0282E Password file is not available.
12/07/09   12:01:08 TID<1278070> ==> ANS0282E (RC168)  Password file is not available.
12/07/09   12:10:43 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:10:44 ANS1834S Unable to write to '/etc/security/adsm' for storing password
12/07/09   12:10:44 ANS0282E Password file is not available.
12/07/09   12:10:44 TID<1069070> ==> ANS0282E (RC168)  Password file is not available.
12/07/09   12:17:35 ANS1025E Session rejected: Authentication failure
12/07/09   12:21:02 TID<848014> ==> ANU2512E Could not open license file: /usr/tivoli/tsm/client/oracle/bin64/agent.lic

这次是缺失了agent.loc 文件，还是要IBM去安装缺失的文件。要好好检查IBM同志的工作！！

===> ls -l /usr/tivoli/tsm/client/oracle/bin64/
total 3400
-rw-rw-rw-    1 oracle   system           47 Dec  7 14:38 agent.lic
lrwxrwxrwx    1 root     system           37 Dec  7 12:00 dsm.opt -> /usr/tivoli/tsm/client/ba/bin/dsm.opt
lrwxrwxrwx    1 root     system           37 Dec  7 11:57 dsm.sys -> /usr/tivoli/tsm/client/ba/bin/dsm.sys
-rwxrwxrwx    1 root     system            0 Nov 25 16:34 dsmerror.log
drwxr-xr-x    2 root     system          256 Nov 25 15:11 en_US
-rwxr-xr-x    1 bin      bin          914416 Jun  3 2009  libobk64.a
-rwxrwxrwx    1 bin      bin             690 Dec  3 12:30 tdpo.opt
-rwxr-xr-x    1 bin      bin             691 Jun  3 2009  tdpo.opt.smp64
-rwxr-xr-x    1 bin      bin          802518 Jun  3 2009  tdpoconf
-rwxrwxrwx    1 root     system         2254 Dec  7 17:58 tdpoerror.log

和其他相同的服务器上比对，不再缺少文件的情况下，去验证RMAN 和TSM，ORA-27211的错误再次出现。文件已经齐全，但是错误依旧，是怎么回事呢？查看了ORA-27211的错误帮助，感觉是RMAN 无法加载到SBT_LIBRARY的驱动。可能是环境变量设置的不对导致的这个问题。 ORA-27211的错误帮助

===> oerr ora 27211
27211, 00000, "Failed to load Media Management Library"
// *Cause:  User-supplied SBT_LIBRARY or libobk.so could not be loaded. Call
//          to dlopen for media library returned error. See Additional
//          information for error code.
// *Action: Retry the command with proper media library. Or re-install
//          Media management module for Oracle.

经过一番摸索，找到了解决问题的办法，问题解决：

1）建立软连接： cd $ORACLE_HOME/lib/ ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a libobk.a
2）检查LIBPATH 和LD_LIBRARY_PATH 环境变量，$ORACLE_HOME/lib 排在/usr/lib 前；
3）确定没有设置环境变量SBT_LIBRARY ；
4）如果还是无效，可能需要重启INSTANCE以释放加载到内存中的环境变量 LIBPATH

-THE END-

ITPub博客

案例：解决ORACLE ORA-27211的错误

最新文章

ITPub博客

案例： 解决ORACLE ORA-27211的错误

最新文章

案例：解决ORACLE ORA-27211的错误