Query to find service name

Thursday, March 29, 2018

Query to find service name

This 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


Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage