How to easily check the installed version of Oracle

How to easily check the installation version of Oracle requires specific code examples

As a software that is widely used in enterprise-level database management systems, the Oracle database has many versions and different installation methods. In our daily work, we often need to check the installed version of the Oracle database for corresponding operations and maintenance. This article will introduce how to easily check the installed version of Oracle and give specific code examples.

Method 1: Through SQL query

In the Oracle database, we can view the version information of the database by executing SQL query statements. The specific code example is as follows:

SELECT banner FROM v$version WHERE banner LIKE 'Oracle%';

The above SQL statement will display version information similar to "Oracle Database 19c Enterprise Edition". By querying the v$version view, we can obtain the installed Oracle database version and type.

Method 2: Use the command line tools provided by Oracle

Oracle also provides some command line tools that can help us check the version information of the database. One of the most commonly used tools is sqlplus. We can open sqlplus through the following command:

sqlplus / as sysdba

Then enter the following SQL statement to view the database version information:

SELECT * FROM v$version;

This will list more detailed version information, including database version, PL/SQL version, TNS protocol version, etc.

Method 3: Through Oracle Inventory

The Oracle installer usually creates a directory named Oracle Inventory in the installation directory, which stores information about installed components. We can obtain the database version by viewing the installation information in the Inventory directory.

In Linux systems, Oracle Inventory is usually located in the path specified in /var/opt/oracle/oraInst.loc. By looking at the inventory.xml file in this path, we can find the version information of the database.

To sum up, through SQL queries, command line tools and Oracle Inventory, we can easily check the installed version of the Oracle database. Different methods provide different levels of detailed information. It will be more convenient and faster to choose the method that suits your needs to view version information. Hope the above content is helpful to you.

The above is the detailed content of How to easily check the installed version of Oracle. For more information, please follow other related articles on the PHP Chinese website!