How to check database instance name in oracle

How to query the Oracle database instance name: Use SQL*Plus to connect and run the query: select name from v$instance; Navigate to "Database Instance" through Oracle Enterprise Manager (OEM) and view "Properties"; Check the environment Variable: %ORACLE_SID% in Windows, $ORACLE_SID in Linux/Unix.

How to query the Oracle database instance name

Method 1: Use SQL*Plus

1. Connect to Oracle database:

   sqlplus / as sysdba

   Copy after login

2. Execute the following query:

   select name from v$instance;

   Copy after login

Method Two: Use Oracle Enterprise Manager (OEM)

1. to log in to the OEM console.
2. In the left navigation bar, expand the "Database" node.
3. In the "Database Instance" list, find and select the database instance you want to query.
4. In the right panel, look for the Properties section, where the instance name will appear.

Method 3: Check environment variables

For Windows systems:

echo %ORACLE_SID%

For Linux/Unix systems:

echo $ORACLE_SID

The difference between instance name and SID

The instance name and SID are usually the same, but sometimes they may be different. The instance name is the human-readable name of the Oracle server instance, and the SID is the system identifier of the Oracle database itself.

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