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