执行sqlplus时提示SP2-1503、SP2-0152的错误
$ sqlplus /nolog
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
在
$ORACLE_HOME目录下检查发现没有oracore目录,在另外一套环境发现有oracore目录,直接将该目录拷贝过来后重新执行sqlplus命令,错误解决。
处理过程参考MOS文章:
SQL*Plus Returns SP2-1503 SP2-0152 After Manually Applying The DST2007 Patch (文档 ID 416497.1)
1. Use the 'fuser' command to ensure that the current time zone files are not being used before replacing them:
% cd $ORACLE_HOME/oracore/zoneinfo
% fuser *.dat
2. If the files are not being used, rename the current time zone files (as a backup)
3. Copy the new time zone files to the $ORACLE_HOME/oracore/zoneinfo directory