Re: DATABASE IDENTIFICATION

Tobias Svennebring wrote:
> I wonder if someone could tell me special signs that makes it possible to
> decide
> * what kind of database that is running on a certain server,

  If the database is Oracle, in most of the cases, there is an user called oracle and there is a group called dba in most of the cases. I claim that it is most of cases because they can rename them. Anyway, it leads to a relink procedure.

  If the server is personl oracle7, you can detect it from the GUI interface.

> * if there is an database there at all

  There are at least four processes named *dbwr*, *lgwr*, *pmon*, *smon* when the databases are up. * is the wildcard because the naming convention is operating system dependent.

> * and what version it is?

  You can check the version for Oracle by using select * from production_component_version. Alternatively, you can check it from the banner of SQL*Pls.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841