Re: 2 instances looking at the same database

I'm not sure that Oracle classes as fun, hmmmmm.

Thanks for your help.

"rob" <rob_at_dsdelft.nl> wrote in message news:9h84h8$6vf$1_at_news.tudelft.nl...
>
> > Ya beauty. This is exactly the answer I was looking for. Now that you
 have
> > spelt it out for me, I realise that perhaps with enough lateral thinking
 I
> > could have worked this out myself. Sometimes you get too close to the
> > problem and go off on a tangent.
>
> SQL*Net basics are really simple once you understand them ;-)
>
> > On a final note, is it possible to rename an instance ? Is it as simple
 as
> > changing the oratab, init{SID}.ora ( and contents ) ?
>
> It may not be complete, but it's something like this:
>
> shutdown database
>
> copy init<oldsid>.ora to init<newsid>.ora. Don't think it needs any
 editing.
> Remember : the database name doesn't change only the SID.
>
> edit oratab, .profile, tnsnames.ora
>
> export ORACLE_SID=<newsid>
>
> startup the database
> select * from v$database; gives you the database name
> select * from v$thread; gives you the sid
>
> change listener.ora
> reload listener
>
> Have fun,
> Rob.
>
>
Received on Mon Jun 25 2001 - 23:33:09 CEST