Query to find service name

This article explains the steps to find the service name of a database running on your local windows machine.

Open command prompt in your windows machine and issue below command, This should connect to your local database as SYSDBA

sqlplus / AS SYSDBA

Once you are connected to the database issue below command to see the service name of the database.

show parameter service\_name

Alternatively you can also open services in your windows machine and look for OracleSerrvice as show below

Share this blog:

Related Articles