JServer Release 版本不一致

Mille

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.1.0 - Production

dba_registry下是9.2.0.8.0

JAVAVM     JServer JAVA Virtual Machine 9.2.0.8.0     VALID     19-OCT-2010 15:53:29     SYS     SYS

sqlplus "/as sysdba"  时看到的JServer Release 版本与实际不一致
怎么回事？？？

Maclean Liu(刘相兵

1、 没有说你的平台

2、
su  -  oracle
echo $ORACLE_HOME
echo $LD_LIBRARY_PATH
echo  $SHLIB_PATH

Mille

aix 5.3.0.0
echo $ORACLE_HOME
/oracle/ora92
echo $LD_LIBRARY_PATH
/oracle/ora92/lib64:/oracle/ora92/lib:/usr/lib:/lib:/usr/ccs/lib:/usr/java/lib
echo  $SHLIB_PATH
/oracle/ora92/lib:/usr/lib:/lib:/usr/ccs/lib

Mille

Maclean Liu(刘相兵 发表于 2013-9-5 14:27
1、 没有说你的平台

2、

aix 5.3.0.0
echo $ORACLE_HOME
/oracle/ora92
echo $LD_LIBRARY_PATH
/oracle/ora92/lib64:/oracle/ora92/lib:/usr/lib:/lib:/usr/ccs/lib:/usr/java/lib
echo  $SHLIB_PATH
/oracle/ora92/lib:/usr/lib:/lib:/usr/ccs/lib

Maclean Liu(刘相兵

ODM FINDING:
JServer Version is Displayed Incorrectly In SQL*Plus Banner

A SQL*Plus connection normally shows the JServer Release version in the banner output. For example:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.6.0 - Production
Notice that the JServer release is not correct. It does not match up to the version of database to which you are connecting. For example:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.6.0 - Production
Note that the Enterprise Edition is 9.2.0.5.0 and the JServer Release is 9.2.0.6.0.
CAUSE
The following scenario can cause this anomaly:
A 9.2.0.6 version listener in one ORACLE_HOME that is configured to listen for a 9.2.0.5 instance in another home. LD_LIBRARY_PATH or SHLIB_PATH
in the listener's environment is set to include a pointer to the 9.2.0.6 $ORACLE_HOME/lib directory. This is where the erroneous JServer release
information is originating.
SOLUTION
Configure the environment so that it does not include an $LD_LIBRARY_PATH or a $SHLIB_PATH pointer to $ORACLE_HOME/lib. Restart the listener with this new profile. SQL*Plus
connections that are made via the listener will now show the correct JServer Release information.

Maclean Liu(刘相兵

我觉得如果你确认 register Jserver是9.2.0.8 的话可以忽略该问题，因为 sqlplus 应当是通过一些共享库文件 了解组件情况的。

此外如果你的系统如果不用JVM的话 完全可以忽略该问题