How to check the installed oracle version

How to check the installed Oracle version: 1. Use the SQL*Plus command line tool, open the command line window, enter "SQL> SELECT * FROM V$VERSION"; 2. Use Oracle Enterprise Manager for A graphical tool for managing Oracle database; 3. View the files in the Oracle installation directory and obtain version information by viewing the contents of these files.

The operating environment of this tutorial: Windows 10 system, Oracle version 19c, DELL G3 computer.

To check the installed Oracle version, you can use the following methods:

1. Use the command line tool: In the command line, you can use the sqlplus tool to connect to the Oracle database and execute the following query statement to view the version information:

SQL> SELECT * FROM V$VERSION;

This will Returns a result set containing Oracle database version information, including the Oracle database version number, release date, etc.

2. Use Oracle Enterprise Manager: Oracle Enterprise Manager is a graphical tool for managing Oracle databases. Through Oracle Enterprise Manager, you can easily view the version information of the database. Generally, Oracle Enterprise Manager can be opened by accessing the following URL in a web browser:

https://:/em

Among them, is the host name or IP address of the database server, is the port number of Oracle Enterprise Manager. In Oracle Enterprise Manager, you can find detailed reports on version information, including database version, patch level, etc.

3. View the files in the Oracle installation directory: The Oracle database installation directory contains some files used to identify version information. Version information can be obtained by viewing the contents of these files. The following are some common files containing version information:

oracle_home\inventory\ContentsXML\oraclehomeproperties.xml: This file contains some property information of the Oracle installation, including the version number. oracle_home\install\oraparam.ini: This file contains some parameter information during the Oracle installation process, including the version number.

Open these files and look for the version number to quickly determine the version information of the Oracle database.

No matter which method is used, viewing Oracle version information is relatively simple. Select the appropriate method according to the specific situation to easily obtain the required version information.

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