Find out started Oracle databases in Windows using command line
June 16, 2016 Leave a comment
One of the simplest way to find what databases are started in Windows is to see all started processes and filter them by keyword oracle.
By net start command you will see all started services:
H:\>net start These Windows services are started: Apache Tomcat 6.0-1 Application Experience Lookup Service COM+ Event System COM+ System Application Computer Browser Cryptographic Services DCOM Server Process Launcher DHCP Client Distributed Link Tracking Client Distributed Transaction Coordinator DNS Client Event Log Help and Support IPSEC Services Java Quick Starter Logical Disk Manager Machine Debug Manager ManageEngine EventLogAnalyzer 9 - Agent Net Logon NetBackup Client Service NetBackup Legacy Client Service NetBackup Legacy Network Service Network Connections Network Location Awareness (NLA) OracleOraDb10g_home1ClrAgent OracleOraDb10g_home1iSQL*Plus OracleOraDb10g_home1TNSListener OracleServiceORATEST10G Plug and Play Print Spooler Protected Storage Remote Procedure Call (RPC) Remote Registry Secondary Logon Security Accounts Manager Server Shell Hardware Detection Symantec Endpoint Protection Symantec Event Manager Symantec Management Client Symantec Private Branch Exchange Symantec Settings Manager System Event Notification Task Scheduler TCP/IP NetBIOS Helper Terminal Services VMware Physical Disk Helper Service VMware Tools Service VMware Upgrade Helper VNC Server Version 4 Windows Management Instrumentation Windows Time Wireless Configuration Workstation The command completed successfully.
To filter the output use | <–pipe and then command findstr which has option /I <–case insensitive to search keyword oracle :
H:\>net start|findstr /I "oracle" OracleOraDb10g_home1ClrAgent OracleOraDb10g_home1iSQL*Plus OracleOraDb10g_home1TNSListener OracleServiceORATEST10G
From here you should guess that database sid that is started is ORATEST10G