故障现象: $ sqlplus / as sysdba SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly 分析:网上都说是timezone和timezlrg文件的权限不正确,可我压根没这两个文件了, 怎么办,且看如下分析
--看看timezone和timezlrg文件是否正常 $ cd /home/oracle/database/oracore/zoneinfo $ ls -lt 总计 16 -rw-r--r-- 1 oracle dba 4672 6月01 2006 readme.txt --竟缺失了,马上想到去RAC的另外一个节点取文件过来
--FTP连过去 $ ftp 192.168.1.56 连接至 192.168.1.56。 220 p550b FTP server (Version 4.2 Tue Nov 14 12:49:19 CST 2006) ready. 名称(192.168.1.56:root):root 331 Password required for root. 密码: 230-Last unsuccessful login: Thu Dec 30 10:43:55 BEIST 2010 on /dev/pts/4 from 192.168.180.27 230-Last login: Fri Apr 1 09:27:15 BEIST 2011 on /dev/pts/1 from 192.168.180.29 230 User root logged in.
--进入到远程主机相应目录 ftp> cd /home/oracle/database/oracore/zoneinfo 250 CWD command successful. ftp> pwd 257 "/home/oracle/database/oracore/zoneinfo" is current directory. ftp> get *.dat
--FTP怎么会不支持模糊,先输入详细名称完成任务吧 200 PORT command successful. 550 *.dat: No such file or directory ftp> ls -lt 200 PORT command successful. 150 Opening data connection for /bin/ls. total 1128 -rw-r--r-- 1 oracle dba 404884 Jan 11 2007 timezlrg.dat -rw-r--r-- 1 oracle dba 161123 Jan 11 2007 timezone.dat -rw-r--r-- 1 oracle dba 4672 Jun 01 2006 readme.txt 226 Transfer complete.
--FTP获取远程文件 ftp> get timezlrg.dat 200 PORT command successful. 150 Opening data connection for timezlrg.dat (404884 bytes). 226 Transfer complete. 在 2.03e-318 秒内接收到 4589539693338558464 字节(5930 千字节/秒) 本地:timezlrg.dat 远程:timezlrg.dat ftp> get timezone.dat 200 PORT command successful. 150 Opening data connection for timezone.dat (161123 bytes). 226 Transfer complete. 在 8.091e-319 秒内接收到 4580058787645227008 字节(1.035e+04 千字节/秒) 本地:timezone.dat 远程:timezone.dat
--文件传输成功,说再见 ftp> bye 221 Goodbye. $ pwd /home/oracle/database/oracore/zoneinfo $ ls -lt 总计 1128 -rw-r--r-- 1 oracle dba 161123 4月01 09时44 timezone.dat -rw-r--r-- 1 oracle dba 404884 4月01 09时44 timezlrg.dat -rw-r--r-- 1 oracle dba 4672 6月01 2006 readme.txt
--尝试登录 $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Fri Apr 1 09:45:20 2011 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options --参试执行SQL语句,成功 SQL> select count(*) from v$session; COUNT(*) ---------- 321