Re: How can I find how many instances in a server

From: Robert Miller <rwmiller_at_gte.net>
Date: 1997/05/06
Message-ID: <5ko271$71a$2@news5.gte.net>#1/1

in unix, the easies way is to check the /etc/oratab file. Each instance should be listed here and whether or not it is auto started upon boot.

It may have been moved if the unix .profile (ksh) or .login has an environment variable TNS_ADMIN set to another path. typically if used, will point to $ORACLE_HOME/network/admin.

-- 


Robt



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

Robert Miller         
Oracle DBA  

robt.miller_at_airmail.net
(214) 532.6558



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

Any opinions expressed are my own and do not necessarily
represent any employer.

Received on Tue May 06 1997 - 00:00:00 CDT