How to read oracle instance name

Check the Oracle instance name through the following steps: 1. Use SQL*Plus to connect to Oracle; 2. Run the query: SELECT INSTANCE_NAME FROM V$INSTANCE; 3. The query results will display the name of the current instance.

How to check the Oracle instance name

Step 1: Open the command prompt

• Windows: Press the "Windows" key "R" on your keyboard, and then enter "cmd" in the "Run" dialog box.
• Mac/Linux: Open a terminal window.

Step 2: Connect to Oracle using SQL*Plus

• In the command prompt, enter the following command:

sqlplus username/password

Where:

• usernameis your Oracle username.
• passwordis your Oracle password.

Step 3: Run the query

• After connecting, run the following query:

SELECT INSTANCE_NAME FROM V$INSTANCE;

Steps 4: View the results

• The query results will display the name of the current instance.

Example:

SQL> SELECT INSTANCE_NAME FROM V$INSTANCE; INSTANCE_NAME --------------- orcl

In this example, the instance name is "orcl".

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