Re: Discovering SID on Novell

Rod Thorell wrote:
>
> I have an Oracle 7.0 database running on Novell 3.12, and want to
> implement hot backups. In order to connect, the backup agent needs the
> SID. Unfortunately this database was not created by me and we do not
> have any documentation on what SID was used at creation. I know how to
> get to this info on my VMS and NT databases, so I have looked around on
> both client and server. Does the SID actually exist anywhere I can get
> it? Thanks in advance.
> scrod_at_adelphia.net

well...SID is contained in TNSNAMES.ORA definition of every remote client connected using tcp/ip or other similar protocols !! You can also find it in Listener.ora in host. Look it up !

John Koo
johnkoo_at_i-wave.net Received on Sun Jan 17 1999 - 19:58:09 CST