Oracle查看版本号

     工作当中有时候想查看一下数据库的具体版本号，这里简单整理了一下，可以通过：dba_server_registry、 dba_registry_history、product_component_version、v$version视图查看，另外还可以通过 Oracle Opatch命令查询具体的补丁版本

1、查询dba_server_registry视图

SQL> select comp_name,version from dba_server_registry;
 
COMP_NAME                                                                        VERSION
-------------------------------------------------------------------------------- --------------
Oracle Application Express                                                       3.2.0.00.27
Oracle XML Database                                                              10.2.0.4.0
Oracle Text                                                                      10.2.0.4.0
Oracle Enterprise Manager                                                        10.2.0.4.0
Oracle Workspace Manager                                                         10.2.0.4.3
Oracle Database Catalog Views                                                    10.2.0.4.0
Oracle Database Packages and Types                                               10.2.0.4.0
 
7 rows selected

2、查询dba_registry_history

 SQL> select * from dba_registry_history;
 
ACTION_TIME                       ACTION      NAMESPACE  VERSION          ID COMMENTS
-------------------------------------------------------------------------------- ------------------  
14-7月 -08 05.24.02.895660 下午   UPGRADE     SERVER      10.2.0.4.0      Upgraded from 10.2.0.3.0
 

3、查询product_component_version视图
SQL> select product,version from product_component_version;
 
PRODUCT                                            VERSION
-------------------------------------------------------------------------------- 
NLSRTL                                             10.2.0.4.0
Oracle Database 10g Enterprise Edition             10.2.0.4.0
PL/SQL                                             10.2.0.4.0
TNS for HPUX:                                      10.2.0.4.0
 4、查询v$version视图
SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE        10.2.0.4.0        Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

5、利用Opatch命令进行查看具体的补丁有哪些

 $opatch lsinventory -detail -oh $CRS_HOME
 $opatch lsinventory -detail -oh $RDBMS_HOME

使用“-help”参数可以获得opatch命令的帮助信息

     [oracle@ora OPatch]$ ./opatch -help
     Usage: opatch [ -help ] [ -r[eport] ] [ command ]
  
                command := apply
                           lsinventory
                           prereq
                           query
                           rollback
                           util
                           version
  
     := -help       Displays the help message for the command.
                           -report     Print the actions without executing.
  
     example:
       'opatch -help'
       'opatch apply -help'
       'opatch lsinventory -help'
       'opatch prereq -help'
       'opatch rollback -help'
       'opatch util -help'
     
     
     [oracle@ora OPatch]$ ./opatch lsinventory -h

     DESCRIPTION
         List the inventory for a particular $ORACLE_HOME or display all
         installations that can be found.
   
     SYNTAX
     opatch lsinventory [-all ] [-all_nodes] [-delay ] [-detail ]
                        [-invPtrLoc ] [-jre ]
                        [-oh] [-oh ] [-patch]
                        [-ptlConnect  ]
                        [-ptlPassword ]
                        [-ptlSchema ]
                        [-property_file ]
          [-retry ]
   
     OPTIONS
            -all
                   Report the name and installation directory for each
                   $ORACLE_HOME found.
   
            -all_nodes
              Reports the patches installed on the given Oracle Home
                   in all nodes of the RAC system. It also prints the oracle
                   binary's size and checksum on all nodes. This option cannot
                   be used in conjunction with -all, -detail, -patch.
   
            -delay
                   If -retry is specified, this option tells OPatch how
                   many seconds it should wait before attempting to lock
                   inventory again in case of a previous failure.
   
            -detail(s)
                   Report installed products and other details. This
                   option cannot be used in conjunction with all option.
   
            -invPtrLoc
                   Used to locate the oraInst.loc file. When the
                   installation used the invPtrLoc flag. This should be
                   the path to the oraInst.loc file
   
            -jre
                   This option tells OPatch to use JRE (java) from the
                   specified location instead of the default location
                   under Oracle Home
   
            -oh
                   The oracle home to work on. This takes precedence over
                   the environment variable ORACLE_HOME
   
            -patch
                   Lists the patch IDs installed in the oracle home
   
            -ptlConnect
                   This option is used to specify the connect string credentials
                   of the portal schema
   
            -ptlPassword
                   This option is used to specify the password of the portal
                   schema
   
            -ptlSchema
                   This option is used to specify the schema of the portal
                   repository
   
            -property_file
                   The user defined property file for OPatch to use. The
                   path to the property file should be absolute. This
                   property file takes precedence over the one that is
                   supplied with OPatch
   
            -retry
                   This option tells OPatch how many times it should
                   retry in case of an inventory lock failure       
   
     PARAMETERS
            This operation does not have any required parameters.