Re: Ghost database

From: Niall Litchfield <>
Date: Mon, 14 Nov 2011 18:04:36 +0000
Message-ID: <>

Hi Bob
I haven't got an 11g agent to look at, but I do have a 10g agent and an 11.2 dbconsole install. Both of these discover database (and ASM) entries from HKLM\SYSTEM\\CurrentControlSet\\Services on windows via the %AGENT_HOME%\sysman\admin\discover\utl\ perl script.I imagine that the same will be true for your case.

The bit of vbscript below should hopefully also return your ghost sid. save as a .vbs file in a c:\scripts on the server and run from the command line. You'll get an oratab like text file in the same directory called listhomes.txt.

' VBScript source code
Const ForAppending = 8
Set FSO = CreateObject("Scripting.FileSystemObject") Set LogFile = FSO.OpenTextFile("c:\scripts\listhomes.txt", _

    ForAppending, True)

strComputer = "."


sub ListOracleHomes

	' write header
	LogFile.Write ("SID,ORACLE_HOME")
	strQuery = "Select * from Win32_Service where DisplayName like
	' get list of services
	Set OraServices = GetObject("winmgmts:\\" & strComputer).ExecQuery(strQuery)	
	For each s in OraServices
		LogFile.Write(mid(s.PathName,instr(1,s.PathName," ")+1))
		LogFile.Write(left(s.PathName,instr(1,s.PathName,"bin") - 1))

end sub

On Mon, Nov 14, 2011 at 4:23 PM, Storey, Robert (DCSO) <> wrote:

> Opened a SR with Oracle on this one. Their first response was to send
> back the discovery process steps that are listed in the docs, which I"ve
> already gone through.
> This is on a Windows 2003 server. There are no registry keys associated
> to the database. I checked the inventory.xml file in the oracle\inventory
> path and no mention of the database in question.
> I did a registry search and a file system search for the database name and
> found nothing.
> Yet, the Agent11g discovery STILL finds this old deleted database.
> Anyone got any other ideas of where this information might be hiding that
> the agent is finding?
> Thanks
> -----Original Message-----
> From: []
> On Behalf Of Storey, Robert (DCSO)
> Sent: Friday, November 11, 2011 8:51 AM
> To: ''
> Subject: Ghost database
> So, I have finally gotten 11g Grid control configured (thank you Chris!).
> Been playing with it for a few days, looking under the hood, etc.
> I installed an agent on a small test box I have been using prior to 11g
> Grid. I have 11gr2 installed on that in the default home. I messed up a
> database on the test box and ended up blowing it away using DBCA.
> But, the agent reported to GC that the database exists and GC is showing
> it in an unknown state.
> Where would the remote agent be obtaining this information for this now
> ghost database? Inventory was my first clue, but not finding it.
> Any ideas?
> Thanks
> Bob
> --
> --

Niall Litchfield
Oracle DBA

Received on Mon Nov 14 2011 - 12:04:36 CST

Original text of this message