Where can I find the instance name of Oracle database?

How to view the Oracle database instance name: SQL*Plus: execute the query "SELECT INSTANCE_NAME FROM V$INSTANCE;" Operating system command: Linux and macOS: "ps -ef | grep ora_pmon | grep -v grep | awk '{print $NF}'" Windows: No method to view the Oracle database instance name is provided yet

# The method to obtain the Oracle database instance name is as follows:

1. Use SQL*Plus

<code class="sql">SELECT INSTANCE_NAME FROM V$INSTANCE;</code>

2. Use the operating system command

Linux and macOS:

<code class="bash">ps -ef | grep ora_pmon | grep -v grep | awk '{print $NF}'</code>

Windows:

The above is the detailed content of Where can I find the instance name of Oracle database?. For more information, please follow other related articles on the PHP Chinese website!