How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)

We can find oracle service name with two method. TNS information is required to connect to Oracle.

In the service_name parameter in the TNS information, we need to specify the service name of ORACLE.

You can learn Oracle service_name with the following two methods.

Method 1:

Find Oracle Database Service Name From sqlplus

After connecting to the oracle database with Toad or SQLplus, you can learn by running the following query.

Method 2:

Find Oracle Database Service Name From TOAD

After connecting to Toad, we access Oracle Parameters with the tabs you see below.

Then, as you see below, we write service in the filter section. You can see the oracle service_name information in Value.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *