Query to find service name

  • Home
  • /
  • Query to find service name
Query to find service name

Query to find service name

Oracle 29 Mar 2018

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
post thumb

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

show parameter service\_name
post thumb

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

post thumb
Share: