查看oracle版本及补丁,查看oracle版本和补丁

1、查看oracle版本

sqlplus nolog

conn sys/oracle as sysdba

SQL> select * from product_component_version;

PRODUCT

——————————————————————————–

VERSION

——————————————————————————–

STATUS

——————————————————————————–

NLSRTL

11.2.0.3.0

Production

Oracle Database 11g Enterprise Edition

11.2.0.3.0

64bit Production

PRODUCT

——————————————————————————–

VERSION

——————————————————————————–

STATUS

——————————————————————————–

PL/SQL

11.2.0.3.0

Production

TNS for Linux:

11.2.0.3.0

PRODUCT

——————————————————————————–

VERSION

——————————————————————————–

STATUS

——————————————————————————–

Production

2、查看oracle打过的补丁

echo $ORACLE_HOME

/usr/local/oracle/orac