Content Preview: rss
17 days ago
如果lsnr挂起（tnsping失败），则杀掉进程重启lsnr 如果lsnr被手动关闭（tns进程不在），不会进行任何操作。 echo `date` echo 'The old LSNR id is:'`ps -ef grep tnslsnr grep -v grep awk '{print $2}'` RVALUE=`tnsping npmserver grep OK awk '{print $1}' wc -l` echo 'OK found:' $RVALUE if [ $RVALUE != 0 ] then echo 'LSNR work fine! bye' fi if [ $RVALUE = 0 ] then TNSCOUNT=`ps -ef grep tnslsnr grep -v grep wc -l` if [ $TNSCOUNT != 0 ] then echo 'Kill the old LSNR process,starting LSNR...' ps -ef grep tnslsnr grep -v grep awk '{print $2}' xargs kill -9 lsnrctl start echo 'The new LSNR id is:' `ps -ef grep tnslsnr grep -v grep awk '{print $2}'` fi if [ $TNSCOUNT = 0 ] then echo 'LSNR not running,try lsnrctl start if needed!' fi fi echo '########################################' echo
108 days ago
客户启用了selinux，配置vsftp失败，错误如下 C:\Documents and Settings\Administrator>ftp 218.62.70.104 Connected to 218.62.70.104. 220 Welcome to blah FTP service. User (218.62.70.104:(none)): oracle 331 Please specify the password. Password: 500 OOPS: could not open chroot() list file:/etc/vsftpd/chroot_list 500 OOPS: priv_sock_get_result Connection closed by remote host. 其实很简单，chroot_list这个文件不存在，执行touch /etc/vsftpd/chroot_list就可以了。 但做完之后错误变成了这个： C:\Documents and Settings\Administrator>ftp 218.62.70.104 Connected to 218.62.70.104. 220 Welcome to blah FTP service. User (218.62.70.104:(none)): oracle 331 Please specify the password. Password: 500 OOPS: cannot change directory:/home/oracle 500 OOPS: child died Connection closed by remote host. 都是讨厌的selinux惹得祸，执行如下操作即可： [root@dbserver vsftpd]# setsebool ftpd_disable_trans 1 [root@dbserver vsftpd]# service vsftpd restart 之后发现vnc也不好用，干脆关掉selinux算了 修改/etc/selinux/config ...
122 days ago
RHEL5.2 64bit+Oracle 10.2.0.1 执行runInstaller时报错： Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-12-21_10-40-21PM/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1477) at java.lang.Runtime.loadLibrary0(Runtime.java:788) at java.lang.System.loadLibrary(System.java:834) at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50) at java.security.AccessController.doPrivileged(Native Method) at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38) at sun.awt.DebugHelper.<clinit>(DebugHelper.java:29) at java.awt.Component.<clinit>(Component.java:506) at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:593) metalink上说，安装libXp这个包就ok了。 ...
161 days ago
hpux+10.2.0.4RAC 数据库挂起 alert日志如下： Thu Jun 18 03:28:17 2009 Thread 2 advanced to log sequence 3758 (LGWR switch) Current log# 5 seq# 3758 mem# 0: /dev/vg6_dss_data03/rredo212 Current log# 5 seq# 3758 mem# 1: /dev/vg6_dss_data04/rredo222 Thu Jun 18 09:19:25 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:20:27 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:21:30 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:22:59 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:24:01 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:25:03 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:26:06 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:27:09 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:28:12 2009 PMON failed to acquire latch, see PMON dump Thu Jun 18 09:36:39 2009 Errors in file /oracle/app/oracle/admin/jldw/bdump/jldw2_q000_5811.trc: ORA-00018: 超出最大会话数 Thu Jun ...
