Originally Posted by xmdms
I am not sure if this is the forum for this question, but what the heck, I am a newbie anyway.
Here's my question; Would anyone know how to calculate the current Oracle database from the OS level if I do have the ASM disks info??
We have only one DBA onsite, but he's on vacation for 2 weeks.
Please help if you know the answer.
Thank you in advance.
if you want to know how many oracle database are running in that machine then use the command
ps -ef | grep pmon..
if you want to know about the listener ,use
ps -ef | grep tns
if you want to know the size of the database, which can be checked at oracle level using dba_data_files,dba_temp_files,v$controlfile,V$logfile. combine all this ,write a query and get the output..
is this what you want ?.. let us know