Viewing Metadata Repository Release Numbers

If you are using an Oracle Database instance for your metadata repository, you can view the release number of the database using SQL*Plus as follows (you can be connected to the database as any user to issue these commands):

SQL> COL PRODUCT FORMAT A40
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT                                    VERSION         STATUS
----------------------------------         --------------  ----------------
NLSRTL                                     11.2.0.1.0      Production
Oracle Database 11g Enterprise Edition     11.2.0.1.0      Production
PL/SQL                                     11.2.0.1.0      Production
TNS for Linux:                             11.2.0.1.0      Production

Leave a Reply

Your email address will not be published. Required fields are marked *