Pau Lo
asked on
Oracle discovery
Are there any tools that will do a discovery of all roacle databases in your network, regardless of the OS they are installed on? Our admins have provided a list that seems very out of date, i just wondered how such a list could be compiled?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There might be other ways other Experts can think of but off the top of my head here is what I have.
You can look for Oracle Software installs. Once found look in common database folders like dbs (Unix) or database (Windows) for config files like the spfile or init configuration files. This will tell you that a database existed at one time but not the current status of it.
You can look at services or running processes to see what is running at that specific moment. This won't show databases that are down (although Windows Services will show what databases are available to be started).
You can look for Oracle Software installs. Once found look in common database folders like dbs (Unix) or database (Windows) for config files like the spfile or init configuration files. This will tell you that a database existed at one time but not the current status of it.
You can look at services or running processes to see what is running at that specific moment. This won't show databases that are down (although Windows Services will show what databases are available to be started).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i use something like this to list the databases i manage
in servers.txt file i add the names of all the servers i'm interested in :
this script checks every servername and lists all the databases (services) per server in file databases.txt
in servers.txt file i add the names of all the servers i'm interested in :
ORASRVTST01
ORASRVTST02
ORASRVPRD01
this script checks every servername and lists all the databases (services) per server in file databases.txt
set serverfile=servers.txt
set dbfile=databases.txt
echo.List of databases per server >%dbfile%
for /f %%G in (%serverfile%) do (
echo.Databases on server "%%G">>%dbfile%
sc \\%%G query|findstr /C:"DISPLAY_NAME: OracleService">>%dbfile%
echo.---------------->>%dbfile%
)
pause
ASKER
The oracle databases are installed on either windows server or AIX IBM.