Oracle9i RAC 報 /nsr/res/nsrdb save: RAP error: system error錯誤分析及解決過程(僅供參考)

Oracle9i RAC 報錯資訊如下 ： 

# vi /var/log/messages 

Jan 21 03:33:18 dell-node1 logger: --- Unsuccessful Save Sets ---
Jan 21 03:33:18 dell-node1 logger:
Jan 21 03:33:18 dell-node1 logger:   dell-node1:/nsr/res/nsrdb: No full backups of this save set were found in the media database; performing a full backup
Jan 21 03:33:18 dell-node1 logger: * dell-node1:/nsr/res/nsrdb save: RAP error: system error

[@more@]
Jan 21 03:33:18 dell-node1 logger: * dell-node1:/nsr/res/nsrdb save: Cannot open save session with dell-node1
Jan 21 03:33:18 dell-node1 logger:   dell-node1:index:dell-node1: No full backups of this save set were found in the media database; performing a full backup
Jan 21 03:33:18 dell-node1 logger: * dell-node1:index save: RAP error: system error
Jan 21 03:33:18 dell-node1 logger: * dell-node1:index save: Cannot open save session with dell-node1
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap save: RAP error: system error
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap save: Cannot open save session with dell-node1
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap Status Information:
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap  sending job 'root@dell-node1+203' to missingprinter@localhost
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap  connecting to 'localhost', attempt 1
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap  cannot open connection to localhost - Connection refused
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap Make sure LPD server is running on the server
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap printing bootstrap information failed (reproduced below).
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap January 21 03:33 2005  dell-node1's bootstrap information Page 1
Jan 21 03:33:18 dell-node1 logger: * dell-node1:bootstrap
Jan 21 03:33:18 dell-node1 logger:
Jan 21 03:33:23 dell-node1 logger: Legato Single Server Version index: (notice) nsrim has finished cross checking the media db
Jan 21 10:38:50 dell-node1 login(pam_unix)[10590]: bad username []

Jan 21 10:38:50 dell-node1 login(pam_unix)[10590]: bad username []
Jan 21 10:38:50 dell-node1 login[10590]: FAILED LOGIN 1 FROM 10.161.11.253 FOR , Authentication failure
Jan 21 10:38:55 dell-node1 login(pam_unix)[10590]: session opened for user oracle by (uid=0)
Jan 21 10:38:55 dell-node1  -- oracle[10590]: LOGIN ON pts/0 BY oracle FROM 10.161.11.253
Jan 21 10:44:05 dell-node1 login(pam_unix)[10590]: session closed for user oracle
Jan 21 17:00:49 dell-node1 login(pam_unix)[13577]: session opened for user oracle by (uid=0)
Jan 21 17:00:49 dell-node1  -- oracle[13577]: LOGIN ON pts/0 BY oracle FROM 10.161.8.155
Jan 21 17:04:18 dell-node1 su(pam_unix)[13658]: session opened for user root by oracle(uid=500)
Jan 21 17:04:58 dell-node1 su(pam_unix)[13658]: session closed for user root
Jan 21 17:04:59 dell-node1 login(pam_unix)[13577]: session closed for user oracle
Jan 21 17:18:46 dell-node1 sshd(pam_unix)[13825]: session opened for user oracle by (uid=0)
Jan 21 17:21:35 dell-node1 sshd(pam_unix)[13825]: session closed for user oracle
Jan 21 18:28:55 dell-node1 login(pam_unix)[14406]: session opened for user oracle by (uid=0)
Jan 21 18:28:56 dell-node1  -- oracle[14406]: LOGIN ON pts/0 BY oracle FROM 10.161.11.253
Jan 21 18:36:12 dell-node1 login(pam_unix)[14406]: session closed for user oracle
Jan 22 03:33:02 dell-node1 logger: Legato Single Server Version Savegroup: (info) starting Default (with 1 client(s))
Jan 22 03:33:08 dell-node1 logger: Legato Single Server Version Savegroup: (info) dell-node1:/nsr/res/nsrdb: No full backups of this save set were found in the media database; performing a full backup
Jan 22 03:33:12 dell-node1 logger: Legato Single Server Version media: (notice) no matching devices; check storage nodes, devices or pools for save of client `dell-node1'
Jan 22 03:33:12 dell-node1 logger: Legato Single Server Version media: (notice) no matching devices; check storage nodes, devices or pools for save of client `dell-node1'
Jan 22 03:33:12 dell-node1 logger: Legato Single Server Version Savegroup: (info) dell-node1:index:dell-node1: No full backups of this save set were found in the media database; performing a full backup
Jan 22 03:33:12 dell-node1 logger: Legato Single Server Version media: (notice) no matching devices; check storage nodes, devices or pools for save of client `dell-node1'
Jan 22 03:33:12 dell-node1 last message repeated 3 times
Jan 22 03:33:17 dell-node1 logger: Legato Single Server Version Savegroup: (alert) Default completed, 1 client(s) (dell-node1 Failed)
Jan 22 03:33:17 dell-node1 logger: Start time:   Sat Jan 22 03:33:02 2005
Jan 22 03:33:17 dell-node1 logger: End time:     Sat Jan 22 03:33:17 2005
Jan 22 03:33:17 dell-node1 logger:

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

是安裝Oracle的時候可以選擇的。
legato是一家做備份的廠商，可能為了佔領市場和Oracle綁在一起了。

你仔細看看安裝Oracle的過程是否有選擇LEGATO元件的，不選就是了。
還有安裝Oracle的時候最好先安裝，最後手動建庫，這樣成功的機率高。

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

這個問題是由於在安裝oracle時安裝了legato相關備份軟體而引起的，這種報錯對資料庫不會有什麼影響。

如果要使系統不產生這些資訊，可以找到/etc/rc.d/rc3.d下的對應於legato(nsr)的相應連結，將其disable掉就可以了。

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

在LEGATO Single Server Version (LSSV) 安裝及解除安裝指導書中發現 和其他沒有安裝legato軟體的相比：多了 /nsr/目錄及/etc/init.d/networker

vi    /etc/init.d/networker  

從語句中可以看出， 需要注釋掉 start 部分的語句 .   才能保證log檔案中不會報錯 . 

#!/bin/sh
# installed by poin.cln on Wed Jul 14 12:10:55 CST 2004
#
# Default locale
#
LANG=C
export LANG

# Override to a different locale if /usr/lib/nsr/LANG exist
[ -r /usr/lib/nsr/LANG ] && . /usr/lib/nsr/LANG

case $1 in
'start')
(echo 'starting LSSV daemons:') > /dev/console
if [ -f /usr/sbin/nsrexecd ]; then
       (/usr/sbin/nsrexecd) > /dev/console 2>&1
       (echo ' nsrexecd') > /dev/console
fi
if [ -f /usr/sbin/lgtolmd ]; then
       (/usr/sbin/lgtolmd -p /nsr/lic -n 1) > /dev/console 2>&1
       (echo ' lgtolmd') > /dev/console
fi
if [ -f /usr/sbin/nsrd -a ! -f /usr/sbin/NetWorker.clustersvr ]; then
       (/usr/sbin/nsrd) > /dev/console 2>&1
       (echo ' nsrd') > /dev/console
fi
       ;;
'stop')
(echo 'stopping LSSV daemons:') > /dev/console
if [ -f /usr/sbin/nsr_shutdown ]; then
       if [ -f /usr/sbin/NetWorker.clustersvr ]; then
               (/usr/sbin/nsr_shutdown -c -a -q&) > /dev/console 2>&1
               (echo ' nsr_shutdown -c -a -q') > /dev/console
       else
               (/usr/sbin/nsr_shutdown -a -q&) > /dev/console 2>&1
               (echo ' nsr_shutdown -a -q') > /dev/console
       fi
fi
       ;;
*)
echo "usage: `basename $0` {start|stop}"
       ;;
esac

當然或者關閉它的服務也可以達到目的 。

[root@dell-node1 init.d]# ./networker  stop  
[root@dell-node1 init.d]#
[root@dell-node1 init.d]# nsr_shutdown -a  
nsr_shutdown: NetWorker daemons are already down
[root@dell-node1 init.d]#