What do you mean by enumerate a list of all SID's ? Do you want to find
out which instances are up on the server ? If that is the case, in
UNIX/Linux you can do a ps -ef (ps -efwww) and grep for "pmon"
What's in a namespace wrote:
> "What's in a namespace" <xml_at_ns.com> schreef in bericht
> news:455895cb$0$339$e4fe514c_at_news.xs4all.nl...
> >
> > "schw" <schwartz_at_alpha.net.pl> schreef in bericht
> > news:1163431566.829318.140140_at_e3g2000cwe.googlegroups.com...
> >> Hi All,
> >>
> >>
> >> apologies for trivial question...but i need help..
> >>
> >>
> >> it is possible to run few oracle databases on a single machine...
>
> Sorry, mistook this sentence for a question.
>
> how
> >> can I enumerate a list of SIDs?
> >>
> >>
> >> thanks for your help..
> >>
> >>
> >> best regards,
> >>
> >
> > As long as it is not Oracle XE, you can (depending on your memory/cpu's
> > etc). Enumerating SID's is done through TNSNAMES.ORA.
> >
> > Shakespeare
> >
Received on Mon Nov 13 2006 - 19:42:57 CST
