| Open-AudIT https://www.open-audit.org/phpBB3/ |
|
| Oracle instances https://www.open-audit.org/phpBB3/viewtopic.php?f=9&t=3809 |
Page 1 of 1 |
| Author: | shanimal [ Sat Oct 02, 2010 12:26 am ] |
| Post subject: | Oracle instances |
Oracle usually can't be found in the typical places windows installs are found. Do you think there is any interest in add Oracle instance discovery to OA (besides myself or course)? You can identify Oracle instances running on Windows in Services.msc because for each instance of Oracle, there is a unique oracle service installed. |
|
| Author: | shanimal [ Fri Oct 22, 2010 1:18 am ] |
| Post subject: | Re: Oracle instances |
[code]Sub OracleInstances(StrComputer) Dim objLocator, objWMI Set objLocator = CreateObject("WbemScripting.SWbemLocator") Set objWMIService = objLocator.ConnectServer(strComputer,"root\cimv2",user,pass) Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Service WHERE DisplayName LIKE 'OracleService%'") For Each objItem In colItems str = objItem.DisplayName instance = Replace(str,"OracleService","") If objItem.Started = "True" Then WScript.Echo instance & " - Started" Else WScript.Echo instance & " - Not started" End If Next End Sub[/code] |
|
| Author: | shanimal [ Sat Dec 11, 2010 12:39 am ] |
| Post subject: | Re: Oracle instances |
Is it safe to conclude that nobody else is interested in discovering Oracle databases? |
|
| Author: | Mark [ Sat Dec 11, 2010 8:13 am ] |
| Post subject: | Re: Oracle instances |
I am definitely interested in enumerating Oracle instances / databases for OAv2. I'd like to get similar data to that currently retrieved for SQL Server. MySQL is another I want to get info from, as well. What platform are your Oracle instance running on ? Are you thinking about querying them in a separate script and essentially ignoring the underlying OS ? I think that might be the best way to go... We could use the same method for other DB's as well. |
|
| Author: | shanimal [ Fri Dec 17, 2010 7:35 am ] |
| Post subject: | Re: Oracle instances |
Hi Mark- This is great news. We have some Oracle databases running on Windows and on Red Hat too. I noticed that there are a couple of 3rd party solutions to discover Oracle but overall it seems to be an oddball. Maybe it's possible to use nmap to scan an ip range and identify systems listening on port 1521 and 1523. This might work but won't help with non-standard listening ports. |
|
| Author: | Mark [ Sun Jan 02, 2011 11:27 am ] |
| Post subject: | Re: Oracle instances |
If we audit the host that Oracle is running on, we should be able to determine ports... Then it's just a matter of connecting (with appropriate credentials) and running a script to enumerate the databases. I already do this for SQL Server in OAv2. I plan to do Oracle, MySQL, Postgres and others, too... |
|
| Page 1 of 1 | All times are UTC + 10 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|